metadata: contig_metadata: 26 rows where bioproject = "PRJNA400391", tax_phylum = "Acidobacteriota" and tax

26 rows where bioproject = "PRJNA400391", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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
414063	414063	PRJNA400391_S_NODE_5201_length_173_cov_7.608696_g5140_i0	PRJNA400391	5201	173	7.608696	13.16304408	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	285	1.32e-72	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g5140	i0	96.532	321.208092485549	173	5	100	1	1	173	9267	9438	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	55569	285	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
414088	414088	PRJNA400391_S_NODE_6261_length_156_cov_2.801653_g6200_i0	PRJNA400391	6261	156	2.801653	4.37057868	Terriglobia bacterium	2081523	Bacteria	Bacteria	117	4.49e-22	NTclustered	gi\|2621703257\|emb\|OY762429.1\|	2081523	g6200	i0	87.379	57.5320512820513	103	12	65	1	16	117	2748031	2748133	MAG: Terriglobia bacterium isolate aa40cff0-ace7-4b53-8087-0ef5d3f4acaf genome assembly, chromosome: 1	blastn	8975	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
1688857	1688857	PRJNA400391_S_NODE_1762_length_294_cov_8.030888_g1701_i0	PRJNA400391	1762	294	8.030888	23.61081072	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	335	2.419999999999999e-87	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g1701	i0	89.011	142.710884353742	273	26	93	4	1	272	283744	284013	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	41957	335	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
7458965	7458965	PRJNA400391_S_NODE_2926_length_235_cov_12.950000_g2865_i0	PRJNA400391	2926	235	12.95	30.4325	Bacteria	2	Bacteria	Bacteria	302	1.89e-77	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g2865	i0	89.787	106.140425531915	235	24	100	0	1	235	2776407	2776641	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	24943	305	0.99016393442623	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
9342304	9342304	PRJNA400391_S_NODE_6448_length_153_cov_3.152542_g6387_i0	PRJNA400391	6448	153	3.152542	4.82338926	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	228	1.9399999999999995e-55	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g6387	i0	94.04	127.084967320261	151	7	98	2	4	153	3919742	3919593	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	19444	228	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10617989	10617989	PRJNA400391_S_NODE_3969_length_202_cov_6.814371_g3908_i0	PRJNA400391	3969	202	6.814371	13.76502942	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	357	3.3299999999999996e-94	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g3908	i0	98.515	115.480198019802	202	3	100	0	1	202	4649102	4649303	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	23327	357	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11284306	11284306	PRJNA400391_S_NODE_1849_length_288_cov_50.217391_g1788_i0	PRJNA400391	1849	288	50.217391	144.62608608	Acidobacterium	33973	Bacteria	Bacteria	418	2.28e-112	NTclustered	gi\|254797400\|gb\|GQ302586.1\|	114706	g1788	i0	92.759	99.6631944444444	290	19	100	2	1	288	25	314	Uncultured Acidobacterium sp. clone sw-xj211 16S ribosomal RNA gene, partial sequence	blastn	28703	418	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	uncultured Acidobacterium sp.
11892871	11892871	PRJNA400391_S_NODE_3130_length_227_cov_11.541667_g3069_i0	PRJNA400391	3130	227	11.541667	26.19958409	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	361	2.96e-95	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g3069	i0	95.197	238.497797356828	229	9	100	2	1	227	2869	2641	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	54139	361	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
11892876	11892876	PRJNA400391_S_NODE_3290_length_221_cov_69.978495_g3229_i0	PRJNA400391	3290	221	69.978495	154.65247395	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	311	2.93e-80	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g3229	i0	91.703	212.371040723982	229	11	100	7	1	221	4232236	4232008	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	46934	311	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11892944	11892944	PRJNA400391_S_NODE_630_length_418_cov_62.712794_g570_i0	PRJNA400391	630	418	62.712794	262.13947892	Acidisarcina polymorpha	2211140	Bacteria	Bacteria	490	7.189999999999998e-134	NTclustered	gi\|1431854037\|gb\|CP030840.1\|	2211140	g570	i0	91.389	340.272727272727	360	27	86	3	1	360	1121529	1121884	Acidisarcina polymorpha strain SBC82 chromosome, complete genome	blastn	142234	490	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidisarcina	Acidisarcina polymorpha
14442954	14442954	PRJNA400391_S_NODE_1712_length_297_cov_13.007634_g1651_i0	PRJNA400391	1712	297	13.007634	38.63267298	Paludibaculum fermentans	1473598	Bacteria	Bacteria	398	3.0799999999999996e-106	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g1651	i0	90.97	105.922558922559	299	22	100	2	1	297	4786307	4786602	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	31459	398	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
14442975	14442975	PRJNA400391_S_NODE_2312_length_263_cov_4.807018_g2251_i0	PRJNA400391	2312	263	4.807018	12.64245734	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	368	2.0999999999999996e-97	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g2251	i0	91.985	230.536121673004	262	21	99	0	2	263	3558167	3558428	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	60631	368	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
15716742	15716742	PRJNA400391_S_NODE_2213_length_268_cov_8.437768_g2152_i0	PRJNA400391	2213	268	8.437768	22.61321824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	414	2.72e-111	NTclustered	gi\|76574290\|gb\|DQ139438.1\|	171953	g2152	i0	94.465	143.757462686567	271	12	100	1	1	268	1630	1360	Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence	blastn	38527	414	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16383411	16383411	PRJNA400391_S_NODE_1993_length_280_cov_27.387755_g1932_i0	PRJNA400391	1993	280	27.387755	76.685714	Candidatus Solibacter	332162	Bacteria	Bacteria	507	4.58e-139	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g1932	i0	99.286	105.560714285714	280	2	100	0	1	280	909	1188	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	29557	507	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
16991603	16991603	PRJNA400391_S_NODE_3474_length_216_cov_1.828729_g3413_i0	PRJNA400391	3474	216	1.828729	3.95005464	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	165	2.35e-36	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g3413	i0	81.69	217.87037037037	213	26	97	10	1	209	548	751	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	47060	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
17658634	17658634	PRJNA400391_S_NODE_6514_length_152_cov_5.538462_g6453_i0	PRJNA400391	6514	152	5.538462	8.41846224	Bacteria	2	Bacteria	Bacteria	235	1.15e-57	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g6453	i0	95.302	109.223684210526	149	5	97	2	1	148	1688050	1687903	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	16602	235	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18932512	18932512	PRJNA400391_S_NODE_2235_length_267_cov_6.405172_g2174_i0	PRJNA400391	2235	267	6.405172	17.10180924	Bacteria	2	Bacteria	Bacteria	204	6.37e-48	NTclustered	gi\|112980872\|gb\|DQ829676.1\|	171953	g2174	i0	84.259	160.078651685393	216	27	79	7	1	212	578	366	Uncultured Acidobacteria bacterium clone DON2 23S ribosomal RNA gene, partial sequence	blastn	42741	206	0.990291262135922	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19539810	19539810	PRJNA400391_S_NODE_1996_length_280_cov_20.493878_g1935_i0	PRJNA400391	1996	280	20.493878	57.3828584	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	429	1.02e-115	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g1935	i0	94.306	204.882142857143	281	15	100	1	1	280	4231420	4231700	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	57367	429	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19539821	19539821	PRJNA400391_S_NODE_2436_length_256_cov_22.932127_g2375_i0	PRJNA400391	2436	256	22.932127	58.70624512	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.66e-58	NTclustered	gi\|112980852\|gb\|DQ829656.1\|	171953	g2375	i0	85.59	126.7421875	229	31	89	2	30	256	763	991	Uncultured Acidobacteria bacterium clone DON25 23S ribosomal RNA gene, partial sequence	blastn	32446	239	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19539826	19539826	PRJNA400391_S_NODE_2596_length_249_cov_5.439252_g2535_i0	PRJNA400391	2596	249	5.439252	13.54373748	Bryobacterales bacterium	2026791	Bacteria	Bacteria	357	4.2599999999999997e-94	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g2535	i0	92.713	194.285140562249	247	18	99	0	3	249	6660781	6661027	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	48377	357	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
19539862	19539862	PRJNA400391_S_NODE_4236_length_195_cov_8.100000_g4175_i0	PRJNA400391	4236	195	8.1	15.795	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	278	2.55e-70	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g4175	i0	92.708	191.717948717949	192	14	98	0	4	195	3556433	3556624	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	37385	278	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
19539918	19539918	PRJNA400391_S_NODE_76_length_726_cov_29.232996_g53_i0	PRJNA400391	76	726	29.232996	212.23155096	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	798	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g53	i0	86.649	89.4118457300276	734	82	100	15	1	726	3557426	3558151	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	64913	798	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
20815678	20815678	PRJNA400391_S_NODE_1657_length_300_cov_6.969811_g1596_i0	PRJNA400391	1657	300	6.969811	20.909433	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	344	4.11e-90	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g1596	i0	89.13	183.663333333333	276	30	92	0	1	276	3559329	3559054	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	55099	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
22090603	22090603	PRJNA400391_S_NODE_78_length_724_cov_29.602322_g55_i0	PRJNA400391	78	724	29.602322	214.32081128	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	797	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g55	i0	86.63	75.8618784530387	733	82	100	15	1	724	3557426	3558151	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	54924	797	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24640420	24640420	PRJNA400391_S_NODE_2120_length_273_cov_17.764706_g2059_i0	PRJNA400391	2120	273	17.764706	48.49764738	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	287	6.31e-73	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g2059	i0	85.87	84.6923076923077	276	32	99	7	3	273	2284792	2285065	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	23121	287	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24640465	24640465	PRJNA400391_S_NODE_3940_length_203_cov_2.053571_g3879_i0	PRJNA400391	3940	203	2.053571	4.16874913	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	311	2.6400000000000003e-80	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g3879	i0	94.949	102.463054187192	198	10	98	0	6	203	779	582	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	20800	311	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);;