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

5 rows where bioproject = "PRJNA796753", 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
26673685	26673685	PRJNA796753_P_NODE_46601_length_246_cov_0.890173_g46289_i0	PRJNA796753	46601	246	0.890173	2.18982558	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	47.8	6.36e-4	NR	NQT94185.1	1932692	g46289	i0	53.7	0.5	41	19	50	0	3	125	158	198	NQT94185.1 WD40 repeat domain-containing protein [Lentisphaerota bacterium]	diamond	123	47.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
26958751	26958751	PRJNA796753_P_NODE_42082_length_249_cov_0.875000_g41770_i0	PRJNA796753	42082	249	0.875	2.17875	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	69.7	1.08e-11	NR	MCJ8328776.1	2053569	g41770	i0	49.3	1.66265060240964	69	35	83.1	0	208	2	64	132	MCJ8328776.1 pantetheine-phosphate adenylyltransferase [Lentisphaeria bacterium]	diamond	414	69.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
28105136	28105136	PRJNA796753_P_NODE_35365_length_262_cov_1.571429_g35053_i0	PRJNA796753	35365	262	1.571429	4.11714398	Bacteria	2	Bacteria	Bacteria	44.7	0.0085	NR	MBE6403771.1	1932692	g35053	i0	46.2	1.45419847328244	39	21	44.7	0	125	9	195	233	MBE6403771.1 hypothetical protein [Lentisphaerota bacterium]	diamond	381	44.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
30094430	30094430	PRJNA796753_P_NODE_7912_length_486_cov_1.443099_g7601_i0	PRJNA796753	7912	486	1.443099	7.01346114	PVC group	1783257	Bacteria	Bacteria	62.8	4.85e-8	NR	MEI6424343.1	1932692	g7601	i0	31.3	6.16666666666667	131	77	76.5	3	100	471	407	531	MEI6424343.1 FAD-dependent oxidoreductase [Lentisphaerota bacterium]	diamond	2997	62.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
32456879	32456879	PRJNA796753_P_NODE_52759_length_242_cov_0.911243_g52447_i0	PRJNA796753	52759	242	0.911243	2.20520806	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	47.4	8.56e-4	NR	HCE43507.1	2053569	g52447	i0	41.9	0.768595041322314	62	32	76.9	1	56	241	87	144	HCE43507.1 glycoside hydrolase [Lentisphaeria bacterium]	diamond	186	47.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria 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);;