[ensembl-dev] Could not retrieve the sequence of a gene

[jtang at mappi.helsinki.fi]

Hi,
I tried to retrieve the actual sequence of the gene BRCA1 using SQL as:


use homo_sapiens_core_65_37;
select seq_region_id
from xref
join gene on xref_id=display_xref_id
join seq_region using (seq_region_id)
where display_label="BRCA1";

And the output is seq_region_id=27509, then retrieve with the id as:

select * from dna where seq_region_id=27509

But it returns empty result.


Is there something wrong with my query?

Thanks!

Best,
Jing