metadata: contig_metadata: 21 rows where bioproject = "PRJNA971593", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA971593", 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
9872636	9872636	PRJNA971593_P_NODE_828_length_1199_cov_6.393428_g744_i0	PRJNA971593	828	1199	6.393428	76.65720172	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	427	1.0399999999999996e-145	NR	RYD65414.1	2026800	g744	i0	75.9	0.70558798999166	282	65	70.3	2	895	53	56	335	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	846	427	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
14972234	14972234	PRJNA971593_P_NODE_24692_length_248_cov_0.868571_g24543_i0	PRJNA971593	24692	248	0.868571	2.15405608	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	99.4	3.700000000000001e-22	NR	HEY2343062.1	2811408	g24543	i0	65.3	0.870967741935484	72	25	87.1	0	3	218	425	496	HEY2343062.1 menaquinone biosynthesis decarboxylase [Chthoniobacteraceae bacterium]	diamond	216	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
25492780	25492780	PRJNA971593_P_NODE_27180_length_244_cov_0.900585_g27031_i0	PRJNA971593	27180	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g27031	i0	92.5	1.93852459016393	40	3	18	0	139	178	3975235	3975196	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	473	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27151948	27151948	PRJNA971593_P_NODE_26922_length_244_cov_0.900585_g26773_i0	PRJNA971593	26922	244	0.900585	2.1974274	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	129	1.6499999999999999e-32	NR	MEI7730925.1	2026799	g26773	i0	76.9	0.959016393442623	78	18	95.9	0	235	2	417	494	MEI7730925.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	234	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27437032	27437032	PRJNA971593_P_NODE_14663_length_314_cov_1.186722_g14514_i0	PRJNA971593	14663	314	1.186722	3.72630708	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	90.5	1.73e-20	NR	RYD70705.1	2026800	g14514	i0	51.6	0.869426751592357	91	43	86.9	1	18	290	7	96	RYD70705.1 MAG: hypothetical protein EOP84_26235 [Verrucomicrobiaceae bacterium]	diamond	273	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27437039	27437039	PRJNA971593_P_NODE_22163_length_251_cov_0.865169_g22014_i0	PRJNA971593	22163	251	0.865169	2.17157419	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	149	1.42e-39	NR	MEO5721508.1	2201154	g22014	i0	83.1	0.99203187250996006	83	14	99.2	0	1	249	846	928	MEO5721508.1 dockerin type I domain-containing protein [Chthoniobacterales bacterium]	diamond	249	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27752700	27752700	PRJNA971593_P_NODE_13424_length_329_cov_0.835938_g13275_i0	PRJNA971593	13424	329	0.835938	2.75023602	Opitutales bacterium	2026772	Bacteria	Bacteria	90.1	3.38e-19	NR	MCC5840993.1	2026772	g13275	i0	54.3	1.58662613981763	92	27	76.6	3	253	2	104	188	MCC5840993.1 orotidine-5'-phosphate decarboxylase [Opitutales bacterium]	diamond	522	90.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27815876	27815876	PRJNA971593_P_NODE_20044_length_265_cov_1.203125_g19895_i0	PRJNA971593	20044	265	1.203125	3.18828125	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	136	1.06e-36	NR	RYD81270.1	2026800	g19895	i0	66.7	0.984905660377358	87	29	98.5	0	2	262	166	252	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	261	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28415719	28415719	PRJNA971593_P_NODE_21726_length_252_cov_1.290503_g21577_i0	PRJNA971593	21726	252	1.290503	3.25206756	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	126	5.61e-33	NR	RYD65414.1	2026800	g21577	i0	80.3	0.785714285714286	66	13	78.6	0	198	1	255	320	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	198	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28478758	28478758	PRJNA971593_P_NODE_21786_length_252_cov_1.016760_g21637_i0	PRJNA971593	21786	252	1.01676	2.5622352	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	153	4.3099999999999997e-42	NR	MFH1497780.1	2026799	g21637	i0	83.3	3	84	14	100	0	252	1	157	240	MFH1497780.1 GTP cyclohydrolase [Verrucomicrobiota bacterium]	diamond	756	153	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29267879	29267879	PRJNA971593_P_NODE_17829_length_282_cov_1.636364_g17680_i0	PRJNA971593	17829	282	1.636364	4.61454648	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	79.3	4.97e-15	NR	MDF1738392.1	2026801	g17680	i0	52.1	2.40425531914894	73	33	77.7	1	250	32	1	71	MDF1738392.1 FAD-dependent oxidoreductase [Verrucomicrobiales bacterium]	diamond	678	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29394447	29394447	PRJNA971593_P_NODE_23989_length_249_cov_0.875000_g23840_i0	PRJNA971593	23989	249	0.875	2.17875	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	86.7	5.79e-18	NR	WP_165207413.1	2711231	g23840	i0	58	0.831325301204819	69	29	83.1	0	43	249	7	75	WP_165207413.1 STELLO glycosyltransferase family protein [Roseimicrobium sp. ORNL1]	diamond	207	86.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
29583501	29583501	PRJNA971593_P_NODE_4030_length_602_cov_1.274102_g3886_i0	PRJNA971593	4030	602	1.274102	7.67009404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	0.012	NR	MFC1497346.1	2026799	g3886	i0	23.1	3.96677740863787	216	134	95.7	6	19	594	7	214	MFC1497346.1 CBASS cGAMP-activated phospholipase [Verrucomicrobiota bacterium]	diamond	2388	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30183906	30183906	PRJNA971593_P_NODE_12092_length_347_cov_2.200730_g11943_i0	PRJNA971593	12092	347	2.20073	7.6365331	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.1	0.00155	NR	MCX7825713.1	2499141	g11943	i0	32.9	0.734870317002882	85	55	71.8	1	265	17	5	89	MCX7825713.1 M60 family metallopeptidase [Verrucomicrobiia bacterium]	diamond	255	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30215347	30215347	PRJNA971593_P_NODE_10212_length_379_cov_1.509804_g10063_i0	PRJNA971593	10212	379	1.509804	5.72215716	Opitutaceae bacterium	2006848	Bacteria	Bacteria	82.4	1.33e-16	NR	HEV8073130.1	2006848	g10063	i0	50	0.696569920844327	88	40	69.7	1	264	1	9	92	HEV8073130.1 DUF2589 domain-containing protein [Opitutaceae bacterium]	diamond	264	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30537746	30537746	PRJNA971593_P_NODE_18633_length_276_cov_1.517241_g18484_i0	PRJNA971593	18633	276	1.517241	4.18758516	PVC group	1783257	Bacteria	Bacteria	66.6	2.21e-10	NR	HRE83282.1	2006848	g18484	i0	61.8	3.18478260869565	55	21	59.8	0	1	165	343	397	HRE83282.1 ABC transporter ATP-binding protein [Opitutaceae bacterium]	diamond	879	66.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30784244	30784244	PRJNA971593_P_NODE_26554_length_245_cov_0.895349_g26405_i0	PRJNA971593	26554	245	0.895349	2.19360505	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	116	1.59e-28	NR	HWM23761.1	2201154	g26405	i0	72.5	2.93877551020408	80	22	98	0	240	1	282	361	HWM23761.1 amidohydrolase family protein [Chthoniobacterales bacterium]	diamond	720	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30973955	30973955	PRJNA971593_P_NODE_5014_length_541_cov_1.829060_g4868_i0	PRJNA971593	5014	541	1.82906	9.8952146	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.2	8.41e-6	NR	MBS0654649.1	2026799	g4868	i0	26.3	0.992606284658041	179	109	93.2	5	541	38	5	171	MBS0654649.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	537	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31448035	31448035	PRJNA971593_P_NODE_15776_length_301_cov_1.543860_g15627_i0	PRJNA971593	15776	301	1.54386	4.6470186	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	152	5.699999999999998e-41	NR	RYD77759.1	2026800	g15627	i0	75	0.996677740863787	100	25	99.7	0	2	301	418	517	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	300	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31479889	31479889	PRJNA971593_P_NODE_18856_length_274_cov_2.014925_g18707_i0	PRJNA971593	18856	274	2.014925	5.5208945	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	146	9.95e-39	NR	RYD77759.1	2026800	g18707	i0	80.2	0.996350364963504	91	18	99.6	0	273	1	283	373	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	273	146	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32080619	32080619	PRJNA971593_P_NODE_28578_length_242_cov_0.911243_g28429_i0	PRJNA971593	28578	242	0.911243	2.20520806	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	129	1.7599999999999998e-32	NR	MBL9113924.1	2026800	g28429	i0	75.9	0.979338842975207	79	19	97.9	0	5	241	503	581	MBL9113924.1 N-6 DNA methylase [Verrucomicrobiaceae bacterium]	diamond	237	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;