metadata: contig_metadata: 32 rows where bioproject = "PRJNA356682", tax_phylum = "Acidobacteriota" and tax

32 rows where bioproject = "PRJNA356682", 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
397281	397281	PRJNA356682_P_NODE_13701_length_381_cov_5.240260_g13011_i0	PRJNA356682	13701	381	5.24026	19.9653906	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	315	4.2e-81	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13011	i0	82.667	2.37007874015748	375	46	96	16	13	379	4472501	4472138	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	903	315	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1671954	1671954	PRJNA356682_P_NODE_14262_length_374_cov_6.528239_g13572_i0	PRJNA356682	14262	374	6.528239	24.41561386	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	503	8.169999999999998e-138	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13572	i0	91.176	3.59090909090909	374	27	100	6	1	374	4472502	4472135	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1343	503	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2947893	2947893	PRJNA356682_P_NODE_14463_length_372_cov_1.478261_g13773_i0	PRJNA356682	14463	372	1.478261	5.49913092	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	520	8.069999999999999e-143	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13773	i0	92.371	3.35215053763441	367	25	99	3	4	370	4472504	4472141	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1247	520	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2948098	2948098	PRJNA356682_P_NODE_24923_length_293_cov_2.209091_g24232_i0	PRJNA356682	24923	293	2.209091	6.47263663	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.5e-59	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g24232	i0	81.695	4.60068259385666	295	50	100	4	1	293	4229820	4230112	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	1348	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4224600	4224600	PRJNA356682_P_NODE_20824_length_317_cov_1.663934_g20133_i0	PRJNA356682	20824	317	1.663934	5.27467078	Luteitalea pratensis	1855912	Bacteria	Bacteria	520	6.769999999999999e-143	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g20133	i0	96.215	131.946372239748	317	12	100	0	1	317	654760	654444	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	41827	520	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
8051076	8051076	PRJNA356682_P_NODE_38787_length_248_cov_0.880000_g38096_i0	PRJNA356682	38787	248	0.88	2.1824	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	108	1.83e-26	NR	HEU0094103.1	2793154	g38096	i0	63.4	0.991935483870968	82	30	99.2	0	248	3	189	270	HEU0094103.1 EAL domain-containing protein [Vicinamibacteria bacterium]	diamond	246	108	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
10601105	10601105	PRJNA356682_P_NODE_18729_length_332_cov_1.181467_g18038_i0	PRJNA356682	18729	332	1.181467	3.92247044	Terriglobus saanensis	870903	Bacteria	Bacteria	147	1.39e-30	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g18038	i0	87.597	37.5993975903614	129	13	39	3	93	220	4858498	4858624	Terriglobus saanensis SP1PR4, complete genome	blastn	12483	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
12550773	12550773	PRJNA356682_P_NODE_24130_length_297_cov_5.321429_g23439_i0	PRJNA356682	24130	297	5.321429	15.80464413	Bacteria	2	Bacteria	Bacteria	200	9.309999999999998e-47	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g23439	i0	81.176	140.026936026936	255	43	85	4	37	288	275	23	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	41588	202	0.99009900990099	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13151004	13151004	PRJNA356682_P_NODE_17371_length_343_cov_1.122222_g16680_i0	PRJNA356682	17371	343	1.122222	3.84922146	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	392	1.68e-104	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g16680	i0	88.06	2.35860058309038	335	34	97	6	10	343	4472463	4472134	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	809	392	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14426050	14426050	PRJNA356682_P_NODE_14352_length_373_cov_3.876667_g13662_i0	PRJNA356682	14352	373	3.876667	14.45996791	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	3.039999999999999e-112	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13662	i0	87.366	1.19034852546917	372	37	99	8	1	369	4472133	4472497	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	444	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15700498	15700498	PRJNA356682_P_NODE_40553_length_246_cov_0.890173_g39862_i0	PRJNA356682	40553	246	0.890173	2.18982558	Terriglobia bacterium	2081523	Bacteria	Bacteria	135	4.93e-36	NR	HLQ76097.1	2081523	g39862	i0	80.5	4	82	14	100	1	246	1	228	307	HLQ76097.1 efflux RND transporter periplasmic adaptor subunit [Terriglobia bacterium]	diamond	984	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
16974602	16974602	PRJNA356682_P_NODE_12054_length_404_cov_4.619335_g11364_i0	PRJNA356682	12054	404	4.619335	18.6621134	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	440	7.079999999999997e-119	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g11364	i0	88.41	2.27475247524752	371	36	92	7	35	404	4472498	4472134	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	919	440	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18249381	18249381	PRJNA356682_P_NODE_37075_length_250_cov_0.870056_g36384_i0	PRJNA356682	37075	250	0.870056	2.17514	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g36384	i0	81.102	1.016	254	38	99	9	2	250	372067	372315	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	254	195	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
22074591	22074591	PRJNA356682_P_NODE_6578_length_549_cov_1.964286_g5893_i0	PRJNA356682	6578	549	1.964286	10.78393014	Candidatus Korobacter sp.	2510641	Bacteria	Bacteria	169	4.54e-45	NR	HEY3930007.1	2510641	g5893	i0	61.5	2.33333333333333	143	54	77.6	1	428	3	1	143	HEY3930007.1 Ti-type conjugative transfer relaxase TraA [Candidatus Korobacter sp.]	diamond	1281	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter sp.
24623594	24623594	PRJNA356682_P_NODE_21480_length_313_cov_1.095833_g20789_i0	PRJNA356682	21480	313	1.095833	3.42995729	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	496	1.1299999999999999e-135	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g20789	i0	95.498	104.335463258786	311	12	99	2	4	313	641295	640986	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	32657	496	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
26663031	26663031	PRJNA356682_P_NODE_32661_length_261_cov_1.941489_g31970_i0	PRJNA356682	32661	261	1.941489	5.06728629	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	130	7.89e-33	NR	MCK6695550.1	2651171	g31970	i0	69.8	0.988505747126437	86	26	98.9	0	3	260	424	509	MCK6695550.1 proprotein convertase P-domain-containing protein [Thermoanaerobaculia bacterium]	diamond	258	130	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
26902317	26902317	PRJNA356682_P_NODE_21721_length_311_cov_1.936975_g21030_i0	PRJNA356682	21721	311	1.936975	6.02399225	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	0.00952	NR	MBI4169823.1	1978231	g21030	i0	31.8	3.11575562700965	85	58	82	0	42	296	775	859	MBI4169823.1 fused MFS/spermidine synthase [Acidobacteriota bacterium]	diamond	969	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27471331	27471331	PRJNA356682_P_NODE_42183_length_244_cov_0.900585_g41492_i0	PRJNA356682	42183	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	148	1.43e-41	NR	PYR26027.1	1978231	g41492	i0	91.4	4.97950819672131	81	7	99.6	0	243	1	172	252	PYR26027.1 MAG: hypothetical protein DMF98_10290 [Acidobacteriota bacterium]	diamond	1215	149	0.993288590604027	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28022555	28022555	PRJNA356682_P_NODE_44985_length_241_cov_0.916667_g44294_i0	PRJNA356682	44985	241	0.916667	2.20916747	Bryobacterales bacterium	2026791	Bacteria	Bacteria	116	3.81e-29	NR	MSV30410.1	2026791	g44294	i0	80.3	1.76763485477178	71	14	88.4	0	215	3	1	71	MSV30410.1 mandelate racemase/muconate lactonizing enzyme family protein [Bryobacterales bacterium]	diamond	426	116	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
28559338	28559338	PRJNA356682_P_NODE_42847_length_243_cov_0.905882_g42156_i0	PRJNA356682	42847	243	0.905882	2.20129326	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	66.6	7.65e-11	NR	HEX8072903.1	2283092	g42156	i0	68	0.617283950617284	50	16	61.7	0	150	1	7	56	HEX8072903.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium]	diamond	150	66.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28622429	28622429	PRJNA356682_P_NODE_38827_length_248_cov_0.880000_g38136_i0	PRJNA356682	38827	248	0.88	2.1824	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	122	2.27e-31	NR	HEV2764972.1	2283092	g38136	i0	76.5	4.82661290322581	81	19	98	0	5	247	297	377	HEV2764972.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Pyrinomonadaceae bacterium]	diamond	1197	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29159245	29159245	PRJNA356682_P_NODE_34449_length_255_cov_2.390110_g33758_i0	PRJNA356682	34449	255	2.39011	6.0947805	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	55.1	9.41e-8	NR	HMJ88716.1	3069120	g33758	i0	60.4	0.564705882352941	48	19	56.5	0	154	11	2	49	HMJ88716.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	144	55.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
29569436	29569436	PRJNA356682_P_NODE_37010_length_250_cov_0.870056_g36319_i0	PRJNA356682	37010	250	0.870056	2.17514	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	143	2.55e-39	NR	HEX2120067.1	2651171	g36319	i0	84.3	0.996	83	13	99.6	0	1	249	24	106	HEX2120067.1 pyridoxal phosphate-dependent aminotransferase [Thermoanaerobaculia bacterium]	diamond	249	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
29663885	29663885	PRJNA356682_P_NODE_42270_length_244_cov_0.900585_g41579_i0	PRJNA356682	42270	244	0.900585	2.1974274	Luteitalea sp.	2004800	Bacteria	Bacteria	114	1.32e-27	NR	WP_291980887.1	2004800	g41579	i0	70	0.983606557377049	80	24	98.4	0	3	242	136	215	WP_291980887.1 hypothetical protein [Luteitalea sp.]	diamond	240	114	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp.
30232803	30232803	PRJNA356682_P_NODE_33892_length_257_cov_2.043478_g33201_i0	PRJNA356682	33892	257	2.043478	5.25173846	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	125	3.1e-35	NR	PYS70122.1	1978231	g33201	i0	82.2	0.852140077821012	73	13	85.2	0	256	38	21	93	PYS70122.1 MAG: hypothetical protein DMF69_14650 [Acidobacteriota bacterium]	diamond	219	125	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30611830	30611830	PRJNA356682_P_NODE_38073_length_249_cov_0.795455_g37382_i0	PRJNA356682	38073	249	0.795455	1.98068295	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.0104	NR	MBM3765365.1	1978231	g37382	i0	35.7	0.843373493975904	70	41	84.3	1	223	14	143	208	MBM3765365.1 hypothetical protein [Acidobacteriota bacterium]	diamond	210	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30881795	30881795	PRJNA356682_P_NODE_12754_length_394_cov_1.411215_g12064_i0	PRJNA356682	12754	394	1.411215	5.5601871	Pseudomonadati	3379134	Bacteria	Bacteria	101	6.52e-22	NR	HTC95996.1	2282142	g12064	i0	44	11.8705583756345	109	60	82.2	1	1	324	533	641	HTC95996.1 threonine--tRNA ligase [Terriglobales bacterium]	diamond	4677	102	0.990196078431373	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
31433611	31433611	PRJNA356682_P_NODE_34336_length_256_cov_1.273224_g33645_i0	PRJNA356682	34336	256	1.273224	3.25945344	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	114	2.44e-30	NR	HEX2458315.1	2910147	g33645	i0	71.8	1.828125	78	22	91.4	0	3	236	55	132	HEX2458315.1 LysM peptidoglycan-binding domain-containing protein [Vicinamibacterales bacterium]	diamond	468	114	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31781446	31781446	PRJNA356682_P_NODE_26137_length_288_cov_1.060465_g25446_i0	PRJNA356682	26137	288	1.060465	3.0541392	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	45.8	0.00405	NR	MDT5261147.1	1978231	g25446	i0	34.1	1.63541666666667	88	58	91.7	0	265	2	19	106	MDT5261147.1 hypothetical protein [Acidobacteriota bacterium]	diamond	471	45.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32730074	32730074	PRJNA356682_P_NODE_12640_length_396_cov_0.953560_g11950_i0	PRJNA356682	12640	396	0.95356	3.7760976	Terracidiphilus sp.	1964191	Bacteria	Bacteria	58.2	7.4e-8	NR	HTH42875.1	1964191	g11950	i0	51.8	0.424242424242424	56	27	42.4	0	185	352	61	116	HTH42875.1 hypothetical protein [Terracidiphilus sp.]	diamond	168	58.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
32761474	32761474	PRJNA356682_P_NODE_38600_length_248_cov_0.880000_g37909_i0	PRJNA356682	38600	248	0.88	2.1824	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	76.6	3.02e-14	NR	HEX7794467.1	2910147	g37909	i0	56.8	0.979838709677419	81	34	96.8	1	246	7	94	174	HEX7794467.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	243	76.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32855860	32855860	PRJNA356682_P_NODE_37800_length_249_cov_0.875000_g37109_i0	PRJNA356682	37800	249	0.875	2.17875	Blastocatellia bacterium	2052146	Bacteria	Bacteria	93.2	1.65e-21	NR	HEY8460516.1	2052146	g37109	i0	78.8	0.795180722891566	66	14	79.5	0	199	2	17	82	HEY8460516.1 ATP-binding cassette domain-containing protein [Blastocatellia bacterium]	diamond	198	93.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia 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);;