metadata: contig_metadata: 9 rows where bioproject = "PRJNA1073183", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA1073183", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
1016073	1016073	PRJNA1073183_P_NODE_4461_length_599_cov_1.638783_g4369_i0	PRJNA1073183	4461	599	1.638783	9.81631017	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	229	6.420000000000001e-73	NR	MFK7736369.1	2699754	g4369	i0	62.9	2.70951585976628	178	61	87.1	3	39	560	21	197	MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium]	diamond	1623	229	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
11665886	11665886	PRJNA1073183_P_NODE_24590_length_262_cov_2.005291_g24495_i0	PRJNA1073183	24590	262	2.005291	5.25386242	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	451	2.02e-122	NTclustered	gi\|389547028\|gb\|JQ401956.1\|	100233	g24495	i0	97.71	98.2328244274809	262	6	100	0	1	262	39	300	Uncultured Planctomycetaceae bacterium clone CNY_02197 16S ribosomal RNA gene, partial sequence	blastn	25737	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12941003	12941003	PRJNA1073183_P_NODE_25491_length_256_cov_3.234973_g25396_i0	PRJNA1073183	25491	256	3.234973	8.28153088	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	215	2.8e-51	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g25396	i0	85.922	113.05078125	206	23	79	6	9	211	4317291	4317089	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	28941	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15489960	15489960	PRJNA1073183_P_NODE_30873_length_245_cov_1.901163_g30778_i0	PRJNA1073183	30873	245	1.901163	4.65784935	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g30778	i0	92.653	194.951020408163	245	18	100	0	1	245	2002870	2002626	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47763	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17593823	17593823	PRJNA1073183_P_NODE_19314_length_297_cov_1.736607_g19219_i0	PRJNA1073183	19314	297	1.736607	5.15772279	Singulisphaera	466152	Bacteria	Bacteria	387	6.66e-103	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g19219	i0	90.301	118.043771043771	299	24	99	5	2	297	299	3	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	35059	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
27446861	27446861	PRJNA1073183_P_NODE_13103_length_358_cov_1.080702_g13008_i0	PRJNA1073183	13103	358	1.080702	3.86891316	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	68.9	8.84e-11	NR	WP_213498649.1	1123043	g13008	i0	28.2	2.70670391061453	131	80	98	1	6	356	468	598	WP_213498649.1 ATP-dependent zinc metalloprotease FtsH [Telmatocola sphagniphila]	diamond	969	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
31047157	31047157	PRJNA1073183_P_NODE_29015_length_248_cov_0.880000_g28920_i0	PRJNA1073183	29015	248	0.88	2.1824	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	81.6	2.07e-16	NR	MBN1974499.1	2813034	g28920	i0	64.2	0.641129032258065	53	19	64.1	0	162	4	8	60	MBN1974499.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	159	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
31164456	31164456	PRJNA1073183_P_NODE_28795_length_248_cov_0.880000_g28700_i0	PRJNA1073183	28795	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	147	4.73e-39	NR	MFN4244329.1	2795155	g28700	i0	82.9	9.91935483870968	82	14	99.2	0	246	1	1076	1157	MFN4244329.1 methionine synthase [Tepidisphaerales bacterium]	diamond	2460	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
32470455	32470455	PRJNA1073183_P_NODE_28439_length_249_cov_0.875000_g28344_i0	PRJNA1073183	28439	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00629	NR	MBL8754923.1	2026780	g28344	i0	42.9	0.927710843373494	77	32	83.1	4	214	8	14	86	MBL8754923.1 hypothetical protein [Planctomycetota bacterium]	diamond	231	43.9	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);;