<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi Alex,<div class="">You can find the data in the transcript_attrib table. You will need to join the attrib_type table too:</div><div class=""><div class="">homo_sapiens_core_88_38 > SELECT t.stable_id, at.name, ta.value FROM transcript t, transcript_attrib ta, attrib_type at WHERE t.transcript_id = ta.transcript_id AND ta.attrib_type_id = at.attrib_type_id LIMIT 3;</div><div class="">+-----------------+--------------------------+-------------------+</div><div class="">| stable_id | name | value |</div><div class="">+-----------------+--------------------------+-------------------+</div><div class="">| ENST00000617849 | GENCODE basic annotation | GENCODE basic |</div><div class="">| ENST00000617849 | Transcript Support Level | tsl1 |</div><div class="">| ENST00000466115 | Synonym | DAQB-124C11.3-007 |</div><div class="">+-----------------+--------------------------+—————————+</div><div class=""><br class=""></div><div class="">We would recommend you to use the Perl API to access this information if you need to do it often and in a safe way.</div><div class=""><a href="http://www.ensembl.org/info/docs/Doxygen/core-api/classBio_1_1EnsEMBL_1_1Transcript.html#a59f9ff2079a28ba80bc8b62a5e636327" class="">http://www.ensembl.org/info/docs/Doxygen/core-api/classBio_1_1EnsEMBL_1_1Transcript.html#a59f9ff2079a28ba80bc8b62a5e636327</a></div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Thibaut</div><div class=""><br class=""></div><div><blockquote type="cite" class=""><div class="">On 8 May 2017, at 06:48, Alexander Drew <<a href="mailto:a.drew@garvan.org.au" class="">a.drew@garvan.org.au</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; direction: ltr; font-family: Tahoma; font-size: 10pt;" class="">Hello,<span class="Apple-converted-space"> </span><br class=""><div style="font-family: 'Times New Roman'; font-size: 16px;" class=""><div class=""><div style="direction: ltr; font-family: Tahoma; font-size: 10pt;" class=""><br class="">I am trying to retrieve the flags (specifically APPRIS and Transcript support level) for Ensembl transcript Ids from the public mySQL database. I am having trouble locating this information in the database schema. I have found the reference for this in the various databases for the different genome builds, but cannot locate the actual data.<br class=""><br class="">I am trying to grab the same data that is populated in the transcript table 'flags' column when viewing a gene in the Ensembl website (eg.<a href="http://www.ensembl.org/Homo_sapiens/Gene/Summary?db=core;g=ENSG00000206195;r=22:15784959-15829984)." target="_blank" class="">http://www.ensembl.org/Homo_sapiens/Gene/Summary?db=core;g=ENSG00000206195;r=22:15784959-15829984).</a><br class=""><br class="">can you help me find this data in the mySQL database?<br class=""><br class="">Thank you,<br class=""><br class="">Alex Drew.<br class=""></div></div></div></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 8pt; font-family: Arial;" class="">NOTICE</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 8pt; font-family: Arial;" class="">Please consider the environment before printing this email. This message and any attachments are intended for the addressee named and may contain legally privileged/confidential/copyright information. If you are not the intended recipient, you should not read, use, disclose, copy or distribute this communication. If you have received this message in error please notify us at once by return email and then delete both messages. We accept no liability for the distribution of viruses or similar in electronic communications. This notice should not be removed.</div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Dev mailing list </span><a href="mailto:Dev@ensembl.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Dev@ensembl.org</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Posting guidelines and subscribe/unsubscribe info:<span class="Apple-converted-space"> </span></span><a href="http://lists.ensembl.org/mailman/listinfo/dev" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lists.ensembl.org/mailman/listinfo/dev</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Ensembl Blog:<span class="Apple-converted-space"> </span></span><a href="http://www.ensembl.info/" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://www.ensembl.info/</a></div></blockquote></div><br class=""></div></body></html>