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

33 rows where bioproject = "PRJNA758087" 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
2009999	2009999	PRJNA758087_P_NODE_9462_length_1058_cov_16.345178_g8432_i0	PRJNA758087	9462	1058	16.345178	172.93198324	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	240	3.389999999999999e-68	NR	MEI6603943.1	2026799	g8432	i0	44.7	4.21644612476371	293	160	82.8	2	1025	150	250	541	MEI6603943.1 rhamnan synthesis F family protein [Verrucomicrobiota bacterium]	diamond	4461	240	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
3285090	3285090	PRJNA758087_P_NODE_43003_length_245_cov_0.895349_g41683_i0	PRJNA758087	43003	245	0.895349	2.19360505	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	368	1.93e-97	NTclustered	gi\|389546593\|gb\|JQ401521.1\|	100233	g41683	i0	98.558	72.5551020408163	208	3	85	0	1	208	208	1	Uncultured Planctomycetaceae bacterium clone CNY_01638 16S ribosomal RNA gene, partial sequence	blastn	17776	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4562357	4562357	PRJNA758087_P_NODE_8064_length_1166_cov_23.376029_g7110_i0	PRJNA758087	8064	1166	23.376029	272.56449814	Prosthecobacter sp.	1965333	Bacteria	Bacteria	590	1.5e-205	NR	WP_397380455.1	1965333	g7110	i0	89.1	0.895368782161235	348	32	88	2	1050	25	1	348	WP_397380455.1 putative porin [Prosthecobacter sp.]	diamond	1044	590	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
5836930	5836930	PRJNA758087_P_NODE_26625_length_470_cov_12.607053_g25305_i0	PRJNA758087	26625	470	12.607053	59.2531491	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	117	1.6e-21	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g25305	i0	88.119	20.2659574468085	101	8	21	4	1	99	5362463	5362365	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	9525	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
7111658	7111658	PRJNA758087_P_NODE_10846_length_966_cov_6.207167_g9746_i0	PRJNA758087	10846	966	6.207167	59.96123322	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	797	0	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g9746	i0	82.434	145.861283643892	945	135	96	26	1	923	1843759	1844694	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	140902	797	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
7112313	7112313	PRJNA758087_P_NODE_33666_length_355_cov_1.911348_g32346_i0	PRJNA758087	33666	355	1.911348	6.7852854	Planctomycetota bacterium	2026780	Bacteria	Bacteria	147	2.05e-38	NR	MDQ3439768.1	2026780	g32346	i0	82.3	0.811267605633803	96	17	81.1	0	66	353	1	96	MDQ3439768.1 HAMP domain-containing protein [Planctomycetota bacterium]	diamond	288	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
8387186	8387186	PRJNA758087_P_NODE_5947_length_1381_cov_8.084862_g5154_i0	PRJNA758087	5947	1381	8.084862	111.65194422	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	691	5.82e-244	NR	MBX3316886.1	2026777	g5154	i0	74.9	0.944967414916727	435	109	94.5	0	25	1329	99	533	MBX3316886.1 M61 family metallopeptidase [Phycisphaeraceae bacterium]	diamond	1305	691	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
8855652	8855652	PRJNA758087_P_NODE_10147_length_1009_cov_18.641026_g9085_i0	PRJNA758087	10147	1009	18.641026	188.08795234	Verrucomicrobia bacterium 12-59-8	1970608	Bacteria	Bacteria	524	4.6999999999999984e-183	NR	OYW70787.1	1970608	g9085	i0	100	0.814667988107037	274	0	81.5	0	164	985	1	274	OYW70787.1 MAG: IS5/IS1182 family transposase [Verrucomicrobia bacterium 12-59-8]	diamond	822	524	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium 12-59-8
13487300	13487300	PRJNA758087_P_NODE_29991_length_411_cov_4.488166_g28671_i0	PRJNA758087	29991	411	4.488166	18.44636226	Planctomycetota bacterium	2026780	Bacteria	Bacteria	133	6.249999999999999e-34	NR	MBS0202891.1	2026780	g28671	i0	66.4	0.781021897810219	107	36	78.1	0	91	411	250	356	MBS0202891.1 AAA family ATPase [Planctomycetota bacterium]	diamond	321	133	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
17311049	17311049	PRJNA758087_P_NODE_11594_length_924_cov_2.740306_g10464_i0	PRJNA758087	11594	924	2.740306	25.32042744	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1110	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g10464	i0	89.011	134.677489177489	910	83	97	16	1	899	5937549	5936646	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	124442	1110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17311370	17311370	PRJNA758087_P_NODE_21594_length_575_cov_9.426295_g20280_i0	PRJNA758087	21594	575	9.426295	54.20119625	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	444	8.01e-120	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20280	i0	83.333	362.766956521739	498	66	86	11	33	524	7050206	7050692	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	208591	444	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17780450	17780450	PRJNA758087_P_NODE_23674_length_530_cov_6.345733_g22355_i0	PRJNA758087	23674	530	6.345733	33.6323849	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	217	1.76e-62	NR	HVK17764.1	1914235	g22355	i0	65.6	1.0188679245283	180	52	99.6	3	530	3	156	329	HVK17764.1 PQQ-binding-like beta-propeller repeat protein [Fimbriiglobus sp.]	diamond	540	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
18585329	18585329	PRJNA758087_P_NODE_29495_length_419_cov_8.104046_g28175_i0	PRJNA758087	29495	419	8.104046	33.95595274	Paludisphaera borealis	1387353	Bacteria	Bacteria	198	4.89e-46	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g28175	i0	79.522	0.699284009546539	293	49	69	10	29	316	5130261	5129975	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	293	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
19860053	19860053	PRJNA758087_P_NODE_14676_length_779_cov_54.726629_g13457_i0	PRJNA758087	14676	779	54.726629	426.32043991	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	454	2.8399999999999996e-156	NR	MBN8419734.1	2026799	g13457	i0	92	0.958921694480103	249	20	95.9	0	26	772	85	333	MBN8419734.1 response regulator [Verrucomicrobiota bacterium]	diamond	747	454	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21136049	21136049	PRJNA758087_P_NODE_30857_length_398_cov_0.947692_g29537_i0	PRJNA758087	30857	398	0.947692	3.77181416	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	730	0	NTclustered	gi\|389546593\|gb\|JQ401521.1\|	100233	g29537	i0	99.749	99.9321608040201	398	1	100	0	1	398	750	353	Uncultured Planctomycetaceae bacterium clone CNY_01638 16S ribosomal RNA gene, partial sequence	blastn	39773	730	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22410818	22410818	PRJNA758087_P_NODE_29258_length_423_cov_14.971429_g27938_i0	PRJNA758087	29258	423	14.971429	63.32914467	Rhodopirellula sp. P2	2127060	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2447573959\|gb\|CP118225.1\|	2127060	g27938	i0	100	0.066193853427896	28	0	7	0	228	255	1837395	1837422	Rhodopirellula sp. P2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. P2
26682797	26682797	PRJNA758087_P_NODE_37761_length_299_cov_4.070796_g36441_i0	PRJNA758087	37761	299	4.070796	12.17168004	Gemmata	113	Bacteria	Bacteria	90.1	1.7e-18	NR	MBN9121675.1	2026780	g36441	i0	56.8	1.77591973244147	88	29	81.3	3	3	245	391	476	MBN9121675.1 cytochrome c biogenesis protein CcsA [Planctomycetota bacterium]	diamond	531	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27558283	27558283	PRJNA758087_P_NODE_36604_length_314_cov_1.867220_g35284_i0	PRJNA758087	36604	314	1.86722	5.8630708	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.4	3.21e-10	NR	NQW46642.1	2026780	g35284	i0	44.9	1.28980891719745	69	37	65	1	280	77	11	79	NQW46642.1 hypothetical protein [Planctomycetota bacterium]	diamond	405	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27685103	27685103	PRJNA758087_P_NODE_27644_length_451_cov_11.690476_g26324_i0	PRJNA758087	27644	451	11.690476	52.72404676	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	134	3.74e-33	NR	MEO6809668.1	2691532	g26324	i0	51.7	0.798226164079823	120	58	79.8	0	41	400	9	128	MEO6809668.1 AsmA-like C-terminal region-containing protein [Isosphaeraceae bacterium]	diamond	360	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28600552	28600552	PRJNA758087_P_NODE_39107_length_283_cov_2.242857_g37787_i0	PRJNA758087	39107	283	2.242857	6.34728531	Gemmataceae bacterium	2052164	Bacteria	Bacteria	166	2.2299999999999994e-48	NR	MFO0823147.1	2052164	g37787	i0	84.3	9.42402826855124	89	14	94.3	0	16	282	44	132	MFO0823147.1 amidohydrolase family protein [Gemmataceae bacterium]	diamond	2667	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28726738	28726738	PRJNA758087_P_NODE_19427_length_628_cov_3.434234_g18126_i0	PRJNA758087	19427	628	3.434234	21.56698952	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	52.4	5.68e-4	NR	WP_213157352.1	2795736	g18126	i0	31.2	0.444267515923567	93	62	44.4	1	75	353	1311	1401	WP_213157352.1 ankyrin repeat domain-containing protein [Parachlamydia sp. AcF125]	diamond	279	52.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
28915913	28915913	PRJNA758087_P_NODE_25448_length_493_cov_3.857143_g24128_i0	PRJNA758087	25448	493	3.857143	19.01571499	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	167	3.59e-47	NR	HEX6986106.1	2026779	g24128	i0	61.4	0.803245436105477	132	51	80.3	0	40	435	74	205	HEX6986106.1 NPCBM/NEW2 domain-containing protein [Planctomycetaceae bacterium]	diamond	396	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28979486	28979486	PRJNA758087_P_NODE_36748_length_312_cov_2.301255_g35428_i0	PRJNA758087	36748	312	2.301255	7.1799156	Gemmata sp.	1914242	Bacteria	Bacteria	109	3.94e-26	NR	HVL11736.1	1914242	g35428	i0	56.2	0.855769230769231	89	39	85.6	0	311	45	275	363	HVL11736.1 prenyltransferase/squalene oxidase repeat-containing protein [Gemmata sp.]	diamond	267	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
29642065	29642065	PRJNA758087_P_NODE_35630_length_327_cov_5.417323_g34310_i0	PRJNA758087	35630	327	5.417323	17.71464621	Planctomycetia bacterium	2052181	Bacteria	Bacteria	92	5.3e-19	NR	MCI0704830.1	2052181	g34310	i0	63.9	0.761467889908257	83	21	76.1	1	25	273	1263	1336	MCI0704830.1 hypothetical protein [Planctomycetia bacterium]	diamond	249	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29768570	29768570	PRJNA758087_P_NODE_15931_length_734_cov_6.919818_g14681_i0	PRJNA758087	15931	734	6.919818	50.79146412	Prosthecobacter sp.	1965333	Bacteria	Bacteria	431	1.0599999999999999e-136	NR	WP_397382958.1	1965333	g14681	i0	93.4	0.935967302452316	229	15	93.6	0	17	703	980	1208	WP_397382958.1 PAS domain S-box protein [Prosthecobacter sp.]	diamond	687	431	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30284369	30284369	PRJNA758087_P_NODE_40172_length_270_cov_2.243655_g38852_i0	PRJNA758087	40172	270	2.243655	6.0578685	Chlamydiia	204429	Bacteria	Bacteria	118	1.31e-30	NR	WP_213106468.1	362787	g38852	i0	72.2	4.41111111111111	79	22	87.8	0	239	3	24	102	WP_213106468.1 GSU2403 family nucleotidyltransferase fold protein [Candidatus Protochlamydia amoebophila]	diamond	1191	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
31475162	31475162	PRJNA758087_P_NODE_21056_length_588_cov_6.355340_g19745_i0	PRJNA758087	21056	588	6.35534	37.3693992	Opitutaceae bacterium	2006848	Bacteria	Bacteria	96.7	2.4e-19	NR	HTZ19767.1	2006848	g19745	i0	66.2	3.94387755102041	77	25	39.3	1	132	362	504	579	HTZ19767.1 NHL repeat-containing protein [Opitutaceae bacterium]	diamond	2319	96.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31981028	31981028	PRJNA758087_P_NODE_33358_length_359_cov_4.814685_g32038_i0	PRJNA758087	33358	359	4.814685	17.28471915	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00806	NR	MFH1419929.1	2026780	g32038	i0	30.9	0.785515320334262	94	59	73.5	1	76	339	71	164	MFH1419929.1 response regulator [Planctomycetota bacterium]	diamond	282	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32044463	32044463	PRJNA758087_P_NODE_43038_length_244_cov_2.111111_g41718_i0	PRJNA758087	43038	244	2.111111	5.15111084	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	58.2	2.08e-8	NR	WP_171472431.1	2774151	g41718	i0	77.1	0.860655737704918	35	8	43	0	117	13	1	35	WP_171472431.1 hypothetical protein [Frigoriglobus tundricola]	diamond	210	58.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
32076101	32076101	PRJNA758087_P_NODE_39498_length_279_cov_1.150485_g38178_i0	PRJNA758087	39498	279	1.150485	3.20985315	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	109	5.0700000000000006e-27	NR	WP_171471945.1	2774151	g38178	i0	65.9	0.913978494623656	85	29	91.4	0	4	258	160	244	WP_171471945.1 hypothetical protein [Frigoriglobus tundricola]	diamond	255	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
32361117	32361117	PRJNA758087_P_NODE_9459_length_1058_cov_126.102538_g8429_i0	PRJNA758087	9459	1058	126.102538	1334.16485204	Gemmataceae bacterium	2052164	Bacteria	Bacteria	372	5.52e-125	NR	HJZ56040.1	2052164	g8429	i0	64.4	2.40737240075614	275	97	77.7	1	194	1015	10	284	HJZ56040.1 DUF4105 domain-containing protein [Gemmataceae bacterium]	diamond	2547	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32771066	32771066	PRJNA758087_P_NODE_23000_length_544_cov_11.356688_g21683_i0	PRJNA758087	23000	544	11.356688	61.78038272	Chlamydia psittaci 1	83554	Bacteria	Bacteria	48.9	2.95e-4	NR	EPP36608.1	1238236	g21683	i0	91.3	0.126838235294118	23	2	12.7	0	46	114	1	23	EPP36608.1 hypothetical protein CP10743SC13_1857 [Chlamydia psittaci 10_743_SC13]	diamond	69	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32812377	32812377	PRJNA758087_P_NODE_41340_length_254_cov_2.149171_g40020_i0	PRJNA758087	41340	254	2.149171	5.45889434	Gemmata	113	Bacteria	Bacteria	79.7	3.12e-16	NR	AMV30455.1	1630693	g40020	i0	65.3	3.34251968503937	72	25	85	0	2	217	102	173	AMV30455.1 hypothetical protein VT84_39040 [Gemmata sp. SH-PL17]	diamond	849	79.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17

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);;