Schema for kgColor
  Database: hg18    Primary Table: kgColor    Row Count: 66,803   Data last updated: 2009-03-03
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc001aaa.2varchar(255) values Known gene ID
r 130tinyint(3) unsigned range Red component 0-255
g 130tinyint(3) unsigned range Green component 0-255
b 210tinyint(3) unsigned range Blue component 0-255

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via kgColor.kgID)
      hg18.ccdsKgMap.geneId (via kgColor.kgID)
      hg18.ceBlastTab.query (via kgColor.kgID)
      hg18.dmBlastTab.query (via kgColor.kgID)
      hg18.drBlastTab.query (via kgColor.kgID)
      hg18.foldUtr3.name (via kgColor.kgID)
      hg18.foldUtr5.name (via kgColor.kgID)
      hg18.gnfAtlas2Distance.query (via kgColor.kgID)
      hg18.gnfAtlas2Distance.target (via kgColor.kgID)
      hg18.gnfU95Distance.query (via kgColor.kgID)
      hg18.gnfU95Distance.target (via kgColor.kgID)
      hg18.humanHprdP2P.query (via kgColor.kgID)
      hg18.humanHprdP2P.target (via kgColor.kgID)
      hg18.humanVidalP2P.query (via kgColor.kgID)
      hg18.humanVidalP2P.target (via kgColor.kgID)
      hg18.humanWankerP2P.query (via kgColor.kgID)
      hg18.humanWankerP2P.target (via kgColor.kgID)
      hg18.keggPathway.kgID (via kgColor.kgID)
      hg18.kgAlias.kgID (via kgColor.kgID)
      hg18.kgProtAlias.kgID (via kgColor.kgID)
      hg18.kgProtMap2.qName (via kgColor.kgID)
      hg18.kgSpAlias.kgID (via kgColor.kgID)
      hg18.kgTargetAli.qName (via kgColor.kgID)
      hg18.kgTxInfo.name (via kgColor.kgID)
      hg18.kgXref.kgID (via kgColor.kgID)
      hg18.knownBlastTab.query (via kgColor.kgID)
      hg18.knownBlastTab.target (via kgColor.kgID)
      hg18.knownCanonToDecipher.name (via kgColor.kgID)
      hg18.knownCanonical.protein (via kgColor.kgID)
      hg18.knownCanonical.transcript (via kgColor.kgID)
      hg18.knownGene.name (via kgColor.kgID)
      hg18.knownGeneMrna.name (via kgColor.kgID)
      hg18.knownGenePep.name (via kgColor.kgID)
      hg18.knownIsoforms.transcript (via kgColor.kgID)
      hg18.knownToAllenBrain.name (via kgColor.kgID)
      hg18.knownToDecipher.name (via kgColor.kgID)
      hg18.knownToEnsembl.name (via kgColor.kgID)
      hg18.knownToGnf1h.name (via kgColor.kgID)
      hg18.knownToGnfAtlas2.name (via kgColor.kgID)
      hg18.knownToHInv.name (via kgColor.kgID)
      hg18.knownToHprd.name (via kgColor.kgID)
      hg18.knownToKeggEntrez.name (via kgColor.kgID)
      hg18.knownToLocusLink.name (via kgColor.kgID)
      hg18.knownToMupit.name (via kgColor.kgID)
      hg18.knownToPfam.name (via kgColor.kgID)
      hg18.knownToRefSeq.name (via kgColor.kgID)
      hg18.knownToSuper.gene (via kgColor.kgID)
      hg18.knownToTreefam.name (via kgColor.kgID)
      hg18.knownToU133.name (via kgColor.kgID)
      hg18.knownToU133Plus2.name (via kgColor.kgID)
      hg18.knownToU95.name (via kgColor.kgID)
      hg18.knownToVisiGene.name (via kgColor.kgID)
      hg18.mmBlastTab.query (via kgColor.kgID)
      hg18.rnBlastTab.query (via kgColor.kgID)
      hg18.scBlastTab.query (via kgColor.kgID)
      hg18.ucscScop.ucscId (via kgColor.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgColor.kgID)
      knownGeneV39.ceBlastTab.query (via kgColor.kgID)
      knownGeneV39.dmBlastTab.query (via kgColor.kgID)
      knownGeneV39.drBlastTab.query (via kgColor.kgID)
      knownGeneV39.foldUtr3.name (via kgColor.kgID)
      knownGeneV39.foldUtr5.name (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgColor.kgID)
      knownGeneV39.kgAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgColor.kgID (via kgColor.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgTargetAli.qName (via kgColor.kgID)
      knownGeneV39.kgXref.kgID (via kgColor.kgID)
      knownGeneV39.knownAttrs.kgID (via kgColor.kgID)
      knownGeneV39.knownBlastTab.query (via kgColor.kgID)
      knownGeneV39.knownBlastTab.target (via kgColor.kgID)
      knownGeneV39.knownCanonical.protein (via kgColor.kgID)
      knownGeneV39.knownCanonical.transcript (via kgColor.kgID)
      knownGeneV39.knownCds.name (via kgColor.kgID)
      knownGeneV39.knownGene.name (via kgColor.kgID)
      knownGeneV39.knownGeneMrna.name (via kgColor.kgID)
      knownGeneV39.knownGenePep.name (via kgColor.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgColor.kgID)
      knownGeneV39.knownToEnsembl.name (via kgColor.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgColor.kgID)
      knownGeneV39.knownToHprd.name (via kgColor.kgID)
      knownGeneV39.knownToLocusLink.name (via kgColor.kgID)
      knownGeneV39.knownToMrna.name (via kgColor.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgColor.kgID)
      knownGeneV39.knownToMupit.name (via kgColor.kgID)
      knownGeneV39.knownToPfam.name (via kgColor.kgID)
      knownGeneV39.knownToRefSeq.name (via kgColor.kgID)
      knownGeneV39.knownToSuper.gene (via kgColor.kgID)
      knownGeneV39.knownToTag.name (via kgColor.kgID)
      knownGeneV39.knownToU133.name (via kgColor.kgID)
      knownGeneV39.knownToU95.name (via kgColor.kgID)
      knownGeneV39.knownToVisiGene.name (via kgColor.kgID)
      knownGeneV39.knownToWikipedia.name (via kgColor.kgID)
      knownGeneV39.mmBlastTab.query (via kgColor.kgID)
      knownGeneV39.rnBlastTab.query (via kgColor.kgID)
      knownGeneV39.scBlastTab.query (via kgColor.kgID)
      knownGeneV39.ucscScop.ucscId (via kgColor.kgID)

Sample Rows
 
kgIDrgb
uc001aaa.2130130210
uc009vip.1130130210
uc009vjg.1130130210
uc001aal.11212120
uc009vjh.1130130210
uc001aaq.1130130210
uc001aar.1130130210
uc001aas.1130130210
uc001aat.1130130210
uc001aau.1130130210

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