Schema for gnfU95Distance
  Database: hg19    Primary Table: gnfU95Distance    Row Count: 32,235,000   Data last updated: 2013-06-14
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query uc003zvs.4varchar(255) Name of one gene
target uc011los.2varchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

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

Sample Rows
 
querytargetdistance
uc003zvs.4uc011los.20
uc003zvs.4uc003zvt.30
uc003zvs.4uc003zvs.40
uc003zvs.4uc001zvj.30.571532
uc003zvs.4uc021tpa.10.578681
uc003zvs.4uc010cmd.30.578681
uc003zvs.4uc002gfp.30.578681
uc003zvs.4uc009wvl.30.582383
uc003zvs.4uc009wvk.30.582383
uc003zvs.4uc010plj.20.582383

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