Schema for ensemblToGeneName
  Database: equCab2    Primary Table: ensemblToGeneName    Row Count: 18,213   Data last updated: 2018-05-08
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSECAT00000013004.1varchar(255) values Ensembl transcript ID
value SYCE1varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSECAT00000013004.1SYCE1
ENSECAT00000020809.1CYP2E1
ENSECAT00000010270.1SCART1
ENSECAT00000010283.1SCART1
ENSECAT00000000129.1PAOX
ENSECAT00000013377.1ECHS1
ENSECAT00000018606.1FUOM
ENSECAT00000018616.1CALY
ENSECAT00000019978.1TUBGCP2
ENSECAT00000021637.1KNDC1

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