metadata: contig_metadata: 25 rows where bioproject = "PRJNA1108487", tax_clade = "PVC group" and tax

25 rows where bioproject = "PRJNA1108487", 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
213409	213409	PRJNA1108487_P_NODE_3801_length_353_cov_2.150000_g3735_i0	PRJNA1108487	3801	353	2.15	7.5895	Aquisphaera giovannonii	406548	Bacteria	Bacteria	451	2.8200000000000004e-122	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g3735	i0	89.831	70.9348441926346	354	33	100	3	1	353	5179858	5179507	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	25040	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
213442	213442	PRJNA1108487_P_NODE_8981_length_251_cov_0.876404_g8915_i0	PRJNA1108487	8981	251	0.876404	2.19977404	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	92.8	1.02e-19	NR	WP_151970570.1	2596890	g8915	i0	50	5.91633466135458	82	40	96.8	1	250	8	1977	2058	WP_151970570.1 hypothetical protein [Candidatus Uabimicrobium amorphum]	diamond	1485	92.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
213445	213445	PRJNA1108487_P_NODE_9401_length_249_cov_0.886364_g9335_i0	PRJNA1108487	9401	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	149	7.76e-44	NR	MBL9080275.1	2053591	g9335	i0	82.9	12.8433734939759	82	14	98.8	0	2	247	45	126	MBL9080275.1 3-isopropylmalate dehydratase large subunit [Planctomycetales bacterium]	diamond	3198	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
1488111	1488111	PRJNA1108487_P_NODE_5142_length_311_cov_3.277311_g5076_i0	PRJNA1108487	5142	311	3.277311	10.19243721	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	69.4	2.89e-7	NTclustered	gi\|2108248627\|gb\|CP070691.1\|	2052180	g5076	i0	97.5	7.64630225080386	40	1	13	0	202	241	2531826	2531865	MAG: Phycisphaerales bacterium isolate bin621 chromosome	blastn	2378	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6123606	6123606	PRJNA1108487_P_NODE_2465_length_431_cov_2.145251_g2399_i0	PRJNA1108487	2465	431	2.145251	9.24603181	Isosphaeraceae	1763524	Bacteria	Bacteria	676	0	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g2399	i0	97.015	237.668213457077	402	12	93	0	30	431	5179405	5179004	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	102435	680	0.994117647058824	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
12967245	12967245	PRJNA1108487_P_NODE_10291_length_245_cov_1.686047_g10225_i0	PRJNA1108487	10291	245	1.686047	4.13081515	Pseudomonadati	3379134	Bacteria	Bacteria	133	9.57e-35	NR	GDY00561.1	2026778	g10225	i0	75.3	12.8938775510204	81	20	99.2	0	3	245	181	261	GDY00561.1 isocitrate dehydrogenase [NADP] [Phycisphaerae bacterium]	diamond	3159	134	0.992537313432836	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
15516031	15516031	PRJNA1108487_P_NODE_353_length_1020_cov_6.183738_g309_i0	PRJNA1108487	353	1020	6.183738	63.0741276	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	73.1	7.94e-8	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g309	i0	74.123	0.284313725490196	228	35	21	17	620	829	2220386	2220165	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	290	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20614552	20614552	PRJNA1108487_P_NODE_3097_length_387_cov_0.993631_g3031_i0	PRJNA1108487	3097	387	0.993631	3.84535197	Pirellulales bacterium	2715253	Bacteria	Bacteria	224	1.15e-69	NR	HEX4132619.1	2715253	g3031	i0	84.8	9.55038759689922	125	19	96.9	0	386	12	272	396	HEX4132619.1 NAD-dependent formate dehydrogenase [Pirellulales bacterium]	diamond	3696	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
23972886	23972886	PRJNA1108487_P_NODE_1419_length_562_cov_2.425358_g1354_i0	PRJNA1108487	1419	562	2.425358	13.63051196	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	155	1.26e-41	NR	MBL9123541.1	2026779	g1354	i0	50.3	0.976868327402135	183	80	97.2	6	555	10	238	410	MBL9123541.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	549	155	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27668109	27668109	PRJNA1108487_P_NODE_11284_length_242_cov_0.923077_g11218_i0	PRJNA1108487	11284	242	0.923077	2.23384634	Planctomycetota bacterium	2026780	Bacteria	Bacteria	93.6	4.75e-20	NR	MBM4006057.1	2026780	g11218	i0	57.5	1.07851239669421	87	30	99.2	1	242	3	736	822	MBM4006057.1 aminomethyl-transferring glycine dehydrogenase [Planctomycetota bacterium]	diamond	261	93.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28394109	28394109	PRJNA1108487_P_NODE_906_length_686_cov_1.611746_g844_i0	PRJNA1108487	906	686	1.611746	11.05657756	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.5	0.0106	NR	MBS0196324.1	2026780	g844	i0	34.5	1.34256559766764	168	85	72.2	9	528	34	191	336	MBS0196324.1 proprotein convertase P-domain-containing protein [Planctomycetota bacterium]	diamond	921	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28954026	28954026	PRJNA1108487_P_NODE_2468_length_431_cov_1.687151_g2402_i0	PRJNA1108487	2468	431	1.687151	7.27162081	PVC group	1783257	Bacteria	Bacteria	53.5	4.82e-5	NR	MEI7781446.1	2026780	g2402	i0	43.8	0.897911832946636	64	32	44.5	2	238	429	95	154	MEI7781446.1 YDG domain-containing protein [Planctomycetota bacterium]	diamond	387	53.9	0.992578849721707	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29120607	29120607	PRJNA1108487_P_NODE_5349_length_307_cov_1.076923_g5283_i0	PRJNA1108487	5349	307	1.076923	3.30615361	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	90.5	1.37e-18	NR	GIW89928.1	2699754	g5283	i0	43.9	9.28338762214984	107	54	98.7	2	3	305	369	475	GIW89928.1 MAG: hypothetical protein KatS3mg109_0360 [Pirellulaceae bacterium]	diamond	2850	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29152325	29152325	PRJNA1108487_P_NODE_9929_length_247_cov_0.896552_g9863_i0	PRJNA1108487	9929	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87	3.29e-19	NR	MBL8857988.1	2026780	g9863	i0	47.6	6.72874493927126	82	42	99.6	1	246	1	65	145	MBL8857988.1 cysteine dioxygenase family protein [Planctomycetota bacterium]	diamond	1662	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29246617	29246617	PRJNA1108487_P_NODE_5509_length_303_cov_1.356522_g5443_i0	PRJNA1108487	5509	303	1.356522	4.11026166	Zavarzinella formosa	360055	Bacteria	Bacteria	44.3	0.0209	NR	WP_162136337.1	360055	g5443	i0	30.5	0.811881188118812	82	55	79.2	2	5	244	361	442	WP_162136337.1 TIGR02996 domain-containing protein [Zavarzinella formosa]	diamond	246	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
29553473	29553473	PRJNA1108487_P_NODE_6390_length_284_cov_1.478673_g6324_i0	PRJNA1108487	6390	284	1.478673	4.19943132	Planctomycetia	203683	Bacteria	Bacteria	44.3	0.0171	NR	MDG1872818.1	2005381	g6324	i0	44.1	2.00704225352113	59	30	62.3	1	219	43	464	519	MDG1872818.1 sulfatase [Mariniblastus sp.]	diamond	570	44.7	0.991051454138702	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus sp.
29878313	29878313	PRJNA1108487_P_NODE_2691_length_414_cov_1.601173_g2625_i0	PRJNA1108487	2691	414	1.601173	6.62885622	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	77.8	1.57e-14	NR	NUM35309.1	2517210	g2625	i0	37.6	1.02173913043478	141	77	97.1	5	406	5	49	185	NUM35309.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	423	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
29941528	29941528	PRJNA1108487_P_NODE_7831_length_260_cov_1.459893_g7765_i0	PRJNA1108487	7831	260	1.459893	3.7957218	Planctomycetales bacterium	2053591	Bacteria	Bacteria	43.1	0.0292	NR	MCA9141042.1	2053591	g7765	i0	47.7	0.507692307692308	44	22	50.8	1	139	8	69	111	MCA9141042.1 hypothetical protein [Planctomycetales bacterium]	diamond	132	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30225664	30225664	PRJNA1108487_P_NODE_972_length_663_cov_1.381356_g909_i0	PRJNA1108487	972	663	1.381356	9.15839028	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.8	5.9e-16	NR	MFO0979819.1	2026779	g909	i0	33.3	0.963800904977376	213	112	86.4	8	582	10	670	874	MFO0979819.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	639	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30352632	30352632	PRJNA1108487_P_NODE_10992_length_243_cov_0.917647_g10926_i0	PRJNA1108487	10992	243	0.917647	2.22988221	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	45.8	0.0032	NR	MBX3353741.1	2026777	g10926	i0	39.2	0.975308641975309	79	45	97.5	3	243	7	1135	1210	MBX3353741.1 S8 family serine peptidase [Phycisphaeraceae bacterium]	diamond	237	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
30604766	30604766	PRJNA1108487_P_NODE_6053_length_291_cov_1.188073_g5987_i0	PRJNA1108487	6053	291	1.188073	3.45729243	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	3.08e-9	NR	MEK6674035.1	2026780	g5987	i0	40.5	1.5360824742268	74	44	76.3	0	6	227	104	177	MEK6674035.1 DUF4139 domain-containing protein [Planctomycetota bacterium]	diamond	447	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30699525	30699525	PRJNA1108487_P_NODE_5214_length_310_cov_1.215190_g5148_i0	PRJNA1108487	5214	310	1.21519	3.767089	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	41.2	0.038	NR	HEX5106285.1	2699754	g5148	i0	39.6	0.464516129032258	48	22	46.5	1	3	146	26	66	HEX5106285.1 hypothetical protein [Pirellulaceae bacterium]	diamond	144	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31426542	31426542	PRJNA1108487_P_NODE_8936_length_251_cov_0.876404_g8870_i0	PRJNA1108487	8936	251	0.876404	2.19977404	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	60.1	2.18e-8	NR	HCK55543.1	2026779	g8870	i0	50.9	1.36254980079681	57	27	68.1	1	234	64	151	206	HCK55543.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	342	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31584878	31584878	PRJNA1108487_P_NODE_11096_length_243_cov_0.876471_g11030_i0	PRJNA1108487	11096	243	0.876471	2.12982453	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	76.3	5.12e-14	NR	MCH2149296.1	2052180	g11030	i0	43.8	5.71604938271605	80	45	98.8	0	3	242	281	360	MCH2149296.1 zinc metallochaperone GTPase ZigA [Phycisphaerales bacterium]	diamond	1389	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32880307	32880307	PRJNA1108487_P_NODE_5780_length_297_cov_1.044643_g5714_i0	PRJNA1108487	5780	297	1.044643	3.10258971	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.4	0.00667	NR	HND53097.1	2699754	g5714	i0	34.3	1	99	53	88.9	3	292	29	144	241	HND53097.1 MBL fold metallo-hydrolase [Pirellulaceae bacterium]	diamond	297	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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);;