Schema for flyBaseToDescription
  Database: dm3    Primary Table: flyBaseToDescription    Row Count: 19,522   Data last updated: 2008-10-24
On download server: MariaDB table dump directory
fieldexampleSQL type info
name CG00000-RAvarchar(255) values
val GH15984p (CG00000-PA, isofo...longtext values

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

Sample Rows
 
nameval
CG00000-RAGH15984p (CG00000-PA, isoform A) (CG00000-PB, isoform B).
CG00000-RBGH15984p (CG00000-PA, isoform A) (CG00000-PB, isoform B).
CG10000-RAPutative polypeptide N-acetylgalactosaminyltransferase 13 (EC 2.4.1.41) (pp-GaNTase 13) (Protein-UDP acetylgalactosaminyltransfe ...
CG10001-RAAllatostatin G-protein coupled receptor (RE51580p) (CG10001-PA).
CG10005-RARE59626p (CG10005-PA).
CG10006-RACG10006-PA, isoform A.
CG10006-RBIP18018p (CG10006-PB, isoform B).
CG10007-RACG10007-PA (LP09696p).
CG10011-RACG10011-PA.
CG10013-RACG10013-PA (LD20383p).

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