Schema for bdgpExprLink
  Database: dm3    Primary Table: bdgpExprLink    Row Count: 6,095   Data last updated: 2007-04-06
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 1360{}505varchar(255) values Symbolic gene name
bdgpName TE19842varchar(255) values BDGP gene ID
flyBaseId FBti0019842varchar(255) values FlyBase gene ID
est RE52236varchar(255) values EST accession
imageCount 4int(11) range Number of images for this gene
bodyPartCount 1int(11) range Number of body parts
plate RA.315varchar(255) values DGC Plate
platePos 23int(11) range Position on plate
newRelease Nchar(1) values 'Y' if this gene is a new release

Connected Tables and Joining Fields
        dm3.fbAllele.geneId (via bdgpExprLink.flyBaseId)
      dm3.fbGene.geneId (via bdgpExprLink.flyBaseId)
      dm3.fbPhenotype.geneId (via bdgpExprLink.flyBaseId)
      dm3.fbSynonym.geneId (via bdgpExprLink.flyBaseId)
      dm3.fbTranscript.geneId (via bdgpExprLink.flyBaseId)
      dm3.flyBase2004Xref.fbgn (via bdgpExprLink.flyBaseId)
      dm3.pscreen.geneIds (via bdgpExprLink.flyBaseId)

Sample Rows
 
symbolbdgpNameflyBaseIdestimageCountbodyPartCountplateplatePosnewRelease
1360{}505TE19842FBti0019842RE5223641RA.31523N
140upCG9852FBgn0010340LD2718293UG.2179N
26-29kD-proteinaseCG8947FBgn0028967RE18380266RA.30593N
312CG9166FBgn0029514GH1662541UG.2967N
412{}878TE18870FBti0018870GM076343510UG.6268N
5-HT1ACG16720FBgn0004168RE5770841RA.31686N
5-HT2CG1056FBgn0013743HL07802338UG.4411N
5-HT7CG12073FBgn0004573LD0450741UG.7316N
a6CG3771FBgn0023130LD1364181UG.7076N
Aac11CG6582FBgn0027885LD0985241UG.1055N

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