Skip to main content
Schema for kgSpAlias
  Database: hg19    Primary Table: kgSpAlias    Row Count: 3,179,921   Data last updated: 2025-09-29
Format description: Associates Known Gene ID with UniProt accession and gene or protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENST00000000233.10_4varchar(40) Known Gene ID
spID P84085varchar(40) UniProt accession
alias ARF5varchar(40) Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        hg19.kgAlias.alias (via kgSpAlias.alias)
      hg19.kgProtAlias.alias (via kgSpAlias.alias)
      hg19.kgXref.geneSymbol (via kgSpAlias.alias)
      hg19.kgXref.protAcc (via kgSpAlias.alias)
      hg19.refFlat.geneName (via kgSpAlias.alias)
      hgFixed.refLink.name (via kgSpAlias.alias)
      hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      visiGene.gene.name (via kgSpAlias.alias)
      hg19.bioCycPathway.kgID (via kgSpAlias.kgID)
      hg19.ceBlastTab.query (via kgSpAlias.kgID)
      hg19.dmBlastTab.query (via kgSpAlias.kgID)
      hg19.drBlastTab.query (via kgSpAlias.kgID)
      hg19.foldUtr3.name (via kgSpAlias.kgID)
      hg19.foldUtr5.name (via kgSpAlias.kgID)
      hg19.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      hg19.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      hg19.gnfU95Distance.query (via kgSpAlias.kgID)
      hg19.gnfU95Distance.target (via kgSpAlias.kgID)
      hg19.humanHprdP2P.query (via kgSpAlias.kgID)
      hg19.humanHprdP2P.target (via kgSpAlias.kgID)
      hg19.humanVidalP2P.query (via kgSpAlias.kgID)
      hg19.humanVidalP2P.target (via kgSpAlias.kgID)
      hg19.humanWankerP2P.query (via kgSpAlias.kgID)
      hg19.humanWankerP2P.target (via kgSpAlias.kgID)
      hg19.keggPathway.kgID (via kgSpAlias.kgID)
      hg19.kgAlias.kgID (via kgSpAlias.kgID)
      hg19.kgColor.kgID (via kgSpAlias.kgID)
      hg19.kgProtAlias.kgID (via kgSpAlias.kgID)
      hg19.kgProtMap2.qName (via kgSpAlias.kgID)
      hg19.kgTargetAli.qName (via kgSpAlias.kgID)
      hg19.kgTxInfo.name (via kgSpAlias.kgID)
      hg19.kgXref.kgID (via kgSpAlias.kgID)
      hg19.knownAttrs.kgID (via kgSpAlias.kgID)
      hg19.knownBlastTab.query (via kgSpAlias.kgID)
      hg19.knownBlastTab.target (via kgSpAlias.kgID)
      hg19.knownCanonical.transcript (via kgSpAlias.kgID)
      hg19.knownCds.name (via kgSpAlias.kgID)
      hg19.knownGene.name (via kgSpAlias.kgID)
      hg19.knownGeneMrna.name (via kgSpAlias.kgID)
      hg19.knownGenePep.name (via kgSpAlias.kgID)
      hg19.knownGeneTxMrna.name (via kgSpAlias.kgID)
      hg19.knownGeneTxPep.name (via kgSpAlias.kgID)
      hg19.knownIsoforms.transcript (via kgSpAlias.kgID)
      hg19.knownToAllenBrain.name (via kgSpAlias.kgID)
      hg19.knownToEnsembl.name (via kgSpAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      hg19.knownToHInv.name (via kgSpAlias.kgID)
      hg19.knownToHprd.name (via kgSpAlias.kgID)
      hg19.knownToKeggEntrez.name (via kgSpAlias.kgID)
      hg19.knownToLocusLink.name (via kgSpAlias.kgID)
      hg19.knownToLynx.name (via kgSpAlias.kgID)
      hg19.knownToMrna.name (via kgSpAlias.kgID)
      hg19.knownToMrnaSingle.name (via kgSpAlias.kgID)
      hg19.knownToMupit.name (via kgSpAlias.kgID)
      hg19.knownToNextProt.name (via kgSpAlias.kgID)
      hg19.knownToPfam.name (via kgSpAlias.kgID)
      hg19.knownToRefSeq.name (via kgSpAlias.kgID)
      hg19.knownToSuper.gene (via kgSpAlias.kgID)
      hg19.knownToTag.name (via kgSpAlias.kgID)
      hg19.knownToTreefam.name (via kgSpAlias.kgID)
      hg19.knownToU133.name (via kgSpAlias.kgID)
      hg19.knownToU133Plus2.name (via kgSpAlias.kgID)
      hg19.knownToU95.name (via kgSpAlias.kgID)
      hg19.knownToVisiGene.name (via kgSpAlias.kgID)
      hg19.knownToWikipedia.name (via kgSpAlias.kgID)
      hg19.mmBlastTab.query (via kgSpAlias.kgID)
      hg19.rnBlastTab.query (via kgSpAlias.kgID)
      hg19.scBlastTab.query (via kgSpAlias.kgID)
      hg19.ucscScop.ucscId (via kgSpAlias.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgSpAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgSpAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgSpAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgSpAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgSpAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgSpAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgSpAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgSpAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgSpAlias.kgID)
      knownGeneV39.knownCds.name (via kgSpAlias.kgID)
      knownGeneV39.knownGene.name (via kgSpAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgSpAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgSpAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgSpAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgSpAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgSpAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgSpAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgSpAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgSpAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgSpAlias.kgID)
      knownGeneV39.knownToTag.name (via kgSpAlias.kgID)
      knownGeneV39.knownToU133.name (via kgSpAlias.kgID)
      knownGeneV39.knownToU95.name (via kgSpAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgSpAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgSpAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgSpAlias.kgID)
      go.goaPart.dbObjectId (via kgSpAlias.spID)
      hg19.kgXref.spID (via kgSpAlias.spID)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.spID)
      knownGeneV39.kgSpAlias.spID (via kgSpAlias.spID)
      knownGeneV39.kgXref.spID (via kgSpAlias.spID)
      proteome.spOldNew.acc (via kgSpAlias.spID)
      proteome.spReactomeEvent.spID (via kgSpAlias.spID)
      proteome.spReactomeId.spID (via kgSpAlias.spID)
      uniProt.accToKeyword.acc (via kgSpAlias.spID)
      uniProt.accToTaxon.acc (via kgSpAlias.spID)
      uniProt.citation.acc (via kgSpAlias.spID)
      uniProt.comment.acc (via kgSpAlias.spID)
      uniProt.description.acc (via kgSpAlias.spID)
      uniProt.displayId.acc (via kgSpAlias.spID)
      uniProt.extDbRef.acc (via kgSpAlias.spID)
      uniProt.feature.acc (via kgSpAlias.spID)
      uniProt.gene.acc (via kgSpAlias.spID)
      uniProt.geneLogic.acc (via kgSpAlias.spID)
      uniProt.info.acc (via kgSpAlias.spID)
      uniProt.otherAcc.acc (via kgSpAlias.spID)
      uniProt.protein.acc (via kgSpAlias.spID)
      visiGene.gene.uniProt (via kgSpAlias.spID)

Sample Rows
 
kgIDspIDalias
ENST00000000233.10_4P84085ARF5
ENST00000000233.10_4P84085ARF5_HUMAN
ENST00000000233.10_4P84085ENST00000000233.1
ENST00000000233.10_4P84085ENST00000000233.10_4
ENST00000000233.10_4P84085ENST00000000233.2
ENST00000000233.10_4P84085ENST00000000233.3
ENST00000000233.10_4P84085ENST00000000233.4
ENST00000000233.10_4P84085ENST00000000233.5
ENST00000000233.10_4P84085ENST00000000233.6
ENST00000000233.10_4P84085ENST00000000233.7

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