metadata: contig_metadata: 15 rows where bioproject = "PRJNA407368", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA407368", 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
2965763	2965763	PRJNA407368_S_NODE_1883_length_452_cov_78.404255_g1785_i0	PRJNA407368	1883	452	78.404255	354.3872326	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	222	3.15e-53	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g1785	i0	78.531	115.980088495575	354	64	76	11	108	452	2202170	2202520	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	52423	222	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
8068383	8068383	PRJNA407368_S_NODE_3967_length_291_cov_33.015267_g3865_i0	PRJNA407368	3967	291	33.015267	96.07442697	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	366	8.48e-97	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g3865	i0	89.726	735.137457044674	292	23	99	6	2	291	320385	320671	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	213925	366	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
9343216	9343216	PRJNA407368_S_NODE_2708_length_365_cov_27.607143_g2606_i0	PRJNA407368	2708	365	27.607143	100.76607195	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	379	1.3999999999999995e-100	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g2606	i0	85.831	606.380821917808	367	41	100	7	1	365	320643	321000	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	221329	379	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
10619009	10619009	PRJNA407368_S_NODE_3649_length_306_cov_35.310469_g3547_i0	PRJNA407368	3649	306	35.310469	108.05003514	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	320	7.09e-83	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g3547	i0	87.413	425.683006535948	286	27	93	4	22	306	320340	320063	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	130259	320	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
19540837	19540837	PRJNA407368_S_NODE_3476_length_315_cov_4.090909_g3374_i0	PRJNA407368	3476	315	4.090909	12.88636335	Chloroflexota bacterium	2026724	Bacteria	Bacteria	177	1.18e-50	NR	MBI5933276.1	2026724	g3374	i0	81.6	0.980952380952381	103	19	98.1	0	314	6	33	135	MBI5933276.1 terminase large subunit [Chloroflexota bacterium]	diamond	309	177	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26632305	26632305	PRJNA407368_S_NODE_8101_length_180_cov_1.350993_g7999_i0	PRJNA407368	8101	180	1.350993	2.4317874	Chloroflexota bacterium	2026724	Bacteria	Bacteria	90.9	4.36e-20	NR	MCX6057726.1	2026724	g7999	i0	71.2	0.983333333333333	59	17	98.3	0	179	3	156	214	MCX6057726.1 tyrosine-type recombinase/integrase [Chloroflexota bacterium]	diamond	177	90.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27517846	27517846	PRJNA407368_S_NODE_7643_length_187_cov_1.620253_g7541_i0	PRJNA407368	7643	187	1.620253	3.02987311	Candidatus Villigracilis vicinus	3140679	Bacteria	Bacteria	52.4	2.5e-6	NR	MBK7450702.1	3140679	g7541	i0	63.4	1.31550802139037	41	15	65.8	0	62	184	1	41	MBK7450702.1 hypothetical protein [Candidatus Villigracilis vicinus]	diamond	246	52.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Candidatus Villigracilaceae	Candidatus Villigracilis	Candidatus Villigracilis vicinus
27959814	27959814	PRJNA407368_S_NODE_7805_length_184_cov_3.374194_g7703_i0	PRJNA407368	7805	184	3.374194	6.20851696	Chloroflexota bacterium	2026724	Bacteria	Bacteria	110	2.37e-26	NR	RPI93045.1	2026724	g7703	i0	88.5	1.98913043478261	61	7	99.5	0	2	184	100	160	RPI93045.1 MAG: hypothetical protein EHM40_11050 [Chloroflexota bacterium]	diamond	366	110	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28243837	28243837	PRJNA407368_S_NODE_10026_length_156_cov_2.204724_g9924_i0	PRJNA407368	10026	156	2.204724	3.43936944	Anaerolineae bacterium	2052143	Bacteria	Bacteria	65.1	6.78e-11	NR	MCB0191245.1	2052143	g9924	i0	67.5	0.769230769230769	40	13	76.9	0	31	150	27	66	MCB0191245.1 DNA adenine methylase [Anaerolineae bacterium]	diamond	120	65.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28623063	28623063	PRJNA407368_S_NODE_3707_length_304_cov_2.956364_g3605_i0	PRJNA407368	3707	304	2.956364	8.98734656	Chloroflexota bacterium	2026724	Bacteria	Bacteria	84.7	6.06e-18	NR	MBI5933277.1	2026724	g3605	i0	70.7	0.572368421052632	58	17	57.2	0	302	129	133	190	MBI5933277.1 hypothetical protein [Chloroflexota bacterium]	diamond	174	84.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30675615	30675615	PRJNA407368_S_NODE_2653_length_370_cov_13.659824_g2551_i0	PRJNA407368	2653	370	13.659824	50.5413488	Chloroflexota bacterium	2026724	Bacteria	Bacteria	90.5	1.86e-18	NR	PZC47394.1	2026724	g2551	i0	68.1	1.25675675675676	69	22	55.9	0	156	362	44	112	PZC47394.1 MAG: Calx-beta domain-containing protein [Chloroflexota bacterium]	diamond	465	90.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31655529	31655529	PRJNA407368_S_NODE_5017_length_248_cov_4.401826_g4915_i0	PRJNA407368	5017	248	4.401826	10.91652848	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	46.2	0.00235	NR	MFA5380279.1	2026734	g4915	i0	43.2	1.80241935483871	44	25	53.2	0	197	66	445	488	MFA5380279.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	447	46.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31750453	31750453	PRJNA407368_S_NODE_3817_length_298_cov_7.914498_g3715_i0	PRJNA407368	3817	298	7.914498	23.58520404	Anaerolineales bacterium	2073117	Bacteria	Bacteria	115	1.8700000000000003e-27	NR	HLF00845.1	2073117	g3715	i0	57.7	1.95302013422819	97	41	97.7	0	3	293	221	317	HLF00845.1 GAF domain-containing protein [Anaerolineales bacterium]	diamond	582	115	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32130438	32130438	PRJNA407368_S_NODE_3378_length_321_cov_2.640411_g3276_i0	PRJNA407368	3378	321	2.640411	8.47571931	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.1	2.5e-4	NR	HOU22807.1	2052143	g3276	i0	41.8	0.514018691588785	55	29	48.6	1	157	2	2	56	HOU22807.1 hypothetical protein [Anaerolineae bacterium]	diamond	165	50.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32825098	32825098	PRJNA407368_S_NODE_2400_length_395_cov_4.699454_g2298_i0	PRJNA407368	2400	395	4.699454	18.5628433	Chloroflexi bacterium ADurb.Bin36	1852861	Bacteria	Bacteria	137	5.999999999999998e-39	NR	OQA14461.1	1852861	g2298	i0	96.1	0.577215189873418	76	3	57.7	0	231	4	1	76	OQA14461.1 MAG: hypothetical protein BWY63_03165 [Chloroflexi bacterium ADurb.Bin360]	diamond	228	137	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium ADurb.Bin360

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