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

6 rows where bioproject = "PRJNA798511", 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
27527847	27527847	PRJNA798511_P_NODE_35703_length_463_cov_1.753846_g31444_i0	PRJNA798511	35703	463	1.753846	8.12030698	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	68.9	3.35e-11	NR	HET6328477.1	2026779	g31444	i0	31.4	0.764578833693304	118	74	75.2	3	94	441	36	148	HET6328477.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	354	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28033221	28033221	PRJNA798511_P_NODE_37945_length_439_cov_1.754098_g33684_i0	PRJNA798511	37945	439	1.754098	7.70049022	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	9.36e-15	NR	HEY3226600.1	2026780	g33684	i0	45.1	6.10250569476082	102	46	68.3	3	432	133	165	258	HEY3226600.1 serine/threonine-protein kinase [Planctomycetota bacterium]	diamond	2679	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28664612	28664612	PRJNA798511_P_NODE_35047_length_471_cov_1.092965_g30788_i0	PRJNA798511	35047	471	1.092965	5.14786515	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	145	4.359999999999999e-37	NR	MCP4255696.1	2268189	g30788	i0	44.9	1.72611464968153	158	81	96.8	1	1	456	627	784	MCP4255696.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	813	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
29368294	29368294	PRJNA798511_P_NODE_10889_length_1432_cov_30.951435_g8254_i1	PRJNA798511	10889	1432	30.951435	443.2245492	Pseudomonadati	3379134	Bacteria	Bacteria	89.7	1.02e-16	NR	HLX63275.1	2026780	g8254	i1	46.2	1.37849162011173	93	49	19.5	1	650	928	99	190	HLX63275.1 ATP-dependent Clp protease proteolytic subunit [Planctomycetota bacterium]	diamond	1974	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30622513	30622513	PRJNA798511_P_NODE_73453_length_281_cov_1.120192_g69187_i0	PRJNA798511	73453	281	1.120192	3.14773952	Aquisphaera insulae	2712864	Bacteria	Bacteria	42	0.0443	NR	WP_165228110.1	2712864	g69187	i0	31.6	0.843416370106762	79	53	84.3	1	21	257	6	83	WP_165228110.1 hypothetical protein [Aquisphaera insulae]	diamond	237	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
32045544	32045544	PRJNA798511_P_NODE_97198_length_245_cov_0.895349_g92932_i0	PRJNA798511	97198	245	0.895349	2.19360505	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	60.5	1.59e-8	NR	MBV8129076.1	2026779	g92932	i0	66.7	0.514285714285714	42	14	51.4	0	118	243	1	42	MBV8129076.1 ABC transporter permease [Planctomycetaceae bacterium]	diamond	126	60.5	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);;