<span style='font-family:Verdana'><span style='font-size:12px'><meta content="text/html; charset=utf-8" http-equiv="content-type" />
<pre style="font-family: monospace; font-size: 8pt; ">
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">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
</span></pre>
<div>
<pre style="font-family: monospace; font-size: 8pt; ">
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">mysql> select * from gene_stable_id where stable_id='ENSDARG00000028148';</span></pre>
</div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+---------+--------------------+---------+---------------------+---------------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> gene_id stable_id version created_date modified_date </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+---------+--------------------+---------+---------------------+---------------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 10181 ENSDARG00000028148 7 2009-03-12 11:42:02 2010-09-03 20:47:26 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+---------+--------------------+---------+---------------------+---------------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">1 row in set (0.29 sec)</span></div>
<div>
</div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">mysql> select * from object_xref where ensembl_id=1081;</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+----------------+------------+---------------------+---------+--------------------+-------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> object_xref_id ensembl_id ensembl_object_type xref_id linkage_annotation analysis_id </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+----------------+------------+---------------------+---------+--------------------+-------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 201019 1081 Translation 69815 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 708474 1081 Translation 415014 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837750 1081 Translation 415118 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837768 1081 Translation 415289 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837760 1081 Translation 415952 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837769 1081 Translation 419359 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837771 1081 Translation 419360 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 708475 1081 Translation 419361 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837752 1081 Translation 419362 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837770 1081 Translation 419365 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837772 1081 Translation 419366 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 708476 1081 Translation 419378 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 837753 1081 Translation 419405 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 35151 1081 Transcript 95074 NULL 207 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 201018 1081 Translation 121946 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 86786 1081 Transcript 362937 NULL 207
</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 201020 1081 Translation 69816 NULL 224 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "> 35152 1081 Transcript 390352 NULL 207 </span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">+----------------+------------+---------------------+---------+--------------------+-------------+</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">18 rows in set (0.27 sec)</span></div>
<div>
<span class="Apple-style-span" style="font-family: tahoma, sans-serif; color: rgb(51, 51, 51); -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; ">which entry should be sent to xref to get the ZFIN ID with external_db_id=2510?
Confused... But the webpage works well..</span></div>
</span></span>