metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Acidobacteriota"

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
379288	379288	PRJNA312899_P_NODE_27701_length_353_cov_6.539474_g27259_i0	PRJNA312899	27701	353	6.539474	23.08434322	Tunturiibacter lichenicola	2051959	Bacteria	Bacteria	444	4.71e-120	NTclustered	gi\|2304905231\|gb\|CP073696.1\|	2051959	g27259	i0	89.855	30.929178470255	345	35	98	0	8	352	2472838	2472494	Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome	blastn	10918	444	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter lichenicola
2930851	2930851	PRJNA312899_P_NODE_8043_length_662_cov_25.841762_g7667_i0	PRJNA312899	8043	662	25.841762	171.07246444	Paludibaculum fermentans	1473598	Bacteria	Bacteria	756	0	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g7667	i0	87.463	1.01208459214502	670	67	100	15	1	662	6289432	6290092	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	670	756	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
4206108	4206108	PRJNA312899_P_NODE_102164_length_161_cov_0.910714_g101722_i0	PRJNA312899	102164	161	0.910714	1.46624954	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	63.9	6.18e-6	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g101722	i0	97.297	3.01863354037267	37	1	23	0	13	49	3675290	3675254	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	486	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
4206715	4206715	PRJNA312899_P_NODE_41064_length_278_cov_2.096070_g40622_i0	PRJNA312899	41064	278	2.09607	5.8270746	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g40622	i0	99.64	1	278	1	100	0	1	278	3857021	3857298	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	278	508	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
4207322	4207322	PRJNA312899_P_NODE_75364_length_185_cov_2.250000_g74922_i0	PRJNA312899	75364	185	2.25	4.1625	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	226	8.789999999999998e-55	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g74922	i0	88.77	53.1675675675676	187	18	100	3	1	185	317447	317262	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	9836	226	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5483193	5483193	PRJNA312899_P_NODE_51905_length_240_cov_4.246073_g51463_i0	PRJNA312899	51905	240	4.246073	10.1905752	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g51463	i0	100	1	240	0	100	0	1	240	1587738	1587977	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	240	444	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
5483297	5483297	PRJNA312899_P_NODE_57585_length_224_cov_2.331429_g57143_i0	PRJNA312899	57585	224	2.331429	5.22240096	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	104	5.42e-18	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g57143	i0	85.047	5.09821428571429	107	10	46	6	44	146	1826398	1826294	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	1142	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
5483571	5483571	PRJNA312899_P_NODE_75005_length_186_cov_1.481752_g74563_i0	PRJNA312899	75005	186	1.481752	2.75605872	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	150	5.48e-32	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g74563	i0	81.283	1.79032258064516	187	33	100	2	1	186	208423	208608	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	333	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
6757142	6757142	PRJNA312899_P_NODE_37506_length_294_cov_2.485714_g37064_i0	PRJNA312899	37506	294	2.485714	7.30799916	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	448	2.979999999999999e-121	NTclustered	gi\|2874253693\|emb\|OY969419.1\|	194844	g37064	i0	94.483	13.6904761904762	290	16	99	0	1	290	2441030	2440741	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1	blastn	4025	448	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
6757865	6757865	PRJNA312899_P_NODE_79326_length_180_cov_1.183206_g78884_i0	PRJNA312899	79326	180	1.183206	2.1297708	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	126	8.87e-25	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g78884	i0	81.529	7.56666666666667	157	25	86	4	1	155	1315916	1315762	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	1362	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
9306935	9306935	PRJNA312899_P_NODE_103448_length_159_cov_4.163636_g103006_i0	PRJNA312899	103448	159	4.163636	6.62018124	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	191	2.67e-44	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g103006	i0	88.535	38.1509433962264	157	18	99	0	1	157	2366480	2366324	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	6066	191	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9308000	9308000	PRJNA312899_P_NODE_67488_length_199_cov_3.226667_g67046_i0	PRJNA312899	67488	199	3.226667	6.42106733	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g67046	i0	100	1	199	0	100	0	1	199	2608653	2608851	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	199	368	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
9308276	9308276	PRJNA312899_P_NODE_83748_length_171_cov_3.622951_g83306_i0	PRJNA312899	83748	171	3.622951	6.19524621	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	147	6.389999999999999e-31	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g83306	i0	85.315	0.83625730994152	143	20	84	1	29	171	1210917	1210776	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	143	147	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11858000	11858000	PRJNA312899_P_NODE_31570_length_327_cov_4.035971_g31128_i0	PRJNA312899	31570	327	4.035971	13.19762517	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	488	1.98e-133	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g31128	i0	93.636	304.544342507645	330	16	100	4	1	327	3176184	3176511	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	99586	488	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13133498	13133498	PRJNA312899_P_NODE_5231_length_795_cov_52.636729_g4919_i0	PRJNA312899	5231	795	52.636729	418.46199555	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	313	3.32e-80	NTclustered	gi\|2874253940\|emb\|OY970265.1\|	171953	g4919	i0	82.906	3.46163522012579	351	56	44	3	21	369	47915	47567	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1	blastn	2752	313	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13133829	13133829	PRJNA312899_P_NODE_73271_length_188_cov_1.467626_g72829_i0	PRJNA312899	73271	188	1.467626	2.75913688	Bryobacterales bacterium	2026791	Bacteria	Bacteria	130	7.24e-26	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g72829	i0	87.069	0.617021276595745	116	14	62	1	67	182	3727745	3727631	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	116	130	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
14407781	14407781	PRJNA312899_P_NODE_101672_length_161_cov_0.910714_g101230_i0	PRJNA312899	101672	161	0.910714	1.46624954	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	89.8	1.02e-13	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g101230	i0	94.737	23.0869565217391	57	3	35	0	105	161	2289939	2289995	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	3717	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
14408259	14408259	PRJNA312899_P_NODE_29952_length_337_cov_10.798611_g29510_i0	PRJNA312899	29952	337	10.798611	36.39131907	Paludibaculum fermentans	1473598	Bacteria	Bacteria	370	7.73e-98	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g29510	i0	86.787	31.0890207715134	333	42	98	2	4	334	6647046	6647378	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	10477	370	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
14408329	14408329	PRJNA312899_P_NODE_34072_length_312_cov_5.882129_g33630_i0	PRJNA312899	34072	312	5.882129	18.35224248	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	147	1.3e-30	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g33630	i0	82.822	0.522435897435897	163	28	52	0	1	163	6971360	6971522	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	163	147	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14409336	14409336	PRJNA312899_P_NODE_95292_length_164_cov_0.886957_g94850_i0	PRJNA312899	95292	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	106	1.04e-18	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g94850	i0	81.89	1.1219512195122	127	22	77	1	4	130	2638813	2638688	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	184	106	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15681867	15681867	PRJNA312899_P_NODE_18733_length_436_cov_4.726098_g18292_i0	PRJNA312899	18733	436	4.726098	20.60578728	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	806	0	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g18292	i0	100	1.45412844036697	436	0	100	0	1	436	3245738	3246173	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	634	806	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
16957560	16957560	PRJNA312899_P_NODE_77214_length_183_cov_1.522388_g76772_i0	PRJNA312899	77214	183	1.522388	2.78597004	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	228	2.4099999999999995e-55	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g76772	i0	89.13	115.693989071038	184	18	100	2	1	183	4233961	4233779	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	21172	228	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16957773	16957773	PRJNA312899_P_NODE_90034_length_166_cov_0.871795_g89592_i0	PRJNA312899	90034	166	0.871795	1.4471797	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	135	1.34e-27	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g89592	i0	88.991	3.00602409638554	109	12	66	0	1	109	3158002	3157894	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	499	135	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18230825	18230825	PRJNA312899_P_NODE_19235_length_430_cov_22.262467_g18794_i0	PRJNA312899	19235	430	22.262467	95.7286081	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	791	0	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g18794	i0	100	1.5	428	0	99	0	1	428	1349390	1348963	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	645	791	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
18232033	18232033	PRJNA312899_P_NODE_89915_length_166_cov_0.871795_g89473_i0	PRJNA312899	89915	166	0.871795	1.4471797	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	110	8.13e-20	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g89473	i0	81.295	2.46385542168675	139	22	83	3	14	150	4910416	4910280	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	409	110	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18232166	18232166	PRJNA312899_P_NODE_99035_length_162_cov_0.902655_g98593_i0	PRJNA312899	99035	162	0.902655	1.4623011	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	135	1.3e-27	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g98593	i0	82.5	3.50617283950617	160	22	97	6	6	162	73402	73246	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	568	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
18915683	18915683	PRJNA312899_P_NODE_101395_length_161_cov_0.910714_g100953_i0	PRJNA312899	101395	161	0.910714	1.46624954	Pseudomonadati	3379134	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g100953	i0	100	1.41614906832298	30	0	19	0	57	86	6814505	6814534	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	228	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
19505950	19505950	PRJNA312899_P_NODE_6476_length_728_cov_16.795287_g6129_i0	PRJNA312899	6476	728	16.795287	122.26968936	Bryobacterales bacterium	2026791	Bacteria	Bacteria	484	6.059999999999998e-132	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g6129	i0	80.122	29.2032967032967	654	126	90	4	72	723	5087305	5086654	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	21260	484	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
20781691	20781691	PRJNA312899_P_NODE_78577_length_181_cov_1.545455_g78135_i0	PRJNA312899	78577	181	1.545455	2.79727355	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g78135	i0	92.105	0.209944751381215	38	2	21	1	84	121	1765594	1765630	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	38	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
23331205	23331205	PRJNA312899_P_NODE_20339_length_417_cov_27.904891_g19898_i0	PRJNA312899	20339	417	27.904891	116.36339547	Terriglobus roseus	392734	Bacteria	Bacteria	67.6	1.43e-6	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g19898	i0	97.436	1.54916067146283	39	1	18	0	283	321	2205286	2205248	Terriglobus roseus DSM 18391, complete genome	blastn	646	67.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
24605340	24605340	PRJNA312899_P_NODE_30440_length_334_cov_7.196491_g29998_i0	PRJNA312899	30440	334	7.196491	24.03627994	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	617	2.48e-172	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g29998	i0	100	2.02395209580838	334	0	100	0	1	334	2002830	2002497	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	676	617	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
24606527	24606527	PRJNA312899_P_NODE_95780_length_164_cov_0.869565_g95338_i0	PRJNA312899	95780	164	0.869565	1.4260866	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	97.1	6.24e-16	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g95338	i0	86.364	0.536585365853659	88	12	54	0	48	135	1338124	1338211	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	88	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;