metadata: contig_metadata: 6 rows where bioproject = "PRJNA438111", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA438111", 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_species
5538233	5538233	PRJNA438111_P_NODE_6605_length_387_cov_4.318436_g6005_i0	PRJNA438111	6605	387	4.318436	16.71234732	Bacteria	2	Bacteria	Bacteria	195	1.49e-57	NR	MCH2174537.1	2053569	g6005	i0	76	6	129	31	100	0	1	387	5	133	MCH2174537.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Lentisphaeria bacterium]	diamond	2322	195	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria		Lentisphaeria bacterium
8743439	8743439	PRJNA438111_P_NODE_2487_length_613_cov_6.693493_g2041_i0	PRJNA438111	2487	613	6.693493	41.03111209	Bacteria	2	Bacteria	Bacteria	306	2.7399999999999998e-99	NR	NLZ64708.1	1932692	g2041	i0	69.1	24.9494290375204	204	63	99.8	0	1	612	273	476	NLZ64708.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Lentisphaerota bacterium]	diamond	15294	309	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota bacterium
23386539	23386539	PRJNA438111_P_NODE_55199_length_176_cov_2.891156_g54574_i0	PRJNA438111	55199	176	2.891156	5.08843456	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	69.7	4.65e-12	NR	NLE68326.1	1932692	g54574	i0	60.3	0.988636363636364	58	19	98.9	1	176	3	205	258	NLE68326.1 glycoside hydrolase family 2 protein [Lentisphaerota bacterium]	diamond	174	69.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota bacterium
28212687	28212687	PRJNA438111_P_NODE_63506_length_169_cov_1.364286_g62881_i0	PRJNA438111	63506	169	1.364286	2.30564334	Lentisphaerae bacterium GWF2_49_21	1798573	Bacteria	Bacteria	111	1.04e-26	NR	OGV36904.1	1798573	g62881	i0	80	0.976331360946746	55	11	97.6	0	166	2	432	486	OGV36904.1 MAG: hypothetical protein A2X48_16055 [Lentisphaerae bacterium GWF2_49_21]	diamond	165	111	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerae bacterium GWF2_49_21
28434018	28434018	PRJNA438111_P_NODE_47506_length_184_cov_4.890323_g46881_i0	PRJNA438111	47506	184	4.890323	8.99819432	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	102	1.5799999999999998e-23	NR	MFA4943072.1	2053569	g46881	i0	75.9	0.945652173913043	58	14	94.6	0	176	3	937	994	MFA4943072.1 sugar-binding protein [Lentisphaeria bacterium]	diamond	174	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria		Lentisphaeria bacterium
31656043	31656043	PRJNA438111_P_NODE_83917_length_155_cov_2.190476_g83292_i0	PRJNA438111	83917	155	2.190476	3.3952378	Victivallales bacterium	2212475	Bacteria	Bacteria	48.5	1.02e-4	NR	MFA6291485.1	2212475	g83292	i0	50	0.812903225806452	42	21	81.3	0	29	154	90	131	MFA6291485.1 hypothetical protein [Victivallales bacterium]	diamond	126	48.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales 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);;