metadata: contig_metadata: 8 rows where bioproject = "PRJNA870096", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA870096", 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
27402948	27402948	PRJNA870096_S_NODE_21283_length_393_cov_2.351429_g19623_i0	PRJNA870096	21283	393	2.351429	9.24111597	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	1.98e-29	NR	MBS0628243.1	2026799	g19623	i0	44.1	0.969465648854962	127	64	91.6	1	2	361	4	130	MBS0628243.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	381	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28255242	28255242	PRJNA870096_S_NODE_61546_length_223_cov_2.400000_g59882_i0	PRJNA870096	61546	223	2.4	5.352	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	54.3	1.03e-6	NR	MBT7982475.1	2562705	g59882	i0	41.9	0.995515695067265	74	41	99.6	1	222	1	88	159	MBT7982475.1 peptidyl-prolyl cis-trans isomerase [Akkermansiaceae bacterium]	diamond	222	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28634484	28634484	PRJNA870096_S_NODE_52787_length_242_cov_1.783920_g51123_i0	PRJNA870096	52787	242	1.78392	4.3170864	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	5.16e-5	NR	MCX6877507.1	2026799	g51123	i0	58.7	2.23140495867769	46	18	55.8	1	1	135	79	124	MCX6877507.1 ankyrin repeat domain-containing protein [Verrucomicrobiota bacterium]	diamond	540	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29107932	29107932	PRJNA870096_S_NODE_144728_length_150_cov_1.794393_g143064_i0	PRJNA870096	144728	150	1.794393	2.6915895	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	57.4	6.88e-8	NR	MFM7179879.1	2026801	g143064	i0	55.3	0.94	47	21	94	0	149	9	361	407	MFM7179879.1 zinc metallochaperone GTPase ZigA [Verrucomicrobiales bacterium]	diamond	141	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29454793	29454793	PRJNA870096_S_NODE_86590_length_189_cov_1.136986_g84926_i0	PRJNA870096	86590	189	1.136986	2.14890354	Lacunisphaera sp.	1961806	Bacteria	Bacteria	72.4	6.2e-13	NR	HWA27973.1	1961806	g84926	i0	62.1	2.50793650793651	58	18	85.7	1	163	2	677	734	HWA27973.1 NADP-dependent isocitrate dehydrogenase [Lacunisphaera sp.]	diamond	474	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
29620666	29620666	PRJNA870096_S_NODE_85170_length_190_cov_2.095238_g83506_i0	PRJNA870096	85170	190	2.095238	3.9809522	PVC group	1783257	Bacteria	Bacteria	78.6	7.93e-17	NR	MDR1009977.1	2006848	g83506	i0	64.5	11.6842105263158	62	22	97.9	0	188	3	39	100	MDR1009977.1 glycine cleavage system protein GcvH [Opitutaceae bacterium]	diamond	2220	79	0.994936708860759	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30149762	30149762	PRJNA870096_S_NODE_23852_length_369_cov_4.978528_g22189_i0	PRJNA870096	23852	369	4.978528	18.37076832	Opitutaceae bacterium	2006848	Bacteria	Bacteria	94.4	1.17e-20	NR	MBX3749762.1	2006848	g22189	i0	42.3	6.04878048780488	123	70	99.2	1	3	368	134	256	MBX3749762.1 SDR family oxidoreductase [Opitutaceae bacterium]	diamond	2232	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31074421	31074421	PRJNA870096_S_NODE_97815_length_178_cov_2.688889_g96151_i0	PRJNA870096	97815	178	2.688889	4.78622242	Pseudomonadati	3379134	Bacteria	Bacteria	97.1	2.8000000000000003e-23	NR	MDE6432490.1	2026772	g96151	i0	85.7	2.62921348314607	49	7	82.6	0	27	173	142	190	MDE6432490.1 peroxiredoxin [Opitutales bacterium]	diamond	468	97.8	0.992842535787321	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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);;