metadata: contig_metadata: 12 rows where bioproject = "PRJNA685060" and tax

12 rows where bioproject = "PRJNA685060" 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
3216996	3216996	PRJNA685060_P_NODE_12003_length_269_cov_1.178571_g11913_i0	PRJNA685060	12003	269	1.178571	3.17035599	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	433	7.53e-117	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g11913	i0	97.255	161.371747211896	255	7	95	0	1	255	557890	558144	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	43409	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10870126	10870126	PRJNA685060_P_NODE_11269_length_279_cov_1.495146_g11179_i0	PRJNA685060	11269	279	1.495146	4.17145734	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	446	1.01e-120	NTclustered	gi\|18029206\|gb\|AF364577.1\|	174324	g11179	i0	95.668	101.046594982079	277	12	99	0	3	279	1	277	Uncultured Chlamydiales bacterium clone P-11 16S ribosomal RNA gene, partial sequence	blastn	28192	446	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
12145467	12145467	PRJNA685060_P_NODE_12970_length_255_cov_2.274725_g12880_i0	PRJNA685060	12970	255	2.274725	5.80054875	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	145	3.7199999999999995e-30	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g12880	i0	78.205	2.0078431372549	234	45	91	5	1	231	4074611	4074841	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	512	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
23619080	23619080	PRJNA685060_P_NODE_8719_length_322_cov_1.176707_g8629_i0	PRJNA685060	8719	322	1.176707	3.78899654	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	444	4.27e-120	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g8629	i0	91.615	111.673913043478	322	25	99	2	1	321	2167879	2168199	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	35959	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24892282	24892282	PRJNA685060_P_NODE_17020_length_242_cov_0.911243_g16930_i0	PRJNA685060	17020	242	0.911243	2.20520806	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	99	1.4699999999999999e-24	NR	MCK4873632.1	2052180	g16930	i0	61.3	2.97520661157025	80	31	99.2	0	240	1	30	109	MCK4873632.1 hypothetical protein [Phycisphaerales bacterium]	diamond	720	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28535123	28535123	PRJNA685060_P_NODE_10047_length_298_cov_0.862222_g9957_i0	PRJNA685060	10047	298	0.862222	2.56942156	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.00808	NR	MCY2932085.1	2026780	g9957	i0	41.5	0.654362416107383	65	38	65.4	0	38	232	55	119	MCY2932085.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium]	diamond	195	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28535137	28535137	PRJNA685060_P_NODE_4467_length_459_cov_2.507772_g4377_i0	PRJNA685060	4467	459	2.507772	11.51067348	Planctomycetota bacterium	2026780	Bacteria	Bacteria	94.7	2.98e-19	NR	MEE2886150.1	2026780	g4377	i0	41.5	4.88235294117647	147	74	95.4	5	17	454	1962	2097	MEE2886150.1 hypothetical protein [Planctomycetota bacterium]	diamond	2241	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30777374	30777374	PRJNA685060_P_NODE_16034_length_245_cov_0.895349_g15944_i0	PRJNA685060	16034	245	0.895349	2.19360505	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	55.1	1.39e-6	NR	HVZ93246.1	2052180	g15944	i0	42.7	0.918367346938776	75	38	85.7	1	1	210	92	166	HVZ93246.1 hypothetical protein [Phycisphaerales bacterium]	diamond	225	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31030324	31030324	PRJNA685060_P_NODE_16075_length_244_cov_2.701754_g15985_i0	PRJNA685060	16075	244	2.701754	6.59227976	Lacunisphaera sp.	1961806	Bacteria	Bacteria	44.7	0.00784	NR	HTL66095.1	1961806	g15985	i0	32.3	1.52459016393443	62	42	76.2	0	238	53	246	307	HTL66095.1 hypothetical protein [Lacunisphaera sp.]	diamond	372	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
32421797	32421797	PRJNA685060_P_NODE_16299_length_244_cov_0.900585_g16209_i0	PRJNA685060	16299	244	0.900585	2.1974274	Opitutaceae bacterium	2006848	Bacteria	Bacteria	80.1	1.76e-15	NR	MFA6288461.1	2006848	g16209	i0	51.9	0.971311475409836	79	37	95.9	1	236	3	124	202	MFA6288461.1 hypothetical protein [Opitutaceae bacterium]	diamond	237	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32516945	32516945	PRJNA685060_P_NODE_17959_length_201_cov_4.265625_g17869_i0	PRJNA685060	17959	201	4.265625	8.57390625	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	42.4	0.0291	NR	WP_068771961.1	1184151	g17869	i0	46.2	0.582089552238806	39	18	58.2	1	185	69	465	500	WP_068771961.1 alpha/beta hydrolase [Termitidicoccus mucosus]	diamond	117	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
32548587	32548587	PRJNA685060_P_NODE_13999_length_250_cov_0.870056_g13909_i0	PRJNA685060	13999	250	0.870056	2.17514	Aeoliella straminimaris	2954799	Bacteria	Bacteria	107	6.71e-25	NR	WP_252854990.1	2954799	g13909	i0	85	0.72	60	9	72	0	70	249	434	493	WP_252854990.1 ABC transporter permease subunit [Aeoliella straminimaris]	diamond	180	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella straminimaris

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