# How to build an OTU table
**URL:** https://forum.qiime2.org/t/how-to-build-an-otu-table/26900
**Category:** User Support
**Tags:** otus
**Created:** [June 27, 2023, 7:38am UTC](https://forum.qiime2.org/t/how-to-build-an-otu-table/26900 "2023-06-27T07:38:56Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@neocat](https://forum.qiime2.org/u/neocat)
#### Post date: [June 27, 2023, 7:38am UTC](https://forum.qiime2.org/t/how-to-build-an-otu-table/26900/1 "2023-06-27T07:38:56Z")
Hi! I am very new to qiime2. What I want to achieve, starting from fastq I want to build an OTU table where each row corresponds to a position in a taxonomic tree (\*), and each column to the raw count in a sample. Where each column corresponds to a sample. I worked through the “moving pictures” tutorial (the DADA2 branch). I looked at the resulting taxonomy.qzv / taxonomy.qza but it only seems to contain Feature ID, Taxon, Confidence. Shouldn’t there also be columns for the actual counts, and total counts for normalization? Is there a separate tutorial how to get to an OTU table? Or what is the most straightforward way to go from fastq to OTU table?
Motivation: I have several data sets from different studies that I want to compare. But my concern is, as these originally have been processed using different techniques, I cannot tell if differences between studies are caused by the processing or by the biological data. So I want to re-process each study using the same workflow.
(\*) For example: “k\_\_Archaea; p\_\_Crenarchaeota; c\_\_Thaumarchaeota; o\_\_Nitrososphaerales; f\_\_Nitrososphaeraceae; g\_\_Candidatus Nitrososphaera; s\_\_SCA1145”
---
### Author:  [@SoilRotifer](https://forum.qiime2.org/u/SoilRotifer)
#### Post date: [June 27, 2023, 1:25pm UTC](https://forum.qiime2.org/t/how-to-build-an-otu-table/26900/2 "2023-06-27T13:25:56Z")
Hi @neocat,
> [@neocat](#):
>
> I looked at the resulting taxonomy.qzv / taxonomy.qza but it only seems to contain Feature ID, Taxon, Confidence. Shouldn’t there also be columns for the actual counts, and total counts for normalization?
This is intended. If you work through the tutorials again, you'll notice that the feature-table (_i.e._ the counts table) is kept as a separate file from the taxonomy. I suggest reading through the :qiime2: [overview](https://docs.qiime2.org/2023.5/tutorials/overview/), for more details.
If you'd like to take a quick look at an old-style QIIME 1 like table, you can run the following commands:
```auto
qiime feature-table transpose \
--i-table table.qza \
--o-transposed-feature-table table-transposed.qza
qiime metadata tabulate \
--m-input-file table-transposed.qza \
--m-input-file taxonomy.qza \
--o-visualization counts-and-taxonomy.qzv
```
Then view the `counts-and-taxonomy.qzv` on QIIME 2 View.
Protip: you can add multiple `--m-imput-files` as long as they share a common ID.
-Cheers!
-Mike
---
### Author:  [@system](https://forum.qiime2.org/u/system)
#### Post date: [July 28, 2023, 7:26pm UTC](https://forum.qiime2.org/t/how-to-build-an-otu-table/26900/3 "2023-07-28T19:26:40Z")
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.