metadata: contig_metadata: 12 rows where bioproject = "PRJNA896554", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA896554", 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
4700997	4700997	PRJNA896554_P_NODE_87064_length_371_cov_1.604027_g79524_i0	PRJNA896554	87064	371	1.604027	5.95094017	Candidatus Methylacidiphilum fumarolicum	591154	Bacteria	Bacteria	149	3.94e-44	NR	TFE68280.1	591154	g79524	i0	73.5	0.792452830188679	98	26	79.2	0	3	296	11	108	TFE68280.1 nickel resistance protein [Candidatus Methylacidiphilum fumarolicum]	diamond	294	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum fumarolicum
16172205	16172205	PRJNA896554_P_NODE_108133_length_313_cov_1.283333_g100593_i0	PRJNA896554	108133	313	1.283333	4.01683229	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	209	4.79e-63	NR	HYY26886.1	2201154	g100593	i0	87.5	2.99041533546326	104	13	99.7	0	2	313	157	260	HYY26886.1 GMC oxidoreductase [Chthoniobacterales bacterium]	diamond	936	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
16172396	16172396	PRJNA896554_P_NODE_116613_length_297_cov_1.031250_g109073_i0	PRJNA896554	116613	297	1.03125	3.0628125	Chthoniobacter sp.	2510640	Bacteria	Bacteria	135	1.19e-36	NR	MCE9612343.1	2510640	g109073	i0	60.8	1.96969696969697	97	38	98	0	293	3	4	100	MCE9612343.1 hypothetical protein [Chthoniobacter sp.]	diamond	585	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
22547244	22547244	PRJNA896554_P_NODE_144158_length_257_cov_2.222826_g136618_i0	PRJNA896554	144158	257	2.222826	5.71266282	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	80.5	1.07e-10	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g136618	i0	91.379	0.22568093385214	58	5	23	0	85	142	4755580	4755523	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	58	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
27087346	27087346	PRJNA896554_P_NODE_49582_length_678_cov_1.700826_g42179_i0	PRJNA896554	49582	678	1.700826	11.53160028	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	129	5.66e-33	NR	MCP5542415.1	2562705	g42179	i0	53.8	0.641592920353982	145	59	63.7	5	246	677	4	141	MCP5542415.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	435	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28074019	28074019	PRJNA896554_P_NODE_97725_length_338_cov_1.162264_g90185_i0	PRJNA896554	97725	338	1.162264	3.92845232	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	2.79e-6	NR	MBT4902053.1	2026799	g90185	i0	35.8	1.54437869822485	106	60	94.1	3	328	11	549	646	MBT4902053.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	522	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28287212	28287212	PRJNA896554_P_NODE_81246_length_394_cov_2.470405_g73706_i0	PRJNA896554	81246	394	2.470405	9.7333957	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	198	4.9099999999999994e-57	NR	WP_317833666.1	3080537	g73706	i0	70.8	0.989847715736041	130	36	99	2	392	3	71	198	WP_317833666.1 5-histidylcysteine sulfoxide synthase [Rubellicoccus peritrichatus]	diamond	390	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
29297779	29297779	PRJNA896554_P_NODE_112509_length_304_cov_1.995671_g104969_i0	PRJNA896554	112509	304	1.995671	6.06683984	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	102	5.619999999999999e-24	NR	MCS7048008.1	2499141	g104969	i0	59.5	5.05263157894737	84	34	82.9	0	304	53	177	260	MCS7048008.1 HAD-IIA family hydrolase [Verrucomicrobiia bacterium]	diamond	1536	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30181942	30181942	PRJNA896554_P_NODE_147552_length_253_cov_1.866667_g140012_i0	PRJNA896554	147552	253	1.866667	4.72266751	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	43.1	0.0297	NR	MBJ7392827.1	2201154	g140012	i0	50	0.49802371541502	42	17	45.1	1	136	249	1	42	MBJ7392827.1 Fic family protein [Chthoniobacterales bacterium]	diamond	126	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30442681	30442681	PRJNA896554_P_NODE_161113_length_246_cov_2.682081_g153573_i0	PRJNA896554	161113	246	2.682081	6.59791926	Pseudomonadati	3379134	Bacteria	Bacteria	93.6	7.230000000000001e-22	NR	WP_200355294.1	415221	g153573	i0	55	1.96341463414634	80	34	97.6	1	243	4	17	94	WP_200355294.1 cysteine hydrolase family protein [Pelagicoccus mobilis]	diamond	483	93.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus mobilis
30750849	30750849	PRJNA896554_P_NODE_79574_length_402_cov_1.419453_g72034_i0	PRJNA896554	79574	402	1.419453	5.70620106	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	75.9	6.07e-13	NR	MCC6233925.1	2026801	g72034	i0	50	0.82089552238806	110	51	79.9	3	372	52	293	401	MCC6233925.1 immunoglobulin domain-containing protein [Verrucomicrobiales bacterium]	diamond	330	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32490306	32490306	PRJNA896554_P_NODE_156819_length_248_cov_1.348571_g149279_i0	PRJNA896554	156819	248	1.348571	3.34445608	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	95.1	1.42e-20	NR	MDB6140686.1	2026800	g149279	i0	66.7	3.03629032258065	63	21	76.2	0	248	60	531	593	MDB6140686.1 family oxidoreductase [Verrucomicrobiaceae bacterium]	diamond	753	95.1	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);;