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

8 rows where bioproject = "PRJNA949785" 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
933162	933162	PRJNA949785_P_NODE_17001_length_247_cov_0.885057_g16804_i0	PRJNA949785	17001	247	0.885057	2.18609079	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	91.6	4.73e-14	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g16804	i0	89.189	24.1376518218623	74	7	30	1	104	177	2206832	2206760	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	5962	91.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17511298	17511298	PRJNA949785_P_NODE_12314_length_290_cov_1.147465_g12117_i0	PRJNA949785	12314	290	1.147465	3.3276485	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	291	5.23e-74	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12117	i0	88.235	105.203448275862	255	15	85	11	44	290	7051644	7051397	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	30509	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22610196	22610196	PRJNA949785_P_NODE_19018_length_241_cov_0.916667_g18821_i0	PRJNA949785	19018	241	0.916667	2.20916747	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	342	1.1499999999999999e-89	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g18821	i0	92.531	31.8174273858921	241	14	100	3	1	241	1315762	1315526	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	7668	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26772323	26772323	PRJNA949785_P_NODE_16421_length_248_cov_1.320000_g16224_i0	PRJNA949785	16421	248	1.32	3.2736	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	46.6	0.00175	NR	MFA5202887.1	2053569	g16224	i0	52.9	0.411290322580645	34	16	41.1	0	1	102	47	80	MFA5202887.1 hypothetical protein [Lentisphaeria bacterium]	diamond	102	46.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28604634	28604634	PRJNA949785_P_NODE_17587_length_245_cov_0.895349_g17390_i0	PRJNA949785	17587	245	0.895349	2.19360505	Opitutales bacterium	2026772	Bacteria	Bacteria	44.3	0.011	NR	MFP4069785.1	2026772	g17390	i0	28.4	0.906122448979592	74	46	90.6	1	24	245	464	530	MFP4069785.1 alpha/beta fold hydrolase [Opitutales bacterium]	diamond	222	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28825361	28825361	PRJNA949785_P_NODE_15028_length_256_cov_1.262295_g14831_i0	PRJNA949785	15028	256	1.262295	3.2314752	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99	7.110000000000001e-22	NR	MCX5635177.1	2026780	g14831	i0	58.8	1.98046875	85	34	98.4	1	3	254	489	573	MCX5635177.1 type I DNA topoisomerase [Planctomycetota bacterium]	diamond	507	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30246931	30246931	PRJNA949785_P_NODE_8212_length_370_cov_1.555556_g8015_i0	PRJNA949785	8212	370	1.555556	5.7555572	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.3	0.0452	NR	HXI72534.1	2499141	g8015	i0	26.4	0.981081081081081	121	79	90.8	2	348	13	847	966	HXI72534.1 AAA domain-containing protein [Verrucomicrobiia bacterium]	diamond	363	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31511033	31511033	PRJNA949785_P_NODE_15856_length_250_cov_0.870056_g15659_i0	PRJNA949785	15856	250	0.870056	2.17514	Gemmata obscuriglobus	114	Bacteria	Bacteria	60.5	2.16e-8	NR	WP_010033308.1	114	g15659	i0	83.8	0.444	37	6	44.4	0	2	112	331	367	WP_010033308.1 hypothetical protein [Gemmata obscuriglobus]	diamond	111	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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);;