Combine ASV table with CD-Hit cluster list

[DanieleDeco]

Dear all,

we obtained ASVs and an ASV table from DNA sequences applying the dada2 algorithm. Afterward, we translated the ASV sequences to amino acid sequences, and we clustered them at 100% identity with CD-Hit. We would like to obtain an abundance/distribution table similar to the ASV table for the amino acid clusters. Is it possible to combine the information from the ASV table and the cd-hit cluster file?.
Please find attached the ASV table, CD-Hit output, and the cluster name list (obtained from the CD-Hit output).

Cheers

Daniele
ASV_table.txt
CD_hit_output_cluster_name.otu.txt
CD-Hit_output.clstr.txt