Schema for knownExpDistance
  Database: hg17    Primary Table: knownExpDistance    Row Count: 32,965,000   Data last updated: 2005-06-04
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query AY341936varchar(255) Query gene. Indexed
target AY341936varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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.