Schema for kgSpAlias
  Database: mm8    Primary Table: kgSpAlias    Row Count: 367,366   Data last updated: 2006-03-04
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 AB001539varchar(40) values Known Gene ID
spID Q810D6varchar(40) values UniProt accession
alias A301varchar(40) values Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (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)
      mm8.dupSpMrna.dupProteinID (via kgSpAlias.alias)
      mm8.dupSpMrna.proteinID (via kgSpAlias.alias)
      mm8.kgProtAlias.alias (via kgSpAlias.alias)
      mm8.kgProtAlias.displayID (via kgSpAlias.alias)
      mm8.kgXref.protAcc (via kgSpAlias.alias)
      mm8.kgXref.spDisplayID (via kgSpAlias.alias)
      mm8.knownCanonical.protein (via kgSpAlias.alias)
      mm8.spMrna.spID (via kgSpAlias.alias)
      proteome.spOldNew.newDisplayId (via kgSpAlias.alias)
      proteome.spOldNew.oldDisplayId (via kgSpAlias.alias)
      uniProt.displayId.val (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)
      mm8.affyGnfU74ADistance.query (via kgSpAlias.kgID)
      mm8.affyGnfU74ADistance.target (via kgSpAlias.kgID)
      mm8.affyGnfU74BDistance.query (via kgSpAlias.kgID)
      mm8.affyGnfU74BDistance.target (via kgSpAlias.kgID)
      mm8.affyGnfU74CDistance.query (via kgSpAlias.kgID)
      mm8.affyGnfU74CDistance.target (via kgSpAlias.kgID)
      mm8.ccdsKgMap.geneId (via kgSpAlias.kgID)
      mm8.ceBlastTab.query (via kgSpAlias.kgID)
      mm8.dmBlastTab.query (via kgSpAlias.kgID)
      mm8.drBlastTab.query (via kgSpAlias.kgID)
      mm8.dupSpMrna.mrnaID (via kgSpAlias.kgID)
      mm8.foldUtr3.name (via kgSpAlias.kgID)
      mm8.foldUtr5.name (via kgSpAlias.kgID)
      mm8.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      mm8.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      mm8.hgBlastTab.query (via kgSpAlias.kgID)
      mm8.keggPathway.kgID (via kgSpAlias.kgID)
      mm8.kgAlias.kgID (via kgSpAlias.kgID)
      mm8.kgProtAlias.kgID (via kgSpAlias.kgID)
      mm8.kgTargetAli.qName (via kgSpAlias.kgID)
      mm8.kgXref.kgID (via kgSpAlias.kgID)
      mm8.knownBlastTab.query (via kgSpAlias.kgID)
      mm8.knownBlastTab.target (via kgSpAlias.kgID)
      mm8.knownCanonical.transcript (via kgSpAlias.kgID)
      mm8.knownGene.name (via kgSpAlias.kgID)
      mm8.knownGeneMrna.name (via kgSpAlias.kgID)
      mm8.knownGenePep.name (via kgSpAlias.kgID)
      mm8.knownIsoforms.transcript (via kgSpAlias.kgID)
      mm8.knownToAllenBrain.name (via kgSpAlias.kgID)
      mm8.knownToEnsembl.name (via kgSpAlias.kgID)
      mm8.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      mm8.knownToKeggEntrez.name (via kgSpAlias.kgID)
      mm8.knownToLocusLink.name (via kgSpAlias.kgID)
      mm8.knownToPfam.name (via kgSpAlias.kgID)
      mm8.knownToRefSeq.name (via kgSpAlias.kgID)
      mm8.knownToSuper.gene (via kgSpAlias.kgID)
      mm8.knownToVisiGene.name (via kgSpAlias.kgID)
      mm8.rnBlastTab.query (via kgSpAlias.kgID)
      mm8.scBlastTab.query (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)
      mm8.kgProtAlias.alias (via kgSpAlias.spID)
      mm8.kgProtMap.qName (via kgSpAlias.spID)
      mm8.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
AB001539Q810D6A301
AB001539Q810D6AB001539
AB001539Q810D6AK077611
AB001539Q810D6BAC66461
AB001539Q810D6GRWD
AB001539Q810D6GRWD1
AB001539Q810D6GRWD1_MOUSE
AB001539Q810D6Grwd1
AB001539Q810D6NM_153419
AB001539Q810D6Q810D6

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