Schema for ensemblToGeneName
  Database: melGal1    Primary Table: ensemblToGeneName    Row Count: 12,240   Data last updated: 2020-08-31
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMGAT00000000563.1varchar(255) values Ensembl transcript ID
value U2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSMGAT00000000563.1U2
ENSMGAT00000002708.1GOLGB1
ENSMGAT00000000023.1U2
ENSMGAT00000002697.1ARSA
ENSMGAT00000011552.2NME6
ENSMGAT00000001162.2ATP13A1
ENSMGAT00000004966.2PPP6R2
ENSMGAT00000002894.1DENND6B
ENSMGAT00000002904.2GCC1
ENSMGAT00000003029.2MIOX

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