metadata: contig_metadata: 8 rows where bioproject = "PRJNA1093008", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA1093008", 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
6576466	6576466	PRJNA1093008_S_NODE_43906_length_305_cov_1.659483_g43579_i0	PRJNA1093008	43906	305	1.659483	5.06142315	Rohdeia mirabilis	2528008	Bacteria	Bacteria	436	6.719999999999999e-118	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g43579	i0	92.557	128.170491803279	309	16	100	6	1	305	3892973	3893278	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	39092	436	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
9947189	9947189	PRJNA1093008_S_NODE_46968_length_299_cov_2.500000_g46641_i0	PRJNA1093008	46968	299	2.5	7.475	Planctomycetia	203683	Bacteria	Bacteria	401	2.3999999999999993e-107	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g46641	i0	94.595	158.996655518395	259	14	87	0	1	259	4317940	4318198	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	47540	403	0.995037220843672	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26750686	26750686	PRJNA1093008_S_NODE_77521_length_255_cov_2.115385_g77194_i0	PRJNA1093008	77521	255	2.115385	5.39423175	Paludisphaera sp.	2017432	Bacteria	Bacteria	90.9	2.43e-19	NR	WP_337174845.1	2017432	g77194	i0	58.6	0.823529411764706	70	29	82.4	0	40	249	1	70	WP_337174845.1 carboxylate-amine ligase [Paludisphaera sp.]	diamond	210	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.
29025845	29025845	PRJNA1093008_S_NODE_82588_length_250_cov_1.740113_g82261_i0	PRJNA1093008	82588	250	1.740113	4.3502825	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0153	NR	MCH8217179.1	2026780	g82261	i0	26.5	0.816	68	47	78	1	250	56	1	68	MCH8217179.1 hypothetical protein [Planctomycetota bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29088763	29088763	PRJNA1093008_S_NODE_75308_length_258_cov_1.248649_g74981_i0	PRJNA1093008	75308	258	1.248649	3.22151442	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.5	0.0238	NR	MDR2438853.1	2026779	g74981	i0	43.8	0.558139534883721	48	22	50	1	186	58	133	180	MDR2438853.1 porin [Planctomycetaceae bacterium]	diamond	144	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30541494	30541494	PRJNA1093008_S_NODE_37193_length_319_cov_3.906504_g36866_i0	PRJNA1093008	37193	319	3.906504	12.46174776	Gemmataceae bacterium	2052164	Bacteria	Bacteria	42.4	0.0442	NR	MFO0841988.1	2052164	g36866	i0	53.8	0.244514106583072	26	12	24.5	0	216	139	81	106	MFO0841988.1 hypothetical protein [Gemmataceae bacterium]	diamond	78	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32249294	32249294	PRJNA1093008_S_NODE_79018_length_254_cov_1.016575_g78691_i0	PRJNA1093008	79018	254	1.016575	2.5821005	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.5	0.0226	NR	MSR40364.1	2052180	g78691	i0	28.4	1.03937007874016	88	41	78	2	28	225	380	467	MSR40364.1 hypothetical protein [Phycisphaerales bacterium]	diamond	264	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32557001	32557001	PRJNA1093008_S_NODE_16099_length_394_cov_3.828660_g15773_i0	PRJNA1093008	16099	394	3.82866	15.0849204	root	1	Root_unresolved	Root_unresolved	107	3.07e-26	NR	MBZ0109748.1	1872076	g15773	i0	56.1	4.90355329949239	107	45	80.7	2	3	320	76	181	MBZ0109748.1 DJ-1/PfpI family protein [Candidatus Scalindua rubra]	diamond	1932	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua rubra

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