Schema for ensemblToGeneName
  Database: speTri2    Primary Table: ensemblToGeneName    Row Count: 22,659   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 ENSSTOT00000007421.3varchar(255) values Ensembl transcript ID
value NOSTRINvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSSTOT00000007421.3NOSTRIN
ENSSTOT00000007390.3CERS6
ENSSTOT00000027701.2CERS6
ENSSTOT00000013685.3STK39
ENSSTOT00000033989.1LYPD6
ENSSTOT00000040366.1FIGN
ENSSTOT00000026266.2FIGN
ENSSTOT00000025616.2LYPD6B
ENSSTOT00000036170.1KCNH7
ENSSTOT00000042299.1KCNH7

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