metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA782235" 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
23715999	23715999	PRJNA782235_P_NODE_11599_length_279_cov_1.339806_g11410_i0	PRJNA782235	11599	279	1.339806	3.73805874	Planctomycetota bacterium	2026780	Bacteria	Bacteria	135	2.7199999999999997e-35	NR	MDX2116694.1	2026780	g11410	i0	73.9	1.97849462365591	92	24	98.9	0	3	278	218	309	MDX2116694.1 histidine ammonia-lyase [Planctomycetota bacterium]	diamond	552	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27147984	27147984	PRJNA782235_P_NODE_26882_length_242_cov_0.911243_g26693_i0	PRJNA782235	26882	242	0.911243	2.20520806	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	114	3.2200000000000004e-27	NR	WP_213499323.1	1123043	g26693	i0	64.6	0.979338842975207	79	28	97.9	0	237	1	372	450	WP_213499323.1 hypothetical protein [Telmatocola sphagniphila]	diamond	237	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
27211426	27211426	PRJNA782235_P_NODE_11762_length_278_cov_1.331707_g11573_i0	PRJNA782235	11762	278	1.331707	3.70214546	Prosthecobacter debontii	48467	Bacteria	Bacteria	76.6	5.68e-14	NR	WP_078815981.1	48467	g11573	i0	44.6	2.97841726618705	92	51	99.3	0	278	3	152	243	WP_078815981.1 PfkB family carbohydrate kinase [Prosthecobacter debontii]	diamond	828	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
27496066	27496066	PRJNA782235_P_NODE_19683_length_248_cov_0.880000_g19494_i0	PRJNA782235	19683	248	0.88	2.1824	Pirellulales bacterium	2715253	Bacteria	Bacteria	164	1.44e-46	NR	MFO1062990.1	2715253	g19494	i0	91.5	3.96774193548387	82	7	99.2	0	3	248	114	195	MFO1062990.1 DUF1501 domain-containing protein [Pirellulales bacterium]	diamond	984	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27874826	27874826	PRJNA782235_P_NODE_18645_length_249_cov_0.875000_g18456_i0	PRJNA782235	18645	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	137	1.5599999999999998e-35	NR	MFM1801074.1	2026780	g18456	i0	74.7	1	83	21	100	0	249	1	182	264	MFM1801074.1 hypothetical protein [Planctomycetota bacterium]	diamond	249	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27938118	27938118	PRJNA782235_P_NODE_10345_length_287_cov_1.425234_g10156_i0	PRJNA782235	10345	287	1.425234	4.09042158	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	124	1.73e-32	NR	HJQ78398.1	2691534	g10156	i0	63	3.13588850174216	100	32	99.3	1	3	287	130	229	HJQ78398.1 alpha/beta fold hydrolase [Lacipirellulaceae bacterium]	diamond	900	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
28294585	28294585	PRJNA782235_P_NODE_12186_length_275_cov_1.524752_g11997_i0	PRJNA782235	12186	275	1.524752	4.193068	Parachlamydiales	1963360	Bacteria	Bacteria	138	1.58e-35	NR	WP_075882831.1	1785087	g11997	i0	71.7	7.78909090909091	92	25	99.3	1	3	275	697	788	WP_075882831.1 DNA topoisomerase (ATP-hydrolyzing) subunit A [Candidatus Protochlamydia sp. W-9]	diamond	2142	138	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
28727413	28727413	PRJNA782235_P_NODE_21967_length_246_cov_0.890173_g21778_i0	PRJNA782235	21967	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0344	NR	MBN8459160.1	2026799	g21778	i0	28.2	0.865853658536585	71	47	85.4	2	36	245	173	240	MBN8459160.1 CAAX prenyl protease-related protein [Verrucomicrobiota bacterium]	diamond	213	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28790404	28790404	PRJNA782235_P_NODE_18147_length_250_cov_0.870056_g17958_i0	PRJNA782235	18147	250	0.870056	2.17514	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	100	7.13e-24	NR	MBA3314692.1	2026779	g17958	i0	57.5	2.772	73	31	87.6	0	3	221	164	236	MBA3314692.1 ABC transporter permease [Planctomycetaceae bacterium]	diamond	693	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28948634	28948634	PRJNA782235_P_NODE_16368_length_251_cov_0.865169_g16179_i0	PRJNA782235	16368	251	0.865169	2.17157419	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	121	3.39e-32	NR	HEX6985633.1	2026779	g16179	i0	72	0.9800796812749	82	23	98	0	5	250	3	84	HEX6985633.1 tetratricopeptide repeat protein [Planctomycetaceae bacterium]	diamond	246	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29074907	29074907	PRJNA782235_P_NODE_25348_length_243_cov_0.905882_g25159_i0	PRJNA782235	25348	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	3.29e-12	NR	HYC78399.1	2026780	g25159	i0	54.3	1	81	33	98.8	2	3	242	231	308	HYC78399.1 integrin alpha [Planctomycetota bacterium]	diamond	243	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29241887	29241887	PRJNA782235_P_NODE_22849_length_246_cov_0.890173_g22660_i0	PRJNA782235	22849	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	136	3.4799999999999995e-35	NR	HNA62028.1	2047756	g22660	i0	77.8	7.90243902439024	81	18	98.8	0	245	3	125	205	HNA62028.1 transketolase [Rhabdochlamydiaceae bacterium]	diamond	1944	137	0.992700729927007	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29327186	29327186	PRJNA782235_P_NODE_24269_length_244_cov_0.900585_g24080_i0	PRJNA782235	24269	244	0.900585	2.1974274	Luteolibacter sp.	1962973	Bacteria	Bacteria	110	7.79e-29	NR	WP_348217506.1	1962973	g24080	i0	67.5	0.983606557377049	80	26	98.4	0	243	4	56	135	WP_348217506.1 DUF6157 family protein [Luteolibacter sp.]	diamond	240	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
29390564	29390564	PRJNA782235_P_NODE_14929_length_258_cov_1.762162_g14740_i0	PRJNA782235	14929	258	1.762162	4.54637796	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	86.7	7.23e-18	NR	HWE39371.1	2691532	g14740	i0	72.7	1.26744186046512	55	15	64	0	166	2	5	59	HWE39371.1 HTTM domain-containing protein [Isosphaeraceae bacterium]	diamond	327	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29927404	29927404	PRJNA782235_P_NODE_28531_length_241_cov_0.898810_g28342_i0	PRJNA782235	28531	241	0.89881	2.1661321	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	145	1.94e-41	NR	WP_317834364.1	3080537	g28342	i0	85.7	0.95850622406639	77	11	95.9	0	236	6	166	242	WP_317834364.1 response regulator transcription factor [Rubellicoccus peritrichatus]	diamond	231	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
29958806	29958806	PRJNA782235_P_NODE_26611_length_242_cov_0.911243_g26422_i0	PRJNA782235	26611	242	0.911243	2.20520806	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	101	6.16e-26	NR	HEX6986172.1	2026779	g26422	i0	78.7	0.756198347107438	61	13	75.6	0	59	241	27	87	HEX6986172.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	183	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30243297	30243297	PRJNA782235_P_NODE_21692_length_247_cov_0.885057_g21503_i0	PRJNA782235	21692	247	0.885057	2.18609079	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	46.2	0.00223	NR	MEI8195214.1	2026778	g21503	i0	50.9	0.668016194331984	55	23	63.2	2	163	8	94	147	MEI8195214.1 uracil-DNA glycosylase [Phycisphaerae bacterium]	diamond	165	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30780278	30780278	PRJNA782235_P_NODE_22334_length_246_cov_0.890173_g22145_i0	PRJNA782235	22334	246	0.890173	2.18982558	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	132	5.91e-35	NR	WP_317832957.1	3080537	g22145	i0	80.2	0.98780487804878	81	16	98.8	0	2	244	100	180	WP_317832957.1 peptidase [Rubellicoccus peritrichatus]	diamond	243	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
31001555	31001555	PRJNA782235_P_NODE_25234_length_243_cov_1.470588_g25045_i0	PRJNA782235	25234	243	1.470588	3.57352884	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	125	8.4e-33	NR	HET6249863.1	2876886	g25045	i0	68.8	2.96296296296296	80	25	98.8	0	3	242	85	164	HET6249863.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	720	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31074051	31074051	PRJNA782235_P_NODE_14955_length_258_cov_1.664865_g14766_i0	PRJNA782235	14955	258	1.664865	4.2953517	Bacteria	2	Bacteria	Bacteria	132	1.21e-34	NR	MBM3994809.1	2026780	g14766	i0	72.9	1.96511627906977	85	23	98.8	0	257	3	108	192	MBM3994809.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Planctomycetota bacterium]	diamond	507	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31855180	31855180	PRJNA782235_P_NODE_23117_length_245_cov_0.895349_g22928_i0	PRJNA782235	23117	245	0.895349	2.19360505	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	71.6	7.14e-13	NR	HTJ73245.1	2499141	g22928	i0	45.7	0.991836734693878	81	42	99.2	2	2	244	54	132	HTJ73245.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	243	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31950051	31950051	PRJNA782235_P_NODE_20137_length_248_cov_0.880000_g19948_i0	PRJNA782235	20137	248	0.88	2.1824	Planctomycetota bacterium	2026780	Bacteria	Bacteria	126	1.0599999999999999e-34	NR	MFN7587940.1	2026780	g19948	i0	98.4	0.762096774193548	63	1	76.2	0	1	189	114	176	MFN7587940.1 RNA polymerase sigma factor [Planctomycetota bacterium]	diamond	189	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31981706	31981706	PRJNA782235_P_NODE_26898_length_242_cov_0.911243_g26709_i0	PRJNA782235	26898	242	0.911243	2.20520806	Pirellulales bacterium	2715253	Bacteria	Bacteria	103	3.94e-26	NR	MEX2168111.1	2715253	g26709	i0	59.5	1.83471074380165	74	30	91.7	0	3	224	58	131	MEX2168111.1 PIN domain-containing protein [Pirellulales bacterium]	diamond	444	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32076754	32076754	PRJNA782235_P_NODE_26178_length_243_cov_0.905882_g25989_i0	PRJNA782235	26178	243	0.905882	2.20129326	Rubritalea halochordaticola	714537	Bacteria	Bacteria	43.1	0.0105	NR	WP_346190057.1	714537	g25989	i0	56.7	0.703703703703704	30	13	37	0	90	1	1	30	WP_346190057.1 DUF2750 domain-containing protein [Rubritalea halochordaticola]	diamond	171	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea halochordaticola
32149435	32149435	PRJNA782235_P_NODE_21038_length_247_cov_0.885057_g20849_i0	PRJNA782235	21038	247	0.885057	2.18609079	Planctomycetia	203683	Bacteria	Bacteria	57.4	2.7e-7	NR	HEY2251909.1	2026779	g20849	i0	61.4	2.05263157894737	44	15	51	1	4	129	533	576	HEY2251909.1 NADPH-dependent assimilatory sulfite reductase hemoprotein subunit [Planctomycetaceae bacterium]	diamond	507	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32551622	32551622	PRJNA782235_P_NODE_19699_length_248_cov_0.880000_g19510_i0	PRJNA782235	19699	248	0.88	2.1824	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	71.6	2.51e-12	NR	MBL6705954.1	2026779	g19510	i0	68.9	0.544354838709677	45	14	54.4	0	6	140	262	306	MBL6705954.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	135	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;