I am try to get the feature table summary with the following command:
qiime feature-table summarize --i-table table1.qza --o-visualization table1.qzv --m-sample-metadata-file 16s-obj1-metadata.tsv
I keep getting the following error:
**There was an issue with loading the file 16s-obj1-metadata.tsv as metadata:**
**Found unrecognized ID column name '<!DOCTYPE html>' 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**
**Find details on QIIME 2 metadata requirements here: https://docs.qiime2.org/2019.4/tutorials/metadata/**
My metadata file looks like in the attached screenshot. I have successfully validated with Keemei in Safari and then Chrome, changed column names, omitted some columns, nothing works. And I have read and re-read the metadata tutorial. I have run one succesful complete analysis before.
To download the metadata file, I did:
wget -O "16s-obj11-metadata.tsv" "https://docs.google.com/spreadsheets/d/1BOtYXnoCkj3XpnskzcJQyse_8j93Vrtq1ILsJJ0Fkuo/edit#gid=0"
I have read here that other people have experienced a similar problem before but I cant seem to find a solution that works for me.
The problem here is that you aren’t downloading what you think you are downloading. Check this out:
[email protected]:~/Desktop> wget -O "16s-obj11-metadata.tsv" "https://docs.google.com/spreadsheets/d/1BOtYXnoCkj3XpnskzcJQyse_8j93Vrtq1ILsJJ0Fkuo/edit#gid=0"
--2019-05-11 11:00:23-- https://docs.google.com/spreadsheets/d/1BOtYXnoCkj3XpnskzcJQyse_8j93Vrtq1ILsJJ0Fkuo/edit
Resolving docs.google.com (docs.google.com)... 184.108.40.206, 2607:f8b0:4000:814::200e
Connecting to docs.google.com (docs.google.com)|220.127.116.11|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Resolving accounts.google.com (accounts.google.com)... 18.104.22.168, 2607:f8b0:4000:811::200d
Connecting to accounts.google.com (accounts.google.com)|22.214.171.124|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘16s-obj11-metadata.tsv’
16s-obj11-metadata.tsv [ <=> ] 55.73K --.-KB/s in 0.1s
2019-05-11 11:00:24 (492 KB/s) - ‘16s-obj11-metadata.tsv’ saved 
[email protected]:~/Desktop> head 16s-obj11-metadata.tsv
<meta content="width=300, initial-scale=1" name="viewport">
<meta name="description" content="Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.">
<meta name="google-site-verification" content="LrdTUW9psUAMbh4Ia074-BPEVmcpBxF6Gwf0MSgQXZs">
<title>Google Sheets - create and edit spreadsheets online, for free.</title>
In case that isn’t clear, you appear to be downloading an HTML document, rather than a TSV.
Oh, I see now!
But how do I download the google sheet into a recognisable metadata file format?
I found a solution by downloading it locally, saving as a tab delimited .txt file, then uploading it to the server. It worked.
Thank you very much!