# qiime feature-table summarize error

**URL:** https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364
**Category:** Technical Support
**Created:** [January 28, 2020, 2:41pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364 "2020-01-28T14:41:53Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![gondry2](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/g/258eb7/32.png) [@gondry2](https://forum.qiime2.org/u/gondry2)
#### Post date: [January 28, 2020, 2:41pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364/1 "2020-01-28T14:41:54Z")

</div>

Hello,

I have been trying to rerun demultiplexed samples obtained from our sequencing center. I have gotten to the point that I want to visualize my dada2 output, but am receiving an error with my metadata file. I ran a check on keemei and received an error because the sample ids provided had "\_" instead of "-" (Example: Lisa001\_0023-8-5-2015). I tried converting that character, and still have the same problem. I found a similar topic in the forum and made sure that my file was saved in UTF-8 format, but that didn't help. Any insight would be helpful!

Thanks,  
Patty

Error reveived:

There was an issue with loading the file Mapping\_file\_012820.csv as metadata:

Found unrecognized ID column name '\ufeffsample-id,barcode-sequence,Diet' while searching for header. The first column name in the header defines the ID column, and must be one of these values:

Case-insensitive: 'feature id', 'feature-id', 'featureid', 'id', 'sample id', 'sample-id', 'sampleid'

Case-sensitive: '#OTU ID', '#OTUID', '#Sample ID', '#SampleID', 'sample\_name'

There may be more errors present in the metadata file. To get a full report, sample/feature metadata files can be validated with Keemei: [https://keemei.qiime2.org](https://keemei.qiime2.org)

Find details on QIIME 2 metadata requirements here: [Metadata in QIIME 2 — QIIME 2 2018.11.0 documentation](https://docs.qiime2.org/2018.11/tutorials/metadata/)

[Mapping\_file\_012820.csv](https://forum.qiime2.org/uploads/short-url/lEWzelVql0Jq6SX6GkP9UalxPOC.csv) (3.2 KB)

---

<div class="post-metadata">

### Author: ![timanix](https://forum.qiime2.org/user_avatar/forum.qiime2.org/timanix/32/17879_2.png) [@timanix](https://forum.qiime2.org/u/timanix)
#### Post date: [January 28, 2020, 3:00pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364/2 "2020-01-28T15:00:12Z")

</div>

Hi!  
Your metadata file in .csv format. You should convert it to .tsv format first

---

<div class="post-metadata">

### Author: ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)
#### Post date: [January 28, 2020, 3:01pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364/3 "2020-01-28T15:01:10Z")

</div>



---

<div class="post-metadata">

### Author: ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)
#### Post date: [January 29, 2020, 2:32pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364/4 "2020-01-29T14:32:53Z")

</div>

Hi @gondry2!

> [@gondry2](#):
>
> I ran a check on keemei and received an error because the sample ids provided had “\_” instead of “-”

I just want to mention, QIIME 2 (and Keemei) don't have special requirements for underscores (`_`) vs hyphens (`-`), what matters is that your Sample IDs _match exactly_ between your demuxed sequences/feature table and your sample metadata.

> [@gondry2](#):
>
> Found unrecognized ID column name ‘\ufeffsample-id,barcode-sequence,Diet’ while searching for header.

As @timanix mentioned, this error is because you are using a CSV for metadata, rather than a TSV.

I think it might be helpful for you to spend some time reviewing the Metadata tutorial, this should help steer you in the right direction:

[https://docs.qiime2.org/2019.10/tutorials/metadata/](https://docs.qiime2.org/2019.10/tutorials/metadata/)

---

<div class="post-metadata">

### Author: ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)
#### Post date: [January 29, 2020, 2:32pm UTC](https://forum.qiime2.org/t/qiime-feature-table-summarize-error/13364/5 "2020-01-29T14:32:55Z")

</div>


