[ensembl-dev] mysql
Koray Doğan Kaya
kkaya at bilkent.edu.tr
Thu Dec 2 09:46:10 GMT 2010
Hi folk,
I tried mysql
mysql> select * from xref where external_db_id=3102 limit 5;
+---------+----------------+---------------+---------------+---------+-------------+-----------+--------------------------+
| xref_id | external_db_id | dbprimary_acc | display_label | version |
description | info_type | info_text |
+---------+----------------+---------------+---------------+---------+-------------+-----------+--------------------------+
| 2304380 | 3102 | 216412_x_at | 216412_x_at | 1 |
NULL | MISC | probeset_size 11 hits 6 |
| 2304439 | 3102 | 206171_at | 206171_at | 1 |
NULL | MISC | probeset_size 11 hits 11 |
| 2304559 | 3102 | 214226_at | 214226_at | 1 |
NULL | MISC | probeset_size 11 hits 10 |
| 2304368 | 3102 | 212997_s_at | 212997_s_at | 1 |
NULL | MISC | probeset_size 11 hits 6 |
| 2304361 | 3102 | 208488_s_at | 208488_s_at | 1 |
NULL | MISC | probeset_size 11 hits 8 |
+---------+----------------+---------------+---------------+---------+-------------+-----------+--------------------------+
How can i combine xref_id to transcript_d?
This did not work for example:
mysql> select gene_id from transcript where display_xref_id=2304439;
Empty set (0.08 sec)
--
M.Sc. Koray Dogan Kaya
PhD Candidate
Bilkent University,
Department of Molecular Biology and Genetics
06800 / Ankara
Turkey
Mobile: (+90) 533 526 09 51
Office: (+90) 312 290 24 03
e-mail: kkaya at bilkent.edu.tr
More information about the Dev
mailing list