metadata: contig_metadata: 33 rows where bioproject = "PRJNA870096" and tax

33 rows where bioproject = "PRJNA870096" and tax_clade = "PVC group"

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
2512857	2512857	PRJNA870096_S_NODE_39142_length_284_cov_2.041494_g37478_i0	PRJNA870096	39142	284	2.041494	5.79784296	Candidatus Protochlamydia	282132	Bacteria	Bacteria	270	6.65e-68	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g37478	i0	84.783	136.44014084507	276	35	99	6	13	283	1249517	1249244	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	38749	270	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
5953594	5953594	PRJNA870096_S_NODE_56705_length_233_cov_1.768421_g55041_i0	PRJNA870096	56705	233	1.768421	4.12042093	Planctomycetota bacterium	2026780	Bacteria	Bacteria	103	3.96e-25	NR	HUS57900.1	2026780	g55041	i0	64.5	2.94849785407725	76	27	97.9	0	233	6	109	184	HUS57900.1 (d)CMP kinase [Planctomycetota bacterium]	diamond	687	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
5953666	5953666	PRJNA870096_S_NODE_62565_length_221_cov_6.101124_g60901_i0	PRJNA870096	62565	221	6.101124	13.48348404	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	239	1.3999999999999999e-58	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g60901	i0	88.776	55.2398190045249	196	21	89	1	26	221	1249074	1249268	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	12208	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19088788	19088788	PRJNA870096_S_NODE_39275_length_284_cov_1.195021_g37611_i0	PRJNA870096	39275	284	1.1950210000000001	3.39385964	Parachlamydiales	1963360	Bacteria	Bacteria	377	3.81e-100	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g37611	i0	90.813	142.531690140845	283	24	99	2	3	284	1249774	1249493	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40479	377	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
21639230	21639230	PRJNA870096_S_NODE_103177_length_174_cov_1.465649_g101513_i0	PRJNA870096	103177	174	1.465649	2.55022926	Candidatus Protochlamydia	282132	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g101513	i0	93.377	57.3965517241379	151	10	87	0	24	174	1250655	1250505	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	9987	224	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23802015	23802015	PRJNA870096_S_NODE_145419_length_150_cov_1.327103_g143755_i0	PRJNA870096	145419	150	1.327103	1.9906545	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	226	6.8e-55	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g143755	i0	94	91.6533333333333	150	7	100	2	1	150	301	154	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	13748	226	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
25076623	25076623	PRJNA870096_S_NODE_78220_length_198_cov_1.812903_g76556_i0	PRJNA870096	78220	198	1.812903	3.58954794	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	99	2.17e-16	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g76556	i0	76.382	3.85353535353535	199	38	99	7	1	196	2153778	2153970	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	763	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
27055307	27055307	PRJNA870096_S_NODE_51182_length_246_cov_1.655172_g49518_i0	PRJNA870096	51182	246	1.655172	4.07172312	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	55.1	4.42e-7	NR	MBX3436947.1	2026779	g49518	i0	41.5	3.92682926829268	65	38	79.3	0	245	51	48	112	MBX3436947.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	966	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27284544	27284544	PRJNA870096_S_NODE_25843_length_354_cov_4.372990_g24179_i0	PRJNA870096	25843	354	4.37299	15.4803846	root	1	Root_unresolved	Root_unresolved	150	3.859999999999999e-42	NR	KPJ56592.1	1703415	g24179	i0	69.6	16.4745762711864	102	31	86.4	0	330	25	184	285	KPJ56592.1 MAG: hydroxylamine reductase, partial [Planctomycetes bacterium DG_58]	diamond	5832	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium DG_58
27316340	27316340	PRJNA870096_S_NODE_143363_length_151_cov_0.888889_g141699_i0	PRJNA870096	143363	151	0.888889	1.34222239	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	8.21e-7	NR	MFT3786816.1	2876886	g141699	i0	51	3.89403973509934	49	24	97.4	0	148	2	192	240	MFT3786816.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	588	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27339817	27339817	PRJNA870096_S_NODE_34543_length_304_cov_1.471264_g32879_i0	PRJNA870096	34543	304	1.471264	4.47264256	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	83.6	2.52e-16	NR	MCA9078104.1	2026779	g32879	i0	41	2.96052631578947	100	57	97.7	2	3	299	206	304	MCA9078104.1 NO-inducible flavohemoprotein [Planctomycetaceae bacterium]	diamond	900	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27371557	27371557	PRJNA870096_S_NODE_129583_length_157_cov_1.017544_g127919_i0	PRJNA870096	129583	157	1.017544	1.59754408	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.6	0.0286	NR	MCG3178336.1	2026778	g127919	i0	43.4	1.01273885350318	53	25	91.7	2	4	147	29	81	MCG3178336.1 hypothetical protein [Phycisphaerae bacterium]	diamond	159	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27402948	27402948	PRJNA870096_S_NODE_21283_length_393_cov_2.351429_g19623_i0	PRJNA870096	21283	393	2.351429	9.24111597	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	1.98e-29	NR	MBS0628243.1	2026799	g19623	i0	44.1	0.969465648854962	127	64	91.6	1	2	361	4	130	MBS0628243.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	381	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27813556	27813556	PRJNA870096_S_NODE_66144_length_215_cov_2.511628_g64480_i0	PRJNA870096	66144	215	2.511628	5.4000002	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	53.5	3.85e-6	NR	MAC20470.1	2026778	g64480	i0	50.8	0.851162790697674	61	29	85.1	1	213	31	261	320	MAC20470.1 hypothetical protein [Phycisphaerae bacterium]	diamond	183	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27821585	27821585	PRJNA870096_S_NODE_107664_length_171_cov_1.125000_g106000_i0	PRJNA870096	107664	171	1.125	1.92375	Pseudomonadati	3379134	Bacteria	Bacteria	60.5	7.66e-9	NR	HEV8112344.1	2026780	g106000	i0	50.9	3.89473684210526	55	27	96.5	0	170	6	394	448	HEV8112344.1 RNB domain-containing ribonuclease [Planctomycetota bacterium]	diamond	666	60.8	0.995065789473684	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28034485	28034485	PRJNA870096_S_NODE_31245_length_320_cov_4.787004_g29581_i0	PRJNA870096	31245	320	4.787004	15.3184128	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.8	0.00316	NR	MCM8804011.1	2035772	g29581	i0	30.3	0.61875	66	46	61.9	0	240	43	26	91	MCM8804011.1 30S ribosomal protein S7 [Candidatus Omnitrophota bacterium]	diamond	198	45.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28034488	28034488	PRJNA870096_S_NODE_89765_length_186_cov_1.006993_g88101_i0	PRJNA870096	89765	186	1.006993	1.87300698	Planctomycetota bacterium	2026780	Bacteria	Bacteria	93.6	4.92e-22	NR	MCB9916332.1	2026780	g88101	i0	67.7	4.93548387096774	62	19	100	1	1	186	101	161	MCB9916332.1 superoxide dismutase [Fe] [Planctomycetota bacterium]	diamond	918	93.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28255242	28255242	PRJNA870096_S_NODE_61546_length_223_cov_2.400000_g59882_i0	PRJNA870096	61546	223	2.4	5.352	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	54.3	1.03e-6	NR	MBT7982475.1	2562705	g59882	i0	41.9	0.995515695067265	74	41	99.6	1	222	1	88	159	MBT7982475.1 peptidyl-prolyl cis-trans isomerase [Akkermansiaceae bacterium]	diamond	222	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28547835	28547835	PRJNA870096_S_NODE_67527_length_213_cov_1.776471_g65863_i0	PRJNA870096	67527	213	1.776471	3.78388323	Planctomycetota	203682	Bacteria	Bacteria	53.1	5.43e-6	NR	MBL8813740.1	2026779	g65863	i0	48	6.97183098591549	50	26	70.4	0	1	150	359	408	MBL8813740.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1485	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28634484	28634484	PRJNA870096_S_NODE_52787_length_242_cov_1.783920_g51123_i0	PRJNA870096	52787	242	1.78392	4.3170864	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	5.16e-5	NR	MCX6877507.1	2026799	g51123	i0	58.7	2.23140495867769	46	18	55.8	1	1	135	79	124	MCX6877507.1 ankyrin repeat domain-containing protein [Verrucomicrobiota bacterium]	diamond	540	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29107932	29107932	PRJNA870096_S_NODE_144728_length_150_cov_1.794393_g143064_i0	PRJNA870096	144728	150	1.794393	2.6915895	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	57.4	6.88e-8	NR	MFM7179879.1	2026801	g143064	i0	55.3	0.94	47	21	94	0	149	9	361	407	MFM7179879.1 zinc metallochaperone GTPase ZigA [Verrucomicrobiales bacterium]	diamond	141	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29336983	29336983	PRJNA870096_S_NODE_31269_length_320_cov_3.212996_g29605_i0	PRJNA870096	31269	320	3.212996	10.2815872	Chlamydia	810	Bacteria	Bacteria	77	2.95e-15	NR	EPJ29527.1	1112251	g29605	i0	42.7	2.896875	103	59	96.6	0	1	309	47	149	EPJ29527.1 cytochrome c oxidase subunit 3, partial [Chlamydia psittaci 99DC5]	diamond	927	77	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
29360487	29360487	PRJNA870096_S_NODE_29329_length_331_cov_2.184028_g27665_i0	PRJNA870096	29329	331	2.184028	7.22913268	Planctomycetes bacterium GWF2_42_9	1801958	Bacteria	Bacteria	43.9	0.0378	NR	OHB57012.1	1801958	g27665	i0	43.2	0.398791540785498	44	25	39.9	0	240	109	87	130	OHB57012.1 MAG: glutathione-dependent formaldehyde dehydrogenase [Planctomycetes bacterium GWF2_42_9]	diamond	132	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium GWF2_42_9
29454793	29454793	PRJNA870096_S_NODE_86590_length_189_cov_1.136986_g84926_i0	PRJNA870096	86590	189	1.136986	2.14890354	Lacunisphaera sp.	1961806	Bacteria	Bacteria	72.4	6.2e-13	NR	HWA27973.1	1961806	g84926	i0	62.1	2.50793650793651	58	18	85.7	1	163	2	677	734	HWA27973.1 NADP-dependent isocitrate dehydrogenase [Lacunisphaera sp.]	diamond	474	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
29620666	29620666	PRJNA870096_S_NODE_85170_length_190_cov_2.095238_g83506_i0	PRJNA870096	85170	190	2.095238	3.9809522	PVC group	1783257	Bacteria	Bacteria	78.6	7.93e-17	NR	MDR1009977.1	2006848	g83506	i0	64.5	11.6842105263158	62	22	97.9	0	188	3	39	100	MDR1009977.1 glycine cleavage system protein GcvH [Opitutaceae bacterium]	diamond	2220	79	0.994936708860759	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29778953	29778953	PRJNA870096_S_NODE_96791_length_179_cov_1.882353_g95127_i0	PRJNA870096	96791	179	1.882353	3.36941187	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	7.75e-6	NR	MFN9985411.1	117	g95127	i0	42.4	2.96648044692737	59	30	98.9	1	179	3	20	74	MFN9985411.1 heavy-metal-associated domain-containing protein [Pirellula sp.]	diamond	531	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30149762	30149762	PRJNA870096_S_NODE_23852_length_369_cov_4.978528_g22189_i0	PRJNA870096	23852	369	4.978528	18.37076832	Opitutaceae bacterium	2006848	Bacteria	Bacteria	94.4	1.17e-20	NR	MBX3749762.1	2006848	g22189	i0	42.3	6.04878048780488	123	70	99.2	1	3	368	134	256	MBX3749762.1 SDR family oxidoreductase [Opitutaceae bacterium]	diamond	2232	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30940036	30940036	PRJNA870096_S_NODE_22894_length_377_cov_3.544910_g21233_i0	PRJNA870096	22894	377	3.54491	13.3643107	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	188	8.819999999999999e-56	NR	MEQ8316804.1	2052180	g21233	i0	74.6	7.84615384615385	122	31	97.1	0	372	7	261	382	MEQ8316804.1 cystathionine gamma-synthase [Phycisphaerales bacterium]	diamond	2958	188	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31066498	31066498	PRJNA870096_S_NODE_118795_length_163_cov_1.600000_g117131_i0	PRJNA870096	118795	163	1.6	2.608	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.8	2.49e-9	NR	MEM8710806.1	2026780	g117131	i0	53.1	1.78527607361963	49	23	90.2	0	3	149	169	217	MEM8710806.1 cysteine dioxygenase family protein [Planctomycetota bacterium]	diamond	291	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31074421	31074421	PRJNA870096_S_NODE_97815_length_178_cov_2.688889_g96151_i0	PRJNA870096	97815	178	2.688889	4.78622242	Pseudomonadati	3379134	Bacteria	Bacteria	97.1	2.8000000000000003e-23	NR	MDE6432490.1	2026772	g96151	i0	85.7	2.62921348314607	49	7	82.6	0	27	173	142	190	MDE6432490.1 peroxiredoxin [Opitutales bacterium]	diamond	468	97.8	0.992842535787321	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
31097697	31097697	PRJNA870096_S_NODE_134155_length_154_cov_1.297297_g132491_i0	PRJNA870096	134155	154	1.297297	1.99783738	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.5	3.02e-9	NR	MDX2130450.1	2026780	g132491	i0	61.7	1.83116883116883	47	18	91.6	0	12	152	159	205	MDX2130450.1 isoprenoid biosynthesis glyoxalase ElbB [Planctomycetota bacterium]	diamond	282	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31580397	31580397	PRJNA870096_S_NODE_147256_length_150_cov_0.897196_g145592_i0	PRJNA870096	147256	150	0.897196	1.345794	Bacteria	2	Bacteria	Bacteria	75.5	1.77e-15	NR	MBX3388087.1	2026777	g145592	i0	73.5	1.96	49	13	98	0	3	149	52	100	MBX3388087.1 peptidyl-prolyl cis-trans isomerase [Phycisphaeraceae bacterium]	diamond	294	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32521614	32521614	PRJNA870096_S_NODE_73979_length_204_cov_0.894410_g72315_i0	PRJNA870096	73979	204	0.89441	1.8245964	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.5	3.64e-6	NR	MEW6238568.1	2035772	g72315	i0	61.9	3.80882352941176	42	15	61.8	1	4	129	33	73	MEW6238568.1 putative Ig domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	777	53.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;