Schema for kgColor
Database: hg19    Primary Table: kgColor    Row Count: 77,614
Format description: What color to draw known gene in?
fieldexampleSQL type info description
kgID uc001aaa.3varchar(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
      hg19.bioCycPathway.kgID (via kgColor.kgID)
      hg19.ccdsKgMap.geneId (via kgColor.kgID)
      hg19.ceBlastTab.query (via kgColor.kgID)
      hg19.dmBlastTab.query (via kgColor.kgID)
      hg19.drBlastTab.query (via kgColor.kgID)
      hg19.foldUtr3.name (via kgColor.kgID)
      hg19.foldUtr5.name (via kgColor.kgID)
      hg19.gnfAtlas2Distance.query (via kgColor.kgID)
      hg19.gnfAtlas2Distance.target (via kgColor.kgID)
      hg19.humanHprdP2P.query (via kgColor.kgID)
      hg19.humanHprdP2P.target (via kgColor.kgID)
      hg19.humanVidalP2P.query (via kgColor.kgID)
      hg19.humanVidalP2P.target (via kgColor.kgID)
      hg19.humanWankerP2P.query (via kgColor.kgID)
      hg19.humanWankerP2P.target (via kgColor.kgID)
      hg19.keggPathway.kgID (via kgColor.kgID)
      hg19.kg4ToKg5.newId (via kgColor.kgID)
      hg19.kgAlias.kgID (via kgColor.kgID)
      hg19.kgProtAlias.kgID (via kgColor.kgID)
      hg19.kgProtMap2.qName (via kgColor.kgID)
      hg19.kgSpAlias.kgID (via kgColor.kgID)
      hg19.kgTargetAli.qName (via kgColor.kgID)
      hg19.kgTxInfo.name (via kgColor.kgID)
      hg19.kgXref.kgID (via kgColor.kgID)
      hg19.knownBlastTab.query (via kgColor.kgID)
      hg19.knownBlastTab.target (via kgColor.kgID)
      hg19.knownCanonical.protein (via kgColor.kgID)
      hg19.knownCanonical.transcript (via kgColor.kgID)
      hg19.knownGene.name (via kgColor.kgID)
      hg19.knownGeneMrna.name (via kgColor.kgID)
      hg19.knownGenePep.name (via kgColor.kgID)
      hg19.knownIsoforms.transcript (via kgColor.kgID)
      hg19.knownToAllenBrain.name (via kgColor.kgID)
      hg19.knownToEnsembl.name (via kgColor.kgID)
      hg19.knownToGnfAtlas2.name (via kgColor.kgID)
      hg19.knownToHprd.name (via kgColor.kgID)
      hg19.knownToLocusLink.name (via kgColor.kgID)
      hg19.knownToPfam.name (via kgColor.kgID)
      hg19.knownToRefSeq.name (via kgColor.kgID)
      hg19.knownToSuper.gene (via kgColor.kgID)
      hg19.knownToTreefam.name (via kgColor.kgID)
      hg19.knownToU133.name (via kgColor.kgID)
      hg19.knownToVisiGene.name (via kgColor.kgID)
      hg19.mmBlastTab.query (via kgColor.kgID)
      hg19.rnBlastTab.query (via kgColor.kgID)
      hg19.scBlastTab.query (via kgColor.kgID)
Sample Rows
kgIDrgb
uc001aaa.3130130210
uc010nxq.1130130210
uc010nxr.1130130210
uc001aal.18080160
uc001aaq.1130130210
uc001aar.1130130210
uc001aav.3130130210
uc001aau.2130130210
uc009vjk.2130130210
uc010nxu.18080160

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