Schema for gnfAtlas2Distance
  Database: mm9    Primary Table: gnfAtlas2Distance    Row Count: 38,744,000   Data last updated: 2011-03-03
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query uc007otg.1varchar(255) Query gene. Indexed
target uc007otg.1varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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

Sample Rows
 
querytargetdistance
uc007otg.1uc007otg.10
uc007otg.1uc007otf.10
uc007otg.1uc011yqd.10
uc007otg.1uc007ote.10
uc007otg.1uc007icu.10.215197
uc007otg.1uc009elb.20.21918
uc007otg.1uc009ela.20.21918
uc007otg.1uc012hgs.10.219869
uc007otg.1uc009tce.20.219869
uc007otg.1uc008kpw.10.225738

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