Skip to main content
Schema for knownExpDistance
  Database: hg17    Primary Table: knownExpDistance    Row Count: 32,965,000   Data last updated: 2005-06-04
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query AY341936varchar(255) Name of one gene
target AY341936varchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

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

Sample Rows
 
querytargetdistance
AY341936AY3419360
AY341936NM_1829050
AY341936AY2173470
AY341936BC0739130
AY341936BC0636820
AY341936AK0741370.338232
AY341936NM_1736180.338232
AY341936NM_0180320.345585
AY341936BC0637920.372672
AY341936BC0517630.372672

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