metadata: contig_metadata: 20 rows where bioproject = "PRJNA376117", tax_phylum = "Chloroflexota" and tax

20 rows where bioproject = "PRJNA376117", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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_species
26758261	26758261	PRJNA376117_P_NODE_38841_length_246_cov_1.624277_g38539_i0	PRJNA376117	38841	246	1.624277	3.99572142	Chloroflexota bacterium	2026724	Bacteria	Bacteria	87	8.99e-18	NR	MBM24236.1	2026724	g38539	i0	56.8	0.902439024390244	74	31	90.2	1	239	18	340	412	MBM24236.1 hypothetical protein [Chloroflexota bacterium]	diamond	222	87	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26790155	26790155	PRJNA376117_P_NODE_36601_length_249_cov_0.875000_g36299_i0	PRJNA376117	36601	249	0.875	2.17875	Anaerolineales bacterium	2073117	Bacteria	Bacteria	56.2	6.16e-7	NR	HLF89711.1	2073117	g36299	i0	35.9	0.939759036144578	78	50	94	0	2	235	195	272	HLF89711.1 adenylate/guanylate cyclase domain-containing protein [Anaerolineales bacterium]	diamond	234	56.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
27296153	27296153	PRJNA376117_P_NODE_42463_length_243_cov_0.905882_g42161_i0	PRJNA376117	42463	243	0.905882	2.20129326	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	130	3.5099999999999995e-37	NR	MCB9430965.1	2614247	g42161	i0	82.5	0.987654320987654	80	14	98.8	0	3	242	35	114	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	240	130	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
27359536	27359536	PRJNA376117_P_NODE_43663_length_242_cov_0.911243_g43361_i0	PRJNA376117	43663	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	92.4	3.06e-22	NR	MDQ5851889.1	2026724	g43361	i0	66.3	1.98347107438017	80	27	99.2	0	242	3	12	91	MDQ5851889.1 nucleoside triphosphate pyrophosphohydrolase [Chloroflexota bacterium]	diamond	480	92.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27422778	27422778	PRJNA376117_P_NODE_41743_length_243_cov_2.652941_g41441_i0	PRJNA376117	41743	243	2.652941	6.44664663	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	140	5.71e-41	NR	MCB9430965.1	2614247	g41441	i0	82.7	1	81	14	100	0	1	243	5	85	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	243	140	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
27801561	27801561	PRJNA376117_P_NODE_32284_length_256_cov_1.683060_g31982_i0	PRJNA376117	32284	256	1.68306	4.3086336	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	110	3.04e-28	NR	MCB0185154.1	2614250	g31982	i0	59.5	4.921875	84	34	98.4	0	254	3	64	147	MCB0185154.1 pyridoxal 5'-phosphate synthase glutaminase subunit PdxT [Caldilineaceae bacterium]	diamond	1260	110	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
28022592	28022592	PRJNA376117_P_NODE_31845_length_258_cov_1.297297_g31543_i0	PRJNA376117	31845	258	1.297297	3.34702626	Anaerolineae bacterium	2052143	Bacteria	Bacteria	55.8	1.45e-7	NR	MCW5848612.1	2052143	g31543	i0	49.2	0.686046511627907	59	30	68.6	0	249	73	66	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	177	55.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28496185	28496185	PRJNA376117_P_NODE_25187_length_282_cov_1.215311_g24885_i0	PRJNA376117	25187	282	1.215311	3.42717702	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	47	0.0019	NR	HCU57485.1	2024896	g24885	i0	33.8	0.787234042553192	74	43	72.3	1	31	234	6	79	HCU57485.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	222	47	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
28843203	28843203	PRJNA376117_P_NODE_43068_length_242_cov_0.911243_g42766_i0	PRJNA376117	43068	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	139	5.259999999999999e-38	NR	MCC7369307.1	2026724	g42766	i0	84.8	0.979338842975207	79	12	97.9	0	241	5	134	212	MCC7369307.1 glycosyltransferase family 2 protein [Chloroflexota bacterium]	diamond	237	139	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29096088	29096088	PRJNA376117_P_NODE_45228_length_228_cov_3.316129_g44926_i0	PRJNA376117	45228	228	3.316129	7.56077412	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	63.2	1.94e-9	NR	MFN8470148.1	2614250	g44926	i0	48.6	1.85526315789474	70	31	92.1	1	223	14	665	729	MFN8470148.1 Ig-like domain-containing protein [Caldilineaceae bacterium]	diamond	423	63.2	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
29695506	29695506	PRJNA376117_P_NODE_31730_length_258_cov_1.664865_g31428_i0	PRJNA376117	31730	258	1.664865	4.2953517	Chloroflexota bacterium	2026724	Bacteria	Bacteria	86.7	3.62e-18	NR	MBM25427.1	2026724	g31428	i0	45.9	0.988372093023256	85	45	97.7	1	253	2	94	178	MBM25427.1 hypothetical protein [Chloroflexota bacterium]	diamond	255	86.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29917100	29917100	PRJNA376117_P_NODE_27991_length_272_cov_1.522613_g27689_i0	PRJNA376117	27991	272	1.522613	4.14150736	Chloroflexota bacterium	2026724	Bacteria	Bacteria	61.2	1.68e-8	NR	MBI5032636.1	2026724	g27689	i0	53.1	0.540441176470588	49	23	54	0	151	5	1	49	MBI5032636.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	147	61.2	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30106382	30106382	PRJNA376117_P_NODE_43752_length_241_cov_4.904762_g43450_i0	PRJNA376117	43752	241	4.904762	11.82047642	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.7	1.69e-6	NR	MBN2086674.1	2073117	g43450	i0	36.8	1.70539419087137	68	43	84.6	0	204	1	186	253	MBN2086674.1 alpha/beta hydrolase [Anaerolineales bacterium]	diamond	411	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
30264783	30264783	PRJNA376117_P_NODE_35612_length_249_cov_2.556818_g35310_i0	PRJNA376117	35612	249	2.556818	6.36647682	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	47	0.00103	NR	HET9457306.1	2952938	g35310	i0	52.5	2.02409638554217	61	26	73.5	2	187	5	5	62	HET9457306.1 AAA family ATPase [Candidatus Limnocylindrales bacterium]	diamond	504	47	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales bacterium
30281970	30281970	PRJNA376117_P_NODE_15512_length_348_cov_1.680000_g15210_i0	PRJNA376117	15512	348	1.68	5.8464	Bacteria	2	Bacteria	Bacteria	169	1.07e-51	NR	MEZ4515128.1	2026724	g15210	i0	70.2	1.97413793103448	114	34	98.3	0	347	6	1	114	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	687	169	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31243885	31243885	PRJNA376117_P_NODE_16875_length_335_cov_2.110687_g16573_i0	PRJNA376117	16875	335	2.110687	7.07080145	Anaerolineales bacterium	2073117	Bacteria	Bacteria	82.4	8.55e-16	NR	HEX9674949.1	2073117	g16573	i0	40.5	2.16716417910448	121	57	94.9	3	11	328	227	347	HEX9674949.1 amino acid ABC transporter substrate-binding protein [Anaerolineales bacterium]	diamond	726	82.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
31908173	31908173	PRJNA376117_P_NODE_10017_length_425_cov_1.309659_g9715_i0	PRJNA376117	10017	425	1.309659	5.56605075	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.6	2e-10	NR	MCP4540491.1	2026724	g9715	i0	36	0.628235294117647	89	57	62.8	0	291	25	76	164	MCP4540491.1 hypothetical protein [Chloroflexota bacterium]	diamond	267	68.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31956843	31956843	PRJNA376117_P_NODE_44797_length_239_cov_2.692771_g44495_i0	PRJNA376117	44797	239	2.692771	6.43572269	Bacteria	2	Bacteria	Bacteria	76.6	1.62e-14	NR	MEM7332398.1	2026724	g44495	i0	45.6	7.88284518828452	79	38	99.2	1	238	2	184	257	MEM7332398.1 fatty acid desaturase [Chloroflexota bacterium]	diamond	1884	76.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32146849	32146849	PRJNA376117_P_NODE_23398_length_288_cov_1.409302_g23096_i0	PRJNA376117	23398	288	1.409302	4.05878976	Bacteria	2	Bacteria	Bacteria	119	6.07e-29	NR	HLZ07472.1	2026724	g23096	i0	67.4	3.95833333333333	95	31	99	0	3	287	307	401	HLZ07472.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Chloroflexota bacterium]	diamond	1140	120	0.991666666666667	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32351369	32351369	PRJNA376117_P_NODE_40719_length_244_cov_2.467836_g40417_i0	PRJNA376117	40719	244	2.467836	6.02151984	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	45.1	0.00549	NR	MCB0046499.1	2614250	g40417	i0	33.3	0.811475409836066	66	40	77.5	2	18	206	290	354	MCB0046499.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Caldilineaceae bacterium]	diamond	198	45.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae 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);;