metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
1473648	1473648	PRJNA1093380_P_NODE_13122_length_249_cov_0.875000_g13016_i0	PRJNA1093380	13122	249	0.875	2.17875	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g13016	i0	100	0.112449799196787	28	0	11	0	41	68	2805447	2805420	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
2749850	2749850	PRJNA1093380_P_NODE_17503_length_235_cov_2.135802_g17397_i0	PRJNA1093380	17503	235	2.135802	5.0191347	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	370	5.12e-98	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g17397	i0	94.937	109.23829787234	237	10	100	2	1	235	1689140	1688904	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	25671	370	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5301984	5301984	PRJNA1093380_P_NODE_1685_length_432_cov_1.724234_g1579_i0	PRJNA1093380	1685	432	1.724234	7.44869088	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	675	0	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g1579	i0	95.498	445.291666666667	422	19	98	0	1	422	10445	10866	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	192366	675	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6577096	6577096	PRJNA1093380_P_NODE_2726_length_359_cov_1.489510_g2620_i0	PRJNA1093380	2726	359	1.48951	5.3473409	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	2.4699999999999994e-48	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g2620	i0	79.861	2.35376044568245	288	52	79	6	1	285	3019866	3020150	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	845	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6577115	6577115	PRJNA1093380_P_NODE_4366_length_307_cov_0.978632_g4260_i0	PRJNA1093380	4366	307	0.978632	3.00440024	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	529	1.0899999999999996e-145	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g4260	i0	98.026	96.2801302931596	304	6	99	0	4	307	3299130	3298827	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	29558	529	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6577132	6577132	PRJNA1093380_P_NODE_5846_length_286_cov_1.446009_g5740_i0	PRJNA1093380	5846	286	1.446009	4.13558574	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	379	1.07e-100	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g5740	i0	90.625	113.664335664336	288	23	100	4	1	286	2907870	2907585	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	32508	379	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7851964	7851964	PRJNA1093380_P_NODE_8307_length_271_cov_2.651515_g8201_i0	PRJNA1093380	8307	271	2.651515	7.18560565	Bryobacterales bacterium	2026791	Bacteria	Bacteria	335	2.2e-87	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g8201	i0	89.011	145.594095940959	273	26	100	4	1	271	6661038	6660768	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	39456	335	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
8672432	8672432	PRJNA1093380_P_NODE_1027_length_542_cov_3.692964_g924_i0	PRJNA1093380	1027	542	3.692964	20.01586488	Bacteria	2	Bacteria	Bacteria	880	0	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g924	i0	95.948	108.116236162362	543	21	100	1	1	542	1689608	1690150	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	58599	885	0.994350282485876	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9126788	9126788	PRJNA1093380_P_NODE_15628_length_244_cov_0.900585_g15522_i0	PRJNA1093380	15628	244	0.900585	2.1974274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	174	4.5e-39	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g15522	i0	80.995	0.905737704918033	221	40	90	2	25	244	1644116	1644335	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	221	174	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9126791	9126791	PRJNA1093380_P_NODE_15828_length_243_cov_1.811765_g15722_i0	PRJNA1093380	15828	243	1.811765	4.40258895	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	1.19e-74	NTclustered	gi\|2874254139\|emb\|OY970224.1\|	171953	g15722	i0	89.03	159.20987654321	237	25	97	1	4	239	1716327	1716091	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1	blastn	38688	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11677808	11677808	PRJNA1093380_P_NODE_510_length_789_cov_5.234637_g416_i0	PRJNA1093380	510	789	5.234637	41.30128593	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	1157	0	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g416	i0	93.156	97.7363751584284	789	52	100	2	1	789	2907343	2908129	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	77114	1157	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12952810	12952810	PRJNA1093380_P_NODE_10771_length_257_cov_1.701087_g10665_i0	PRJNA1093380	10771	257	1.701087	4.37179359	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	412	9.31e-111	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g10665	i0	95.72	98.9338521400778	257	10	99	1	2	257	2284586	2284330	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	25426	412	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13772621	13772621	PRJNA1093380_P_NODE_9031_length_267_cov_2.257732_g8925_i0	PRJNA1093380	9031	267	2.257732	6.02814444	Paludibaculum	1649475	Bacteria	Bacteria	346	1e-90	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g8925	i0	90.262	132.940074906367	267	23	100	3	1	267	4784871	4784608	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	35495	348	0.994252873563218	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
16776242	16776242	PRJNA1093380_P_NODE_18054_length_206_cov_7.496241_g17948_i0	PRJNA1093380	18054	206	7.496241	15.44225646	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	233	5.99e-57	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g17948	i0	87.317	4.83009708737864	205	24	99	2	3	206	359735	359532	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	995	233	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
16776279	16776279	PRJNA1093380_P_NODE_4454_length_304_cov_2.000000_g4348_i0	PRJNA1093380	4454	304	2	6.08	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	501	2.34e-137	NTclustered	gi\|2874253940\|emb\|OY970265.1\|	171953	g4348	i0	96.382	254.720394736842	304	11	100	0	1	304	3789812	3789509	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1	blastn	77435	501	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20600182	20600182	PRJNA1093380_P_NODE_1737_length_427_cov_1.966102_g1631_i0	PRJNA1093380	1737	427	1.966102	8.39525554	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	545	1.55e-150	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g1631	i0	89.767	90.7634660421546	430	38	99	5	1	426	3176008	3175581	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	38756	545	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
21875929	21875929	PRJNA1093380_P_NODE_1398_length_468_cov_1.425316_g1293_i0	PRJNA1093380	1398	468	1.425316	6.67047888	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	444	6.42e-120	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g1293	i0	84.067	83.775641025641	477	58	100	15	1	468	3558102	3557635	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	39207	444	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
23151580	23151580	PRJNA1093380_P_NODE_99_length_1524_cov_3.687112_g71_i0	PRJNA1093380	99	1524	3.687112	56.19158688	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	2436	0	NTclustered	gi\|112980876\|gb\|DQ829680.1\|	171953	g71	i0	95.538	101.292650918635	1524	67	100	1	1	1524	36	1558	Uncultured Acidobacteria bacterium clone DON6 23S ribosomal RNA gene, partial sequence	blastn	154370	2436	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);;