Schema for knownToHprd
Database: hg19    Primary Table: knownToHprd    Row Count: 46,396
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name uc001aal.1varchar(255) values primary ID
value 14974varchar(255) values associated ID, label, quantity etc.
Connected Tables and Joining Fields
      hg19.bioCycPathway.kgID (via knownToHprd.name)
      hg19.ccdsKgMap.geneId (via knownToHprd.name)
      hg19.ceBlastTab.query (via knownToHprd.name)
      hg19.dmBlastTab.query (via knownToHprd.name)
      hg19.drBlastTab.query (via knownToHprd.name)
      hg19.foldUtr3.name (via knownToHprd.name)
      hg19.foldUtr5.name (via knownToHprd.name)
      hg19.gnfAtlas2Distance.query (via knownToHprd.name)
      hg19.gnfAtlas2Distance.target (via knownToHprd.name)
      hg19.humanHprdP2P.query (via knownToHprd.name)
      hg19.humanHprdP2P.target (via knownToHprd.name)
      hg19.humanVidalP2P.query (via knownToHprd.name)
      hg19.humanVidalP2P.target (via knownToHprd.name)
      hg19.humanWankerP2P.query (via knownToHprd.name)
      hg19.humanWankerP2P.target (via knownToHprd.name)
      hg19.keggPathway.kgID (via knownToHprd.name)
      hg19.kg4ToKg5.newId (via knownToHprd.name)
      hg19.kgAlias.kgID (via knownToHprd.name)
      hg19.kgColor.kgID (via knownToHprd.name)
      hg19.kgProtAlias.kgID (via knownToHprd.name)
      hg19.kgProtMap2.qName (via knownToHprd.name)
      hg19.kgSpAlias.kgID (via knownToHprd.name)
      hg19.kgTargetAli.qName (via knownToHprd.name)
      hg19.kgTxInfo.name (via knownToHprd.name)
      hg19.kgXref.kgID (via knownToHprd.name)
      hg19.knownBlastTab.query (via knownToHprd.name)
      hg19.knownBlastTab.target (via knownToHprd.name)
      hg19.knownCanonical.protein (via knownToHprd.name)
      hg19.knownCanonical.transcript (via knownToHprd.name)
      hg19.knownGene.name (via knownToHprd.name)
      hg19.knownGeneMrna.name (via knownToHprd.name)
      hg19.knownGenePep.name (via knownToHprd.name)
      hg19.knownIsoforms.transcript (via knownToHprd.name)
      hg19.knownToAllenBrain.name (via knownToHprd.name)
      hg19.knownToEnsembl.name (via knownToHprd.name)
      hg19.knownToGnfAtlas2.name (via knownToHprd.name)
      hg19.knownToLocusLink.name (via knownToHprd.name)
      hg19.knownToPfam.name (via knownToHprd.name)
      hg19.knownToRefSeq.name (via knownToHprd.name)
      hg19.knownToSuper.gene (via knownToHprd.name)
      hg19.knownToTreefam.name (via knownToHprd.name)
      hg19.knownToU133.name (via knownToHprd.name)
      hg19.knownToVisiGene.name (via knownToHprd.name)
      hg19.mmBlastTab.query (via knownToHprd.name)
      hg19.rnBlastTab.query (via knownToHprd.name)
      hg19.scBlastTab.query (via knownToHprd.name)
Sample Rows
namevalue
uc001aal.114974
uc001abw.110081
uc001abx.110081
uc001aby.313166
uc001abz.313166
uc001aca.113926
uc001acd.213190
uc001ace.213190
uc001aci.216273
uc001acj.300958

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