Schema for flyP2P
  Database: dm2    Primary Table: flyP2P    Row Count: 2,001,243   Data last updated: 2006-02-06
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query CG2759-RAvarchar(255) Query gene. Indexed
target CG2759-RAvarchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

Connected Tables and Joining Fields
        dm2.arbExpDistance.query (via flyP2P.query)
      dm2.arbExpDistance.target (via flyP2P.query)
      dm2.ceBlastTab.query (via flyP2P.query)
      dm2.drBlastTab.query (via flyP2P.query)
      dm2.flyBase2004Xref.name (via flyP2P.query)
      dm2.flyBaseBlastTab.query (via flyP2P.query)
      dm2.flyBaseBlastTab.target (via flyP2P.query)
      dm2.flyBaseCanonical.transcript (via flyP2P.query)
      dm2.flyBaseGene.name (via flyP2P.query)
      dm2.flyBaseIsoforms.transcript (via flyP2P.query)
      dm2.flyBaseNoncoding.name (via flyP2P.query)
      dm2.flyBasePep.name (via flyP2P.query)
      dm2.flyBaseToCG.name (via flyP2P.query)
      dm2.flyBaseToDescription.name (via flyP2P.query)
      dm2.flyBaseToPfam.name (via flyP2P.query)
      dm2.flyBaseToRefSeq.name (via flyP2P.query)
      dm2.flyBaseToUniProt.name (via flyP2P.query)
      dm2.hgBlastTab.query (via flyP2P.query)
      dm2.mmBlastTab.query (via flyP2P.query)
      dm2.rnBlastTab.query (via flyP2P.query)
      dm2.scBlastTab.query (via flyP2P.query)

Sample Rows
 
querytargetdistance
CG2759-RACG2759-RA0
CG2759-RACG7803-RA1
CG2759-RACG8573-RB1
CG2759-RACG8573-RA1
CG2759-RACG3757-RA1
CG2759-RACG3936-RA2
CG2759-RACG6502-RA1
CG2759-RACG4654-RB2
CG2759-RACG4654-RA2
CG2759-RACG6376-RC2

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