Schema for ensemblToGeneName
  Database: criGriChoV2    Primary Table: ensemblToGeneName    Row Count: 25,608   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 ENSCGRT00001000683.1varchar(255) values Ensembl transcript ID
value Triml2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCGRT00001000683.1Triml2
ENSCGRT00001000688.1Triml2
ENSCGRT00001000713.1Leprotl1
ENSCGRT00001000714.1Leprotl1
ENSCGRT00001000732.1Sdha
ENSCGRT00001000758.1Isl1
ENSCGRT00001000742.1Zdhhc14
ENSCGRT00001000820.1Mroh2a
ENSCGRT00001000791.1Smoc2
ENSCGRT00001000846.1Sgpp2

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