Schema for bdgpExprLink
  Database: dm1    Primary Table: bdgpExprLink    Row Count: 2,153   Data last updated: 2004-06-17
Format description: Summary info for linking to the BDGP Expression In Situ Images site
On download server: MariaDB table dump directory
fieldexampleSQL type info description
symbol #symbolvarchar(255) values Symbolic gene name
bdgpName cgvarchar(255) values BDGP gene ID
flyBaseId fbgnvarchar(255) values FlyBase gene ID
est estvarchar(255) values EST accession
imageCount 0int(11) range Number of images for this gene
bodyPartCount 0int(11) range Number of body parts
plate platevarchar(255) values DGC Plate
platePos 0int(11) range Position on plate
newRelease ichar(1) values 'Y' if this gene is a new release

Connected Tables and Joining Fields
        dm1.bdgpGeneInfo.bdgpName (via bdgpExprLink.bdgpName)
      dm1.bdgpToCanonical.value (via bdgpExprLink.bdgpName)
      dm1.bdgpGeneInfo.flyBaseId (via bdgpExprLink.flyBaseId)
      dm1.bdgpNonCodingInfo.flyBaseId (via bdgpExprLink.flyBaseId)
      dm1.bdgpSwissProt.flyBaseId (via bdgpExprLink.flyBaseId)
      dm1.fbAllele.geneId (via bdgpExprLink.flyBaseId)
      dm1.fbGene.geneId (via bdgpExprLink.flyBaseId)
      dm1.fbPhenotype.geneId (via bdgpExprLink.flyBaseId)
      dm1.fbSynonym.geneId (via bdgpExprLink.flyBaseId)
      dm1.fbTranscript.geneId (via bdgpExprLink.flyBaseId)
      dm1.flyBaseSwissProt.flyBaseId (via bdgpExprLink.flyBaseId)

Sample Rows
 
symbolbdgpNameflyBaseIdestimageCountbodyPartCountplateplatePosnewRelease
#symbolcgfbgnest00plate0i
26-29kD-proteinaseCG8947FBgn0028967RE18380265RA.30593N
412{}878TE18870FBti0018870GM07634357UG.6268N
5-HT2CG1056FBgn0013743HL07802338UG.4411N
5-HT7CG12073FBgn0004573LD0450741UG.7316N
Aats-alaCG13391FBgn0027094GM03058125UG.7367N
Aats-ala-mCG4633FBgn0028962LD11251102UG.7479N
Aats-thrCG5353FBgn0027081GH200222019UG.4337N
abCG4807FBgn0000011RE259244015TF_AT_RE_228N
AceCG17907FBgn0000024GH25720222UG.5555N

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