Schema for gnfAtlas2Distance
  Database: rn3    Primary Table: gnfAtlas2Distance    Row Count: 4,472,000   Data last updated: 2004-05-27
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query L17127varchar(255) Query gene. Indexed
target L17127varchar(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)
      rn3.dmBlastTab.query (via gnfAtlas2Distance.query)
      rn3.drBlastTab.query (via gnfAtlas2Distance.query)
      rn3.dupSpMrna.mrnaID (via gnfAtlas2Distance.query)
      rn3.hgBlastTab.query (via gnfAtlas2Distance.query)
      rn3.keggPathway.kgID (via gnfAtlas2Distance.query)
      rn3.kgAlias.kgID (via gnfAtlas2Distance.query)
      rn3.kgProtAlias.kgID (via gnfAtlas2Distance.query)
      rn3.kgSpAlias.kgID (via gnfAtlas2Distance.query)
      rn3.kgXref.kgID (via gnfAtlas2Distance.query)
      rn3.knownBlastTab.query (via gnfAtlas2Distance.query)
      rn3.knownBlastTab.target (via gnfAtlas2Distance.query)
      rn3.knownCanonical.transcript (via gnfAtlas2Distance.query)
      rn3.knownGene.name (via gnfAtlas2Distance.query)
      rn3.knownGeneLink.name (via gnfAtlas2Distance.query)
      rn3.knownGeneMrna.name (via gnfAtlas2Distance.query)
      rn3.knownGenePep.name (via gnfAtlas2Distance.query)
      rn3.knownIsoforms.transcript (via gnfAtlas2Distance.query)
      rn3.knownToEnsembl.name (via gnfAtlas2Distance.query)
      rn3.knownToGnfAtlas2.name (via gnfAtlas2Distance.query)
      rn3.knownToLocusLink.name (via gnfAtlas2Distance.query)
      rn3.knownToPfam.name (via gnfAtlas2Distance.query)
      rn3.knownToRefSeq.name (via gnfAtlas2Distance.query)
      rn3.knownToSuper.gene (via gnfAtlas2Distance.query)
      rn3.scBlastTab.query (via gnfAtlas2Distance.query)

Sample Rows
 
querytargetdistance
L17127L171270
L17127D107550.333977
L17127D107560.391636
L17127BC0605750.391636
L17127J026500.413886
L17127X064830.426477
L17127BC0615620.426477
L17127D218000.427341
L17127X527830.4315
L17127J028970.438159

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