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

33 rows where analysis = "diamond", bioproject = "PRJNA376117" 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
8052900	8052900	PRJNA376117_P_NODE_13187_length_375_cov_1.374172_g12885_i0	PRJNA376117	13187	375	1.374172	5.153145	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	181	1.03e-51	NR	RYD60109.1	2026800	g12885	i0	74.4	2	125	32	100	0	375	1	137	261	RYD60109.1 MAG: hypothetical protein EOP83_20225 [Verrucomicrobiaceae bacterium]	diamond	750	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
13153646	13153646	PRJNA376117_P_NODE_2871_length_847_cov_2.381137_g2606_i0	PRJNA376117	2871	847	2.381137	20.16823039	root	1	Root_unresolved	Root_unresolved	351	7.62e-111	NR	MFC1809264.1	2035772	g2606	i0	61.9	12.9492325855962	281	104	99.5	2	1	843	498	775	MFC1809264.1 pyruvate, phosphate dikinase [Candidatus Omnitrophota bacterium]	diamond	10968	352	0.997159090909091	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
15702877	15702877	PRJNA376117_P_NODE_5913_length_555_cov_1.724066_g5614_i0	PRJNA376117	5913	555	1.724066	9.5685663	Bacteria	2	Bacteria	Bacteria	194	9.949999999999999e-54	NR	OQB82108.1	1852903	g5614	i0	78.8	10.5081081081081	113	24	61.1	0	550	212	823	935	OQB82108.1 MAG: Pyruvate, phosphate dikinase [Planctomycetes bacterium ADurb.Bin126]	diamond	5832	194	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium ADurb.Bin126
26870837	26870837	PRJNA376117_P_NODE_28101_length_272_cov_1.140704_g27799_i0	PRJNA376117	28101	272	1.140704	3.10271488	Bacteria	2	Bacteria	Bacteria	45.4	0.00569	NR	MDP4643832.1	2026772	g27799	i0	39.7	3.19852941176471	58	35	64	0	233	60	2	59	MDP4643832.1 glycosyltransferase [Opitutales bacterium]	diamond	870	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27074859	27074859	PRJNA376117_P_NODE_29162_length_268_cov_1.471795_g28860_i0	PRJNA376117	29162	268	1.471795	3.9444106	Candidatus Neptunochlamydia vexilliferae	1651774	Bacteria	Bacteria	57	4.36e-7	NR	WP_194846953.1	1651774	g28860	i0	40.7	0.66044776119403	59	35	66	0	48	224	244	302	WP_194846953.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Candidatus Neptunochlamydia vexilliferae]	diamond	177	57	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
27264622	27264622	PRJNA376117_P_NODE_42123_length_243_cov_0.905882_g41821_i0	PRJNA376117	42123	243	0.905882	2.20129326	uncultured Phycisphaerae bacterium	904963	Bacteria	Bacteria	43.9	0.0129	NR	CAA9396067.1	904963	g41821	i0	39.4	0.814814814814815	66	37	81.5	1	38	235	140	202	CAA9396067.1 MAG: 5,10-methylenetetrahydrofolate reductase, partial [uncultured Phycisphaerae bacterium]	diamond	198	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				uncultured Phycisphaerae bacterium
27454320	27454320	PRJNA376117_P_NODE_31963_length_257_cov_2.500000_g31661_i0	PRJNA376117	31963	257	2.5	6.425	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	1.35e-6	NR	RKY17898.1	2026780	g31661	i0	52.1	7.63424124513619	48	23	56	0	1	144	279	326	RKY17898.1 MAG: hypothetical protein DRP63_02935 [Planctomycetota bacterium]	diamond	1962	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27597672	27597672	PRJNA376117_P_NODE_37684_length_247_cov_2.465517_g37382_i0	PRJNA376117	37684	247	2.465517	6.08982699	Thalassoglobus	2795865	Bacteria	Bacteria	44.3	0.0111	NR	WP_146512551.1	1938619	g37382	i0	35.7	2.47773279352227	70	35	77.7	2	2	193	85	150	WP_146512551.1 right-handed parallel beta-helix repeat-containing protein [Thalassoglobus neptunius]	diamond	612	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus neptunius
27896032	27896032	PRJNA376117_P_NODE_18705_length_319_cov_2.727642_g18403_i0	PRJNA376117	18705	319	2.727642	8.70117798	Planctomycetota bacterium	2026780	Bacteria	Bacteria	90.5	1.61e-18	NR	MSR63205.1	2026780	g18403	i0	44.5	1.03448275862069	110	50	98.7	3	316	2	320	423	MSR63205.1 HYR domain-containing protein [Planctomycetota bacterium]	diamond	330	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28117042	28117042	PRJNA376117_P_NODE_27985_length_272_cov_1.542714_g27683_i0	PRJNA376117	27985	272	1.542714	4.19618208	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	58.9	1.07e-7	NR	HUA62969.1	2499141	g27683	i0	43.6	0.860294117647059	78	37	86	2	255	22	773	843	HUA62969.1 family 78 glycoside hydrolase catalytic domain [Verrucomicrobiia bacterium]	diamond	234	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28464611	28464611	PRJNA376117_P_NODE_17986_length_326_cov_1.059289_g17684_i0	PRJNA376117	17986	326	1.059289	3.4532821399999998	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	45.8	0.00838	NR	MAD20413.1	2026779	g17684	i0	45.9	0.957055214723926	37	20	34	0	208	98	1521	1557	MAD20413.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	312	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28622477	28622477	PRJNA376117_P_NODE_17787_length_328_cov_0.905882_g17485_i0	PRJNA376117	17787	328	0.905882	2.97129296	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	65.5	4.71e-10	NR	RYD62543.1	2026800	g17485	i0	61.4	0.402439024390244	44	17	40.2	0	194	325	1	44	RYD62543.1 MAG: hypothetical protein EOP83_14325 [Verrucomicrobiaceae bacterium]	diamond	132	65.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28653957	28653957	PRJNA376117_P_NODE_44907_length_236_cov_3.141104_g44605_i0	PRJNA376117	44907	236	3.141104	7.41300544	Planctomyces sp.	37635	Bacteria	Bacteria	117	1.07e-29	NR	MBX3444802.1	37635	g44605	i0	68	2.89830508474576	75	24	95.3	0	229	5	59	133	MBX3444802.1 alkaline phosphatase family protein [Planctomyces sp.]	diamond	684	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28811477	28811477	PRJNA376117_P_NODE_36748_length_248_cov_1.697143_g36446_i0	PRJNA376117	36748	248	1.697143	4.20891464	Planctomycetes bacterium RBG_13_6	2026780	Bacteria	Bacteria	60.1	3.09e-8	NR	OHB64874.1	1801963	g36446	i0	50	2.09274193548387	62	31	75	0	244	59	353	414	OHB64874.1 MAG: hypothetical protein A2Y76_13230, partial [Planctomycetes bacterium RBG_13_60_9]	diamond	519	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RBG_13_60_9
28860346	28860346	PRJNA376117_P_NODE_23908_length_286_cov_1.446009_g23606_i0	PRJNA376117	23908	286	1.446009	4.13558574	Pseudomonadati	3379134	Bacteria	Bacteria	70.1	1.59e-11	NR	HLX60662.1	2026780	g23606	i0	47.6	2.73776223776224	84	41	88.1	2	32	283	2227	2307	HLX60662.1 Ig-like domain-containing protein [Planctomycetota bacterium]	diamond	783	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28906308	28906308	PRJNA376117_P_NODE_30708_length_262_cov_1.629630_g30406_i0	PRJNA376117	30708	262	1.62963	4.2696306	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	131	7e-36	NR	HSV13712.1	2876886	g30406	i0	71.8	0.973282442748092	85	24	97.3	0	2	256	162	246	HSV13712.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	255	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29033028	29033028	PRJNA376117_P_NODE_25528_length_281_cov_1.110577_g25226_i0	PRJNA376117	25528	281	1.110577	3.12072137	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	129	2.24e-32	NR	NUQ47707.1	2026778	g25226	i0	61.3	4.9644128113879	93	36	99.3	0	280	2	228	320	NUQ47707.1 aminomethyl-transferring glycine dehydrogenase [Phycisphaerae bacterium]	diamond	1395	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29302492	29302492	PRJNA376117_P_NODE_22889_length_290_cov_1.165899_g22587_i0	PRJNA376117	22889	290	1.165899	3.3811071	Pseudomonadati	3379134	Bacteria	Bacteria	114	3.06e-27	NR	MBT3200446.1	2052180	g22587	i0	56.8	3.96206896551724	95	41	98.3	0	6	290	29	123	MBT3200446.1 L-glutamate gamma-semialdehyde dehydrogenase [Phycisphaerales bacterium]	diamond	1149	115	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29474557	29474557	PRJNA376117_P_NODE_27630_length_273_cov_2.185000_g27328_i0	PRJNA376117	27630	273	2.185	5.96505	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.1	6.49e-10	NR	MFH1422031.1	2026780	g27328	i0	54.9	1.35164835164835	51	23	56	0	159	7	296	346	MFH1422031.1 hypothetical protein [Planctomycetota bacterium]	diamond	369	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30123423	30123423	PRJNA376117_P_NODE_30652_length_262_cov_2.021164_g30350_i0	PRJNA376117	30652	262	2.021164	5.29544968	Pseudomonadati	3379134	Bacteria	Bacteria	66.6	2.02e-11	NR	MCA8923957.1	2026780	g30350	i0	47.6	1.45419847328244	63	33	72.1	0	261	73	95	157	MCA8923957.1 SRPBCC family protein [Planctomycetota bacterium]	diamond	381	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30313683	30313683	PRJNA376117_P_NODE_38332_length_247_cov_0.885057_g38030_i0	PRJNA376117	38332	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	129	3.32e-33	NR	HUU94870.1	2026778	g38030	i0	70.7	3.98380566801619	82	24	99.6	0	247	2	289	370	HUU94870.1 NADP-dependent isocitrate dehydrogenase [Phycisphaerae bacterium]	diamond	984	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30471313	30471313	PRJNA376117_P_NODE_27793_length_273_cov_1.195000_g27491_i0	PRJNA376117	27793	273	1.195	3.26235	PVC group	1783257	Bacteria	Bacteria	84	6.02e-17	NR	MDD5155923.1	2035772	g27491	i0	48.9	5.12087912087912	92	44	97.8	1	2	268	155	246	MDD5155923.1 MoxR family ATPase [Candidatus Omnitrophota bacterium]	diamond	1398	84	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30517240	30517240	PRJNA376117_P_NODE_8333_length_464_cov_2.529412_g8031_i0	PRJNA376117	8333	464	2.529412	11.73647168	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	59.3	4.91e-8	NR	MDA0321252.1	2026799	g8031	i0	56.9	0.65948275862069	51	22	33	0	463	311	72	122	MDA0321252.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	306	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30628901	30628901	PRJNA376117_P_NODE_30673_length_262_cov_1.629630_g30371_i0	PRJNA376117	30673	262	1.62963	4.2696306	Parachlamydiaceae	92713	Bacteria	Bacteria	134	2.0499999999999998e-34	NR	WP_059060408.1	389348	g30371	i0	80.2	1.96946564885496	86	17	98.5	0	3	260	567	652	WP_059060408.1 methyl-accepting chemotaxis protein [Candidatus Protochlamydia naegleriophila]	diamond	516	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
30896545	30896545	PRJNA376117_P_NODE_29094_length_268_cov_1.579487_g28792_i0	PRJNA376117	29094	268	1.579487	4.23302516	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	121	1.29e-29	NR	MFN0010758.1	2052180	g28792	i0	70.2	1.83582089552239	84	24	92.9	1	265	17	300	383	MFN0010758.1 alanine--tRNA ligase [Phycisphaerales bacterium]	diamond	492	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31022813	31022813	PRJNA376117_P_NODE_39015_length_246_cov_0.890173_g38713_i0	PRJNA376117	39015	246	0.890173	2.18982558	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.6	6.98e-15	NR	MDY7011604.1	2026780	g38713	i0	45.9	1.03658536585366	85	41	97.6	1	3	242	225	309	MDY7011604.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	255	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31387771	31387771	PRJNA376117_P_NODE_29036_length_268_cov_2.087179_g28734_i0	PRJNA376117	29036	268	2.087179	5.59363972	Bacteria	2	Bacteria	Bacteria	69.3	2.23e-11	NR	MEI6074512.1	2026799	g28734	i0	58.5	2.21641791044776	53	22	59.3	0	267	109	63	115	MEI6074512.1 kelch repeat-containing protein [Verrucomicrobiota bacterium]	diamond	594	69.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31609023	31609023	PRJNA376117_P_NODE_34816_length_250_cov_0.870056_g34514_i0	PRJNA376117	34816	250	0.870056	2.17514	Candidatus Protochlamydia	282132	Bacteria	Bacteria	89.7	1.2e-18	NR	WP_226996109.1	1785087	g34514	i0	68.1	6.144	72	22	85.2	1	250	38	350	421	WP_226996109.1 ribonuclease R [Candidatus Protochlamydia sp. W-9]	diamond	1536	89.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
31908185	31908185	PRJNA376117_P_NODE_37717_length_247_cov_1.896552_g37415_i0	PRJNA376117	37717	247	1.896552	4.68448344	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	151	1.38e-40	NR	MCL4192849.1	2691551	g37415	i0	98.8	0.995951417004049	82	1	99.6	0	2	247	329	410	MCL4192849.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	246	151	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
32129884	32129884	PRJNA376117_P_NODE_39378_length_246_cov_0.890173_g39076_i0	PRJNA376117	39378	246	0.890173	2.18982558	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	53.1	1.32e-6	NR	RYD61498.1	2026800	g39076	i0	55.6	0.548780487804878	45	20	54.9	0	23	157	63	107	RYD61498.1 MAG: hypothetical protein EOP83_16875, partial [Verrucomicrobiaceae bacterium]	diamond	135	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32256618	32256618	PRJNA376117_P_NODE_29058_length_268_cov_1.815385_g28756_i0	PRJNA376117	29058	268	1.815385	4.8652318	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	126	1.01e-31	NR	RYD60109.1	2026800	g28756	i0	76.5	1.77985074626866	81	19	90.7	0	267	25	5	85	RYD60109.1 MAG: hypothetical protein EOP83_20225 [Verrucomicrobiaceae bacterium]	diamond	477	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32400073	32400073	PRJNA376117_P_NODE_41699_length_244_cov_0.894737_g41397_i0	PRJNA376117	41699	244	0.894737	2.18315828	Pseudomonadati	3379134	Bacteria	Bacteria	122	6.19e-34	NR	MFP4542229.1	2026772	g41397	i0	73.8	2.95081967213115	80	21	98.4	0	3	242	17	96	MFP4542229.1 VTT domain-containing protein [Opitutales bacterium]	diamond	720	123	0.991869918699187	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
32792770	32792770	PRJNA376117_P_NODE_18400_length_322_cov_1.236948_g18098_i0	PRJNA376117	18400	322	1.236948	3.98297256	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.9	3.67e-11	NR	MBU6414059.1	2026780	g18098	i0	48.8	0.801242236024845	86	40	79.2	3	255	1	128	210	MBU6414059.1 choice-of-anchor A family protein [Planctomycetota bacterium]	diamond	258	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;