# Exporting taxonomy with level columns

**URL:** https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833
**Category:** User Support
**Tags:** taxonomy, export
**Created:** [April 9, 2024, 6:15pm UTC](https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833 "2024-04-09T18:15:13Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![AdventureDavid](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@AdventureDavid](https://forum.qiime2.org/u/AdventureDavid)
#### Post date: [April 9, 2024, 6:15pm UTC](https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833/1 "2024-04-09T18:15:13Z")

</div>

Hi,

I am using QIIME2/2023.7 version. I use the "qiime tools export " function to export my taxonomy.qza into a tsv. My question, is there a way to export the file with the column identifiers for each of the levels of taxa?

Currently what my table looks like: (Where I just have 1 column "taxon" with the entire taxonomic profile line for each id.)  
 ![image](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/3X/e/2/e2dd31db5cc184dd92aaae4a7e80c0838a164307.png)

Ideally what it would like: Where I have 7 columns for each level of taxonomy (kingdom-\>species)  
 ![image](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/3X/a/2/a268e855ee591ebfa7fed9a8ac63d9cf0943f6dc.png)

---

<div class="post-metadata">

### Author: ![AdventureDavid](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@AdventureDavid](https://forum.qiime2.org/u/AdventureDavid)
#### Post date: [April 9, 2024, 9:21pm UTC](https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833/2 "2024-04-09T21:21:28Z")

</div>

Actually, I'm not sure if there is a specific function to command QIIME2 to do this. I ended up transforming this on R!

---

<div class="post-metadata">

### Author: ![timanix](https://forum.qiime2.org/user_avatar/forum.qiime2.org/timanix/32/17879_2.png) [@timanix](https://forum.qiime2.org/u/timanix)
#### Post date: [April 10, 2024, 6:41am UTC](https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833/3 "2024-04-10T06:41:50Z")

</div>

Hello!  
Glad hat you figured it out 👍.  
You are right, there is no way to do it in Qiime2. I transform it with Python when needed.

---

<div class="post-metadata">

### Author: ![system](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/3X/2/1/21af5fe23cb6f4579467c66a9ed94e55274ca7bd.svg) [@system](https://forum.qiime2.org/u/system)
#### Post date: [May 11, 2024, 12:42pm UTC](https://forum.qiime2.org/t/exporting-taxonomy-with-level-columns/29833/4 "2024-05-11T12:42:03Z")

</div>

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.