Schema for bdgpToCanonical
  Database: dm1    Primary Table: bdgpToCanonical    Row Count: 13,380   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 CG11023-RAvarchar(255) values primary ID
value CG11023varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
CG11023-RACG11023
CG11371-RBCG11371
CG11372-RACG11372
CG11374-RACG11374
CG11376-RACG11376
CG11377-RACG11377
CG2674-RECG2674
CG2718-RCCG2718
CG11454-RACG11454
CG11455-RBCG11455

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