metadata: contig_metadata: 63 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax

63 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
5296438	5296438	PRJNA1086823_P_NODE_12505_length_253_cov_0.866667_g12388_i0	PRJNA1086823	12505	253	0.866667	2.19266751	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	138	8.61e-40	NR	HEX2473236.1	2691534	g12388	i0	78.6	0.99604743083004	84	18	99.6	0	252	1	17	100	HEX2473236.1 OsmC family protein [Lacipirellulaceae bacterium]	diamond	252	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
7846387	7846387	PRJNA1086823_P_NODE_15307_length_248_cov_0.891429_g15190_i0	PRJNA1086823	15307	248	0.891429	2.21074392	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	147	7.24e-39	NR	MBP90009.1	2026779	g15190	i0	87.3	1.91129032258065	79	10	95.6	0	244	8	144	222	MBP90009.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	474	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
9121303	9121303	PRJNA1086823_P_NODE_12748_length_252_cov_0.871508_g12631_i0	PRJNA1086823	12748	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	132	1.69e-33	NR	HEY5753989.1	2201154	g12631	i0	75.6	45.25	82	20	97.6	0	251	6	668	749	HEY5753989.1 DEAD/DEAH box helicase [Chthoniobacterales bacterium]	diamond	11403	133	0.992481203007519	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
10397044	10397044	PRJNA1086823_P_NODE_13989_length_250_cov_0.881356_g13872_i0	PRJNA1086823	13989	250	0.881356	2.20339	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	108	6.79e-27	NR	HWB58488.1	2811408	g13872	i0	65.9	0.984	82	26	98.4	1	248	3	16	95	HWB58488.1 glycosyltransferase [Chthoniobacteraceae bacterium]	diamond	246	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
18869026	18869026	PRJNA1086823_P_NODE_17815_length_244_cov_0.912281_g17698_i0	PRJNA1086823	17815	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	149	1.3899999999999999e-40	NR	MBI3856869.1	2026780	g17698	i0	87.7	1.99180327868852	81	10	99.6	0	243	1	218	298	MBI3856869.1 2-hydroxyglutaryl-CoA dehydratase [Planctomycetota bacterium]	diamond	486	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
20594856	20594856	PRJNA1086823_P_NODE_18357_length_243_cov_0.917647_g18240_i0	PRJNA1086823	18357	243	0.917647	2.22988221	Pirellulales bacterium	2715253	Bacteria	Bacteria	107	9.24e-25	NR	MEX2091893.1	2715253	g18240	i0	67.9	1	81	26	100	0	243	1	320	400	MEX2091893.1 UvrD-helicase domain-containing protein [Pirellulales bacterium]	diamond	243	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
23145900	23145900	PRJNA1086823_P_NODE_14359_length_250_cov_0.881356_g14242_i0	PRJNA1086823	14359	250	0.881356	2.20339	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	130	1.87e-35	NR	HVZ94251.1	2052180	g14242	i0	90.9	0.924	77	7	92.4	0	18	248	22	98	HVZ94251.1 HNH endonuclease [Phycisphaerales bacterium]	diamond	231	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26687625	26687625	PRJNA1086823_P_NODE_18161_length_243_cov_1.735294_g18044_i0	PRJNA1086823	18161	243	1.735294	4.21676442	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	105	3.1799999999999998e-24	NR	MCC6510096.1	2699754	g18044	i0	88.9	2	81	9	100	0	1	243	287	367	MCC6510096.1 hypothetical protein [Pirellulaceae bacterium]	diamond	486	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
26877925	26877925	PRJNA1086823_P_NODE_16961_length_245_cov_0.906977_g16844_i0	PRJNA1086823	16961	245	0.906977	2.22209365	Opitutaceae bacterium	2006848	Bacteria	Bacteria	152	2.07e-41	NR	MBW7894878.1	2006848	g16844	i0	84	2.97551020408163	81	13	99.2	0	1	243	11	91	MBW7894878.1 SAM-dependent DNA methyltransferase [Opitutaceae bacterium]	diamond	729	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
26972526	26972526	PRJNA1086823_P_NODE_18242_length_243_cov_0.917647_g18125_i0	PRJNA1086823	18242	243	0.917647	2.22988221	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	123	1.0500000000000001e-30	NR	HJQ79905.1	2691534	g18125	i0	76.3	1.97530864197531	80	19	98.8	0	2	241	91	170	HJQ79905.1 AAA family ATPase [Lacipirellulaceae bacterium]	diamond	480	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
27004099	27004099	PRJNA1086823_P_NODE_15522_length_248_cov_0.891429_g15405_i0	PRJNA1086823	15522	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.7	1.4e-4	NR	MBI5365533.1	2026780	g15405	i0	75	0.338709677419355	28	7	33.9	0	243	160	557	584	MBI5365533.1 hypothetical protein [Planctomycetota bacterium]	diamond	84	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27004102	27004102	PRJNA1086823_P_NODE_1842_length_549_cov_0.945378_g1726_i0	PRJNA1086823	1842	549	0.945378	5.19012522	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	52.8	4.91e-5	NR	MEN6367745.1	2691551	g1726	i0	29.9	0.584699453551913	107	64	52.5	2	331	44	4	110	MEN6367745.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	321	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
27035883	27035883	PRJNA1086823_P_NODE_11302_length_259_cov_3.010753_g11185_i0	PRJNA1086823	11302	259	3.010753	7.79785027	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	5.33e-5	NR	MEO8427722.1	2026799	g11185	i0	51.7	1.37837837837838	58	20	60.2	2	6	161	42	97	MEO8427722.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	357	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27067439	27067439	PRJNA1086823_P_NODE_9402_length_278_cov_1.868293_g9285_i0	PRJNA1086823	9402	278	1.868293	5.19385454	Pirellulales bacterium	2715253	Bacteria	Bacteria	145	1.36e-39	NR	MEX2093738.1	2715253	g9285	i0	80.2	0.982014388489209	91	18	98.2	0	4	276	111	201	MEX2093738.1 excinuclease ABC subunit A [Pirellulales bacterium]	diamond	273	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27415440	27415440	PRJNA1086823_P_NODE_15863_length_247_cov_0.896552_g15746_i0	PRJNA1086823	15863	247	0.896552	2.21448344	Gemmataceae bacterium	2052164	Bacteria	Bacteria	152	4.62e-42	NR	MEO2091164.1	2052164	g15746	i0	91.5	0.995951417004049	82	7	99.6	0	2	247	351	432	MEO2091164.1 glycosyltransferase [Gemmataceae bacterium]	diamond	246	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27415443	27415443	PRJNA1086823_P_NODE_18543_length_243_cov_0.917647_g18426_i0	PRJNA1086823	18543	243	0.917647	2.22988221	Pirellulales bacterium	2715253	Bacteria	Bacteria	58.9	7.35e-8	NR	MEX2091185.1	2715253	g18426	i0	49.3	0.851851851851852	69	35	85.2	0	237	31	137	205	MEX2091185.1 hypothetical protein [Pirellulales bacterium]	diamond	207	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27510004	27510004	PRJNA1086823_P_NODE_18103_length_244_cov_0.871345_g17986_i0	PRJNA1086823	18103	244	0.871345	2.1260818	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	114	2.03e-27	NR	HOX56336.1	2026799	g17986	i0	65.8	0.971311475409836	79	27	97.1	0	3	239	111	189	HOX56336.1 cell wall anchor protein [Verrucomicrobiota bacterium]	diamond	237	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27541544	27541544	PRJNA1086823_P_NODE_3544_length_412_cov_2.675516_g3427_i0	PRJNA1086823	3544	412	2.675516	11.02312592	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	161	2.67e-46	NR	MCD4825372.1	2026778	g3427	i0	55.6	0.968446601941748	133	56	96.1	2	401	6	53	183	MCD4825372.1 thymidylate synthase [Phycisphaerae bacterium]	diamond	399	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27880208	27880208	PRJNA1086823_P_NODE_17225_length_245_cov_0.906977_g17108_i0	PRJNA1086823	17225	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	98.6	9.59e-23	NR	MEM8735454.1	2026780	g17108	i0	57.5	2.88979591836735	80	34	98	0	240	1	99	178	MEM8735454.1 substrate-binding domain-containing protein [Planctomycetota bacterium]	diamond	708	99.4	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28038201	28038201	PRJNA1086823_P_NODE_19665_length_227_cov_2.025974_g19548_i0	PRJNA1086823	19665	227	2.025974	4.59896098	Pirellulimonas	2795783	Bacteria	Bacteria	111	2.21e-26	NR	WP_145284923.1	2528009	g19548	i0	70.3	2.96035242290749	74	22	97.8	0	223	2	492	565	WP_145284923.1 glycoside hydrolase family 44 protein [Pirellulimonas nuda]	diamond	672	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
29120390	29120390	PRJNA1086823_P_NODE_12289_length_253_cov_0.866667_g12172_i0	PRJNA1086823	12289	253	0.866667	2.19266751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	140	4.57e-38	NR	MBX9735703.1	2052180	g12172	i0	79.8	0.99604743083004	84	17	99.6	0	252	1	186	269	MBX9735703.1 ABC transporter permease [Phycisphaerales bacterium]	diamond	252	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29120394	29120394	PRJNA1086823_P_NODE_17649_length_244_cov_0.912281_g17532_i0	PRJNA1086823	17649	244	0.912281	2.22596564	Zavarzinella sp.	1914240	Bacteria	Bacteria	116	3.71e-28	NR	MEZ6143479.1	1914240	g17532	i0	68.8	0.983606557377049	80	25	98.4	0	242	3	200	279	MEZ6143479.1 DUF1588 domain-containing protein [Zavarzinella sp.]	diamond	240	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella sp.
29120400	29120400	PRJNA1086823_P_NODE_9649_length_276_cov_1.261084_g9532_i0	PRJNA1086823	9649	276	1.261084	3.48059184	Pirellulales bacterium	2715253	Bacteria	Bacteria	130	1.22e-35	NR	MEX2093914.1	2715253	g9532	i0	75.6	0.978260869565217	90	22	97.8	0	271	2	125	214	MEX2093914.1 divalent metal cation transporter [Pirellulales bacterium]	diamond	270	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29152097	29152097	PRJNA1086823_P_NODE_12309_length_253_cov_0.866667_g12192_i0	PRJNA1086823	12309	253	0.866667	2.19266751	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	107	6.84e-25	NR	MBX7210235.1	2026800	g12192	i0	59.1	1.10276679841897	93	27	98.4	3	3	251	200	291	MBX7210235.1 aryl-sulfate sulfotransferase [Verrucomicrobiaceae bacterium]	diamond	279	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29498985	29498985	PRJNA1086823_P_NODE_9250_length_280_cov_1.507246_g9133_i0	PRJNA1086823	9250	280	1.507246	4.2202888	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	159	1.35e-46	NR	MBA2726772.1	2052176	g9133	i0	81.7	0.996428571428571	93	17	99.6	0	279	1	88	180	MBA2726772.1 efflux RND transporter periplasmic adaptor subunit [Parachlamydiaceae bacterium]	diamond	279	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29530680	29530680	PRJNA1086823_P_NODE_14510_length_249_cov_0.886364_g14393_i0	PRJNA1086823	14510	249	0.886364	2.20704636	Pirellulales bacterium	2715253	Bacteria	Bacteria	90.1	8.24e-19	NR	MEX0642886.1	2715253	g14393	i0	53.1	1.96385542168675	81	37	97.6	1	244	2	270	349	MEX0642886.1 TIGR03545 family protein [Pirellulales bacterium]	diamond	489	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29562064	29562064	PRJNA1086823_P_NODE_16130_length_247_cov_0.896552_g16013_i0	PRJNA1086823	16130	247	0.896552	2.21448344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	149	1.36e-40	NR	MDH4410114.1	2026801	g16013	i0	86.3	1.95546558704453	80	11	97.2	0	3	242	379	458	MDH4410114.1 polysaccharide pyruvyl transferase family protein [Verrucomicrobiales bacterium]	diamond	483	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29656505	29656505	PRJNA1086823_P_NODE_8850_length_284_cov_1.322275_g8733_i0	PRJNA1086823	8850	284	1.322275	3.755261	Pirellulales bacterium	2715253	Bacteria	Bacteria	59.7	6.4e-8	NR	MEX2092643.1	2715253	g8733	i0	64.6	0.507042253521127	48	17	50.7	0	139	282	25	72	MEX2092643.1 choice-of-anchor I family protein [Pirellulales bacterium]	diamond	144	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29783169	29783169	PRJNA1086823_P_NODE_18771_length_243_cov_0.858824_g18654_i0	PRJNA1086823	18771	243	0.858824	2.08694232	Planctomycetota bacterium	2026780	Bacteria	Bacteria	150	6.03e-41	NR	MCB9891214.1	2026780	g18654	i0	86.3	2.96296296296296	80	11	98.8	0	3	242	230	309	MCB9891214.1 B12-binding domain-containing radical SAM protein [Planctomycetota bacterium]	diamond	720	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29846388	29846388	PRJNA1086823_P_NODE_14951_length_249_cov_0.886364_g14834_i0	PRJNA1086823	14951	249	0.886364	2.20704636	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	87	1.02e-17	NR	MCU0879836.1	2699754	g14834	i0	46.3	0.987951807228916	82	44	98.8	0	2	247	288	369	MCU0879836.1 serine/threonine-protein kinase [Pirellulaceae bacterium]	diamond	246	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29901091	29901091	PRJNA1086823_P_NODE_19311_length_242_cov_0.923077_g19194_i0	PRJNA1086823	19311	242	0.923077	2.23384634	Pirellulales	2691354	Bacteria	Bacteria	108	1.67e-25	NR	MBA4107628.1	117	g19194	i0	73.8	3.96694214876033	80	21	99.2	0	240	1	295	374	MBA4107628.1 hypothetical protein [Pirellula sp.]	diamond	960	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29995908	29995908	PRJNA1086823_P_NODE_8691_length_285_cov_2.202830_g8574_i0	PRJNA1086823	8691	285	2.20283	6.2780655	Bacteria	2	Bacteria	Bacteria	135	6.18e-36	NR	HEY4233965.1	2691534	g8574	i0	68.1	4.94736842105263	94	30	98.9	0	284	3	174	267	HEY4233965.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	1410	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30067432	30067432	PRJNA1086823_P_NODE_15172_length_248_cov_0.891429_g15055_i0	PRJNA1086823	15172	248	0.891429	2.21074392	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	44.3	0.00152	NR	HVT29832.1	2691534	g15055	i0	62.5	1.58467741935484	32	12	38.7	0	97	2	1	32	HVT29832.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	393	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30130342	30130342	PRJNA1086823_P_NODE_12152_length_253_cov_0.866667_g12035_i0	PRJNA1086823	12152	253	0.866667	2.19266751	Pirellulales bacterium	2715253	Bacteria	Bacteria	147	2.16e-39	NR	MEX2091692.1	2715253	g12035	i0	82.1	0.99604743083004	84	15	99.6	0	2	253	530	613	MEX2091692.1 cytochrome b N-terminal domain-containing protein [Pirellulales bacterium]	diamond	252	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30130349	30130349	PRJNA1086823_P_NODE_18332_length_243_cov_0.917647_g18215_i0	PRJNA1086823	18332	243	0.917647	2.22988221	Haloferula rosea	490093	Bacteria	Bacteria	135	4.6599999999999995e-37	NR	WP_200275685.1	490093	g18215	i0	85	4.9382716049382704	80	12	98.8	0	241	2	81	160	WP_200275685.1 acetyl-CoA carboxylase, carboxyltransferase subunit beta [Haloferula rosea]	diamond	1200	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula rosea
30162051	30162051	PRJNA1086823_P_NODE_6392_length_323_cov_0.936000_g6275_i0	PRJNA1086823	6392	323	0.936	3.02328	Pirellulales bacterium	2715253	Bacteria	Bacteria	197	4.95e-57	NR	MEX2091162.1	2715253	g6275	i0	86	0.993808049535604	107	15	99.4	0	1	321	187	293	MEX2091162.1 HlyD family efflux transporter periplasmic adaptor subunit [Pirellulales bacterium]	diamond	321	197	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30193778	30193778	PRJNA1086823_P_NODE_17172_length_245_cov_0.906977_g17055_i0	PRJNA1086823	17172	245	0.906977	2.22209365	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	171	1.01e-52	NR	HEY4234264.1	2691534	g17055	i0	88.9	1.98367346938776	81	9	99.2	0	3	245	23	103	HEY4234264.1 YkgJ family cysteine cluster protein [Lacipirellulaceae bacterium]	diamond	486	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30248757	30248757	PRJNA1086823_P_NODE_14532_length_249_cov_0.886364_g14415_i0	PRJNA1086823	14532	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	154	3.1099999999999998e-46	NR	PYJ67514.1	2026799	g14415	i0	88	5	83	10	100	0	1	249	50	132	PYJ67514.1 MAG: hypothetical protein DME76_15025, partial [Verrucomicrobiota bacterium]	diamond	1245	155	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30415416	30415416	PRJNA1086823_P_NODE_18713_length_243_cov_0.917647_g18596_i0	PRJNA1086823	18713	243	0.917647	2.22988221	Verrucomicrobia bacterium 21-51-4	1970609	Bacteria	Bacteria	110	2.33e-26	NR	OYV47722.1	1970609	g18596	i0	75	0.987654320987654	80	20	98.8	0	3	242	53	132	OYV47722.1 MAG: EscC/YscC/HrcC family type III secretion system outer membrane ring protein, partial [Verrucomicrobia bacterium 21-51-4]	diamond	240	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium 21-51-4
30446835	30446835	PRJNA1086823_P_NODE_13293_length_251_cov_0.876404_g13176_i0	PRJNA1086823	13293	251	0.876404	2.19977404	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	141	5.35e-40	NR	MCL4192204.1	2691551	g13176	i0	83.1	1.9840637450199201	83	14	99.2	0	3	251	3	85	MCL4192204.1 sulfite exporter TauE/SafE family protein [Thermoguttaceae bacterium]	diamond	498	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
30541403	30541403	PRJNA1086823_P_NODE_16633_length_246_cov_0.901734_g16516_i0	PRJNA1086823	16633	246	0.901734	2.21826564	Thermogemmata fonticola	2755323	Bacteria	Bacteria	83.2	1.35e-17	NR	WP_194537071.1	2755323	g16516	i0	48.1	2.74390243902439	77	39	93.9	1	236	6	113	188	WP_194537071.1 MerC domain-containing protein [Thermogemmata fonticola]	diamond	675	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Thermogemmata	Thermogemmata fonticola
30690769	30690769	PRJNA1086823_P_NODE_9653_length_276_cov_1.226601_g9536_i0	PRJNA1086823	9653	276	1.226601	3.38541876	Bacteria	2	Bacteria	Bacteria	105	4.02e-25	NR	MBM4075639.1	2026780	g9536	i0	57	2.8695652173913	86	37	93.5	0	262	5	142	227	MBM4075639.1 UV DNA damage repair endonuclease UvsE [Planctomycetota bacterium]	diamond	792	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30794112	30794112	PRJNA1086823_P_NODE_16354_length_246_cov_0.901734_g16237_i0	PRJNA1086823	16354	246	0.901734	2.21826564	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	134	4.0399999999999996e-38	NR	MFA6045090.1	2052180	g16237	i0	97.2	0.878048780487805	72	2	87.8	0	2	217	75	146	MFA6045090.1 Hsp20/alpha crystallin family protein [Phycisphaerales bacterium]	diamond	216	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31078717	31078717	PRJNA1086823_P_NODE_18455_length_243_cov_0.917647_g18338_i0	PRJNA1086823	18455	243	0.917647	2.22988221	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	147	2.75e-41	NR	MEJ7595694.1	2026779	g18338	i0	88.8	0.987654320987654	80	9	98.8	0	241	2	233	312	MEJ7595694.1 NAD-dependent epimerase/dehydratase family protein [Planctomycetaceae bacterium]	diamond	240	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31141370	31141370	PRJNA1086823_P_NODE_12995_length_252_cov_0.871508_g12878_i0	PRJNA1086823	12995	252	0.871508	2.19620016	Chthoniobacter sp.	2510640	Bacteria	Bacteria	68.6	3.13e-11	NR	MCE9608906.1	2510640	g12878	i0	55.6	0.75	63	28	75	0	1	189	274	336	MCE9608906.1 glycosyltransferase family 4 protein [Chthoniobacter sp.]	diamond	189	68.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
31227820	31227820	PRJNA1086823_P_NODE_8915_length_283_cov_1.619048_g8798_i0	PRJNA1086823	8915	283	1.619048	4.58190584	Pseudomonadati	3379134	Bacteria	Bacteria	120	4.39e-30	NR	MBL9139086.1	2026801	g8798	i0	65.6	1.97173144876325	93	32	98.6	0	3	281	185	277	MBL9139086.1 DUF4062 domain-containing protein [Verrucomicrobiales bacterium]	diamond	558	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31236438	31236438	PRJNA1086823_P_NODE_10955_length_263_cov_1.431579_g10838_i0	PRJNA1086823	10955	263	1.431579	3.76505277	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	115	2.27e-29	NR	MBL0870120.1	2052180	g10838	i0	58.6	0.992395437262357	87	36	99.2	0	263	3	115	201	MBL0870120.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Phycisphaerales bacterium]	diamond	261	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31236448	31236448	PRJNA1086823_P_NODE_19295_length_242_cov_0.923077_g19178_i0	PRJNA1086823	19295	242	0.923077	2.23384634	Pirellula sp.	117	Bacteria	Bacteria	93.6	5.7500000000000005e-21	NR	MBA4105616.1	117	g19178	i0	60	1.97107438016529	80	31	99.2	1	241	2	84	162	MBA4105616.1 DUF1738 domain-containing protein [Pirellula sp.]	diamond	477	93.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
31299793	31299793	PRJNA1086823_P_NODE_15195_length_248_cov_0.891429_g15078_i0	PRJNA1086823	15195	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	115	1.7199999999999995e-31	NR	HXX93293.1	2026780	g15078	i0	69.7	2.90322580645161	76	23	91.9	0	228	1	1	76	HXX93293.1 NPCBM/NEW2 domain-containing protein [Planctomycetota bacterium]	diamond	720	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31331390	31331390	PRJNA1086823_P_NODE_19236_length_242_cov_0.923077_g19119_i0	PRJNA1086823	19236	242	0.923077	2.23384634	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	55.8	9.07e-7	NR	MCC7374768.1	2026801	g19119	i0	41.3	2.82644628099174	80	43	99.2	2	3	242	1635	1710	MCC7374768.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	684	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31426301	31426301	PRJNA1086823_P_NODE_14316_length_250_cov_0.881356_g14199_i0	PRJNA1086823	14316	250	0.881356	2.20339	Phycisphaeraceae bacterium JB051	3342864	Bacteria	Bacteria	43.1	0.0288	NR	MFG0247834.1	3342864	g14199	i0	38.5	0.624	52	32	62.4	0	43	198	174	225	MFG0247834.1 major capsid protein [Phycisphaeraceae bacterium JB051]	diamond	156	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium JB051
31426303	31426303	PRJNA1086823_P_NODE_16156_length_247_cov_0.896552_g16039_i0	PRJNA1086823	16156	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.6	8.48e-15	NR	MFM7118152.1	2026780	g16039	i0	50.6	1.96761133603239	81	40	98.4	0	3	245	279	359	MFM7118152.1 hypothetical protein [Planctomycetota bacterium]	diamond	486	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31426316	31426316	PRJNA1086823_P_NODE_7536_length_300_cov_1.700441_g7419_i0	PRJNA1086823	7536	300	1.700441	5.101323	Phycisphaerales bacterium JB040	3342850	Bacteria	Bacteria	127	1.9099999999999998e-31	NR	MFG0306061.1	3342850	g7419	i0	63.5	3.91	96	35	96	0	13	300	771	866	MFG0306061.1 aminomethyl-transferring glycine dehydrogenase [Phycisphaerales bacterium JB040]	diamond	1173	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium JB040
31489856	31489856	PRJNA1086823_P_NODE_5636_length_339_cov_1.172932_g5519_i0	PRJNA1086823	5636	339	1.172932	3.97623948	Pirellulales bacterium	2715253	Bacteria	Bacteria	98.6	9.33e-23	NR	MEX2093852.1	2715253	g5519	i0	92.7	0.48672566371681403	55	4	48.7	0	339	175	156	210	MEX2093852.1 substrate-binding domain-containing protein [Pirellulales bacterium]	diamond	165	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31521356	31521356	PRJNA1086823_P_NODE_9736_length_275_cov_1.356436_g9619_i0	PRJNA1086823	9736	275	1.356436	3.730199	Pirellulales bacterium	2715253	Bacteria	Bacteria	130	4e-34	NR	MEX2092751.1	2715253	g9619	i0	82.7	0.883636363636364	81	14	88.4	0	30	272	245	325	MEX2092751.1 8-amino-7-oxononanoate synthase [Pirellulales bacterium]	diamond	243	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31584674	31584674	PRJNA1086823_P_NODE_6676_length_316_cov_1.658436_g6559_i0	PRJNA1086823	6676	316	1.658436	5.24065776	Chlamydiota bacterium	2081524	Bacteria	Bacteria	119	4.24e-29	NR	NBO24907.1	2081524	g6559	i0	62	1.74683544303797	92	35	87.3	0	1	276	182	273	NBO24907.1 hypothetical protein [Chlamydiota bacterium]	diamond	552	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32090680	32090680	PRJNA1086823_P_NODE_15418_length_248_cov_0.891429_g15301_i0	PRJNA1086823	15418	248	0.891429	2.21074392	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	144	1.76e-39	NR	MBP8260243.1	2026799	g15301	i0	83.8	1.97177419354839	80	12	95.6	1	12	248	133	212	MBP8260243.1 acetylxylan esterase [Verrucomicrobiota bacterium]	diamond	489	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32217291	32217291	PRJNA1086823_P_NODE_17578_length_244_cov_1.368421_g17461_i0	PRJNA1086823	17578	244	1.368421	3.33894724	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	80.1	2.68e-15	NR	MBO7166920.1	2212473	g17461	i0	53.7	1.00819672131148	82	36	98.4	1	244	5	296	377	MBO7166920.1 type I DNA topoisomerase [Kiritimatiellia bacterium]	diamond	246	80.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32335460	32335460	PRJNA1086823_P_NODE_12299_length_253_cov_0.866667_g12182_i0	PRJNA1086823	12299	253	0.866667	2.19266751	Planctomycetota	203682	Bacteria	Bacteria	84	5.88e-18	NR	HEV8002758.1	2026779	g12182	i0	54.8	5.0395256916996	62	28	73.5	0	2	187	123	184	HEV8002758.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1275	84.3	0.99644128113879	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32344027	32344027	PRJNA1086823_P_NODE_14679_length_249_cov_0.886364_g14562_i0	PRJNA1086823	14679	249	0.886364	2.20704636	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	44.7	0.00842	NR	HEY2413118.1	2699754	g14562	i0	50	1.27710843373494	56	22	60.2	1	2	151	606	661	HEY2413118.1 POTRA domain-containing protein [Pirellulaceae bacterium]	diamond	318	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32619665	32619665	PRJNA1086823_P_NODE_18240_length_243_cov_0.917647_g18123_i0	PRJNA1086823	18240	243	0.917647	2.22988221	Fuerstiella	1936111	Bacteria	Bacteria	132	1.38e-34	NR	MEQ9407969.1	1936112	g18123	i0	81.3	5.92592592592593	80	15	98.8	0	241	2	153	232	MEQ9407969.1 class II fumarate hydratase [Fuerstiella sp.]	diamond	1440	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
32754194	32754194	PRJNA1086823_P_NODE_18740_length_243_cov_0.917647_g18623_i0	PRJNA1086823	18740	243	0.917647	2.22988221	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	51.6	3.02e-6	NR	HMP08456.1	2691534	g18623	i0	43.1	0.716049382716049	58	33	71.6	0	62	235	1	58	HMP08456.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	174	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
32785548	32785548	PRJNA1086823_P_NODE_19060_length_242_cov_0.923077_g18943_i0	PRJNA1086823	19060	242	0.923077	2.23384634	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	96.7	1.0300000000000001e-22	NR	MBX9737728.1	2052180	g18943	i0	59.1	0.818181818181818	66	27	81.8	0	237	40	70	135	MBX9737728.1 NUDIX domain-containing protein [Phycisphaerales bacterium]	diamond	198	96.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;