metadata: contig_metadata: 23 rows where bioproject = "PRJNA924320", tax_clade = "PVC group" and tax

23 rows where bioproject = "PRJNA924320", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
8552023	8552023	PRJNA924320_S_NODE_17487_length_244_cov_1.974359_g17345_i0	PRJNA924320	17487	244	1.974359	4.81743596	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	136	4.88e-37	NR	RYD65414.1	2026800	g17345	i0	81.1	1.84426229508197	74	14	91	0	5	226	262	335	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	450	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26651789	26651789	PRJNA924320_S_NODE_47881_length_166_cov_0.871795_g47739_i0	PRJNA924320	47881	166	0.871795	1.4471797	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	1.04e-6	NR	MEY4917632.1	2026799	g47739	i0	50	3.6144578313253	52	25	94	1	5	160	58	108	MEY4917632.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	600	54.7	0.992687385740402	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27087997	27087997	PRJNA924320_S_NODE_13462_length_272_cov_1.515695_g13320_i0	PRJNA924320	13462	272	1.515695	4.1226904	Coraliomargarita sinensis	2174842	Bacteria	Bacteria	76.3	8.65e-14	NR	WP_110129373.1	2174842	g13320	i0	46.2	1.02573529411765	93	44	98.2	2	267	1	301	391	WP_110129373.1 response regulator [Coraliomargarita sinensis]	diamond	279	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita sinensis
27119219	27119219	PRJNA924320_S_NODE_10082_length_309_cov_1.026923_g9940_i0	PRJNA924320	10082	309	1.026923	3.17319207	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67.4	1.78e-10	NR	HYG84357.1	2499141	g9940	i0	50	0.660194174757282	68	34	66	0	7	210	229	296	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	204	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27182536	27182536	PRJNA924320_S_NODE_39982_length_177_cov_1.593750_g39840_i0	PRJNA924320	39982	177	1.59375	2.8209375	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.1	0.00232	NR	MBS0654748.1	2026799	g39840	i0	53.3	0.76271186440678	45	19	72.9	1	2	130	478	522	MBS0654748.1 AMP-binding protein [Verrucomicrobiota bacterium]	diamond	135	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27467225	27467225	PRJNA924320_S_NODE_4483_length_445_cov_1.522727_g4342_i0	PRJNA924320	4483	445	1.522727	6.77613515	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.9	8.42e-9	NR	PYJ49293.1	2026799	g4342	i0	39.1	1.55056179775281	115	59	76.2	4	94	432	34	139	PYJ49293.1 MAG: hypothetical protein DME85_00285 [Verrucomicrobiota bacterium]	diamond	690	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27845847	27845847	PRJNA924320_S_NODE_38064_length_181_cov_1.159091_g37922_i0	PRJNA924320	38064	181	1.159091	2.09795471	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.2	1.75e-11	NR	MFK5924323.1	2026799	g37922	i0	53.6	0.92817679558011	56	26	92.8	0	1	168	449	504	MFK5924323.1 SIS domain-containing protein [Verrucomicrobiota bacterium]	diamond	168	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27877597	27877597	PRJNA924320_S_NODE_9665_length_315_cov_1.225564_g9523_i0	PRJNA924320	9665	315	1.225564	3.8605266	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	51.6	6.47e-5	NR	HYG84357.1	2499141	g9523	i0	37.4	0.866666666666667	91	52	83.8	3	281	18	172	260	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	273	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27908902	27908902	PRJNA924320_S_NODE_54705_length_162_cov_1.353982_g54563_i0	PRJNA924320	54705	162	1.353982	2.19345084	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	93.2	6.350000000000001e-21	NR	RYD65414.1	2026800	g54563	i0	88.9	1	54	6	100	0	162	1	91	144	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	162	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28105702	28105702	PRJNA924320_S_NODE_13925_length_268_cov_2.168950_g13783_i0	PRJNA924320	13925	268	2.16895	5.812786	PVC group	1783257	Bacteria	Bacteria	53.9	5.98e-6	NR	MEY5026800.1	2026799	g13783	i0	46.9	3.63805970149254	64	31	68.3	2	267	85	132	195	MEY5026800.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	975	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28161904	28161904	PRJNA924320_S_NODE_34805_length_188_cov_1.100719_g34663_i0	PRJNA924320	34805	188	1.100719	2.06935172	Prosthecobacter sp.	1965333	Bacteria	Bacteria	42.4	0.0249	NR	WP_300932858.1	1965333	g34663	i0	34.9	1.00531914893617	63	38	95.7	2	5	184	338	400	WP_300932858.1 PVC-type heme-binding CxxCH protein [Prosthecobacter sp.]	diamond	189	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28193132	28193132	PRJNA924320_S_NODE_7166_length_359_cov_1.916129_g7024_i0	PRJNA924320	7166	359	1.916129	6.87890311	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	56.6	1.87e-6	NR	HYG84357.1	2499141	g7024	i0	36.1	0.81058495821727	97	58	79.4	2	9	293	115	209	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	291	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28382758	28382758	PRJNA924320_S_NODE_54586_length_162_cov_1.522124_g54444_i0	PRJNA924320	54586	162	1.522124	2.46584088	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	62.4	1.48e-9	NR	MFL6584006.1	2201154	g54444	i0	57.1	0.907407407407407	49	21	90.7	0	162	16	860	908	MFL6584006.1 2-oxoglutarate dehydrogenase E1 component [Chthoniobacterales bacterium]	diamond	147	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29455906	29455906	PRJNA924320_S_NODE_18970_length_237_cov_0.984043_g18828_i0	PRJNA924320	18970	237	0.984043	2.33218191	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	69.3	1.3e-11	NR	MBS0603821.1	2026799	g18828	i0	49.4	1.0253164556962	81	38	98.7	1	2	235	158	238	MBS0603821.1 TIGR02452 family protein [Verrucomicrobiota bacterium]	diamond	243	69.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29582224	29582224	PRJNA924320_S_NODE_2750_length_558_cov_3.106090_g2614_i0	PRJNA924320	2750	558	3.10609	17.3319822	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	73.6	1.69e-11	NR	HYG84357.1	2499141	g2614	i0	31.8	0.913978494623656	170	104	88.2	5	1	492	133	296	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	510	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29803493	29803493	PRJNA924320_S_NODE_22191_length_223_cov_1.034483_g22049_i0	PRJNA924320	22191	223	1.034483	2.30689709	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52	1.52e-5	NR	HYG84357.1	2499141	g22049	i0	68.8	0.430493273542601	32	10	43	0	126	221	117	148	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	96	52	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30442831	30442831	PRJNA924320_S_NODE_37393_length_182_cov_1.586466_g37251_i0	PRJNA924320	37393	182	1.586466	2.88736812	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	5.95e-20	NR	WP_343221741.1	454144	g37251	i0	72.9	4.82967032967033	59	16	97.3	0	1	177	206	264	WP_343221741.1 NADPH-dependent aldehyde reductase Ahr [Persicirhabdus sediminis]	diamond	879	91.7	0.991275899672846	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Persicirhabdus	Persicirhabdus sediminis
30695386	30695386	PRJNA924320_S_NODE_51653_length_164_cov_0.886957_g51511_i0	PRJNA924320	51653	164	0.886957	1.45460948	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	4.71e-12	NR	WP_075080717.1	690879	g51511	i0	78.1	12.2743902439024	32	7	58.5	0	159	64	10	41	WP_075080717.1 DUF2237 family protein [Terrimicrobium sacchariphilum]	diamond	2013	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
30814574	30814574	PRJNA924320_S_NODE_58094_length_160_cov_2.756757_g57952_i0	PRJNA924320	58094	160	2.756757	4.4108112	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.2	0.0428	NR	MEY2572035.1	2026799	g57952	i0	37.8	0.84375	45	28	84.4	0	10	144	90	134	MEY2572035.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	135	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31098799	31098799	PRJNA924320_S_NODE_33355_length_191_cov_1.077465_g33213_i0	PRJNA924320	33355	191	1.077465	2.05795815	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	82	8.45e-17	NR	MBL9157138.1	2026801	g33213	i0	74	0.785340314136126	50	13	78.5	0	41	190	10	59	MBL9157138.1 MBL fold metallo-hydrolase [Verrucomicrobiales bacterium]	diamond	150	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32522685	32522685	PRJNA924320_S_NODE_11539_length_291_cov_1.417355_g11397_i0	PRJNA924320	11539	291	1.417355	4.12450305	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0222	NR	MCZ6672873.1	2026799	g11397	i0	51.7	0.298969072164948	29	14	29.9	0	51	137	8	36	MCZ6672873.1 NUDIX hydrolase [Verrucomicrobiota bacterium]	diamond	87	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32648219	32648219	PRJNA924320_S_NODE_1380_length_766_cov_2.892608_g1279_i0	PRJNA924320	1380	766	2.892608	22.15737728	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	173	2.1e-46	NR	HYG84357.1	2499141	g1279	i0	48.9	0.89686684073107	229	102	86.2	7	16	675	56	278	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	687	173	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32711473	32711473	PRJNA924320_S_NODE_23500_length_218_cov_1.207101_g23358_i0	PRJNA924320	23500	218	1.207101	2.63148018	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77.4	1.66e-14	NR	MEC8826605.1	2026799	g23358	i0	49.3	0.94954128440367	69	35	95	0	1	207	443	511	MEC8826605.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	207	77.4	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);;