metadata: contig_metadata: 34 rows where bioproject = "PRJNA1010662", tax_kingdom = "Bacillati" and tax

34 rows where bioproject = "PRJNA1010662", 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
2276662	2276662	PRJNA1010662_S_NODE_682_length_344_cov_5.069767_g637_i0	PRJNA1010662	682	344	5.069767	17.43999848	Herpetosiphon	64	Bacteria	Bacteria	593	4.3099999999999986e-165	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g637	i0	97.688	216.186046511628	346	6	100	1	1	344	1988	2333	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	74368	593	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
2705237	2705237	PRJNA1010662_S_NODE_4443_length_164_cov_3.082645_g4398_i0	PRJNA1010662	4443	164	3.082645	5.0555378	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	200	4.62e-47	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g4398	i0	88.957	106.286585365854	163	17	99	1	2	164	596005	596166	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	17431	200	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
3981421	3981421	PRJNA1010662_S_NODE_3024_length_193_cov_2.013333_g2979_i0	PRJNA1010662	3024	193	2.013333	3.88573269	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	339	1.14e-88	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g2979	i0	98.942	57.4922279792746	189	2	98	0	5	193	5446478	5446666	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	11096	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
3981423	3981423	PRJNA1010662_S_NODE_3184_length_189_cov_2.876712_g3139_i0	PRJNA1010662	3184	189	2.876712	5.43698568	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	339	1.11e-88	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g3139	i0	98.942	5.77777777777778	189	2	100	0	1	189	1227801	1227989	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	1092	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
6533147	6533147	PRJNA1010662_S_NODE_126_length_660_cov_5.155592_g17_i1	PRJNA1010662	126	660	5.155592	34.0269072	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	726	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i1	86.738	785.916666666667	656	83	99	4	1	654	597847	597194	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	518705	726	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533154	6533154	PRJNA1010662_S_NODE_26_length_1030_cov_6.596758_g17_i0	PRJNA1010662	26	1030	6.596758	67.9466074	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1345	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i0	90.31	577.147572815534	1032	92	99	7	1	1029	598466	597440	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	594462	1345	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533159	6533159	PRJNA1010662_S_NODE_3086_length_191_cov_6.006757_g3041_i0	PRJNA1010662	3086	191	6.006757	11.47290587	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	270	4.17e-68	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3041	i0	92.147	127.973821989529	191	15	100	0	1	191	596777	596967	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	24443	270	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533160	6533160	PRJNA1010662_S_NODE_3106_length_191_cov_1.817568_g3061_i0	PRJNA1010662	3106	191	1.817568	3.47155488	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	75	3.51e-9	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3061	i0	97.727	0.785340314136126	44	0	23	1	22	64	2804628	2804585	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	150	75	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
10358104	10358104	PRJNA1010662_S_NODE_3309_length_186_cov_2.790210_g3264_i0	PRJNA1010662	3309	186	2.79021	5.1897906	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	71.3	4.39e-8	NTclustered	gi\|2107832821\|gb\|CP070822.1\|	2024896	g3264	i0	97.619	0.639784946236559	42	0	23	1	34	75	1948790	1948830	MAG: Anaerolineaceae bacterium isolate bin1136 chromosome	blastn	119	71.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
12908653	12908653	PRJNA1010662_S_NODE_131_length_648_cov_4.375207_g104_i0	PRJNA1010662	131	648	4.375207	28.35134136	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	593	8.539999999999997e-165	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i0	84.783	240.233024691358	598	83	92	8	1	595	598971	598379	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	155671	593	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20556133	20556133	PRJNA1010662_S_NODE_1697_length_240_cov_10.182741_g1652_i0	PRJNA1010662	1697	240	10.182741	24.4385784	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	364	2.4399999999999993e-96	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g1652	i0	94.142	106.108333333333	239	14	99	0	2	240	596740	596978	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	25466	364	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20556150	20556150	PRJNA1010662_S_NODE_3477_length_182_cov_3.359712_g3432_i0	PRJNA1010662	3477	182	3.359712	6.11467584	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	126	8.99e-25	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g3432	i0	86.441	85.489010989011	118	13	64	3	66	181	678255	678371	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	15559	126	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
23107269	23107269	PRJNA1010662_S_NODE_159_length_616_cov_6.071553_g17_i2	PRJNA1010662	159	616	6.071553	37.40076648	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	619	1.33e-172	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i2	84.927	795.590909090909	617	88	99	4	1	615	597847	597234	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	490084	619	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
24381026	24381026	PRJNA1010662_S_NODE_4580_length_163_cov_1.050000_g4535_i0	PRJNA1010662	4580	163	1.05	1.7115	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	239	9.72e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4535	i0	95.918	41.7546012269939	147	6	90	0	16	162	275902	275756	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	6806	239	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25227703	25227703	PRJNA1010662_S_NODE_220_length_547_cov_4.081349_g177_i0	PRJNA1010662	220	547	4.081349	22.32497903	Herpetosiphon	64	Bacteria	Bacteria	928	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g177	i0	97.258	28.3674588665448	547	15	100	0	1	547	1801	1255	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	15517	928	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
25227723	25227723	PRJNA1010662_S_NODE_3920_length_173_cov_2.969231_g3875_i0	PRJNA1010662	3920	173	2.969231	5.13676963	Herpetosiphon	64	Bacteria	Bacteria	313	6.04e-81	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g3875	i0	99.419	166.543352601156	172	1	99	0	2	173	1140	969	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	28812	313	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
27224007	27224007	PRJNA1010662_P_NODE_7023_length_211_cov_1.265432_g6964_i0	PRJNA1010662	7023	211	1.265432	2.67006152	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	119	2.34e-30	NR	HET8846813.1	2740538	g6964	i0	77.1	0.995260663507109	70	16	99.5	0	1	210	151	220	HET8846813.1 cystathionine gamma-synthase [Ktedonobacteraceae bacterium]	diamond	210	119	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
27375058	27375058	PRJNA1010662_P_NODE_14683_length_165_cov_0.896552_g14624_i0	PRJNA1010662	14683	165	0.896552	1.4793108	root	1	Root_unresolved	Root_unresolved	41.2	0.0458	NR	MFC1996312.1	2026724	g14624	i0	46.8	3.70909090909091	47	25	85.5	0	25	165	58	104	MFC1996312.1 GDSL-type esterase/lipase family protein [Chloroflexota bacterium]	diamond	612	41.6	0.990384615384615	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27382301	27382301	PRJNA1010662_P_NODE_14743_length_165_cov_0.896552_g14684_i0	PRJNA1010662	14743	165	0.896552	1.4793108	Anaerolineae bacterium	2052143	Bacteria	Bacteria	60.1	3.2e-9	NR	MCB0156437.1	2052143	g14684	i0	58.5	0.963636363636364	53	22	96.4	0	161	3	85	137	MCB0156437.1 Hsp70 family protein [Anaerolineae bacterium]	diamond	159	60.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27540155	27540155	PRJNA1010662_P_NODE_14584_length_165_cov_1.327586_g14525_i0	PRJNA1010662	14584	165	1.327586	2.1905169	Anaerolineales bacterium	2073117	Bacteria	Bacteria	48.9	8.84e-5	NR	MBE0672193.1	2073117	g14525	i0	56.3	1.23636363636364	32	14	58.2	0	150	55	305	336	MBE0672193.1 tetratricopeptide repeat protein [Anaerolineales bacterium]	diamond	204	48.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27848153	27848153	PRJNA1010662_P_NODE_12464_length_169_cov_1.275000_g12405_i0	PRJNA1010662	12464	169	1.275	2.15475	Bacteria	2	Bacteria	Bacteria	47.8	2.24e-4	NR	HEY5639825.1	2026734	g12405	i0	40.9	4.63313609467456	44	26	78.1	0	167	36	90	133	HEY5639825.1 phosphotransferase [Dehalococcoidia bacterium]	diamond	783	48.1	0.993762993762994	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28108239	28108239	PRJNA1010662_P_NODE_14025_length_166_cov_0.888889_g13966_i0	PRJNA1010662	14025	166	0.888889	1.47555574	Chloroflexi bacterium SZAS-1	2807729	Bacteria	Bacteria	119	1.0500000000000001e-30	NR	MBS1964241.1	2807729	g13966	i0	98.2	0.993975903614458	55	1	99.4	0	2	166	272	326	MBS1964241.1 hypothetical protein [Chloroflexi bacterium SZAS-1]	diamond	165	119	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium SZAS-1
29055760	29055760	PRJNA1010662_P_NODE_12728_length_168_cov_1.739496_g12669_i0	PRJNA1010662	12728	168	1.739496	2.92235328	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	50.4	2.51e-5	NR	MCJ7519601.1	2024896	g12669	i0	44.7	0.839285714285714	47	26	83.9	0	167	27	177	223	MCJ7519601.1 DUF1116 domain-containing protein [Anaerolineaceae bacterium]	diamond	141	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
29268946	29268946	PRJNA1010662_P_NODE_12389_length_169_cov_1.658333_g12330_i0	PRJNA1010662	12389	169	1.658333	2.80258277	Herpetosiphon	64	Bacteria	Bacteria	92.8	4.7299999999999996e-23	NR	WP_054533819.1	70996	g12330	i0	93.6	1.66863905325444	47	3	83.4	0	28	168	1	47	WP_054533819.1 hypothetical protein [Herpetosiphon geysericola]	diamond	282	93.2	0.995708154506438	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon geysericola
30003078	30003078	PRJNA1010662_P_NODE_4831_length_243_cov_0.927835_g4772_i0	PRJNA1010662	4831	243	0.927835	2.25463905	Anaerolineae bacterium	2052143	Bacteria	Bacteria	53.9	4.48e-6	NR	HNS01227.1	2052143	g4772	i0	47.7	1.25925925925926	65	33	79	1	49	240	1004	1068	HNS01227.1 BTAD domain-containing putative transcriptional regulator [Anaerolineae bacterium]	diamond	306	53.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30184924	30184924	PRJNA1010662_P_NODE_9772_length_186_cov_1.481752_g9713_i0	PRJNA1010662	9772	186	1.481752	2.75605872	root	1	Root_unresolved	Root_unresolved	48.9	6.83e-5	NR	MDY7040159.1	2026724	g9713	i0	48.9	2.14516129032258	47	23	74.2	1	15	152	128	174	MDY7040159.1 DUF5519 family protein [Chloroflexota bacterium]	diamond	399	48.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30445442	30445442	PRJNA1010662_P_NODE_6593_length_216_cov_0.934132_g6534_i0	PRJNA1010662	6593	216	0.934132	2.01772512	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	47.8	4.56e-4	NR	HLI07359.1	2740538	g6534	i0	50.8	0.819444444444444	59	25	81.9	3	183	7	484	538	HLI07359.1 FAD-binding protein [Ktedonobacteraceae bacterium]	diamond	177	47.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
30792765	30792765	PRJNA1010662_P_NODE_8054_length_200_cov_1.370861_g7995_i0	PRJNA1010662	8054	200	1.370861	2.741722	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42	0.0379	NR	MEN6480508.1	2073117	g7995	i0	47.6	0.63	42	22	63	0	37	162	178	219	MEN6480508.1 dephospho-CoA kinase [Anaerolineales bacterium]	diamond	126	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30887600	30887600	PRJNA1010662_P_NODE_13374_length_167_cov_1.322034_g13315_i0	PRJNA1010662	13374	167	1.322034	2.20779678	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.8	0.00108	NR	MCH7642797.1	2026724	g13315	i0	41.2	4.40119760479042	51	27	91.6	2	163	11	101	148	MCH7642797.1 phosphotransferase [Chloroflexota bacterium]	diamond	735	45.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31077323	31077323	PRJNA1010662_P_NODE_10775_length_179_cov_1.392308_g10716_i0	PRJNA1010662	10775	179	1.392308	2.49223132	Anaerolineales bacterium	2073117	Bacteria	Bacteria	45.8	0.00129	NR	MCA9987602.1	2073117	g10716	i0	46.8	1.52513966480447	47	25	78.8	0	27	167	8	54	MCA9987602.1 AMP-binding protein [Anaerolineales bacterium]	diamond	273	45.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31354284	31354284	PRJNA1010662_P_NODE_6696_length_214_cov_2.957576_g6637_i0	PRJNA1010662	6696	214	2.957576	6.32921264	Bacteria	2	Bacteria	Bacteria	115	1.53e-28	NR	MCX6080782.1	2026724	g6637	i0	72.5	7.76635514018692	69	19	96.7	0	213	7	240	308	MCX6080782.1 aspartate aminotransferase family protein [Chloroflexota bacterium]	diamond	1662	115	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32311079	32311079	PRJNA1010662_P_NODE_5499_length_231_cov_1.445055_g5440_i0	PRJNA1010662	5499	231	1.445055	3.33807705	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.4	0.00347	NR	MBV9358052.1	2026724	g5440	i0	38.1	2.12987012987013	63	37	81.8	1	206	18	14	74	MBV9358052.1 FAD-binding protein [Chloroflexota bacterium]	diamond	492	45.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32405778	32405778	PRJNA1010662_P_NODE_15619_length_164_cov_0.886957_g15560_i0	PRJNA1010662	15619	164	0.886957	1.45460948	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	76.3	4.48e-16	NR	MCB9430965.1	2614247	g15560	i0	92.5	0.731707317073171	40	3	73.2	0	2	121	87	126	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	120	76.3	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
32437589	32437589	PRJNA1010662_P_NODE_15839_length_163_cov_1.403509_g15780_i0	PRJNA1010662	15839	163	1.403509	2.28771967	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42	0.0238	NR	HKZ50321.1	2026734	g15780	i0	44.4	0.828220858895706	45	25	82.8	0	159	25	49	93	HKZ50321.1 regulatory iron-sulfur-containing complex subunit RicT [Dehalococcoidia bacterium]	diamond	135	42	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;