Schema for ensemblToGeneName
  Database: oryCun2    Primary Table: ensemblToGeneName    Row Count: 31,015   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 ENSOCUT00000027832.1varchar(255) values Ensembl transcript ID
value SNORD42varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSOCUT00000027832.1SNORD42
ENSOCUT00000002001.3GOLM1
ENSOCUT00000063174.1JHY
ENSOCUT00000062183.1JHY
ENSOCUT00000015520.4JHY
ENSOCUT00000041379.1U2
ENSOCUT00000028557.1U6
ENSOCUT00000058061.1EXT2
ENSOCUT00000040381.1EXT2
ENSOCUT00000007356.3EXT2

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