Schema for flyBaseToDescription
  Database: dm2    Primary Table: flyBaseToDescription    Row Count: 20,145   Data last updated: 2007-04-03
On download server: MariaDB table dump directory
fieldexampleSQL type info
name CG10000-RAvarchar(255) values
val Putative polypeptide N-acet...longtext values

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

Sample Rows
 
nameval
CG10000-RAPutative polypeptide N-acetylgalactosaminyltransferase 13 (EC 2.4.1.41) (Protein-UDP acetylgalactosaminyltransferase 13) (UDP- G ...
CG10001-RAAllatostatin G-protein coupled receptor (RE51580p) (CG10001-PA).
CG10002-RAProtein fork head.
CG10002-RACG10002 (Fragment).
CG10002-RARE03865p.
CG10005-RARE59626p (CG10005-PA).
CG10006-RACG10006-PA.
CG10007-RACG10007-PA (LP09696p).
CG10009-RAZinc finger protein 330 homolog (Nucleolar autoantigen 36 homolog).
CG10011-RACG10011-PA.

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