Schema for affyGnfU74CDistance
  Database: mm7    Primary Table: affyGnfU74CDistance    Row Count: 2,130,000   Data last updated: 2005-11-17
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_173868varchar(255) Query gene. Indexed
target NM_173868varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.ceBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.dmBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.drBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.foldUtr3.name (via affyGnfU74CDistance.query)
      knownGeneV39.foldUtr5.name (via affyGnfU74CDistance.query)
      knownGeneV39.gnfAtlas2Distance.query (via affyGnfU74CDistance.query)
      knownGeneV39.gnfAtlas2Distance.target (via affyGnfU74CDistance.query)
      knownGeneV39.kgAlias.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.kgColor.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.kgProtAlias.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.kgSpAlias.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.kgTargetAli.qName (via affyGnfU74CDistance.query)
      knownGeneV39.kgXref.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.knownAttrs.kgID (via affyGnfU74CDistance.query)
      knownGeneV39.knownBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.knownBlastTab.target (via affyGnfU74CDistance.query)
      knownGeneV39.knownCanonical.protein (via affyGnfU74CDistance.query)
      knownGeneV39.knownCanonical.transcript (via affyGnfU74CDistance.query)
      knownGeneV39.knownCds.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownGene.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownGeneMrna.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownGenePep.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownIsoforms.transcript (via affyGnfU74CDistance.query)
      knownGeneV39.knownToEnsembl.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToGnfAtlas2.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToHprd.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToLocusLink.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToMrna.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToMrnaSingle.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToMupit.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToPfam.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToRefSeq.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToSuper.gene (via affyGnfU74CDistance.query)
      knownGeneV39.knownToTag.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToU133.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToU95.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToVisiGene.name (via affyGnfU74CDistance.query)
      knownGeneV39.knownToWikipedia.name (via affyGnfU74CDistance.query)
      knownGeneV39.mmBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.rnBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.scBlastTab.query (via affyGnfU74CDistance.query)
      knownGeneV39.ucscScop.ucscId (via affyGnfU74CDistance.query)
      mm7.affyGnfU74ADistance.query (via affyGnfU74CDistance.query)
      mm7.affyGnfU74ADistance.target (via affyGnfU74CDistance.query)
      mm7.affyGnfU74BDistance.query (via affyGnfU74CDistance.query)
      mm7.affyGnfU74BDistance.target (via affyGnfU74CDistance.query)
      mm7.dmBlastTab.query (via affyGnfU74CDistance.query)
      mm7.drBlastTab.query (via affyGnfU74CDistance.query)
      mm7.dupSpMrna.mrnaID (via affyGnfU74CDistance.query)
      mm7.foldUtr3.name (via affyGnfU74CDistance.query)
      mm7.foldUtr5.name (via affyGnfU74CDistance.query)
      mm7.gnfAtlas2Distance.query (via affyGnfU74CDistance.query)
      mm7.gnfAtlas2Distance.target (via affyGnfU74CDistance.query)
      mm7.hgBlastTab.query (via affyGnfU74CDistance.query)
      mm7.keggPathway.kgID (via affyGnfU74CDistance.query)
      mm7.kgAlias.kgID (via affyGnfU74CDistance.query)
      mm7.kgProtAlias.kgID (via affyGnfU74CDistance.query)
      mm7.kgSpAlias.kgID (via affyGnfU74CDistance.query)
      mm7.kgXref.kgID (via affyGnfU74CDistance.query)
      mm7.knownBlastTab.query (via affyGnfU74CDistance.query)
      mm7.knownBlastTab.target (via affyGnfU74CDistance.query)
      mm7.knownCanonical.transcript (via affyGnfU74CDistance.query)
      mm7.knownGene.name (via affyGnfU74CDistance.query)
      mm7.knownGeneLink.name (via affyGnfU74CDistance.query)
      mm7.knownGeneMrna.name (via affyGnfU74CDistance.query)
      mm7.knownGenePep.name (via affyGnfU74CDistance.query)
      mm7.knownIsoforms.transcript (via affyGnfU74CDistance.query)
      mm7.knownToAllenBrain.name (via affyGnfU74CDistance.query)
      mm7.knownToEnsembl.name (via affyGnfU74CDistance.query)
      mm7.knownToGnfAtlas2.name (via affyGnfU74CDistance.query)
      mm7.knownToKeggEntrez.name (via affyGnfU74CDistance.query)
      mm7.knownToLocusLink.name (via affyGnfU74CDistance.query)
      mm7.knownToPfam.name (via affyGnfU74CDistance.query)
      mm7.knownToRefSeq.name (via affyGnfU74CDistance.query)
      mm7.knownToVisiGene.name (via affyGnfU74CDistance.query)
      mm7.rnBlastTab.query (via affyGnfU74CDistance.query)
      mm7.scBlastTab.query (via affyGnfU74CDistance.query)

Sample Rows
 
querytargetdistance
NM_173868NM_1738680
NM_173868NM_1445570.597561
NM_173868NM_1831560.619989
NM_173868NM_1392930.639217
NM_173868AF4895710.639217
NM_173868AF4895690.639217
NM_173868AF4895700.639217
NM_173868NM_1451230.645707
NM_173868NM_0281120.651781
NM_173868NM_1781430.654369

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