metadata: contig_metadata: 8 rows where bioproject = "PRJNA796975" and tax

8 rows where bioproject = "PRJNA796975" 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
10985154	10985154	PRJNA796975_S_NODE_12449_length_164_cov_0.886957_g12372_i0	PRJNA796975	12449	164	0.886957	1.45460948	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	204	3.5699999999999997e-48	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g12372	i0	89.441	8.92682926829268	161	17	100	0	4	164	1551760	1551600	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1464	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13970833	13970833	PRJNA796975_S_NODE_3931_length_227_cov_1.797753_g3854_i0	PRJNA796975	3931	227	1.797753	4.08089931	Bacteria	2	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g3854	i0	100	0.246696035242291	28	0	12	0	179	206	1415884	1415911	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
26958776	26958776	PRJNA796975_S_NODE_9362_length_167_cov_1.177966_g9285_i0	PRJNA796975	9362	167	1.177966	1.96720322	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	86.3	6.76e-19	NR	MBL0928261.1	2052180	g9285	i0	73.5	2.78443113772455	49	11	84.4	1	23	163	73	121	MBL0928261.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Phycisphaerales bacterium]	diamond	465	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28452757	28452757	PRJNA796975_S_NODE_12166_length_164_cov_0.886957_g12089_i0	PRJNA796975	12166	164	0.886957	1.45460948	Bacteria	2	Bacteria	Bacteria	49.3	6.24e-5	NR	MBO0697984.1	1914240	g12089	i0	48.3	4.40853658536585	58	24	97	3	160	2	79	135	MBO0697984.1 autotransporter-associated beta strand repeat-containing protein [Zavarzinella sp.]	diamond	723	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella sp.
29390860	29390860	PRJNA796975_S_NODE_11689_length_165_cov_0.879310_g11612_i0	PRJNA796975	11689	165	0.87931	1.4508615	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	53.1	2.45e-6	NR	MBV9658300.1	2026799	g11612	i0	50.9	2.03636363636364	57	25	98.2	1	2	163	111	167	MBV9658300.1 right-handed parallel beta-helix repeat-containing protein [Verrucomicrobiota bacterium]	diamond	336	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31001835	31001835	PRJNA796975_S_NODE_11094_length_165_cov_1.172414_g11017_i0	PRJNA796975	11094	165	1.172414	1.9344831	Gemmataceae bacterium	2052164	Bacteria	Bacteria	69.7	2.88e-13	NR	MFO0865520.1	2052164	g11017	i0	94.6	2.69090909090909	37	2	67.3	0	112	2	1	37	MFO0865520.1 response regulator [Gemmataceae bacterium]	diamond	444	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31823765	31823765	PRJNA796975_S_NODE_12157_length_164_cov_0.886957_g12080_i0	PRJNA796975	12157	164	0.886957	1.45460948	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	69.7	2.81e-12	NR	MES2707562.1	2026799	g12080	i0	72.2	0.98780487804878	54	15	98.8	0	2	163	180	233	MES2707562.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	162	69.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32362069	32362069	PRJNA796975_S_NODE_10959_length_166_cov_0.658120_g10882_i0	PRJNA796975	10959	166	0.65812	1.0924792	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0313	NR	MFN9704369.1	2026780	g10882	i0	53.1	1.1566265060241	32	15	57.8	0	140	45	89	120	MFN9704369.1 MipA/OmpV family protein [Planctomycetota bacterium]	diamond	192	41.6	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);;