metadata: contig_metadata: 5 rows where bioproject = "PRJNA685060", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA685060", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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

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