metadata: contig_metadata: 29 rows where bioproject = "PRJNA421571", tax_phylum = "Acidobacteriota" and tax

29 rows where bioproject = "PRJNA421571", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6189157	6189157	PRJNA421571_P_NODE_69465_length_305_cov_1.905172_g66916_i0	PRJNA421571	69465	305	1.905172	5.8107746	Acidobacteriaceae	204434	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|2304905231\|gb\|CP073696.1\|	2051959	g66916	i0	100	104.603278688525	305	0	100	0	1	305	3199955	3199651	Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome	blastn	31904	564	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter lichenicola
8076700	8076700	PRJNA421571_P_NODE_55027_length_362_cov_1.065744_g52478_i0	PRJNA421571	55027	362	1.065744	3.85799328	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	99	1.62e-23	NR	MBA3887688.1	1978231	g52478	i0	46.2	0.986187845303867	119	55	97	3	2	352	33	144	MBA3887688.1 hypothetical protein [Acidobacteriota bacterium]	diamond	357	99	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9351907	9351907	PRJNA421571_P_NODE_71128_length_300_cov_1.356828_g68579_i0	PRJNA421571	71128	300	1.356828	4.070484	Pseudomonadati	3379134	Bacteria	Bacteria	117	2.19e-28	NR	MEY3284333.1	1978231	g68579	i0	58.6	11.77	99	41	99	0	3	299	226	324	MEY3284333.1 hypothetical protein [Acidobacteriota bacterium]	diamond	3531	117	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10628320	10628320	PRJNA421571_P_NODE_96609_length_248_cov_0.880000_g94060_i0	PRJNA421571	96609	248	0.88	2.1824	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	158	4.62e-34	NTclustered	gi\|1037405666\|gb\|CP011806.1\|	1660251	g94060	i0	83.908	18.6854838709677	174	19	69	7	19	190	5680132	5679966	Acidobacteria bacterium Mor1 chromosome	blastn	4634	158	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium Mor1
11902391	11902391	PRJNA421571_P_NODE_62470_length_330_cov_1.447471_g59921_i0	PRJNA421571	62470	330	1.447471	4.7766543	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	100	1.05e-24	NR	MDQ7008653.1	1978231	g59921	i0	78.3	0.627272727272727	69	15	62.7	0	3	209	43	111	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	207	100	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14450804	14450804	PRJNA421571_P_NODE_105552_length_242_cov_0.911243_g103003_i0	PRJNA421571	105552	242	0.911243	2.20520806	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	75.1	4.44e-15	NR	HXP08495.1	2052142	g103003	i0	59.6	1.26446280991736	52	21	64.5	0	27	182	81	132	HXP08495.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	306	75.1	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
18275826	18275826	PRJNA421571_P_NODE_84335_length_267_cov_1.195876_g81786_i0	PRJNA421571	84335	267	1.195876	3.19298892	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	127	1.0299999999999998e-31	NR	MCB1050766.1	1978231	g81786	i0	75	3.95505617977528	88	20	98.9	1	266	3	411	496	MCB1050766.1 arginine--tRNA ligase [Acidobacteriota bacterium]	diamond	1056	127	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19549343	19549343	PRJNA421571_P_NODE_57536_length_350_cov_1.234657_g54987_i0	PRJNA421571	57536	350	1.234657	4.3212995	Terriglobus saanensis	870903	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g54987	i0	100	0.08	28	0	8	0	286	313	4098126	4098099	Terriglobus saanensis SP1PR4, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
23375627	23375627	PRJNA421571_P_NODE_58579_length_345_cov_1.772059_g56030_i0	PRJNA421571	58579	345	1.772059	6.11360355	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	124	4.94e-34	NR	MDQ7008654.1	1978231	g56030	i0	78.2	0.756521739130435	87	18	75.7	1	343	83	27	112	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	261	124	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26917465	26917465	PRJNA421571_P_NODE_79602_length_278_cov_1.375610_g77053_i0	PRJNA421571	79602	278	1.37561	3.8241958	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	53.1	1.25e-5	NR	HEX3085720.1	2283092	g77053	i0	39	2.88129496402878	100	51	97.1	5	9	278	313	412	HEX3085720.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium]	diamond	801	53.1	1	Bacteria		Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
26917472	26917472	PRJNA421571_P_NODE_85322_length_265_cov_0.875000_g82773_i0	PRJNA421571	85322	265	0.875	2.31875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	88.2	2.29e-20	NR	MDQ7008653.1	1978231	g82773	i0	60.2	2.79622641509434	83	32	92.8	1	248	3	25	107	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	741	88.2	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27250262	27250262	PRJNA421571_P_NODE_73663_length_293_cov_0.881818_g71114_i0	PRJNA421571	73663	293	0.881818	2.58372674	Terriglobia	204432	Bacteria	Bacteria	134	3.04e-36	NR	PYX86855.1	1978231	g71114	i0	63.9	12.9112627986348	97	35	99.3	0	291	1	8	104	PYX86855.1 MAG: hypothetical protein DMG68_13790 [Acidobacteriota bacterium]	diamond	3783	135	0.992592592592593	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27928524	27928524	PRJNA421571_P_NODE_87465_length_260_cov_1.288770_g84916_i0	PRJNA421571	87465	260	1.28877	3.350802	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	45.1	0.00686	NR	HSP33943.1	2651171	g84916	i0	35.4	1.89230769230769	82	46	94.6	3	14	259	391	465	HSP33943.1 oligopeptidase B [Thermoanaerobaculia bacterium]	diamond	492	45.1	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28180804	28180804	PRJNA421571_P_NODE_101226_length_245_cov_0.895349_g98677_i0	PRJNA421571	101226	245	0.895349	2.19360505	Terriglobales bacterium	2282142	Bacteria	Bacteria	42.7	0.0378	NR	HKW17502.1	2282142	g98677	i0	52.6	0.46530612244898	38	18	46.5	0	33	146	259	296	HKW17502.1 tetratricopeptide repeat protein [Terriglobales bacterium]	diamond	114	42.7	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
28307389	28307389	PRJNA421571_P_NODE_50866_length_385_cov_1.131410_g48318_i0	PRJNA421571	50866	385	1.13141	4.3559285	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	44.3	0.0485	NR	HEX4784998.1	2771375	g48318	i0	38.6	0.342857142857143	44	27	34.3	0	242	111	491	534	HEX4784998.1 carbon starvation CstA family protein [Candidatus Sulfotelmatobacter sp.]	diamond	132	44.3	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
28955671	28955671	PRJNA421571_P_NODE_74408_length_291_cov_1.013761_g71859_i0	PRJNA421571	74408	291	1.013761	2.95004451	Pseudomonadati	3379134	Bacteria	Bacteria	167	1.69e-49	NR	MBM3793404.1	1978231	g71859	i0	83.3	6.92783505154639	96	16	99	0	2	289	34	129	MBM3793404.1 hypothetical protein [Acidobacteriota bacterium]	diamond	2016	168	0.994047619047619	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29128539	29128539	PRJNA421571_P_NODE_24909_length_682_cov_3.054187_g22450_i0	PRJNA421571	24909	682	3.054187	20.82955534	Terriglobia bacterium	2081523	Bacteria	Bacteria	60.5	3.46e-7	NR	MBZ5639833.1	2081523	g22450	i0	61	1.16129032258065	41	16	18	0	559	681	88	128	MBZ5639833.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Terriglobia bacterium]	diamond	792	60.5	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29475287	29475287	PRJNA421571_P_NODE_108390_length_200_cov_4.330709_g105841_i0	PRJNA421571	108390	200	4.330709	8.661418	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	75.1	5.38e-14	NR	MBP6823791.1	1978231	g105841	i0	56.1	1.95	66	29	99	0	3	200	68	133	MBP6823791.1 isopenicillin N synthase family oxygenase [Acidobacteriota bacterium]	diamond	390	75.1	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29555145	29555145	PRJNA421571_P_NODE_79970_length_277_cov_1.446078_g77421_i0	PRJNA421571	79970	277	1.446078	4.00563606	Pseudomonadati	3379134	Bacteria	Bacteria	115	1.56e-29	NR	HTY82967.1	1964179	g77421	i0	67.1	19.4187725631769	82	27	88.8	0	31	276	3	84	HTY82967.1 zinc-dependent alcohol dehydrogenase [Silvibacterium sp.]	diamond	5379	116	0.991379310344828	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Silvibacterium	Silvibacterium sp.
29633045	29633045	PRJNA421571_P_NODE_102490_length_244_cov_0.900585_g99941_i0	PRJNA421571	102490	244	0.900585	2.1974274	Terriglobia bacterium	2081523	Bacteria	Bacteria	56.2	5.59e-7	NR	MFQ5695483.1	2081523	g99941	i0	41.3	1.80737704918033	80	39	98.4	3	243	4	194	265	MFQ5695483.1 diacylglycerol/lipid kinase family protein [Terriglobia bacterium]	diamond	441	56.2	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29759641	29759641	PRJNA421571_P_NODE_97751_length_247_cov_0.885057_g95202_i0	PRJNA421571	97751	247	0.885057	2.18609079	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	113	2.54e-30	NR	MDQ7008654.1	1978231	g95202	i0	80.6	0.874493927125506	72	14	87.4	0	14	229	31	102	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	216	113	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30170324	30170324	PRJNA421571_P_NODE_94832_length_249_cov_0.875000_g92283_i0	PRJNA421571	94832	249	0.875	2.17875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	85.5	3.35e-17	NR	MDQ3171159.1	1978231	g92283	i0	55.1	7.54216867469879	78	34	94	1	247	14	85	161	MDQ3171159.1 bifunctional metallophosphatase/5'-nucleotidase [Acidobacteriota bacterium]	diamond	1878	85.5	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31055392	31055392	PRJNA421571_P_NODE_26595_length_649_cov_3.366319_g24106_i0	PRJNA421571	26595	649	3.366319	21.84741031	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	236	2.62e-75	NR	MEM7351519.1	1978231	g24106	i0	72.3	1.46995377503852	159	44	73.5	0	630	154	21	179	MEM7351519.1 hypothetical protein [Acidobacteriota bacterium]	diamond	954	236	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31134546	31134546	PRJNA421571_P_NODE_101575_length_244_cov_1.467836_g99026_i0	PRJNA421571	101575	244	1.467836	3.58151984	Pseudomonadati	3379134	Bacteria	Bacteria	123	4.89e-31	NR	MDQ2776657.1	1978231	g99026	i0	72.8	19.9180327868852	81	22	99.6	0	243	1	192	272	MDQ2776657.1 aldehyde dehydrogenase family protein [Acidobacteriota bacterium]	diamond	4860	124	0.991935483870968	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31877192	31877192	PRJNA421571_P_NODE_98977_length_246_cov_0.890173_g96428_i0	PRJNA421571	98977	246	0.890173	2.18982558	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	61.2	1.1e-9	NR	MEO8074530.1	1978231	g96428	i0	63.3	2.18292682926829	79	28	95.1	1	241	8	31	109	MEO8074530.1 VCBS repeat-containing protein [Acidobacteriota bacterium]	diamond	537	61.2	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32098779	32098779	PRJNA421571_P_NODE_94058_length_250_cov_0.870056_g91509_i0	PRJNA421571	94058	250	0.870056	2.17514	Sulfidibacter corallicola	2818388	Bacteria	Bacteria	60.8	1.36e-8	NR	WP_237382010.1	2818388	g91509	i0	54.3	0.552	46	19	55.2	1	45	182	263	306	WP_237382010.1 SMP-30/gluconolactonase/LRE family protein [Sulfidibacter corallicola]	diamond	138	60.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Sulfidibacter	Sulfidibacter corallicola
32147077	32147077	PRJNA421571_P_NODE_84178_length_267_cov_1.587629_g81629_i0	PRJNA421571	84178	267	1.587629	4.23896943	Pseudomonadati	3379134	Bacteria	Bacteria	129	1.33e-35	NR	MEM7351519.1	1978231	g81629	i0	70.5	3.93258426966292	88	24	98.9	1	266	3	72	157	MEM7351519.1 hypothetical protein [Acidobacteriota bacterium]	diamond	1050	129	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32257340	32257340	PRJNA421571_P_NODE_104678_length_242_cov_0.911243_g102129_i0	PRJNA421571	104678	242	0.911243	2.20520806	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	59.3	5.27e-8	NR	HYL75751.1	2212468	g102129	i0	37.8	1.92148760330579	82	46	97.9	2	6	242	268	347	HYL75751.1 family 20 glycosylhydrolase [Bryobacteraceae bacterium]	diamond	465	59.3	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32841697	32841697	PRJNA421571_P_NODE_107500_length_236_cov_2.343558_g104951_i0	PRJNA421571	107500	236	2.343558	5.53079688	Bacteria	2	Bacteria	Bacteria	46.6	6.27e-4	NR	MBA3916600.1	2282142	g104951	i0	44.4	6.86440677966102	45	19	49.6	1	64	180	86	130	MBA3916600.1 VOC family protein [Terriglobales bacterium]	diamond	1620	47	0.991489361702128	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales 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);;