metadata: contig_metadata: 20 rows where bioproject = "PRJNA235310" and tax

20 rows where bioproject = "PRJNA235310" 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
1642143	1642143	PRJNA235310_P_NODE_2462_length_246_cov_1.284264_g2436_i0	PRJNA235310	2462	246	1.284264	3.15928944	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g2436	i0	91.6	116.829268292683	250	14	100	6	1	246	2759258	2759504	Planctomyces sp. SH-PL62, complete genome	blastn	28740	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
2917942	2917942	PRJNA235310_P_NODE_1883_length_289_cov_1.208333_g1857_i0	PRJNA235310	1883	289	1.208333	3.49208237	Singulisphaera acidiphila	466153	Bacteria	Bacteria	202	2.51e-47	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g1857	i0	83.482	319.688581314879	224	30	76	7	66	285	7354547	7354767	Singulisphaera acidiphila DSM 18658, complete genome	blastn	92390	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
8020797	8020797	PRJNA235310_P_NODE_6127_length_163_cov_0.912281_g6101_i0	PRJNA235310	6127	163	0.912281	1.48701803	Pseudomonadati	3379134	Bacteria	Bacteria	82.8	7.68e-17	NR	WP_068772074.1	1184151	g6101	i0	78.8	5.8159509202454	52	11	95.7	0	161	6	31	82	WP_068772074.1 phosphoglycerate kinase [Termitidicoccus mucosus]	diamond	948	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
9295419	9295419	PRJNA235310_P_NODE_2528_length_243_cov_0.958763_g2502_i0	PRJNA235310	2528	243	0.958763	2.32979409	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	267	7.19e-67	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g2502	i0	86.585	110.765432098765	246	28	100	5	1	243	267449	267206	Tautonia plasticadhaerens strain ElP chromosome	blastn	26916	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
14396364	14396364	PRJNA235310_P_NODE_112_length_871_cov_1.607056_g96_i0	PRJNA235310	112	871	1.607056	13.99745776	Parachlamydiales	1963360	Bacteria	Bacteria	346	3.709999999999999e-112	NR	WP_013182645.1	71667	g96	i0	59.4	10.0332950631458	266	102	91.6	3	1	798	344	603	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	8739	347	0.997118155619596	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27010593	27010593	PRJNA235310_P_NODE_5002_length_168_cov_1.747899_g4976_i0	PRJNA235310	5002	168	1.747899	2.93647032	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.7	0.00284	NR	MFH1046421.1	2035772	g4976	i0	44.4	0.803571428571429	45	25	80.4	0	140	6	1934	1978	MFH1046421.1 LamG-like jellyroll fold domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	135	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27105401	27105401	PRJNA235310_P_NODE_2982_length_220_cov_1.514620_g2956_i0	PRJNA235310	2982	220	1.51462	3.332164	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47	8.37e-4	NR	MBL0869689.1	2052180	g2956	i0	38	0.968181818181818	71	43	96.8	1	1	213	83	152	MBL0869689.1 choice-of-anchor A family protein [Phycisphaerales bacterium]	diamond	213	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27136769	27136769	PRJNA235310_P_NODE_4322_length_180_cov_1.190840_g4296_i0	PRJNA235310	4322	180	1.19084	2.143512	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	47.4	3.78e-4	NR	MDB6054328.1	2026801	g4296	i0	42.4	1.46666666666667	59	34	98.3	0	177	1	103	161	MDB6054328.1 UDP-3-O-acylglucosamine N-acyltransferase [Verrucomicrobiales bacterium]	diamond	264	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27881392	27881392	PRJNA235310_P_NODE_5105_length_168_cov_0.873950_g5079_i0	PRJNA235310	5105	168	0.87395	1.468236	Planctomycetota	203682	Bacteria	Bacteria	48.9	8.83e-5	NR	HEV3303939.1	2026779	g5079	i0	87.5	3.125	24	3	42.9	0	2	73	479	502	HEV3303939.1 aldehyde dehydrogenase family protein [Planctomycetaceae bacterium]	diamond	525	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28937298	28937298	PRJNA235310_P_NODE_6288_length_162_cov_0.920354_g6262_i0	PRJNA235310	6288	162	0.920354	1.49097348	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	103	1.9099999999999994e-24	NR	MCC7335815.1	2699754	g6262	i0	94.3	0.981481481481482	53	3	98.1	0	161	3	354	406	MCC7335815.1 DUF1501 domain-containing protein [Pirellulaceae bacterium]	diamond	159	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29221555	29221555	PRJNA235310_P_NODE_4629_length_173_cov_1.258065_g4603_i0	PRJNA235310	4629	173	1.258065	2.17645245	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.4	0.0016	NR	RJP31723.1	2052180	g4603	i0	42.2	0.780346820809249	45	26	78	0	3	137	178	222	RJP31723.1 MAG: CHRD domain-containing protein [Phycisphaerales bacterium]	diamond	135	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29239209	29239209	PRJNA235310_P_NODE_5949_length_164_cov_0.904348_g5923_i0	PRJNA235310	5949	164	0.904348	1.48313072	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	2.49e-6	NR	MDP6545667.1	2026778	g5923	i0	52.5	1.40853658536585	40	19	73.2	0	147	28	44	83	MDP6545667.1 hypothetical protein [Phycisphaerae bacterium]	diamond	231	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29396989	29396989	PRJNA235310_P_NODE_5629_length_166_cov_0.888889_g5603_i0	PRJNA235310	5629	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	53.5	7.44e-7	NR	WP_154931914.1	122	g5603	i0	50	5.53012048192771	52	25	92.2	1	12	164	58	109	WP_154931914.1 ankyrin repeat domain-containing protein [Gimesia maris]	diamond	918	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
30010967	30010967	PRJNA235310_P_NODE_2831_length_227_cov_1.168539_g2805_i0	PRJNA235310	2831	227	1.168539	2.65258353	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0308	NR	MEI8374410.1	2026780	g2805	i0	39.3	0.740088105726872	56	34	74	0	17	184	576	631	MEI8374410.1 hypothetical protein [Planctomycetota bacterium]	diamond	168	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30073848	30073848	PRJNA235310_P_NODE_1092_length_385_cov_0.928571_g1066_i0	PRJNA235310	1092	385	0.928571	3.57499835	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	60.5	6.82e-9	NR	HXJ56640.1	2499141	g1066	i0	34	0.732467532467532	94	58	73.2	1	59	340	11	100	HXJ56640.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	282	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30534026	30534026	PRJNA235310_P_NODE_253_length_679_cov_1.461905_g232_i0	PRJNA235310	253	679	1.461905	9.92633495	Pseudomonadati	3379134	Bacteria	Bacteria	55.5	4.6e-5	NR	MEZ5277925.1	2006848	g232	i0	42.9	1.36082474226804	77	34	29.6	2	14	214	185	261	MEZ5277925.1 kelch repeat-containing protein [Opitutaceae bacterium]	diamond	924	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31210955	31210955	PRJNA235310_P_NODE_4755_length_170_cov_1.289256_g4729_i0	PRJNA235310	4755	170	1.289256	2.1917352	Gemmataceae bacterium	2052164	Bacteria	Bacteria	44.7	0.00266	NR	HZZ80729.1	2052164	g4729	i0	51.4	0.652941176470588	37	16	61.8	1	154	50	111	147	HZZ80729.1 PEP-CTERM sorting domain-containing protein [Gemmataceae bacterium]	diamond	111	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32526590	32526590	PRJNA235310_P_NODE_2659_length_234_cov_1.610811_g2633_i0	PRJNA235310	2659	234	1.610811	3.76929774	PVC group	1783257	Bacteria	Bacteria	61.6	1.48e-9	NR	MEN8150348.1	2026780	g2633	i0	48.4	7.70512820512821	62	31	79.5	1	23	208	93	153	MEN8150348.1 macro domain-containing protein [Planctomycetota bacterium]	diamond	1803	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32540350	32540350	PRJNA235310_P_NODE_4959_length_169_cov_0.866667_g4933_i0	PRJNA235310	4959	169	0.866667	1.46466723	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	90.9	9.99e-20	NR	HEY4330435.1	2026778	g4933	i0	84.9	23.5207100591716	53	8	94.1	0	3	161	333	385	HEY4330435.1 Clp protease N-terminal domain-containing protein [Phycisphaerae bacterium]	diamond	3975	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32697541	32697541	PRJNA235310_P_NODE_1620_length_315_cov_2.150376_g1594_i0	PRJNA235310	1620	315	2.150376	6.7736844	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	63.9	3.28e-9	NR	MCL4205693.1	2699754	g1594	i0	38.8	0.933333333333333	98	60	93.3	0	296	3	1763	1860	MCL4205693.1 VCBS repeat-containing protein [Pirellulaceae bacterium]	diamond	294	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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);;