metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA879221" 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
857290	857290	PRJNA879221_P_NODE_59621_length_243_cov_1.694118_g59481_i0	PRJNA879221	59621	243	1.694118	4.11670674	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	112	8.410000000000001e-27	NR	MEQ1850051.1	2811408	g59481	i0	66.3	0.987654320987654	80	27	98.8	0	241	2	1286	1365	MEQ1850051.1 MG2 domain-containing protein [Chthoniobacteraceae bacterium]	diamond	240	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
3408005	3408005	PRJNA879221_P_NODE_53903_length_247_cov_0.885057_g53763_i0	PRJNA879221	53903	247	0.885057	2.18609079	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	147	8.77e-39	NR	HMP76893.1	2212473	g53763	i0	92.7	9.95951417004049	82	6	99.6	0	247	2	914	995	HMP76893.1 type I restriction endonuclease subunit R [Kiritimatiellia bacterium]	diamond	2460	147	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
8510121	8510121	PRJNA879221_P_NODE_54727_length_246_cov_0.890173_g54587_i0	PRJNA879221	54727	246	0.890173	2.18982558	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72.4	1.27e-12	NR	MCA9286879.1	2052180	g54587	i0	52.6	2.8780487804878	76	34	90.2	1	23	244	316	391	MCA9286879.1 DUF418 domain-containing protein [Phycisphaerales bacterium]	diamond	708	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
11060662	11060662	PRJNA879221_P_NODE_38509_length_281_cov_1.360577_g38369_i0	PRJNA879221	38509	281	1.360577	3.82322137	Gemmataceae bacterium	2052164	Bacteria	Bacteria	150	1.22e-41	NR	MFO0966402.1	2052164	g38369	i0	89.4	2.71174377224199	85	9	90.7	0	1	255	86	170	MFO0966402.1 FAD-binding protein [Gemmataceae bacterium]	diamond	762	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25083419	25083419	PRJNA879221_P_NODE_6920_length_709_cov_8.594340_g6789_i0	PRJNA879221	6920	709	8.59434	60.9338706	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	201	2.0399999999999997e-57	NR	MDX1947833.1	2699754	g6789	i0	60.7	0.634696755994358	150	59	63.5	0	689	240	208	357	MDX1947833.1 DUF3386 family protein [Pirellulaceae bacterium]	diamond	450	201	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
26865723	26865723	PRJNA879221_P_NODE_56021_length_246_cov_0.872832_g55881_i0	PRJNA879221	56021	246	0.872832	2.14716672	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	117	7.66e-29	NR	MES2466076.1	2026799	g55881	i0	71.6	0.98780487804878	81	23	98.8	0	245	3	137	217	MES2466076.1 O-antigen ligase family protein [Verrucomicrobiota bacterium]	diamond	243	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27086975	27086975	PRJNA879221_P_NODE_22402_length_373_cov_1.026667_g22262_i0	PRJNA879221	22402	373	1.026667	3.82946791	Chlamydiales bacterium	2047757	Bacteria	Bacteria	49.3	5.22e-4	NR	MCC5833030.1	2047757	g22262	i0	45.8	0.386058981233244	48	24	38.6	1	356	213	184	229	MCC5833030.1 DUF3820 family protein [Chlamydiales bacterium]	diamond	144	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27308340	27308340	PRJNA879221_P_NODE_57123_length_245_cov_0.895349_g56983_i0	PRJNA879221	57123	245	0.895349	2.19360505	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	129	7.09e-33	NR	MDB6071178.1	2026801	g56983	i0	90.1	0.991836734693878	81	8	99.2	0	1	243	294	374	MDB6071178.1 glxR 1 [Verrucomicrobiales bacterium]	diamond	243	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27852920	27852920	PRJNA879221_P_NODE_57044_length_245_cov_0.895349_g56904_i0	PRJNA879221	57044	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	165	1.78e-49	NR	MBP3406883.1	2212473	g56904	i0	100	1.98367346938776	81	0	99.2	0	2	244	114	194	MBP3406883.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	486	165	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28516132	28516132	PRJNA879221_P_NODE_37427_length_286_cov_1.192488_g37287_i0	PRJNA879221	37427	286	1.192488	3.41051568	Bacteria	2	Bacteria	Bacteria	133	1.05e-33	NR	MFM2199721.1	2026799	g37287	i0	61.7	1.96153846153846	94	36	98.6	0	284	3	77	170	MFM2199721.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	561	133	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28666037	28666037	PRJNA879221_P_NODE_51547_length_248_cov_0.880000_g51407_i0	PRJNA879221	51547	248	0.88	2.1824	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	43.1	0.0287	NR	MCP5541041.1	2562705	g51407	i0	82.6	0.278225806451613	23	4	27.8	0	40	108	524	546	MCP5541041.1 transposase [Akkermansiaceae bacterium]	diamond	69	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28799988	28799988	PRJNA879221_P_NODE_51067_length_248_cov_0.880000_g50927_i0	PRJNA879221	51067	248	0.88	2.1824	Lacunisphaera	1961799	Bacteria	Bacteria	116	1.59e-30	NR	HKB57571.1	1961806	g50927	i0	65.9	1.98387096774194	82	28	99.2	0	3	248	71	152	HKB57571.1 sigma-70 family RNA polymerase sigma factor [Lacunisphaera sp.]	diamond	492	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
28981867	28981867	PRJNA879221_P_NODE_53008_length_247_cov_0.885057_g52868_i0	PRJNA879221	53008	247	0.885057	2.18609079	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	85.1	4.27e-17	NR	MCU0780393.1	2562705	g52868	i0	48.1	2.95141700404858	81	42	98.4	0	245	3	113	193	MCU0780393.1 BamA/TamA family outer membrane protein [Akkermansiaceae bacterium]	diamond	729	85.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29116104	29116104	PRJNA879221_P_NODE_48788_length_250_cov_0.870056_g48648_i0	PRJNA879221	48788	250	0.870056	2.17514	Pirellulales	2691354	Bacteria	Bacteria	132	5.49e-35	NR	MBA4106052.1	117	g48648	i0	79.3	1.968	82	17	98.4	0	246	1	176	257	MBA4106052.1 hypothetical protein [Pirellula sp.]	diamond	492	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29423466	29423466	PRJNA879221_P_NODE_60589_length_243_cov_0.905882_g60449_i0	PRJNA879221	60589	243	0.905882	2.20129326	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	122	1.33e-33	NR	MEY4485144.1	2026799	g60449	i0	92.4	0.814814814814815	66	5	81.5	0	241	44	67	132	MEY4485144.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	198	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29549784	29549784	PRJNA879221_P_NODE_37630_length_285_cov_1.283019_g37490_i0	PRJNA879221	37630	285	1.283019	3.65660415	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	139	7.65e-36	NR	MBX3452621.1	2026779	g37490	i0	77.9	1	95	21	100	0	1	285	1211	1305	MBX3452621.1 autotransporter domain-containing protein [Planctomycetaceae bacterium]	diamond	285	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29612780	29612780	PRJNA879221_P_NODE_55210_length_246_cov_0.890173_g55070_i0	PRJNA879221	55210	246	0.890173	2.18982558	Verrucomicrobium sp.	72225	Bacteria	Bacteria	147	4.12e-41	NR	MEZ0389366.1	72225	g55070	i0	81.5	1.98780487804878	81	15	98.8	0	243	1	225	305	MEZ0389366.1 DUF3500 domain-containing protein [Verrucomicrobium sp.]	diamond	489	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp.
29897433	29897433	PRJNA879221_P_NODE_52891_length_247_cov_0.885057_g52751_i0	PRJNA879221	52891	247	0.885057	2.18609079	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	76.3	6.14e-14	NR	MCC7191929.1	2026777	g52751	i0	60.9	0.777327935222672	64	24	76.5	1	190	2	11	74	MCC7191929.1 iron-sulfur cluster-binding protein [Phycisphaeraceae bacterium]	diamond	192	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29992171	29992171	PRJNA879221_P_NODE_60711_length_243_cov_0.905882_g60571_i0	PRJNA879221	60711	243	0.905882	2.20129326	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	61.6	8.59e-9	NR	MCE9520108.1	2026799	g60571	i0	71.6	1	81	23	100	0	1	243	107	187	MCE9520108.1 chromosome segregation protein SMC [Verrucomicrobiota bacterium]	diamond	243	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30189610	30189610	PRJNA879221_P_NODE_60152_length_243_cov_0.905882_g60012_i0	PRJNA879221	60152	243	0.905882	2.20129326	Chlamydia	810	Bacteria	Bacteria	49.7	9.67e-6	NR	EPJ18665.1	1112258	g60012	i0	63.2	5.62962962962963	38	14	46.9	0	186	73	9	46	EPJ18665.1 hypothetical protein CP02DC22_1193, partial [Chlamydia psittaci 02DC22]	diamond	1368	49.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30750475	30750475	PRJNA879221_P_NODE_64594_length_241_cov_0.916667_g64454_i0	PRJNA879221	64594	241	0.916667	2.20916747	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	87.4	1.79e-19	NR	MEI6534364.1	2026800	g64454	i0	81.8	0.547717842323652	44	8	54.8	0	2	133	112	155	MEI6534364.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	132	87.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31003225	31003225	PRJNA879221_P_NODE_58814_length_244_cov_0.900585_g58674_i0	PRJNA879221	58814	244	0.900585	2.1974274	Pirellulales bacterium	2715253	Bacteria	Bacteria	68.9	2.32e-11	NR	HEV2970763.1	2715253	g58674	i0	62.1	0.811475409836066	66	25	81.1	0	199	2	1446	1511	HEV2970763.1 autotransporter-associated beta strand repeat-containing protein [Pirellulales bacterium]	diamond	198	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31003227	31003227	PRJNA879221_P_NODE_60034_length_243_cov_0.905882_g59894_i0	PRJNA879221	60034	243	0.905882	2.20129326	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	94	3.24e-20	NR	MES2705122.1	2026799	g59894	i0	61.3	0.987654320987654	80	31	98.8	0	3	242	37	116	MES2705122.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	240	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31043121	31043121	PRJNA879221_P_NODE_59035_length_244_cov_0.900585_g58895_i0	PRJNA879221	59035	244	0.900585	2.1974274	Prosthecobacter	48463	Bacteria	Bacteria	151	6.85e-44	NR	WP_300932137.1	1965333	g58895	i0	92.6	1.99180327868852	81	6	99.6	0	2	244	54	134	WP_300932137.1 HpcH/HpaI aldolase family protein [Prosthecobacter sp.]	diamond	486	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31319183	31319183	PRJNA879221_P_NODE_58275_length_244_cov_0.900585_g58135_i0	PRJNA879221	58275	244	0.900585	2.1974274	Gemmata sp.	1914242	Bacteria	Bacteria	71.2	3.47e-12	NR	MFM8272512.1	1914242	g58135	i0	53.8	3.84836065573771	78	36	95.9	0	5	238	227	304	MFM8272512.1 peptidylprolyl isomerase [Gemmata sp.]	diamond	939	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
31477522	31477522	PRJNA879221_P_NODE_50576_length_249_cov_0.875000_g50436_i0	PRJNA879221	50576	249	0.875	2.17875	Lacunisphaera sp.	1961806	Bacteria	Bacteria	135	9.779999999999996e-35	NR	HEX7631115.1	1961806	g50436	i0	84.1	0.987951807228916	82	13	98.8	0	3	248	510	591	HEX7631115.1 L-glutamate gamma-semialdehyde dehydrogenase [Lacunisphaera sp.]	diamond	246	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
31477528	31477528	PRJNA879221_P_NODE_61716_length_242_cov_0.911243_g61576_i0	PRJNA879221	61716	242	0.911243	2.20520806	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	147	1.02e-39	NR	MEY4484604.1	2026799	g61576	i0	98.8	0.991735537190083	80	1	99.2	0	3	242	483	562	MEY4484604.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	240	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31635451	31635451	PRJNA879221_P_NODE_46976_length_251_cov_0.865169_g46836_i0	PRJNA879221	46976	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	58.2	5.85e-9	NR	MCX6873948.1	2026799	g46836	i0	96.4	0.334661354581673	28	1	33.5	0	168	251	1	28	MCX6873948.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	84	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32078395	32078395	PRJNA879221_P_NODE_57378_length_245_cov_0.895349_g57238_i0	PRJNA879221	57378	245	0.895349	2.19360505	Prosthecobacter sp.	1965333	Bacteria	Bacteria	87.8	7.790000000000001e-21	NR	MDP1587501.1	1965333	g57238	i0	87.5	0.587755102040816	48	6	58.8	0	245	102	18	65	MDP1587501.1 CsbD family protein [Prosthecobacter sp.]	diamond	144	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32205043	32205043	PRJNA879221_P_NODE_46018_length_251_cov_0.865169_g45878_i0	PRJNA879221	46018	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	158	6.63e-48	NR	MEY4485222.1	2026799	g45878	i0	85.5	0.99203187250996006	83	12	99.2	0	251	3	1	83	MEY4485222.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	249	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32363412	32363412	PRJNA879221_P_NODE_42559_length_264_cov_1.356021_g42419_i0	PRJNA879221	42559	264	1.356021	3.57989544	Candidatus Scalindua sediminis	2798304	Bacteria	Bacteria	174	3.07e-52	NR	MEE9260883.1	2798304	g42419	i0	94.3	0.988636363636364	87	5	98.9	0	3	263	126	212	MEE9260883.1 glycosyltransferase family 2 protein [Candidatus Scalindua sediminis]	diamond	261	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sediminis
32489929	32489929	PRJNA879221_P_NODE_44399_length_256_cov_2.174863_g44259_i0	PRJNA879221	44399	256	2.174863	5.56764928	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	99	1.57e-24	NR	HEX5471700.1	2691534	g44259	i0	69.2	1.58203125	65	20	76.2	0	1	195	57	121	HEX5471700.1 type II toxin-antitoxin system RelE/ParE family toxin [Lacipirellulaceae bacterium]	diamond	405	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
32804936	32804936	PRJNA879221_P_NODE_51240_length_248_cov_0.880000_g51100_i0	PRJNA879221	51240	248	0.88	2.1824	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.2	4.51e-11	NR	MES2709103.1	2026799	g51100	i0	45.9	0.895161290322581	74	35	83.5	1	42	248	1297	1370	MES2709103.1 RHS repeat-associated core domain-containing protein [Verrucomicrobiota bacterium]	diamond	222	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;