[Biojava-l] Ensembl-Locuslink

[Ewan Birney]

On Thu, 3 Jan 2002, Stein Aerts wrote:

> Hello,
> 
> does anyone know how to get an ensembl gene id out of the Ensembl database
> (kaka.sanger.ac.uk) starting from a list of locuslink id?

use the Xref tables. Here goes ....


mysql> select o.ensembl_id,o.ensembl_object_type from objectXref o,Xref x
where x.externalDBId = 7 and x.dbprimary_id = 80090 and o.xrefId =
x.xrefId;
+------------+---------------------+
| ensembl_id | ensembl_object_type |
+------------+---------------------+
| 19343      | Translation         |
+------------+---------------------+
1 row in set (6.88 sec)



19343 is now the internal id to the translation table which you can now
take into the transcript and therefore the gene tables




> 
> Thanks a lot,
> 
> Stein Aerts
> ESAT-SCD, KULeuven, Belgium
> http://www.esat.kuleuven.ac.be/~dna/BioI/
> 

-----------------------------------------------------------------
Ewan Birney. Mobile: +44 (0)7970 151230, Work: +44 1223 494420
<birney@ebi.ac.uk>. 
-----------------------------------------------------------------