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

33 rows where analysis = "diamond", bioproject = "PRJNA781196" 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
26895503	26895503	PRJNA781196_P_NODE_27461_length_332_cov_1.204633_g27084_i0	PRJNA781196	27461	332	1.204633	3.99938156	Pirellulales bacterium	2715253	Bacteria	Bacteria	66.2	1.2e-10	NR	HEY2828245.1	2715253	g27084	i0	40.4	0.984939759036145	109	59	97.6	4	326	3	27	130	HEY2828245.1 hypothetical protein [Pirellulales bacterium]	diamond	327	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
26895528	26895528	PRJNA781196_P_NODE_55281_length_250_cov_0.881356_g54904_i0	PRJNA781196	55281	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.8	5.56e-5	NR	MEM8678322.1	2026780	g54904	i0	43.7	0.852	71	38	85.2	2	227	15	210	278	MEM8678322.1 putative Ig domain-containing protein [Planctomycetota bacterium]	diamond	213	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27062873	27062873	PRJNA781196_P_NODE_51662_length_252_cov_0.871508_g51285_i0	PRJNA781196	51662	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	93.6	2.35e-21	NR	MBA4032721.1	37635	g51285	i0	57.1	2	84	33	100	1	1	252	110	190	MBA4032721.1 NAD-dependent protein deacetylase [Planctomyces sp.]	diamond	504	93.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
27347557	27347557	PRJNA781196_P_NODE_41283_length_279_cov_1.135922_g40906_i0	PRJNA781196	41283	279	1.135922	3.16922238	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	2.13e-12	NR	NLX60820.1	2026778	g40906	i0	46.3	5.87096774193548	82	41	84.9	1	40	276	93	174	NLX60820.1 hydroxylamine reductase [Phycisphaerae bacterium]	diamond	1638	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27464500	27464500	PRJNA781196_P_NODE_7343_length_578_cov_0.792079_g6969_i0	PRJNA781196	7343	578	0.792079	4.57821662	Pirellula sp.	117	Bacteria	Bacteria	53.5	1.45e-4	NR	MFM7931657.1	117	g6969	i0	40.8	1.5259515570934301	98	53	49.8	3	288	1	14	108	MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.]	diamond	882	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27590841	27590841	PRJNA781196_P_NODE_46924_length_261_cov_1.659574_g46547_i0	PRJNA781196	46924	261	1.659574	4.33148814	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	120	1.15e-29	NR	HUO08880.1	2026778	g46547	i0	65.5	1.85057471264368	84	29	96.6	0	260	9	98	181	HUO08880.1 phosphoenolpyruvate carboxykinase (GTP) [Phycisphaerae bacterium]	diamond	483	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27780229	27780229	PRJNA781196_P_NODE_63484_length_244_cov_0.912281_g63107_i0	PRJNA781196	63484	244	0.912281	2.22596564	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	77.4	2.33e-14	NR	MDA7930803.1	2562705	g63107	i0	50.6	8.11475409836066	77	37	94.7	1	3	233	22	97	MDA7930803.1 ubiquitin-like protein [Akkermansiaceae bacterium]	diamond	1980	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
27938039	27938039	PRJNA781196_P_NODE_3985_length_765_cov_1.127168_g3648_i0	PRJNA781196	3985	765	1.127168	8.6228352	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.9	0.016	NR	MBC8351023.1	2026780	g3648	i0	29.3	0.682352941176471	174	109	67.1	7	602	90	182	344	MBC8351023.1 DUF11 domain-containing protein [Planctomycetota bacterium]	diamond	522	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28001276	28001276	PRJNA781196_P_NODE_52225_length_252_cov_0.871508_g51848_i0	PRJNA781196	52225	252	0.871508	2.19620016	Urbifossiella sp.	2807431	Bacteria	Bacteria	81.3	3.25e-17	NR	HEY3788008.1	2807431	g51848	i0	56.5	1.38095238095238	62	27	73.8	0	186	1	6	67	HEY3788008.1 sulfatase-like hydrolase/transferase [Urbifossiella sp.]	diamond	348	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
28127487	28127487	PRJNA781196_P_NODE_4265_length_740_cov_3.152924_g3919_i0	PRJNA781196	4265	740	3.152924	23.3316376	Planctomycetales bacterium	2053591	Bacteria	Bacteria	58.5	8.98e-6	NR	MCA9175273.1	2053591	g3919	i0	32	1.01351351351351	122	76	46.6	2	80	424	212	333	MCA9175273.1 DUF11 domain-containing protein [Planctomycetales bacterium]	diamond	750	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
28768159	28768159	PRJNA781196_P_NODE_22707_length_358_cov_2.185965_g22330_i0	PRJNA781196	22707	358	2.185965	7.8257547	root	1	Root_unresolved	Root_unresolved	45.1	0.0181	NR	KAB2939565.1	2026778	g22330	i0	41.3	0.846368715083799	46	26	37.7	1	218	84	190	235	KAB2939565.1 MAG: hypothetical protein F9K17_14965 [Phycisphaerae bacterium]	diamond	303	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29011771	29011771	PRJNA781196_P_NODE_25288_length_343_cov_1.722222_g24911_i0	PRJNA781196	25288	343	1.722222	5.90722146	Phragmitibacter flavus	2576071	Bacteria	Bacteria	48.1	0.00139	NR	WP_138088455.1	2576071	g24911	i0	29.9	1.02332361516035	117	63	97.1	3	337	5	3	106	WP_138088455.1 hypothetical protein [Phragmitibacter flavus]	diamond	351	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Phragmitibacter	Phragmitibacter flavus
29295609	29295609	PRJNA781196_P_NODE_45969_length_264_cov_1.528796_g45592_i0	PRJNA781196	45969	264	1.528796	4.03602144	Opitutaceae bacterium	2006848	Bacteria	Bacteria	83.6	3.71e-17	NR	HEX9784778.1	2006848	g45592	i0	70.5	0.693181818181818	61	18	69.3	0	185	3	1	61	HEX9784778.1 pantoate--beta-alanine ligase [Opitutaceae bacterium]	diamond	183	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29358840	29358840	PRJNA781196_P_NODE_47169_length_260_cov_2.085561_g46792_i0	PRJNA781196	47169	260	2.085561	5.4224586	Allorhodopirellula heiligendammensis	2714739	Bacteria	Bacteria	49.7	1.59e-4	NR	WP_146406538.1	2714739	g46792	i0	42.7	0.865384615384615	75	38	86.5	2	32	256	47	116	WP_146406538.1 putative glycoside hydrolase [Allorhodopirellula heiligendammensis]	diamond	225	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Allorhodopirellula	Allorhodopirellula heiligendammensis
29778534	29778534	PRJNA781196_P_NODE_51751_length_252_cov_0.871508_g51374_i0	PRJNA781196	51751	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	121	2.3699999999999997e-30	NR	QDU66963.1	2528011	g51374	i0	69.1	10.3452380952381	81	25	96.4	0	10	252	130	210	QDU66963.1 Sulfoacetaldehyde dehydrogenase [Planctomycetes bacterium Pla133]	diamond	2607	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
29958746	29958746	PRJNA781196_P_NODE_6591_length_607_cov_1.215356_g6220_i0	PRJNA781196	6591	607	1.215356	7.37721092	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	92.4	9.35e-18	NR	MCU0772034.1	2026799	g6220	i0	36.1	0.958813838550247	194	102	95.4	8	17	595	526	698	MCU0772034.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	582	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30274937	30274937	PRJNA781196_P_NODE_2992_length_866_cov_2.253468_g2689_i0	PRJNA781196	2992	866	2.253468	19.51503288	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.9	2.81e-11	NR	MCA9086382.1	2026779	g2689	i0	32.1	0.540415704387991	156	104	53.3	2	842	381	187	342	MCA9086382.1 DUF11 domain-containing protein [Planctomycetaceae bacterium]	diamond	468	75.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30306790	30306790	PRJNA781196_P_NODE_62672_length_245_cov_0.906977_g62295_i0	PRJNA781196	62672	245	0.906977	2.22209365	Planctopirus ephydatiae	2528019	Bacteria	Bacteria	142	1.52e-39	NR	WP_186377815.1	2528019	g62295	i0	82.5	0.979591836734694	80	14	98	0	6	245	93	172	WP_186377815.1 cyanophycinase [Planctopirus ephydatiae]	diamond	240	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
30338336	30338336	PRJNA781196_P_NODE_45712_length_265_cov_1.218750_g45335_i0	PRJNA781196	45712	265	1.21875	3.2296875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	114	2.39e-28	NR	GIW72247.1	2026780	g45335	i0	64.4	1.96981132075472	87	31	98.5	0	262	2	129	215	GIW72247.1 MAG: hypothetical protein KatS3mg102_1789 [Planctomycetota bacterium]	diamond	522	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30401555	30401555	PRJNA781196_P_NODE_63993_length_244_cov_0.912281_g63616_i0	PRJNA781196	63993	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.4	6.79e-5	NR	MCH7573464.1	2026780	g63616	i0	37.3	0.823770491803279	67	42	82.4	0	9	209	267	333	MCH7573464.1 ankyrin repeat domain-containing protein [Planctomycetota bacterium]	diamond	201	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30685303	30685303	PRJNA781196_P_NODE_45733_length_265_cov_1.218750_g45356_i0	PRJNA781196	45733	265	1.21875	3.2296875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.2	2.59e-22	NR	MDA1142300.1	2026780	g45356	i0	62.7	1.69811320754717	75	26	84.9	1	13	237	160	232	MDA1142300.1 TIM barrel protein [Planctomycetota bacterium]	diamond	450	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30789581	30789581	PRJNA781196_P_NODE_4214_length_744_cov_1.988077_g3870_i0	PRJNA781196	4214	744	1.988077	14.79129288	PVC group	1783257	Bacteria	Bacteria	53.5	3.46e-4	NR	MBN8603554.1	2026780	g3870	i0	33.1	1.49193548387097	121	76	47.6	4	728	375	212	330	MBN8603554.1 hypothetical protein [Planctomycetota bacterium]	diamond	1110	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31096069	31096069	PRJNA781196_P_NODE_27255_length_333_cov_1.200000_g26878_i0	PRJNA781196	27255	333	1.2	3.996	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.9	1.2e-5	NR	MCU0862381.1	2026780	g26878	i0	36.9	4.77477477477477	65	35	58.6	1	238	44	55	113	MCU0862381.1 hypothetical protein [Planctomycetota bacterium]	diamond	1590	53.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31412342	31412342	PRJNA781196_P_NODE_12776_length_456_cov_1.629243_g12399_i0	PRJNA781196	12776	456	1.629243	7.42934808	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.2	2.87e-15	NR	PYJ08782.1	2026799	g12399	i0	42.4	1.98026315789474	139	69	89.5	3	452	45	156	286	PYJ08782.1 MAG: hypothetical protein DME25_00550 [Verrucomicrobiota bacterium]	diamond	903	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31665297	31665297	PRJNA781196_P_NODE_62277_length_245_cov_0.906977_g61900_i0	PRJNA781196	62277	245	0.906977	2.22209365	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	69.3	1.5e-11	NR	MCE5279461.1	2026779	g61900	i0	40.5	0.96734693877551	79	41	96.7	2	7	243	69	141	MCE5279461.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	237	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31823376	31823376	PRJNA781196_P_NODE_26857_length_335_cov_1.190840_g26480_i0	PRJNA781196	26857	335	1.19084	3.989314	Planctomycetes bacterium SV_7m_r	2528025	Bacteria	Bacteria	46.2	0.00661	NR	QDT61455.1	2528025	g26480	i0	36.6	1.71044776119403	93	54	80.6	3	306	37	116	206	QDT61455.1 Serine/threonine-protein kinase PrkC [Planctomycetes bacterium SV_7m_r]	diamond	573	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
32108231	32108231	PRJNA781196_P_NODE_10358_length_498_cov_1.503529_g9982_i0	PRJNA781196	10358	498	1.503529	7.48757442	Rosistilla carotiformis	2528017	Bacteria	Bacteria	61.2	1.89e-7	NR	WP_145100387.1	2528017	g9982	i0	33.8	2.44578313253012	133	82	79.5	4	98	493	153	280	WP_145100387.1 DUF11 domain-containing protein [Rosistilla carotiformis]	diamond	1218	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla carotiformis
32235192	32235192	PRJNA781196_P_NODE_59358_length_247_cov_0.896552_g58981_i0	PRJNA781196	59358	247	0.896552	2.21448344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	99.4	4.22e-22	NR	HAB15996.1	2026801	g58981	i0	77.6	1.44534412955466	58	13	70.4	0	1	174	481	538	HAB15996.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	357	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32488144	32488144	PRJNA781196_P_NODE_51559_length_252_cov_0.871508_g51182_i0	PRJNA781196	51559	252	0.871508	2.19620016	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	96.7	6.01e-22	NR	MBZ0172664.1	2052180	g51182	i0	55.6	1.95238095238095	81	34	94	1	8	244	183	263	MBZ0172664.1 hypothetical protein [Phycisphaerales bacterium]	diamond	492	96.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32497561	32497561	PRJNA781196_P_NODE_54279_length_250_cov_1.237288_g53902_i0	PRJNA781196	54279	250	1.237288	3.09322	Bacteria	2	Bacteria	Bacteria	83.2	2.37e-16	NR	MBK8098326.1	2026780	g53902	i0	51.2	3.948	82	38	98.4	1	1	246	181	260	MBK8098326.1 S9 family peptidase [Planctomycetota bacterium]	diamond	987	83.6	0.995215311004785	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32614302	32614302	PRJNA781196_P_NODE_4520_length_721_cov_1.231481_g4163_i0	PRJNA781196	4520	721	1.231481	8.87897801	Planctomycetota bacterium	2026780	Bacteria	Bacteria	74.7	2.66e-11	NR	MEY2612968.1	2026780	g4163	i0	28.2	0.869625520110957	209	137	83.6	5	35	637	132	335	MEY2612968.1 Large cysteine-rich periplasmic protein omcB precursor [Planctomycetota bacterium]	diamond	627	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32708713	32708713	PRJNA781196_P_NODE_62000_length_245_cov_0.906977_g61623_i0	PRJNA781196	62000	245	0.906977	2.22209365	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	132	2.57e-35	NR	MES2595503.1	2026799	g61623	i0	81.5	1.98367346938776	81	15	99.2	0	1	243	9	89	MES2595503.1 ABC transporter substrate-binding protein [Verrucomicrobiota bacterium]	diamond	486	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32740433	32740433	PRJNA781196_P_NODE_52340_length_252_cov_0.871508_g51963_i0	PRJNA781196	52340	252	0.871508	2.19620016	Victivallis vadensis	172901	Bacteria	Bacteria	43.1	0.0301	NR	WP_276739735.1	172901	g51963	i0	39.6	1.26190476190476	53	25	57.1	2	191	48	195	245	WP_276739735.1 DUF4962 domain-containing protein [Victivallis vadensis]	diamond	318	43.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis vadensis

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