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

12 rows where bioproject = "PRJNA1008624", 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
7378895	7378895	PRJNA1008624_P_NODE_19706_length_193_cov_1.236111_g19518_i0	PRJNA1008624	19706	193	1.236111	2.38569423	root	1	Root_unresolved	Root_unresolved	248	1.98e-61	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g19518	i0	90.155	15.2331606217617	193	15	99	4	2	192	7050908	7051098	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	2940	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26646912	26646912	PRJNA1008624_P_NODE_35181_length_163_cov_0.912281_g34993_i0	PRJNA1008624	35181	163	0.912281	1.48701803	PVC group	1783257	Bacteria	Bacteria	72	5.64e-13	NR	MCH8851105.1	2026780	g34993	i0	67.9	4.84049079754601	53	16	97.5	1	3	161	356	407	MCH8851105.1 AAA family ATPase [Planctomycetota bacterium]	diamond	789	72.4	0.994475138121547	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27698302	27698302	PRJNA1008624_P_NODE_20464_length_190_cov_1.468085_g20276_i0	PRJNA1008624	20464	190	1.468085	2.7893615	Isosphaera sp.	41672	Bacteria	Bacteria	76.3	2.85e-14	NR	MBA4065467.1	41672	g20276	i0	59	1.92631578947368	61	25	96.3	0	4	186	205	265	MBA4065467.1 hypothetical protein [Isosphaera sp.]	diamond	366	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
28582159	28582159	PRJNA1008624_P_NODE_28687_length_168_cov_0.873950_g28499_i0	PRJNA1008624	28687	168	0.87395	1.468236	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	49.7	4.73e-5	NR	HDZ44016.1	2026778	g28499	i0	43.6	0.982142857142857	55	27	98.2	2	2	166	295	345	HDZ44016.1 hypothetical protein [Phycisphaerae bacterium]	diamond	165	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28676843	28676843	PRJNA1008624_P_NODE_32907_length_165_cov_0.896552_g32719_i0	PRJNA1008624	32907	165	0.896552	1.4793108	Gemmatales bacterium	2838789	Bacteria	Bacteria	65.1	9.91e-11	NR	MFT3882049.1	2838789	g32719	i0	60.8	0.927272727272727	51	20	92.7	0	10	162	100	150	MFT3882049.1 hypothetical protein [Gemmatales bacterium]	diamond	153	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
29371424	29371424	PRJNA1008624_P_NODE_32929_length_165_cov_0.896552_g32741_i0	PRJNA1008624	32929	165	0.896552	1.4793108	Planctomycetia bacterium	2052181	Bacteria	Bacteria	98.2	2.9e-23	NR	HVJ82717.1	2052181	g32741	i0	87	1.96363636363636	54	7	98.2	0	1	162	25	78	HVJ82717.1 hypothetical protein [Planctomycetia bacterium]	diamond	324	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29908311	29908311	PRJNA1008624_P_NODE_35151_length_163_cov_0.912281_g34963_i0	PRJNA1008624	35151	163	0.912281	1.48701803	Planctomycetia bacterium	2052181	Bacteria	Bacteria	53.1	2.53e-6	NR	MDZ4783589.1	2052181	g34963	i0	100	0.478527607361963	26	0	47.9	0	3	80	310	335	MDZ4783589.1 DMT family transporter [Planctomycetia bacterium]	diamond	78	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29939915	29939915	PRJNA1008624_P_NODE_27851_length_169_cov_0.866667_g27663_i0	PRJNA1008624	27851	169	0.866667	1.46466723	Limnoglobus roseus	2598579	Bacteria	Bacteria	78.6	4.55e-16	NR	WP_149109288.1	2598579	g27663	i0	88.9	0.798816568047337	45	5	79.9	0	167	33	178	222	WP_149109288.1 YdjY domain-containing protein [Limnoglobus roseus]	diamond	135	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30256002	30256002	PRJNA1008624_P_NODE_27792_length_169_cov_0.866667_g27604_i0	PRJNA1008624	27792	169	0.866667	1.46466723	Pirellulales bacterium	2715253	Bacteria	Bacteria	82	1.13e-17	NR	MCC6127284.1	2715253	g27604	i0	70	1.84615384615385	50	15	88.8	0	150	1	8	57	MCC6127284.1 DUF2213 domain-containing protein [Pirellulales bacterium]	diamond	312	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30666360	30666360	PRJNA1008624_P_NODE_20113_length_191_cov_1.964789_g19925_i0	PRJNA1008624	20113	191	1.964789	3.75274699	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	68.6	1.47e-11	NR	MCU0702683.1	1914235	g19925	i0	49.5	1.58638743455497	101	12	97.4	1	5	190	303	403	MCU0702683.1 hypothetical protein [Fimbriiglobus sp.]	diamond	303	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
32405756	32405756	PRJNA1008624_P_NODE_27839_length_169_cov_0.866667_g27651_i0	PRJNA1008624	27839	169	0.866667	1.46466723	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	67.8	2.04e-11	NR	MDZ4849029.1	2699754	g27651	i0	57.7	0.923076923076923	52	22	92.3	0	165	10	723	774	MDZ4849029.1 hypothetical protein [Pirellulaceae bacterium]	diamond	156	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32595482	32595482	PRJNA1008624_P_NODE_30540_length_166_cov_1.683761_g30352_i0	PRJNA1008624	30540	166	1.683761	2.79504326	Limnoglobus roseus	2598579	Bacteria	Bacteria	44.7	0.00277	NR	WP_149108655.1	2598579	g30352	i0	45.3	0.957831325301205	53	29	95.8	0	163	5	7	59	WP_149108655.1 hypothetical protein [Limnoglobus roseus]	diamond	159	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus

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