Schema for kgProtAlias
  Database: hg18    Primary Table: kgProtAlias    Row Count: 281,556   Data last updated: 2009-03-03
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc001aal.1varchar(255) values Known Gene ID
displayID Q8NH21varchar(255) values protein display ID
alias NP_001005484varchar(255) values a protein alias

Connected Tables and Joining Fields
        hg18.kgSpAlias.alias (via kgProtAlias.alias)
      hg18.kgXref.protAcc (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      hg18.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg18.ccdsKgMap.geneId (via kgProtAlias.kgID)
      hg18.ceBlastTab.query (via kgProtAlias.kgID)
      hg18.dmBlastTab.query (via kgProtAlias.kgID)
      hg18.drBlastTab.query (via kgProtAlias.kgID)
      hg18.foldUtr3.name (via kgProtAlias.kgID)
      hg18.foldUtr5.name (via kgProtAlias.kgID)
      hg18.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      hg18.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      hg18.gnfU95Distance.query (via kgProtAlias.kgID)
      hg18.gnfU95Distance.target (via kgProtAlias.kgID)
      hg18.humanHprdP2P.query (via kgProtAlias.kgID)
      hg18.humanHprdP2P.target (via kgProtAlias.kgID)
      hg18.humanVidalP2P.query (via kgProtAlias.kgID)
      hg18.humanVidalP2P.target (via kgProtAlias.kgID)
      hg18.humanWankerP2P.query (via kgProtAlias.kgID)
      hg18.humanWankerP2P.target (via kgProtAlias.kgID)
      hg18.keggPathway.kgID (via kgProtAlias.kgID)
      hg18.kgAlias.kgID (via kgProtAlias.kgID)
      hg18.kgColor.kgID (via kgProtAlias.kgID)
      hg18.kgProtMap2.qName (via kgProtAlias.kgID)
      hg18.kgSpAlias.kgID (via kgProtAlias.kgID)
      hg18.kgTargetAli.qName (via kgProtAlias.kgID)
      hg18.kgTxInfo.name (via kgProtAlias.kgID)
      hg18.kgXref.kgID (via kgProtAlias.kgID)
      hg18.knownBlastTab.query (via kgProtAlias.kgID)
      hg18.knownBlastTab.target (via kgProtAlias.kgID)
      hg18.knownCanonToDecipher.name (via kgProtAlias.kgID)
      hg18.knownCanonical.protein (via kgProtAlias.kgID)
      hg18.knownCanonical.transcript (via kgProtAlias.kgID)
      hg18.knownGene.name (via kgProtAlias.kgID)
      hg18.knownGeneMrna.name (via kgProtAlias.kgID)
      hg18.knownGenePep.name (via kgProtAlias.kgID)
      hg18.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg18.knownToAllenBrain.name (via kgProtAlias.kgID)
      hg18.knownToDecipher.name (via kgProtAlias.kgID)
      hg18.knownToEnsembl.name (via kgProtAlias.kgID)
      hg18.knownToGnf1h.name (via kgProtAlias.kgID)
      hg18.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg18.knownToHInv.name (via kgProtAlias.kgID)
      hg18.knownToHprd.name (via kgProtAlias.kgID)
      hg18.knownToKeggEntrez.name (via kgProtAlias.kgID)
      hg18.knownToLocusLink.name (via kgProtAlias.kgID)
      hg18.knownToMupit.name (via kgProtAlias.kgID)
      hg18.knownToPfam.name (via kgProtAlias.kgID)
      hg18.knownToRefSeq.name (via kgProtAlias.kgID)
      hg18.knownToSuper.gene (via kgProtAlias.kgID)
      hg18.knownToTreefam.name (via kgProtAlias.kgID)
      hg18.knownToU133.name (via kgProtAlias.kgID)
      hg18.knownToU133Plus2.name (via kgProtAlias.kgID)
      hg18.knownToU95.name (via kgProtAlias.kgID)
      hg18.knownToVisiGene.name (via kgProtAlias.kgID)
      hg18.mmBlastTab.query (via kgProtAlias.kgID)
      hg18.rnBlastTab.query (via kgProtAlias.kgID)
      hg18.scBlastTab.query (via kgProtAlias.kgID)
      hg18.ucscScop.ucscId (via kgProtAlias.kgID)
      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)

Sample Rows
 
kgIDdisplayIDalias
uc001aal.1Q8NH21NP_001005484
uc001aal.1Q8NH21OR4F5
uc001aal.1Q8NH21OR4F5_HUMAN
uc001aal.1Q8NH21Q5VT22
uc001aal.1Q8NH21Q8NH21
uc001aaw.1Q6IEY1NP_001005277
uc001aaw.1Q6IEY1OR4F16
uc001aaw.1Q6IEY1OR4F29
uc001aaw.1Q6IEY1OR4F3
uc001aaw.1Q6IEY1OR4F3_HUMAN

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