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 <[EMAIL PROTECTED]>. ----------------------------------------------------------------- _______________________________________________ Biojava-l mailing list - [EMAIL PROTECTED] http://biojava.org/mailman/listinfo/biojava-l
