[ensembl-dev] gene biotypes

Felix Kokocinski fsk at sanger.ac.uk
Mon Nov 1 14:47:42 GMT 2010


Andreas Kahari wrote:
> Hi Andrea,
> 
> On Mon, Nov 01, 2010 at 02:00:22PM +0000, Andrea Edwards wrote:
>> Hi
>>
>> I'm sorry for the basic question but is there some documentation
>> describing the different fields in the ensembl database. I've found
>> a schema document online
>>
>> http://www.ensembl.org/info/docs/api/core/core_schema.html
>>
>> but this didn't help me find the information i was looking for. In
>> this instance I was looking for the list of values for gene biotype
>> field. This document didn't list/explain all the fields in each
>> table.
>>
>> I did find the list of fields from a 'select distinct' query on the
>> database.
>>
>> thanks for your help
> 
> If you're using straight SQL you can get the list of gene biotypes
> through the following query:
> 
>   SELECT DISTINCT biotype FROM gene;
> 
> 
> As for what each biotype means, our genebuilders (or our
> helpdesk at ensembl.org) will be able to answer that.

Here is also a list which gives some more information on most of these 
types: http://www.gencodegenes.org/gencode_biotypes.html
(The Gencode gene set is identical to the Ensembl gene set)

  Best, Felix




More information about the Dev mailing list