Schema for ensemblSource
  Database: dm3    Primary Table: ensemblSource    Row Count: 29,173   Data last updated: 2014-03-04
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name FBtr0330361varchar(255) values Ensembl transcript ID
source pre_miRNAvarchar(255) values gene source classification

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

Sample Rows
 
namesource
FBtr0330361pre_miRNA
FBtr0330363miRNA
FBtr0330362miRNA
FBtr0078961protein_coding
FBtr0078962protein_coding
FBtr0308946pseudogene
FBtr0308945pseudogene
FBtr0078989protein_coding
FBtr0306022protein_coding
FBtr0078964protein_coding

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