metadata: contig_metadata: 9 rows where bioproject = "PRJNA1103784" and tax

9 rows where bioproject = "PRJNA1103784" 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
11690850	11690850	PRJNA1103784_P_NODE_5450_length_254_cov_1.287293_g5395_i0	PRJNA1103784	5450	254	1.287293	3.26972422	Planctomycetota bacterium	2026780	Bacteria	Bacteria	149	1.87e-40	NR	MEY4831052.1	2026780	g5395	i0	84.1	21.2952755905512	82	13	96.9	0	252	7	357	438	MEY4831052.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	5409	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23164456	23164456	PRJNA1103784_P_NODE_4239_length_277_cov_1.803922_g4184_i0	PRJNA1103784	4239	277	1.803922	4.99686394	Humisphaera borealis	2807512	Bacteria	Bacteria	370	6.19e-98	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4184	i0	90.714	228.285198555957	280	22	100	4	1	277	5063287	5063009	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	63235	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
27762930	27762930	PRJNA1103784_P_NODE_7264_length_243_cov_1.635294_g7209_i0	PRJNA1103784	7264	243	1.635294	3.97376442	Chthoniobacter sp.	2510640	Bacteria	Bacteria	72.8	9.17e-13	NR	MDR3405335.1	2510640	g7209	i0	82.9	0.506172839506173	41	7	50.6	0	3	125	424	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	123	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
30447018	30447018	PRJNA1103784_P_NODE_893_length_522_cov_1.699332_g838_i0	PRJNA1103784	893	522	1.699332	8.87051304	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	1.8e-9	NR	MCP4648866.1	2056642	g838	i0	44	0.574712643678161	100	56	57.5	0	169	468	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
31236641	31236641	PRJNA1103784_P_NODE_5615_length_251_cov_1.297753_g5560_i0	PRJNA1103784	5615	251	1.297753	3.25736003	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	123	5.849999999999999e-32	NR	RYD65414.1	2026800	g5560	i0	73.8	1.00398406374502	84	21	99.2	1	251	3	206	289	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	252	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31553298	31553298	PRJNA1103784_P_NODE_3676_length_290_cov_1.082949_g3621_i0	PRJNA1103784	3676	290	1.082949	3.1405521	Novipirellula caenicola	1536901	Bacteria	Bacteria	68.2	7.71e-11	NR	WP_345683361.1	1536901	g3621	i0	44.3	1.98620689655172	97	51	98.3	3	290	6	822	917	WP_345683361.1 Calx-beta domain-containing protein [Novipirellula caenicola]	diamond	576	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula caenicola
31733925	31733925	PRJNA1103784_P_NODE_4277_length_277_cov_0.950980_g4222_i0	PRJNA1103784	4277	277	0.95098	2.6342146	Bacteria	2	Bacteria	Bacteria	47	0.00184	NR	MFN0126353.1	2026801	g4222	i0	44.7	0.974729241877256	38	21	41.2	0	56	169	692	729	MFN0126353.1 LamG-like jellyroll fold domain-containing protein [Verrucomicrobiales bacterium]	diamond	270	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32027603	32027603	PRJNA1103784_P_NODE_3938_length_284_cov_1.218009_g3883_i0	PRJNA1103784	3938	284	1.218009	3.45914556	Coraliomargarita parva	3014050	Bacteria	Bacteria	80.1	2.83e-15	NR	WP_269524788.1	3014050	g3883	i0	43.8	0.940140845070423	89	50	94	0	8	274	84	172	WP_269524788.1 ADP-ribosylglycohydrolase family protein [Coraliomargarita parva]	diamond	267	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita parva
32154153	32154153	PRJNA1103784_P_NODE_6618_length_246_cov_1.687861_g6563_i0	PRJNA1103784	6618	246	1.687861	4.15213806	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	89.7	1.04e-19	NR	NQT91292.1	1932692	g6563	i0	54.9	1	82	36	100	1	1	246	104	184	NQT91292.1 NAD-dependent epimerase/dehydratase family protein [Lentisphaerota bacterium]	diamond	246	89.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;