Schema for kgSpAlias
  Database: mm7    Primary Table: kgSpAlias    Row Count: 315,464   Data last updated: 2005-11-14
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 Q8K335varchar(40) values UniProt accession
alias AAH28896varchar(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)
      mm7.dupSpMrna.dupProteinID (via kgSpAlias.alias)
      mm7.dupSpMrna.proteinID (via kgSpAlias.alias)
      mm7.kgProtAlias.alias (via kgSpAlias.alias)
      mm7.kgProtAlias.displayID (via kgSpAlias.alias)
      mm7.kgXref.protAcc (via kgSpAlias.alias)
      mm7.kgXref.spDisplayID (via kgSpAlias.alias)
      mm7.knownCanonical.protein (via kgSpAlias.alias)
      mm7.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)
      mm7.affyGnfU74ADistance.query (via kgSpAlias.kgID)
      mm7.affyGnfU74ADistance.target (via kgSpAlias.kgID)
      mm7.affyGnfU74BDistance.query (via kgSpAlias.kgID)
      mm7.affyGnfU74BDistance.target (via kgSpAlias.kgID)
      mm7.affyGnfU74CDistance.query (via kgSpAlias.kgID)
      mm7.affyGnfU74CDistance.target (via kgSpAlias.kgID)
      mm7.dmBlastTab.query (via kgSpAlias.kgID)
      mm7.drBlastTab.query (via kgSpAlias.kgID)
      mm7.dupSpMrna.mrnaID (via kgSpAlias.kgID)
      mm7.foldUtr3.name (via kgSpAlias.kgID)
      mm7.foldUtr5.name (via kgSpAlias.kgID)
      mm7.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      mm7.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      mm7.hgBlastTab.query (via kgSpAlias.kgID)
      mm7.keggPathway.kgID (via kgSpAlias.kgID)
      mm7.kgAlias.kgID (via kgSpAlias.kgID)
      mm7.kgProtAlias.kgID (via kgSpAlias.kgID)
      mm7.kgXref.kgID (via kgSpAlias.kgID)
      mm7.knownBlastTab.query (via kgSpAlias.kgID)
      mm7.knownBlastTab.target (via kgSpAlias.kgID)
      mm7.knownCanonical.transcript (via kgSpAlias.kgID)
      mm7.knownGene.name (via kgSpAlias.kgID)
      mm7.knownGeneLink.name (via kgSpAlias.kgID)
      mm7.knownGeneMrna.name (via kgSpAlias.kgID)
      mm7.knownGenePep.name (via kgSpAlias.kgID)
      mm7.knownIsoforms.transcript (via kgSpAlias.kgID)
      mm7.knownToAllenBrain.name (via kgSpAlias.kgID)
      mm7.knownToEnsembl.name (via kgSpAlias.kgID)
      mm7.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      mm7.knownToKeggEntrez.name (via kgSpAlias.kgID)
      mm7.knownToLocusLink.name (via kgSpAlias.kgID)
      mm7.knownToPfam.name (via kgSpAlias.kgID)
      mm7.knownToRefSeq.name (via kgSpAlias.kgID)
      mm7.knownToVisiGene.name (via kgSpAlias.kgID)
      mm7.rnBlastTab.query (via kgSpAlias.kgID)
      mm7.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)
      mm7.kgProtAlias.alias (via kgSpAlias.spID)
      mm7.kgProtMap.qName (via kgSpAlias.spID)
      mm7.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
AB001539Q8K335AAH28896
AB001539Q8K335AB001539
AB001539Q8K335Grwd1
AB001539Q8K335Q810D6
AB001539Q8K335Q8K335
AB001539Q8K335Q8K335_MOUSE
AB001539Q8K335Q922H3
AB001926P48722-2AB001926
AB001926P48722-2P48722
AB001926P48722-2P48722-2

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