Schema for kgSpAlias
  Database: mm10    Primary Table: kgSpAlias    Row Count: 804,057   Data last updated: 2019-09-20
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 ENSMUST00000000001.4varchar(40) Known Gene ID
spID Q9DC51varchar(40) UniProt accession
alias A2AE36varchar(40) Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      mm10.kgProtAlias.alias (via kgSpAlias.alias)
      mm10.kgXref.protAcc (via kgSpAlias.alias)
      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)
      mm10.bioCycPathway.kgID (via kgSpAlias.kgID)
      mm10.ccdsKgMap.geneId (via kgSpAlias.kgID)
      mm10.ceBlastTab.query (via kgSpAlias.kgID)
      mm10.dmBlastTab.query (via kgSpAlias.kgID)
      mm10.drBlastTab.query (via kgSpAlias.kgID)
      mm10.foldUtr3.name (via kgSpAlias.kgID)
      mm10.foldUtr5.name (via kgSpAlias.kgID)
      mm10.hgBlastTab.query (via kgSpAlias.kgID)
      mm10.keggPathway.kgID (via kgSpAlias.kgID)
      mm10.kgAlias.kgID (via kgSpAlias.kgID)
      mm10.kgColor.kgID (via kgSpAlias.kgID)
      mm10.kgProtAlias.kgID (via kgSpAlias.kgID)
      mm10.kgProtMap2.qName (via kgSpAlias.kgID)
      mm10.kgTargetAli.qName (via kgSpAlias.kgID)
      mm10.kgTxInfo.name (via kgSpAlias.kgID)
      mm10.kgXref.kgID (via kgSpAlias.kgID)
      mm10.knownAttrs.kgID (via kgSpAlias.kgID)
      mm10.knownBlastTab.query (via kgSpAlias.kgID)
      mm10.knownBlastTab.target (via kgSpAlias.kgID)
      mm10.knownCanonical.transcript (via kgSpAlias.kgID)
      mm10.knownCds.name (via kgSpAlias.kgID)
      mm10.knownGene.name (via kgSpAlias.kgID)
      mm10.knownGeneMrna.name (via kgSpAlias.kgID)
      mm10.knownGenePep.name (via kgSpAlias.kgID)
      mm10.knownIsoforms.transcript (via kgSpAlias.kgID)
      mm10.knownToEnsembl.name (via kgSpAlias.kgID)
      mm10.knownToKeggEntrez.name (via kgSpAlias.kgID)
      mm10.knownToLocusLink.name (via kgSpAlias.kgID)
      mm10.knownToLynx.name (via kgSpAlias.kgID)
      mm10.knownToMrna.name (via kgSpAlias.kgID)
      mm10.knownToMrnaSingle.name (via kgSpAlias.kgID)
      mm10.knownToPfam.name (via kgSpAlias.kgID)
      mm10.knownToRefSeq.name (via kgSpAlias.kgID)
      mm10.knownToSuper.gene (via kgSpAlias.kgID)
      mm10.knownToTag.name (via kgSpAlias.kgID)
      mm10.knownToVisiGene.name (via kgSpAlias.kgID)
      mm10.knownToWikipedia.name (via kgSpAlias.kgID)
      mm10.rnBlastTab.query (via kgSpAlias.kgID)
      mm10.scBlastTab.query (via kgSpAlias.kgID)
      mm10.ucscScop.ucscId (via kgSpAlias.kgID)
      go.goaPart.dbObjectId (via kgSpAlias.spID)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.spID)
      knownGeneV39.kgSpAlias.spID (via kgSpAlias.spID)
      knownGeneV39.kgXref.spID (via kgSpAlias.spID)
      mm10.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
ENSMUST00000000001.4Q9DC51A2AE36
ENSMUST00000000001.4Q9DC51ENSMUST00000000001.4
ENSMUST00000000001.4Q9DC51GNAI3_MOUSE
ENSMUST00000000001.4Q9DC51Gnai3
ENSMUST00000000001.4Q9DC51NM_010306
ENSMUST00000000001.4Q9DC51Q3TGV1
ENSMUST00000000001.4Q9DC51Q61019
ENSMUST00000000001.4Q9DC51Q9DC51
ENSMUST00000000001.4Q9DC51uc008qyd.1
ENSMUST00000000001.4Q9DC51uc008qyd.2

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