Schema for spXref3
  Database: proteome    Primary Table: spXref3    Row Count: 28,967,555   Data last updated: 2018-04-11
Format description: An cross-reference table between SWISS-PROT IDs and other databases.
On download server: MariaDB table dump directory
fieldexampleSQL type description
accession P04217varchar(40) SWISS-PROT accession number
displayID A1BG_HUMANvarchar(40) SWISS-PROT display ID
division 9606varchar(40) SWISS-PROT division
bioentryID 25884883int(11) Biosql bioentry ID
biodatabaseID 1int(11) Biosql biodatabase ID
description RecName: Full=Alpha-1B-glyc...text Description
hugoSymbol A1BGvarchar(40) HUGO Gene Nomenclature Committee (HGNC) gene symbol
hugoDesc alpha-1-B glycoproteinvarchar(255) HGNC gene description

Connected Tables and Joining Fields
        proteome.hgncXref.uniProt (via spXref3.accession)

Sample Rows
 
accessiondisplayIDdivisionbioentryIDbiodatabaseIDdescriptionhugoSymbolhugoDesc
P04217A1BG_HUMAN9606258848831RecName: Full=Alpha-1B-glycoprotein; AltName: Full=Alpha-1-B glycoprotein; Flags: Precursor;A1BGalpha-1-B glycoprotein
Q9NQ94A1CF_HUMAN9606288221511RecName: Full=APOBEC1 complementation factor; AltName: Full=APOBEC1-stimulating protein;A1CFAPOBEC1 complementation factor
P01023A2MG_HUMAN9606258821611RecName: Full=Alpha-2-macroglobulin;          Short=Alpha-2-M; AltName: Full=C3 and PZP-like alpha-2-macroglobulin domain-contai ...A2Malpha-2-macroglobulin
A8K2U0A2ML1_HUMAN960617457281RecName: Full=Alpha-2-macroglobulin-like protein 1; AltName: Full=C3 and PZP-like alpha-2-macroglobulin domain-containing protei ...A2ML1alpha-2-macroglobulin-like 1
Q9NPC4A4GAT_HUMAN9606288220271RecName: Full=Lactosylceramide 4-alpha-galactosyltransferase;          EC=2.4.1.228; AltName: Full=Alpha-1,4-N-acetylglucosaminy ...A4GALTalpha 1,4-galactosyltransferase
Q9UNA3A4GCT_HUMAN9606288802401RecName: Full=Alpha-1,4-N-acetylglucosaminyltransferase;          Short=Alpha4GnT;          EC=2.4.1.-;A4GNTalpha-1,4-N-acetylglucosaminyltransferase
Q9NRG9AAAS_HUMAN9606288223131RecName: Full=Aladin; AltName: Full=Adracalin;AAASachalasia, adrenocortical insufficiency, alacrimia
Q86V21AACS_HUMAN9606282708351RecName: Full=Acetoacetyl-CoA synthetase;          EC=6.2.1.16; AltName: Full=Acyl-CoA synthetase family member 1; AltName: Full ...AACSacetoacetyl-CoA synthetase
P22760AAAD_HUMAN9606259128771RecName: Full=Arylacetamide deacetylase;          EC=3.1.1.3;AADACarylacetamide deacetylase
Q6P093ADCL2_HUMAN9606278553051RecName: Full=Arylacetamide deacetylase-like 2;          EC=3.1.1.-; Flags: Precursor;AADACL2arylacetamide deacetylase-like 2

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