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

5 rows where bioproject = "PRJNA1050291", 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
9103483	9103483	PRJNA1050291_P_NODE_13988_length_299_cov_1.623894_g13097_i0	PRJNA1050291	13988	299	1.623894	4.85544306	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g13097	i0	100	0.0936454849498328	28	0	9	0	49	76	1244494	1244467	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
26615510	26615510	PRJNA1050291_P_NODE_14921_length_286_cov_1.352113_g14030_i0	PRJNA1050291	14921	286	1.352113	3.86704318	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	6.99e-11	NR	HEV3203136.1	2052164	g14030	i0	52.5	1.52097902097902	59	28	61.9	0	180	4	108	166	HEV3203136.1 class I SAM-dependent methyltransferase [Gemmataceae bacterium]	diamond	435	68.6	0.994169096209913	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28961942	28961942	PRJNA1050291_P_NODE_13288_length_310_cov_6.130802_g12397_i0	PRJNA1050291	13288	310	6.130802	19.0054862	Pirellulales bacterium	2715253	Bacteria	Bacteria	45.4	0.00912	NR	MBN2290920.1	2715253	g12397	i0	59.1	0.425806451612903	44	18	42.6	0	134	3	451	494	MBN2290920.1 hypothetical protein [Pirellulales bacterium]	diamond	132	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30185101	30185101	PRJNA1050291_P_NODE_14092_length_297_cov_2.075893_g13201_i0	PRJNA1050291	14092	297	2.075893	6.16540221	Bacteria	2	Bacteria	Bacteria	67	4.25e-11	NR	MFA5251620.1	2026778	g13201	i0	44.3	1.94949494949495	97	51	98	2	292	2	86	179	MFA5251620.1 AP2 domain-containing protein [Phycisphaerae bacterium]	diamond	579	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31995171	31995171	PRJNA1050291_P_NODE_18978_length_250_cov_0.881356_g18087_i0	PRJNA1050291	18978	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	1.87e-9	NR	MCH7988511.1	2026780	g18087	i0	35.4	0.984	82	53	98.4	0	248	3	152	233	MCH7988511.1 hypothetical protein [Planctomycetota bacterium]	diamond	246	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;