metadata: contig_metadata: 32 rows where bioproject = "PRJNA597223", tax_clade = "PVC group" and tax

32 rows where bioproject = "PRJNA597223", 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
568781	568781	PRJNA597223_P_NODE_1001_length_1611_cov_13.158629_g384_i1	PRJNA597223	1001	1611	13.158629	211.98551319	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1179	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g384	i1	84.678	548.352576039727	1227	138	75	31	1	1213	1867739	1866549	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	883396	1179	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
569241	569241	PRJNA597223_P_NODE_51981_length_193_cov_2.158228_g50135_i0	PRJNA597223	51981	193	2.158228	4.16538004	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	209	9.33e-50	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g50135	i0	86.364	9.95854922279793	198	19	99	6	2	193	1830301	1830496	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1922	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
569453	569453	PRJNA597223_P_NODE_74361_length_164_cov_3.426357_g72515_i0	PRJNA597223	74361	164	3.426357	5.61922548	Humisphaera borealis	2807512	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g72515	i0	93.293	38.030487804878	164	11	100	0	1	164	5063236	5063073	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	6237	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
1140773	1140773	PRJNA597223_P_NODE_72441_length_167_cov_1.750000_g70595_i0	PRJNA597223	72441	167	1.75	2.9225	Engelhardtia	139931	Bacteria	Bacteria	231	1.68e-56	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g70595	i0	92.073	21.2275449101796	164	13	98	0	1	164	5246224	5246387	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	3545	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
4396971	4396971	PRJNA597223_P_NODE_65964_length_177_cov_2.598592_g64118_i0	PRJNA597223	65964	177	2.598592	4.59950784	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	148	1.85e-31	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g64118	i0	84.416	1.91525423728814	154	20	86	3	26	177	882390	882239	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	339	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4397053	4397053	PRJNA597223_P_NODE_71744_length_168_cov_1.616541_g69898_i0	PRJNA597223	71744	168	1.616541	2.71578888	Paludisphaera borealis	1387353	Bacteria	Bacteria	148	1.75e-31	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g69898	i0	83.537	12.047619047619	164	22	97	3	5	167	122484	122325	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	2024	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
6244214	6244214	PRJNA597223_P_NODE_11125_length_517_cov_1.948133_g9420_i0	PRJNA597223	11125	517	1.948133	10.07184761	Gimesia	1649453	Bacteria	Bacteria	424	9.32e-114	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g9420	i0	82.095	168.959381044487	525	67	97	21	2	501	2663961	2664483	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	87352	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
6947403	6947403	PRJNA597223_P_NODE_46426_length_206_cov_2.046784_g44580_i0	PRJNA597223	46426	206	2.046784	4.21637504	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	270	4.569999999999999e-68	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g44580	i0	90.64	120.572815533981	203	19	99	0	2	204	1832236	1832034	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	24838	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
6947604	6947604	PRJNA597223_P_NODE_66546_length_176_cov_2.468085_g64700_i0	PRJNA597223	66546	176	2.468085	4.3438296	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	235	1.37e-57	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g64700	i0	91.429	131.772727272727	175	10	99	4	3	176	4319781	4319951	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	23192	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8222498	8222498	PRJNA597223_P_NODE_56387_length_188_cov_1.980392_g54541_i0	PRJNA597223	56387	188	1.980392	3.72313696	Phycisphaera sp.	2030824	Bacteria	Bacteria	60.2	9.63e-5	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g54541	i0	89.362	0.25	47	5	25	0	23	69	2541202	2541248	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	47	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
8793664	8793664	PRJNA597223_P_NODE_8807_length_586_cov_4.862069_g7240_i0	PRJNA597223	8807	586	4.862069	28.49172434	Isosphaeraceae	1763524	Bacteria	Bacteria	632	1.6299999999999995e-176	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g7240	i0	89.474	499.928327645051	513	37	86	15	84	586	5179562	5179057	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	292958	632	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
9497270	9497270	PRJNA597223_P_NODE_21048_length_350_cov_2.955556_g19210_i0	PRJNA597223	21048	350	2.955556	10.344446	Gemmata massiliana	1210884	Bacteria	Bacteria	250	1.09e-61	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g19210	i0	80.597	215.382857142857	335	56	95	8	8	340	3634132	3633805	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	75384	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
9497598	9497598	PRJNA597223_P_NODE_48588_length_200_cov_5.327273_g46742_i0	PRJNA597223	48588	200	5.327273	10.654546	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	296	7.269999999999998e-76	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g46742	i0	93.878	345.76	196	12	98	0	5	200	1868295	1868490	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	69152	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10069466	10069466	PRJNA597223_P_NODE_9848_length_552_cov_22.017408_g567_i1	PRJNA597223	9848	552	22.017408	121.53609216	Singulisphaera	466152	Bacteria	Bacteria	640	9.12e-179	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g567	i1	87.703	122.498188405797	553	63	99	5	2	552	118	667	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	67619	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
10773328	10773328	PRJNA597223_P_NODE_34069_length_251_cov_234.990741_g32223_i0	PRJNA597223	34069	251	234.990741	589.82675991	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	364	2.57e-96	NTclustered	gi\|40362961\|gb\|AY494692.1\|	120965	g32223	i0	92.829	107.581673306773	251	18	100	0	1	251	252	2	Uncultured planctomycete clone PLANCTO4 16S ribosomal RNA gene, partial sequence	blastn	27003	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11344002	11344002	PRJNA597223_P_NODE_27809_length_290_cov_14.517647_g25963_i0	PRJNA597223	27809	290	14.517647	42.1011763	Singulisphaera	466152	Bacteria	Bacteria	424	4.94e-114	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g25963	i0	93.403	205.213793103448	288	15	99	3	1	288	2515	2798	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	59512	425	0.997647058823529	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
12048744	12048744	PRJNA597223_P_NODE_85170_length_152_cov_2.623932_g83324_i0	PRJNA597223	85170	152	2.623932	3.98837664	Paludisphaera borealis	1387353	Bacteria	Bacteria	113	5.6200000000000006e-21	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g83324	i0	81.69	2.80263157894737	142	21	93	3	3	143	122338	122475	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	426	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
12048793	12048793	PRJNA597223_P_NODE_930_length_1670_cov_18.029969_g567_i0	PRJNA597223	930	1670	18.029969	301.1004823	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1997	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g567	i0	88.343	129.402395209581	1690	161	99	28	2	1670	1599280	1600954	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	216102	1997	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
14597837	14597837	PRJNA597223_P_NODE_29212_length_280_cov_4.632653_g27366_i0	PRJNA597223	29212	280	4.632653	12.9714284	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	405	1.72e-108	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g27366	i0	92.857	62.1678571428571	280	19	100	1	1	280	1868287	1868009	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	17407	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16443467	16443467	PRJNA597223_P_NODE_51753_length_193_cov_5.816456_g49907_i0	PRJNA597223	51753	193	5.816456	11.22576008	Pirellula	123	Bacteria	Bacteria	196	7.26e-46	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g49907	i0	92.647	180.212435233161	136	10	70	0	35	170	1195	1060	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	34781	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
20267286	20267286	PRJNA597223_P_NODE_73876_length_165_cov_1.953846_g72030_i0	PRJNA597223	73876	165	1.953846	3.2238459	Isosphaera	127	Bacteria	Bacteria	206	1e-48	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g72030	i0	89.697	5	165	12	99	4	1	163	783	944	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	825	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
20267352	20267352	PRJNA597223_P_NODE_89036_length_150_cov_0.860870_g87190_i0	PRJNA597223	89036	150	0.86087	1.291305	Singulisphaera	466152	Bacteria	Bacteria	189	8.92e-44	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g87190	i0	89.333	171.813333333333	150	16	100	0	1	150	2151	2002	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	25772	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
22246389	22246389	PRJNA597223_P_NODE_5538_length_740_cov_2018.802837_g4255_i0	PRJNA597223	5538	740	2018.802837	14939.1409938	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	560	9.96e-155	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4255	i0	85.353	96.2689189189189	553	68	96	9	181	726	1866197	1866743	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	71239	560	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22246688	22246688	PRJNA597223_P_NODE_83118_length_154_cov_2.403361_g81272_i0	PRJNA597223	83118	154	2.403361	3.70117594	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	176	7.189999999999999e-40	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g81272	i0	87.662	36.1363636363636	154	15	100	4	1	154	7628331	7628182	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	5565	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
24795492	24795492	PRJNA597223_P_NODE_69360_length_172_cov_1.065693_g67514_i0	PRJNA597223	69360	172	1.065693	1.83299196	Gemmataceae bacterium	2052164	Bacteria	Bacteria	261	2.2000000000000002e-65	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g67514	i0	94.186	43.1220930232558	172	9	99	1	1	171	317767	317938	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	7417	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
24795624	24795624	PRJNA597223_P_NODE_79640_length_158_cov_1.674797_g77794_i0	PRJNA597223	79640	158	1.674797	2.64617926	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	237	3.36e-58	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g77794	i0	94.194	81.5569620253165	155	9	98	0	4	158	7628786	7628632	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	12886	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
27048284	27048284	PRJNA597223_P_NODE_78622_length_159_cov_2.193548_g76776_i0	PRJNA597223	78622	159	2.193548	3.48774132	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	83.2	5.77e-17	NR	WP_164103780.1	2770505	g76776	i0	75	0.981132075471698	52	13	98.1	0	158	3	48	99	WP_164103780.1 M20 metallopeptidase family protein [Candidatus Laterigemmans baculatus]	diamond	156	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
27995920	27995920	PRJNA597223_S_NODE_2785_length_186_cov_1.564626_g2728_i0	PRJNA597223	2785	186	1.564626	2.91020436	Singulisphaera sp. GP187	1882752	Bacteria	Bacteria	58.5	4.6e-8	NR	WP_074311456.1	1882752	g2728	i0	49.2	0.983870967741935	61	31	98.4	0	185	3	38	98	WP_074311456.1 tetratricopeptide repeat protein [Singulisphaera sp. GP187]	diamond	183	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
28437986	28437986	PRJNA597223_P_NODE_62466_length_184_cov_1.288591_g60620_i0	PRJNA597223	62466	184	1.288591	2.37100744	Planctomycetales bacterium	2053591	Bacteria	Bacteria	121	3.93e-30	NR	MCA9199410.1	2053591	g60620	i0	93.4	0.994565217391304	61	4	99.5	0	184	2	156	216	MCA9199410.1 hypothetical protein [Planctomycetales bacterium]	diamond	183	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30251400	30251400	PRJNA597223_P_NODE_74312_length_164_cov_4.465116_g72466_i0	PRJNA597223	74312	164	4.465116	7.32279024	Pseudomonadati	3379134	Bacteria	Bacteria	84.7	2.83e-19	NR	MFI5381397.1	2795155	g72466	i0	72.5	2.79878048780488	51	14	93.3	0	157	5	55	105	MFI5381397.1 hypothetical protein [Tepidisphaerales bacterium]	diamond	459	84.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
30333094	30333094	PRJNA597223_P_NODE_49332_length_199_cov_1.658537_g47486_i0	PRJNA597223	49332	199	1.658537	3.30048863	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	125	3.5900000000000004e-33	NR	MCP4265690.1	2094028	g47486	i0	87.7	4.89949748743719	65	8	98	0	197	3	20	84	MCP4265690.1 hypothetical protein [Candidatus Brocadiaceae bacterium]	diamond	975	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
31375545	31375545	PRJNA597223_P_NODE_29436_length_279_cov_2.450820_g27590_i0	PRJNA597223	29436	279	2.45082	6.8377878	Gemmataceae bacterium	2052164	Bacteria	Bacteria	77.8	2.72e-16	NR	MCI0375991.1	2052164	g27590	i0	55.2	1.2258064516129	58	26	62.4	0	268	95	38	95	MCI0375991.1 YciI family protein [Gemmataceae bacterium]	diamond	342	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;