# How to include confidence in taxonomy-annotated BIOM file?

**URL:** <https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729>\
**Category:** Other Bioinformatics Tools\
**Created:** [May 12, 2019, 3:53am UTC](https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729 "2019-05-12T03:53:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ngonza27](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/n/da6949/32.png) [@ngonza27](https://forum.qiime2.org/u/ngonza27)\
**Post date:** [May 12, 2019, 3:53am UTC](https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729/1 "2019-05-12T03:53:15Z")

</div>

Hi all,

So I've followed the example listed above and the new .biom file that I export is great, but the confidence isn't in my exported file. I have column 1 containing my #OTUID, the next columns containing my samples and reads, and the last column contains the taxonomy but no confidence values. I'm clearly missing something.

This is what I'm running if anyone is able to help:

biom add-metadata -i feature-table.biom -o table-with-taxonomy3.biom --observation-metadata-fp taxonomy\_reformatted.txt --sc-separated taxonomy

biom convert --input-fp table-with-taxonomy3.biom --output-fp table-with-taxonomy3.tsv --to-tsv --header-key taxonomy

---

<div class="post-metadata">

**Author:** ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)\
**Post date:** [May 12, 2019, 3:55am UTC](https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729/2 "2019-05-12T03:55:17Z")

</div>



---

<div class="post-metadata">

**Author:** ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)\
**Post date:** [May 12, 2019, 4:12am UTC](https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729/3 "2019-05-12T04:12:11Z")

</div>

I am not a biom developer, but, I found this little nugget, w.r.t TSV-style BIOM files:

> the classic format can support only a single observation metadata entry

As I understand it, you can have the taxonomy annotation, or the confidence value, but not both. ~~A workaround might be to collapse your `FeatureTable[Frequency]` in QIIME 2 with your taxonomy ([check this example](https://docs.qiime2.org/2019.4/tutorials/moving-pictures/#differential-abundance-testing-with-ancom), at the very end of the ANCOM section), before exporting to biom.~~

You could just [`metadata tabulate`](https://docs.qiime2.org/2019.4/plugins/available/metadata/tabulate/) your table and taxonomy and grab the TSV out of there (thanks for pointing out the error of my ways, @Nicholas_Bokulich)

---

<div class="post-metadata">

**Author:** ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)\
**Post date:** [May 12, 2019, 4:12am UTC](https://forum.qiime2.org/t/how-to-include-confidence-in-taxonomy-annotated-biom-file/9729/4 "2019-05-12T04:12:13Z")

</div>


