Schema for ensemblXref3
  Database: hg17    Primary Table: ensemblXref3    Row Count: 36,924   Data last updated: 2004-11-30
Format description: A cross-reference table for Ensembl Genes.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSG00000169861char(20) values Ensembl gene ID
geneVer 4char(4) values Ensembl gene ID version number
transcript ENST00000302092char(20) values Ensembl transcript ID
transcriptVer 4char(4) values Ensembl transcript ID version number
protein ENSP00000303034char(20) values Ensembl protein ID
proteinVer 4char(4) values Ensembl protein version number
tremblAcc  char(20) values TrEMBL protein accession number
swissDisplayId  char(20) values Swiss-Prot protein display ID
swissAcc  char(20) values Swiss-Prot protein accession number

Connected Tables and Joining Fields
        hg17.sfAssign.seqID (via ensemblXref3.protein)

Sample Rows
 
genegeneVertranscripttranscriptVerproteinproteinVertremblAccswissDisplayIdswissAcc
ENSG000001698614ENST000003020924ENSP000003030344
ENSG000001661575ENST000003596931ENSP000003527221TPTE_HUMANP56180
ENSG000001661575ENST000002982324ENSP000002982324
ENSG000001661575ENST000003424202ENSP000003444412
ENSG000001661575ENST000003397042ENSP000003422432
ENSG000001871724ENST000003353692ENSP000003355282BGE2_HUMANQ86Y30
ENSG000001871724ENST000003353692ENSP000003355282BGE3_HUMANQ86Y29
ENSG000001871724ENST000003568321ENSP000003492891BGE4_HUMANQ86Y28
ENSG000001871724ENST000003568321ENSP000003492891BGE1_HUMANQ13072
ENSG000001871724ENST000003568321ENSP000003492891BGE5_HUMANQ86Y27

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