metadata: contig_metadata: 15 rows where bioproject = "PRJNA889065" and tax

15 rows where bioproject = "PRJNA889065" 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_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
27094938	27094938	PRJNA889065_S_NODE_21902_length_208_cov_1.345455_g21664_i0	PRJNA889065	21902	208	1.345455	2.7985464	Pseudomonadati	3379134	Bacteria	Bacteria	62.8	1.86e-9	NR	MDQ6655875.1	2026799	g21664	i0	53.6	4.42788461538461	56	26	80.8	0	32	199	285	340	MDQ6655875.1 NADH:flavin oxidoreductase/NADH oxidase [Verrucomicrobiota bacterium]	diamond	921	63.2	0.993670886075949	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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
28168805	28168805	PRJNA889065_S_NODE_14945_length_251_cov_1.634615_g14707_i0	PRJNA889065	14945	251	1.634615	4.10288365	Bacteria	2	Bacteria	Bacteria	48.9	2.38e-4	NR	PYJ64909.1	2026799	g14707	i0	30.1	6.34661354581673	83	56	99.2	2	250	2	177	257	PYJ64909.1 MAG: class I SAM-dependent methyltransferase [Verrucomicrobiota bacterium]	diamond	1593	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
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
29305371	29305371	PRJNA889065_S_NODE_18909_length_224_cov_1.546961_g18671_i0	PRJNA889065	18909	224	1.546961	3.46519264	Pseudomonadati	3379134	Bacteria	Bacteria	79	7.32e-16	NR	KJJ86067.1	1609969	g18671	i0	62.7	10.3928571428571	59	22	79	0	221	45	5	63	KJJ86067.1 DnaJ class molecular chaperone [Candidatus Omnitrophus magneticus]	diamond	2328	79	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophus	Candidatus Omnitrophus magneticus
29400155	29400155	PRJNA889065_S_NODE_37109_length_156_cov_1.628319_g36871_i0	PRJNA889065	37109	156	1.628319	2.54017764	PVC group	1783257	Bacteria	Bacteria	64.3	2.71e-10	NR	MBU4478701.1	2035772	g36871	i0	65.3	1.90384615384615	49	17	94.2	0	149	3	116	164	MBU4478701.1 AarF/ABC1/UbiB kinase family protein [Candidatus Omnitrophota bacterium]	diamond	297	64.7	0.993817619783617	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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
30245261	30245261	PRJNA889065_S_NODE_2892_length_518_cov_11.785263_g2668_i0	PRJNA889065	2892	518	11.785263	61.04766234	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	129	3.05e-34	NR	MFA6379319.1	2035772	g2668	i0	43.9	3.86293436293436	164	83	93.8	5	3	488	21	177	MFA6379319.1 dihydrofolate reductase [Candidatus Omnitrophota bacterium]	diamond	2001	129	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30813755	30813755	PRJNA889065_S_NODE_36834_length_157_cov_1.210526_g36596_i0	PRJNA889065	36834	157	1.210526	1.90052582	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	50.4	2.21e-5	NR	MDO8675474.1	2035772	g36596	i0	66.7	0.630573248407643	33	11	63.1	0	1	99	453	485	MDO8675474.1 class I SAM-dependent DNA methyltransferase [Candidatus Omnitrophota bacterium]	diamond	99	50.4	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31066762	31066762	PRJNA889065_S_NODE_12735_length_270_cov_1.823789_g12497_i0	PRJNA889065	12735	270	1.823789	4.9242303	Spartobacteria bacterium	2052183	Bacteria	Bacteria	60.1	3.93e-8	NR	NCC52901.1	2052183	g12497	i0	45.6	0.755555555555556	68	37	75.6	0	65	268	57	124	NCC52901.1 hypothetical protein [Spartobacteria bacterium]	diamond	204	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
31168983	31168983	PRJNA889065_S_NODE_35135_length_161_cov_1.559322_g34897_i0	PRJNA889065	35135	161	1.559322	2.51050842	Bacteria	2	Bacteria	Bacteria	58.2	9.67e-9	NR	MCZ7638296.1	2026799	g34897	i0	56.8	1.63975155279503	44	18	82	1	1	132	108	150	MCZ7638296.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	264	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;