# Obtaining sequences per biological sample - version 2

**URL:** https://forum.qiime2.org/t/obtaining-sequences-per-biological-sample-version-2/14195
**Category:** User Support
**Created:** [March 25, 2020, 12:08am UTC](https://forum.qiime2.org/t/obtaining-sequences-per-biological-sample-version-2/14195 "2020-03-25T00:08:23Z")
**Posts on this page:** 1
**Showing post:** 14

<div class="post-metadata">

### Author: ![jwdebelius](https://forum.qiime2.org/user_avatar/forum.qiime2.org/jwdebelius/32/9655_2.png) [@jwdebelius](https://forum.qiime2.org/u/jwdebelius)
#### Post date: [March 26, 2020, 4:08pm UTC](https://forum.qiime2.org/t/obtaining-sequences-per-biological-sample-version-2/14195/14 "2020-03-26T16:08:32Z")

</div>

Hi @rnasrah,

So, it ran correctly, but this adds the sequence at. the end as metadata. You could take the last sequence column in excel and move it over, or add one line to the end of the python after

```python
combined.rename(columns={0:"representative_sequence"}, inplace=True)
combined.set_index("representative_sequence", inplace=True)
combined.to_csv(out_fp, sep='\t')

```

@Nicholas_Bokulich also suggested this thread, because he thinks more qiime-o-matically than I do. So, I may have sent you on a wild goose chase (sorry).

> [@Formatting a QIIME2 feature table for the R version of DADA2?](https://forum.qiime2.org/t/formatting-a-qiime2-feature-table-for-the-r-version-of-dada2/13387/3):
>
> Sure there is — secret QIIME 2 method. Use qiime feature-table group to relabel. We have a few examples floating around the forum of using this as a sneaky way to relabel sample IDs, e.g., here: [https://forum.qiime2.org/t/problem-with-taxa-collapse/9081/2?u=nicholas\_bokulich](https://forum.qiime2.org/t/problem-with-taxa-collapse/9081/2) But group can operate on feature IDs as well, and the same trick applies... additionally, we can transform a FeatureData[Sequence] artifact to metadata so that the sequence gets read in as the new label. Proof (using the…

Best,  
Justine

---

_[View the full topic](https://forum.qiime2.org/t/obtaining-sequences-per-biological-sample-version-2/14195)._