Schema for ensemblToGeneName
  Database: micMur2    Primary Table: ensemblToGeneName    Row Count: 35,571   Data last updated: 2017-10-10
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMICT00000020045.2varchar(255) values Ensembl transcript ID
value Y_RNAvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSMICT00000020045.2Y_RNA
ENSMICT00000023797.25S_rRNA
ENSMICT00000005926.2DLG5
ENSMICT00000034041.1DLG5
ENSMICT00000051971.1Y_RNA
ENSMICT00000021328.2Y_RNA
ENSMICT00000042432.1ZMIZ1
ENSMICT00000054408.1ZMIZ1
ENSMICT00000007075.2ZMIZ1
ENSMICT00000044210.1ZMIZ1

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