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

7 rows where bioproject = "PRJNA889065", 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
21265307	21265307	PRJNA889065_S_NODE_20057_length_217_cov_2.316092_g19819_i0	PRJNA889065	20057	217	2.316092	5.02591964	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	109	6.42e-26	NR	MFN9993795.1	2052180	g19819	i0	72.7	2.05990783410138	77	16	99.5	1	217	2	410	486	MFN9993795.1 adenosylhomocysteinase [Phycisphaerales bacterium]	diamond	447	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26960409	26960409	PRJNA889065_S_NODE_5862_length_389_cov_5.398844_g5624_i0	PRJNA889065	5862	389	5.398844	21.00150316	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	160	5.55e-45	NR	MAT68612.1	2026779	g5624	i0	66	0.794344473007712	103	34	79.4	1	311	3	269	370	MAT68612.1 methionine sulfoxide reductase [Planctomycetaceae bacterium]	diamond	309	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27560860	27560860	PRJNA889065_S_NODE_6044_length_383_cov_5.182353_g5806_i0	PRJNA889065	6044	383	5.182353	19.84841199	Lignipirellula cremea	2528010	Bacteria	Bacteria	92	3.64e-19	NR	WP_145051958.1	2528010	g5806	i0	38.2	4.05744125326371	131	74	97.9	3	378	4	203	332	WP_145051958.1 DNA/RNA non-specific endonuclease [Lignipirellula cremea]	diamond	1554	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
29171441	29171441	PRJNA889065_S_NODE_28449_length_181_cov_2.000000_g28211_i0	PRJNA889065	28449	181	2	3.62	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57	4.24e-8	NR	MFH0938368.1	2026780	g28211	i0	52.1	1.5414364640884	48	23	79.6	0	8	151	120	167	MFH0938368.1 thioredoxin family protein [Planctomycetota bacterium]	diamond	279	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29897652	29897652	PRJNA889065_S_NODE_3271_length_494_cov_28.237251_g3046_i0	PRJNA889065	3271	494	28.237251	139.49201994	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	134	2.91e-36	NR	MCD4830981.1	2873829	g3046	i0	45.2	1.6336032388664	135	73	81.4	1	473	72	49	183	MCD4830981.1 DJ-1/PfpI family protein [Anaerohalosphaeraceae bacterium]	diamond	807	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
32466430	32466430	PRJNA889065_S_NODE_14319_length_256_cov_2.089202_g14081_i0	PRJNA889065	14319	256	2.089202	5.34835712	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	6.700000000000001e-22	NR	HLY75848.1	2026780	g14081	i0	52.9	3	85	39	98.4	1	2	253	101	185	HLY75848.1 metallophosphatase domain-containing protein [Planctomycetota bacterium]	diamond	768	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32718605	32718605	PRJNA889065_S_NODE_28060_length_183_cov_0.985714_g27822_i0	PRJNA889065	28060	183	0.985714	1.80385662	PVC group	1783257	Bacteria	Bacteria	42.7	0.0164	NR	HLY73621.1	2026780	g27822	i0	43.1	11.0983606557377	58	33	95.1	0	3	176	240	297	HLY73621.1 peptide chain release factor 1 [Planctomycetota bacterium]	diamond	2031	42.7	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);;