metadata: contig_metadata: 7 rows where bioproject = "PRJNA951412", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA951412", 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
10191521	10191521	PRJNA951412_P_NODE_6208_length_246_cov_0.901734_g6123_i0	PRJNA951412	6208	246	0.901734	2.21826564	Botrimarina	2795782	Bacteria	Bacteria	285	2.01e-72	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g6123	i0	88.235	2.05691056910569	238	28	97	0	1	238	2133335	2133572	Planctomycetes bacterium K2D chromosome, complete genome	blastn	506	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
16237627	16237627	PRJNA951412_P_NODE_3813_length_258_cov_1.254054_g3728_i0	PRJNA951412	3813	258	1.254054	3.23545932	Neorhodopirellula lusitana	445327	Bacteria	Bacteria	134	4.49e-36	NR	WP_404308400.1	445327	g3728	i0	70.6	2.98837209302326	85	24	97.7	1	3	254	115	199	WP_404308400.1 NADPH-dependent aldehyde reductase Ahr [Neorhodopirellula lusitana]	diamond	771	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana
26708720	26708720	PRJNA951412_P_NODE_7601_length_243_cov_0.905882_g7516_i0	PRJNA951412	7601	243	0.905882	2.20129326	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	126	3.6899999999999996e-32	NR	MCA8985066.1	2026779	g7516	i0	100	0.703703703703704	57	0	70.4	0	3	173	414	470	MCA8985066.1 methyltransferase domain-containing protein [Planctomycetaceae bacterium]	diamond	171	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26835851	26835851	PRJNA951412_P_NODE_7701_length_242_cov_0.923077_g7616_i0	PRJNA951412	7701	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	82	2.16e-16	NR	MBX7106043.1	2052164	g7616	i0	51.3	0.991735537190083	80	37	99.2	1	3	242	185	262	MBX7106043.1 HNH endonuclease [Gemmataceae bacterium]	diamond	240	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29520264	29520264	PRJNA951412_P_NODE_2090_length_323_cov_1.116000_g2005_i0	PRJNA951412	2090	323	1.116	3.60468	Planctomycetota bacterium	2026780	Bacteria	Bacteria	124	3.0299999999999997e-30	NR	MEC9373988.1	2026780	g2005	i0	57.7	6.52941176470588	104	44	96.6	0	10	321	657	760	MEC9373988.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	2109	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32340229	32340229	PRJNA951412_P_NODE_5579_length_248_cov_0.891429_g5494_i0	PRJNA951412	5579	248	0.891429	2.21074392	Pseudomonadati	3379134	Bacteria	Bacteria	126	6.52e-33	NR	MFO0847386.1	2052164	g5494	i0	69.5	1.98387096774194	82	25	99.2	0	1	246	165	246	MFO0847386.1 fatty acid desaturase [Gemmataceae bacterium]	diamond	492	127	0.992125984251969	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32365286	32365286	PRJNA951412_P_NODE_6479_length_246_cov_0.890173_g6394_i0	PRJNA951412	6479	246	0.890173	2.18982558	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	52.8	1.09e-5	NR	HEV3164829.1	2691532	g6394	i0	39.3	1.02439024390244	84	46	98.8	2	2	244	330	411	HEV3164829.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	252	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae 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);;