Schema for ensemblToGeneName
  Database: echTel1    Primary Table: ensemblToGeneName    Row Count: 14,627   Data last updated: 2019-01-11
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSETET00000003745.1varchar(255) values Ensembl transcript ID
value PAPPAvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSETET00000003745.1PAPPA
ENSETET00000003765.1ASTN2
ENSETET00000023029.1RF00026
ENSETET00000008175.1DMD
ENSETET00000024257.1RF00420
ENSETET00000024918.1RF00420
ENSETET00000025012.1RF00420
ENSETET00000015143.1NRXN3
ENSETET00000023585.1RF00191
ENSETET00000018837.1USH2A

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