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

5 rows where bioproject = "PRJNA206070", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
366424	366424	PRJNA206070_S_NODE_26241_length_167_cov_2.546154_g24365_i0	PRJNA206070	26241	167	2.546154	4.25207718	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	213	6.07e-51	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g24365	i0	89.881	7.9940119760479	168	14	99	2	1	165	1867601	1867768	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1335	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9294449	9294449	PRJNA206070_S_NODE_22248_length_189_cov_1.789474_g20372_i0	PRJNA206070	22248	189	1.789474	3.38210586	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.07e-17	NR	HZV04970.1	2052164	g20372	i0	64.5	3.82539682539683	62	22	98.4	0	187	2	160	221	HZV04970.1 class II aldolase/adducin family protein [Gemmataceae bacterium]	diamond	723	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
18218195	18218195	PRJNA206070_S_NODE_31275_length_151_cov_1.245614_g29399_i0	PRJNA206070	31275	151	1.245614	1.88087714	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	171	3.26e-38	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g29399	i0	87.662	31.5364238410596	154	10	99	3	2	151	7050665	7050813	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	4762	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23318377	23318377	PRJNA206070_S_NODE_19219_length_213_cov_1.875000_g17343_i0	PRJNA206070	19219	213	1.875	3.99375	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	302	1.69e-77	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g17343	i0	92.891	43.0046948356808	211	10	98	4	1	209	4317533	4317326	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	9160	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
31102651	31102651	PRJNA206070_S_NODE_19395_length_211_cov_3.775862_g17519_i0	PRJNA206070	19395	211	3.775862	7.96706882	Pseudomonadati	3379134	Bacteria	Bacteria	84	5.88e-17	NR	WP_020469806.1	360055	g17519	i0	58	2.80094786729858	69	29	98.1	0	3	209	152	220	WP_020469806.1 hypothetical protein [Zavarzinella formosa]	diamond	591	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa

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