Schema for kgProtAlias
  Database: mm7    Primary Table: kgProtAlias    Row Count: 160,331   Data last updated: 2005-11-14
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB001539varchar(255) values Known Gene ID
displayID Q8K335_MOUSEvarchar(255) values protein display ID
alias AAH28896varchar(255) values a protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectId (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.spID (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgXref.spID (via kgProtAlias.alias)
      mm7.kgProtMap.qName (via kgProtAlias.alias)
      mm7.kgSpAlias.alias (via kgProtAlias.alias)
      mm7.kgSpAlias.spID (via kgProtAlias.alias)
      mm7.kgXref.protAcc (via kgProtAlias.alias)
      mm7.kgXref.spID (via kgProtAlias.alias)
      proteome.spOldNew.acc (via kgProtAlias.alias)
      proteome.spReactomeEvent.spID (via kgProtAlias.alias)
      proteome.spReactomeId.spID (via kgProtAlias.alias)
      uniProt.accToKeyword.acc (via kgProtAlias.alias)
      uniProt.accToTaxon.acc (via kgProtAlias.alias)
      uniProt.citation.acc (via kgProtAlias.alias)
      uniProt.comment.acc (via kgProtAlias.alias)
      uniProt.description.acc (via kgProtAlias.alias)
      uniProt.displayId.acc (via kgProtAlias.alias)
      uniProt.extDbRef.acc (via kgProtAlias.alias)
      uniProt.feature.acc (via kgProtAlias.alias)
      uniProt.gene.acc (via kgProtAlias.alias)
      uniProt.geneLogic.acc (via kgProtAlias.alias)
      uniProt.info.acc (via kgProtAlias.alias)
      uniProt.otherAcc.acc (via kgProtAlias.alias)
      uniProt.protein.acc (via kgProtAlias.alias)
      visiGene.gene.uniProt (via kgProtAlias.alias)
      go.goaPart.dbObjectSymbol (via kgProtAlias.displayID)
      knownGeneV39.kgProtAlias.displayID (via kgProtAlias.displayID)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.displayID)
      knownGeneV39.kgXref.spDisplayID (via kgProtAlias.displayID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.displayID)
      mm7.dupSpMrna.dupProteinID (via kgProtAlias.displayID)
      mm7.dupSpMrna.proteinID (via kgProtAlias.displayID)
      mm7.kgSpAlias.alias (via kgProtAlias.displayID)
      mm7.kgXref.spDisplayID (via kgProtAlias.displayID)
      mm7.knownCanonical.protein (via kgProtAlias.displayID)
      mm7.spMrna.spID (via kgProtAlias.displayID)
      proteome.spOldNew.newDisplayId (via kgProtAlias.displayID)
      proteome.spOldNew.oldDisplayId (via kgProtAlias.displayID)
      uniProt.displayId.val (via kgProtAlias.displayID)
      knownGeneV39.bioCycPathway.kgID (via kgProtAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgProtAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgProtAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownCds.name (via kgProtAlias.kgID)
      knownGeneV39.knownGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgProtAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgProtAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgProtAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgProtAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgProtAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgProtAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgProtAlias.kgID)
      knownGeneV39.knownToTag.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU133.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU95.name (via kgProtAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgProtAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgProtAlias.kgID)
      mm7.affyGnfU74ADistance.query (via kgProtAlias.kgID)
      mm7.affyGnfU74ADistance.target (via kgProtAlias.kgID)
      mm7.affyGnfU74BDistance.query (via kgProtAlias.kgID)
      mm7.affyGnfU74BDistance.target (via kgProtAlias.kgID)
      mm7.affyGnfU74CDistance.query (via kgProtAlias.kgID)
      mm7.affyGnfU74CDistance.target (via kgProtAlias.kgID)
      mm7.dmBlastTab.query (via kgProtAlias.kgID)
      mm7.drBlastTab.query (via kgProtAlias.kgID)
      mm7.dupSpMrna.mrnaID (via kgProtAlias.kgID)
      mm7.foldUtr3.name (via kgProtAlias.kgID)
      mm7.foldUtr5.name (via kgProtAlias.kgID)
      mm7.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      mm7.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      mm7.hgBlastTab.query (via kgProtAlias.kgID)
      mm7.keggPathway.kgID (via kgProtAlias.kgID)
      mm7.kgAlias.kgID (via kgProtAlias.kgID)
      mm7.kgSpAlias.kgID (via kgProtAlias.kgID)
      mm7.kgXref.kgID (via kgProtAlias.kgID)
      mm7.knownBlastTab.query (via kgProtAlias.kgID)
      mm7.knownBlastTab.target (via kgProtAlias.kgID)
      mm7.knownCanonical.transcript (via kgProtAlias.kgID)
      mm7.knownGene.name (via kgProtAlias.kgID)
      mm7.knownGeneLink.name (via kgProtAlias.kgID)
      mm7.knownGeneMrna.name (via kgProtAlias.kgID)
      mm7.knownGenePep.name (via kgProtAlias.kgID)
      mm7.knownIsoforms.transcript (via kgProtAlias.kgID)
      mm7.knownToAllenBrain.name (via kgProtAlias.kgID)
      mm7.knownToEnsembl.name (via kgProtAlias.kgID)
      mm7.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      mm7.knownToKeggEntrez.name (via kgProtAlias.kgID)
      mm7.knownToLocusLink.name (via kgProtAlias.kgID)
      mm7.knownToPfam.name (via kgProtAlias.kgID)
      mm7.knownToRefSeq.name (via kgProtAlias.kgID)
      mm7.knownToVisiGene.name (via kgProtAlias.kgID)
      mm7.rnBlastTab.query (via kgProtAlias.kgID)
      mm7.scBlastTab.query (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
AB001539Q8K335_MOUSEAAH28896
AB001539Q8K335_MOUSEQ810D6
AB001539Q8K335_MOUSEQ8K335
AB001539Q8K335_MOUSEQ8K335_MOUSE
AB001539Q8K335_MOUSEQ922H3
AB001926P48722-2P48722
AB001926P48722-2P48722-2
AB001926P48722-2Q3TTD4
AB003147O54770_MOUSEBAA24139
AB003147O54770_MOUSEO35656

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