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

5 rows where bioproject = "PRJNA891846", 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
867419	867419	PRJNA891846_P_NODE_41121_length_247_cov_0.885057_g40901_i0	PRJNA891846	41121	247	0.885057	2.18609079	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	191	4.53e-44	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g40901	i0	80.723	38.4817813765182	249	44	100	3	1	247	453747	453501	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	9505	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
27908143	27908143	PRJNA891846_P_NODE_46145_length_242_cov_0.911243_g45925_i0	PRJNA891846	46145	242	0.911243	2.20520806	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	122	3.52e-30	NR	MAD26228.1	2026801	g45925	i0	69.6	0.979338842975207	79	24	97.9	0	239	3	1303	1381	MAD26228.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	237	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27940103	27940103	PRJNA891846_P_NODE_37625_length_250_cov_0.870056_g37405_i0	PRJNA891846	37625	250	0.870056	2.17514	Prosthecobacter sp.	1965333	Bacteria	Bacteria	136	4.58e-35	NR	WP_395716847.1	1965333	g37405	i0	92.8	1.992	83	6	99.6	0	2	250	196	278	WP_395716847.1 tetratricopeptide repeat protein [Prosthecobacter sp.]	diamond	498	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28350426	28350426	PRJNA891846_P_NODE_44966_length_243_cov_0.905882_g44746_i0	PRJNA891846	44966	243	0.905882	2.20129326	Opitutaceae bacterium	2006848	Bacteria	Bacteria	64.3	9.33e-10	NR	HEX2852909.1	2006848	g44746	i0	53.3	0.740740740740741	60	27	72.8	1	178	2	669	728	HEX2852909.1 immunoglobulin domain-containing protein [Opitutaceae bacterium]	diamond	180	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32205337	32205337	PRJNA891846_P_NODE_43238_length_245_cov_0.895349_g43018_i0	PRJNA891846	43238	245	0.895349	2.19360505	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	163	1.24e-45	NR	NBV38207.1	2026799	g43018	i0	95.1	0.991836734693878	81	4	99.2	0	244	2	62	142	NBV38207.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Verrucomicrobiota bacterium]	diamond	243	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;