Schema for kgProtAlias
  Database: hg19    Primary Table: kgProtAlias    Row Count: 412,741   Data last updated: 2013-06-14
Format description: Link together a Known Gene ID and a protein alias
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
        hg19.kgSpAlias.alias (via kgProtAlias.alias)
      hg19.kgXref.protAcc (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      hg19.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg19.ccdsKgMap.geneId (via kgProtAlias.kgID)
      hg19.ceBlastTab.query (via kgProtAlias.kgID)
      hg19.dmBlastTab.query (via kgProtAlias.kgID)
      hg19.drBlastTab.query (via kgProtAlias.kgID)
      hg19.foldUtr3.name (via kgProtAlias.kgID)
      hg19.foldUtr5.name (via kgProtAlias.kgID)
      hg19.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      hg19.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      hg19.gnfU95Distance.query (via kgProtAlias.kgID)
      hg19.gnfU95Distance.target (via kgProtAlias.kgID)
      hg19.humanHprdP2P.query (via kgProtAlias.kgID)
      hg19.humanHprdP2P.target (via kgProtAlias.kgID)
      hg19.humanVidalP2P.query (via kgProtAlias.kgID)
      hg19.humanVidalP2P.target (via kgProtAlias.kgID)
      hg19.humanWankerP2P.query (via kgProtAlias.kgID)
      hg19.humanWankerP2P.target (via kgProtAlias.kgID)
      hg19.keggPathway.kgID (via kgProtAlias.kgID)
      hg19.kgAlias.kgID (via kgProtAlias.kgID)
      hg19.kgColor.kgID (via kgProtAlias.kgID)
      hg19.kgProtMap2.qName (via kgProtAlias.kgID)
      hg19.kgSpAlias.kgID (via kgProtAlias.kgID)
      hg19.kgTargetAli.qName (via kgProtAlias.kgID)
      hg19.kgTxInfo.name (via kgProtAlias.kgID)
      hg19.kgXref.kgID (via kgProtAlias.kgID)
      hg19.knownBlastTab.query (via kgProtAlias.kgID)
      hg19.knownBlastTab.target (via kgProtAlias.kgID)
      hg19.knownCanonToDecipher.name (via kgProtAlias.kgID)
      hg19.knownCanonical.transcript (via kgProtAlias.kgID)
      hg19.knownGene.name (via kgProtAlias.kgID)
      hg19.knownGeneMrna.name (via kgProtAlias.kgID)
      hg19.knownGenePep.name (via kgProtAlias.kgID)
      hg19.knownGeneTxMrna.name (via kgProtAlias.kgID)
      hg19.knownGeneTxPep.name (via kgProtAlias.kgID)
      hg19.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg19.knownToAllenBrain.name (via kgProtAlias.kgID)
      hg19.knownToDecipher.name (via kgProtAlias.kgID)
      hg19.knownToEnsembl.name (via kgProtAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg19.knownToHInv.name (via kgProtAlias.kgID)
      hg19.knownToHprd.name (via kgProtAlias.kgID)
      hg19.knownToKeggEntrez.name (via kgProtAlias.kgID)
      hg19.knownToLocusLink.name (via kgProtAlias.kgID)
      hg19.knownToLynx.name (via kgProtAlias.kgID)
      hg19.knownToMupit.name (via kgProtAlias.kgID)
      hg19.knownToNextProt.name (via kgProtAlias.kgID)
      hg19.knownToPfam.name (via kgProtAlias.kgID)
      hg19.knownToRefSeq.name (via kgProtAlias.kgID)
      hg19.knownToSuper.gene (via kgProtAlias.kgID)
      hg19.knownToTreefam.name (via kgProtAlias.kgID)
      hg19.knownToU133.name (via kgProtAlias.kgID)
      hg19.knownToU133Plus2.name (via kgProtAlias.kgID)
      hg19.knownToU95.name (via kgProtAlias.kgID)
      hg19.knownToVisiGene.name (via kgProtAlias.kgID)
      hg19.knownToWikipedia.name (via kgProtAlias.kgID)
      hg19.mmBlastTab.query (via kgProtAlias.kgID)
      hg19.rnBlastTab.query (via kgProtAlias.kgID)
      hg19.scBlastTab.query (via kgProtAlias.kgID)
      hg19.ucscScop.ucscId (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
uc001aal.1Q8NH21NP_001005484
uc001aal.1Q8NH21OR4F5
uc001aal.1Q8NH21OR4F5_HUMAN
uc001aal.1Q8NH21Q5VT22
uc001aal.1Q8NH21Q8NH21
uc001aau.3C9J4L2C9J4L2
uc001aau.3C9J4L2C9J4L2_HUMAN
uc001aau.3C9J4L2LOC100132062
uc001abe.4B4DGA0B4DGA0
uc001abe.4B4DGA0B4DGA0_HUMAN

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