# Produce table with ASV, assignation, perc identity, number of reads per sample **URL:** \ **Category:** User Support\ **Tags:** dada2, feature-table, taxonomy, metadata\ **Created:** [October 21, 2021, 8:51am UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134 "2021-10-21T08:51:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![alexcussigh0](https://forum.qiime2.org/user_avatar/forum.qiime2.org/alexcussigh0/32/12041_2.png) [@alexcussigh0](https://forum.qiime2.org/u/alexcussigh0)\ **Post date:** [October 21, 2021, 8:51am UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134/1 "2021-10-21T08:51:52Z")
Hi everyone! I have applied a qiime2 pipeline for the metabarcoding on fresh water eDNA using the 12s MiFish primers. I have managed to obtain a TSV using qiime metadata tabulate on my classified consensus blast/VSEARCH denoised sequences. I was wondering if there is a chance to obtain a complete TSV table with for each ASV obtained: taxonomic assignation, percentage of identity, sequence, number of reads assigned all separated for each samples. I hope I made myself clear, thank you so much for the attention ---
**Author:** ![Mehrbod\_Estaki](https://forum.qiime2.org/user_avatar/forum.qiime2.org/mehrbod_estaki/32/4001_2.png) [@Mehrbod\_Estaki](https://forum.qiime2.org/u/Mehrbod_Estaki)\ **Post date:** [October 22, 2021, 3:47am UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134/2 "2021-10-22T03:47:32Z")
Hi @alexcussigh0, I think the information you are looking for (mostly) already exists through various artifacts which you probably already created. I'm not sure if there is an easy way to combine all of them within Q2, (there may be, I'm just not thinking hard enough about it atm) but probably the easiest way is to export the various tables into your preferred data wrangling program and combine them there. Below I've outlined where all of your requested data are. In almost all of the various visualization artifacts below there wil be a "download" button that will let you download the needed tables. I'm going to refer to the [Moving Pictures tutorial](https://docs.qiime2.org/2021.8/tutorials/moving-pictures/) artifact names here for demo: **Sequence** : The `rep-seqs.qzv` artifact will show the hashed Feature/ASV ID and its corresponding sequence: ![Screenshot from 2021-10-21 21-34-02](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/f/fc1d947d5977e6c0414f0b41ed4f5b5831ff165a.png) **Taxonomy** : The taxonomic assignment of those features are in the `taxonomy.qzv` artifact: ![Screenshot from 2021-10-21 21-37-45](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/9/940250c38e89ebac46808490dae9d50a1908d6df.png) **# of reads assigned** : Look in the `Feature Detail` tab in the `table.qzv` ![Screenshot from 2021-10-21 21-29-55](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/8/83bd2bc12c9269c47ed68c34159578176dc81d6e.png) **number of reads assigned all separated for each samples:** If I understand this correctly, this is basically just your `table.qza`. You can export this out of QIIME 2 in a tsv format like so: ```python qiime tools export table.qza --output-dir exported biom convert -i exported/feature-table.biom -o feature-table.tsv --to-tsv ``` The second command there uses `biom` which is not a QIIME 2 program but does come preloaded in your Q2 environment. **percentage of identity** I'm not sure I understand what exactly you are referring to here. % identify of what? Hope this helps ---
**Author:** ![alexcussigh0](https://forum.qiime2.org/user_avatar/forum.qiime2.org/alexcussigh0/32/12041_2.png) [@alexcussigh0](https://forum.qiime2.org/u/alexcussigh0)\ **Post date:** [November 5, 2021, 11:26am UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134/3 "2021-11-05T11:26:30Z")
Thank you so much! I was wondering if there is a way to produce a table with the sequence of the assigned ASV I have produced directly without merging the the` rep-seqs.qzv` artifact and the `taxonomy.qzv` artifact. With percentage of identity I was referring to the **Confidence** value in the taxonomic assignment ---
**Author:** ![Mehrbod\_Estaki](https://forum.qiime2.org/user_avatar/forum.qiime2.org/mehrbod_estaki/32/4001_2.png) [@Mehrbod\_Estaki](https://forum.qiime2.org/u/Mehrbod_Estaki)\ **Post date:** [November 8, 2021, 5:16pm UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134/4 "2021-11-08T17:16:47Z")
Hi @alexcussigh0, Sorry I'm not sure I fully understand what you are looking for exactly, I thought what you are describing already exists in the rep-seq.qza file. Can you show an example of you what you are looking for exactly? Also just to clarify, in any of the artifacts above, you can visualize them alone directly using the `metadata tabulate` action. And as long as they share the same index (i.e. `Feature ID`) you can be merged multiple similar tables as well, ex: ``` qiime metadata tabulate \ --m-input-file taxonomy.qza \ --m-input-file rep-seqs.qza \ --o-visualization taxo-table.qzv ``` However, if you are trying to include in there a table where the index is `sample-id`, and not Feature ID, you'll want to transpose that table first using `qiime feature-table transpose` ---
**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:** [December 9, 2021, 11:17pm UTC](https://forum.qiime2.org/t/produce-table-with-asv-assignation-perc-identity-number-of-reads-per-sample/21134/5 "2021-12-09T23:17:35Z")
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.