metadata: contig_metadata: 11 rows where bioproject = "PRJNA554794" and tax

11 rows where bioproject = "PRJNA554794" 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
6227178	6227178	PRJNA554794_P_NODE_21145_length_184_cov_0.940741_g17216_i0	PRJNA554794	21145	184	0.940741	1.73096344	Rubinisphaera	1649490	Bacteria	Bacteria	167	5.37e-37	NTclustered	gi\|470488120\|ref\|NR_076852.1\|	119	g17216	i0	84.27	111.396739130435	178	20	97	8	7	184	189	20	Planctomyces brasiliensis strain DSM 5305 23S ribosomal RNA gene, complete sequence	blastn	20497	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
8173722	8173722	PRJNA554794_P_NODE_9627_length_424_cov_0.744000_g5784_i0	PRJNA554794	9627	424	0.744	3.15456	Pseudomonadati	3379134	Bacteria	Bacteria	186	6.45e-54	NR	NUQ33528.1	2026779	g5784	i0	73.6	23.6603773584906	121	32	85.6	0	1	363	346	466	NUQ33528.1 F0F1 ATP synthase subunit beta [Planctomycetaceae bacterium]	diamond	10032	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
9449318	9449318	PRJNA554794_P_NODE_22148_length_172_cov_0.934959_g18219_i0	PRJNA554794	22148	172	0.934959	1.6081294799999999	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|673538893\|gb\|KJ611645.1\|	100233	g18219	i0	100	101	172	0	100	0	1	172	264	435	Uncultured Planctomycetaceae bacterium clone 40-2_27 16S ribosomal RNA gene, partial sequence	blastn	17372	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20923111	20923111	PRJNA554794_P_NODE_23017_length_166_cov_0.752137_g19088_i0	PRJNA554794	23017	166	0.75213699999999994	1.24854742	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	248	1.65e-61	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g19088	i0	93.902	170.590361445783	164	10	99	0	1	164	1832284	1832447	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	28318	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
26951523	26951523	PRJNA554794_P_NODE_12662_length_268_cov_1.351598_g8733_i0	PRJNA554794	12662	268	1.351598	3.62228264	Phycisphaeraceae bacterium JB051	3342864	Bacteria	Bacteria	54.3	3.48e-6	NR	MFG0249595.1	3342864	g8733	i0	36.4	1.97014925373134	88	56	98.5	0	5	268	106	193	MFG0249595.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium JB051]	diamond	528	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium JB051
27394493	27394493	PRJNA554794_P_NODE_11803_length_298_cov_1.895582_g7874_i0	PRJNA554794	11803	298	1.895582	5.64883436	Chlamydiales bacterium	2047757	Bacteria	Bacteria	43.5	0.0348	NR	MDP1836552.1	2047757	g7874	i0	38.3	0.604026845637584	60	34	58.4	2	3	176	50	108	MDP1836552.1 choice-of-anchor A family protein [Chlamydiales bacterium]	diamond	180	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27836224	27836224	PRJNA554794_P_NODE_22204_length_171_cov_1.459016_g18275_i0	PRJNA554794	22204	171	1.459016	2.49491736	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0145	NR	MBN8643811.1	2026780	g18275	i0	38.2	4.75438596491228	55	32	96.5	1	4	168	289	341	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	813	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28404685	28404685	PRJNA554794_P_NODE_21306_length_182_cov_1.127820_g17377_i0	PRJNA554794	21306	182	1.12782	2.0526324	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.1	0.0119	NR	MBX3315538.1	2026777	g17377	i0	45.6	2.43956043956044	57	25	89	2	182	21	270	323	MBX3315538.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium]	diamond	444	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28499534	28499534	PRJNA554794_P_NODE_24207_length_162_cov_0.902655_g20278_i0	PRJNA554794	24207	162	0.902655	1.4623011	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	75.9	3.86e-16	NR	RYD73501.1	2026800	g20278	i0	78.4	0.944444444444444	51	11	94.4	0	155	3	4	54	RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium]	diamond	153	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32196394	32196394	PRJNA554794_P_NODE_23418_length_164_cov_1.321739_g19489_i0	PRJNA554794	23418	164	1.321739	2.16765196	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	108	5.71e-28	NR	MCP4190648.1	2026779	g19489	i0	92.6	1.97560975609756	54	4	98.8	0	162	1	140	193	MCP4190648.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	324	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32590660	32590660	PRJNA554794_P_NODE_6219_length_796_cov_1.160643_g3043_i0	PRJNA554794	6219	796	1.160643	9.23871828	PVC group	1783257	Bacteria	Bacteria	54.7	1.79e-4	NR	MBN8603554.1	2026780	g3043	i0	33.1	1.43969849246231	121	76	44.5	4	734	381	212	330	MBN8603554.1 hypothetical protein [Planctomycetota bacterium]	diamond	1146	55.1	0.992740471869329	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);;