metadata: contig_metadata: 6 rows where bioproject = "PRJNA385073", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA385073", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
15708260	15708260	PRJNA385073_P_NODE_16053_length_344_cov_1.527675_g15892_i0	PRJNA385073	16053	344	1.527675	5.255202	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	169	3.1e-37	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g15892	i0	82.212	38.8168604651163	208	25	58	9	121	319	708377	708173	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	13353	169	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium CCUG 44730
27233263	27233263	PRJNA385073_P_NODE_44043_length_250_cov_0.870056_g43881_i0	PRJNA385073	44043	250	0.870056	2.17514	Victivallis lenta	2606640	Bacteria	Bacteria	160	6.879999999999999e-48	NR	WP_106054054.1	2606640	g43881	i0	97.6	0.984	82	2	98.4	0	248	3	12	93	WP_106054054.1 orotate phosphoribosyltransferase [Victivallis lenta]	diamond	246	160	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis lenta
28243590	28243590	PRJNA385073_P_NODE_53846_length_244_cov_0.900585_g53684_i0	PRJNA385073	53846	244	0.900585	2.1974274	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	130	2.12e-35	NR	MFA6930095.1	2053569	g53684	i0	78.8	1.9672131147541	80	17	98.4	0	244	5	35	114	MFA6930095.1 ABC transporter substrate-binding protein [Lentisphaeria bacterium]	diamond	480	130	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
30707038	30707038	PRJNA385073_P_NODE_45574_length_249_cov_0.875000_g45412_i0	PRJNA385073	45574	249	0.875	2.17875	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	121	9.81e-30	NR	NLG00205.1	1932692	g45412	i0	97.6	0.987951807228916	82	2	98.8	0	248	3	2476	2557	NLG00205.1 hypothetical protein [Lentisphaerota bacterium]	diamond	246	121	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30959946	30959946	PRJNA385073_P_NODE_46654_length_248_cov_0.880000_g46492_i0	PRJNA385073	46654	248	0.88	2.1824	Oligosphaera ethanolica	760260	Bacteria	Bacteria	58.5	1.08e-7	NR	WP_307261160.1	760260	g46492	i0	81.3	0.387096774193548	32	6	38.7	0	99	4	1	32	WP_307261160.1 cellulase family glycosylhydrolase [Oligosphaera ethanolica]	diamond	96	58.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Oligosphaeria	Oligosphaerales	Oligosphaeraceae	Oligosphaera	Oligosphaera ethanolica
32761848	32761848	PRJNA385073_P_NODE_56800_length_242_cov_0.911243_g56638_i0	PRJNA385073	56800	242	0.911243	2.20520806	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	139	4.8e-37	NR	NLX27012.1	1932692	g56638	i0	86.1	0.979338842975207	79	11	97.9	0	239	3	1	79	NLX27012.1 IS5 family transposase [Lentisphaerota bacterium]	diamond	237	139	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;