metadata: contig_metadata: 26 rows where bioproject = "PRJNA407087" and tax

26 rows where bioproject = "PRJNA407087" 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
11284953	11284953	PRJNA407087_S_NODE_8749_length_162_cov_1.706767_g8286_i0	PRJNA407087	8749	162	1.706767	2.76496254	Gemmataceae	1914233	Bacteria	Bacteria	150	4.65e-32	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g8286	i0	83.832	29.4691358024691	167	18	100	8	1	162	3634723	3634885	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	4774	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
18933141	18933141	PRJNA407087_S_NODE_5875_length_208_cov_6.139665_g5412_i0	PRJNA407087	5875	208	6.139665	12.7705032	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	91.3	6.72e-21	NR	WP_077025744.1	1891926	g5412	i0	75	4.96153846153846	56	14	80.8	0	3	170	145	200	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	1032	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
26600317	26600317	PRJNA407087_S_NODE_3781_length_290_cov_3.256705_g3318_i0	PRJNA407087	3781	290	3.256705	9.4444445	Planctomycetota bacterium	2026780	Bacteria	Bacteria	157	4.029999999999999e-43	NR	MBL1217658.1	2026780	g3318	i0	78.1	8.8551724137931	96	21	99.3	0	1	288	178	273	MBL1217658.1 hypothetical protein [Planctomycetota bacterium]	diamond	2568	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26997078	26997078	PRJNA407087_S_NODE_4262_length_265_cov_16.872881_g3799_i0	PRJNA407087	4262	265	16.872881	44.71313465	Pseudomonadati	3379134	Bacteria	Bacteria	81.6	8.67e-17	NR	MBU6237403.1	2026780	g3799	i0	49.4	2.67169811320755	87	40	95.1	2	14	265	9	94	MBU6237403.1 peptidylprolyl isomerase [Planctomycetota bacterium]	diamond	708	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27296711	27296711	PRJNA407087_S_NODE_8903_length_160_cov_3.022901_g8440_i0	PRJNA407087	8903	160	3.022901	4.8366416	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.6	1.47e-16	NR	MCP4456285.1	2026780	g8440	i0	64.7	1.93125	51	18	95.6	0	3	155	36	86	MCP4456285.1 hypothetical protein [Planctomycetota bacterium]	diamond	309	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28686298	28686298	PRJNA407087_S_NODE_6127_length_203_cov_2.557471_g5664_i0	PRJNA407087	6127	203	2.557471	5.19166613	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	57	2.02e-7	NR	NUM34221.1	2517210	g5664	i0	52	0.738916256157635	50	24	73.9	0	49	198	392	441	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	150	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
29159861	29159861	PRJNA407087_S_NODE_6329_length_198_cov_4.934911_g5866_i0	PRJNA407087	6329	198	4.934911	9.77112378	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.1	2.58e-4	NR	MBN2714177.1	2026780	g5866	i0	41.2	1.03030303030303	68	36	97	2	198	7	174	241	MBN2714177.1 class I tRNA ligase family protein [Planctomycetota bacterium]	diamond	204	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29349185	29349185	PRJNA407087_S_NODE_3009_length_353_cov_2.645062_g2547_i0	PRJNA407087	3009	353	2.645062	9.33706886	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0215	NR	MBV9671622.1	2026799	g2547	i0	37	0.390934844192635	46	29	39.1	0	326	189	8	53	MBV9671622.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29443594	29443594	PRJNA407087_S_NODE_7650_length_176_cov_1.823129_g7187_i0	PRJNA407087	7650	176	1.823129	3.20870704	Chlamydiales bacterium	2047757	Bacteria	Bacteria	63.2	9.32e-10	NR	MFT5050156.1	2047757	g7187	i0	47.5	5.01136363636364	59	30	98.9	1	175	2	241	299	MFT5050156.1 acetylornithine deacetylase/succinyl-diaminopimelate desuccinylase-like protein [Chlamydiales bacterium]	diamond	882	63.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29475101	29475101	PRJNA407087_S_NODE_8130_length_169_cov_2.392857_g7667_i0	PRJNA407087	8130	169	2.392857	4.04392833	Planctomycetota bacterium	2026780	Bacteria	Bacteria	92	1.67e-21	NR	MEZ6183539.1	2026780	g7667	i0	74.5	3.90532544378698	55	14	97.6	0	4	168	46	100	MEZ6183539.1 peroxiredoxin [Planctomycetota bacterium]	diamond	660	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29632877	29632877	PRJNA407087_S_NODE_3830_length_287_cov_6.899225_g3367_i0	PRJNA407087	3830	287	6.899225	19.80077575	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	123	6.9699999999999986e-34	NR	MEI8196857.1	2026778	g3367	i0	62.4	8.78048780487805	93	35	97.2	0	281	3	5	97	MEI8196857.1 aldolase/citrate lyase family protein [Phycisphaerae bacterium]	diamond	2520	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29759414	29759414	PRJNA407087_S_NODE_8351_length_166_cov_2.854015_g7888_i0	PRJNA407087	8351	166	2.854015	4.7376649	Planctomycetota bacterium	2026780	Bacteria	Bacteria	88.2	1.28e-18	NR	MEE9394932.1	2026780	g7888	i0	67.3	1.98795180722892	55	18	99.4	0	1	165	321	375	MEE9394932.1 threonine--tRNA ligase [Planctomycetota bacterium]	diamond	330	88.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30201581	30201581	PRJNA407087_S_NODE_7232_length_181_cov_6.006579_g6769_i0	PRJNA407087	7232	181	6.006579	10.87190799	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	56.6	2.08e-7	NR	HYG84357.1	2499141	g6769	i0	61.7	0.779005524861878	47	18	77.9	0	2	142	232	278	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	141	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30265325	30265325	PRJNA407087_S_NODE_752_length_864_cov_6.673054_g476_i0	PRJNA407087	752	864	6.673054	57.65518656	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79.7	1.16e-13	NR	MEY2479657.1	2026799	g476	i0	34.6	2.52083333333333	191	112	65.3	7	799	236	7	187	MEY2479657.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	2178	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30580763	30580763	PRJNA407087_S_NODE_4153_length_270_cov_5.962656_g3690_i0	PRJNA407087	4153	270	5.962656	16.0991712	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	130	2.27e-34	NR	RYD65414.1	2026800	g3690	i0	73	0.988888888888889	89	22	98.9	1	3	269	120	206	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	267	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30580770	30580770	PRJNA407087_S_NODE_8233_length_167_cov_6.862319_g7770_i0	PRJNA407087	8233	167	6.862319	11.46007273	Mariniblastus sp.	2005381	Bacteria	Bacteria	84.3	1.2e-17	NR	MDG1873019.1	2005381	g7770	i0	69.1	2.94610778443114	55	17	98.8	0	166	2	27	81	MDG1873019.1 malate dehydrogenase [Mariniblastus sp.]	diamond	492	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus sp.
31086523	31086523	PRJNA407087_S_NODE_6255_length_200_cov_3.789474_g5792_i0	PRJNA407087	6255	200	3.789474	7.578948	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	84	4.19e-18	NR	OGN59821.1	1797601	g5792	i0	54.5	1.98	66	30	99	0	198	1	105	170	OGN59821.1 MAG: superoxide dismutase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	396	84	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
31149256	31149256	PRJNA407087_S_NODE_1855_length_488_cov_57.832244_g1412_i0	PRJNA407087	1855	488	57.832244	282.22135072	Chlamydiales bacterium	2047757	Bacteria	Bacteria	145	2.64e-41	NR	MCP5470421.1	2047757	g1412	i0	53	2.60655737704918	151	65	91.6	2	480	34	11	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1272	145	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31307700	31307700	PRJNA407087_S_NODE_5555_length_216_cov_4.647059_g5092_i0	PRJNA407087	5555	216	4.647059	10.03764744	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	42.7	0.0168	NR	HEY0008342.1	2876886	g5092	i0	43.4	0.736111111111111	53	30	73.6	0	214	56	78	130	HEY0008342.1 Hsp70 family protein [Tepidisphaeraceae bacterium]	diamond	159	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31529324	31529324	PRJNA407087_S_NODE_1576_length_538_cov_40.214145_g1152_i0	PRJNA407087	1576	538	40.214145	216.3521001	Chlamydiales bacterium	2047757	Bacteria	Bacteria	148	4.229999999999999e-42	NR	MCP5470421.1	2047757	g1152	i0	51.9	3.32899628252788	156	69	85.9	2	495	34	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1791	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31687256	31687256	PRJNA407087_S_NODE_3237_length_331_cov_3.582781_g2774_i0	PRJNA407087	3237	331	3.582781	11.85900511	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	98.6	2.13e-21	NR	NUM34221.1	2517210	g2774	i0	49.5	0.879154078549849	97	44	83.4	2	4	279	407	503	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	291	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
31798720	31798720	PRJNA407087_S_NODE_5157_length_229_cov_3.130000_g4694_i0	PRJNA407087	5157	229	3.13	7.1677	PVC group	1783257	Bacteria	Bacteria	43.1	0.0215	NR	MCM8819852.1	2035772	g4694	i0	32.8	1.63755458515284	61	41	79.9	0	18	200	80	140	MCM8819852.1 6-bladed beta-propeller [Candidatus Omnitrophota bacterium]	diamond	375	43.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32162048	32162048	PRJNA407087_S_NODE_2798_length_371_cov_5.520468_g2336_i0	PRJNA407087	2798	371	5.520468	20.48093628	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	108	1.19e-24	NR	HYG84357.1	2499141	g2336	i0	52.6	0.93800539083558	116	53	92.2	1	20	361	71	186	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	348	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32320437	32320437	PRJNA407087_S_NODE_7579_length_177_cov_1.979730_g7116_i0	PRJNA407087	7579	177	1.97973	3.5041221	Chlamydiales bacterium	2047757	Bacteria	Bacteria	103	1.52e-26	NR	MCP5470421.1	2047757	g7116	i0	82.8	0.983050847457627	58	10	98.3	0	3	176	53	110	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	174	103	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32699009	32699009	PRJNA407087_S_NODE_6360_length_198_cov_2.248521_g5897_i0	PRJNA407087	6360	198	2.248521	4.45207158	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	79	3.52e-15	NR	MCG3128574.1	2026778	g5897	i0	50	6.78787878787879	64	32	97	0	3	194	582	645	MCG3128574.1 3-isopropylmalate dehydratase large subunit [Phycisphaerae bacterium]	diamond	1344	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32699014	32699014	PRJNA407087_S_NODE_8360_length_166_cov_2.635036_g7897_i0	PRJNA407087	8360	166	2.635036	4.37415976	Pirellulales bacterium	2715253	Bacteria	Bacteria	84	3.58e-17	NR	HEY2839821.1	2715253	g7897	i0	74.1	0.975903614457831	54	13	97.6	1	164	3	78	130	HEY2839821.1 phosphoenolpyruvate carboxykinase (ATP) [Pirellulales bacterium]	diamond	162	84	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);;