Schema for ensGtp
  Database: felCat3    Primary Table: ensGtp    Row Count: 19,262   Data last updated: 2012-08-24
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSFCAG00000019490char(20) values Ensembl gene ID
transcript ENSFCAT00000019477char(20) values Ensembl transcript ID
protein  char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSFCAG00000019490ENSFCAT00000019477
ENSFCAG00000021181ENSFCAT00000021168
ENSFCAG00000021814ENSFCAT00000021801
ENSFCAG00000006978ENSFCAT00000006980ENSFCAP00000006474
ENSFCAG00000019606ENSFCAT00000019593
ENSFCAG00000012487ENSFCAT00000012490ENSFCAP00000011585
ENSFCAG00000006995ENSFCAT00000006997ENSFCAP00000016186
ENSFCAG00000007719ENSFCAT00000007721
ENSFCAG00000004547ENSFCAT00000004548
ENSFCAG00000008589ENSFCAT00000008590ENSFCAP00000007962

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