Integrating gene expression and metabolic profiles to optimize cellular functions