metadata: contig_metadata: 11 rows where bioproject = "PRJNA206070" and tax

11 rows where bioproject = "PRJNA206070" and tax_clade = "PVC group"

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
14395461	14395461	PRJNA206070_S_NODE_23352_length_182_cov_2.372414_g21476_i0	PRJNA206070	23352	182	2.372414	4.31779348	Fontisphaera persica	2974023	Bacteria	Bacteria	281	1.81e-71	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g21476	i0	94.505	175.065934065934	182	10	100	0	1	182	3861982	3861801	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	31862	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
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
19492191	19492191	PRJNA206070_S_NODE_15396_length_259_cov_2.684685_g13520_i0	PRJNA206070	15396	259	2.684685	6.95333415	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	71.3	6.51e-8	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g13520	i0	92	0.328185328185328	50	4	19	0	206	255	1221812	1221763	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	85	71.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19492244	19492244	PRJNA206070_S_NODE_17696_length_229_cov_1.010417_g15820_i0	PRJNA206070	17696	229	1.010417	2.31385493	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	204	5.33e-48	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g15820	i0	83.111	0.982532751091703	225	36	98	2	4	227	3216694	3216471	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	225	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23318177	23318177	PRJNA206070_S_NODE_11399_length_339_cov_2.711921_g9523_i0	PRJNA206070	11399	339	2.711921	9.19341219	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	409	1.65e-109	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9523	i0	88.596	73.2153392330383	342	32	99	7	1	338	1315941	1316279	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	24820	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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
27358610	27358610	PRJNA206070_S_NODE_23223_length_183_cov_1.746575_g21347_i0	PRJNA206070	23223	183	1.746575	3.19623225	Prosthecobacter sp.	1965333	Bacteria	Bacteria	57	1.92e-8	NR	WP_395739302.1	1965333	g21347	i0	58.3	0.983606557377049	60	24	98.4	1	180	1	59	117	WP_395739302.1 hypothetical protein [Prosthecobacter sp.]	diamond	180	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
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
31861640	31861640	PRJNA206070_S_NODE_5317_length_697_cov_3.309091_g3530_i0	PRJNA206070	5317	697	3.309091	23.06436427	Bacteria	2	Bacteria	Bacteria	156	3.269999999999999e-42	NR	MCR5183256.1	2026772	g3530	i0	50	4.63988522238164	154	60	61.1	4	5	430	186	334	MCR5183256.1 adenine-specific methyltransferase EcoRI family protein [Opitutales bacterium]	diamond	3234	157	0.993630573248408	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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);;