metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
862888	862888	PRJNA888821_P_NODE_34001_length_253_cov_9.055556_g33918_i0	PRJNA888821	34001	253	9.055556	22.91055668	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	250	7.58e-62	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g33918	i0	84.825	108.588932806324	257	30	100	7	1	253	1162	1413	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	27473	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
2517680	2517680	PRJNA888821_P_NODE_5502_length_320_cov_17.599190_g5420_i0	PRJNA888821	5502	320	17.59919	56.317408	Bacteria	2	Bacteria	Bacteria	531	3.16e-146	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g5420	i0	96.855	101.96875	318	9	99	1	1	317	3310	3627	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	32630	536	0.990671641791045	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3413814	3413814	PRJNA888821_P_NODE_43523_length_226_cov_12.549020_g43440_i0	PRJNA888821	43523	226	12.54902	28.3607852	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	1.14e-44	NTclustered	gi\|197360314\|gb\|EU979102.1\|	171953	g43440	i0	98.198	48.641592920354	111	0	48	2	1	109	111	1	Uncultured Acidobacteria bacterium clone g68-M-84 16S ribosomal RNA gene, partial sequence	blastn	10993	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4690966	4690966	PRJNA888821_P_NODE_14084_length_310_cov_7.261603_g14002_i0	PRJNA888821	14084	310	7.261603	22.5109693	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	161	4.6099999999999995e-35	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g14002	i0	86	0.82258064516129	150	21	48	0	1	150	2560525	2560376	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	255	161	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4691331	4691331	PRJNA888821_P_NODE_3584_length_370_cov_9.962963_g3503_i0	PRJNA888821	3584	370	9.962963	36.8629631	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	501	2.909999999999999e-137	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g3503	i0	91.351	116.589189189189	370	27	99	5	3	370	4649913	4650279	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	43138	501	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5069927	5069927	PRJNA888821_P_NODE_3424_length_375_cov_16.341060_g3343_i0	PRJNA888821	3424	375	16.34106	61.278975	Bacteria	2	Bacteria	Bacteria	610	4.699999999999999e-170	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g3343	i0	96.011	586.728	376	13	100	2	1	375	1600	1226	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	220023	610	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5965909	5965909	PRJNA888821_P_NODE_19705_length_310_cov_2.772152_g19623_i0	PRJNA888821	19705	310	2.772152	8.5936712	uncultured Bryobacterales bacterium	2569091	Bacteria	Bacteria	207	5.84e-49	NTclustered	gi\|2546137838\|emb\|OY282420.1\|	2569091	g19623	i0	79.11	10.8064516129032	292	48	90	1	1	279	3759897	3760188	MAG: uncultured Bryobacterales bacterium isolate 78526416-339a-45b8-a6d3-8fabb82c2801 genome assembly, chromosome: 1	blastn	3350	207	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			uncultured Bryobacterales bacterium
5966513	5966513	PRJNA888821_P_NODE_6705_length_310_cov_25.396624_g6623_i0	PRJNA888821	6705	310	25.396624	78.7295344	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	1.64e-44	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g6623	i0	90.411	0.690322580645161	146	14	47	0	3	148	7037064	7037209	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	214	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8515947	8515947	PRJNA888821_P_NODE_43567_length_226_cov_10.300654_g43484_i0	PRJNA888821	43567	226	10.300654	23.27947804	Terriglobia bacterium	2081523	Bacteria	Bacteria	67.6	7.18e-7	NTclustered	gi\|2874253655\|emb\|OY968796.1\|	2081523	g43484	i0	87.719	0.252212389380531	57	7	25	0	169	225	3565804	3565748	MAG: Terriglobia bacterium isolate MFD04463.bin.1.19 genome assembly, chromosome: 1	blastn	57	67.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
9790810	9790810	PRJNA888821_P_NODE_32728_length_258_cov_8.648649_g32645_i0	PRJNA888821	32728	258	8.648649	22.31351442	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	182	2.87e-41	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g32645	i0	80.478	38.0116279069767	251	37	96	8	6	253	4060797	4061038	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	9807	182	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
9791120	9791120	PRJNA888821_P_NODE_51728_length_201_cov_5.218750_g51645_i0	PRJNA888821	51728	201	5.21875	10.4896875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	2.12e-46	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g51645	i0	86.932	86.3333333333333	176	23	88	0	1	176	3274845	3274670	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	17353	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11066579	11066579	PRJNA888821_P_NODE_449_length_737_cov_41.436747_g389_i0	PRJNA888821	449	737	41.436747	305.38882539	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	979	0	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g389	i0	90.663	725.905020352782	739	65	100	4	1	737	4648413	4649149	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	534992	979	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11066608	11066608	PRJNA888821_P_NODE_46669_length_215_cov_17.077465_g46586_i0	PRJNA888821	46669	215	17.077465	36.71654975	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	364	2.139999999999999e-96	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g46586	i0	97.642	101.093023255814	212	5	99	0	1	212	634970	635181	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	21735	364	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
12342350	12342350	PRJNA888821_P_NODE_53190_length_197_cov_7.725806_g53107_i0	PRJNA888821	53190	197	7.725806	15.21983782	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	182	2.09e-41	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g53107	i0	83.505	0.984771573604061	194	32	98	0	4	197	6817419	6817226	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	194	182	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13616434	13616434	PRJNA888821_P_NODE_28991_length_274_cov_7.213930_g28909_i0	PRJNA888821	28991	274	7.21393	19.7661682	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	422	1.67e-113	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g28909	i0	94.505	146.06204379562	273	15	99	0	1	273	320529	320801	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	40021	422	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14890569	14890569	PRJNA888821_P_NODE_17432_length_310_cov_4.839662_g17350_i0	PRJNA888821	17432	310	4.839662	15.0029522	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	122	2.1799999999999999e-23	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g17350	i0	87.037	0.716129032258065	108	14	44	0	6	113	8391727	8391834	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	222	122	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14891104	14891104	PRJNA888821_P_NODE_48112_length_211_cov_7.739130_g48029_i0	PRJNA888821	48112	211	7.73913	16.3295643	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	7.919999999999999e-61	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g48029	i0	87.678	1.27962085308057	211	26	100	0	1	211	5236594	5236384	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	270	246	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17441426	17441426	PRJNA888821_P_NODE_6714_length_310_cov_25.063291_g6632_i0	PRJNA888821	6714	310	25.063291	77.6962021	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	538	1.8199999999999993e-148	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g6632	i0	98.058	105.503225806452	309	6	99	0	2	310	1797	2105	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	32706	538	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19093631	19093631	PRJNA888821_P_NODE_9975_length_310_cov_11.160338_g9893_i0	PRJNA888821	9975	310	11.160338	34.5970478	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	226	1.6099999999999998e-54	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g9893	i0	93.96	66.5741935483871	149	9	96	0	161	309	3299851	3299999	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	20638	226	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19989326	19989326	PRJNA888821_P_NODE_24616_length_293_cov_5.827273_g24534_i0	PRJNA888821	24616	293	5.827273	17.07390989	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	158	5.6e-34	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g24534	i0	83.889	4.10580204778157	180	13	79	10	1	177	941412	941578	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	1203	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
19989403	19989403	PRJNA888821_P_NODE_28916_length_274_cov_13.895522_g28834_i0	PRJNA888821	28916	274	13.895522	38.07373028	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	73.1	1.93e-8	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g28834	i0	79.808	0.37956204379562	104	17	37	4	173	274	1346707	1346606	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	104	73.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19989459	19989459	PRJNA888821_P_NODE_31716_length_262_cov_31.677249_g31633_i0	PRJNA888821	31716	262	31.677249	82.99439238	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	250	7.899999999999999e-62	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g31633	i0	84.444	223.984732824427	270	25	99	13	1	260	283783	284045	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	58684	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
21264727	21264727	PRJNA888821_P_NODE_26537_length_285_cov_11.382075_g26455_i0	PRJNA888821	26537	285	11.382075	32.43891375	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	281	3.08e-71	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g26455	i0	87.903	119.943859649123	248	18	86	8	41	285	3557727	3557489	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	34184	281	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
21265170	21265170	PRJNA888821_P_NODE_52677_length_198_cov_12.560000_g52594_i0	PRJNA888821	52677	198	12.56	24.8688	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	189	1.2499999999999996e-43	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g52594	i0	84.103	4.12626262626263	195	31	98	0	1	195	3829471	3829665	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	817	189	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22539456	22539456	PRJNA888821_P_NODE_20718_length_309_cov_11.169492_g20636_i0	PRJNA888821	20718	309	11.169492	34.51373028	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	1.66e-29	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g20636	i0	87.023	0.423948220064725	131	11	41	6	182	309	6652823	6652696	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	131	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22539781	22539781	PRJNA888821_P_NODE_39758_length_239_cov_25.409639_g39675_i0	PRJNA888821	39758	239	25.409639	60.72903721	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	368	1.88e-97	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g39675	i0	94.561	141.037656903766	239	12	99	1	1	238	4652068	4652306	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	33708	368	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23814912	23814912	PRJNA888821_P_NODE_24779_length_292_cov_27.744292_g24697_i0	PRJNA888821	24779	292	27.744292	81.01333264	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	307	5.23e-79	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g24697	i0	86.254	186.551369863014	291	31	98	9	7	292	317552	317266	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	54473	307	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24193298	24193298	PRJNA888821_P_NODE_24299_length_293_cov_19.518182_g24217_i0	PRJNA888821	24299	293	19.518182	57.18827326	Pseudomonadati	3379134	Bacteria	Bacteria	128	4.3899999999999995e-25	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g24217	i0	93.182	3.29692832764505	88	4	30	2	13	99	1676902	1676816	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	966	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis

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);;