metadata: contig_metadata: 4 rows where bioproject = "PRJNA229468", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA229468", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
27863582	27863582	PRJNA229468_S_NODE_225_length_326_cov_1.335740_g212_i0	PRJNA229468	225	326	1.33574	4.3545124	Gemmataceae bacterium	2052164	Bacteria	Bacteria	134	1.55e-36	NR	MDB5309156.1	2052164	g212	i0	69.2	0.984662576687117	107	32	97.5	1	318	1	129	235	MDB5309156.1 3-oxoacyl-ACP reductase [Gemmataceae bacterium]	diamond	321	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32445422	32445422	PRJNA229468_S_NODE_359_length_265_cov_1.648148_g346_i0	PRJNA229468	359	265	1.648148	4.3675922	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.0145	NR	MBU6172306.1	2026780	g346	i0	28.9	1.0188679245283	90	57	94	2	255	7	259	348	MBU6172306.1 DUF11 domain-containing protein [Planctomycetota bacterium]	diamond	270	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32526587	32526587	PRJNA229468_S_NODE_19_length_918_cov_2.767549_g15_i0	PRJNA229468	19	918	2.767549	25.40609982	Planctomycetia	203683	Bacteria	Bacteria	73.9	1.37e-10	NR	MFM7931657.1	117	g15	i0	41.3	1.23529411764706	126	69	40.5	3	635	264	14	136	MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.]	diamond	1134	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32886402	32886402	PRJNA229468_S_NODE_440_length_236_cov_1.887701_g427_i0	PRJNA229468	440	236	1.887701	4.45497436	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	42.4	0.0471	NR	MFM8580792.1	2026779	g427	i0	49	1.94491525423729	51	26	64.8	0	1	153	442	492	MFM8580792.1 collagen binding domain-containing protein [Planctomycetaceae bacterium]	diamond	459	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;