Schema for ensemblToGeneName
  Database: otoGar3    Primary Table: ensemblToGeneName    Row Count: 20,018   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 ENSOGAT00000027433.1varchar(255) values Ensembl transcript ID
value ENDOD1varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSOGAT00000027433.1ENDOD1
ENSOGAT00000014495.2SESN3
ENSOGAT00000005768.2FAM76B
ENSOGAT00000005776.2MTMR2
ENSOGAT00000000361.2MAML2
ENSOGAT00000007292.2CCDC82
ENSOGAT00000032961.1JRKL
ENSOGAT00000004711.2CNTN5
ENSOGAT00000012306.2ARHGAP42
ENSOGAT00000012316.2PGR

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