dna_homol in sequence class

Article View: bionet.software.acedb

Article #171

Back to bionet.software.acedb Previous Next

#171

From: Richard Adams
Date: Fri, 30 Aug 2002 08:36

46 lines
3124 bytes

Hello,

I'm trying to get the genomic sequence coordinates for the start/finish
of DNA homology matches to particular BACS in our in-house Ace database.

My AQL query is


 select a, a[4], a[5] from a in object ("sequence",
"Em:AC104662")->DNA_homol where a = "Mm_A:contig_66209"

where a[4] is the start coord and a[5] the end coord. But, for a
sequence (say a cDNA ) with multiple matches, this doesn't return say

name    23    345
name  567    789
name 1024    4567

which is what I would like,  instead it returns

name 23 345
name 23 789
name23 4567
name 567 345
name 567 789
name 567 4567
name 1024    345
name 567 789
name 1024    4567

Can anyone help me on this? If there is just a single match this query
works fine. Likewise if I just ask for a[4] or a[5] I get just three
rows returned.  In the data model there doesn't appear to be any nested
data structure
for multiple matches but as I 'm a bit new to all this there may be a
totally obvious answer, in which case my apologies.

Thank you for your time,


Dr Richard Adams
Molecular Medicine Centre
University of Edinburgh
richard.adams@ed.ac.uk

---

Technical Details

Message-ID: <3D6E4744.1BB7FDAE@ed.ac.uk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,cb94fb572274d3ca,start
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 2002-08-30 01:36:15 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net
From: Richard.Adams@ed.ac.uk (Richard Adams)
Newsgroups: bionet.software.acedb
Subject: dna_homol in sequence class
Date: 30 Aug 2002 09:36:13 +0100
Organization: Department of Medical Sciences, Edinburgh University
Lines: 47
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <3D6E4744.1BB7FDAE@ed.ac.uk>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: niobium.hgmp.mrc.ac.uk 1030696574 29489 193.62.192.80 (30 Aug 2002 08:36:14 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Fri, 30 Aug 2002 08:36:14 +0000 (UTC)
X-Received: from localhost (localhost [127.0.0.1])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 41FBE17B20
 for <acedb@hgmp.mrc.ac.uk>; Thu, 29 Aug 2002 17:09:43 +0100 (BST)
X-Received: from lawnmarket.ucs.ed.ac.uk (lawnmarket.ucs.ed.ac.uk [129.215.166.63])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 56A4717AE6
 for <acedb@net.bio.net>; Thu, 29 Aug 2002 17:09:41 +0100 (BST)
X-Received: from ed.ac.uk (culcreuch.hgu.ed.ac.uk [129.215.189.187])
 by lawnmarket.ucs.ed.ac.uk (8.11.6/8.11.6) with ESMTP id g7TG9ei19763
 for <acedb@net.bio.net>; Thu, 29 Aug 2002 17:09:40 +0100 (BST)
X-Accept-Language: en
X-To: acedb@net.bio.net
X-Razor-id: 483ed4488b964349f7564bed153d61ec2939256b
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAPW8ue6CIqsWvyF5FAQGXcAP/R2sfdoiUZwf5L6tXsvcp8exfNwfdJERS
 Nhk0d3keDN5J+bT+0iDjmq9x8+coIjpikxegt5QNfAx8wBifmebWaohPRkJFDdwJ
 xPXdgfye1AxgN8wOo7id4PgCO4GNnIU1Xp0O6svBH+bDFlpNIJfqT6zvD8zudWa3
 PWpWMYeQFsw=
 =0GPE