Schema for ensGtp
  Database: sarHar1    Primary Table: ensGtp    Row Count: 24,035   Data last updated: 2020-08-31
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSSHAG00000011277.1char(21) values Ensembl gene ID
transcript ENSSHAT00000013299.1char(21) values Ensembl transcript ID
protein ENSSHAP00000013191.1char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSSHAG00000011277.1ENSSHAT00000013299.1ENSSHAP00000013191.1
ENSSHAG00000015543.1ENSSHAT00000018461.1ENSSHAP00000018311.1
ENSSHAG00000015543.1ENSSHAT00000018462.1ENSSHAP00000018312.1
ENSSHAG00000015925.1ENSSHAT00000018917.1ENSSHAP00000018762.1
ENSSHAG00000016104.1ENSSHAT00000019128.1ENSSHAP00000018972.1
ENSSHAG00000016243.1ENSSHAT00000019287.1ENSSHAP00000019131.1
ENSSHAG00000016433.1ENSSHAT00000019503.1ENSSHAP00000019347.1
ENSSHAG00000016638.1ENSSHAT00000019754.1ENSSHAP00000019597.1
ENSSHAG00000017071.1ENSSHAT00000020282.1ENSSHAP00000020122.1
ENSSHAG00000017081.1ENSSHAT00000020295.1ENSSHAP00000020135.1

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