Schema for ensemblSource
  Database: panTro2    Primary Table: ensemblSource    Row Count: 41,488   Data last updated: 2011-10-25
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSPTRT00000057728varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

Connected Tables and Joining Fields
        knownGeneV39.knownToEnsembl.value (via ensemblSource.name)
      panTro2.ensGene.name (via ensemblSource.name)
      panTro2.ensGtp.transcript (via ensemblSource.name)
      panTro2.ensPep.name (via ensemblSource.name)
      panTro2.ensemblToGeneName.name (via ensemblSource.name)

Sample Rows
 
namesource
ENSPTRT00000057728protein_coding
ENSPTRT00000032636protein_coding
ENSPTRT00000032642protein_coding
ENSPTRT00000032644protein_coding
ENSPTRT00000064193protein_coding
ENSPTRT00000032649protein_coding
ENSPTRT00000071896snoRNA
ENSPTRT00000057724protein_coding
ENSPTRT00000032651protein_coding
ENSPTRT00000071868misc_RNA

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.