Breakdown of energy expenditure at the level of a single cell
I was musing on this and did some strange googling, and have some ballpark figures  for a bunch of different organisms. It's far from a complete answer but it's at least a start, and all this won't fit in a comment.

DNA replication, I assumed, was a huge metabolic drain on the cell. Turns out that is far from the case. Many helicases are passive, requiring no ATP, and the amount of ATP-equivalent triphosphates to synthesize the entire genome is pretty small compared to the amount that gets used and recycled every day.

According to these guys humans go through their bodyweight in ATP every day, about 50% of which is actin turnover, and 30% is synthesis (60% or more in rapid bacteria). Proteins cost about 4-5 ATP per AA to break down and rebuild.

You're not going to get a really good general breakdown, I don't think, but in crop plants or E. coli there are numbers for this, sort of. A lot of them are based on indirect measurements of protein uptake/turnover and ATP cost per AA or BP. They're fascinating but insane and often contradictory.