Schema for ensemblSource
  Database: panTro4    Primary Table: ensemblSource    Row Count: 29,160   Data last updated: 2017-10-10
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSPTRT00000000015.3varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSPTRT00000000015.3protein_coding
ENSPTRT00000000017.3protein_coding
ENSPTRT00000000022.4protein_coding
ENSPTRT00000000044.3protein_coding
ENSPTRT00000000049.3protein_coding
ENSPTRT00000000050.3protein_coding
ENSPTRT00000000057.3protein_coding
ENSPTRT00000000060.2protein_coding
ENSPTRT00000000064.4protein_coding
ENSPTRT00000000068.3protein_coding

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