<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Laura,</p>
<p>Thanks for your email.</p>
<p>The "display_name" is referenced to by the field
"display_xref_id" in either gene or transcript table, and you can
find the actual "display_name" in the xref table.</p>
<p>For example, let's assume we are interested in the gene
identified by "ENSG00000139618", the following SQL query shows you
the "display_name"<br>
</p>
<p><font face="Courier New, Courier, monospace">SELECT g.gene_id,
g.stable_id, g.biotype, g.display_xref_id, x.external_db_id,
e.db_name, x.display_label<br>
FROM gene g INNER JOIN xref x ON g.display_xref_id =
x.xref_id<br>
INNER JOIN external_db e ON x.external_db_id =
e.external_db_id <br>
WHERE g.stable_id = 'ENSG00000139618';</font><br>
</p>
<p>A similar query can work on transcripts; for example<br>
</p>
<p><font face="Courier New, Courier, monospace">SELECT t.gene_id,
t.stable_id, t.biotype, t.display_xref_id, x.external_db_id,
e.db_name, x.display_label<br>
FROM transcript t INNER JOIN xref x ON t.display_xref_id =
x.xref_id<br>
INNER JOIN external_db e ON
x.external_db_id = e.external_db_id<br>
LIMIT 5;</font><br>
</p>
<p>In both the examples, I added in the "external_db" table to show
where the "display_name" comes from.<br>
This is entirely optional, and you can safely remove table and
related field from the queries.</p>
<p>Hope this helps.</p>
<p>Best wishes,</p>
<p>Stefano<br>
</p>
<div class="moz-cite-prefix">On 01/03/2022 03:08, Luebbert, Laura
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SJ0PR03MB645666A0C023A68B22329C09A0029@SJ0PR03MB6456.namprd03.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}div.WordSection1
{page:WordSection1;}</style>
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">Hi, </span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am having
trouble finding the equivalent of the “display_name” (name
or identifier of a gene/transcript) in the Ensembl core
schema. In which table can I find this information for each
stable ID?</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">With best
regards,</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Laura</span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Dev mailing list <a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
Posting guidelines and subscribe/unsubscribe info: <a class="moz-txt-link-freetext" href="https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org">https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org</a>
Ensembl Blog: <a class="moz-txt-link-freetext" href="http://www.ensembl.info/">http://www.ensembl.info/</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>