Schema for ensemblToGeneName
  Database: dm3    Primary Table: ensemblToGeneName    Row Count: 29,173   Data last updated: 2014-03-04
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name FBtr0330361varchar(255) values Ensembl transcript ID
value mir-5613varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
FBtr0330361mir-5613
FBtr0330363mir-5613
FBtr0330362mir-5613
FBtr0078961CG12581
FBtr0078962CG12581
FBtr0308946CR33294
FBtr0308945CR33294
FBtr0078989Dsk
FBtr0306022CG12582
FBtr0078964CG12582

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