metadata: contig_metadata: 11 rows where bioproject = "PRJNA565584", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA565584", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
27395648	27395648	PRJNA565584_P_NODE_162603_length_254_cov_1.342541_g161451_i0	PRJNA565584	162603	254	1.342541	3.41005414	Lentisphaera araneosa	256847	Bacteria	Bacteria	72.8	1.1e-12	NR	WP_007281143.1	256847	g161451	i0	47.6	0.74409448818897606	63	33	74.4	0	189	1	2	64	WP_007281143.1 Na/Pi cotransporter family protein [Lentisphaera araneosa]	diamond	189	72.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera araneosa
27774573	27774573	PRJNA565584_P_NODE_42224_length_461_cov_1.188144_g41073_i0	PRJNA565584	42224	461	1.188144	5.47734384	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	58.9	5.49e-7	NR	MCK5806648.1	2053569	g41073	i0	54	0.325379609544469	50	23	32.5	0	13	162	60	109	MCK5806648.1 ankyrin repeat domain-containing protein [Lentisphaeria bacterium]	diamond	150	58.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28595454	28595454	PRJNA565584_P_NODE_195047_length_245_cov_0.895349_g193895_i0	PRJNA565584	195047	245	0.895349	2.19360505	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	60.5	1.8e-9	NR	MBO5694326.1	2053569	g193895	i0	66.7	0.440816326530612	36	12	44.1	0	234	127	2	37	MBO5694326.1 sel1 repeat family protein [Lentisphaeria bacterium]	diamond	108	60.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28753136	28753136	PRJNA565584_P_NODE_195887_length_245_cov_0.895349_g194735_i0	PRJNA565584	195887	245	0.895349	2.19360505	Victivallales bacterium	2212475	Bacteria	Bacteria	45.1	0.00568	NR	MFA6291039.1	2212475	g194735	i0	38.9	2.27755102040816	54	32	66.1	1	245	84	291	343	MFA6291039.1 GDSL-type esterase/lipase family protein [Victivallales bacterium]	diamond	558	45.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
29731703	29731703	PRJNA565584_P_NODE_21190_length_686_cov_3.854812_g20079_i0	PRJNA565584	21190	686	3.854812	26.44401032	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	89	1.1e-16	NR	QSH41408.1	1932692	g20079	i0	32.8	0.760932944606414	174	91	69.1	4	551	78	203	366	QSH41408.1 beta-N-acetylglucosaminidase domain-containing protein [Lentisphaerota bacterium]	diamond	522	89	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30535367	30535367	PRJNA565584_P_NODE_161753_length_254_cov_2.220994_g160601_i0	PRJNA565584	161753	254	2.220994	5.64132476	Pseudomonadati	3379134	Bacteria	Bacteria	66.6	1.64e-10	NR	MCX6983583.1	1932692	g160601	i0	49.1	3.34251968503937	57	27	67.3	1	14	184	36	90	MCX6983583.1 family 78 glycoside hydrolase catalytic domain [Lentisphaerota bacterium]	diamond	849	67	0.994029850746269	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31166989	31166989	PRJNA565584_P_NODE_143615_length_266_cov_2.062176_g142463_i0	PRJNA565584	143615	266	2.062176	5.48538816	Bacteria	2	Bacteria	Bacteria	83.6	9.08e-17	NR	OQC11971.1	1852899	g142463	i0	52.3	2.97744360902256	88	42	99.2	0	3	266	148	235	OQC11971.1 MAG: Acryloyl-CoA reductase electron transfer subunit beta [Lentisphaerae bacterium ADurb.Bin082]	diamond	792	83.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium ADurb.Bin082
31627929	31627929	PRJNA565584_P_NODE_153056_length_260_cov_1.647059_g151904_i0	PRJNA565584	153056	260	1.647059	4.2823534	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	43.5	0.0218	NR	MBO4632826.1	2053569	g151904	i0	34.4	0.738461538461539	64	34	64.6	1	67	234	169	232	MBO4632826.1 DUF1559 domain-containing protein [Lentisphaeria bacterium]	diamond	192	43.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32229261	32229261	PRJNA565584_P_NODE_14418_length_864_cov_2.231353_g13395_i0	PRJNA565584	14418	864	2.231353	19.27888992	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	69.7	1.88e-9	NR	QSH41408.1	1932692	g13395	i0	26.6	0.927083333333333	267	127	87.5	10	774	19	134	346	QSH41408.1 beta-N-acetylglucosaminidase domain-containing protein [Lentisphaerota bacterium]	diamond	801	69.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32369597	32369597	PRJNA565584_P_NODE_40839_length_469_cov_1.739899_g39688_i0	PRJNA565584	40839	469	1.739899	8.16012631	Pseudomonadati	3379134	Bacteria	Bacteria	96.3	7.9e-20	NR	QSH42534.1	1932692	g39688	i0	37.6	2.80810234541578	141	75	87.6	2	17	427	362	493	QSH42534.1 trypsin-like peptidase domain-containing protein [Lentisphaerota bacterium]	diamond	1317	96.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32829041	32829041	PRJNA565584_P_NODE_121280_length_281_cov_1.365385_g120128_i0	PRJNA565584	121280	281	1.365385	3.83673185	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	58.5	1.32e-7	NR	MBM4165165.1	1932692	g120128	i0	44.7	2.79715302491103	76	41	81.1	1	276	49	228	302	MBM4165165.1 SDR family oxidoreductase [Lentisphaerota bacterium]	diamond	786	58.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;