feature-table IDs are not present in the metadata

Hi all,

I'm struggling to run the following command:
qiime feature-table summarize --i-table table.qza --o-visualization table.qzv --m-sample-metadata-file Sample_metadataQIIME2_sheep_project_2017_2018.txt

Because I get the following error message:
Plugin error from feature-table:

The following IDs are not present in the metadata: 'G1-8667-TP89', 'G1-8673-TP0', 'G1-8673-TP75', 'G1-8674-TP0', 'G1-8674-TP42', 'G1-8674-TP61', 'G1-8674-TP75', 'G1-8674-TP99', 'G1-8686-TP42', 'G1-8686-TP99', 'G2-9110-TP42', 'G3-8743-TP42', 'G4-8744-TP42', 'G4-8744-TP61', 'G4-8744-TP75', 'G4-8744-TP89', 'G4-8744-TP99', 'G4-9111-TP0', 'G4-9111-TP75', 'G4-9111-TP89', 'G4-9185-TP42', 'G4-9185-TP89', 'G4-9208-TP0', 'G4-9208-TP61', 'G4-9208-TP75', 'G4-9208-TP99', 'G5-8670-TP75', 'G5-8670-TP99', 'G5-9102-TP61', 'G6-8704-TP99', 'G6-8749-TP0', 'G6-8749-TP99', 'G7-8731-TP75', 'G7-8758-TP75', 'G7-8762-TP61', 'G7-8762-TP75', 'G7-8762-TP89'

Debug info has been saved to /tmp/qiime2-q2cli-err-5xlg9iwf.log

Apparently, there are some missing samples.
I checked the metadata file. The spelling seems to be ok.
I have ran feature-table without the --m-sample-metadata-file, and then I visualized the table.qzv, those samples are in the list.
Here attached the table.qzv and the metadata filetable.qzv (5.6 MB) Sample_metadataQIIME2_sheep_project_2017_2018.txt (54.6 KB)

Any idea, suggestions?
Thanks in advance

1 Like

Hello @mefistofele82,

I wonder if this has to do with the line endings of the file. It looks like your file is using Windows line endings (CRLF), but Qiime and other linux software expect Linux line endings (LF).

I've converted your file so it's in the proper LF format. Let me know if this new file works.
Sample_metadataQIIME2_sheep_project_2017_2018-fixed.txt (54.1 KB)

Colin

1 Like

Yes! This is the problem!
Thanks

1 Like