metadata: contig_metadata: 28 rows where bioproject = "PRJNA1215813", tax_clade = "PVC group" and tax

28 rows where bioproject = "PRJNA1215813", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
331652	331652	PRJNA1215813_P_NODE_3301_length_418_cov_1.930435_g3221_i0	PRJNA1215813	3301	418	1.930435	8.0692183	Pseudomonadati	3379134	Bacteria	Bacteria	224	1.2e-68	NR	MCH7591671.1	2026780	g3221	i0	73.4	27.6674641148325	139	37	99.8	0	418	2	90	228	MCH7591671.1 aldehyde dehydrogenase family protein [Planctomycetota bacterium]	diamond	11565	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
2882729	2882729	PRJNA1215813_P_NODE_6403_length_309_cov_1.322034_g6323_i0	PRJNA1215813	6403	309	1.322034	4.08508506	Fuerstiella sp.	1936112	Bacteria	Bacteria	138	2.95e-36	NR	MEP3481059.1	1936112	g6323	i0	62.7	4.99029126213592	102	38	99	0	307	2	225	326	MEP3481059.1 aldehyde dehydrogenase family protein [Fuerstiella sp.]	diamond	1542	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
3596339	3596339	PRJNA1215813_P_NODE_7243_length_291_cov_1.073394_g7163_i0	PRJNA1215813	7243	291	1.073394	3.12357654	Bacteria	2	Bacteria	Bacteria	122	9.38e-34	NR	MBM4098314.1	2026780	g7163	i0	91.8	7.52577319587629	73	6	75.3	0	289	71	50	122	MBM4098314.1 phosphoglycerate kinase [Planctomycetota bacterium]	diamond	2190	123	0.991869918699187	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
4873957	4873957	PRJNA1215813_P_NODE_8084_length_276_cov_1.192118_g8004_i0	PRJNA1215813	8084	276	1.192118	3.29024568	Planctomycetota bacterium	2026780	Bacteria	Bacteria	125	6.53e-31	NR	MEL6328803.1	2026780	g8004	i0	73.5	0.902173913043478	83	19	90.2	1	249	1	14	93	MEL6328803.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	249	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
22008490	22008490	PRJNA1215813_P_NODE_618_length_876_cov_2.768369_g561_i0	PRJNA1215813	618	876	2.768369	24.25091244	Pseudomonadati	3379134	Bacteria	Bacteria	223	1.47e-65	NR	HVK15574.1	1914235	g561	i0	58.4	23.8801369863014	178	73	60.6	1	872	342	316	493	HVK15574.1 aldehyde dehydrogenase family protein [Fimbriiglobus sp.]	diamond	20919	224	0.995535714285714	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
26977784	26977784	PRJNA1215813_P_NODE_2422_length_479_cov_1.509852_g2342_i0	PRJNA1215813	2422	479	1.509852	7.23219108	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	186	1.88e-56	NR	MBY0307717.1	2052180	g2342	i0	59.2	0.889352818371608	142	57	88.3	1	478	56	86	227	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	426	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27388945	27388945	PRJNA1215813_P_NODE_1683_length_573_cov_1.856000_g1605_i0	PRJNA1215813	1683	573	1.856	10.63488	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	148	6.68e-41	NR	MFG0274066.1	2052180	g1605	i0	44.2	0.900523560209424	172	87	85.9	3	494	3	20	190	MFG0274066.1 pyridoxamine 5'-phosphate oxidase [Phycisphaerales bacterium]	diamond	516	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27704875	27704875	PRJNA1215813_P_NODE_6824_length_300_cov_1.030837_g6744_i0	PRJNA1215813	6824	300	1.030837	3.092511	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.6	0.003	NR	REK11914.1	2026780	g6744	i0	41.8	0.67	67	35	63	2	46	234	228	294	REK11914.1 MAG: choice-of-anchor A family protein [Planctomycetota bacterium]	diamond	201	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28051787	28051787	PRJNA1215813_P_NODE_10265_length_250_cov_0.881356_g10185_i0	PRJNA1215813	10265	250	0.881356	2.20339	Pirellulales bacterium	2715253	Bacteria	Bacteria	60.1	3.06e-8	NR	MBN1393965.1	2715253	g10185	i0	56	3.336	50	20	60	1	6	155	408	455	MBN1393965.1 PAS domain S-box protein [Pirellulales bacterium]	diamond	834	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28367442	28367442	PRJNA1215813_P_NODE_506_length_939_cov_6.886836_g456_i0	PRJNA1215813	506	939	6.886836	64.66739004	Planctomycetota bacterium	2026780	Bacteria	Bacteria	102	3.53e-20	NR	MEY2612968.1	2026780	g456	i0	32.9	1.94249201277955	258	149	77.6	7	145	873	165	413	MEY2612968.1 Large cysteine-rich periplasmic protein omcB precursor [Planctomycetota bacterium]	diamond	1824	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28557148	28557148	PRJNA1215813_P_NODE_9967_length_251_cov_0.876404_g9887_i0	PRJNA1215813	9967	251	0.876404	2.19977404	Pirellulales bacterium	2715253	Bacteria	Bacteria	46.6	0.00172	NR	HVX60166.1	2715253	g9887	i0	33	1.70916334661355	88	52	96.8	5	7	249	110	197	HVX60166.1 hypothetical protein [Pirellulales bacterium]	diamond	429	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28683481	28683481	PRJNA1215813_P_NODE_1127_length_685_cov_1.169935_g1052_i0	PRJNA1215813	1127	685	1.169935	8.01405475	Phycisphaeraceae bacterium AH-315-B13	2814564	Bacteria	Bacteria	307	1.05e-99	NR	MBN4082610.1	2814564	g1052	i0	65.4	5.96934306569343	228	78	99.4	1	2	682	51	278	MBN4082610.1 aspartate aminotransferase family protein [Phycisphaeraceae bacterium AH-315-B13]	diamond	4089	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium AH-315-B13
28683486	28683486	PRJNA1215813_P_NODE_587_length_894_cov_8.399513_g531_i0	PRJNA1215813	587	894	8.399513	75.09164622	Planctomycetota bacterium	2026780	Bacteria	Bacteria	76.3	2.4e-11	NR	MEI6525793.1	2026780	g531	i0	30.2	3.55704697986577	212	129	68.1	7	840	232	137	338	MEI6525793.1 SdrD B-like domain-containing protein [Planctomycetota bacterium]	diamond	3180	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29062348	29062348	PRJNA1215813_P_NODE_9328_length_253_cov_0.866667_g9248_i0	PRJNA1215813	9328	253	0.866667	2.19266751	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	49.7	1.42e-4	NR	MFO0978387.1	2026779	g9248	i0	51	1.49407114624506	49	21	56.9	2	74	217	99	145	MFO0978387.1 DUF1963 domain-containing protein [Planctomycetaceae bacterium]	diamond	378	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29112650	29112650	PRJNA1215813_P_NODE_9368_length_253_cov_0.866667_g9288_i0	PRJNA1215813	9368	253	0.866667	2.19266751	Bacteria	2	Bacteria	Bacteria	89.7	1.02e-18	NR	MEQ1826730.1	117	g9288	i0	56.2	8.11067193675889	89	28	98.4	3	251	3	92	175	MEQ1826730.1 aldehyde dehydrogenase family protein [Pirellula sp.]	diamond	2052	90.1	0.995560488346282	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29661656	29661656	PRJNA1215813_P_NODE_5810_length_323_cov_0.920000_g5730_i0	PRJNA1215813	5810	323	0.92	2.9716	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.9	5.74e-13	NR	MEM9064039.1	2026780	g5730	i0	45.5	0.81733746130031	88	47	80.8	1	285	25	154	241	MEM9064039.1 NAD-dependent epimerase/dehydratase family protein [Planctomycetota bacterium]	diamond	264	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29914927	29914927	PRJNA1215813_P_NODE_4051_length_379_cov_2.617647_g3971_i0	PRJNA1215813	4051	379	2.617647	9.92088213	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	152	2.92e-42	NR	MFO0782314.1	2052180	g3971	i0	54.8	0.997361477572559	126	56	98.9	1	3	377	1	126	MFO0782314.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium]	diamond	378	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30515020	30515020	PRJNA1215813_P_NODE_213_length_1328_cov_2.201594_g183_i0	PRJNA1215813	213	1328	2.201594	29.23716832	Planctomycetota bacterium	2026780	Bacteria	Bacteria	450	2.4099999999999993e-152	NR	MFT7677738.1	2026780	g183	i0	55.4	8.39683734939759	433	185	97.1	7	34	1323	16	443	MFT7677738.1 cystathionine beta-synthase [Planctomycetota bacterium]	diamond	11151	450	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30926000	30926000	PRJNA1215813_P_NODE_534_length_926_cov_3.203986_g484_i0	PRJNA1215813	534	926	3.203986	29.66891036	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	109	2.36e-22	NR	GJM26624.1	2026778	g484	i0	33.3	1.03995680345572	321	186	97.2	12	924	25	1431	1744	GJM26624.1 MAG: hypothetical protein DHS20C16_30390 [Phycisphaerae bacterium]	diamond	963	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31589867	31589867	PRJNA1215813_P_NODE_9956_length_251_cov_0.876404_g9876_i0	PRJNA1215813	9956	251	0.876404	2.19977404	Planctomycetota bacterium	2026780	Bacteria	Bacteria	70.1	9.82e-12	NR	MDE0737763.1	2026780	g9876	i0	54.4	4.20717131474104	57	26	68.1	0	8	178	1358	1414	MDE0737763.1 MG2 domain-containing protein [Planctomycetota bacterium]	diamond	1056	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31608509	31608509	PRJNA1215813_P_NODE_7716_length_283_cov_1.114286_g7636_i0	PRJNA1215813	7716	283	1.114286	3.15342938	Pseudomonadati	3379134	Bacteria	Bacteria	47.4	0.00139	NR	MBM4026607.1	2026780	g7636	i0	47.8	2.28975265017668	46	24	48.8	0	143	6	355	400	MBM4026607.1 hypothetical protein [Planctomycetota bacterium]	diamond	648	47.8	0.99163179916318	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31747755	31747755	PRJNA1215813_P_NODE_8157_length_275_cov_1.044554_g8077_i0	PRJNA1215813	8157	275	1.044554	2.8725235	Planctomycetota bacterium	2026780	Bacteria	Bacteria	93.2	4.67e-20	NR	MDY7011604.1	2026780	g8077	i0	46.8	2.05090909090909	94	46	99.3	2	3	275	219	311	MDY7011604.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	564	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31842561	31842561	PRJNA1215813_P_NODE_5717_length_325_cov_1.857143_g5637_i0	PRJNA1215813	5717	325	1.857143	6.03571475	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	163	6.729999999999999e-46	NR	MEE8170978.1	2026778	g5637	i0	69.2	4.93846153846154	107	33	98.8	0	321	1	288	394	MEE8170978.1 aldehyde dehydrogenase family protein [Phycisphaerae bacterium]	diamond	1605	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31893129	31893129	PRJNA1215813_P_NODE_477_length_969_cov_4.603795_g427_i0	PRJNA1215813	477	969	4.603795	44.61077355	Pirellula	123	Bacteria	Bacteria	74.3	1.49e-10	NR	MCE2753085.1	117	g427	i0	30.6	2.54489164086687	209	126	61.6	8	900	304	103	302	MCE2753085.1 hypothetical protein [Pirellula sp.]	diamond	2466	74.7	0.994645247657296	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32286019	32286019	PRJNA1215813_P_NODE_10499_length_249_cov_0.886364_g10419_i0	PRJNA1215813	10499	249	0.886364	2.20704636	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	49.7	1.4e-4	NR	MEP0847119.1	2026778	g10419	i0	45.8	0.710843373493976	59	32	71.1	0	245	69	188	246	MEP0847119.1 serine/threonine protein kinase [Phycisphaerae bacterium]	diamond	177	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32317653	32317653	PRJNA1215813_P_NODE_6299_length_311_cov_1.310924_g6219_i0	PRJNA1215813	6299	311	1.310924	4.07697364	Planctomycetota bacterium	2026780	Bacteria	Bacteria	131	2.7399999999999996e-35	NR	MCH8252428.1	2026780	g6219	i0	56.7	1.98713826366559	104	44	99.4	1	309	1	76	179	MCH8252428.1 polyprenol monophosphomannose synthase [Planctomycetota bacterium]	diamond	618	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32349218	32349218	PRJNA1215813_P_NODE_2019_length_522_cov_2.033408_g1939_i0	PRJNA1215813	2019	522	2.033408	10.61438976	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	105	2.39e-24	NR	MBY0307717.1	2052180	g1939	i0	44.8	0.666666666666667	116	63	66.7	1	170	517	7	121	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	348	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32727935	32727935	PRJNA1215813_P_NODE_7360_length_289_cov_1.254630_g7280_i0	PRJNA1215813	7360	289	1.25463	3.6258807	Blastopirellula sp.	2024826	Bacteria	Bacteria	75.1	2.74e-13	NR	PHS07368.1	2024826	g7280	i0	43.3	2.83391003460208	90	50	92.4	1	269	3	1284	1373	PHS07368.1 MAG: hypothetical protein COA78_13480, partial [Blastopirellula sp.]	diamond	819	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula 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);;