metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA897077" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA897077" 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
2148935	2148935	PRJNA897077_P_NODE_19002_length_244_cov_0.912281_g18875_i0	PRJNA897077	19002	244	0.912281	2.22596564	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	122	4.47e-32	NR	MCX6922257.1	2026799	g18875	i0	81.5	1.99180327868852	81	15	99.6	0	1	243	11	91	MCX6922257.1 type II secretion system protein [Verrucomicrobiota bacterium]	diamond	486	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
5976867	5976867	PRJNA897077_P_NODE_13305_length_272_cov_1.407035_g13178_i0	PRJNA897077	13305	272	1.407035	3.8271352	Bacteria	2	Bacteria	Bacteria	145	6.99e-40	NR	HWL94848.1	2026778	g13178	i0	78.7	3.94852941176471	89	19	98.2	0	268	2	218	306	HWL94848.1 glycosyltransferase [Phycisphaerae bacterium]	diamond	1074	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
23825771	23825771	PRJNA897077_P_NODE_17479_length_248_cov_0.891429_g17352_i0	PRJNA897077	17479	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	162	2.35e-45	NR	MCX6923052.1	2026799	g17352	i0	92.7	10.9112903225806	82	6	99.2	0	246	1	181	262	MCX6923052.1 ammonium transporter [Verrucomicrobiota bacterium]	diamond	2706	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
24195674	24195674	PRJNA897077_P_NODE_18159_length_246_cov_0.901734_g18032_i0	PRJNA897077	18159	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	139	4.48e-39	NR	RMF83565.1	2026780	g18032	i0	78	1	82	18	100	0	1	246	57	138	RMF83565.1 MAG: endonuclease V [Planctomycetota bacterium]	diamond	246	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27308784	27308784	PRJNA897077_P_NODE_16423_length_250_cov_0.881356_g16296_i0	PRJNA897077	16423	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99.8	5.18e-24	NR	TDJ58178.1	2026780	g16296	i0	55.7	2.868	79	26	94.8	1	3	239	23	92	TDJ58178.1 MAG: DUF1080 domain-containing protein [Planctomycetota bacterium]	diamond	717	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27529644	27529644	PRJNA897077_P_NODE_11903_length_287_cov_1.369159_g11776_i0	PRJNA897077	11903	287	1.369159	3.92948633	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	84	3.69e-18	NR	MDX1927699.1	2699754	g11776	i0	55.9	1.46341463414634	68	30	71.1	0	5	208	74	141	MDX1927699.1 chemotaxis protein CheW [Pirellulaceae bacterium]	diamond	420	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27656141	27656141	PRJNA897077_P_NODE_17884_length_247_cov_0.896552_g17757_i0	PRJNA897077	17884	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	92	1.74e-19	NR	MEO0478245.1	2026780	g17757	i0	55.1	2.93927125506073	78	35	94.7	0	235	2	184	261	MEO0478245.1 translational GTPase TypA [Planctomycetota bacterium]	diamond	726	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28318981	28318981	PRJNA897077_P_NODE_10226_length_308_cov_2.953191_g10099_i0	PRJNA897077	10226	308	2.953191	9.09582828	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0465	NR	MEC7923392.1	2026780	g10099	i0	39.7	0.564935064935065	58	27	51.6	2	108	266	60	114	MEC7923392.1 type II secretion system protein GspG [Planctomycetota bacterium]	diamond	174	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28540300	28540300	PRJNA897077_P_NODE_15907_length_251_cov_2.561798_g15780_i0	PRJNA897077	15907	251	2.561798	6.43011298	Opitutaceae bacterium	2006848	Bacteria	Bacteria	44.3	0.0118	NR	HRE83688.1	2006848	g15780	i0	42	0.597609561752988	50	28	58.6	1	156	10	401	450	HRE83688.1 prolyl oligopeptidase family serine peptidase [Opitutaceae bacterium]	diamond	150	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28887248	28887248	PRJNA897077_P_NODE_17888_length_247_cov_0.896552_g17761_i0	PRJNA897077	17888	247	0.896552	2.21448344	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	105	7.52e-26	NR	HEX4630426.1	2201154	g17761	i0	68.7	0.813765182186235	67	21	81.4	0	209	9	13	79	HEX4630426.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	201	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29013984	29013984	PRJNA897077_P_NODE_15648_length_252_cov_0.871508_g15521_i0	PRJNA897077	15648	252	0.871508	2.19620016	Horticoccus sp. 23ND18S-11	3391832	Bacteria	Bacteria	155	8.71e-47	NR	WP_414662688.1	3391832	g15521	i0	98.8	1	84	1	100	0	252	1	30	113	WP_414662688.1 50S ribosomal protein L18 [Horticoccus sp. 23ND18S-11]	diamond	252	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus sp. 23ND18S-11
29076968	29076968	PRJNA897077_P_NODE_16428_length_250_cov_0.881356_g16301_i0	PRJNA897077	16428	250	0.881356	2.20339	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	89.4	4.47e-19	NR	MCI0533773.1	2026801	g16301	i0	46.8	0.924	77	41	92.4	0	3	233	203	279	MCI0533773.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	231	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29392661	29392661	PRJNA897077_P_NODE_16689_length_250_cov_0.881356_g16562_i0	PRJNA897077	16689	250	0.881356	2.20339	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.5	0.0221	NR	GJQ30050.1	2026778	g16562	i0	43.2	0.444	37	21	44.4	0	7	117	246	282	GJQ30050.1 MAG: hypothetical protein HBSAPP03_19340 [Phycisphaerae bacterium]	diamond	111	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29779082	29779082	PRJNA897077_P_NODE_8251_length_341_cov_1.190299_g8124_i0	PRJNA897077	8251	341	1.190299	4.05891959	Bacteria	2	Bacteria	Bacteria	45.1	0.0174	NR	PHX78409.1	2026779	g8124	i0	60	0.879765395894428	25	10	22	0	122	196	547	571	PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium]	diamond	300	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30024325	30024325	PRJNA897077_P_NODE_17711_length_247_cov_0.896552_g17584_i0	PRJNA897077	17711	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	157	4.809999999999999e-46	NR	MBI5775361.1	2026799	g17584	i0	85.4	0.995951417004049	82	12	99.6	0	246	1	103	184	MBI5775361.1 ThuA domain-containing protein [Verrucomicrobiota bacterium]	diamond	246	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30348296	30348296	PRJNA897077_P_NODE_18212_length_246_cov_0.901734_g18085_i0	PRJNA897077	18212	246	0.901734	2.21826564	Prosthecobacter	48463	Bacteria	Bacteria	49.3	1.98e-4	NR	MDZ4290247.1	1965333	g18085	i0	36	2.03658536585366	86	47	96.3	3	240	4	1065	1149	MDZ4290247.1 choice-of-anchor D domain-containing protein [Prosthecobacter sp.]	diamond	501	49.7	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30348298	30348298	PRJNA897077_P_NODE_19532_length_243_cov_0.917647_g19405_i0	PRJNA897077	19532	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	132	1.12e-34	NR	OQB86345.1	1852903	g19405	i0	73.4	5.90123456790123	79	21	97.5	0	241	5	243	321	OQB86345.1 MAG: Zinc carboxypeptidase [Planctomycetes bacterium ADurb.Bin126]	diamond	1434	133	0.992481203007519	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium ADurb.Bin126
30592756	30592756	PRJNA897077_P_NODE_18613_length_245_cov_0.906977_g18486_i0	PRJNA897077	18613	245	0.906977	2.22209365	Planctomycetota bacterium	2026780	Bacteria	Bacteria	155	1.18e-44	NR	MBC8470514.1	2026780	g18486	i0	90.1	0.991836734693878	81	8	99.2	0	1	243	182	262	MBC8470514.1 ThuA domain-containing protein [Planctomycetota bacterium]	diamond	243	155	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31066983	31066983	PRJNA897077_P_NODE_19955_length_242_cov_0.923077_g19828_i0	PRJNA897077	19955	242	0.923077	2.23384634	Pelagicoccus enzymogenes	2773457	Bacteria	Bacteria	158	3.0799999999999993e-43	NR	WP_191616268.1	2773457	g19828	i0	90	1.98347107438017	80	8	99.2	0	242	3	354	433	WP_191616268.1 hypothetical protein [Pelagicoccus enzymogenes]	diamond	480	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus enzymogenes
32174015	32174015	PRJNA897077_P_NODE_15878_length_252_cov_0.871508_g15751_i0	PRJNA897077	15878	252	0.871508	2.19620016	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	146	1.2999999999999998e-38	NR	HEV3208890.1	2201154	g15751	i0	83.3	3.01190476190476	84	14	100	0	252	1	8	91	HEV3208890.1 protein kinase [Chthoniobacterales bacterium]	diamond	759	146	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32174017	32174017	PRJNA897077_P_NODE_18298_length_246_cov_0.901734_g18171_i0	PRJNA897077	18298	246	0.901734	2.21826564	Gemmataceae bacterium	2052164	Bacteria	Bacteria	131	5.47e-36	NR	HEV3446128.1	2052164	g18171	i0	78.5	0.963414634146341	79	17	96.3	0	245	9	1	79	HEV3446128.1 hypothetical protein [Gemmataceae bacterium]	diamond	237	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32245058	32245058	PRJNA897077_P_NODE_18338_length_246_cov_0.901734_g18211_i0	PRJNA897077	18338	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	75.1	1.47e-13	NR	MBK8270120.1	2026780	g18211	i0	46.7	1.71951219512195	75	39	90.2	1	226	5	335	409	MBK8270120.1 hypothetical protein [Planctomycetota bacterium]	diamond	423	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32332330	32332330	PRJNA897077_P_NODE_17239_length_248_cov_0.891429_g17112_i0	PRJNA897077	17239	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0208	NR	HVS09816.1	2026780	g17112	i0	40	0.967741935483871	80	36	90.7	3	2	226	167	239	HVS09816.1 hypothetical protein [Planctomycetota bacterium]	diamond	240	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32490388	32490388	PRJNA897077_P_NODE_19579_length_243_cov_0.917647_g19452_i0	PRJNA897077	19579	243	0.917647	2.22988221	Opitutaceae bacterium	2006848	Bacteria	Bacteria	44.7	0.00741	NR	HYC72374.1	2006848	g19452	i0	42.9	0.777777777777778	63	33	76.5	2	42	227	62	122	HYC72374.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol N-acetylglucosamine transferase [Opitutaceae bacterium]	diamond	189	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32899759	32899759	PRJNA897077_P_NODE_18900_length_244_cov_0.912281_g18773_i0	PRJNA897077	18900	244	0.912281	2.22596564	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	151	2.58e-44	NR	MCL4202956.1	2699754	g18773	i0	88.8	0.983606557377049	80	9	98.4	0	242	3	90	169	MCL4202956.1 molecular chaperone TorD family protein [Pirellulaceae bacterium]	diamond	240	151	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);;