metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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
248874	248874	PRJNA1120060_P_NODE_2234381_length_263_cov_4.647368_g2216327_i0	PRJNA1120060	2234381	263	4.647368	12.22257784	Bryobacterales bacterium	2026791	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2913438621\|emb\|OZ224030.1\|	2026791	g2216327	i0	100	0.114068441064639	30	0	11	0	173	202	1720429	1720458	MAG: Bryobacterales bacterium isolate 7c2e36ee-14bd-451a-b5bf-70b98c7e11c2 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
1529566	1529566	PRJNA1120060_P_NODE_2717022_length_248_cov_1.377143_g2698939_i0	PRJNA1120060	2717022	248	1.377143	3.41531464	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g2698939	i0	100	0.112903225806452	28	0	11	0	91	118	396909	396882	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1547602	1547602	PRJNA1120060_P_NODE_912242_length_312_cov_3.979079_g894313_i0	PRJNA1120060	912242	312	3.979079	12.41472648	uncultured Vicinamibacterales bacterium	3036250	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2546137835\|emb\|OY282382.1\|	3036250	g894313	i0	100	0.0897435897435897	28	0	9	0	278	305	1222442	1222469	MAG: uncultured Vicinamibacterales bacterium isolate e65da963-7c29-4b68-91ce-224fd25ea74c genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			uncultured Vicinamibacterales bacterium
4072082	4072082	PRJNA1120060_P_NODE_1956104_length_274_cov_3.502488_g1938078_i0	PRJNA1120060	1956104	274	3.502488	9.59681712	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	158	5.1799999999999986e-34	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g1938078	i0	83.832	0.60948905109489	167	26	61	1	106	272	651526	651691	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	167	158	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4080144	4080144	PRJNA1120060_P_NODE_2569684_length_252_cov_0.865922_g2551609_i0	PRJNA1120060	2569684	252	0.865922	2.18212344	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	231	2.73e-56	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g2551609	i0	86.111	6.38095238095238	216	28	85	2	38	252	4381612	4381398	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	1608	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
4089870	4089870	PRJNA1120060_P_NODE_3418804_length_214_cov_5.453901_g3400682_i0	PRJNA1120060	3418804	214	5.453901	11.67134814	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	82.4	2.4e-11	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g3400682	i0	91.525	0.275700934579439	59	5	28	0	154	212	3816654	3816712	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	59	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4098271	4098271	PRJNA1120060_P_NODE_788724_length_322_cov_0.835341_g770848_i0	PRJNA1120060	788724	322	0.835341	2.68979802	Acidisarcina polymorpha	2211140	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1431854037\|gb\|CP030840.1\|	2211140	g770848	i0	96.875	0.0993788819875776	32	0	10	1	272	303	3770749	3770779	Acidisarcina polymorpha strain SBC82 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidisarcina	Acidisarcina polymorpha
5347217	5347217	PRJNA1120060_P_NODE_1876705_length_277_cov_8.132353_g1858686_i0	PRJNA1120060	1876705	277	8.132353	22.52661781	Granulicella sp. 5B5	1617967	Bacteria	Bacteria	235	2.3599999999999997e-57	NTclustered	gi\|1886125103\|gb\|CP046444.1\|	1617967	g1858686	i0	81.949	1	277	50	100	0	1	277	2757121	2756845	Granulicella sp. 5B5 chromosome, complete genome	blastn	277	235	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. 5B5
5353699	5353699	PRJNA1120060_P_NODE_2354685_length_259_cov_1.962366_g2336624_i0	PRJNA1120060	2354685	259	1.962366	5.08252794	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	324	4.53e-84	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g2336624	i0	89.231	16.1814671814672	260	26	100	2	1	259	5556465	5556723	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	4191	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
7889967	7889967	PRJNA1120060_P_NODE_1384707_length_298_cov_4.253333_g1366727_i0	PRJNA1120060	1384707	298	4.253333	12.67493234	Luteitalea pratensis	1855912	Bacteria	Bacteria	178	4.379999999999999e-40	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g1366727	i0	88.435	2.3758389261745	147	17	49	0	152	298	620112	619966	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	708	178	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
9160584	9160584	PRJNA1120060_P_NODE_1100408_length_311_cov_3.054622_g1082473_i0	PRJNA1120060	1100408	311	3.054622	9.49987442	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	97.1	1.32e-15	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g1082473	i0	78.289	0.488745980707395	152	31	49	2	1	151	2649884	2650034	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	152	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
9189598	9189598	PRJNA1120060_P_NODE_3325668_length_224_cov_5.105960_g3307556_i0	PRJNA1120060	3325668	224	5.10596	11.4373504	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	172	1.46e-38	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g3307556	i0	91.27	3	126	11	56	0	99	224	459845	459720	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	672	172	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
11731331	11731331	PRJNA1120060_P_NODE_2531510_length_253_cov_0.866667_g2513438_i0	PRJNA1120060	2531510	253	0.866667	2.19266751	Tunturiibacter gelidiferens	3069689	Bacteria	Bacteria	95.3	3.76e-15	NTclustered	gi\|2750677617\|gb\|CP132938.1\|	3069689	g2513438	i0	91.304	0.541501976284585	69	6	27	0	1	69	2808288	2808220	Tunturiibacter gelidoferens strain M8UP39 chromosome	blastn	137	95.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter gelidiferens
14293318	14293318	PRJNA1120060_P_NODE_3576352_length_200_cov_8.787402_g3558225_i0	PRJNA1120060	3576352	200	8.787402	17.574804	Candidatus Korobacter versatilis	658062	Bacteria	Bacteria	143	1e-29	NTclustered	gi\|94549081\|gb\|CP000360.1\|	204669	g3558225	i0	80.311	4.97	193	34	96	4	10	200	1677682	1677492	Candidatus Koribacter versatilis Ellin345, complete genome	blastn	994	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter versatilis
15554677	15554677	PRJNA1120060_P_NODE_2462973_length_255_cov_2.164835_g2444903_i0	PRJNA1120060	2462973	255	2.164835	5.52032925	Terriglobus roseus	392734	Bacteria	Bacteria	276	1.26e-69	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g2444903	i0	86.694	73.7098039215686	248	33	97	0	1	248	1824808	1825055	Terriglobus roseus DSM 18391, complete genome	blastn	18796	276	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
15558306	15558306	PRJNA1120060_P_NODE_2774353_length_246_cov_5.583815_g2756267_i0	PRJNA1120060	2774353	246	5.583815	13.7361849	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g2756267	i0	85.281	98.0934959349593	231	34	94	0	14	244	4536389	4536619	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	24131	239	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
15564591	15564591	PRJNA1120060_P_NODE_3321113_length_224_cov_17.503311_g3303002_i0	PRJNA1120060	3321113	224	17.503311	39.20741664	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	226	1.1099999999999999e-54	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g3303002	i0	92.903	3.29464285714286	155	11	69	0	1	155	210054	210208	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	738	226	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18086492	18086492	PRJNA1120060_P_NODE_1229755_length_310_cov_2.105485_g1211815_i0	PRJNA1120060	1229755	310	2.105485	6.5270035	Thermotomaculum hydrothermale	981385	Bacteria	Bacteria	60.2	1.73e-4	NTclustered	gi\|1941646770\|dbj\|AP017470.1\|	981385	g1211815	i0	97.143	0.112903225806452	35	1	11	0	103	137	1788646	1788612	Thermotomaculum hydrothermale DNA, complete genome, strain: AC55	blastn	35	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Thermotomaculales	Thermotomaculaceae	Thermotomaculum	Thermotomaculum hydrothermale
18088723	18088723	PRJNA1120060_P_NODE_1380215_length_298_cov_8.688889_g1362235_i0	PRJNA1120060	1380215	298	8.688889	25.89288922	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	122	2.0799999999999994e-23	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g1362235	i0	84.553	2.40939597315436	123	19	41	0	169	291	1749656	1749534	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	718	122	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18091046	18091046	PRJNA1120060_P_NODE_1543535_length_291_cov_3.087156_g1525544_i0	PRJNA1120060	1543535	291	3.087156	8.98362396	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g1525544	i0	100	0.0962199312714777	28	0	10	0	206	233	794099	794072	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
18093184	18093184	PRJNA1120060_P_NODE_1695555_length_285_cov_2.080189_g1677551_i0	PRJNA1120060	1695555	285	2.080189	5.92853865	Bryobacterales bacterium	2026791	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g1677551	i0	100	0.0982456140350877	28	0	10	0	71	98	2025037	2025010	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
18104928	18104928	PRJNA1120060_P_NODE_2564415_length_252_cov_0.871508_g2546340_i0	PRJNA1120060	2564415	252	0.871508	2.19620016	Bryobacterales bacterium	2026791	Bacteria	Bacteria	143	1.32e-29	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g2546340	i0	83.23	32.4126984126984	161	22	81	5	96	252	6857794	6857953	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	8168	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
20645070	20645070	PRJNA1120060_P_NODE_1865837_length_278_cov_1.960976_g1847821_i0	PRJNA1120060	1865837	278	1.960976	5.45151328	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	121	6.92e-23	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g1847821	i0	91.209	24.136690647482	91	5	32	3	71	160	1017355	1017267	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	6710	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
20655581	20655581	PRJNA1120060_P_NODE_2674937_length_249_cov_1.448864_g2656856_i0	PRJNA1120060	2674937	249	1.448864	3.60767136	Terriglobus roseus	392734	Bacteria	Bacteria	237	5.8e-58	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g2656856	i0	83.936	2.96385542168675	249	38	99	2	2	249	1648902	1648655	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	738	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
20656411	20656411	PRJNA1120060_P_NODE_2745157_length_247_cov_2.488506_g2727073_i0	PRJNA1120060	2745157	247	2.488506	6.14660982	uncultured Vicinamibacterales bacterium	3036250	Bacteria	Bacteria	104	6.08e-18	NTclustered	gi\|2546137835\|emb\|OY282382.1\|	3036250	g2727073	i0	87.778	1.89068825910931	90	9	36	2	148	236	1784886	1784974	MAG: uncultured Vicinamibacterales bacterium isolate e65da963-7c29-4b68-91ce-224fd25ea74c genome assembly, chromosome: 1	blastn	467	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			uncultured Vicinamibacterales bacterium
23216445	23216445	PRJNA1120060_P_NODE_3543439_length_203_cov_5.261538_g3525312_i0	PRJNA1120060	3543439	203	5.261538	10.68092214	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	172	1.2999999999999998e-38	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g3525312	i0	82.323	1.44334975369458	198	35	98	0	2	199	265591	265394	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	293	172	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
23224470	23224470	PRJNA1120060_P_NODE_854719_length_314_cov_2.082988_g836799_i0	PRJNA1120060	854719	314	2.082988	6.54058232	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	104	8e-18	NTclustered	gi\|2108168239\|gb\|CP070717.1\|	1978231	g836799	i0	84.615	0.331210191082803	104	16	33	0	206	309	5025366	5025263	MAG: Acidobacteria bacterium isolate bin48 chromosome	blastn	104	104	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24473148	24473148	PRJNA1120060_P_NODE_2093800_length_269_cov_1.576531_g2075760_i0	PRJNA1120060	2093800	269	1.576531	4.24086839	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	163	1.09e-35	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g2075760	i0	80.861	0.776951672862453	209	38	77	2	59	266	1720110	1719903	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	209	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24476243	24476243	PRJNA1120060_P_NODE_2330860_length_260_cov_1.582888_g2312800_i0	PRJNA1120060	2330860	260	1.582888	4.1155088	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	281	2.78e-71	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g2312800	i0	86.957	24.8192307692308	253	29	97	4	10	260	476990	477240	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	6453	281	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
25252479	25252479	PRJNA1120060_P_NODE_2544500_length_252_cov_3.061453_g2526425_i0	PRJNA1120060	2544500	252	3.061453	7.71486156	Pseudomonadati	3379134	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g2526425	i0	83.137	185.063492063492	255	31	98	10	1	246	1534600	1534851	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	46636	222	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota 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);;