Schema for ensemblSource
  Database: hg19    Primary Table: ensemblSource    Row Count: 204,940   Data last updated: 2014-02-28
Format description: Ensembl gene source classification, coding/non-coding status
fieldexampleSQL type info description
name ENST00000400776varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENST00000400776protein_coding
ENST00000374457protein_coding
ENST00000433682protein_coding
ENST00000374449protein_coding
ENST00000459035snRNA
ENST00000516583snoRNA
ENST00000459564miRNA
ENST00000545452protein_coding
ENST00000425945protein_coding
ENST00000458901rRNA

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