metadata: contig_metadata: 14 rows where bioproject = "PRJNA546018", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA546018", tax_kingdom = "Bacillati" 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
1786174	1786174	PRJNA546018_S_NODE_16682_length_403_cov_3.757310_g16357_i0	PRJNA546018	16682	403	3.75731	15.1419593	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	162	8.88e-46	NR	HEY8847404.1	2952938	g16357	i0	74.6	0.90818858560794	122	23	90.8	1	18	383	30	143	HEY8847404.1 ABC transporter permease [Candidatus Limnocylindrales bacterium]	diamond	366	162	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
3062249	3062249	PRJNA546018_S_NODE_57163_length_202_cov_2.553191_g56838_i0	PRJNA546018	57163	202	2.553191	5.15744582	Bacillati	1783272	Bacteria	Bacteria	80.1	9.07e-16	NR	HSL41963.1	2073117	g56838	i0	71.4	15.8762376237624	56	16	83.2	0	22	189	166	221	HSL41963.1 nicotinate-nucleotide--dimethylbenzimidazole phosphoribosyltransferase [Anaerolineales bacterium]	diamond	3207	80.5	0.995031055900621	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
10715200	10715200	PRJNA546018_S_NODE_39569_length_245_cov_1.086957_g39244_i0	PRJNA546018	39569	245	1.086957	2.66304465	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	124	4.779999999999999e-31	NR	HEU4327911.1	2762507	g39244	i0	91.2	1.66530612244898	68	6	83.3	0	224	21	57	124	HEU4327911.1 biotin carboxylase N-terminal domain-containing protein [Roseiflexaceae bacterium]	diamond	408	124	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
13264635	13264635	PRJNA546018_S_NODE_24591_length_322_cov_1.827586_g24266_i0	PRJNA546018	24591	322	1.827586	5.88482692	Chloroflexota bacterium	2026724	Bacteria	Bacteria	157	8.149999999999999e-43	NR	MBA2632395.1	2026724	g24266	i0	76.5	1.87267080745342	102	24	95	0	15	320	318	419	MBA2632395.1 GAF domain-containing protein [Chloroflexota bacterium]	diamond	603	157	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26776460	26776460	PRJNA546018_S_NODE_36221_length_257_cov_7.005102_g35896_i0	PRJNA546018	36221	257	7.005102	18.00311214	Bacteria	2	Bacteria	Bacteria	112	1.6600000000000003e-27	NR	MBC7263876.1	2026724	g35896	i0	82.3	7.23735408560311	62	11	72.4	0	3	188	100	161	MBC7263876.1 peptide chain release factor 1 [Chloroflexota bacterium]	diamond	1860	112	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26919762	26919762	PRJNA546018_S_NODE_20582_length_356_cov_1.966102_g20257_i0	PRJNA546018	20582	356	1.966102	6.99932312	Anaerolineae bacterium	2052143	Bacteria	Bacteria	188	1.08e-52	NR	MCW5882322.1	2052143	g20257	i0	81.4	0.952247191011236	113	21	95.2	0	9	347	690	802	MCW5882322.1 anaerobic glycerol-3-phosphate dehydrogenase subunit C [Anaerolineae bacterium]	diamond	339	188	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
26966170	26966170	PRJNA546018_S_NODE_7822_length_633_cov_9.933566_g7516_i0	PRJNA546018	7822	633	9.933566	62.87947278	Bacteria	2	Bacteria	Bacteria	121	1.15e-30	NR	MER3437325.1	2026724	g7516	i0	50.6	2.29383886255924	162	71	74.9	4	23	496	36	192	MER3437325.1 DUF305 domain-containing protein [Chloroflexota bacterium]	diamond	1452	121	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27014569	27014569	PRJNA546018_S_NODE_44962_length_228_cov_1.808383_g44637_i0	PRJNA546018	44962	228	1.808383	4.12311324	Anaerolineales bacterium	2073117	Bacteria	Bacteria	144	7.3e-40	NR	MCB9099515.1	2073117	g44637	i0	94.7	1.97368421052632	75	4	98.7	0	227	3	133	207	MCB9099515.1 HlyC/CorC family transporter [Anaerolineales bacterium]	diamond	450	144	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27583334	27583334	PRJNA546018_S_NODE_57604_length_202_cov_0.921986_g57279_i0	PRJNA546018	57604	202	0.921986	1.86241172	Chloroflexota bacterium	2026724	Bacteria	Bacteria	121	6.07e-33	NR	MCH8025227.1	2026724	g57279	i0	78.8	1.96039603960396	66	14	98	0	200	3	71	136	MCH8025227.1 hypothetical protein [Chloroflexota bacterium]	diamond	396	121	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28877844	28877844	PRJNA546018_S_NODE_11648_length_499_cov_15.399543_g11324_i0	PRJNA546018	11648	499	15.399543	76.84371957	Anaerolineales bacterium	2073117	Bacteria	Bacteria	117	2.29e-30	NR	MCA9964165.1	2073117	g11324	i0	41.9	0.817635270541082	136	77	81.2	2	457	53	1	135	MCA9964165.1 hypothetical protein [Anaerolineales bacterium]	diamond	408	117	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28909243	28909243	PRJNA546018_S_NODE_3388_length_1012_cov_7.888538_g3190_i0	PRJNA546018	3388	1012	7.888538	79.83200456	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	234	5.000000000000002e-72	NR	KPV55000.1	186479	g3190	i0	45.1	4.83794466403162	268	138	77.7	4	916	131	10	274	KPV55000.1 hypothetical protein SE17_00200 [Kouleothrix aurantiaca]	diamond	4896	234	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca
29983144	29983144	PRJNA546018_S_NODE_11651_length_499_cov_10.404110_g11327_i0	PRJNA546018	11651	499	10.40411	51.9165089	Anaerolineae bacterium	2052143	Bacteria	Bacteria	144	1.48e-39	NR	MCB0195587.1	2052143	g11327	i0	59.1	1.31663326653307	110	45	66.1	0	24	353	137	246	MCB0195587.1 sulfotransferase domain-containing protein [Anaerolineae bacterium]	diamond	657	144	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32101046	32101046	PRJNA546018_S_NODE_17758_length_388_cov_3.798165_g17433_i0	PRJNA546018	17758	388	3.798165	14.7368802	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	65.5	5.21e-10	NR	MCB9453290.1	2024896	g17433	i0	34.4	5.40463917525773	122	70	94.3	2	3	368	96	207	MCB9453290.1 30S ribosomal protein S4 [Anaerolineaceae bacterium]	diamond	2097	65.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32354494	32354494	PRJNA546018_S_NODE_2339_length_1219_cov_5.457686_g2178_i0	PRJNA546018	2339	1219	5.457686	66.52919234	Chloroflexota bacterium	2026724	Bacteria	Bacteria	306	4.2899999999999996e-98	NR	NTU62956.1	2026724	g2178	i0	68.1	2.22969647251846	226	72	55.6	0	22	699	126	351	NTU62956.1 RNA polymerase sigma factor [Chloroflexota bacterium]	diamond	2718	306	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);;