metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

24 rows where analysis = "diamond", bioproject = "PRJNA169559" 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
11258030	11258030	PRJNA169559_P_NODE_1249_length_1467_cov_2.611961_g686_i0	PRJNA169559	1249	1467	2.611961	38.31746787	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	348	1.9e-109	NR	RYD77759.1	2026800	g686	i0	54.9	1.43967280163599	357	139	72.8	2	1464	397	170	505	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	2112	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
11843784	11843784	PRJNA169559_P_NODE_690_length_2008_cov_3.763517_g322_i0	PRJNA169559	690	2008	3.763517	75.57142136	root	1	Root_unresolved	Root_unresolved	785	3.05e-278	NR	WP_013182645.1	71667	g322	i0	62.2	10.9093625498008	611	221	91.1	6	1861	32	2	603	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	21906	790	0.993670886075949	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
13808196	13808196	PRJNA169559_P_NODE_17991_length_401_cov_4.258065_g15992_i0	PRJNA169559	17991	401	4.258065	17.07484065	Pseudomonadati	3379134	Bacteria	Bacteria	147	1.19e-41	NR	RMF40182.1	2026780	g15992	i0	69.1	16.3391521197007	110	33	81.5	1	74	400	94	203	RMF40182.1 MAG: NAD(P)H:quinone oxidoreductase [Planctomycetota bacterium]	diamond	6552	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27453346	27453346	PRJNA169559_P_NODE_22443_length_336_cov_2.817590_g20377_i0	PRJNA169559	22443	336	2.81759	9.4671024	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	89	5.94e-18	NR	NUM34221.1	2517210	g20377	i0	46.5	0.883928571428571	99	49	84.8	1	299	15	388	486	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	297	89	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
27471086	27471086	PRJNA169559_P_NODE_15963_length_423_cov_1.685279_g14000_i0	PRJNA169559	15963	423	1.685279	7.12873017	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	9.87e-20	NR	MBS0623645.1	2026799	g14000	i0	58.2	4.14893617021277	79	32	56	1	244	8	135	212	MBS0623645.1 tryptophan--tRNA ligase [Verrucomicrobiota bacterium]	diamond	1755	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27471089	27471089	PRJNA169559_P_NODE_3183_length_930_cov_3.138735_g2145_i0	PRJNA169559	3183	930	3.138735	29.1902355	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	1.78e-4	NR	WP_294231434.1	1965333	g2145	i0	32.3	1.52903225806452	155	87	49.7	4	139	600	2065	2202	WP_294231434.1 Calx-beta domain-containing protein [Prosthecobacter sp.]	diamond	1422	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27737631	27737631	PRJNA169559_P_NODE_48424_length_159_cov_2.176923_g46347_i0	PRJNA169559	48424	159	2.176923	3.4613075699999998	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	109	3.01e-26	NR	MFI0478845.1	2320511	g46347	i0	98	0.962264150943396	51	1	96.2	0	155	3	1100	1150	MFI0478845.1 hypothetical protein [Candidatus Rhabdochlamydia sp.]	diamond	153	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
27926764	27926764	PRJNA169559_P_NODE_3945_length_845_cov_2.620098_g2781_i0	PRJNA169559	3945	845	2.620098	22.1398281	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.9	2.86e-7	NR	MFO1485461.1	2026800	g2781	i0	40.5	0.447337278106509	126	65	44.7	2	406	29	2265	2380	MFO1485461.1 Calx-beta domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	378	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28463687	28463687	PRJNA169559_P_NODE_24266_length_311_cov_2.592199_g22190_i0	PRJNA169559	24266	311	2.592199	8.06173889	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	0.0015	NR	MCX6851244.1	2026799	g22190	i0	42.9	2.82636655948553	105	48	96.5	5	308	9	901	998	MCX6851244.1 PKD domain-containing protein [Verrucomicrobiota bacterium]	diamond	879	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28495245	28495245	PRJNA169559_P_NODE_25187_length_300_cov_1.926199_g23111_i0	PRJNA169559	25187	300	1.926199	5.778597	Planctomycetota bacterium	2026780	Bacteria	Bacteria	127	8.27e-32	NR	MCX5689910.1	2026780	g23111	i0	74.7	9.91	99	23	99	1	297	1	198	294	MCX5689910.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	2973	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28558388	28558388	PRJNA169559_P_NODE_46087_length_200_cov_1.356725_g44010_i0	PRJNA169559	46087	200	1.356725	2.71345	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	146	1.84e-42	NR	MFI0436095.1	2052176	g44010	i0	98.5	0.99	66	1	99	0	3	200	7	72	MFI0436095.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	198	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29505340	29505340	PRJNA169559_P_NODE_34710_length_248_cov_2.155251_g32633_i0	PRJNA169559	34710	248	2.155251	5.34502248	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	75.1	1.61e-13	NR	MCC7349131.1	2052180	g32633	i0	78	4.1491935483871	41	9	49.6	0	1	123	830	870	MCC7349131.1 pyruvate, phosphate dikinase [Phycisphaerales bacterium]	diamond	1029	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29537007	29537007	PRJNA169559_P_NODE_31890_length_257_cov_1.741228_g29814_i0	PRJNA169559	31890	257	1.741228	4.47495596	Planctomycetales bacterium	2053591	Bacteria	Bacteria	65.9	3.29e-10	NR	MCA9213857.1	2053591	g29814	i0	37	4.79766536964981	81	50	94.6	1	14	256	1966	2045	MCA9213857.1 hypothetical protein [Planctomycetales bacterium]	diamond	1233	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29694576	29694576	PRJNA169559_P_NODE_21450_length_351_cov_2.782609_g19387_i0	PRJNA169559	21450	351	2.782609	9.76695759	Planctomycetota bacterium	2026780	Bacteria	Bacteria	96.3	6.860000000000001e-21	NR	MEK7411798.1	2026780	g19387	i0	44.4	1	117	65	100	0	1	351	57	173	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	351	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30642482	30642482	PRJNA169559_P_NODE_26893_length_284_cov_1.729412_g24817_i0	PRJNA169559	26893	284	1.729412	4.91153008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00366	NR	MFH1417650.1	2026780	g24817	i0	38	0.528169014084507	50	31	52.8	0	5	154	424	473	MFH1417650.1 protein kinase [Planctomycetota bacterium]	diamond	150	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30705722	30705722	PRJNA169559_P_NODE_5454_length_727_cov_2.169054_g4075_i0	PRJNA169559	5454	727	2.169054	15.76902258	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	63.5	6.45e-8	NR	MDF1813063.1	2026801	g4075	i0	39.2	0.495185694635488	120	61	48.7	4	486	133	110	219	MDF1813063.1 carbonic anhydrase family protein [Verrucomicrobiales bacterium]	diamond	360	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31608739	31608739	PRJNA169559_P_NODE_9176_length_561_cov_2.469925_g7481_i0	PRJNA169559	9176	561	2.469925	13.85627925	Bacteria	2	Bacteria	Bacteria	115	4.17e-28	NR	MEY4190276.1	2026780	g7481	i0	47.1	3.45454545454545	121	62	64.2	2	65	424	103	222	MEY4190276.1 hypothetical protein [Planctomycetota bacterium]	diamond	1938	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31748931	31748931	PRJNA169559_P_NODE_45197_length_213_cov_1.923913_g43120_i0	PRJNA169559	45197	213	1.923913	4.09793469	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	63.9	8.32e-10	NR	MFI0436003.1	2052176	g43120	i0	40.3	1.01408450704225	72	41	98.6	1	211	2	454	525	MFI0436003.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	216	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32065378	32065378	PRJNA169559_P_NODE_298_length_5167_cov_5.449786_g98_i0	PRJNA169559	298	5167	5.449786	281.59044262	Gemmataceae bacterium	2052164	Bacteria	Bacteria	142	1.76e-29	NR	MFO0800230.1	2052164	g98	i0	26.7	0.541126378943294	932	546	50.5	44	2252	4858	8851	9708	MFO0800230.1 PKD domain-containing protein [Gemmataceae bacterium]	diamond	2796	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32160526	32160526	PRJNA169559_P_NODE_10278_length_528_cov_37.835671_g8515_i0	PRJNA169559	10278	528	37.835671	199.77234288	Chlamydiales bacterium	2047757	Bacteria	Bacteria	148	3.8e-42	NR	MCP5470421.1	2047757	g8515	i0	51.9	3.40340909090909	156	69	87.5	2	507	46	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1797	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32255656	32255656	PRJNA169559_P_NODE_11078_length_506_cov_2.742138_g9265_i0	PRJNA169559	11078	506	2.742138	13.87521828	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	142	2.67e-36	NR	HYG84357.1	2499141	g9265	i0	53	0.99604743083004	168	72	97.2	3	504	13	115	279	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	504	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32350397	32350397	PRJNA169559_P_NODE_4739_length_778_cov_2.746328_g3451_i0	PRJNA169559	4739	778	2.746328	21.36643184	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.9	2.01e-7	NR	MFO1485461.1	2026800	g3451	i0	40.5	0.48586118251928	126	65	48.6	2	373	750	2265	2380	MFO1485461.1 Calx-beta domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	378	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32634362	32634362	PRJNA169559_P_NODE_26900_length_284_cov_1.635294_g24824_i0	PRJNA169559	26900	284	1.635294	4.64423496	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	57.8	2.25e-7	NR	MFI0435901.1	2052176	g24824	i0	76.3	0.401408450704225	38	9	40.1	0	282	169	140	177	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	114	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32760557	32760557	PRJNA169559_P_NODE_2780_length_992_cov_4.067497_g1809_i0	PRJNA169559	2780	992	4.067497	40.34957024	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	65.9	9.83e-8	NR	NOT01860.1	2052180	g1809	i0	28.7	1.94153225806452	171	117	50.5	4	169	669	52	221	NOT01860.1 DUF4215 domain-containing protein [Phycisphaerales bacterium]	diamond	1926	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;