I used summarize_taxa to give me the sum of the counts, but the function returned the wrong sum by placing the results in column P168.
The data is attached.
Would you happen to have any suggestions to fix this issue?
I'm not sure I can replicate your issue. A quick check would suggest this worked as expected where the correct number of reads were retained per sample:
Probably not want you want to hear, but while I was looking at this I noticed your data looks rather odd. I don't know what your experiment is, but all but one sample exclusively contains ASVs unassigned to a phylum... or even kingdom! If this was not expected, you may want to trace back through the analysis for potential issues.