Schema for rankProp
  Database: hg17    Primary Table: rankProp    Row Count: 62,427,912   Data last updated: 2005-07-15
Format description: RankProp protein ranking for a pair of proteins
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_023008varchar(255) known genes id of query protein
target AX785390varchar(255) known genes id of target protein
score 0.521427float rankp score

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

Sample Rows
 
querytargetscore
NM_023008AX7853900.521427
AX785390NM_0230080.521427
NM_178159AX7853900.521427
AX785390NM_1781590.521427
NM_023008NM_0051030.52143
NM_005103NM_0230080.52143
NM_023008NM_0225490.52143
NM_022549NM_0230080.52143
NM_178159NM_0051030.52143
NM_005103NM_1781590.52143

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