Schema for bdgpCanonical
  Database: dm1    Primary Table: bdgpCanonical    Row Count: 13,380   Data last updated: 2005-01-08
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chr2Lvarchar(255) values Chromosome
chromStart 7528int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 9491int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 1int(10) unsigned range Which cluster of transcripts this belongs to in knownIsoforms
transcript CG11023-RAvarchar(255) values Corresponds to knownGene name field.
protein Q86BM6varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        dm1.bdgpIsoforms.clusterId (via bdgpCanonical.clusterId)
      dm1.bdgpGene.proteinID (via bdgpCanonical.protein)
      dm1.bdgpSwissProt.swissProtId (via bdgpCanonical.protein)
      dm1.flyBaseSwissProt.swissProtId (via bdgpCanonical.protein)
      go.goaPart.dbObjectId (via bdgpCanonical.protein)
      knownGeneV39.kgProtAlias.alias (via bdgpCanonical.protein)
      knownGeneV39.kgSpAlias.spID (via bdgpCanonical.protein)
      knownGeneV39.kgXref.spID (via bdgpCanonical.protein)
      proteome.spOldNew.acc (via bdgpCanonical.protein)
      proteome.spReactomeEvent.spID (via bdgpCanonical.protein)
      proteome.spReactomeId.spID (via bdgpCanonical.protein)
      uniProt.accToKeyword.acc (via bdgpCanonical.protein)
      uniProt.accToTaxon.acc (via bdgpCanonical.protein)
      uniProt.citation.acc (via bdgpCanonical.protein)
      uniProt.comment.acc (via bdgpCanonical.protein)
      uniProt.description.acc (via bdgpCanonical.protein)
      uniProt.displayId.acc (via bdgpCanonical.protein)
      uniProt.extDbRef.acc (via bdgpCanonical.protein)
      uniProt.feature.acc (via bdgpCanonical.protein)
      uniProt.gene.acc (via bdgpCanonical.protein)
      uniProt.geneLogic.acc (via bdgpCanonical.protein)
      uniProt.info.acc (via bdgpCanonical.protein)
      uniProt.otherAcc.acc (via bdgpCanonical.protein)
      uniProt.protein.acc (via bdgpCanonical.protein)
      visiGene.gene.uniProt (via bdgpCanonical.protein)
      dm1.arbExpDistance.query (via bdgpCanonical.transcript)
      dm1.arbExpDistance.target (via bdgpCanonical.transcript)
      dm1.bdgpBlastTab.query (via bdgpCanonical.transcript)
      dm1.bdgpBlastTab.target (via bdgpCanonical.transcript)
      dm1.bdgpGene.name (via bdgpCanonical.transcript)
      dm1.bdgpGenePep.name (via bdgpCanonical.transcript)
      dm1.bdgpIsoforms.transcript (via bdgpCanonical.transcript)
      dm1.bdgpSwissProt.bdgpName (via bdgpCanonical.transcript)
      dm1.bdgpToCanonical.name (via bdgpCanonical.transcript)
      dm1.bdgpToLocusLink.name (via bdgpCanonical.transcript)
      dm1.bdgpToPfam.name (via bdgpCanonical.transcript)
      dm1.bdgpToRefSeq.name (via bdgpCanonical.transcript)
      dm1.blastFBPep00.name (via bdgpCanonical.transcript)
      dm1.drBlastTab.query (via bdgpCanonical.transcript)
      dm1.fbTranscript.transcriptId (via bdgpCanonical.transcript)
      dm1.hgBlastTab.query (via bdgpCanonical.transcript)
      dm1.pscreen.geneIds (via bdgpCanonical.transcript)
      dm1.scBlastTab.query (via bdgpCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chr2L752894911CG11023-RAQ86BM6
chr2L67043713902CG11371-RBQ9V474
chr2L72387762033CG11372-RAQ9VPI6
chr2L76301776394CG11374-RAQ9VPI7
chr2L947511020865CG11376-RAQ9VPI9
chr2L1023811041466CG11377-RAQ9VPJ0
chr2L1069021144327CG2674-REP40320
chr2L1320591344728CG2718-RCQ9VPK0
chr2L1433751442279CG11454-RAQ9VPK4
chr2L15533615601710CG11455-RBn/a

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