metadata: contig_metadata: 29 rows where bioproject = "PRJNA415856", tax_clade = "PVC group" and tax

29 rows where bioproject = "PRJNA415856", 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
1694186	1694186	PRJNA415856_P_NODE_37502_length_166_cov_1.376068_g37241_i0	PRJNA415856	37502	166	1.376068	2.28427288	Adhaeretor mobilis	1930276	Bacteria	Bacteria	224	2.7799999999999995e-54	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g37241	i0	90.964	56.0903614457831	166	15	100	0	1	166	3977207	3977372	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	9311	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
1694202	1694202	PRJNA415856_P_NODE_39942_length_165_cov_1.698276_g39681_i0	PRJNA415856	39942	165	1.698276	2.8021554	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	154	3.68e-33	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g39681	i0	86.429	0.848484848484849	140	19	85	0	26	165	5868166	5868027	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	140	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
1694276	1694276	PRJNA415856_P_NODE_50342_length_162_cov_0.902655_g50081_i0	PRJNA415856	50342	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	1.48e-25	NR	MDQ3439808.1	2026780	g50081	i0	88.5	1.92592592592593	52	6	96.3	0	5	160	38	89	MDQ3439808.1 sugar phosphate isomerase/epimerase [Planctomycetota bacterium]	diamond	312	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
1694319	1694319	PRJNA415856_P_NODE_8142_length_320_cov_2.003690_g7881_i0	PRJNA415856	8142	320	2.00369	6.411808	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	392	1.5599999999999995e-104	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g7881	i0	88.785	73.875	321	35	100	1	1	320	2621795	2622115	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	23640	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4246377	4246377	PRJNA415856_P_NODE_32864_length_170_cov_1.264463_g32603_i0	PRJNA415856	32864	170	1.264463	2.1495871	root	1	Root_unresolved	Root_unresolved	98.2	2.92e-22	NR	MBN2712999.1	2026780	g32603	i0	87.5	2.96470588235294	56	7	98.8	0	168	1	263	318	MBN2712999.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	504	99	0.991919191919192	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6797096	6797096	PRJNA415856_P_NODE_3586_length_525_cov_2.808824_g3337_i0	PRJNA415856	3586	525	2.808824	14.746326	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	673	0	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3337	i0	90.249	93.992380952381	523	39	99	2	1	523	3081664	3082174	Stratiformator vulcanicus strain Pan189 chromosome	blastn	49346	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
8736372	8736372	PRJNA415856_P_NODE_3907_length_500_cov_2.780488_g3654_i0	PRJNA415856	3907	500	2.780488	13.90244	Pirellulales	2691354	Bacteria	Bacteria	756	0	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g3654	i0	94.165	126.798	497	28	100	1	4	500	2674143	2673648	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	63399	756	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
13173000	13173000	PRJNA415856_P_NODE_22691_length_188_cov_1.071942_g22430_i0	PRJNA415856	22691	188	1.071942	2.01525096	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	222	1.16e-53	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g22430	i0	88.235	86.6276595744681	187	20	99	2	3	188	4421361	4421546	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	16286	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13173018	13173018	PRJNA415856_P_NODE_24471_length_184_cov_1.807407_g24210_i0	PRJNA415856	24471	184	1.807407	3.32562888	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	285	1.42e-72	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g24210	i0	94.565	135.20652173913	184	10	100	0	1	184	4422213	4422396	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	24878	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15721840	15721840	PRJNA415856_P_NODE_14493_length_228_cov_1.648045_g14232_i0	PRJNA415856	14493	228	1.648045	3.7575426	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	399	6.299999999999999e-107	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g14232	i0	98.667	116.118421052632	225	3	99	0	1	225	5169504	5169728	Lacipirellula limnantheis strain I41 chromosome	blastn	26475	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
16385983	16385983	PRJNA415856_P_NODE_45613_length_163_cov_1.500000_g45352_i0	PRJNA415856	45613	163	1.5	2.445	Planctomycetia	203683	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g45352	i0	95.706	136.361963190184	163	7	100	0	1	163	2507	2669	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	22227	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
18271061	18271061	PRJNA415856_P_NODE_48715_length_162_cov_0.902655_g48454_i0	PRJNA415856	48715	162	0.902655	1.4623011	Humisphaera borealis	2807512	Bacteria	Bacteria	132	1.68e-26	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g48454	i0	84.733	2.65432098765432	131	20	81	0	1	131	3547554	3547684	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	430	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19545171	19545171	PRJNA415856_P_NODE_34876_length_167_cov_1.491525_g34615_i0	PRJNA415856	34876	167	1.491525	2.49084675	Humisphaera borealis	2807512	Bacteria	Bacteria	86.1	1.38e-12	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g34615	i0	88.571	0.419161676646707	70	8	42	0	96	165	4459470	4459539	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	70	86.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19545309	19545309	PRJNA415856_P_NODE_536_length_1235_cov_3.026138_g443_i0	PRJNA415856	536	1235	3.026138	37.3728043	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	1249	0	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g443	i0	85.138	109.338461538462	1265	138	100	30	1	1235	1844353	1845597	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	135033	1249	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
20209534	20209534	PRJNA415856_P_NODE_14836_length_225_cov_3.198864_g14575_i0	PRJNA415856	14836	225	3.198864	7.197444	Gimesia	1649453	Bacteria	Bacteria	333	6.379999999999999e-87	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g14575	i0	93.722	526.675555555556	223	12	99	2	3	224	2397312	2397091	Gimesia alba strain Pan241w chromosome	blastn	118502	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
24645778	24645778	PRJNA415856_P_NODE_41940_length_165_cov_0.879310_g41679_i0	PRJNA415856	41940	165	0.87931	1.4508615	Paludisphaera borealis	1387353	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g41679	i0	97.576	150.454545454545	165	4	100	0	1	165	121929	121765	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	24825	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
25309656	25309656	PRJNA415856_P_NODE_39740_length_165_cov_1.974138_g39479_i0	PRJNA415856	39740	165	1.974138	3.2573277	Planctomycetaceae	126	Bacteria	Bacteria	255	9.8e-64	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g39479	i0	94.545	137.024242424242	165	9	100	0	1	165	5087678	5087842	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	22609	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
27328573	27328573	PRJNA415856_P_NODE_48903_length_162_cov_0.902655_g48642_i0	PRJNA415856	48903	162	0.902655	1.4623011	Gemmataceae bacterium	2052164	Bacteria	Bacteria	91.3	2.2e-20	NR	MDB5313536.1	2052164	g48642	i0	83	1.96296296296296	53	9	98.1	0	161	3	95	147	MDB5313536.1 dihydroorotate dehydrogenase [Gemmataceae bacterium]	diamond	318	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27391809	27391809	PRJNA415856_P_NODE_38963_length_166_cov_0.871795_g38702_i0	PRJNA415856	38963	166	0.871795	1.4471797	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.8	0.00108	NR	HTN74522.1	2699754	g38702	i0	43.8	0.867469879518072	48	27	86.7	0	145	2	305	352	HTN74522.1 BBP7 family outer membrane beta-barrel protein [Pirellulaceae bacterium]	diamond	144	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27724399	27724399	PRJNA415856_P_NODE_47804_length_163_cov_0.877193_g47543_i0	PRJNA415856	47804	163	0.877193	1.42982459	Pseudomonadati	3379134	Bacteria	Bacteria	100	1.4000000000000002e-23	NR	MDZ4683813.1	2026779	g47543	i0	83	7.80368098159509	53	9	97.5	0	1	159	223	275	MDZ4683813.1 isochorismatase family protein [Planctomycetaceae bacterium]	diamond	1272	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28307310	28307310	PRJNA415856_P_NODE_34266_length_168_cov_1.226891_g34005_i0	PRJNA415856	34266	168	1.226891	2.06117688	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	60.8	2.7e-9	NR	HZN36815.1	2699754	g34005	i0	75.8	1.17857142857143	33	8	58.9	0	168	70	189	221	HZN36815.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Pirellulaceae bacterium]	diamond	198	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28465296	28465296	PRJNA415856_P_NODE_47406_length_163_cov_0.894737_g47145_i0	PRJNA415856	47406	163	0.894737	1.45842131	Gemmataceae bacterium	2052164	Bacteria	Bacteria	67.8	1.86e-11	NR	HYV37295.1	2052164	g47145	i0	66	0.865030674846626	47	16	86.5	0	2	142	339	385	HYV37295.1 6-pyruvoyl-tetrahydropterin synthase-related protein [Gemmataceae bacterium]	diamond	141	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29633004	29633004	PRJNA415856_P_NODE_39190_length_166_cov_0.871795_g38929_i0	PRJNA415856	39190	166	0.871795	1.4471797	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	77	1.04e-14	NR	MEO6434528.1	2876886	g38929	i0	68.4	2.02409638554217	57	15	97.6	2	3	164	591	647	MEO6434528.1 S8 family serine peptidase [Tepidisphaeraceae bacterium]	diamond	336	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29712783	29712783	PRJNA415856_P_NODE_37050_length_166_cov_2.145299_g36789_i0	PRJNA415856	37050	166	2.145299	3.56119634	Bacteria	2	Bacteria	Bacteria	75.1	3.9e-15	NR	WP_145201570.1	2527994	g36789	i0	61.4	16.3373493975904	57	20	99.4	1	166	2	82	138	WP_145201570.1 peptide-methionine (S)-S-oxide reductase MsrA [Thalassoglobus polymorphus]	diamond	2712	75.5	0.994701986754967	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
29791079	29791079	PRJNA415856_P_NODE_21451_length_190_cov_1.446809_g21190_i0	PRJNA415856	21451	190	1.446809	2.7489371	Planctomycetales bacterium	2053591	Bacteria	Bacteria	65.1	1.55e-10	NR	MCA9203155.1	2053591	g21190	i0	69.5	1.89473684210526	59	17	93.2	1	9	185	174	231	MCA9203155.1 hypothetical protein [Planctomycetales bacterium]	diamond	360	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30549445	30549445	PRJNA415856_P_NODE_633_length_1162_cov_4.915544_g527_i0	PRJNA415856	633	1162	4.915544	57.11862128	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.6	1.89e-12	NR	MDZ4821649.1	2026780	g527	i0	41.2	0.307228915662651	119	63	30.7	3	89	445	63	174	MDZ4821649.1 SAM-dependent DNA methyltransferase [Planctomycetota bacterium]	diamond	357	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31466240	31466240	PRJNA415856_P_NODE_49816_length_162_cov_0.902655_g49555_i0	PRJNA415856	49816	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.9	8.87e-11	NR	MCY2961048.1	2026780	g49555	i0	57.4	3	54	23	100	0	162	1	637	690	MCY2961048.1 HEAT repeat domain-containing protein [Planctomycetota bacterium]	diamond	486	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32288956	32288956	PRJNA415856_P_NODE_43259_length_164_cov_0.886957_g42998_i0	PRJNA415856	43259	164	0.886957	1.45460948	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	49.3	2.16e-5	NR	HTL30426.1	2876886	g42998	i0	56.3	0.878048780487805	48	20	87.8	1	2	145	65	111	HTL30426.1 VCBS repeat-containing protein [Tepidisphaeraceae bacterium]	diamond	144	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32667667	32667667	PRJNA415856_P_NODE_30180_length_174_cov_1.560000_g29919_i0	PRJNA415856	30180	174	1.56	2.7144	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	104	2.1499999999999998e-24	NR	MCA9076099.1	2026779	g29919	i0	86	2.94827586206897	57	8	98.3	0	173	3	694	750	MCA9076099.1 excinuclease ABC subunit A [Planctomycetaceae bacterium]	diamond	513	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;