metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA312615" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA312615" 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
11266905	11266905	PRJNA312615_P_NODE_1489_length_860_cov_10.145499_g1379_i0	PRJNA312615	1489	860	10.145499	87.2512914	Chthoniobacter sp.	2510640	Bacteria	Bacteria	500	1.1299999999999998e-174	NR	MDR3405335.1	2510640	g1379	i0	90.4	0.941860465116279	270	26	94.2	0	49	858	1	270	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	810	500	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
18229725	18229725	PRJNA312615_P_NODE_2355_length_731_cov_19.181818_g2231_i0	PRJNA312615	2355	731	19.181818	140.21908958	Chthoniobacter sp.	2510640	Bacteria	Bacteria	369	1.15e-123	NR	MDR3405335.1	2510640	g2231	i0	87.2	0.833105335157319	203	26	83.3	0	3	611	262	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	609	369	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
20779814	20779814	PRJNA312615_P_NODE_36757_length_202_cov_2.973856_g36606_i0	PRJNA312615	36757	202	2.973856	6.00718912	Planctomycetia	203683	Bacteria	Bacteria	102	2.03e-25	NR	WP_077025744.1	1891926	g36606	i0	75.8	4.63366336633663	62	15	92.1	0	201	16	139	200	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	936	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
26662442	26662442	PRJNA312615_P_NODE_51361_length_167_cov_0.881356_g51210_i0	PRJNA312615	51361	167	0.881356	1.47186452	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	41.6	0.0346	NR	HPA19938.1	2499141	g51210	i0	54.3	0.62874251497006	35	16	62.9	0	36	140	82	116	HPA19938.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	105	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27327196	27327196	PRJNA312615_P_NODE_28343_length_230_cov_1.121547_g28192_i0	PRJNA312615	28343	230	1.121547	2.5795581	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	67	1.13e-11	NR	MFL6568229.1	2201154	g28192	i0	62.5	1.23913043478261	48	18	62.6	0	228	85	115	162	MFL6568229.1 L,D-transpeptidase family protein [Chthoniobacterales bacterium]	diamond	285	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27376616	27376616	PRJNA312615_P_NODE_27063_length_235_cov_1.306452_g26912_i0	PRJNA312615	27063	235	1.306452	3.0701622	Opitutia	414999	Bacteria	Bacteria	95.9	6.740000000000001e-21	NR	MEZ5277587.1	2006848	g26912	i0	60	7.4936170212766	75	30	95.7	0	2	226	98	172	MEZ5277587.1 insulinase family protein [Opitutaceae bacterium]	diamond	1761	95.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28084890	28084890	PRJNA312615_P_NODE_43245_length_186_cov_1.153285_g43094_i0	PRJNA312615	43245	186	1.153285	2.1451101	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.1	3.7e-6	NR	MBM3999155.1	2026780	g43094	i0	40	2.80645161290323	60	36	96.8	0	5	184	426	485	MBM3999155.1 hypothetical protein [Planctomycetota bacterium]	diamond	522	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28748020	28748020	PRJNA312615_P_NODE_44847_length_182_cov_1.210526_g44696_i0	PRJNA312615	44847	182	1.210526	2.20315732	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.3	8.01e-5	NR	MEM8681583.1	2026780	g44696	i0	39	2.83516483516484	59	36	97.3	0	182	6	340	398	MEM8681583.1 hypothetical protein [Planctomycetota bacterium]	diamond	516	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28810800	28810800	PRJNA312615_P_NODE_34768_length_208_cov_1.283019_g34617_i0	PRJNA312615	34768	208	1.283019	2.66867952	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.6	1.54e-12	NR	MCZ6572710.1	2026780	g34617	i0	53.6	1.99038461538462	69	31	99.5	1	2	208	187	254	MCZ6572710.1 acetate--CoA ligase [Planctomycetota bacterium]	diamond	414	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28955267	28955267	PRJNA312615_P_NODE_51748_length_167_cov_0.864407_g51597_i0	PRJNA312615	51748	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	47.8	2.3e-4	NR	MCA9033902.1	2026779	g51597	i0	61.7	3.39520958083832	47	17	84.4	1	155	15	1684	1729	MCA9033902.1 tandem-95 repeat protein [Planctomycetaceae bacterium]	diamond	567	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28986869	28986869	PRJNA312615_P_NODE_20528_length_269_cov_1.222727_g20377_i0	PRJNA312615	20528	269	1.222727	3.28913563	PVC group	1783257	Bacteria	Bacteria	93.2	1.13e-21	NR	MCS6866835.1	1914242	g20377	i0	55.4	1.70631970260223	83	33	88.1	1	268	32	80	162	MCS6866835.1 glutathione peroxidase [Gemmata sp.]	diamond	459	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
29063897	29063897	PRJNA312615_P_NODE_36028_length_204_cov_2.670968_g35877_i0	PRJNA312615	36028	204	2.670968	5.44877472	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	61.2	7.75e-10	NR	MBX9742746.1	2201154	g35877	i0	53.3	0.882352941176471	60	26	88.2	1	180	1	22	79	MBX9742746.1 RidA family protein [Chthoniobacterales bacterium]	diamond	180	61.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29680894	29680894	PRJNA312615_P_NODE_27110_length_235_cov_1.096774_g26959_i0	PRJNA312615	27110	235	1.096774	2.5774189	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	1.02e-5	NR	MEI6236014.1	2026780	g26959	i0	44.3	4.90212765957447	61	31	77.9	1	207	25	1170	1227	MEI6236014.1 hypothetical protein [Planctomycetota bacterium]	diamond	1152	53.1	0.994350282485876	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29807409	29807409	PRJNA312615_P_NODE_36631_length_203_cov_1.292208_g36480_i0	PRJNA312615	36631	203	1.292208	2.62318224	Bacteria	2	Bacteria	Bacteria	58.5	5.96e-8	NR	MEI8382219.1	2026780	g36480	i0	51.5	1.95073891625616	66	31	97.5	1	199	2	626	690	MEI8382219.1 hypothetical protein [Planctomycetota bacterium]	diamond	396	58.9	0.99320882852292	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29997198	29997198	PRJNA312615_P_NODE_36491_length_203_cov_1.896104_g36340_i0	PRJNA312615	36491	203	1.896104	3.84909112	Schlesneria	656899	Bacteria	Bacteria	44.7	0.00473	NR	WP_010585981.1	360056	g36340	i0	61.3	5.58620689655172	31	12	45.8	0	96	4	1871	1901	WP_010585981.1 hypothetical protein [Schlesneria paludicola]	diamond	1134	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria paludicola
30628721	30628721	PRJNA312615_P_NODE_34853_length_208_cov_0.962264_g34702_i0	PRJNA312615	34853	208	0.962264	2.00150912	Bacteria	2	Bacteria	Bacteria	103	1.89e-25	NR	WP_309386537.1	490090	g34702	i0	71.6	5.79807692307692	67	19	96.6	0	4	204	39	105	WP_309386537.1 NAD(P)-dependent oxidoreductase [Cerasicoccus frondis]	diamond	1206	104	0.990384615384615	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus frondis
30660543	30660543	PRJNA312615_P_NODE_23713_length_251_cov_1.000000_g23562_i0	PRJNA312615	23713	251	1	2.51	PVC group	1783257	Bacteria	Bacteria	47.8	7.29e-4	NR	MDI1251189.1	1961806	g23562	i0	42	2.97609561752988	50	29	59.8	0	32	181	2211	2260	MDI1251189.1 immunoglobulin domain-containing protein [Lacunisphaera sp.]	diamond	747	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
30755386	30755386	PRJNA312615_P_NODE_25894_length_240_cov_2.005236_g25743_i0	PRJNA312615	25894	240	2.005236	4.8125664	Bacteria	2	Bacteria	Bacteria	43.1	0.0251	NR	PKL48441.1	2013827	g25743	i0	58.1	1.1875	31	13	38.8	0	233	141	365	395	PKL48441.1 MAG: 8-amino-7-oxononanoate synthase [Planctomycetes bacterium HGW-Planctomycetes-1]	diamond	285	43.5	0.990804597701149	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium HGW-Planctomycetes-1
31401685	31401685	PRJNA312615_P_NODE_57976_length_162_cov_0.902655_g57825_i0	PRJNA312615	57976	162	0.902655	1.4623011	Chlamydiota bacterium	2081524	Bacteria	Bacteria	82.4	8.95e-17	NR	NGX54462.1	2081524	g57825	i0	73.6	1.96296296296296	53	14	98.1	0	161	3	125	177	NGX54462.1 hypothetical protein [Chlamydiota bacterium]	diamond	318	82.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31780886	31780886	PRJNA312615_P_NODE_46917_length_176_cov_2.700787_g46766_i0	PRJNA312615	46917	176	2.700787	4.75338512	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0389	NR	MCC6427943.1	2052180	g46766	i0	47.5	0.681818181818182	40	20	68.2	1	23	142	125	163	MCC6427943.1 PepSY domain-containing protein [Phycisphaerales bacterium]	diamond	120	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32224076	32224076	PRJNA312615_P_NODE_29158_length_226_cov_3.372881_g29007_i0	PRJNA312615	29158	226	3.372881	7.62271106	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	122	1.64e-31	NR	RYD65414.1	2026800	g29007	i0	82.4	0.982300884955752	74	13	98.2	0	2	223	76	149	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	222	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32350734	32350734	PRJNA312615_P_NODE_22719_length_256_cov_0.961353_g22568_i0	PRJNA312615	22719	256	0.961353	2.46106368	Pirellulales bacterium	2715253	Bacteria	Bacteria	126	2.43e-32	NR	HJT32260.1	2715253	g22568	i0	66.7	2.953125	84	28	98.4	0	2	253	124	207	HJT32260.1 fumarylacetoacetase [Pirellulales bacterium]	diamond	756	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32413917	32413917	PRJNA312615_P_NODE_25499_length_242_cov_1.559585_g25348_i0	PRJNA312615	25499	242	1.559585	3.7741957	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	55.5	1.23e-6	NR	MEY4916642.1	2026799	g25348	i0	43.4	3.75619834710744	76	39	93	3	17	241	692	764	MEY4916642.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	909	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32572228	32572228	PRJNA312615_P_NODE_48499_length_172_cov_1.658537_g48348_i0	PRJNA312615	48499	172	1.658537	2.85268364	Verrucomicrobia bacterium TMED6	1986793	Bacteria	Bacteria	51.2	1.19e-5	NR	OUU56877.1	1986793	g48348	i0	46.9	0.854651162790698	49	26	85.5	0	24	170	187	235	OUU56877.1 MAG: hypothetical protein CBC20_07620 [Verrucomicrobia bacterium TMED60]	diamond	147	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium TMED60
32683837	32683837	PRJNA312615_P_NODE_38200_length_198_cov_5.395973_g38049_i0	PRJNA312615	38200	198	5.395973	10.68402654	Bacteria	2	Bacteria	Bacteria	74.3	3.28e-14	NR	MEO1372129.1	2026780	g38049	i0	71.2	6.34848484848485	52	15	78.8	0	42	197	6	57	MEO1372129.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	1257	74.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32792180	32792180	PRJNA312615_P_NODE_34060_length_210_cov_1.267081_g33909_i0	PRJNA312615	34060	210	1.267081	2.6608701	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	51.2	1.4e-6	NR	RYD20671.1	2026800	g33909	i0	85.2	0.385714285714286	27	4	38.6	0	81	1	2	28	RYD20671.1 MAG: hypothetical protein EOP88_14130 [Verrucomicrobiaceae bacterium]	diamond	81	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;