Schema for esRegGeneToModule
  Database: sacCer1    Primary Table: esRegGeneToModule    Row Count: 2,355   Data last updated: 2004-03-27
Format description: Module (group of transcription factor binding sites) for gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene YAL002Wvarchar(255) values Name of gene
module 571int(11) range ID of regulatory module, see also esRegModuleToMotif

Connected Tables and Joining Fields
        sacCer1.choExpDistance.query (via esRegGeneToModule.gene)
      sacCer1.choExpDistance.target (via esRegGeneToModule.gene)
      sacCer1.dmBlastTab.query (via esRegGeneToModule.gene)
      sacCer1.esRegGeneToMotif.gene (via esRegGeneToModule.gene)
      sacCer1.esRegUpstreamRegion.name (via esRegGeneToModule.gene)
      sacCer1.hgBlastTab.query (via esRegGeneToModule.gene)
      sacCer1.mmBlastTab.query (via esRegGeneToModule.gene)
      sacCer1.rnBlastTab.query (via esRegGeneToModule.gene)
      sacCer1.sgdAbundance.name (via esRegGeneToModule.gene)
      sacCer1.sgdBlastTab.query (via esRegGeneToModule.gene)
      sacCer1.sgdBlastTab.target (via esRegGeneToModule.gene)
      sacCer1.sgdCanonical.transcript (via esRegGeneToModule.gene)
      sacCer1.sgdDescription.name (via esRegGeneToModule.gene)
      sacCer1.sgdGene.name (via esRegGeneToModule.gene)
      sacCer1.sgdIsoforms.transcript (via esRegGeneToModule.gene)
      sacCer1.sgdLocalization.name (via esRegGeneToModule.gene)
      sacCer1.sgdPep.name (via esRegGeneToModule.gene)
      sacCer1.sgdToName.name (via esRegGeneToModule.gene)
      sacCer1.sgdToPfam.name (via esRegGeneToModule.gene)
      sacCer1.sgdToSwissProt.name (via esRegGeneToModule.gene)

Sample Rows
 
genemodule
YAL002W571
YAL005C445
YAL007C367
YAL012W517
YAL023C469
YAL026C469
YAL027W391
YAL029C469
YAL030W379
YAL034C505

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