[ensembl-dev] Location of APPRIS and TSL in public mysql database for each Ensembl transcript

[Alexander Drew]

Hello,

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.

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. http://www.ensembl.org/Homo_sapiens/Gene/Summary?db=core;g=ENSG00000206195;r=22:15784959-15829984).

can you help me find this data in the mySQL database?

Thank you,

Alex Drew.
NOTICE
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20170508/080deaa0/attachment.html>