metadata: contig_metadata: 26 rows where bioproject = "PRJNA591127", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA591127", 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
565133	565133	PRJNA591127_P_NODE_27561_length_156_cov_1.260504_g27392_i0	PRJNA591127	27561	156	1.260504	1.96638624	Bremerella volcania	2527984	Bacteria	Bacteria	206	9.32e-49	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g27392	i0	90.385	200.307692307692	156	15	100	0	1	156	2674071	2674226	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	31248	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
565195	565195	PRJNA591127_P_NODE_6041_length_299_cov_1.958015_g5873_i0	PRJNA591127	6041	299	1.958015	5.85446485	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	351	2.45e-92	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g5873	i0	88.04	92.8461538461538	301	31	100	5	1	299	5936460	5936163	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	27761	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8218164	8218164	PRJNA591127_P_NODE_11007_length_222_cov_1.481081_g10839_i0	PRJNA591127	11007	222	1.481081	3.28799982	planctomycete str. 139	149588	Bacteria	Bacteria	348	2.2400000000000002e-91	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g10839	i0	95.067	97.527027027027	223	7	100	4	1	222	1354	1135	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	21651	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
9493487	9493487	PRJNA591127_P_NODE_26068_length_163_cov_0.992063_g25899_i0	PRJNA591127	26068	163	0.992063	1.61706269	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g25899	i0	96.933	6.86503067484663	163	5	100	0	1	163	266287	266449	Tautonia plasticadhaerens strain ElP chromosome	blastn	1119	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
10067195	10067195	PRJNA591127_P_NODE_10268_length_230_cov_1.896373_g10100_i0	PRJNA591127	10268	230	1.896373	4.3616579	Planctomycetaceae	126	Bacteria	Bacteria	233	6.83e-57	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g10100	i0	85.652	88.6	230	23	100	4	1	230	3082096	3082315	Stratiformator vulcanicus strain Pan189 chromosome	blastn	20378	235	0.991489361702128	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
15867765	15867765	PRJNA591127_P_NODE_24773_length_170_cov_1.165414_g24604_i0	PRJNA591127	24773	170	1.165414	1.9812038	planctomycete str. 139	149588	Bacteria	Bacteria	228	2.2e-55	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g24604	i0	98.45	42.9588235294118	129	2	76	0	42	170	1558	1686	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	7303	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
17142724	17142724	PRJNA591127_P_NODE_23294_length_179_cov_2.260563_g23125_i0	PRJNA591127	23294	179	2.260563	4.04640777	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	230	6.529999999999999e-56	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g23125	i0	94.079	87.6256983240224	152	8	85	1	1	152	5086845	5086695	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	15685	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
18416938	18416938	PRJNA591127_P_NODE_2575_length_440_cov_6.570720_g2409_i0	PRJNA591127	2575	440	6.57072	28.911168	Planctomicrobium piriforme	1576369	Bacteria	Bacteria	665	0	NTclustered	gi\|2363081066\|ref\|NR_178776.1\|	1576369	g2409	i0	94.091	101.193181818182	440	22	99	4	1	439	514	950	Planctomicrobium piriforme strain P3 16S ribosomal RNA, partial sequence	blastn	44525	665	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomicrobium	Planctomicrobium piriforme
18417011	18417011	PRJNA591127_P_NODE_3395_length_389_cov_5.829545_g3227_i0	PRJNA591127	3395	389	5.829545	22.67693005	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	641	1.7299999999999995e-179	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g3227	i0	96.401	395.388174807198	389	14	100	0	1	389	265894	266282	Tautonia plasticadhaerens strain ElP chromosome	blastn	153806	641	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
18990350	18990350	PRJNA591127_P_NODE_9915_length_234_cov_0.913706_g9747_i0	PRJNA591127	9915	234	0.913706	2.13807204	Pirellula	123	Bacteria	Bacteria	366	6.59e-97	NTclustered	gi\|914868\|emb\|X81942.1\|	117	g9747	i0	94.872	98.2692307692308	234	12	100	0	1	234	615	382	Pirellula sp. partial 16S rRNA gene (Schlesner 302)	blastn	22995	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
19691581	19691581	PRJNA591127_P_NODE_7716_length_265_cov_2.907895_g7548_i0	PRJNA591127	7716	265	2.907895	7.70592175	Aureliella sp.	2795609	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g7548	i0	96.97	0.124528301886792	33	1	12	0	118	150	3201881	3201913	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
20265265	20265265	PRJNA591127_P_NODE_21256_length_193_cov_3.141026_g21087_i0	PRJNA591127	21256	193	3.141026	6.06218018	Pirellulales	2691354	Bacteria	Bacteria	250	5.499999999999999e-62	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g21087	i0	95.541	130.253886010363	157	5	92	2	35	191	3121589	3121435	Planctomycetes bacterium TBK1r chromosome	blastn	25139	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
20967156	20967156	PRJNA591127_P_NODE_13377_length_201_cov_1.737805_g13208_i0	PRJNA591127	13377	201	1.737805	3.49298805	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	287	4.399999999999999e-73	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g13208	i0	92.537	353.452736318408	201	14	100	1	1	201	3083018	3082819	Stratiformator vulcanicus strain Pan189 chromosome	blastn	71044	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
20967185	20967185	PRJNA591127_P_NODE_1597_length_536_cov_3.777555_g1445_i0	PRJNA591127	1597	536	3.777555	20.2476948	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	747	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g1445	i0	92.571	139.585820895522	525	32	97	7	1	522	1599947	1599427	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	74818	747	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
20967248	20967248	PRJNA591127_P_NODE_22197_length_187_cov_0.960000_g22028_i0	PRJNA591127	22197	187	0.96	1.7952	Humisphaera borealis	2807512	Bacteria	Bacteria	307	3.09e-79	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g22028	i0	96.257	21.3850267379679	187	7	100	0	1	187	5063245	5063059	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	3999	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20967258	20967258	PRJNA591127_P_NODE_23297_length_179_cov_2.070423_g23128_i0	PRJNA591127	23297	179	2.070423	3.70605717	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	231	1.8100000000000002e-56	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g23128	i0	90.449	16.0558659217877	178	13	99	4	2	179	1867636	1867809	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	2874	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22242180	22242180	PRJNA591127_P_NODE_22438_length_185_cov_1.750000_g22269_i0	PRJNA591127	22438	185	1.75	3.2375	Bremerella volcania	2527984	Bacteria	Bacteria	267	5.18e-67	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g22269	i0	92.553	88.8162162162162	188	10	100	4	1	185	2673237	2673051	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	16431	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
23517455	23517455	PRJNA591127_P_NODE_25119_length_168_cov_1.190840_g24950_i0	PRJNA591127	25119	168	1.19084	2.0006112	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	244	2.1699999999999999e-60	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g24950	i0	92.857	11.0714285714286	168	12	100	0	1	168	5086012	5085845	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	1860	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
24090717	24090717	PRJNA591127_P_NODE_24779_length_170_cov_0.879699_g24610_i0	PRJNA591127	24779	170	0.879699	1.4954883	Blastopirellula	265487	Bacteria	Bacteria	150	4.9e-32	NTclustered	gi\|12583963\|gb\|AF245367.1\|AF245367	314230	g24610	i0	82.759	109.370588235294	174	25	100	4	1	170	2063	2235	Pirellula marina 23S ribosomal RNA gene, partial sequence	blastn	18593	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
24791272	24791272	PRJNA591127_P_NODE_26060_length_163_cov_1.198413_g25891_i0	PRJNA591127	26060	163	1.198413	1.95341319	Humisphaera borealis	2807512	Bacteria	Bacteria	230	5.8499999999999985e-56	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g25891	i0	92.073	91.1104294478528	164	12	100	1	1	163	5064812	5064975	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	14851	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
25365074	25365074	PRJNA591127_P_NODE_24780_length_170_cov_0.879699_g24611_i0	PRJNA591127	24780	170	0.879699	1.4954883	Gemmata	113	Bacteria	Bacteria	303	3.55e-78	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g24611	i0	98.824	128.658823529412	170	2	100	0	1	170	1819	1988	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	21872	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
27585188	27585188	PRJNA591127_P_NODE_14724_length_197_cov_3.900000_g14555_i0	PRJNA591127	14724	197	3.9	7.683	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	3.42e-4	NR	HZE98642.1	2026780	g14555	i0	79.2	0.730964467005076	24	5	36.5	0	195	124	128	151	HZE98642.1 rhomboid family intramembrane serine protease [Planctomycetota bacterium]	diamond	144	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31610209	31610209	PRJNA591127_P_NODE_16956_length_197_cov_2.637500_g16787_i0	PRJNA591127	16956	197	2.6375	5.195875	Pseudomonadati	3379134	Bacteria	Bacteria	47	2.34e-4	NR	MBL8881360.1	2052180	g16787	i0	100	0.761421319796954	25	0	38.1	0	123	197	74	98	MBL8881360.1 capsule biosynthesis protein [Phycisphaerales bacterium]	diamond	150	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32324670	32324670	PRJNA591127_P_NODE_26039_length_163_cov_1.349206_g25870_i0	PRJNA591127	26039	163	1.349206	2.1992057800000002	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.6	0.0328	NR	MDH4240107.1	2026778	g25870	i0	39.2	0.938650306748466	51	30	92	1	11	160	181	231	MDH4240107.1 serine/threonine protein kinase [Phycisphaerae bacterium]	diamond	153	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32338067	32338067	PRJNA591127_P_NODE_31899_length_150_cov_3.053097_g31730_i0	PRJNA591127	31899	150	3.053097	4.5796455	Bacteria	2	Bacteria	Bacteria	43.9	0.00382	NR	MBX3394104.1	2026778	g31730	i0	68	4.62	25	8	50	0	2	76	226	250	MBX3394104.1 LPS export ABC transporter ATP-binding protein [Phycisphaerae bacterium]	diamond	693	44.3	0.99097065462754	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32482688	32482688	PRJNA591127_P_NODE_31719_length_150_cov_3.424779_g31550_i0	PRJNA591127	31719	150	3.424779	5.1371685	Planctomycetia bacterium	2052181	Bacteria	Bacteria	94.4	6.740000000000001e-21	NR	MDA8376149.1	2052181	g31550	i0	79.6	2.94	49	10	98	0	2	148	197	245	MDA8376149.1 SMP-30/gluconolactonase/LRE family protein [Planctomycetia bacterium]	diamond	441	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;