metadata: contig_metadata: 32 rows where bioproject = "PRJNA751877", tax_clade = "PVC group" and tax

32 rows where bioproject = "PRJNA751877", tax_clade = "PVC group" 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
726443	726443	PRJNA751877_P_NODE_26941_length_245_cov_0.895349_g26819_i0	PRJNA751877	26941	245	0.895349	2.19360505	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g26819	i0	83.197	11.8775510204082	244	41	99	0	2	245	6246643	6246400	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2910	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2002144	2002144	PRJNA751877_P_NODE_10962_length_336_cov_2.144487_g10840_i0	PRJNA751877	10962	336	2.144487	7.20547632	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	604	1.9399999999999992e-168	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g10840	i0	99.107	171.071428571429	336	3	100	0	1	336	267608	267943	Tautonia plasticadhaerens strain ElP chromosome	blastn	57480	604	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
5830152	5830152	PRJNA751877_P_NODE_365_length_1120_cov_2.945559_g280_i0	PRJNA751877	365	1120	2.945559	32.9902608	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	2002	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g280	i0	98.929	240.295535714286	1120	12	100	0	1	1120	266593	265474	Tautonia plasticadhaerens strain ElP chromosome	blastn	269131	2002	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
9655141	9655141	PRJNA751877_P_NODE_9788_length_350_cov_1.111913_g9666_i0	PRJNA751877	9788	350	1.111913	3.8916955	Limisphaera ngatamarikiensis	1324935	Bacteria	Bacteria	57	1.3e-6	NR	WP_165107131.1	1324935	g9666	i0	38.6	0.711428571428571	83	51	71.1	0	22	270	535	617	WP_165107131.1 tetratricopeptide repeat protein [Limisphaera ngatamarikiensis]	diamond	249	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera ngatamarikiensis
12205885	12205885	PRJNA751877_P_NODE_25650_length_247_cov_0.885057_g25528_i0	PRJNA751877	25650	247	0.885057	2.18609079	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	150	7.7e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g25528	i0	94.792	40.6153846153846	96	5	39	0	127	222	751037	750942	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	10032	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12679944	12679944	PRJNA751877_P_NODE_27650_length_244_cov_0.900585_g27528_i0	PRJNA751877	27650	244	0.900585	2.1974274	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	151	1.8799999999999993e-40	NR	WP_170266723.1	748831	g27528	i0	93.8	0.983606557377049	80	5	98.4	0	242	3	96	175	WP_170266723.1 phosphoenolpyruvate carboxylase [Brevifollis gellanilyticus]	diamond	240	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
16029045	16029045	PRJNA751877_P_NODE_23873_length_249_cov_0.875000_g23751_i0	PRJNA751877	23873	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	69.7	2.35e-13	NR	MDB5349418.1	2026780	g23751	i0	77.3	0.530120481927711	44	10	53	0	115	246	2	45	MDB5349418.1 acyP [Planctomycetota bacterium]	diamond	132	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
17304496	17304496	PRJNA751877_P_NODE_24874_length_248_cov_0.880000_g24752_i0	PRJNA751877	24874	248	0.88	2.1824	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	89	1.41e-18	NR	WP_146852628.1	748831	g24752	i0	91.7	0.580645161290323	48	4	58.1	0	104	247	1	48	WP_146852628.1 thymidine phosphorylase [Brevifollis gellanilyticus]	diamond	144	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
18578259	18578259	PRJNA751877_P_NODE_3575_length_485_cov_1.881068_g3453_i0	PRJNA751877	3575	485	1.881068	9.1231798	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g3453	i0	100	0.0639175257731959	31	0	6	0	395	425	7374488	7374518	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
19051813	19051813	PRJNA751877_P_NODE_155_length_1627_cov_3.868726_g97_i0	PRJNA751877	155	1627	3.868726	62.94417202	Chthoniobacter sp.	2510640	Bacteria	Bacteria	844	3.38e-305	NR	MDR3405335.1	2510640	g97	i0	88.6	0.855562384757222	464	53	85.6	0	36	1427	1	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1392	844	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
22403799	22403799	PRJNA751877_P_NODE_25238_length_247_cov_1.419540_g25116_i0	PRJNA751877	25238	247	1.41954	3.5062638	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g25116	i0	90.041	0.975708502024291	241	24	98	0	2	242	6472399	6472639	Planctomyces sp. SH-PL62, complete genome	blastn	241	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24152020	24152020	PRJNA751877_P_NODE_5399_length_424_cov_1.754986_g5277_i0	PRJNA751877	5399	424	1.754986	7.44114064	Engelhardtia	139931	Bacteria	Bacteria	58.4	8.78e-4	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g5277	i0	92.5	0.188679245283019	40	3	9	0	278	317	5427271	5427310	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	80	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
26863283	26863283	PRJNA751877_P_NODE_25561_length_247_cov_0.885057_g25439_i0	PRJNA751877	25561	247	0.885057	2.18609079	Roseimicrobium sp.	3069589	Bacteria	Bacteria	103	1.16e-23	NR	HSH93947.1	3069589	g25439	i0	62.8	0.947368421052632	78	29	94.7	0	246	13	133	210	HSH93947.1 hypothetical protein [Roseimicrobium sp.]	diamond	234	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp.
26926216	26926216	PRJNA751877_P_NODE_24382_length_249_cov_0.875000_g24260_i0	PRJNA751877	24382	249	0.875	2.17875	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	152	1.2e-40	NR	WP_170267079.1	748831	g24260	i0	92.8	1.98795180722892	83	6	100	0	1	249	1536	1618	WP_170267079.1 lamin tail domain-containing protein [Brevifollis gellanilyticus]	diamond	495	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
27495211	27495211	PRJNA751877_P_NODE_25543_length_247_cov_0.885057_g25421_i0	PRJNA751877	25543	247	0.885057	2.18609079	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	162	1.0499999999999999e-47	NR	WP_146849155.1	748831	g25421	i0	96.3	0.983805668016194	81	3	98.4	0	245	3	159	239	WP_146849155.1 ABC transporter ATP-binding protein [Brevifollis gellanilyticus]	diamond	243	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
27558105	27558105	PRJNA751877_P_NODE_29324_length_242_cov_0.911243_g29202_i0	PRJNA751877	29324	242	0.911243	2.20520806	Prosthecobacter sp.	1965333	Bacteria	Bacteria	92	2.61e-20	NR	WP_397382604.1	1965333	g29202	i0	94.9	0.483471074380165	39	2	48.3	0	242	126	249	287	WP_397382604.1 sugar phosphate isomerase/epimerase family protein [Prosthecobacter sp.]	diamond	117	92	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28221194	28221194	PRJNA751877_P_NODE_23046_length_250_cov_0.870056_g22924_i0	PRJNA751877	23046	250	0.870056	2.17514	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	120	2.13e-30	NR	WP_198141320.1	2736	g22924	i0	63.5	4.02	85	29	99.6	1	1	249	99	183	WP_198141320.1 polysaccharide pyruvyl transferase family protein [Verrucomicrobium spinosum]	diamond	1005	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
28862656	28862656	PRJNA751877_P_NODE_20628_length_261_cov_1.611702_g20506_i0	PRJNA751877	20628	261	1.611702	4.20654222	Bacteria	2	Bacteria	Bacteria	66.6	1.82e-10	NR	HEY1793481.1	2006848	g20506	i0	97	9.62068965517241	33	1	37.9	0	99	1	1	33	HEY1793481.1 GMC family oxidoreductase [Opitutaceae bacterium]	diamond	2511	66.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29083915	29083915	PRJNA751877_P_NODE_19708_length_267_cov_1.335052_g19586_i0	PRJNA751877	19708	267	1.335052	3.56458884	Pseudomonadati	3379134	Bacteria	Bacteria	82.8	4.29e-16	NR	HXC34131.1	2499141	g19586	i0	48.8	2.8876404494382	84	41	94.4	2	267	16	503	584	HXC34131.1 SDR family NAD(P)-dependent oxidoreductase [Verrucomicrobiia bacterium]	diamond	771	83.6	0.990430622009569	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29799966	29799966	PRJNA751877_P_NODE_14191_length_305_cov_2.000000_g14069_i0	PRJNA751877	14191	305	2	6.1	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	60.1	2.74e-8	NR	HEX3818319.1	2201154	g14069	i0	36	1.85901639344262	100	56	96.4	4	3	296	125	218	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	567	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29957943	29957943	PRJNA751877_P_NODE_11911_length_327_cov_1.212598_g11789_i0	PRJNA751877	11911	327	1.212598	3.96519546	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	64.3	2.51e-9	NR	MDA7675033.1	2562705	g11789	i0	34.8	4.55045871559633	89	58	81.7	0	325	59	150	238	MDA7675033.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	1488	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30306019	30306019	PRJNA751877_P_NODE_24932_length_248_cov_0.880000_g24810_i0	PRJNA751877	24932	248	0.88	2.1824	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	110	9.24e-29	NR	MCB1212107.1	2026801	g24810	i0	71.8	1.63306451612903	71	20	85.9	0	213	1	1	71	MCB1212107.1 sulfatase-like hydrolase/transferase [Verrucomicrobiales bacterium]	diamond	405	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30747913	30747913	PRJNA751877_P_NODE_23734_length_249_cov_1.539773_g23612_i0	PRJNA751877	23734	249	1.539773	3.83403477	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	154	1.1499999999999999e-42	NR	MCX6853541.1	2026799	g23612	i0	94	3.95180722891566	83	5	100	0	1	249	222	304	MCX6853541.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	984	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30906004	30906004	PRJNA751877_P_NODE_23834_length_249_cov_0.875000_g23712_i0	PRJNA751877	23834	249	0.875	2.17875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.4	7.62e-5	NR	MFM2143340.1	2026799	g23712	i0	63.4	1.36144578313253	41	14	49.4	1	126	248	135	174	MFM2143340.1 aspartate--tRNA ligase [Verrucomicrobiota bacterium]	diamond	339	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31126663	31126663	PRJNA751877_P_NODE_22535_length_251_cov_0.865169_g22413_i0	PRJNA751877	22535	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	111	5.74e-28	NR	HYF48200.1	2026780	g22413	i0	58	1.87649402390438	81	34	96.8	0	3	245	162	242	HYF48200.1 phytanoyl-CoA dioxygenase family protein [Planctomycetota bacterium]	diamond	471	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31579847	31579847	PRJNA751877_P_NODE_25496_length_247_cov_0.885057_g25374_i0	PRJNA751877	25496	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0175	NR	WP_162669483.1	1210884	g25374	i0	44.2	1.84615384615385	43	24	52.2	0	2	130	69	111	WP_162669483.1 hypothetical protein [Gemmata massiliana]	diamond	456	42.7	0.992974238875878	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
31727797	31727797	PRJNA751877_P_NODE_29977_length_241_cov_0.916667_g29855_i0	PRJNA751877	29977	241	0.916667	2.20916747	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	157	2.57e-44	NR	WP_146851029.1	748831	g29855	i0	92.4	0.983402489626556	79	6	98.3	0	239	3	244	322	WP_146851029.1 hypothetical protein [Brevifollis gellanilyticus]	diamond	237	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
31854358	31854358	PRJNA751877_P_NODE_17777_length_279_cov_1.495146_g17655_i0	PRJNA751877	17777	279	1.495146	4.17145734	Gemmataceae bacterium	2052164	Bacteria	Bacteria	118	1.93e-29	NR	MFQ3648825.1	2052164	g17655	i0	63.4	1	93	33	98.9	1	277	2	255	347	MFQ3648825.1 ROK family transcriptional regulator [Gemmataceae bacterium]	diamond	279	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32171067	32171067	PRJNA751877_P_NODE_23998_length_249_cov_0.875000_g23876_i0	PRJNA751877	23998	249	0.875	2.17875	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	164	2.29e-46	NR	WP_146855482.1	748831	g23876	i0	95.1	3.95180722891566	82	4	98.8	0	2	247	294	375	WP_146855482.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Brevifollis gellanilyticus]	diamond	984	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
32202503	32202503	PRJNA751877_P_NODE_16878_length_285_cov_1.089623_g16756_i0	PRJNA751877	16878	285	1.089623	3.10542555	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	101	1.7000000000000002e-22	NR	MBL9116487.1	2026800	g16756	i0	55.9	0.978947368421053	93	37	96.8	2	9	284	324	413	MBL9116487.1 DUF11 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	279	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32329369	32329369	PRJNA751877_P_NODE_21279_length_257_cov_1.255435_g21157_i0	PRJNA751877	21279	257	1.255435	3.22646795	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	187	1.8299999999999994e-55	NR	HCP12131.1	2026779	g21157	i0	100	0.992217898832685	85	0	99.2	0	2	256	145	229	HCP12131.1 membrane-bound O-acyltransferase family protein [Planctomycetaceae bacterium]	diamond	255	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32392322	32392322	PRJNA751877_P_NODE_17739_length_280_cov_1.000000_g17617_i0	PRJNA751877	17739	280	1	2.8	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	44.7	0.0112	NR	HQX51038.1	2026779	g17617	i0	36.1	0.771428571428571	72	45	77.1	1	242	27	64	134	HQX51038.1 branched-chain amino acid ABC transporter permease [Planctomycetaceae bacterium]	diamond	216	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;