Metabolic engineering of biocatalysts for carboxylic acids production