Biochemical principles enabling metabolic cooperativity and phenotypic heterogeneity at the single cell level