Schema for bdgpToLocusLink
  Database: dm1    Primary Table: bdgpToLocusLink    Row Count: 18,175   Data last updated: 2005-01-08
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name CG12581-RAvarchar(255) values primary ID
value 40522varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm1.arbExpDistance.query (via bdgpToLocusLink.name)
      dm1.arbExpDistance.target (via bdgpToLocusLink.name)
      dm1.bdgpBlastTab.query (via bdgpToLocusLink.name)
      dm1.bdgpBlastTab.target (via bdgpToLocusLink.name)
      dm1.bdgpCanonical.transcript (via bdgpToLocusLink.name)
      dm1.bdgpGene.name (via bdgpToLocusLink.name)
      dm1.bdgpGenePep.name (via bdgpToLocusLink.name)
      dm1.bdgpIsoforms.transcript (via bdgpToLocusLink.name)
      dm1.bdgpSwissProt.bdgpName (via bdgpToLocusLink.name)
      dm1.bdgpToCanonical.name (via bdgpToLocusLink.name)
      dm1.bdgpToPfam.name (via bdgpToLocusLink.name)
      dm1.bdgpToRefSeq.name (via bdgpToLocusLink.name)
      dm1.blastFBPep00.name (via bdgpToLocusLink.name)
      dm1.drBlastTab.query (via bdgpToLocusLink.name)
      dm1.fbTranscript.transcriptId (via bdgpToLocusLink.name)
      dm1.hgBlastTab.query (via bdgpToLocusLink.name)
      dm1.pscreen.geneIds (via bdgpToLocusLink.name)
      dm1.scBlastTab.query (via bdgpToLocusLink.name)

Sample Rows
 
namevalue
CG12581-RA40522
CG12581-RB40522
CG12582-RA40524
CG1107-RA40527
CG1107-RB40527
CG14637-RA40530
CG1106-RF46008
CG1106-RE46008
CG1106-RD46008
CG1106-RB46008

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