Hi @kmkalanetra --- I might be misunderstanding your question, but have you had a chance to look at
taxa barplot --- specifically the CSV export?
The CSV looks like this:
This looks pretty similar to your first screenshot, except that the counts aren't relative abundances, but you could calculate that in your spreadsheet software (just looking at way to get you moving right away on your problem).
It is worth noting, the CSV is different at each taxonomic level (the barplot viz runs
collapse behind the scenes).
Apologies if I missed the mark here. Thanks!