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

5 rows where bioproject = "PRJEB27957", 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
3849588	3849588	PRJEB27957_P_NODE_41564_length_249_cov_1.300000_g41454_i0	PRJEB27957	41564	249	1.3	3.237	Candidatus Jettenia caeni	247490	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2556874801\|gb\|CP129467.1\|	247490	g41454	i0	100	0.116465863453815	29	0	12	0	196	224	2781580	2781608	MAG: Candidatus Jettenia caeni isolate YC-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia caeni
19148916	19148916	PRJEB27957_P_NODE_52716_length_227_cov_1.168539_g52606_i0	PRJEB27957	52716	227	1.168539	2.65258353	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g52606	i0	100	0.127753303964758	29	0	13	0	33	61	4471859	4471887	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27538828	27538828	PRJEB27957_P_NODE_68304_length_205_cov_1.333333_g68194_i0	PRJEB27957	68304	205	1.333333	2.73333265	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.1	0.0169	NR	RZO63680.1	2026777	g68194	i0	44.2	0.629268292682927	43	24	62.9	0	165	37	19	61	RZO63680.1 MAG: hypothetical protein EVA78_05740 [Phycisphaeraceae bacterium]	diamond	129	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31803034	31803034	PRJEB27957_P_NODE_78297_length_193_cov_1.583333_g78187_i0	PRJEB27957	78297	193	1.583333	3.05583269	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.6	0.0474	NR	MBN2448429.1	2026778	g78187	i0	56.8	0.575129533678757	37	12	57.5	1	170	60	277	309	MBN2448429.1 hypothetical protein [Phycisphaerae bacterium]	diamond	111	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32467873	32467873	PRJEB27957_P_NODE_70919_length_202_cov_1.019608_g70809_i0	PRJEB27957	70919	202	1.019608	2.05960816	Pirellulales bacterium	2715253	Bacteria	Bacteria	42.7	0.0222	NR	HEV3418293.1	2715253	g70809	i0	60.7	0.415841584158416	28	11	41.6	0	202	119	113	140	HEV3418293.1 chemotaxis protein CheB [Pirellulales bacterium]	diamond	84	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;