Metabolomics-based engineering biology for microbial bio-production with sustainability