metadata: contig_metadata: 5 rows where bioproject = "PRJNA981359" and tax

5 rows where bioproject = "PRJNA981359" and tax_clade = "PVC group"

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_species
26804697	26804697	PRJNA981359_S_NODE_74461_length_237_cov_5.079268_g74361_i0	PRJNA981359	74461	237	5.079268	12.03786516	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0455	NR	NOX57190.1	2026780	g74361	i0	38.1	0.531645569620253	42	25	51.9	1	50	172	53	94	NOX57190.1 rhomboid family intramembrane serine protease [Planctomycetota bacterium]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
28984540	28984540	PRJNA981359_S_NODE_25828_length_340_cov_1.505618_g25728_i0	PRJNA981359	25828	340	1.505618	5.1191012	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	44.3	0.0272	NR	HUT56262.1	2026778	g25728	i0	39.2	0.45	51	31	45	0	108	260	161	211	HUT56262.1 MBL fold metallo-hydrolase [Phycisphaerae bacterium]	diamond	153	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
29457553	29457553	PRJNA981359_S_NODE_46530_length_288_cov_1.451163_g46430_i0	PRJNA981359	46530	288	1.451163	4.17934944	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	43.1	0.0332	NR	HOW36265.1	2035772	g46430	i0	37.2	0.447916666666667	43	27	44.8	0	60	188	100	142	HOW36265.1 imidazole glycerol phosphate synthase subunit HisH [Candidatus Omnitrophota bacterium]	diamond	129	43.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
31732909	31732909	PRJNA981359_S_NODE_74797_length_236_cov_2.392638_g74697_i0	PRJNA981359	74797	236	2.392638	5.64662568	Victivallaceae bacterium	2793042	Bacteria	Bacteria	41.6	0.0337	NR	MCQ2380568.1	2793042	g74697	i0	35.4	0.826271186440678	65	39	82.6	2	19	213	31	92	MCQ2380568.1 hypothetical protein [Victivallaceae bacterium]	diamond	195	41.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
32776022	32776022	PRJNA981359_S_NODE_38860_length_305_cov_1.681034_g38760_i0	PRJNA981359	38860	305	1.681034	5.1271537	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.9	0.028	NR	MBN2580312.1	2715253	g38760	i0	34.2	0.718032786885246	73	43	66.9	1	91	294	221	293	MBN2580312.1 phosphatidate cytidylyltransferase [Pirellulales bacterium]	diamond	219	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales		Pirellulales 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);;