[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