metadata: contig_metadata: 5 rows where bioproject = "PRJNA724011", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA724011", 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_species
9639008	9639008	PRJNA724011_P_NODE_25628_length_558_cov_1.517526_g24612_i0	PRJNA724011	25628	558	1.517526	8.46779508	Bacteria	2	Bacteria	Bacteria	117	9.12e-27	NR	NLF18273.1	1932692	g24612	i0	51.7	2.73118279569892	116	54	62.4	1	556	209	446	559	NLF18273.1 1,4-alpha-glucan-branching enzyme [Lentisphaerota bacterium]	diamond	1524	117	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
26925588	26925588	PRJNA724011_P_NODE_50842_length_363_cov_1.062069_g49819_i0	PRJNA724011	50842	363	1.062069	3.85531047	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	44.7	0.0275	NR	MBE6371241.1	1932692	g49819	i0	41.5	0.685950413223141	41	24	33.9	0	149	27	28	68	MBE6371241.1 hypothetical protein [Lentisphaerota bacterium]	diamond	249	44.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
27852124	27852124	PRJNA724011_P_NODE_102424_length_245_cov_2.180233_g101401_i0	PRJNA724011	102424	245	2.180233	5.34157085	Bacteria	2	Bacteria	Bacteria	63.9	6.36e-10	NR	HCE46442.1	2053569	g101401	i0	62.5	4.06530612244898	48	17	58.8	1	237	94	200	246	HCE46442.1 peptidase M15 [Lentisphaeria bacterium]	diamond	996	63.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
30115253	30115253	PRJNA724011_P_NODE_48972_length_371_cov_1.845638_g47949_i0	PRJNA724011	48972	371	1.845638	6.84731698	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	47	0.00498	NR	MBT4817504.1	1932692	g47949	i0	38.2	1.09973045822102	68	40	54.2	2	164	364	429	495	MBT4817504.1 DEAD/DEAH box helicase [Lentisphaerota bacterium]	diamond	408	47	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
31959055	31959055	PRJNA724011_P_NODE_24357_length_576_cov_3.188867_g23341_i0	PRJNA724011	24357	576	3.188867	18.36787392	Pseudomonadati	3379134	Bacteria	Bacteria	47.8	0.0148	NR	MBE6397871.1	1932692	g23341	i0	42.9	0.588541666666667	63	31	32.8	3	525	337	31	88	MBE6397871.1 hypothetical protein [Lentisphaerota bacterium]	diamond	339	48.1	0.993762993762994	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);;