[ensembl-dev] SQL query to retrieve gene sequence...

[Steve Moss]

Dear EnsEMBL Dev,

I'm trying to write a raw SQL query to retrieve the sequence for the human
BRCA2 gene to compare different methods of accessing EnsEMBL data. I'm
currently doing the following, but getting an empty set.

SELECT SUBSTRING(sequence, g.seq_region_start, g.seq_region_end)
FROM dna d
JOIN gene g
ON d.seq_region_id = g.seq_region_id
WHERE g.stable_id="ENSG00000139618"

What am I missing? I think I'm falling short on working out the coord.
system mapping stuff. Any pointers to help in fixing please?

Cheers,

Steve

-- 

Steve Moss
about.me/gawbul
[image: Steve Moss on about.me]
  <http://about.me/gawbul>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20141216/231af2f7/attachment.html>