Schema for flyBaseCanonical
  Database: dm2    Primary Table: flyBaseCanonical    Row Count: 13,566   Data last updated: 2007-04-03
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chr3Rvarchar(255) values Chromosome
chromStart 379int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 10200int(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 CG12581-RBvarchar(255) values Corresponds to knownGene name field.
protein Q9VMY3varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        dm2.arbExpDistance.query (via flyBaseCanonical.transcript)
      dm2.arbExpDistance.target (via flyBaseCanonical.transcript)
      dm2.ceBlastTab.query (via flyBaseCanonical.transcript)
      dm2.drBlastTab.query (via flyBaseCanonical.transcript)
      dm2.flyBase2004Xref.name (via flyBaseCanonical.transcript)
      dm2.flyBaseBlastTab.query (via flyBaseCanonical.transcript)
      dm2.flyBaseBlastTab.target (via flyBaseCanonical.transcript)
      dm2.flyBaseGene.name (via flyBaseCanonical.transcript)
      dm2.flyBaseIsoforms.transcript (via flyBaseCanonical.transcript)
      dm2.flyBaseNoncoding.name (via flyBaseCanonical.transcript)
      dm2.flyBasePep.name (via flyBaseCanonical.transcript)
      dm2.flyBaseToCG.name (via flyBaseCanonical.transcript)
      dm2.flyBaseToDescription.name (via flyBaseCanonical.transcript)
      dm2.flyBaseToPfam.name (via flyBaseCanonical.transcript)
      dm2.flyBaseToRefSeq.name (via flyBaseCanonical.transcript)
      dm2.flyBaseToUniProt.name (via flyBaseCanonical.transcript)
      dm2.flyP2P.query (via flyBaseCanonical.transcript)
      dm2.flyP2P.target (via flyBaseCanonical.transcript)
      dm2.hgBlastTab.query (via flyBaseCanonical.transcript)
      dm2.mmBlastTab.query (via flyBaseCanonical.transcript)
      dm2.rnBlastTab.query (via flyBaseCanonical.transcript)
      dm2.scBlastTab.query (via flyBaseCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chr3R379102001CG12581-RBQ9VMY3
chr3R19945218712CG33294-RACG33294-RA
chr3R23028302953CG12582-RAQ9VMY5
chr3R46718532444CG1107-RBQ9VMY8
chr3R58764607645CG14637-RAQ9V3C0
chr3R60867667806CG1106-RHQ07171
chr3R70292707807CG14638-RAQ9VMZ4
chr3R72743740368CG14639-RAQ9VMZ5
chr3R80501813169CG14640-RAQ9VMZ8
chr3R826938416610CG31519-RAP82986

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