metadata: contig_metadata: 12 rows where bioproject = "PRJNA407368", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA407368", 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
2965806	2965806	PRJNA407368_S_NODE_3523_length_312_cov_9.685512_g3421_i0	PRJNA407368	3523	312	9.685512	30.21879744	planctomycete str. 139	149588	Bacteria	Bacteria	433	8.92e-117	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g3421	i0	92.308	203.163461538462	312	12	100	8	1	312	1857	1558	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	63387	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
4242184	4242184	PRJNA407368_S_NODE_4524_length_267_cov_31.550420_g4422_i0	PRJNA407368	4524	267	31.55042	84.2396214	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	316	7.849999999999998e-82	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g4422	i0	88.192	355.277153558052	271	25	100	5	1	267	1600806	1600539	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	94859	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
5518778	5518778	PRJNA407368_S_NODE_1285_length_556_cov_38.753321_g1199_i0	PRJNA407368	1285	556	38.753321	215.46846476	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	616	1.5499999999999996e-171	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1199	i0	87.57	150.210431654676	539	58	96	8	21	556	1866215	1866747	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	83517	616	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9343163	9343163	PRJNA407368_S_NODE_10088_length_155_cov_3.301587_g9986_i0	PRJNA407368	10088	155	3.301587	5.11745985	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	121	3.439999999999999e-23	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g9986	i0	81.013	8.71612903225807	158	24	99	6	1	153	1575890	1575734	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	1351	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10009783	10009783	PRJNA407368_S_NODE_4228_length_279_cov_27.968000_g4126_i0	PRJNA407368	4228	279	27.968	78.03072	Gemmata	113	Bacteria	Bacteria	363	1.0499999999999999e-95	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g4126	i0	90.323	303.795698924731	279	23	99	4	3	279	1036073	1036349	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	84759	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
22758671	22758671	PRJNA407368_S_NODE_7678_length_186_cov_3.299363_g7576_i0	PRJNA407368	7678	186	3.299363	6.13681518	Planctomycetia	203683	Bacteria	Bacteria	252	1.46e-62	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g7576	i0	93.529	116.586021505376	170	9	96	2	9	177	1156589	1156757	Planctomyces sp. SH-PL62, complete genome	blastn	21685	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
26600321	26600321	PRJNA407368_S_NODE_2181_length_415_cov_9.398964_g2080_i0	PRJNA407368	2181	415	9.398964	39.0057006	Planctomycetota bacterium	2026780	Bacteria	Bacteria	79	2.56e-14	NR	MFO0417818.1	2026780	g2080	i0	35.5	1.01927710843373	141	74	94	5	3	392	13	147	MFO0417818.1 hypothetical protein [Planctomycetota bacterium]	diamond	423	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27549309	27549309	PRJNA407368_S_NODE_7164_length_195_cov_4.584337_g7062_i0	PRJNA407368	7164	195	4.584337	8.93945715	Planctomycetes bacterium RBG_13_5	2026780	Bacteria	Bacteria	77.4	2.77e-15	NR	OHB65247.1	1801962	g7062	i0	57.8	0.984615384615385	64	27	98.5	0	194	3	10	73	OHB65247.1 MAG: hypothetical protein A2168_08255 [Planctomycetes bacterium RBG_13_50_24]	diamond	192	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RBG_13_50_24
30201586	30201586	PRJNA407368_S_NODE_7672_length_186_cov_3.675159_g7570_i0	PRJNA407368	7672	186	3.675159	6.83579574	Planctomycetes bacterium RBG_13_5	2026780	Bacteria	Bacteria	55.5	4e-7	NR	OHB65247.1	1801962	g7570	i0	48.2	1.80645161290323	56	28	88.7	1	184	20	67	122	OHB65247.1 MAG: hypothetical protein A2168_08255 [Planctomycetes bacterium RBG_13_50_24]	diamond	336	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RBG_13_50_24
30675616	30675616	PRJNA407368_S_NODE_4873_length_253_cov_5.401786_g4771_i0	PRJNA407368	4873	253	5.401786	13.66651858	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.2	2.1e-8	NR	MEM8668760.1	2026780	g4771	i0	48.8	0.509881422924901	43	22	51	0	201	73	14	56	MEM8668760.1 hypothetical protein [Planctomycetota bacterium]	diamond	129	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30897124	30897124	PRJNA407368_S_NODE_5194_length_242_cov_3.544601_g5092_i0	PRJNA407368	5194	242	3.544601	8.57793442	Zavarzinella formosa	360055	Bacteria	Bacteria	61.2	1.59e-9	NR	WP_157369949.1	360055	g5092	i0	58.9	0.694214876033058	56	22	68.2	1	2	166	15	70	WP_157369949.1 hypothetical protein [Zavarzinella formosa]	diamond	168	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
32351969	32351969	PRJNA407368_S_NODE_10299_length_153_cov_2.806452_g10197_i0	PRJNA407368	10299	153	2.806452	4.29387156	Gemmataceae bacterium	2052164	Bacteria	Bacteria	58.5	2.78e-8	NR	MFO0930928.1	2052164	g10197	i0	66	0.92156862745098	47	16	92.2	0	5	145	217	263	MFO0930928.1 ISAs1 family transposase [Gemmataceae bacterium]	diamond	141	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;