[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