Schema for ensemblToGeneName
  Database: susScr3    Primary Table: ensemblToGeneName    Row Count: 19,557   Data last updated: 2016-10-18
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSSSCT00000026580.1varchar(255) values Ensembl transcript ID
value FAM120Bvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSSSCT00000026580.1FAM120B
ENSSSCT00000024788.1DLL1
ENSSSCT00000034841.1CH242-271M12.1
ENSSSCT00000004434.2ERMARD
ENSSSCT00000004436.2THBS2
ENSSSCT00000004439.2DACT2
ENSSSCT00000004442.2FRMD1
ENSSSCT00000027970.1FRMD1
ENSSSCT00000004441.2KIF25
ENSSSCT00000004443.2AFDN

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