metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
201114	201114	PRJNA1095825_P_NODE_295901_length_241_cov_0.916667_g292838_i0	PRJNA1095825	295901	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.57e-48	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g292838	i0	82.158	12.1244813278008	241	41	99	2	1	240	2709128	2709367	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	2922	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1019497	1019497	PRJNA1095825_P_NODE_263101_length_247_cov_0.879310_g260038_i0	PRJNA1095825	263101	247	0.87931	2.1718957	Luteitalea	2004797	Bacteria	Bacteria	163	9.88e-36	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g260038	i0	82.199	6.10121457489879	191	32	77	2	18	207	7026915	7026726	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	1507	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
1474829	1474829	PRJNA1095825_P_NODE_192002_length_282_cov_1.473684_g188939_i0	PRJNA1095825	192002	282	1.473684	4.15578888	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	327	3.86e-85	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g188939	i0	89.575	84.8085106382979	259	25	91	2	3	260	2792411	2792668	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	23916	327	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2751385	2751385	PRJNA1095825_P_NODE_240243_length_251_cov_0.865169_g237180_i0	PRJNA1095825	240243	251	0.865169	2.17157419	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2893358436\|emb\|OZ220728.1\|	2910147	g237180	i0	100	0.342629482071713	30	0	12	0	222	251	241561	241532	MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1	blastn	86	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
2751815	2751815	PRJNA1095825_P_NODE_286743_length_242_cov_1.633136_g283680_i0	PRJNA1095825	286743	242	1.633136	3.95218912	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	176	1.24e-39	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g283680	i0	86.709	0.652892561983471	158	21	65	0	85	242	714919	714762	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	158	176	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9128407	9128407	PRJNA1095825_P_NODE_245488_length_250_cov_0.870056_g242425_i0	PRJNA1095825	245488	250	0.870056	2.17514	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	71.3	6.25e-8	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g242425	i0	95.455	0.352	44	2	18	0	155	198	1073800	1073757	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	88	71.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
9128771	9128771	PRJNA1095825_P_NODE_282568_length_243_cov_0.905882_g279505_i0	PRJNA1095825	282568	243	0.905882	2.20129326	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	215	2.64e-51	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g279505	i0	85.577	24.2304526748971	208	26	85	4	38	243	3549742	3549947	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	5888	215	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
9947675	9947675	PRJNA1095825_P_NODE_230008_length_255_cov_1.384615_g226945_i0	PRJNA1095825	230008	255	1.384615	3.53076825	Holophagaceae	574976	Bacteria	Bacteria	132	2.89e-26	NTclustered	gi\|2621702213\|emb\|OY760195.1\|	188475	g226945	i0	86.777	31.7647058823529	121	12	47	4	135	253	2296708	2296590	MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1	blastn	8100	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
9947798	9947798	PRJNA1095825_P_NODE_288328_length_242_cov_0.911243_g285265_i0	PRJNA1095825	288328	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|2836016423\|emb\|OZ196153.1\|	1241325	g285265	i0	84.475	33.6942148760331	219	32	90	2	1	218	713407	713190	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 6	blastn	8154	215	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
10404422	10404422	PRJNA1095825_P_NODE_284009_length_243_cov_0.905882_g280946_i0	PRJNA1095825	284009	243	0.905882	2.20129326	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g280946	i0	82.143	1.15637860082305	224	40	92	0	1	224	5821895	5822118	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	281	193	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
11222870	11222870	PRJNA1095825_P_NODE_210569_length_269_cov_1.306122_g207506_i0	PRJNA1095825	210569	269	1.306122	3.51346818	Bacteria	2	Bacteria	Bacteria	300	7.97e-77	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g207506	i0	86.957	99.092936802974	276	24	100	9	1	269	6660189	6660459	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	26656	302	0.993377483443709	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
11679253	11679253	PRJNA1095825_P_NODE_232310_length_253_cov_1.711111_g229247_i0	PRJNA1095825	232310	253	1.711111	4.32911083	Luteitalea pratensis	1855912	Bacteria	Bacteria	359	1.21e-94	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g229247	i0	93.089	307.256916996047	246	15	97	2	1	245	655178	654934	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	77736	359	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
12954550	12954550	PRJNA1095825_P_NODE_249531_length_249_cov_0.875000_g246468_i0	PRJNA1095825	249531	249	0.875	2.17875	Luteitalea pratensis	1855912	Bacteria	Bacteria	263	9.56e-66	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g246468	i0	85.83	0.991967871485944	247	35	99	0	3	249	3873213	3873459	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	247	263	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
12954892	12954892	PRJNA1095825_P_NODE_286151_length_243_cov_0.870588_g283088_i0	PRJNA1095825	286151	243	0.870588	2.11552884	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	298	2.55e-76	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g283088	i0	89.451	2.48559670781893	237	24	97	1	8	243	3398912	3398676	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	604	298	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15503358	15503358	PRJNA1095825_P_NODE_240373_length_251_cov_0.865169_g237310_i0	PRJNA1095825	240373	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	132	2.84e-26	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g237310	i0	93.258	3.44223107569721	89	6	35	0	1	89	2009377	2009465	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	864	132	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15503384	15503384	PRJNA1095825_P_NODE_243653_length_250_cov_0.870056_g240590_i0	PRJNA1095825	243653	250	0.870056	2.17514	Paludibaculum fermentans	1473598	Bacteria	Bacteria	187	5.949999999999998e-43	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g240590	i0	83.5	20.996	200	33	80	0	48	247	6669332	6669133	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	5249	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
16778136	16778136	PRJNA1095825_P_NODE_276254_length_244_cov_0.900585_g273191_i0	PRJNA1095825	276254	244	0.900585	2.1974274	Bryobacterales bacterium	2026791	Bacteria	Bacteria	159	1.2599999999999999e-34	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g273191	i0	86.301	8.60245901639344	146	20	60	0	1	146	4850454	4850309	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	2099	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
18052604	18052604	PRJNA1095825_P_NODE_268855_length_246_cov_0.890173_g265792_i0	PRJNA1095825	268855	246	0.890173	2.18982558	Luteitalea pratensis	1855912	Bacteria	Bacteria	292	1.2e-74	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g265792	i0	88.525	4.56910569105691	244	24	98	4	3	244	4993207	4993448	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	1124	292	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
18052625	18052625	PRJNA1095825_P_NODE_271335_length_245_cov_0.895349_g268272_i0	PRJNA1095825	271335	245	0.895349	2.19360505	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	163	9.79e-36	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g268272	i0	80.184	4.22040816326531	217	43	89	0	29	245	6588404	6588188	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	1034	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18052627	18052627	PRJNA1095825_P_NODE_271475_length_245_cov_0.895349_g268412_i0	PRJNA1095825	271475	245	0.895349	2.19360505	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	143	1.28e-29	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g268412	i0	82.911	0.644897959183673	158	27	64	0	38	195	4534792	4534949	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	158	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
19326883	19326883	PRJNA1095825_P_NODE_284816_length_243_cov_0.905882_g281753_i0	PRJNA1095825	284816	243	0.905882	2.20129326	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	150	7.55e-32	NTclustered	gi\|2893358436\|emb\|OZ220728.1\|	2910147	g281753	i0	78.367	7.81893004115226	245	43	99	9	1	240	3854350	3854589	MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1	blastn	1900	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
21877552	21877552	PRJNA1095825_P_NODE_248138_length_249_cov_0.875000_g245075_i0	PRJNA1095825	248138	249	0.875	2.17875	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	200	7.61e-47	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g245075	i0	81.452	0.995983935742972	248	42	99	4	4	249	1058233	1058478	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	248	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
21877601	21877601	PRJNA1095825_P_NODE_253878_length_248_cov_0.880000_g250815_i0	PRJNA1095825	253878	248	0.88	2.1824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	254	5.73e-63	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g250815	i0	86.017	71.2459677419355	236	33	95	0	3	238	416191	416426	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	17669	254	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21877908	21877908	PRJNA1095825_P_NODE_286018_length_243_cov_0.905882_g282955_i0	PRJNA1095825	286018	243	0.905882	2.20129326	Luteitalea pratensis	1855912	Bacteria	Bacteria	62.1	3.64e-5	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g282955	i0	97.222	0.304526748971193	36	1	15	0	123	158	3142414	3142379	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	74	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
23152905	23152905	PRJNA1095825_P_NODE_235459_length_251_cov_1.415730_g232396_i0	PRJNA1095825	235459	251	1.41573	3.5534823	Geothrix sp.	1962974	Bacteria	Bacteria	189	1.6599999999999996e-43	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g232396	i0	82.063	0.888446215139442	223	38	88	2	25	246	1950983	1951204	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	223	189	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
24426671	24426671	PRJNA1095825_P_NODE_250740_length_249_cov_0.875000_g247677_i0	PRJNA1095825	250740	249	0.875	2.17875	Granulicella sp. 5B5	1617967	Bacteria	Bacteria	171	5.96e-38	NTclustered	gi\|1886125103\|gb\|CP046444.1\|	1617967	g247677	i0	81.166	25.0923694779116	223	33	88	8	3	221	1200123	1200340	Granulicella sp. 5B5 chromosome, complete genome	blastn	6248	171	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. 5B5
24426752	24426752	PRJNA1095825_P_NODE_259100_length_247_cov_0.885057_g256037_i0	PRJNA1095825	259100	247	0.885057	2.18609079	Bryobacterales bacterium	2026791	Bacteria	Bacteria	279	9.41e-71	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g256037	i0	87.149	542.744939271255	249	28	100	4	1	247	6660764	6661010	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	134058	279	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales 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);;