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

25 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
15486463	15486463	PRJNA1068830_P_NODE_82653_length_246_cov_0.901734_g81950_i0	PRJNA1068830	82653	246	0.901734	2.21826564	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	82	5.33e-18	NR	OCA02583.1	1679444	g81950	i0	95.3	1.04878048780488	43	2	52.4	0	246	118	71	113	OCA02583.1 transposase [Akkermansia glycaniphila]	diamond	258	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
27098914	27098914	PRJNA1068830_P_NODE_78602_length_249_cov_0.886364_g77899_i0	PRJNA1068830	78602	249	0.886364	2.20704636	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57.4	2.62e-7	NR	MBV9009557.1	2026799	g77899	i0	53.7	2.12048192771084	54	24	65.1	1	2	163	82	134	MBV9009557.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	528	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27193650	27193650	PRJNA1068830_P_NODE_74542_length_252_cov_0.871508_g73839_i0	PRJNA1068830	74542	252	0.871508	2.19620016	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	58.9	6.36e-8	NR	HEX5103081.1	2699754	g73839	i0	46.7	0.714285714285714	60	32	71.4	0	26	205	5	64	HEX5103081.1 serine/threonine-protein kinase [Pirellulaceae bacterium]	diamond	180	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27225190	27225190	PRJNA1068830_P_NODE_61603_length_277_cov_1.343137_g60900_i0	PRJNA1068830	61603	277	1.343137	3.72048949	Planctomycetia bacterium	2052181	Bacteria	Bacteria	47	0.00166	NR	MBI3861953.1	2052181	g60900	i0	77.8	0.292418772563177	27	6	29.2	0	3	83	143	169	MBI3861953.1 hypothetical protein [Planctomycetia bacterium]	diamond	81	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27541384	27541384	PRJNA1068830_P_NODE_70124_length_257_cov_1.695652_g69421_i0	PRJNA1068830	70124	257	1.695652	4.35782564	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.7	0.045	NR	HEY1764242.1	2006848	g69421	i0	33.8	0.793774319066148	68	37	70	2	47	226	499	566	HEY1764242.1 right-handed parallel beta-helix repeat-containing protein [Opitutaceae bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27793998	27793998	PRJNA1068830_P_NODE_15404_length_623_cov_3.160000_g14725_i0	PRJNA1068830	15404	623	3.16	19.6868	Crateriforma spongiae	2724528	Bacteria	Bacteria	161	6.86e-44	NR	WP_168565541.1	2724528	g14725	i0	51.2	2.51364365971108	168	79	79.5	1	9	503	207	374	WP_168565541.1 galactokinase [Crateriforma spongiae]	diamond	1566	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma	Crateriforma spongiae
27794031	27794031	PRJNA1068830_P_NODE_84084_length_245_cov_0.906977_g83381_i0	PRJNA1068830	84084	245	0.906977	2.22209365	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	133	1.41e-35	NR	MDD5421816.1	2035772	g83381	i0	77.8	1.9469387755102	81	18	99.2	0	2	244	211	291	MDD5421816.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Omnitrophota bacterium]	diamond	477	133	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27943429	27943429	PRJNA1068830_P_NODE_87865_length_242_cov_1.443787_g87162_i0	PRJNA1068830	87865	242	1.443787	3.49396454	Bacteria	2	Bacteria	Bacteria	91.3	1.25e-19	NR	HBH51526.1	2026779	g87162	i0	54.4	4.94628099173554	79	36	97.9	0	4	240	72	150	HBH51526.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1197	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28101057	28101057	PRJNA1068830_P_NODE_83745_length_245_cov_0.906977_g83042_i0	PRJNA1068830	83745	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	53.5	3.19e-6	NR	MCX6961305.1	2026799	g83042	i0	42.7	6.24489795918367	75	39	86.9	2	7	219	104	178	MCX6961305.1 YbjN domain-containing protein [Verrucomicrobiota bacterium]	diamond	1530	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28551817	28551817	PRJNA1068830_P_NODE_58887_length_283_cov_3.938095_g58184_i0	PRJNA1068830	58887	283	3.938095	11.14480885	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	104	6.88e-27	NR	MFO7821374.1	2053569	g58184	i0	65.8	1.72791519434629	79	27	83.7	0	247	11	4	82	MFO7821374.1 RNA-binding protein [Lentisphaeria bacterium]	diamond	489	104	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28606322	28606322	PRJNA1068830_P_NODE_86647_length_243_cov_0.917647_g85944_i0	PRJNA1068830	86647	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	140	5.54e-38	NR	MBI4658269.1	2026799	g85944	i0	77.8	9	81	18	100	0	1	243	288	368	MBI4658269.1 terpene cyclase/mutase family protein [Verrucomicrobiota bacterium]	diamond	2187	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28804005	28804005	PRJNA1068830_P_NODE_83028_length_245_cov_3.627907_g82325_i0	PRJNA1068830	83028	245	3.627907	8.88837215	Verrucomicrobiia bacterium Tous-C3TDCM	1982330	Bacteria	Bacteria	44.3	0.0107	NR	PAW61727.1	1982330	g82325	i0	34.7	0.918367346938776	75	49	91.8	0	2	226	324	398	PAW61727.1 MAG: RIP metalloprotease RseP [Verrucomicrobiia bacterium Tous-C3TDCM]	diamond	225	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium Tous-C3TDCM
30383711	30383711	PRJNA1068830_P_NODE_84253_length_245_cov_0.906977_g83550_i0	PRJNA1068830	84253	245	0.906977	2.22209365	Planctomycetia bacterium	2052181	Bacteria	Bacteria	137	2.55e-36	NR	MDZ4782843.1	2052181	g83550	i0	77.8	0.991836734693878	81	18	99.2	0	245	3	139	219	MDZ4782843.1 MlaD family protein [Planctomycetia bacterium]	diamond	243	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30532793	30532793	PRJNA1068830_P_NODE_72993_length_253_cov_0.866667_g72290_i0	PRJNA1068830	72993	253	0.866667	2.19266751	Planctomycetia	203683	Bacteria	Bacteria	51.2	4.28e-5	NR	MFM7041767.1	2026779	g72290	i0	37	7.70750988142292	81	46	96	2	246	4	235	310	MFM7041767.1 M66 family metalloprotease [Planctomycetaceae bacterium]	diamond	1950	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30857180	30857180	PRJNA1068830_P_NODE_86574_length_243_cov_0.917647_g85871_i0	PRJNA1068830	86574	243	0.917647	2.22988221	Planctomycetia bacterium	2052181	Bacteria	Bacteria	108	1.54e-25	NR	MDZ4779337.1	2052181	g85871	i0	64.2	1	81	29	100	0	1	243	440	520	MDZ4779337.1 lipopolysaccharide kinase InaA family protein [Planctomycetia bacterium]	diamond	243	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31047097	31047097	PRJNA1068830_P_NODE_61155_length_278_cov_1.521951_g60452_i0	PRJNA1068830	61155	278	1.521951	4.23102378	Pirellulales bacterium	2715253	Bacteria	Bacteria	102	3.649999999999999e-23	NR	MDA7937840.1	2715253	g60452	i0	58.9	0.971223021582734	90	37	97.1	0	7	276	64	153	MDA7937840.1 threonine ammonia-lyase [Pirellulales bacterium]	diamond	270	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31489664	31489664	PRJNA1068830_P_NODE_24696_length_471_cov_1.070352_g23995_i0	PRJNA1068830	24696	471	1.070352	5.04135792	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	163	1.34e-47	NR	MAD23566.1	2026801	g23995	i0	59	0.853503184713376	134	50	82.2	1	402	16	1	134	MAD23566.1 thymidylate synthase (FAD) [Verrucomicrobiales bacterium]	diamond	402	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31670722	31670722	PRJNA1068830_P_NODE_57137_length_288_cov_1.381395_g56434_i0	PRJNA1068830	57137	288	1.381395	3.9784176	Bacteria	2	Bacteria	Bacteria	54.7	4.04e-6	NR	MEY3460111.1	2026780	g56434	i0	52.8	1.75	53	25	55.2	0	273	115	509	561	MEY3460111.1 hypothetical protein [Planctomycetota bacterium]	diamond	504	55.1	0.992740471869329	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31837185	31837185	PRJNA1068830_P_NODE_76417_length_250_cov_1.305085_g75714_i0	PRJNA1068830	76417	250	1.305085	3.2627125	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52.4	1.08e-5	NR	HXT85908.1	2499141	g75714	i0	37.1	0.744	62	38	74.4	1	3	188	167	227	HXT85908.1 lipid-binding SYLF domain-containing protein [Verrucomicrobiia bacterium]	diamond	186	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31932132	31932132	PRJNA1068830_P_NODE_25357_length_463_cov_1.748718_g24655_i0	PRJNA1068830	25357	463	1.748718	8.09656434	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	277	3.3499999999999998e-90	NR	WP_206863961.1	2796139	g24655	i0	90.9	1.97624190064795	154	14	99.8	0	462	1	194	347	WP_206863961.1 IS256 family transposase [Methylacidimicrobium sp. B4]	diamond	915	277	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
32090477	32090477	PRJNA1068830_P_NODE_55918_length_291_cov_1.431193_g55215_i0	PRJNA1068830	55918	291	1.431193	4.16477163	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	196	6.32e-60	NR	MFA7054871.1	2212473	g55215	i0	94.8	0.989690721649485	96	5	99	0	3	290	97	192	MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium]	diamond	288	196	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32090483	32090483	PRJNA1068830_P_NODE_65018_length_269_cov_1.326531_g64315_i0	PRJNA1068830	65018	269	1.326531	3.56836839	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	81.3	9.86e-16	NR	NNE90836.1	2026801	g64315	i0	47.7	1.97397769516729	88	43	98.1	2	264	1	64	148	NNE90836.1 2-aminoethylphosphonate--pyruvate transaminase [Verrucomicrobiales bacterium]	diamond	531	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32153812	32153812	PRJNA1068830_P_NODE_72498_length_253_cov_0.866667_g71795_i0	PRJNA1068830	72498	253	0.866667	2.19266751	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	141	5.679999999999999e-37	NR	MBL8014117.1	2035772	g71795	i0	81.7	1.94466403162055	82	15	97.2	0	3	248	341	422	MBL8014117.1 ATP-dependent DNA helicase RecG [Candidatus Omnitrophota bacterium]	diamond	492	141	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32659298	32659298	PRJNA1068830_P_NODE_85280_length_244_cov_0.912281_g84577_i0	PRJNA1068830	85280	244	0.912281	2.22596564	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	42.7	0.0384	NR	MCI0362211.1	2026779	g84577	i0	39.6	0.590163934426229	48	26	59	1	151	8	366	410	MCI0362211.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	144	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32690880	32690880	PRJNA1068830_P_NODE_72580_length_253_cov_0.866667_g71877_i0	PRJNA1068830	72580	253	0.866667	2.19266751	Planctomycetales bacterium	2053591	Bacteria	Bacteria	43.9	0.014	NR	MBI5757453.1	2053591	g71877	i0	43	0.936758893280632	79	34	93.7	3	15	251	100	167	MBI5757453.1 hypothetical protein [Planctomycetales bacterium]	diamond	237	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales 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);;