Hello, I am having problems interpreting exactly what the values in the cells represent in a percentile abundance table generated from an ANCOM analysis even after reading about percentile abundance tables online. The taxonomic level was “3” and the variable of interest was pH treatment value for a water sample (7.6 vs. 7.8 vs. 8.0 where “1.0” was a pseudo-value assigned to boat samples). I have attached my table in the form of an excel workbook. Can you please explain to me what specific values represent exactly in plain terms? For example what does the value in cell K6 represent? Thanks
Sorry, I was not allowed to upload an excel file, only txt file so I have uploaded that here.
percent-abundances from ANCOM.txt (7.7 KB)
@Lisa_Crummett so there are a two headers that are important, namely
Group denotes the metadata category. In your case, there are only 4 different pH values,
1, 7.6, 7.8 and 8, so these 4 values are your groups.
Percentile denotes the quartile values. For example if you look at the 3rd row denoted by
Unassigned;__;__, you'll notice that the percentiles in Group 1 are given as follows
This means the minimum value (denoted by Percentile 0) is 1 (which in your case is actually zero since you added a pseudocount in ANCOM). And your maximum (denoted by Percentile 100) is 57. The average (denoted by Percentile 50) is 23. Percentiles 25 and 75 just denote quartiles.
Does this make more sense?
Thanks for the explanation @mortonjt, but just to clarify, I think that you meant that the “median” is denoted by percentile 50, right? Since not always the average value correspond to the percentile 50.
Yes that’s right @Daniela_Vargas, thanks for the correction!
I am sorry for the lag in my reply, I have been swamped with other stuff. So, I appreciate your reply but it still doesn’t specifically explain what the values in the cells correspond to. I know that they are supposed to represent abundance of reads but that doesn’t make sense to me…
Here is an example from my results:
Bacteria X has the following percentiles from 0 to 100% respectively for treatment 1… 1 - 84 - 283 - 825 - 3645 whereas treatment 2 has the following percentiles… 19 - 327 - 1075 - 2143 - 179480.
For the 25% percentile, we have 84 for Treatment 1 vs. 327 for Treatment 2. Does this mean that 84 reads that are identified as Bacteria X in Treatment 1 equals 25% of the total reads identified as Bacteria X and that 285 reads that are identified as Bacteria X in Treatment 1 equals 50% of the total reads identified as Bacteria X? If that were true then why isn’t 283 (50th percentile) twice the amount of 84 (25th percentile)? Also if this were true, why wouldn’t we just look the 100th percentile to see how many total reads are associated with a given taxon? Can you please explain exactly what these numbers (in the cells) mean because they clearly can’t be interpreted the same way that one would interpret percentiles for test scores for instance…
You mentioned that the
bacteria X (some taxon) percentiles for your
treatment1 category are as follows:
25th percentile: 84
50th percentile (median): 283
75th percentile: 825
The interpretations of these values are as follows:
Min: in the table provided as input to
ancom, of the samples in the
treatment1 group, in the sample with the lowest count of sequences assigned to
bacteria X, one sequence was observed that was ultimately assigned the taxon
25th percentile: In 25% of the samples in the
treatment1 group, 84 or fewer sequences were observed that were ultimately assigned the taxon
50th percentile (median): In half of the samples in the
treatment1 group, 283 or fewer sequences were observed that were ultimately assigned the taxon
75th percentile: In 75% of the samples in the
treatment1 group, 825 or fewer sequences were observed that were ultimately assigned the taxon
Max: Of the samples in the
treatment1 group, in the sample with the highest count of sequences assigned to
bacteria X, 3645 sequences were observed that were ultimately assigned the taxon
The distribution of observed sequences that were ultimately assigned the taxon
bacteria X in your
treatment1 samples should look something like the following. In this box plot, the line inside the box is the median, the top and bottom of the box are the 75th and 25th percentiles, respectively, and the top and bottom whiskers are the max and min respectively.
Does this help?
Thank you very much Greg. This makes good sense!
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.