Schema for ensemblToGeneName
  Database: calJac3    Primary Table: ensemblToGeneName    Row Count: 42,463   Data last updated: 2017-12-12
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSCJAT00000051294.1varchar(255) values Ensembl transcript ID
value U6varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCJAT00000051294.1U6
ENSCJAT00000048144.1U4
ENSCJAT00000057358.1U6
ENSCJAT00000006122.2SLITRK6
ENSCJAT00000058771.1SLITRK5
ENSCJAT00000006138.1SLITRK5
ENSCJAT00000006127.2SLITRK5
ENSCJAT00000046399.1SNORD59
ENSCJAT00000047722.1U6
ENSCJAT00000047858.1SNORD38

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