metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
275602	275602	PRJNA1120203_P_NODE_94361_length_245_cov_0.895349_g93345_i0	PRJNA1120203	94361	245	0.895349	2.19360505	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	228	3.4199999999999995e-55	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g93345	i0	86.19	1.83265306122449	210	29	86	0	22	231	200856	200647	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	449	228	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
2825757	2825757	PRJNA1120203_P_NODE_57023_length_298_cov_4.302222_g56007_i0	PRJNA1120203	57023	298	4.302222	12.82062156	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	475	1.3899999999999996e-129	NTclustered	gi\|2430736796\|emb\|OV285505.1\|	171953	g56007	i0	96.575	97.7248322147651	292	1	95	1	14	296	1	292	uncultured Acidobacteria partial 16S rRNA gene	blastn	29122	475	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4101584	4101584	PRJNA1120203_P_NODE_104524_length_241_cov_0.916667_g103508_i0	PRJNA1120203	104524	241	0.916667	2.20916747	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	217	7.269999999999999e-52	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g103508	i0	84.977	73.9460580912863	213	32	88	0	16	228	3210282	3210070	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	17821	217	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
4102594	4102594	PRJNA1120203_P_NODE_91644_length_246_cov_0.890173_g90628_i0	PRJNA1120203	91644	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	202	2.08e-47	NTclustered	gi\|2874253939\|emb\|OY970264.1\|	171953	g90628	i0	81.707	26.630081300813	246	41	99	4	1	244	3364273	3364030	MAG: uncultured Acidobacteriota bacterium isolate MFD03726.bin.c.8 genome assembly, chromosome: 1	blastn	6551	202	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5378444	5378444	PRJNA1120203_P_NODE_76965_length_253_cov_1.383333_g75949_i0	PRJNA1120203	76965	253	1.383333	3.49983249	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	180	1.01e-40	NTclustered	gi\|2874253956\|emb\|OY970281.1\|	194844	g75949	i0	79.839	0.980237154150198	248	48	98	2	1	247	3404245	3403999	MAG: uncultured Acidobacteriaceae bacterium isolate MFD00008.bin.c.2 genome assembly, chromosome: 1	blastn	248	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
6653396	6653396	PRJNA1120203_P_NODE_89686_length_247_cov_0.885057_g88670_i0	PRJNA1120203	89686	247	0.885057	2.18609079	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	174	4.57e-39	NTclustered	gi\|2621701354\|emb\|OY760074.1\|	1978231	g88670	i0	79.435	1.20242914979757	248	49	100	2	1	247	1277002	1277248	MAG: Acidobacteriota bacterium isolate e8b00ceb-3b51-4674-b3e1-58c3ce2e7457 genome assembly, chromosome: 1	blastn	297	174	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7928503	7928503	PRJNA1120203_P_NODE_93107_length_246_cov_0.861272_g92091_i0	PRJNA1120203	93107	246	0.861272	2.11872912	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	230	9.56e-56	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g92091	i0	83.817	4.02439024390244	241	39	98	0	3	243	3370348	3370588	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	990	230	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7928521	7928521	PRJNA1120203_P_NODE_94727_length_245_cov_0.895349_g93711_i0	PRJNA1120203	94727	245	0.895349	2.19360505	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	316	7.099999999999998e-82	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g93711	i0	89.919	37.6448979591837	248	22	100	2	1	245	3634991	3635238	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	9223	316	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
9202412	9202412	PRJNA1120203_P_NODE_100388_length_243_cov_0.905882_g99372_i0	PRJNA1120203	100388	243	0.905882	2.20129326	Granulicella mallensis	940614	Bacteria	Bacteria	183	7.44e-42	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g99372	i0	80.328	2.69958847736626	244	46	100	2	1	243	5369930	5370172	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	656	183	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
9202949	9202949	PRJNA1120203_P_NODE_53568_length_308_cov_11.323404_g52552_i0	PRJNA1120203	53568	308	11.323404	34.87608432	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	446	1.13e-120	NTclustered	gi\|2163809345\|emb\|LR982343.1\|	171953	g52552	i0	94.218	95.4675324675325	294	14	95	3	15	307	1	292	uncultured Acidobacteria partial 16S rRNA gene	blastn	29404	446	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9203429	9203429	PRJNA1120203_P_NODE_87568_length_248_cov_0.880000_g86552_i0	PRJNA1120203	87568	248	0.88	2.1824	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	187	5.8899999999999985e-43	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g86552	i0	80.876	37.4193548387097	251	36	99	8	1	245	1438622	1438866	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	9280	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
9203516	9203516	PRJNA1120203_P_NODE_92988_length_246_cov_0.890173_g91972_i0	PRJNA1120203	92988	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.61e-48	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g91972	i0	83.111	79.6056910569106	225	38	91	0	22	246	1478705	1478481	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	19583	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13028289	13028289	PRJNA1120203_P_NODE_105211_length_241_cov_0.916667_g104195_i0	PRJNA1120203	105211	241	0.916667	2.20916747	Acidobacterium capsulatum	33075	Bacteria	Bacteria	224	4.3399999999999996e-54	NTclustered	gi\|225791207\|gb\|CP001472.1\|	240015	g104195	i0	83.402	5.01659751037344	241	40	100	0	1	241	3072294	3072054	Acidobacterium capsulatum ATCC 51196, complete genome	blastn	1209	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
13029302	13029302	PRJNA1120203_P_NODE_92631_length_246_cov_0.890173_g91615_i0	PRJNA1120203	92631	246	0.890173	2.18982558	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g91615	i0	89.024	96.2926829268293	246	27	100	0	1	246	4658209	4657964	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	23688	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
13029413	13029413	PRJNA1120203_P_NODE_99671_length_243_cov_0.905882_g98655_i0	PRJNA1120203	99671	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	217	7.34e-52	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g98655	i0	83.264	45.5473251028807	239	36	98	4	1	237	3909098	3908862	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	11068	217	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13781166	13781166	PRJNA1120203_P_NODE_54311_length_306_cov_7.493562_g53295_i0	PRJNA1120203	54311	306	7.493562	22.93029972	Edaphobacter	388463	Bacteria	Bacteria	531	3.0099999999999998e-146	NTclustered	gi\|37961630\|gb\|AY234473.1\|	234244	g53295	i0	99.317	95.6699346405229	293	2	96	0	12	304	737	445	Bacterium Ellin5056 16S ribosomal RNA gene, partial sequence	blastn	29275	531	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		bacterium Ellin5056
14304438	14304438	PRJNA1120203_P_NODE_92272_length_246_cov_0.890173_g91256_i0	PRJNA1120203	92272	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	2.7e-46	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g91256	i0	82.883	8.07723577235772	222	36	90	2	2	222	2945592	2945812	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	1987	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15577990	15577990	PRJNA1120203_P_NODE_63113_length_283_cov_1.604762_g62097_i0	PRJNA1120203	63113	283	1.604762	4.54147646	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	167	8.94e-37	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g62097	i0	79.747	79.2932862190813	237	42	83	5	18	251	6992068	6991835	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	22440	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
16852585	16852585	PRJNA1120203_P_NODE_75514_length_256_cov_1.453552_g74498_i0	PRJNA1120203	75514	256	1.453552	3.72109312	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	316	7.47e-82	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g74498	i0	89.286	17.47265625	252	27	98	0	5	256	3105673	3105924	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	4473	316	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
16852721	16852721	PRJNA1120203_P_NODE_84234_length_249_cov_0.875000_g83218_i0	PRJNA1120203	84234	249	0.875	2.17875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	5.96e-38	NTclustered	gi\|2874254139\|emb\|OY970224.1\|	171953	g83218	i0	79.832	0.955823293172691	238	44	95	4	8	243	136520	136285	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1	blastn	238	171	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16852913	16852913	PRJNA1120203_P_NODE_96434_length_244_cov_0.900585_g95418_i0	PRJNA1120203	96434	244	0.900585	2.1974274	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	158	4.53e-34	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g95418	i0	81.188	6.15983606557377	202	32	81	6	10	207	68158	67959	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	1503	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18127301	18127301	PRJNA1120203_P_NODE_94215_length_245_cov_0.895349_g93199_i0	PRJNA1120203	94215	245	0.895349	2.19360505	Acidobacteriaceae bacterium ZG23-2	2883246	Bacteria	Bacteria	171	5.85e-38	NTclustered	gi\|2221425918\|gb\|CP085323.1\|	2883246	g93199	i0	79.832	1.63673469387755	238	44	96	3	1	236	3925910	3925675	Acidobacteriaceae bacterium ZG23-2 chromosome, complete genome	blastn	401	171	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium ZG23-2
18127340	18127340	PRJNA1120203_P_NODE_96235_length_244_cov_0.900585_g95219_i0	PRJNA1120203	96235	244	0.900585	2.1974274	Tunturiibacter lichenicola	2051959	Bacteria	Bacteria	163	9.75e-36	NTclustered	gi\|2304905231\|gb\|CP073696.1\|	2051959	g95219	i0	89.231	9.39754098360656	130	14	53	0	115	244	4928781	4928910	Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome	blastn	2293	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter lichenicola
19401101	19401101	PRJNA1120203_P_NODE_68176_length_272_cov_1.432161_g67160_i0	PRJNA1120203	68176	272	1.432161	3.89547792	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	313	1.04e-80	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g67160	i0	87.778	0.992647058823529	270	29	99	4	3	270	3806793	3807060	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	270	313	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20676598	20676598	PRJNA1120203_P_NODE_66177_length_277_cov_0.867647_g65161_i0	PRJNA1120203	66177	277	0.867647	2.40338219	Terriglobia bacterium	2081523	Bacteria	Bacteria	204	6.65e-48	NTclustered	gi\|2874253792\|emb\|OY969776.1\|	2081523	g65161	i0	80.144	5.09386281588448	277	51	99	4	3	277	2689086	2689360	MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1	blastn	1411	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
20676813	20676813	PRJNA1120203_P_NODE_82117_length_250_cov_0.870056_g81101_i0	PRJNA1120203	82117	250	0.870056	2.17514	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	161	3.61e-35	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g81101	i0	90.244	3.392	123	12	49	0	3	125	6924676	6924798	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	848	161	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21952267	21952267	PRJNA1120203_P_NODE_85078_length_249_cov_0.875000_g84062_i0	PRJNA1120203	85078	249	0.875	2.17875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g84062	i0	82.845	19.9036144578313	239	35	95	6	4	239	3461386	3461151	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	4956	209	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23227788	23227788	PRJNA1120203_P_NODE_87259_length_248_cov_0.880000_g86243_i0	PRJNA1120203	87259	248	0.88	2.1824	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g86243	i0	81.34	54.5403225806452	209	37	88	2	32	239	1135107	1135314	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	13526	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
23227874	23227874	PRJNA1120203_P_NODE_92199_length_246_cov_0.890173_g91183_i0	PRJNA1120203	92199	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g91183	i0	84.211	85.8821138211382	247	37	100	2	1	246	2874695	2874450	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	21127	239	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23227911	23227911	PRJNA1120203_P_NODE_94719_length_245_cov_0.895349_g93703_i0	PRJNA1120203	94719	245	0.895349	2.19360505	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	248	2.6299999999999997e-61	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g93703	i0	85.081	20.065306122449	248	31	100	4	1	245	1012375	1012131	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	4916	248	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25253837	25253837	PRJNA1120203_P_NODE_105100_length_241_cov_0.916667_g104084_i0	PRJNA1120203	105100	241	0.916667	2.20916747	Occallatibacter	1742983	Bacteria	Bacteria	204	5.66e-48	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g104084	i0	89.937	35.9419087136929	159	15	66	1	84	241	1563750	1563908	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	8662	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;