Produce table with ASV, assignation, perc identity, number of reads per sample

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 artifact names here for demo:

Sequence:
The rep-seqs.qzv artifact will show the hashed Feature/ASV ID and its corresponding sequence:

Taxonomy:
The taxonomic assignment of those features are in the taxonomy.qzv artifact:

# of reads assigned:
Look in the Feature Detail tab in the table.qzv

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:

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

1 Like