Schema for ensemblToGeneName
  Database: dm6    Primary Table: ensemblToGeneName    Row Count: 35,137   Data last updated: 2021-05-25
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name FBtr0091512varchar(255) values Ensembl transcript ID
value gfzfvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
FBtr0091512gfzf
FBtr0334671gfzf
FBtr0114531gfzf
FBtr0473385sisRNA:CR46358
FBtr0078591Osi24
FBtr0301479msps
FBtr0304801msps
FBtr0304803msps
FBtr0304802msps
FBtr0301480msps

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