Schema for hgncXref
  Database: proteome    Primary Table: hgncXref    Row Count: 35,645   Data last updated: 2018-04-04
Format description: A cross-reference table between HUGO Gene Nomenclature Committee (HGNC) IDs and other database IDs.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
symbol A1BGvarchar(40) values Approved Symbol
refSeq NM_130786varchar(40) values RefSeq ID
uniProt P04217varchar(40) values UniProt ID (mapped data)
hgncId HGNC:5varchar(40) values HGNC ID
entrez 1varchar(40) values ENTREZ ID
description alpha-1-B glycoproteinvarchar(255) values Approved Name

Connected Tables and Joining Fields
        hg16.kgXref.spID (via hgncXref.uniProt)
      hg17.kgXref.spID (via hgncXref.uniProt)
      hg18.kgXref.spID (via hgncXref.uniProt)
      hg19.kgXref.spID (via hgncXref.uniProt)
      hg38.kgXref.spID (via hgncXref.uniProt)
      proteome.spXref3.accession (via hgncXref.uniProt)

Sample Rows
 
symbolrefSequniProthgncIdentrezdescription
A1BGNM_130786P04217HGNC:51alpha-1-B glycoprotein
A1BG-AS1NR_015380HGNC:37133503538A1BG antisense RNA 1
A1CFNM_001198819Q9NQ94HGNC:2408629974APOBEC1 complementation factor
A2MNM_000014P01023HGNC:72alpha-2-macroglobulin
A2M-AS1NR_026971HGNC:27057144571A2M antisense RNA 1
A2ML1NM_144670A8K2U0HGNC:23336144568alpha-2-macroglobulin-like 1
A2ML1-AS1HGNC:41022100874108A2ML1 antisense RNA 1
A2ML1-AS2HGNC:41523A2ML1 antisense RNA 2
A2MP1NR_040112HGNC:83alpha-2-macroglobulin pseudogene 1
A3GALT2NM_001080438-HGNC:30005127550alpha 1,3-galactosyltransferase 2

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