Reconciling molecular regulatory mechanisms with noise patterns of bacterial metabolic promoters in induced and repressed states