Error when importing metadata

I have a metadata file that passes the Keemei check. I uploaded the .tsv file to Google Drive and imported it using wget, which worked fine. But when I try to use the metadata in a beta-group-significance call, I get the following error.There was an issue with loading the file metadata_4a.tsv as metadata:

Found unrecognized ID column name '@font-face{font-family:'Roboto';font-style:italic;font-weight:400;src:url(//fonts.gstatic.com/s/roboto/v18/KFOkCnqEu92Fr1Mu51xIIzc.ttf)format('truetype');}@font-face{font-family:'Roboto';font-style:normal;font-weight:300;src:url(//fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmSU5fBBc9.ttf)format('truetype');}@font-face{font-family:'Roboto';font-style:normal;font-weight:400;src:url(//fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu4mxP.ttf)format('truetype');}@font-face{font-family:'Roboto';font-style:normal;font-weight:500;src:url(//fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmEU9fBBc9.ttf)format('truetype');}@font-face{font-family:'Roboto';font-style:normal;font-weight:700;src:url(//fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfBBc9.ttf)format('truetype');}metadata_4a.tsv - Google Drive;this.gbar={CONFIG:[[[0,"www.gstatic.com","og.qtm.en_US.7CmTUC1dl7E.es5.O","com","en","25",0,[4,2,"","","","509095866","0"],null,"b_7sY7PTL4PdptQPjOuG6AY",null,0,"og.qtm.7k-KsmqIsU.L.X.O","AA2YrTtDCsxgvNhkmCP_swCt8NfowK4K5Q","AA2YrTtz2euke2bgsyPEZvx2a05EFzqqtA","",2,1,200,"USA",null,null,"25","25",1],null,[1,0.1000000014901161,2,1],[1,0.001000000047497451,1],[0,0,0,null,"","","",""],[0,0,"",1,0,0,0,0,0,0,null,0,0,null,0,0,null,null,0,0,0,"","","","","","",null,0,0,0,0,0,null,null,null,"rgba(32,33,36,1)","rgba(255,255,255,1)",0,0,0,null,null,1,0,0],null,null,["1","gci_91f30755d6a6b787dcc2a4062e6e9824.js","googleapis.client:gapi.iframes","","en"],null,null,null,null,["m;//scs/abc-static//js/k=gapi.gapi.en.3R2S2iMRC9o.O/d=1/rs=AHpOoo8-ukmJKpOYaCGRb909wNTowBRXFA/m=features","https://apis.google.com","","","","",null,1,"es_plusone_gc_20230109.0_p0","en",null,0],[0.009999999776482582,"com","25",[null,"","0",null,1,5184000,null,null,"",null,null,null,null,null,0,null,0,0,1,0,0,0,null,null,0,0,null,0,0,0,0,0],null,null,null,0,null,null,["5061451","google\\.(com|ru|ca|by|kz|com\\.mx|com\\.tr)$",1]],[1,1,null,27043,25,"USA","en","509095866.0",8,0.009999999776482582,0,0,null,null,null,null,"3700942",null,null,null,"b_7sY7PTL4PdptQPjOuG6AY",0,0,0,null,2,5,"gh",34,0,0,0,0,1],[[null,null,null,"https://www.gstatic.com/og/_/js/k=og.qtm.en_US.7CmTUC1dl7E.es5.O/rt=j/m=qabr,q_dnp,qapid/exm=qaaw,qadd,qaid,qein,qhaw,qhba,qhbr,qhch,qhga,qhid,qhin,qhpr/d=1/ed=1/rs=AA2YrTtDCsxgvNhkmCP_swCt8NfowK4K5Q"]]]],};this.gbar_=this.gbar_||{};(function(_){var window=this;' 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'

NOTE: Metadata files must contain tab-separated values.

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

Find details on QIIME 2 metadata requirements here: Metadata in QIIME 2 — QIIME 2 2022.11.1 documentation

How can I fix this?

Hello,

You've downloaded html file instead of tsv.
Consult Google Docs documentation to automatically convert and download files in different formats.

Cheers
V

Is there a similar issue for .qza files? I am trying to import my unweighted_unifrac_distance_matrix.qza with wget, and it is not coming in as a .qza.

It imports fine

wget -O "unweighted_unifrac_distance_matrix2.qza" "unweighted_unifrac_distance_matrix (2).qza - Google Drive"
--2023-02-15 12:19:59-- unweighted_unifrac_distance_matrix (2).qza - Google Drive
Resolving drive.google.com (drive.google.com)... 64.233.176.101, 64.233.176.138, 64.233.176.113, ...
Connecting to drive.google.com (drive.google.com)|64.233.176.101|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: unweighted_unifrac_distance_matrix (2).qza - Google Drive [following]
--2023-02-15 12:19:59-- unweighted_unifrac_distance_matrix (2).qza - Google Drive
Reusing existing connection to drive.google.com:443.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: unweighted_unifrac_distance_matrix (2).qza - Google Drive [following]
--2023-02-15 12:19:59-- unweighted_unifrac_distance_matrix (2).qza - Google Drive
Reusing existing connection to drive.google.com:443.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘unweighted_unifrac_distance_matrix2.qza’

unweighted_unifrac_distance_m [ <=> ] 71.64K --.-KB/s in 0.02s

2023-02-15 12:20:00 (4.18 MB/s) - ‘unweighted_unifrac_distance_matrix2.qza’ saved [73359]

But then it says it is not an artifact.

qiime tools peek unweighted_unifrac_distance_matrix2.qza
;Traceback (most recent call last):
File "/home/hharder/ENTER/envs/qiime2-2022.11/bin/qiime", line 11, in
sys.exit(qiime())
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 1130, in call
return self.main(*args, **kwargs)
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/q2cli/builtin/tools.py", line 189, in peek
metadatas = {os.path.basename(path):
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/q2cli/builtin/tools.py", line 190, in
qiime2.sdk.Result.peek(path) for path in paths}
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/qiime2/sdk/result.py", line 58, in peek
return ResultMetadata(*archive.Archiver.peek(filepath))
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/qiime2/core/archive/archiver.py", line 335, in peek
archive = cls.get_archive(filepath)
File "/home/hharder/ENTER/envs/qiime2-2022.11/lib/python3.8/site-packages/qiime2/core/archive/archiver.py", line 321, in get_archive
raise ValueError("%s is not a QIIME archive." % filepath)
ValueError: unweighted_unifrac_distance_matrix2.qza is not a QIIME archive.

Yes, wget probably download html of the webpage.

Cheers
V

Is there a better site to upload these to? I couldn't figure out how to import them from my computer, so online is the only option.

Hi @hharder,

I would recommend just utilizing your metadata and QIIME 2 artifact files locally vs. uploading them to the web - that adds a layer of complexity that isn't strictly necessary. Is there a specific command within QIIME 2 you were unsure of using local files with?

In general, what I would say is your easiest option for analysis is to place all of your needed input files (metadata, feature tables, QIIME 2 artifacts) in one directory, and then run all of your commands from that same directory.

Hope this helps! Cheers :lizard:

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.