metadata: contig_metadata: 14 rows where bioproject = "PRJNA929522", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA929522", 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
18756858	18756858	PRJNA929522_S_NODE_155_length_1308_cov_6.864777_g132_i0	PRJNA929522	155	1308	6.864777	89.79128316	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	427	3.8699999999999985e-145	NR	RYD65414.1	2026800	g132	i0	75.5	0.646788990825688	282	66	64.4	2	305	1147	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
27506146	27506146	PRJNA929522_S_NODE_2083_length_461_cov_1.079897_g2013_i0	PRJNA929522	2083	461	1.079897	4.97832517	Bacteria	2	Bacteria	Bacteria	56.6	5.7e-6	NR	MCU0772034.1	2026799	g2013	i0	39.8	2.51843817787419	118	52	73.5	5	39	377	857	960	MCU0772034.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1161	57	0.992982456140351	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27940991	27940991	PRJNA929522_S_NODE_6005_length_289_cov_1.365741_g5935_i0	PRJNA929522	6005	289	1.365741	3.94699149	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	99	3.789999999999999e-23	NR	WP_330928177.1	2909285	g5935	i0	55.4	1.89965397923875	92	41	95.5	0	276	1	29	120	WP_330928177.1 M15 family metallopeptidase [Synoicihabitans lomoniglobus]	diamond	549	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
28035719	28035719	PRJNA929522_S_NODE_6065_length_288_cov_1.074419_g5995_i0	PRJNA929522	6065	288	1.074419	3.09432672	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	120	2.33e-30	NR	RYD71398.1	2026800	g5995	i0	59.4	1	96	37	100	1	1	288	179	272	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	288	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28098698	28098698	PRJNA929522_S_NODE_7785_length_260_cov_1.096257_g7715_i0	PRJNA929522	7785	260	1.096257	2.8502682	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	96.7	1.6e-21	NR	RYD71398.1	2026800	g7715	i0	57.1	0.888461538461538	77	33	88.8	0	3	233	285	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	231	96.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28130476	28130476	PRJNA929522_S_NODE_605_length_803_cov_2.002740_g552_i0	PRJNA929522	605	803	2.00274	16.0820022	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	126	3.71e-29	NR	WP_330930766.1	2909285	g552	i0	35.3	0.889165628891656	238	120	80.3	7	654	10	259	485	WP_330930766.1 carboxypeptidase regulatory-like domain-containing protein [Synoicihabitans lomoniglobus]	diamond	714	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
30025065	30025065	PRJNA929522_S_NODE_7511_length_264_cov_0.989529_g7441_i0	PRJNA929522	7511	264	0.989529	2.61235656	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	93.2	3.38e-20	NR	RYD71398.1	2026800	g7441	i0	51.7	1.01136363636364	89	40	100	2	264	1	118	204	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	267	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30341367	30341367	PRJNA929522_S_NODE_392_length_945_cov_2.880734_g349_i0	PRJNA929522	392	945	2.880734	27.2229363	Opitutales bacterium	2026772	Bacteria	Bacteria	94.4	2.27e-19	NR	MDB2357976.1	2026772	g349	i0	40.2	0.387301587301587	122	71	38.7	2	179	544	41	160	MDB2357976.1 phage tail tip lysozyme [Opitutales bacterium]	diamond	366	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
30751668	30751668	PRJNA929522_S_NODE_6834_length_274_cov_1.452736_g6764_i0	PRJNA929522	6834	274	1.452736	3.98049664	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	86.3	8.66e-18	NR	MDB4664826.1	2026799	g6764	i0	45.7	2.98905109489051	92	49	99.6	1	273	1	75	166	MDB4664826.1 dihydrodipicolinate synthase family protein [Verrucomicrobiota bacterium]	diamond	819	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30909690	30909690	PRJNA929522_S_NODE_34_length_2238_cov_4.581986_g25_i0	PRJNA929522	34	2238	4.581986	102.54484668	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	424	1.13e-128	NR	MBS0647573.1	2026799	g25	i0	36.5	0.922252010723861	688	403	89.5	11	2235	232	622	1295	MBS0647573.1 DDE-type integrase/transposase/recombinase [Verrucomicrobiota bacterium]	diamond	2064	424	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30909691	30909691	PRJNA929522_S_NODE_3814_length_346_cov_1.545788_g3744_i0	PRJNA929522	3814	346	1.545788	5.34842648	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	113	6.39e-27	NR	MDB6059759.1	2026801	g3744	i0	45.3	1.01445086705202	117	61	98.8	1	346	5	266	382	MDB6059759.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	351	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31763224	31763224	PRJNA929522_S_NODE_9197_length_246_cov_2.219653_g9127_i0	PRJNA929522	9197	246	2.219653	5.46034638	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	78.2	1.23e-14	NR	MBA3830530.1	2201154	g9127	i0	53.4	3.6219512195122	73	34	89	0	230	12	249	321	MBA3830530.1 S8 family serine peptidase [Chthoniobacterales bacterium]	diamond	891	78.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32269650	32269650	PRJNA929522_S_NODE_8478_length_251_cov_0.865169_g8408_i0	PRJNA929522	8478	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	54.7	2.5e-6	NR	MEM7146344.1	2026799	g8408	i0	40.7	1.08764940239044	91	45	99.2	4	2	250	170	259	MEM7146344.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	273	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32301475	32301475	PRJNA929522_S_NODE_10159_length_241_cov_0.898810_g10089_i0	PRJNA929522	10159	241	0.89881	2.1661321	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67.4	6.3e-11	NR	NDD57575.1	2026799	g10089	i0	69.8	0.535269709543568	43	13	53.5	0	6	134	300	342	NDD57575.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	129	67.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);;