Schema for flyBaseIsoforms
  Database: dm2    Primary Table: flyBaseIsoforms    Row Count: 19,452   Data last updated: 2007-04-03
Format description: Links together various transcripts of a gene into a cluster
On download server: MariaDB table dump directory
fieldexampleSQL type info description
clusterId 1int(10) unsigned range Unique id for transcript cluster (aka gene)
transcript CG12581-RBvarchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

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

Sample Rows
 
clusterIdtranscript
1CG12581-RB
1CG12581-RA
2CG33294-RA
3CG12582-RA
4CG1107-RB
4CG1107-RA
5CG14637-RA
6CG1106-RH
6CG1106-RG
6CG1106-RF

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