Schema for ensemblXref3
  Database: hg16    Primary Table: ensemblXref3    Row Count: 38,938   Data last updated: 2004-05-24
Format description: A cross-reference table for Ensembl Genes.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSG00000187981char(20) values Ensembl gene ID
geneVer 1char(4) values Ensembl gene ID version number
transcript ENST00000343885char(20) values Ensembl transcript ID
transcriptVer 1char(4) values Ensembl transcript ID version number
protein ENSP00000339205char(20) values Ensembl protein ID
proteinVer 1char(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
        hg16.sfAssign.seqID (via ensemblXref3.protein)

Sample Rows
 
genegeneVertranscripttranscriptVerproteinproteinVertremblAccswissDisplayIdswissAcc
ENSG000001879811ENST000003438851ENSP000003392051
ENSG000001879081ENST000003398711ENSP000003397521
ENSG000001879081ENST000003443991ENSP000003432681
ENSG000001879081ENST000003383541ENSP000003422101
ENSG000001879081ENST000003444671ENSP000003425721
ENSG000001879081ENST000003274382ENSP000003315222
ENSG000001879081ENST000003443381ENSP000003431751
ENSG000001879081ENST000003395481ENSP000003457361
ENSG000001879081ENST000003397121ENSP000003425001
ENSG000001879081ENST000003301632ENSP000003277472

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