Schema for kgProtAlias
  Database: mm8    Primary Table: kgProtAlias    Row Count: 174,917   Data last updated: 2006-03-04
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 GRWD1_MOUSEvarchar(255) values protein display ID
alias BAC66461varchar(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)
      mm8.kgProtMap.qName (via kgProtAlias.alias)
      mm8.kgSpAlias.alias (via kgProtAlias.alias)
      mm8.kgSpAlias.spID (via kgProtAlias.alias)
      mm8.kgXref.protAcc (via kgProtAlias.alias)
      mm8.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)
      mm8.dupSpMrna.dupProteinID (via kgProtAlias.displayID)
      mm8.dupSpMrna.proteinID (via kgProtAlias.displayID)
      mm8.kgSpAlias.alias (via kgProtAlias.displayID)
      mm8.kgXref.spDisplayID (via kgProtAlias.displayID)
      mm8.knownCanonical.protein (via kgProtAlias.displayID)
      mm8.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)
      mm8.affyGnfU74ADistance.query (via kgProtAlias.kgID)
      mm8.affyGnfU74ADistance.target (via kgProtAlias.kgID)
      mm8.affyGnfU74BDistance.query (via kgProtAlias.kgID)
      mm8.affyGnfU74BDistance.target (via kgProtAlias.kgID)
      mm8.affyGnfU74CDistance.query (via kgProtAlias.kgID)
      mm8.affyGnfU74CDistance.target (via kgProtAlias.kgID)
      mm8.ccdsKgMap.geneId (via kgProtAlias.kgID)
      mm8.ceBlastTab.query (via kgProtAlias.kgID)
      mm8.dmBlastTab.query (via kgProtAlias.kgID)
      mm8.drBlastTab.query (via kgProtAlias.kgID)
      mm8.dupSpMrna.mrnaID (via kgProtAlias.kgID)
      mm8.foldUtr3.name (via kgProtAlias.kgID)
      mm8.foldUtr5.name (via kgProtAlias.kgID)
      mm8.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      mm8.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      mm8.hgBlastTab.query (via kgProtAlias.kgID)
      mm8.keggPathway.kgID (via kgProtAlias.kgID)
      mm8.kgAlias.kgID (via kgProtAlias.kgID)
      mm8.kgSpAlias.kgID (via kgProtAlias.kgID)
      mm8.kgTargetAli.qName (via kgProtAlias.kgID)
      mm8.kgXref.kgID (via kgProtAlias.kgID)
      mm8.knownBlastTab.query (via kgProtAlias.kgID)
      mm8.knownBlastTab.target (via kgProtAlias.kgID)
      mm8.knownCanonical.transcript (via kgProtAlias.kgID)
      mm8.knownGene.name (via kgProtAlias.kgID)
      mm8.knownGeneMrna.name (via kgProtAlias.kgID)
      mm8.knownGenePep.name (via kgProtAlias.kgID)
      mm8.knownIsoforms.transcript (via kgProtAlias.kgID)
      mm8.knownToAllenBrain.name (via kgProtAlias.kgID)
      mm8.knownToEnsembl.name (via kgProtAlias.kgID)
      mm8.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      mm8.knownToKeggEntrez.name (via kgProtAlias.kgID)
      mm8.knownToLocusLink.name (via kgProtAlias.kgID)
      mm8.knownToPfam.name (via kgProtAlias.kgID)
      mm8.knownToRefSeq.name (via kgProtAlias.kgID)
      mm8.knownToSuper.gene (via kgProtAlias.kgID)
      mm8.knownToVisiGene.name (via kgProtAlias.kgID)
      mm8.rnBlastTab.query (via kgProtAlias.kgID)
      mm8.scBlastTab.query (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
AB001539GRWD1_MOUSEBAC66461
AB001539GRWD1_MOUSEGRWD1_MOUSE
AB001539GRWD1_MOUSEQ810D6
AB001539GRWD1_MOUSEQ8K335
AB001539GRWD1_MOUSEQ922H3
AB001750RABE1_MOUSEBAA21783
AB001750RABE1_MOUSEO35551
AB001750RABE1_MOUSEO35551-2
AB001750RABE1_MOUSEO35551-3
AB001750RABE1_MOUSEO35551-4

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