metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_phylum = "Bacteroidota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5728918	5728918	PRJNA658591_S_NODE_1805_length_311_cov_2.683206_g1742_i0	PRJNA658591	1805	311	2.683206	8.34477066	Bacteroidota	976	Bacteria	Bacteria	115	3.27e-27	NR	MBI1343465.1	1914338	g1742	i0	62.5	10.8906752411576	88	26	84.9	1	310	47	835	915	MBI1343465.1 pyruvate, phosphate dikinase [Terrimonas sp.]	diamond	3387	116	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Terrimonas	Terrimonas sp.
8278714	8278714	PRJNA658591_S_NODE_11007_length_156_cov_2.915888_g10944_i0	PRJNA658591	11007	156	2.915888	4.54878528	Bacteroidota	976	Bacteria	Bacteria	116	2.78e-29	NR	MBU7570240.1	239	g10944	i0	96.1	7.84615384615385	51	2	98.1	0	3	155	362	412	MBU7570240.1 aldehyde dehydrogenase family protein [Flavobacterium sp.]	diamond	1224	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
8278724	8278724	PRJNA658591_S_NODE_2507_length_270_cov_8.085973_g2444_i0	PRJNA658591	2507	270	8.085973	21.8321271	Bacteroidota	976	Bacteria	Bacteria	151	2.1799999999999996e-41	NR	WP_184625254.1	188932	g2444	i0	80.7	24.4888888888889	88	17	97.8	0	265	2	341	428	WP_184625254.1 aldehyde dehydrogenase family protein [Pedobacter cryoconitis]	diamond	6612	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter cryoconitis
26923218	26923218	PRJNA658591_S_NODE_1862_length_307_cov_2.372093_g1799_i0	PRJNA658591	1862	307	2.372093	7.28232551	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	102	8.13e-26	NR	MFM7852277.1	2026740	g1799	i0	54.7	0.840390879478827	86	27	84	1	32	289	1	74	MFM7852277.1 transglycosylase SLT domain-containing protein [Flammeovirgaceae bacterium]	diamond	258	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
26954634	26954634	PRJNA658591_S_NODE_1102_length_385_cov_6.458333_g1039_i0	PRJNA658591	1102	385	6.458333	24.86458205	Bacteroidota bacterium	1898104	Bacteria	Bacteria	130	2.45e-32	NR	MEY4860558.1	1898104	g1039	i0	49.2	0.981818181818182	126	63	97.4	1	380	6	500	625	MEY4860558.1 hypothetical protein [Bacteroidota bacterium]	diamond	378	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27409862	27409862	PRJNA658591_S_NODE_8463_length_171_cov_2.352459_g8400_i0	PRJNA658591	8463	171	2.352459	4.02270489	Pseudomonadati	3379134	Bacteria	Bacteria	72	6.54e-13	NR	QQS51403.1	1898104	g8400	i0	63.6	5.87719298245614	55	20	96.5	0	5	169	206	260	QQS51403.1 MAG: NADP-dependent isocitrate dehydrogenase [Bacteroidota bacterium]	diamond	1005	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27776504	27776504	PRJNA658591_S_NODE_4424_length_217_cov_3.345238_g4361_i0	PRJNA658591	4424	217	3.345238	7.25916646	Sediminibacterium sp.	1917865	Bacteria	Bacteria	80.9	9.93e-16	NR	MCW3087753.1	1917865	g4361	i0	54.2	2.98617511520737	72	33	99.5	0	216	1	433	504	MCW3087753.1 glycine dehydrogenase [Sediminibacterium sp.]	diamond	648	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp.
28186558	28186558	PRJNA658591_S_NODE_2066_length_293_cov_7.122951_g2003_i0	PRJNA658591	2066	293	7.122951	20.87024643	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	124	1.11e-30	NR	HNA14825.1	2099675	g2003	i0	59.1	0.95221843003413	93	38	95.2	0	293	15	1536	1628	HNA14825.1 reverse transcriptase domain-containing protein [Cyclobacteriaceae bacterium]	diamond	279	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
28471096	28471096	PRJNA658591_S_NODE_8706_length_169_cov_4.266667_g8643_i0	PRJNA658591	8706	169	4.266667	7.21066723	Dyadobacter psychrotolerans	2541721	Bacteria	Bacteria	89	3.16e-19	NR	WP_131959455.1	2541721	g8643	i0	73.2	2.98224852071006	56	15	99.4	0	2	169	132	187	WP_131959455.1 NAD(P)-dependent alcohol dehydrogenase [Dyadobacter psychrotolerans]	diamond	504	89	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter psychrotolerans
29272317	29272317	PRJNA658591_S_NODE_6489_length_188_cov_2.733813_g6426_i0	PRJNA658591	6489	188	2.733813	5.13956844	Bacteroidota	976	Bacteria	Bacteria	113	1.72e-27	NR	WP_012779691.1	94254	g6426	i0	85.5	12.8617021276596	62	9	98.9	0	2	187	267	328	WP_012779691.1 aldehyde dehydrogenase family protein [Dyadobacter fermentans]	diamond	2418	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fermentans
29765343	29765343	PRJNA658591_S_NODE_4391_length_218_cov_1.076923_g4328_i0	PRJNA658591	4391	218	1.076923	2.34769214	Bacteroidales bacterium	2030927	Bacteria	Bacteria	116	2e-29	NR	MFO7939826.1	2030927	g4328	i0	75	3.94954128440367	72	18	99.1	0	216	1	251	322	MFO7939826.1 GMP reductase [Bacteroidales bacterium]	diamond	861	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30144206	30144206	PRJNA658591_S_NODE_3192_length_245_cov_4.464286_g3129_i0	PRJNA658591	3192	245	4.464286	10.9375007	Fluviicola sp.	1917219	Bacteria	Bacteria	107	2.43e-25	NR	MBL1279618.1	1917219	g3129	i0	59.5	3.90612244897959	79	31	96.7	1	8	244	156	233	MBL1279618.1 acetyl-CoA C-acyltransferase [Fluviicola sp.]	diamond	957	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola sp.
30188270	30188270	PRJNA658591_S_NODE_1072_length_389_cov_4.108824_g1009_i0	PRJNA658591	1072	389	4.108824	15.98332536	Bacteria	2	Bacteria	Bacteria	160	1.54e-42	NR	MEY4860637.1	1898104	g1009	i0	58.1	1.98971722365039	129	53	99.5	1	3	389	26	153	MEY4860637.1 hypothetical protein [Bacteroidota bacterium]	diamond	774	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32009649	32009649	PRJNA658591_S_NODE_978_length_404_cov_8.712676_g915_i0	PRJNA658591	978	404	8.712676	35.19921104	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	185	3.42e-51	NR	HNA14825.1	2099675	g915	i0	67.9	0.995049504950495	134	43	99.5	0	1	402	1409	1542	HNA14825.1 reverse transcriptase domain-containing protein [Cyclobacteriaceae bacterium]	diamond	402	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
32452854	32452854	PRJNA658591_S_NODE_9659_length_165_cov_0.896552_g9596_i0	PRJNA658591	9659	165	0.896552	1.4793108	Mucilaginibacter arboris	2682090	Bacteria	Bacteria	53.9	1.52e-6	NR	WP_157567582.1	2682090	g9596	i0	47.1	1.85454545454545	51	27	92.7	0	153	1	662	712	WP_157567582.1 non-ribosomal peptide synthetase [Mucilaginibacter arboris]	diamond	306	53.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter arboris

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;