metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA1104180" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA1104180" 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
2762997	2762997	PRJNA1104180_P_NODE_15883_length_272_cov_2.145729_g15741_i0	PRJNA1104180	15883	272	2.145729	5.83638288	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	110	5.94e-26	NR	MEZ6234625.1	2052180	g15741	i0	83.9	2.8125	62	10	68.4	0	187	2	1	62	MEZ6234625.1 rhodanese-like domain-containing protein [Phycisphaerales bacterium]	diamond	765	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4848277	4848277	PRJNA1104180_P_NODE_17464_length_264_cov_1.450262_g17322_i0	PRJNA1104180	17464	264	1.450262	3.82869168	Aquisphaera insulae	2712864	Bacteria	Bacteria	88.6	1.47e-19	NR	WP_165235999.1	2712864	g17322	i0	56.5	0.965909090909091	85	37	96.6	0	256	2	27	111	WP_165235999.1 hypothetical protein, partial [Aquisphaera insulae]	diamond	255	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
5315121	5315121	PRJNA1104180_P_NODE_13325_length_287_cov_1.439252_g13183_i0	PRJNA1104180	13325	287	1.439252	4.13065324	Planctomycetota bacterium	2026780	Bacteria	Bacteria	164	8.479999999999999e-47	NR	MBI5762376.1	2026780	g13183	i0	92.6	0.993031358885017	95	7	99.3	0	286	2	327	421	MBI5762376.1 DEAD/DEAH box helicase [Planctomycetota bacterium]	diamond	285	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9948511	9948511	PRJNA1104180_P_NODE_27208_length_233_cov_2.681250_g27065_i0	PRJNA1104180	27208	233	2.68125	6.2473125	Limnoglobus roseus	2598579	Bacteria	Bacteria	112	1.1300000000000002e-27	NR	WP_168219187.1	2598579	g27065	i0	67.5	2.97424892703863	77	25	99.1	0	1	231	203	279	WP_168219187.1 GGDEF domain-containing protein [Limnoglobus roseus]	diamond	693	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
11690991	11690991	PRJNA1104180_P_NODE_16990_length_266_cov_2.295337_g16848_i0	PRJNA1104180	16990	266	2.295337	6.10559642	PVC group	1783257	Bacteria	Bacteria	92.4	1.66e-19	NR	MBV8265011.1	2026779	g16848	i0	63.5	1.42105263157895	63	23	71.1	0	265	77	605	667	MBV8265011.1 WD40 repeat domain-containing protein [Planctomycetaceae bacterium]	diamond	378	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
12499077	12499077	PRJNA1104180_P_NODE_15830_length_273_cov_1.010000_g15688_i0	PRJNA1104180	15830	273	1.01	2.7573	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	164	4.28e-47	NR	TAG29148.1	2026799	g15688	i0	97.8	1	91	2	100	0	273	1	221	311	TAG29148.1 MAG: replicative DNA helicase, partial [Verrucomicrobiota bacterium]	diamond	273	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
15514856	15514856	PRJNA1104180_P_NODE_12653_length_291_cov_2.022936_g12511_i0	PRJNA1104180	12653	291	2.022936	5.88674376	Planctomycetota bacterium	2026780	Bacteria	Bacteria	146	2.49e-41	NR	MCE9566448.1	2026780	g12511	i0	82.6	0.88659793814433	86	15	88.7	0	258	1	1	86	MCE9566448.1 sugar phosphate isomerase/epimerase [Planctomycetota bacterium]	diamond	258	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
19338097	19338097	PRJNA1104180_P_NODE_15416_length_275_cov_1.524752_g15274_i0	PRJNA1104180	15416	275	1.524752	4.193068	Planctomycetota bacterium	2026780	Bacteria	Bacteria	174	1.49e-50	NR	MBN9120930.1	2026780	g15274	i0	93.4	3.97090909090909	91	6	99.3	0	274	2	36	126	MBN9120930.1 exodeoxyribonuclease VII large subunit [Planctomycetota bacterium]	diamond	1092	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
20613440	20613440	PRJNA1104180_P_NODE_14517_length_280_cov_1.487923_g14375_i0	PRJNA1104180	14517	280	1.487923	4.1661844	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	143	8.97e-38	NR	MBX6314302.1	2691532	g14375	i0	69.2	1.96071428571429	91	28	97.5	0	6	278	327	417	MBX6314302.1 DUF1549 domain-containing protein [Isosphaeraceae bacterium]	diamond	549	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
26624475	26624475	PRJNA1104180_P_NODE_20781_length_250_cov_0.870056_g20638_i0	PRJNA1104180	20781	250	0.870056	2.17514	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.2	7.35e-13	NR	MDB5351778.1	2026780	g20638	i0	77.1	0.42	35	8	42	0	1	105	47	81	MDB5351778.1 hypothetical protein [Planctomycetota bacterium]	diamond	105	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27952142	27952142	PRJNA1104180_P_NODE_26305_length_241_cov_0.916667_g26162_i0	PRJNA1104180	26305	241	0.916667	2.20916747	Gemmataceae bacterium	2052164	Bacteria	Bacteria	100	5.61e-24	NR	MBY0528330.1	2052164	g26162	i0	61.5	3.88381742738589	78	30	97.1	0	236	3	14	91	MBY0528330.1 sugar phosphate isomerase/epimerase [Gemmataceae bacterium]	diamond	936	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28109827	28109827	PRJNA1104180_P_NODE_18585_length_258_cov_1.637838_g18443_i0	PRJNA1104180	18585	258	1.637838	4.22562204	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	123	4e-34	NR	MBP7074924.1	2047756	g18443	i0	86.8	0.790697674418605	68	9	79.1	0	2	205	52	119	MBP7074924.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase [Rhabdochlamydiaceae bacterium]	diamond	204	123	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28204503	28204503	PRJNA1104180_P_NODE_18126_length_260_cov_3.074866_g17984_i0	PRJNA1104180	18126	260	3.074866	7.9946516	Urbifossiella sp.	2807431	Bacteria	Bacteria	98.6	1.05e-21	NR	HYH68589.1	2807431	g17984	i0	58.1	0.992307692307692	86	36	99.2	0	259	2	217	302	HYH68589.1 hypothetical protein [Urbifossiella sp.]	diamond	258	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
28488917	28488917	PRJNA1104180_P_NODE_13727_length_285_cov_1.226415_g13585_i0	PRJNA1104180	13727	285	1.226415	3.49528275	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	64.3	3.69e-10	NR	HEY0009252.1	2876886	g13585	i0	60.3	0.610526315789474	58	22	60	1	110	280	7	64	HEY0009252.1 F0F1 ATP synthase subunit B [Tepidisphaeraceae bacterium]	diamond	174	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28741466	28741466	PRJNA1104180_P_NODE_14707_length_279_cov_1.417476_g14565_i0	PRJNA1104180	14707	279	1.417476	3.95475804	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	134	5.42e-35	NR	MFM9956678.1	2052180	g14565	i0	65.2	0.989247311827957	92	32	98.9	0	277	2	225	316	MFM9956678.1 hypothetical protein [Phycisphaerales bacterium]	diamond	276	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28741469	28741469	PRJNA1104180_P_NODE_22727_length_247_cov_0.885057_g22584_i0	PRJNA1104180	22727	247	0.885057	2.18609079	Limisphaerales bacterium	2052186	Bacteria	Bacteria	62.4	4.76e-9	NR	MCC6820064.1	2052186	g22584	i0	63	0.558704453441296	46	17	55.9	0	139	2	1	46	MCC6820064.1 MMPL family transporter [Limisphaerales bacterium]	diamond	138	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29088842	29088842	PRJNA1104180_P_NODE_17628_length_263_cov_1.621053_g17486_i0	PRJNA1104180	17628	263	1.621053	4.26336939	Planctomycetota bacterium	2026780	Bacteria	Bacteria	162	1.05e-45	NR	MBI5763009.1	2026780	g17486	i0	94.3	0.992395437262357	87	5	99.2	0	1	261	285	371	MBI5763009.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Planctomycetota bacterium]	diamond	261	162	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29088843	29088843	PRJNA1104180_P_NODE_19008_length_256_cov_1.683060_g18866_i0	PRJNA1104180	19008	256	1.68306	4.3086336	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.6	1.64e-11	NR	TVQ60296.1	2052180	g18866	i0	48.7	0.890625	76	39	89.1	0	230	3	179	254	TVQ60296.1 MAG: hypothetical protein EA379_08410 [Phycisphaerales bacterium]	diamond	228	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29120566	29120566	PRJNA1104180_P_NODE_21649_length_249_cov_0.875000_g21506_i0	PRJNA1104180	21649	249	0.875	2.17875	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	114	3e-28	NR	HVP11818.1	2026778	g21506	i0	58.5	0.987951807228916	82	34	98.8	0	3	248	197	278	HVP11818.1 hypothetical protein [Phycisphaerae bacterium]	diamond	246	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29152290	29152290	PRJNA1104180_P_NODE_18529_length_258_cov_2.021622_g18387_i0	PRJNA1104180	18529	258	2.021622	5.21578476	Gemmataceae bacterium	2052164	Bacteria	Bacteria	77	3.23e-14	NR	HKB38071.1	2052164	g18387	i0	68.4	1.96511627906977	57	18	66.3	0	173	3	296	352	HKB38071.1 IS110 family transposase [Gemmataceae bacterium]	diamond	507	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29499151	29499151	PRJNA1104180_P_NODE_22950_length_246_cov_1.780347_g22807_i0	PRJNA1104180	22950	246	1.780347	4.37965362	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	3.8199999999999995e-30	NR	MFO0808267.1	2052164	g22807	i0	69.1	5.92682926829268	81	25	98.8	0	243	1	874	954	MFO0808267.1 hypothetical protein [Gemmataceae bacterium]	diamond	1458	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29688379	29688379	PRJNA1104180_P_NODE_25910_length_242_cov_0.911243_g25767_i0	PRJNA1104180	25910	242	0.911243	2.20520806	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	42.4	0.0491	NR	HUO07241.1	2026778	g25767	i0	51.3	0.483471074380165	39	17	48.3	2	60	176	299	335	HUO07241.1 radical SAM family heme chaperone HemW [Phycisphaerae bacterium]	diamond	117	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29783344	29783344	PRJNA1104180_P_NODE_23831_length_245_cov_0.895349_g23688_i0	PRJNA1104180	23831	245	0.895349	2.19360505	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	126	1.3599999999999999e-34	NR	HLQ04515.1	2499141	g23688	i0	75.3	3.96734693877551	81	20	99.2	0	245	3	100	180	HLQ04515.1 glycosyltransferase family 2 protein [Verrucomicrobiia bacterium]	diamond	972	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29806134	29806134	PRJNA1104180_P_NODE_25231_length_243_cov_0.905882_g25088_i0	PRJNA1104180	25231	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	73.2	6.97e-13	NR	MBM3981799.1	2026780	g25088	i0	61.5	1.34567901234568	52	20	64.2	0	158	3	490	541	MBM3981799.1 hypothetical protein [Planctomycetota bacterium]	diamond	327	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30193956	30193956	PRJNA1104180_P_NODE_22552_length_247_cov_0.885057_g22409_i0	PRJNA1104180	22552	247	0.885057	2.18609079	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	75.5	1.16e-13	NR	HEY1683259.1	2876886	g22409	i0	59.3	1.4331983805668	59	22	69.2	1	72	242	2077	2135	HEY1683259.1 Ig-like domain-containing protein [Tepidisphaeraceae bacterium]	diamond	354	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30636204	30636204	PRJNA1104180_P_NODE_20433_length_251_cov_0.865169_g20290_i0	PRJNA1104180	20433	251	0.865169	2.17157419	Paludisphaera soli	2712865	Bacteria	Bacteria	69.3	1.81e-11	NR	WP_165246447.1	2712865	g20290	i0	42.1	0.908366533864542	76	44	90.8	0	246	19	292	367	WP_165246447.1 hypothetical protein [Paludisphaera soli]	diamond	228	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera soli
30722375	30722375	PRJNA1104180_P_NODE_25934_length_242_cov_0.911243_g25791_i0	PRJNA1104180	25934	242	0.911243	2.20520806	PVC group	1783257	Bacteria	Bacteria	131	4.17e-36	NR	MCU0713500.1	117	g25791	i0	82.5	15.8677685950413	80	14	99.2	0	242	3	17	96	MCU0713500.1 hypothetical protein [Pirellula sp.]	diamond	3840	132	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
31458313	31458313	PRJNA1104180_P_NODE_24656_length_244_cov_0.900585_g24513_i0	PRJNA1104180	24656	244	0.900585	2.1974274	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	55.8	5.16e-7	NR	MBX3396730.1	2026778	g24513	i0	61.5	0.983606557377049	39	14	46.7	1	243	130	183	221	MBX3396730.1 hypothetical protein [Phycisphaerae bacterium]	diamond	240	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31616291	31616291	PRJNA1104180_P_NODE_25916_length_242_cov_0.911243_g25773_i0	PRJNA1104180	25916	242	0.911243	2.20520806	Opitutaceae bacterium	2006848	Bacteria	Bacteria	110	3.9e-26	NR	MBL9213358.1	2006848	g25773	i0	65	0.991735537190083	80	28	99.2	0	3	242	452	531	MBL9213358.1 hypothetical protein [Opitutaceae bacterium]	diamond	240	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31765697	31765697	PRJNA1104180_P_NODE_25597_length_242_cov_0.911243_g25454_i0	PRJNA1104180	25597	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	135	6.609999999999998e-35	NR	MFO0936574.1	2052164	g25454	i0	78.8	1.98347107438017	80	17	99.2	0	240	1	523	602	MFO0936574.1 DUF1553 domain-containing protein [Gemmataceae bacterium]	diamond	480	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31860458	31860458	PRJNA1104180_P_NODE_22037_length_248_cov_0.880000_g21894_i0	PRJNA1104180	22037	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	171	3.81e-50	NR	MEO6034882.1	2026799	g21894	i0	92.7	4.95967741935484	82	6	99.2	0	1	246	196	277	MEO6034882.1 NAD-dependent epimerase/dehydratase family protein [Verrucomicrobiota bacterium]	diamond	1230	172	0.994186046511628	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32113872	32113872	PRJNA1104180_P_NODE_15718_length_273_cov_1.795000_g15576_i0	PRJNA1104180	15718	273	1.795	4.90035	Fimbriiglobus	1914234	Bacteria	Bacteria	115	1.05e-27	NR	HET6571956.1	1914235	g15576	i0	68.8	1.75824175824176	80	25	87.9	0	246	7	1	80	HET6571956.1 hypothetical protein [Fimbriiglobus sp.]	diamond	480	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
32217458	32217458	PRJNA1104180_P_NODE_18798_length_257_cov_1.668478_g18656_i0	PRJNA1104180	18798	257	1.668478	4.28798846	Pirellulaceae	2691357	Bacteria	Bacteria	120	5.739999999999999e-31	NR	WP_105332975.1	2691357	g18656	i0	65.9	0.992217898832685	85	29	99.2	0	256	2	37	121	WP_105332975.1 MULTISPECIES: exosortase/archaeosortase family protein [Pirellulaceae]	diamond	255	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae
32249411	32249411	PRJNA1104180_P_NODE_27198_length_233_cov_3.593750_g27055_i0	PRJNA1104180	27198	233	3.59375	8.3734375	Paludisphaera mucosa	3030827	Bacteria	Bacteria	67.4	6.54e-11	NR	WP_277859545.1	3030827	g27055	i0	58.4	1.99570815450644	77	29	99.1	1	231	1	368	441	WP_277859545.1 heavy metal-binding domain-containing protein [Paludisphaera mucosa]	diamond	465	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera mucosa
32691288	32691288	PRJNA1104180_P_NODE_20260_length_251_cov_0.865169_g20117_i0	PRJNA1104180	20260	251	0.865169	2.17157419	Gemmataceae bacterium	2052164	Bacteria	Bacteria	139	9.11e-38	NR	MBX9581843.1	2052164	g20117	i0	81.9	0.99203187250996006	83	15	99.2	0	251	3	129	211	MBX9581843.1 carbohydrate kinase [Gemmataceae bacterium]	diamond	249	139	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);;