Schema for flyBase2004Xref
  Database: dm3    Primary Table: flyBase2004Xref    Row Count: 22,353   Data last updated: 2008-10-21
Format description: FlyBase cross references circa late 2004 (dm2/4.0; dp3/1.0 uses a subset)
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name CG4696-RBvarchar(255) values FlyBase annotation gene ID
symbol Mp20varchar(255) values Symbolic gene name
synonyms  longblob   Comma-separated list of synonyms
fbtr FBtr0005009varchar(255) values FlyBase FBtr acc
fbgn FBgn0002789varchar(255) values FlyBase FBgn acc
fbpp FBpp0099513varchar(255) values FlyBase FBpp acc
fban FBan0004696varchar(255) values FlyBase FBan acc
type  varchar(255) values Annotation type (for noncoding only)

Connected Tables and Joining Fields
        dm3.bdgpExprLink.flyBaseId (via flyBase2004Xref.fbgn)
      dm3.fbAllele.geneId (via flyBase2004Xref.fbgn)
      dm3.fbGene.geneId (via flyBase2004Xref.fbgn)
      dm3.fbPhenotype.geneId (via flyBase2004Xref.fbgn)
      dm3.fbSynonym.geneId (via flyBase2004Xref.fbgn)
      dm3.fbTranscript.geneId (via flyBase2004Xref.fbgn)
      dm3.pscreen.geneIds (via flyBase2004Xref.fbgn)
      dm3.arbExpDistance.query (via flyBase2004Xref.name)
      dm3.arbExpDistance.target (via flyBase2004Xref.name)
      dm3.ceBlastTab.query (via flyBase2004Xref.name)
      dm3.drBlastTab.query (via flyBase2004Xref.name)
      dm3.flyBaseBlastTab.query (via flyBase2004Xref.name)
      dm3.flyBaseBlastTab.target (via flyBase2004Xref.name)
      dm3.flyBaseCanonical.transcript (via flyBase2004Xref.name)
      dm3.flyBaseGene.name (via flyBase2004Xref.name)
      dm3.flyBaseIsoforms.transcript (via flyBase2004Xref.name)
      dm3.flyBaseNoncoding.name (via flyBase2004Xref.name)
      dm3.flyBasePep.name (via flyBase2004Xref.name)
      dm3.flyBaseToCG.name (via flyBase2004Xref.name)
      dm3.flyBaseToDescription.name (via flyBase2004Xref.name)
      dm3.flyBaseToPfam.name (via flyBase2004Xref.name)
      dm3.flyBaseToRefSeq.name (via flyBase2004Xref.name)
      dm3.flyBaseToUniProt.name (via flyBase2004Xref.name)
      dm3.flyP2P.query (via flyBase2004Xref.name)
      dm3.flyP2P.target (via flyBase2004Xref.name)
      dm3.hgBlastTab.query (via flyBase2004Xref.name)
      dm3.mmBlastTab.query (via flyBase2004Xref.name)
      dm3.rnBlastTab.query (via flyBase2004Xref.name)
      dm3.scBlastTab.query (via flyBase2004Xref.name)

Sample Rows
 
namesymbolsynonymsfbtrfbgnfbppfbantype
CG4696-RBMp20FBtr0005009FBgn0002789FBpp0099513FBan0004696
CG17291-RAPp2A-29BFBtr0005088FBgn0005776FBpp0099974FBan0013383
CG10890-RAmus201FBtr0005673FBgn0002887FBpp0099904FBan0032956
CG10890-RBmus201FBtr0005674FBgn0002887FBpp0099905FBan0032956
CG3484-RAAdhrFBtr0006151FBgn0000056FBpp0099544FBan0032954
CG9565-RANep3FBtr0070000FBgn0031081FBpp0070000FBan0009565
CR32826-RAtRNA:CR32826-RAFBtr0070001FBgn0052826tRNA
CG9570-RACG9570FBtr0070002FBgn0031085FBpp0070001FBan0009570
CG32825-RAOr19bFBtr0070003FBgn0062565FBpp0070002FBan0032825
CG15322-RACG15322FBtr0070005FBgn0031088FBpp0070004FBan0015322

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