Schema for ensemblSource
  Database: canFam2    Primary Table: ensemblSource    Row Count: 30,914   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 ENSCAFT00000041506varchar(255) values Ensembl transcript ID
source miRNAvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSCAFT00000041506miRNA
ENSCAFT00000039894protein_coding
ENSCAFT00000039893protein_coding
ENSCAFT00000021396protein_coding
ENSCAFT00000039890protein_coding
ENSCAFT00000039889protein_coding
ENSCAFT00000039888protein_coding
ENSCAFT00000024574pseudogene
ENSCAFT00000020814pseudogene
ENSCAFT00000021056protein_coding

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