[ensembl-dev] zfin,hgnc,flyubase etc

Koray Kaya koray at gmx.co.uk
Fri Dec 17 14:59:33 GMT 2010


Why cant I fetch gene SYMBOLS THROUGH GENE_ID of gene table AS ENSEMBL_ID OF object_xref from xref with a defined external db_id? where do i do wrong? none of the entries from object_xref is gene 
mysql> select * from gene_stable_id where stable_id='ENSDARG00000028148';
+---------+--------------------+---------+---------------------+---------------------+
 gene_id stable_id version created_date modified_date 
+---------+--------------------+---------+---------------------+---------------------+
 10181 ENSDARG00000028148 7 2009-03-12 11:42:02 2010-09-03 20:47:26 
+---------+--------------------+---------+---------------------+---------------------+
1 row in set (0.29 sec)

mysql> select * from object_xref where ensembl_id=1081;
+----------------+------------+---------------------+---------+--------------------+-------------+
 object_xref_id ensembl_id ensembl_object_type xref_id linkage_annotation analysis_id 
+----------------+------------+---------------------+---------+--------------------+-------------+
 201019 1081 Translation 69815 NULL 224 
 708474 1081 Translation 415014 NULL 224 
 837750 1081 Translation 415118 NULL 224 
 837768 1081 Translation 415289 NULL 224 
 837760 1081 Translation 415952 NULL 224 
 837769 1081 Translation 419359 NULL 224 
 837771 1081 Translation 419360 NULL 224 
 708475 1081 Translation 419361 NULL 224 
 837752 1081 Translation 419362 NULL 224 
 837770 1081 Translation 419365 NULL 224 
 837772 1081 Translation 419366 NULL 224 
 708476 1081 Translation 419378 NULL 224 
 837753 1081 Translation 419405 NULL 224 
 35151 1081 Transcript 95074 NULL 207 
 201018 1081 Translation 121946 NULL 224 
 86786 1081 Transcript 362937 NULL 207 
 201020 1081 Translation 69816 NULL 224 
 35152 1081 Transcript 390352 NULL 207 
+----------------+------------+---------------------+---------+--------------------+-------------+
18 rows in set (0.27 sec)
which entry should be sent to xref to get the ZFIN ID with external_db_id=2510? Confused... But the webpage works well..
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20101217/64438c9d/attachment.html>


More information about the Dev mailing list