Schema for rgdGene2Isoforms
  Database: rn4    Primary Table: rgdGene2Isoforms    Row Count: 18,240   Data last updated: 2010-10-19
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 RGD:1563873varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via rgdGene2Isoforms.transcript)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via rgdGene2Isoforms.transcript)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via rgdGene2Isoforms.transcript)
      rn4.affyExonTissuesGsRgdGene2.name (via rgdGene2Isoforms.transcript)
      rn4.ceBlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.dmBlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.drBlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.gnfAtlas2RgdGene2Distance.query (via rgdGene2Isoforms.transcript)
      rn4.gnfAtlas2RgdGene2Distance.target (via rgdGene2Isoforms.transcript)
      rn4.hgBlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.mmBlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2BlastTab.query (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2BlastTab.target (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2Canonical.transcript (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2KeggPathway.rgdId (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2Pep.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToDescription.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToDisplayId.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToEnsembl.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToGenbank.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToGenbankAll.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToGnfAtlas2.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToKeggEntrez.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToLocusLink.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToPDB.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToPfam.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToRAE230.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToRefSeq.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToSymbol.rgdId (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToU34A.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2ToUniProt.name (via rgdGene2Isoforms.transcript)
      rn4.rgdGene2Xref.rgdGeneId (via rgdGene2Isoforms.transcript)
      rn4.rgdGenePathway.geneId (via rgdGene2Isoforms.transcript)
      rn4.scBlastTab.query (via rgdGene2Isoforms.transcript)

Sample Rows
 
clusterIdtranscript
1RGD:1563873
2RGD:1560768
3RGD:1588662
4RGD:1588647
5RGD:1561678
6RGD:1561623
7RGD:1560720
8RGD:1560124
9RGD:1311230
10RGD:1564494

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