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

5 rows where bioproject = "PRJNA492406", 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
8105571	8105571	PRJNA492406_P_NODE_20627_length_280_cov_1.937198_g20328_i0	PRJNA492406	20627	280	1.937198	5.4241544	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	372	1.7399999999999995e-98	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g20328	i0	91.039	132.657142857143	279	19	99	5	2	278	1728192	1728466	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	37144	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19578263	19578263	PRJNA492406_P_NODE_19856_length_284_cov_1.450237_g19557_i0	PRJNA492406	19856	284	1.450237	4.11867308	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g19557	i0	99.648	100.246478873239	284	1	100	0	1	284	408	125	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	28470	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
27392611	27392611	PRJNA492406_P_NODE_12343_length_355_cov_1.322695_g12044_i0	PRJNA492406	12343	355	1.322695	4.69556725	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	85.5	1.32e-16	NR	HYG84357.1	2499141	g12044	i0	46.5	1.07323943661972	127	45	88.7	5	39	353	225	350	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	381	85.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30929491	30929491	PRJNA492406_P_NODE_24694_length_260_cov_1.443850_g24395_i0	PRJNA492406	24694	260	1.44385	3.75401	Haloferula sargassicola	490096	Bacteria	Bacteria	85.9	1.96e-17	NR	WP_353568968.1	490096	g24395	i0	54.7	0.738461538461539	64	29	73.8	0	192	1	1	64	WP_353568968.1 radical SAM protein [Haloferula sargassicola]	diamond	192	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
31419566	31419566	PRJNA492406_P_NODE_12076_length_358_cov_1.396491_g11777_i0	PRJNA492406	12076	358	1.396491	4.99943778	Pseudomonadati	3379134	Bacteria	Bacteria	191	2.5199999999999997e-56	NR	MBL9213920.1	2006848	g11777	i0	78	46.9944134078212	118	26	98.9	0	356	3	213	330	MBL9213920.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Opitutaceae bacterium]	diamond	16824	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;