Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for ensGtp
  Database: bosTau4    Primary Table: ensGtp    Row Count: 29,803
Format description: Ensembl Gene/Transcript/Protein cross-reference
fieldexampleSQL type info description
gene ENSBTAG00000040418char(20) values Ensembl gene ID
transcript ENSBTAT00000045897char(20) values Ensembl transcript ID
protein  char(20) values Ensembl protein ID

  Connected Tables and Joining Fields
        bosTau4.ensGene.name (via ensGtp.transcript)
      bosTau4.ensPep.name (via ensGtp.transcript)

  Sample Rows
 
genetranscriptprotein
ENSBTAG00000040418ENSBTAT00000045897
ENSBTAG00000024801ENSBTAT00000034533ENSBTAP00000034423
ENSBTAG00000002779ENSBTAT00000003604ENSBTAP00000003604
ENSBTAG00000002865ENSBTAT00000049321ENSBTAP00000046227
ENSBTAG00000002865ENSBTAT00000003718ENSBTAP00000003718
ENSBTAG00000002985ENSBTAT00000003886ENSBTAP00000003886
ENSBTAG00000002985ENSBTAT00000056280ENSBTAP00000049066
ENSBTAG00000009381ENSBTAT00000012345ENSBTAP00000012345
ENSBTAG00000009381ENSBTAT00000049330ENSBTAP00000046235
ENSBTAG00000043132ENSBTAT00000060124U6

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