metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax_clade = "PVC group"

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
872887	872887	PRJNA896758_P_NODE_25421_length_243_cov_0.905882_g25031_i0	PRJNA896758	25421	243	0.905882	2.20129326	Planctomicrobium	1779141	Bacteria	Bacteria	80.1	2.57e-15	NR	MBK8097468.1	2026780	g25031	i0	52	5.8641975308642	75	36	92.6	0	18	242	1	75	MBK8097468.1 discoidin domain-containing protein [Planctomycetota bacterium]	diamond	1425	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
12351789	12351789	PRJNA896758_P_NODE_19890_length_260_cov_1.647059_g19500_i0	PRJNA896758	19890	260	1.647059	4.2823534	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	158	9.25e-45	NR	MBY0307539.1	2052180	g19500	i0	80.2	0.992307692307692	86	17	99.2	0	3	260	304	389	MBY0307539.1 hypothetical protein [Phycisphaerales bacterium]	diamond	258	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
17451066	17451066	PRJNA896758_P_NODE_23514_length_247_cov_0.885057_g23124_i0	PRJNA896758	23514	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	103	4.52e-24	NR	MCB9915701.1	2026780	g23124	i0	60.5	3.88663967611336	81	32	98.4	0	245	3	126	206	MCB9915701.1 glycosyltransferase [Planctomycetota bacterium]	diamond	960	104	0.990384615384615	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26834287	26834287	PRJNA896758_P_NODE_18961_length_267_cov_1.489691_g18571_i0	PRJNA896758	18961	267	1.489691	3.97747497	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.9	0.00354	NR	MDP1799090.1	2026779	g18571	i0	55.6	0.764044943820225	36	16	40.4	0	267	160	54	89	MDP1799090.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	204	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27466654	27466654	PRJNA896758_P_NODE_18283_length_272_cov_1.331658_g17893_i0	PRJNA896758	18283	272	1.331658	3.62210976	Simkania sp.	34094	Bacteria	Bacteria	133	1.93e-36	NR	MCB1084310.1	34094	g17893	i0	86.8	0.838235294117647	76	10	83.8	0	271	44	46	121	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	228	133	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27782378	27782378	PRJNA896758_P_NODE_15324_length_291_cov_2.431193_g14934_i0	PRJNA896758	15324	291	2.431193	7.07477163	Gemmataceae bacterium	2052164	Bacteria	Bacteria	164	2.38e-48	NR	MDW8265987.1	2052164	g14934	i0	78.1	1.97938144329897	96	21	99	0	3	290	62	157	MDW8265987.1 hypothetical protein [Gemmataceae bacterium]	diamond	576	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27782391	27782391	PRJNA896758_P_NODE_25344_length_243_cov_0.905882_g24954_i0	PRJNA896758	25344	243	0.905882	2.20129326	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.2	3.92e-11	NR	MCG8404944.1	2052180	g24954	i0	85.3	0.419753086419753	34	5	42	0	243	142	298	331	MCG8404944.1 endonuclease [Phycisphaerales bacterium]	diamond	102	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28224084	28224084	PRJNA896758_P_NODE_18426_length_271_cov_1.247475_g18036_i0	PRJNA896758	18426	271	1.247475	3.38065725	Urbifossiella sp.	2807431	Bacteria	Bacteria	52.8	7.92e-6	NR	HYH67232.1	2807431	g18036	i0	72.4	0.996309963099631	29	8	32.1	0	184	270	12	40	HYH67232.1 Uma2 family endonuclease [Urbifossiella sp.]	diamond	270	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
28382151	28382151	PRJNA896758_P_NODE_22366_length_249_cov_0.875000_g21976_i0	PRJNA896758	22366	249	0.875	2.17875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	97.1	3.26e-21	NR	MCA9243179.1	2052180	g21976	i0	54.3	1.95180722891566	81	37	97.6	0	1	243	873	953	MCA9243179.1 hypothetical protein [Phycisphaerales bacterium]	diamond	486	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28413815	28413815	PRJNA896758_P_NODE_17006_length_280_cov_1.743961_g16616_i0	PRJNA896758	17006	280	1.743961	4.8830908	Opitutaceae bacterium	2006848	Bacteria	Bacteria	112	2.66e-26	NR	MCU0791279.1	2006848	g16616	i0	60	0.964285714285714	90	36	96.4	0	11	280	717	806	MCU0791279.1 translocation/assembly module TamB [Opitutaceae bacterium]	diamond	270	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28571516	28571516	PRJNA896758_P_NODE_14507_length_301_cov_1.350877_g14117_i0	PRJNA896758	14507	301	1.350877	4.06613977	Novipirellula galeiformis	2528004	Bacteria	Bacteria	101	7.1e-25	NR	WP_146595968.1	2528004	g14117	i0	47.4	0.946843853820598	95	48	92.7	1	5	283	35	129	WP_146595968.1 pyridoxamine 5'-phosphate oxidase family protein [Novipirellula galeiformis]	diamond	285	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula galeiformis
28603267	28603267	PRJNA896758_P_NODE_19867_length_260_cov_2.663102_g19477_i0	PRJNA896758	19867	260	2.663102	6.9240652	Planctomycetia bacterium	2052181	Bacteria	Bacteria	134	2.94e-34	NR	MBL8799561.1	2052181	g19477	i0	76.7	1.97307692307692	86	20	99.2	0	260	3	719	804	MBL8799561.1 DUF2309 domain-containing protein [Planctomycetia bacterium]	diamond	513	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
28926556	28926556	PRJNA896758_P_NODE_23248_length_247_cov_1.551724_g22858_i0	PRJNA896758	23248	247	1.551724	3.83275828	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.00167	NR	MCH8967893.1	2026780	g22858	i0	35.8	4.40890688259109	81	38	86.2	3	242	30	445	521	MCH8967893.1 hypothetical protein [Planctomycetota bacterium]	diamond	1089	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29013944	29013944	PRJNA896758_P_NODE_13028_length_319_cov_0.841463_g12638_i0	PRJNA896758	13028	319	0.841463	2.68426697	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0314	NR	MEI6341235.1	2026799	g12638	i0	33.7	0.780564263322884	83	46	69.6	2	58	279	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29045322	29045322	PRJNA896758_P_NODE_17348_length_278_cov_1.390244_g16958_i0	PRJNA896758	17348	278	1.390244	3.86487832	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	72.8	1.47e-12	NR	MDX1930724.1	2699754	g16958	i0	41.4	1.80215827338129	87	51	93.9	0	17	277	157	243	MDX1930724.1 DNA ligase [Pirellulaceae bacterium]	diamond	501	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29076950	29076950	PRJNA896758_P_NODE_26148_length_242_cov_0.911243_g25758_i0	PRJNA896758	26148	242	0.911243	2.20520806	Planctomycetota bacterium	2026780	Bacteria	Bacteria	67.8	9.74e-12	NR	NOT29662.1	2026780	g25758	i0	47.6	2.36776859504132	63	33	78.1	0	239	51	118	180	NOT29662.1 cysteine dioxygenase family protein [Planctomycetota bacterium]	diamond	573	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29203277	29203277	PRJNA896758_P_NODE_25909_length_242_cov_0.911243_g25519_i0	PRJNA896758	25909	242	0.911243	2.20520806	Planctomycetaceae bacterium SCGC AG-212-F19	1799658	Bacteria	Bacteria	85.1	1.12e-17	NR	OAI48071.1	1799658	g25519	i0	50.7	3.40909090909091	71	35	88	0	242	30	187	257	OAI48071.1 hypothetical protein AYO44_01325 [Planctomycetaceae bacterium SCGC AG-212-F19]	diamond	825	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium SCGC AG-212-F19
29297837	29297837	PRJNA896758_P_NODE_19949_length_260_cov_1.256684_g19559_i0	PRJNA896758	19949	260	1.256684	3.2673784	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00173	NR	MEI6341235.1	2026799	g19559	i0	36.8	0.876923076923077	76	39	77.3	2	218	18	84	159	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	228	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29329320	29329320	PRJNA896758_P_NODE_17189_length_279_cov_1.470874_g16799_i0	PRJNA896758	17189	279	1.470874	4.10373846	Luteolibacter luteus	2728835	Bacteria	Bacteria	140	1.94e-36	NR	WP_169455091.1	2728835	g16799	i0	67.7	1	93	29	100	1	279	1	555	646	WP_169455091.1 multicopper oxidase domain-containing protein [Luteolibacter luteus]	diamond	279	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
29392639	29392639	PRJNA896758_P_NODE_25289_length_243_cov_1.376471_g24899_i0	PRJNA896758	25289	243	1.376471	3.34482453	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.1	2.88e-8	NR	MEK7483685.1	2026780	g24899	i0	47.6	0.777777777777778	63	32	76.5	1	198	13	361	423	MEK7483685.1 serine protease [Planctomycetota bacterium]	diamond	189	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29676321	29676321	PRJNA896758_P_NODE_15190_length_293_cov_1.172727_g14800_i0	PRJNA896758	15190	293	1.172727	3.43609011	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	102	9.5e-23	NR	HSX03888.1	2047756	g14800	i0	49	1.00341296928328	98	46	98.3	2	289	2	101	196	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	294	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30055518	30055518	PRJNA896758_P_NODE_15611_length_289_cov_1.791667_g15221_i0	PRJNA896758	15611	289	1.791667	5.17791763	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.1	0.00155	NR	HIB00376.1	2052180	g15221	i0	51.5	0.633217993079585	33	16	34.3	0	284	186	14	46	HIB00376.1 tetratricopeptide repeat protein [Phycisphaerales bacterium]	diamond	183	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30624239	30624239	PRJNA896758_P_NODE_18913_length_267_cov_2.278351_g18523_i0	PRJNA896758	18913	267	2.278351	6.08319717	Gemmataceae bacterium	2052164	Bacteria	Bacteria	91.7	7.7e-21	NR	MEO2091034.1	2052164	g18523	i0	55.1	1	89	40	100	0	1	267	55	143	MEO2091034.1 hypothetical protein [Gemmataceae bacterium]	diamond	267	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30750872	30750872	PRJNA896758_P_NODE_23314_length_247_cov_0.885057_g22924_i0	PRJNA896758	23314	247	0.885057	2.18609079	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	111	2.39e-29	NR	HEU5071473.1	2499141	g22924	i0	76.4	0.874493927125506	72	17	87.4	0	247	32	57	128	HEU5071473.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	216	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30782386	30782386	PRJNA896758_P_NODE_26454_length_241_cov_0.916667_g26064_i0	PRJNA896758	26454	241	0.916667	2.20916747	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	42.7	0.0369	NR	HHH75565.1	2026778	g26064	i0	33.9	0.771784232365145	62	38	73.4	1	193	17	269	330	HHH75565.1 DUF4159 domain-containing protein [Phycisphaerae bacterium]	diamond	186	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30813948	30813948	PRJNA896758_P_NODE_18874_length_268_cov_1.184615_g18484_i0	PRJNA896758	18874	268	1.184615	3.1747682	Chlamydiales bacterium	2047757	Bacteria	Bacteria	129	7.35e-36	NR	MCP5470420.1	2047757	g18484	i0	83.8	0.828358208955224	74	12	82.8	0	1	222	8	81	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	222	129	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30877155	30877155	PRJNA896758_P_NODE_20734_length_254_cov_1.033149_g20344_i0	PRJNA896758	20734	254	1.033149	2.62419846	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	79.7	4.07e-15	NR	MEZ6123636.1	2026779	g20344	i0	48.8	0.992125984251969	84	39	99.2	1	253	2	535	614	MEZ6123636.1 peroxidase family protein [Planctomycetaceae bacterium]	diamond	252	79.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31256362	31256362	PRJNA896758_P_NODE_23075_length_248_cov_0.880000_g22685_i0	PRJNA896758	23075	248	0.88	2.1824	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.4	0.00426	NR	MEX2219228.1	2052180	g22685	i0	31.6	1.92338709677419	79	52	95.6	1	4	240	277	353	MEX2219228.1 hypothetical protein [Phycisphaerales bacterium]	diamond	477	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31351374	31351374	PRJNA896758_P_NODE_20036_length_259_cov_1.655914_g19646_i0	PRJNA896758	20036	259	1.655914	4.28881726	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	107	6.6799999999999985e-25	NR	HEY2154002.1	2691532	g19646	i0	63.9	21.3938223938224	72	26	83.4	0	257	42	420	491	HEY2154002.1 aldehyde dehydrogenase family protein [Isosphaeraceae bacterium]	diamond	5541	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
31383008	31383008	PRJNA896758_P_NODE_20076_length_259_cov_1.333333_g19686_i0	PRJNA896758	20076	259	1.333333	3.45333247	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	52.4	1.32e-5	NR	MCA8988186.1	2026779	g19686	i0	35.1	0.857142857142857	74	46	83.4	2	9	224	29	102	MCA8988186.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	222	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31390748	31390748	PRJNA896758_P_NODE_16836_length_281_cov_2.134615_g16446_i0	PRJNA896758	16836	281	2.134615	5.99826815	Pseudomonadati	3379134	Bacteria	Bacteria	61.2	1.83e-8	NR	MFP4435414.1	2026778	g16446	i0	42.7	6.06405693950178	82	41	81.1	3	11	238	615	696	MFP4435414.1 hypothetical protein [Phycisphaerae bacterium]	diamond	1704	61.6	0.993506493506494	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31730698	31730698	PRJNA896758_P_NODE_23777_length_246_cov_1.526012_g23387_i0	PRJNA896758	23777	246	1.526012	3.75398952	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	44.3	0.011	NR	HVT26924.1	2691534	g23387	i0	47.5	1.48780487804878	61	22	74.4	1	2	184	659	709	HVT26924.1 secretin N-terminal domain-containing protein [Lacipirellulaceae bacterium]	diamond	366	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
32268842	32268842	PRJNA896758_P_NODE_23518_length_247_cov_0.885057_g23128_i0	PRJNA896758	23518	247	0.885057	2.18609079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	106	8.3e-25	NR	HEX3147824.1	2052164	g23128	i0	64.6	1.96761133603239	82	28	99.6	1	1	246	286	366	HEX3147824.1 tyrosine-type recombinase/integrase [Gemmataceae bacterium]	diamond	486	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;