metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27514512	27514512	PRJNA1174207_P_NODE_32083_length_256_cov_1.398907_g31554_i0	PRJNA1174207	32083	256	1.398907	3.58120192	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	117	2.78e-30	NR	HZM79502.1	2952938	g31554	i0	87.9	1.53515625	66	8	77.3	0	198	1	28	93	HZM79502.1 CPBP family glutamic-type intramembrane protease [Candidatus Limnocylindrales bacterium]	diamond	393	117	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
27798833	27798833	PRJNA1174207_P_NODE_35424_length_248_cov_2.782857_g34895_i0	PRJNA1174207	35424	248	2.782857	6.90148536	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	77.4	2.5e-16	NR	MCB8942763.1	2614247	g34895	i0	70.9	2.6491935483871	55	16	66.5	0	3	167	46	100	MCB8942763.1 PAAR domain-containing protein [Ardenticatenaceae bacterium]	diamond	657	77.4	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
29743637	29743637	PRJNA1174207_P_NODE_28870_length_269_cov_1.964286_g28341_i0	PRJNA1174207	28870	269	1.964286	5.28392934	Bacillati	1783272	Bacteria	Bacteria	79	3.48e-15	NR	HOU23501.1	2052143	g28341	i0	66.7	3.37918215613383	60	20	66.9	0	88	267	1	60	HOU23501.1 nucleoside triphosphate pyrophosphohydrolase family protein [Anaerolineae bacterium]	diamond	909	79	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30040537	30040537	PRJNA1174207_P_NODE_27751_length_274_cov_1.398010_g27222_i0	PRJNA1174207	27751	274	1.39801	3.8305474	Chloroflexota bacterium	2026724	Bacteria	Bacteria	77	4.78e-14	NR	MBV9791606.1	2026724	g27222	i0	46.2	1.01824817518248	93	40	90.9	3	273	25	172	264	MBV9791606.1 hypothetical protein [Chloroflexota bacterium]	diamond	279	77	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30040540	30040540	PRJNA1174207_P_NODE_36971_length_247_cov_0.885057_g36442_i0	PRJNA1174207	36971	247	0.885057	2.18609079	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	155	9.279999999999999e-47	NR	MEZ4552387.1	2026734	g36442	i0	90.1	0.983805668016194	81	8	98.4	0	4	246	32	112	MEZ4552387.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	243	155	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30640682	30640682	PRJNA1174207_P_NODE_30893_length_261_cov_1.425532_g30364_i0	PRJNA1174207	30893	261	1.425532	3.72063852	Chloroflexota bacterium	2026724	Bacteria	Bacteria	163	2e-45	NR	MQC18835.1	2026724	g30364	i0	96.5	0.988505747126437	86	3	98.9	0	259	2	178	263	MQC18835.1 dihydroxy-acid dehydratase [Chloroflexota bacterium]	diamond	258	163	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30861985	30861985	PRJNA1174207_P_NODE_36574_length_247_cov_0.885057_g36045_i0	PRJNA1174207	36574	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	122	1.34e-30	NR	MFN2121797.1	2073117	g36045	i0	74.1	0.983805668016194	81	21	98.4	0	2	244	340	420	MFN2121797.1 IS110 family transposase [Anaerolineales bacterium]	diamond	243	122	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31020073	31020073	PRJNA1174207_P_NODE_25155_length_285_cov_1.367925_g24626_i0	PRJNA1174207	25155	285	1.367925	3.89858625	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.7	6.42e-8	NR	NLW71622.1	2026724	g24626	i0	41.3	0.789473684210526	75	44	78.9	0	9	233	233	307	NLW71622.1 hypothetical protein [Chloroflexota bacterium]	diamond	225	59.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31020078	31020078	PRJNA1174207_P_NODE_36615_length_247_cov_0.885057_g36086_i0	PRJNA1174207	36615	247	0.885057	2.18609079	Bellilinea sp.	2838785	Bacteria	Bacteria	148	3.7e-40	NR	HMN11892.1	2838785	g36086	i0	100	0.995951417004049	82	0	99.6	0	246	1	395	476	HMN11892.1 ABC transporter permease [Bellilinea sp.]	diamond	246	148	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
31083201	31083201	PRJNA1174207_P_NODE_20015_length_317_cov_1.262295_g19486_i0	PRJNA1174207	20015	317	1.262295	4.00147515	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	68.9	6.48e-12	NR	TAJ20127.1	2026734	g19486	i0	64.9	0.539432176656151	57	20	53.9	0	173	3	1	57	TAJ20127.1 MAG: hypothetical protein EPO65_04725, partial [Dehalococcoidia bacterium]	diamond	171	68.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31450309	31450309	PRJNA1174207_P_NODE_28576_length_270_cov_2.157360_g28047_i0	PRJNA1174207	28576	270	2.15736	5.824872	Bacteria	2	Bacteria	Bacteria	101	2.1499999999999994e-23	NR	MCH8186582.1	2026724	g28047	i0	57.8	7.92222222222222	90	38	100	0	270	1	191	280	MCH8186582.1 2-dehydropantoate 2-reductase [Chloroflexota bacterium]	diamond	2139	101	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31968630	31968630	PRJNA1174207_P_NODE_42378_length_235_cov_2.104938_g41849_i0	PRJNA1174207	42378	235	2.104938	4.9466043	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	116	1.0599999999999998e-31	NR	HYJ14097.1	3047546	g41849	i0	73.2	2.71914893617021	71	19	90.6	0	234	22	47	117	HYJ14097.1 hypothetical protein [Candidatus Limnocylindria bacterium]	diamond	639	116	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32380163	32380163	PRJNA1174207_P_NODE_27679_length_274_cov_1.532338_g27150_i0	PRJNA1174207	27679	274	1.532338	4.19860612	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	107	1.14e-27	NR	KPV48230.1	186479	g27150	i0	100	0.613138686131387	56	0	61.3	0	78	245	1	56	KPV48230.1 hypothetical protein SE17_39190, partial [Kouleothrix aurantiaca]	diamond	168	107	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca
32538458	32538458	PRJNA1174207_P_NODE_40379_length_242_cov_1.597633_g39850_i0	PRJNA1174207	40379	242	1.597633	3.86627186	Chloroflexota bacterium	2026724	Bacteria	Bacteria	71.2	2.63e-12	NR	MCC7371887.1	2026724	g39850	i0	91.4	0.867768595041322	35	3	43.4	0	1	105	322	356	MCC7371887.1 amidohydrolase [Chloroflexota bacterium]	diamond	210	71.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium

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);;