Schema for ensemblSource
  Database: ci2    Primary Table: ensemblSource    Row Count: 20,225   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 ENSCINT00000027313varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSCINT00000027313protein_coding
ENSCINT00000020405protein_coding
ENSCINT00000020407protein_coding
ENSCINT00000015514protein_coding
ENSCINT00000015518protein_coding
ENSCINT00000015517protein_coding
ENSCINT00000000506protein_coding
ENSCINT00000015501protein_coding
ENSCINT00000027244protein_coding
ENSCINT00000010826protein_coding

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