metadata: contig_metadata: 20 rows where bioproject = "PRJNA1041773", tax_kingdom = "Bacillati" and tax

20 rows where bioproject = "PRJNA1041773", 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
3997595	3997595	PRJNA1041773_P_NODE_99244_length_242_cov_0.911243_g98911_i0	PRJNA1041773	99244	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	61.6	7.93e-9	NR	HEY1294667.1	2026724	g98911	i0	79.5	0.483471074380165	39	7	47.1	1	127	240	1	39	HEY1294667.1 MFS transporter [Chloroflexota bacterium]	diamond	117	61.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
21846750	21846750	PRJNA1041773_P_NODE_101258_length_241_cov_0.916667_g100925_i0	PRJNA1041773	101258	241	0.916667	2.20916747	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	396	8.7e-106	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g100925	i0	97.021	2.98340248962656	235	7	98	0	1	235	7023608	7023374	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	719	396	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria				Ktedonobacteria bacterium brp13
26718252	26718252	PRJNA1041773_P_NODE_65341_length_270_cov_1.406091_g65008_i0	PRJNA1041773	65341	270	1.406091	3.7964457	Anaerolinea thermophila	167964	Bacteria	Bacteria	143	9.13e-42	NR	KUK47115.1	167964	g65008	i0	75.3	0.988888888888889	89	22	98.9	0	269	3	25	113	KUK47115.1 MAG: Putative Holliday junction resolvase [Anaerolinea thermophila]	diamond	267	143	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
27129603	27129603	PRJNA1041773_P_NODE_78502_length_251_cov_0.865169_g78169_i0	PRJNA1041773	78502	251	0.865169	2.17157419	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42	0.0197	NR	MFN8596322.1	2052143	g78169	i0	39	0.49003984063745	41	22	45.4	1	100	213	46	86	MFN8596322.1 hypothetical protein [Anaerolineae bacterium]	diamond	123	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27382983	27382983	PRJNA1041773_P_NODE_69383_length_263_cov_1.621053_g69050_i0	PRJNA1041773	69383	263	1.621053	4.26336939	Anaerolineae bacterium	2052143	Bacteria	Bacteria	138	2.14e-38	NR	MBZ0296681.1	2052143	g69050	i0	76.7	0.980988593155893	86	20	98.1	0	263	6	101	186	MBZ0296681.1 DNA repair protein RecO [Anaerolineae bacterium]	diamond	258	138	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27604133	27604133	PRJNA1041773_P_NODE_94444_length_244_cov_0.900585_g94111_i0	PRJNA1041773	94444	244	0.900585	2.1974274	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	144	1.17e-39	NR	HYT36602.1	2740538	g94111	i0	83.3	0.959016393442623	78	13	95.9	0	2	235	204	281	HYT36602.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	234	144	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
28266754	28266754	PRJNA1041773_P_NODE_89206_length_246_cov_0.890173_g88873_i0	PRJNA1041773	89206	246	0.890173	2.18982558	Chloroflexota bacterium	2026724	Bacteria	Bacteria	79	5.13e-17	NR	HVC82913.1	2026724	g88873	i0	58.3	2.04878048780488	84	33	100	1	1	246	1	84	HVC82913.1 helix-turn-helix domain-containing protein [Chloroflexota bacterium]	diamond	504	79	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28488083	28488083	PRJNA1041773_P_NODE_90027_length_246_cov_0.890173_g89694_i0	PRJNA1041773	90027	246	0.890173	2.18982558	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	44.7	0.00821	NR	KPV53419.1	186479	g89694	i0	38.4	1.04878048780488	86	43	98.8	2	245	3	434	514	KPV53419.1 hypothetical protein SE17_09775, partial [Kouleothrix aurantiaca]	diamond	258	44.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca
28961838	28961838	PRJNA1041773_P_NODE_84148_length_248_cov_0.880000_g83815_i0	PRJNA1041773	84148	248	0.88	2.1824	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	70.1	2.51e-12	NR	MBF6599631.1	2026734	g83815	i0	34.4	1.51209677419355	125	36	95.6	2	3	239	39	163	MBF6599631.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	375	70.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29025094	29025094	PRJNA1041773_P_NODE_32308_length_368_cov_5.277966_g31976_i0	PRJNA1041773	32308	368	5.277966	19.42291488	Bellilinea sp.	2838785	Bacteria	Bacteria	84.3	2.85e-17	NR	HMN15858.1	2838785	g31976	i0	38.1	1.63858695652174	105	65	85.6	0	9	323	63	167	HMN15858.1 hypothetical protein [Bellilinea sp.]	diamond	603	84.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
29214432	29214432	PRJNA1041773_P_NODE_42189_length_327_cov_0.909449_g41856_i0	PRJNA1041773	42189	327	0.909449	2.97389823	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.5	5.69e-8	NR	MFQ5875847.1	2026734	g41856	i0	60	1.30275229357798	45	18	41.3	0	327	193	360	404	MFQ5875847.1 IS110 family transposase [Dehalococcoidia bacterium]	diamond	426	60.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29530010	29530010	PRJNA1041773_P_NODE_91430_length_245_cov_0.895349_g91097_i0	PRJNA1041773	91430	245	0.895349	2.19360505	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.9	4.1e-12	NR	HEX8917252.1	2026724	g91097	i0	67.6	0.869387755102041	71	23	86.9	0	11	223	1	71	HEX8917252.1 hypothetical protein [Chloroflexota bacterium]	diamond	213	65.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30066738	30066738	PRJNA1041773_P_NODE_26252_length_406_cov_2.534535_g25921_i0	PRJNA1041773	26252	406	2.534535	10.2902121	Chloroflexota bacterium	2026724	Bacteria	Bacteria	202	5.26e-63	NR	GIL13670.1	2026724	g25921	i0	74.4	1.88423645320197	129	32	95.3	1	398	12	112	239	GIL13670.1 MAG: hypothetical protein BroJett038_23900 [Chloroflexota bacterium]	diamond	765	202	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30066752	30066752	PRJNA1041773_P_NODE_79672_length_250_cov_0.870056_g79339_i0	PRJNA1041773	79672	250	0.870056	2.17514	Chloroflexi bacterium HGW-Chloroflexi-1	2013723	Bacteria	Bacteria	109	2.86e-26	NR	PKO23656.1	2013723	g79339	i0	86.5	0.624	52	7	62.4	0	249	94	78	129	PKO23656.1 MAG: site-specific DNA-methyltransferase [Chloroflexi bacterium HGW-Chloroflexi-1]	diamond	156	109	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium HGW-Chloroflexi-1
30161362	30161362	PRJNA1041773_P_NODE_87412_length_247_cov_0.885057_g87079_i0	PRJNA1041773	87412	247	0.885057	2.18609079	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	97.8	2.76e-24	NR	HEY7332887.1	3047546	g87079	i0	91.1	0.546558704453441	45	4	54.7	0	135	1	1	45	HEY7332887.1 FmdB family zinc ribbon protein [Candidatus Limnocylindria bacterium]	diamond	135	97.8	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
31078030	31078030	PRJNA1041773_P_NODE_73755_length_256_cov_1.382514_g73422_i0	PRJNA1041773	73755	256	1.382514	3.53923584	Chloroflexota bacterium	2026724	Bacteria	Bacteria	168	1.75e-50	NR	MEW6406216.1	2026724	g73422	i0	100	0.984375	84	0	98.4	0	254	3	48	131	MEW6406216.1 conjugal transfer protein TraF [Chloroflexota bacterium]	diamond	252	168	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31267526	31267526	PRJNA1041773_P_NODE_59415_length_281_cov_1.293269_g59082_i0	PRJNA1041773	59415	281	1.293269	3.63408589	Chloroflexota bacterium	2026724	Bacteria	Bacteria	131	2.22e-33	NR	MBI3241846.1	2026724	g59082	i0	65.2	1.95373665480427	92	32	98.2	0	3	278	91	182	MBI3241846.1 glycogen debranching enzyme N-terminal domain-containing protein [Chloroflexota bacterium]	diamond	549	131	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31615436	31615436	PRJNA1041773_P_NODE_87116_length_247_cov_0.885057_g86783_i0	PRJNA1041773	87116	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.2	2.63e-11	NR	MCA0456525.1	2026724	g86783	i0	67.9	0.643724696356275	53	17	64.4	0	3	161	245	297	MCA0456525.1 hypothetical protein [Chloroflexota bacterium]	diamond	159	68.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32089954	32089954	PRJNA1041773_P_NODE_42378_length_326_cov_1.478261_g42045_i0	PRJNA1041773	42378	326	1.478261	4.81913086	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	51.2	8.63e-5	NR	HUF53814.1	2026734	g42045	i0	44.9	0.450920245398773	49	27	45.1	0	157	303	6	54	HUF53814.1 MaoC family dehydratase N-terminal domain-containing protein [Dehalococcoidia bacterium]	diamond	147	51.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32619507	32619507	PRJNA1041773_P_NODE_78240_length_251_cov_0.865169_g77907_i0	PRJNA1041773	78240	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	103	1.66e-23	NR	MFL5680113.1	2026724	g77907	i0	66.3	4.91235059760956	83	28	99.2	0	250	2	915	997	MFL5680113.1 GAF domain-containing protein [Chloroflexota bacterium]	diamond	1233	103	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);;