Schema for kgColor
  Database: mm9    Primary Table: kgColor    Row Count: 55,419   Data last updated: 2011-03-02
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc007afh.1varchar(255) values Known gene ID
r 80tinyint(3) unsigned range Red component 0-255
g 80tinyint(3) unsigned range Green component 0-255
b 160tinyint(3) unsigned range Blue component 0-255

Connected Tables and Joining Fields
        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)
      mm9.affyGnfU74ADistance.query (via kgColor.kgID)
      mm9.affyGnfU74ADistance.target (via kgColor.kgID)
      mm9.affyGnfU74BDistance.query (via kgColor.kgID)
      mm9.affyGnfU74BDistance.target (via kgColor.kgID)
      mm9.affyGnfU74CDistance.query (via kgColor.kgID)
      mm9.affyGnfU74CDistance.target (via kgColor.kgID)
      mm9.bioCycPathway.kgID (via kgColor.kgID)
      mm9.ccdsKgMap.geneId (via kgColor.kgID)
      mm9.ceBlastTab.query (via kgColor.kgID)
      mm9.dmBlastTab.query (via kgColor.kgID)
      mm9.drBlastTab.query (via kgColor.kgID)
      mm9.foldUtr3.name (via kgColor.kgID)
      mm9.foldUtr5.name (via kgColor.kgID)
      mm9.gnfAtlas2Distance.query (via kgColor.kgID)
      mm9.gnfAtlas2Distance.target (via kgColor.kgID)
      mm9.hgBlastTab.query (via kgColor.kgID)
      mm9.keggPathway.kgID (via kgColor.kgID)
      mm9.kgAlias.kgID (via kgColor.kgID)
      mm9.kgProtAlias.kgID (via kgColor.kgID)
      mm9.kgProtMap2.qName (via kgColor.kgID)
      mm9.kgSpAlias.kgID (via kgColor.kgID)
      mm9.kgTargetAli.qName (via kgColor.kgID)
      mm9.kgTxInfo.name (via kgColor.kgID)
      mm9.kgXref.kgID (via kgColor.kgID)
      mm9.knownBlastTab.query (via kgColor.kgID)
      mm9.knownBlastTab.target (via kgColor.kgID)
      mm9.knownCanonical.protein (via kgColor.kgID)
      mm9.knownCanonical.transcript (via kgColor.kgID)
      mm9.knownGene.name (via kgColor.kgID)
      mm9.knownGeneMrna.name (via kgColor.kgID)
      mm9.knownGenePep.name (via kgColor.kgID)
      mm9.knownIsoforms.transcript (via kgColor.kgID)
      mm9.knownToAllenBrain.name (via kgColor.kgID)
      mm9.knownToEnsembl.name (via kgColor.kgID)
      mm9.knownToGnfAtlas2.name (via kgColor.kgID)
      mm9.knownToKeggEntrez.name (via kgColor.kgID)
      mm9.knownToLocusLink.name (via kgColor.kgID)
      mm9.knownToPfam.name (via kgColor.kgID)
      mm9.knownToRefSeq.name (via kgColor.kgID)
      mm9.knownToSuper.gene (via kgColor.kgID)
      mm9.knownToVisiGene.name (via kgColor.kgID)
      mm9.rnBlastTab.query (via kgColor.kgID)
      mm9.scBlastTab.query (via kgColor.kgID)
      mm9.ucscScop.ucscId (via kgColor.kgID)

Sample Rows
 
kgIDrgb
uc007afh.18080160
uc007afg.1130130210
uc007afi.21212120
uc011wht.11212120
uc011whu.11212120
uc007afn.18080160
uc007afm.1130130210
uc007afo.18080160
uc007afp.1130130210
uc007afq.1130130210

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