Schema for kgSpAlias
  Database: hg17    Primary Table: kgSpAlias    Row Count: 400,567   Data last updated: 2005-06-09
Format description: Associates Known Gene ID with UniProt accession and gene or protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000409varchar(40) values Known Gene ID
spID Q9BUB5-2varchar(40) values UniProt accession
alias AB000409varchar(40) values Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via kgSpAlias.alias)
      hg17.dupSpMrna.dupProteinID (via kgSpAlias.alias)
      hg17.dupSpMrna.proteinID (via kgSpAlias.alias)
      hg17.kgAlias.alias (via kgSpAlias.alias)
      hg17.kgProtAlias.alias (via kgSpAlias.alias)
      hg17.kgProtAlias.displayID (via kgSpAlias.alias)
      hg17.kgXref.geneSymbol (via kgSpAlias.alias)
      hg17.kgXref.protAcc (via kgSpAlias.alias)
      hg17.kgXref.spDisplayID (via kgSpAlias.alias)
      hg17.knownCanonical.protein (via kgSpAlias.alias)
      hg17.refFlat.geneName (via kgSpAlias.alias)
      hg17.spMrna.spID (via kgSpAlias.alias)
      hgFixed.refLink.name (via kgSpAlias.alias)
      hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.displayID (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgXref.spDisplayID (via kgSpAlias.alias)
      knownGeneV39.knownCanonical.protein (via kgSpAlias.alias)
      proteome.spOldNew.newDisplayId (via kgSpAlias.alias)
      proteome.spOldNew.oldDisplayId (via kgSpAlias.alias)
      uniProt.displayId.val (via kgSpAlias.alias)
      visiGene.gene.name (via kgSpAlias.alias)
      hg17.bioCycPathway.kgID (via kgSpAlias.kgID)
      hg17.ccdsKgMap.geneId (via kgSpAlias.kgID)
      hg17.ceBlastTab.query (via kgSpAlias.kgID)
      hg17.dmBlastTab.query (via kgSpAlias.kgID)
      hg17.drBlastTab.query (via kgSpAlias.kgID)
      hg17.dupSpMrna.mrnaID (via kgSpAlias.kgID)
      hg17.foldUtr3.name (via kgSpAlias.kgID)
      hg17.foldUtr5.name (via kgSpAlias.kgID)
      hg17.gladHumESDistance.query (via kgSpAlias.kgID)
      hg17.gladHumESDistance.target (via kgSpAlias.kgID)
      hg17.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      hg17.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      hg17.gnfU95Distance.query (via kgSpAlias.kgID)
      hg17.gnfU95Distance.target (via kgSpAlias.kgID)
      hg17.humanHprdP2P.query (via kgSpAlias.kgID)
      hg17.humanHprdP2P.target (via kgSpAlias.kgID)
      hg17.humanVidalP2P.query (via kgSpAlias.kgID)
      hg17.humanVidalP2P.target (via kgSpAlias.kgID)
      hg17.humanWankerP2P.query (via kgSpAlias.kgID)
      hg17.humanWankerP2P.target (via kgSpAlias.kgID)
      hg17.keggPathway.kgID (via kgSpAlias.kgID)
      hg17.kgAlias.kgID (via kgSpAlias.kgID)
      hg17.kgProtAlias.kgID (via kgSpAlias.kgID)
      hg17.kgTargetAli.qName (via kgSpAlias.kgID)
      hg17.kgXref.kgID (via kgSpAlias.kgID)
      hg17.knownBlastTab.query (via kgSpAlias.kgID)
      hg17.knownBlastTab.target (via kgSpAlias.kgID)
      hg17.knownCanonical.transcript (via kgSpAlias.kgID)
      hg17.knownExpDistance.query (via kgSpAlias.kgID)
      hg17.knownExpDistance.target (via kgSpAlias.kgID)
      hg17.knownGene.name (via kgSpAlias.kgID)
      hg17.knownGeneLink.name (via kgSpAlias.kgID)
      hg17.knownGeneMrna.name (via kgSpAlias.kgID)
      hg17.knownGenePep.name (via kgSpAlias.kgID)
      hg17.knownIsoforms.transcript (via kgSpAlias.kgID)
      hg17.knownToAllenBrain.name (via kgSpAlias.kgID)
      hg17.knownToEnsembl.name (via kgSpAlias.kgID)
      hg17.knownToGnf1h.name (via kgSpAlias.kgID)
      hg17.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      hg17.knownToHInv.name (via kgSpAlias.kgID)
      hg17.knownToHprd.name (via kgSpAlias.kgID)
      hg17.knownToKeggEntrez.name (via kgSpAlias.kgID)
      hg17.knownToLocusLink.name (via kgSpAlias.kgID)
      hg17.knownToPfam.name (via kgSpAlias.kgID)
      hg17.knownToRefSeq.name (via kgSpAlias.kgID)
      hg17.knownToSuper.gene (via kgSpAlias.kgID)
      hg17.knownToU133.name (via kgSpAlias.kgID)
      hg17.knownToU133Plus2.name (via kgSpAlias.kgID)
      hg17.knownToU95.name (via kgSpAlias.kgID)
      hg17.knownToVisiGene.name (via kgSpAlias.kgID)
      hg17.mmBlastTab.query (via kgSpAlias.kgID)
      hg17.rankProp.query (via kgSpAlias.kgID)
      hg17.rankProp.target (via kgSpAlias.kgID)
      hg17.rnBlastTab.query (via kgSpAlias.kgID)
      hg17.scBlastTab.query (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)
      hg17.kgProtAlias.alias (via kgSpAlias.spID)
      hg17.kgProtMap.qName (via kgSpAlias.spID)
      hg17.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
AB000409Q9BUB5-2AB000409
AB000409Q9BUB5-2MKNK1
AB000409Q9BUB5-2MNK1
AB000409Q9BUB5-2Q5TC08
AB000409Q9BUB5-2Q6V0N6
AB000409Q9BUB5-2Q7Z319
AB000409Q9BUB5-2Q9BUB5
AB000409Q9BUB5-2Q9BUB5-2
AB000460P78311AB000460
AB000460P78311BAA19116

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