How can I get sample-metadata-tsv?

[caidefeng (Defeng Cai)]

Thank you very much，
I download the sequencing from NCBI，when procedure the next step：qiime diversity core-metrics-phylogenetic
--i-phylogeny rooted-tree.qza
--i-table table.qza
--p-sampling-depth 4230
--m-metadata-file sample-metadata-tsv
--output-dir core-metrics-results
How can I get sample-metadata-tsv?
Thank you very much

[Lei (Lei Li)]

Since you downloaded the data from NCBI, I think you need to try to find it in the original data website where you have downloaded. If this is your own data, you need to make the metadata yourself. Metadata is a file which contains your sample information (e.g., treatment, group).
If you want to make a metadata tsv file, please follow the tutorial in the following link:
https://docs.qiime2.org/2018.2/tutorials/metadata/

Keemei: Validate tabular bioinformatics file formats in Google Sheets

Hope it help.

[caidefeng (Defeng Cai)]

Thank you！
Yes ,I have download the sequencing from the NCBI。
I try to find metadata in the NCBI，but I can not find it where it is！

[caidefeng (Defeng Cai)]

I have download it from the web of denoising-stats.qzv ，but when i run it，there have a problem：

Plugin error from diversity:

Metadata does not contain any columns that satisfy this visualizer's requirements. There must be at least one metadata column that contains categorical data, isn't empty, doesn't consist of unique values, and doesn't consist of exactly one value.

Debug info has been saved to /tmp/qiime2-q2cli-err-3hvep7ni.log

what is the matters

[caidefeng (Defeng Cai)]

Can you tell me how construct a metadata,Thank you!

sample-id	input	filtered	denoised	merged	non-chimeric
#q2:types	numeric	numeric	numeric	numeric	numeric
7703701-con19	14405	12076	11830	10052	5613
7703702-con18	34031	30051	29287	25540	11202
7703703-con12	30400	26904	26406	18641	7135
7703704-con4	33301	28972	28491	21905	8704
7703705-con16	42882	38348	36632	27652	14823
7703706-case4	31515	20890	20174	17505	4335
7703707-case3	31248	25802	25066	20878	9499
7703708-case2	31449	27055	26750	23989	6449
7703709-case1	31848	26822	25943	21265	7553
7703710-case8	31133	26264	25790	23144	8671
7703711-case7	31292	25122	24623	22563	10066
7703712-case6	31146	26311	25735	22339	8992
7703713-case5	31806	20502	20104	18019	6542
7703714-con15	35074	31096	30634	24214	9705
7703715-con5	22869	20045	19417	14837	7831
7703716-case10	31981	20316	19802	17311	6199
7703717-case9	31440	22871	21704	17048	6388
7703718-con14	10887	9404	8957	6684	5542
7703719-case12	30942	26918	26307	22504	6518
7703720-case11	32165	20876	20424	18130	8009
7703721-case14	31862	26732	26302	24616	4016
7703722-case13	31232	26478	26130	24577	7207
7703723-case16	31160	25985	25154	20993	7663
7703724-case15	30997	26882	26359	21493	4620
7703725-case18	31601	21544	21326	19788	5849
7703726-case17	31382	25511	24761	21646	8310
7703727-case20	31732	27067	26811	25409	7402
7703728-case19	31529	21399	20684	15665	5510
7703729-case32	32130	22249	21559	17265	5602
7703730-case31	31761	22256	21479	17227	6683
7703731-case38	30922	26845	26333	24591	6139
7703732-case37	31250	21065	20612	17926	4107
7703733-case36	31262	26565	26337	25396	4828
7703734-case35	31257	26678	26074	24582	6058
7703735-con38	31787	20420	19588	16574	5637
7703736-con37	31775	23213	21892	17531	6231
7703737-con36	31830	20948	19821	14767	7631
7703738-con35	31598	22406	21435	17585	6145
7703739-con34	31543	22576	21426	17598	6388
7703740-con33	31554	24152	22820	17590	8287
7703741-con32	31713	26318	25632	22186	8857

[Lei (Lei Li)]

The screen shot your show me is not metadata. It the output from DADA2. We cannot contract a metadata based on this output. The meta should be something like following (You need to know what are those sample ID are (e.g., treatment, location.....))

Since you download the dataset from NCBI, I am guessing you cannot find the metadata fro it (The author not usually upload their metadata into NCBI).
I think if you want to learn how to use Qiime2 , please following the moving picture tutorial in the following link. It contains all the information you need to use and detail explanation. It is a good starting point.
https://docs.qiime2.org/2018.2/tutorials/moving-pictures/
Good luck!

[caidefeng (Defeng Cai)]

Thank you very much！I will try it！