How to further classify the OTUs?

[Hira]

I have done an analysis and generated the following OTU table:

The above table shows OTUs and their sizes along with taxonomy. I want to further specify the OTUs to each of the specific sample. (example given below)

In the above table, The first column is OTU name, the second column is about taxonomy and the next columns are the samples starting from PC1 and onwards. I want such kind of OTUs specified for each of my sample. How can do that? Are there any commands to generate such a table?
Regards
Hira

[pschloss]

mothur has a function called corr.axes that does what you seem to have in the second table. If you want to merge those two tables, you’ll have to do it in R or something like that.

Pat