Schema for ensemblToGeneName
  Database: ponAbe2    Primary Table: ensemblToGeneName    Row Count: 18,962   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 ENSPPYT00000000001.2varchar(255) values Ensembl transcript ID
value PGBD2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSPPYT00000000001.2PGBD2
ENSPPYT00000000005.2ZNF672
ENSPPYT00000000006.2SH3BP5L
ENSPPYT00000000007.1OR2T27
ENSPPYT00000000009.1OR2T11
ENSPPYT00000000012.1OR2T4
ENSPPYT00000000015.1OR14C36
ENSPPYT00000000016.1OR2M7
ENSPPYT00000000019.1OR2L13
ENSPPYT00000000022.1OR2L2

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