metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA627467" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA627467" 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
3149967	3149967	PRJNA627467_P_NODE_11343_length_183_cov_1.970149_g11274_i0	PRJNA627467	11343	183	1.970149	3.60537267	Gemmataceae	1914233	Bacteria	Bacteria	82	2.33e-16	NR	WP_162136278.1	360055	g11274	i0	64	4.37704918032787	50	18	82	0	3	152	223	272	WP_162136278.1 DUF1549 and DUF1553 domain-containing protein [Zavarzinella formosa]	diamond	801	82.8	0.990338164251208	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
19002243	19002243	PRJNA627467_P_NODE_16795_length_166_cov_1.444444_g16726_i0	PRJNA627467	16795	166	1.444444	2.39777704	Gemmataceae bacterium	2052164	Bacteria	Bacteria	73.2	2.04e-13	NR	HEY7156363.1	2052164	g16726	i0	81.1	1.89759036144578	53	10	95.8	0	165	7	26	78	HEY7156363.1 ABC transporter permease [Gemmataceae bacterium]	diamond	315	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26681795	26681795	PRJNA627467_P_NODE_16941_length_166_cov_0.871795_g16872_i0	PRJNA627467	16941	166	0.871795	1.4471797	Pseudomonadati	3379134	Bacteria	Bacteria	62	1.63e-10	NR	OAI40554.1	1799653	g16872	i0	65.1	3.03614457831325	43	15	77.7	0	27	155	37	79	OAI40554.1 hypothetical protein AYO40_04695 [Planctomycetaceae bacterium SCGC AG-212-D15]	diamond	504	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium SCGC AG-212-D15
26744893	26744893	PRJNA627467_P_NODE_11621_length_182_cov_2.165414_g11552_i0	PRJNA627467	11621	182	2.165414	3.94105348	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	1.2e-16	NR	ADI16723.1	710995	g11552	i0	72	1.45054945054945	50	14	82.4	0	154	5	1	50	ADI16723.1 hypothetical protein [uncultured Verrucomicrobiales bacterium HF0010_05E02]	diamond	264	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium HF0010_05E02
26891015	26891015	PRJNA627467_P_NODE_12341_length_180_cov_1.251908_g12272_i0	PRJNA627467	12341	180	1.251908	2.2534344	Opitutus sp. ER46	2161864	Bacteria	Bacteria	108	1.04e-25	NR	WP_107834408.1	2161864	g12272	i0	93.1	0.966666666666667	58	4	96.7	0	5	178	825	882	WP_107834408.1 valine--tRNA ligase [Opitutus sp. ER46]	diamond	174	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
26953840	26953840	PRJNA627467_P_NODE_2902_length_316_cov_2.299625_g2834_i0	PRJNA627467	2902	316	2.299625	7.266815	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.5	1.37e-13	NR	GBL26153.1	2026799	g2834	i0	93.8	1.23417721518987	32	2	30.4	0	314	219	150	181	GBL26153.1 hypothetical protein EMGBS8_01010 [Verrucomicrobiota bacterium]	diamond	390	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27156250	27156250	PRJNA627467_P_NODE_19342_length_161_cov_0.910714_g19273_i0	PRJNA627467	19342	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	88.2	8.99e-19	NR	PYL05533.1	2026799	g19273	i0	73.6	4.91925465838509	53	14	98.8	0	159	1	60	112	PYL05533.1 MAG: hypothetical protein DME34_11235, partial [Verrucomicrobiota bacterium]	diamond	792	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27270182	27270182	PRJNA627467_P_NODE_10063_length_187_cov_3.833333_g9994_i0	PRJNA627467	10063	187	3.833333	7.16833271	Planctomycetota bacterium	2026780	Bacteria	Bacteria	110	1.51e-26	NR	MEL7087636.1	2026780	g9994	i0	88.7	0.994652406417112	62	7	99.5	0	1	186	285	346	MEL7087636.1 DNA cytosine methyltransferase [Planctomycetota bacterium]	diamond	186	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27333642	27333642	PRJNA627467_P_NODE_2303_length_316_cov_2.771536_g2235_i0	PRJNA627467	2303	316	2.7715360000000002	8.75805376	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	6.33e-10	NR	MEP7014928.1	2026799	g2235	i0	93.8	3.34177215189873	32	2	30.4	0	219	314	214	245	MEP7014928.1 NCS1 family nucleobase:cation symporter-1 [Verrucomicrobiota bacterium]	diamond	1056	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27586172	27586172	PRJNA627467_P_NODE_20804_length_155_cov_2.339623_g20735_i0	PRJNA627467	20804	155	2.339623	3.62641565	Spartobacteria bacterium	2052183	Bacteria	Bacteria	73.9	2.37e-15	NR	NBS53893.1	2052183	g20735	i0	92.1	0.735483870967742	38	3	73.5	0	40	153	1	38	NBS53893.1 DUF2442 domain-containing protein [Spartobacteria bacterium]	diamond	114	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
27807353	27807353	PRJNA627467_P_NODE_11404_length_183_cov_1.492537_g11335_i0	PRJNA627467	11404	183	1.492537	2.73134271	Pirellula sp.	117	Bacteria	Bacteria	99.8	1.1200000000000001e-22	NR	MBA4106719.1	117	g11335	i0	89.8	1.9344262295082	59	6	96.7	0	5	181	83	141	MBA4106719.1 hypothetical protein [Pirellula sp.]	diamond	354	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27901663	27901663	PRJNA627467_P_NODE_12565_length_179_cov_1.546154_g12496_i0	PRJNA627467	12565	179	1.546154	2.76761566	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	50.8	3.45e-6	NR	HMF38861.1	2691532	g12496	i0	65.6	0.536312849162011	32	11	53.6	0	84	179	1	32	HMF38861.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	96	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
27996700	27996700	PRJNA627467_P_NODE_20645_length_155_cov_4.509434_g20576_i0	PRJNA627467	20645	155	4.509434	6.9896227	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.6	4.54e-17	NR	MFM2198789.1	2026799	g20576	i0	76	0.967741935483871	50	12	96.8	0	153	4	908	957	MFM2198789.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28009543	28009543	PRJNA627467_P_NODE_14805_length_171_cov_3.598361_g14736_i0	PRJNA627467	14805	171	3.598361	6.15319731	root	1	Root_unresolved	Root_unresolved	73.6	1.89e-13	NR	WP_205576064.1	239935	g14736	i0	69.2	6.35087719298246	52	14	91.2	1	5	160	578	627	WP_205576064.1 hypothetical protein [Akkermansia muciniphila]	diamond	1086	74.3	0.990578734858681	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
28312394	28312394	PRJNA627467_P_NODE_10546_length_186_cov_1.277372_g10477_i0	PRJNA627467	10546	186	1.277372	2.37591192	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	97.8	6.91e-22	NR	MFO0954251.1	2691532	g10477	i0	81.4	1.90322580645161	59	11	95.2	0	184	8	102	160	MFO0954251.1 CehA/McbA family metallohydrolase [Isosphaeraceae bacterium]	diamond	354	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28754340	28754340	PRJNA627467_P_NODE_9307_length_190_cov_2.198582_g9238_i0	PRJNA627467	9307	190	2.198582	4.1773058	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	97.8	1.93e-24	NR	HEU4772675.1	2665650	g9238	i0	91.9	1.95789473684211	62	5	97.9	0	187	2	16	77	HEU4772675.1 hypothetical protein [Candidatus Udaeobacter sp.]	diamond	372	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28944111	28944111	PRJNA627467_P_NODE_21228_length_153_cov_2.711538_g21159_i0	PRJNA627467	21228	153	2.711538	4.14865314	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	100	2.4599999999999994e-23	NR	HEV8419696.1	2665650	g21159	i0	89.8	1.92156862745098	49	5	96.1	0	148	2	31	79	HEV8419696.1 NnrS family protein [Candidatus Udaeobacter sp.]	diamond	294	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28975451	28975451	PRJNA627467_P_NODE_1088_length_355_cov_2.934641_g1021_i0	PRJNA627467	1088	355	2.934641	10.41797555	Pirellulales bacterium	2715253	Bacteria	Bacteria	52	6.8e-5	NR	MEX2185422.1	2715253	g1021	i0	31.5	0.912676056338028	108	61	84.5	3	318	19	3	105	MEX2185422.1 HNH endonuclease [Pirellulales bacterium]	diamond	324	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29259327	29259327	PRJNA627467_P_NODE_19789_length_159_cov_3.545455_g19720_i0	PRJNA627467	19789	159	3.545455	5.63727345	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	1.28e-7	NR	RLS57585.1	2026780	g19720	i0	51	0.924528301886792	49	24	92.5	0	9	155	102	150	RLS57585.1 MAG: DNA-deoxyinosine glycosylase [Planctomycetota bacterium]	diamond	147	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29291052	29291052	PRJNA627467_P_NODE_12429_length_179_cov_3.323077_g12360_i0	PRJNA627467	12429	179	3.323077	5.94830783	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	85.1	1.85e-17	NR	WP_145093763.1	2528021	g12360	i0	68.5	0.905027932960894	54	17	90.5	0	177	16	294	347	WP_145093763.1 YXWGXW repeat-containing protein [Anatilimnocola aggregata]	diamond	162	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
29291053	29291053	PRJNA627467_P_NODE_15289_length_170_cov_1.628099_g15220_i0	PRJNA627467	15289	170	1.628099	2.7677683	Gemmataceae bacterium	2052164	Bacteria	Bacteria	54.3	1.15e-6	NR	HKB38353.1	2052164	g15220	i0	64.9	1.44705882352941	37	13	65.3	0	29	139	164	200	HKB38353.1 hypothetical protein [Gemmataceae bacterium]	diamond	246	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29417269	29417269	PRJNA627467_P_NODE_18449_length_163_cov_0.894737_g18380_i0	PRJNA627467	18449	163	0.894737	1.45842131	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.5	1.16e-4	NR	MBU6294112.1	2026780	g18380	i0	58.3	2.65030674846626	36	15	66.3	0	162	55	456	491	MBU6294112.1 efflux RND transporter periplasmic adaptor subunit [Planctomycetota bacterium]	diamond	432	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29985820	29985820	PRJNA627467_P_NODE_16231_length_167_cov_1.720339_g16162_i0	PRJNA627467	16231	167	1.720339	2.87296613	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	4.09e-12	NR	HWL93753.1	2026778	g16162	i0	74.4	0.772455089820359	43	11	77.2	0	167	39	292	334	HWL93753.1 amidohydrolase family protein [Phycisphaerae bacterium]	diamond	129	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30143413	30143413	PRJNA627467_P_NODE_18972_length_161_cov_5.089286_g18903_i0	PRJNA627467	18972	161	5.089286	8.19375046	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	67	3.32e-11	NR	MFO0975231.1	2026779	g18903	i0	59.6	1.93788819875776	52	21	96.9	0	156	1	481	532	MFO0975231.1 signal peptidase I [Planctomycetaceae bacterium]	diamond	312	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30270432	30270432	PRJNA627467_P_NODE_15972_length_168_cov_1.352941_g15903_i0	PRJNA627467	15972	168	1.352941	2.27294088	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.3	6.73e-5	NR	NDG61965.1	2026780	g15903	i0	71.9	0.571428571428571	32	9	57.1	0	168	73	468	499	NDG61965.1 DEAD/DEAH box helicase [Planctomycetota bacterium]	diamond	96	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30491403	30491403	PRJNA627467_P_NODE_9613_length_189_cov_1.821429_g9544_i0	PRJNA627467	9613	189	1.821429	3.44250081	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	75.5	5.13e-14	NR	HXI73658.1	2499141	g9544	i0	63.3	0.952380952380952	60	22	95.2	0	6	185	168	227	HXI73658.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	180	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30744126	30744126	PRJNA627467_P_NODE_15014_length_171_cov_1.442623_g14945_i0	PRJNA627467	15014	171	1.442623	2.46688533	Planctomycetia bacterium	2052181	Bacteria	Bacteria	92.4	4.36e-20	NR	MBL8792391.1	2052181	g14945	i0	93.5	0.807017543859649	46	3	80.7	0	140	3	1	46	MBL8792391.1 DEAD/DEAH box helicase [Planctomycetia bacterium]	diamond	138	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31344653	31344653	PRJNA627467_P_NODE_18256_length_163_cov_1.684211_g18187_i0	PRJNA627467	18256	163	1.684211	2.74526393	Gemmataceae bacterium	2052164	Bacteria	Bacteria	57.4	1.44e-8	NR	HKB40244.1	2052164	g18187	i0	52	1.84049079754601	50	24	92	0	155	6	84	133	HKB40244.1 cytochrome c [Gemmataceae bacterium]	diamond	300	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31597832	31597832	PRJNA627467_P_NODE_16936_length_166_cov_0.871795_g16867_i0	PRJNA627467	16936	166	0.871795	1.4471797	Gemmatales bacterium	2838789	Bacteria	Bacteria	56.6	1.69e-7	NR	HMP01689.1	2838789	g16867	i0	48.9	1.42771084337349	45	23	81.3	0	139	5	16	60	HMP01689.1 hypothetical protein [Gemmatales bacterium]	diamond	237	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
31818925	31818925	PRJNA627467_P_NODE_4697_length_316_cov_1.692884_g4629_i0	PRJNA627467	4697	316	1.692884	5.34951344	Opitutales bacterium	2026772	Bacteria	Bacteria	45.8	0.0072	NR	MFP4157167.1	2026772	g4629	i0	70	0.588607594936709	30	9	28.5	0	314	225	953	982	MFP4157167.1 chemotaxis protein CheW [Opitutales bacterium]	diamond	186	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
32008877	32008877	PRJNA627467_P_NODE_12918_length_178_cov_1.449612_g12849_i0	PRJNA627467	12918	178	1.449612	2.58030936	Pirellulales bacterium	2715253	Bacteria	Bacteria	59.3	1.23e-8	NR	HVA48474.1	2715253	g12849	i0	68.2	0.741573033707865	44	14	74.2	0	6	137	194	237	HVA48474.1 hypothetical protein [Pirellulales bacterium]	diamond	132	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32135524	32135524	PRJNA627467_P_NODE_10258_length_187_cov_1.376812_g10189_i0	PRJNA627467	10258	187	1.376812	2.57463844	Roseimicrobium sp.	3069589	Bacteria	Bacteria	75.9	2.05e-14	NR	HSH95181.1	3069589	g10189	i0	55.7	1.9572192513369	61	27	97.9	0	186	4	101	161	HSH95181.1 DUF6268 family outer membrane beta-barrel protein [Roseimicrobium sp.]	diamond	366	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp.
32135535	32135535	PRJNA627467_P_NODE_9938_length_188_cov_1.438849_g9869_i0	PRJNA627467	9938	188	1.438849	2.70503612	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	73.9	1.77e-13	NR	MFI0435913.1	2052176	g9869	i0	51.7	0.957446808510638	60	29	95.7	0	4	183	291	350	MFI0435913.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	180	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32357160	32357160	PRJNA627467_P_NODE_16079_length_167_cov_3.313559_g16010_i0	PRJNA627467	16079	167	3.313559	5.53364353	Planctomycetia bacterium	2052181	Bacteria	Bacteria	80.9	3.9e-16	NR	MBI3839575.1	2052181	g16010	i0	76	1.79640718562874	50	12	89.8	0	4	153	186	235	MBI3839575.1 efflux RND transporter periplasmic adaptor subunit [Planctomycetia bacterium]	diamond	300	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
32874410	32874410	PRJNA627467_P_NODE_9480_length_189_cov_3.564286_g9411_i0	PRJNA627467	9480	189	3.564286	6.73650054	Prosthecobacter	48463	Bacteria	Bacteria	71.2	6.4e-13	NR	MFN7563283.1	1965333	g9411	i0	68.1	2.23809523809524	47	15	74.6	0	27	167	87	133	MFN7563283.1 hypothetical protein [Prosthecobacter sp.]	diamond	423	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.

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);;