metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Peregrinibacteriota"

25 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Peregrinibacteriota"

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_phylum	tax_class	tax_order	tax_genus	tax_species
525300	525300	PRJNA556992_P_NODE_1_length_153848_cov_118.931419_g0_i0	PRJNA556992	1	153848	118.931419	182973.60950312	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	1026	0	NR	MCK5020030.1	2735830	g0	i0	39.4	0.0317456190525714	1628	911	3.1	31	51638	56350	2	1610	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	4884	1026	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
1802558	1802558	PRJNA556992_P_NODE_2_length_116150_cov_119.825866_g0_i1	PRJNA556992	2	116150	119.825866	139177.743359	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	1026	0	NR	MCK5020030.1	2735830	g0	i1	39.4	0.0420490744726647	1628	911	4.1	31	64513	59801	2	1610	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	4884	1026	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
3079170	3079170	PRJNA556992_P_NODE_3_length_114416_cov_125.195963_g0_i2	PRJNA556992	3	114416	125.195963	143244.21302608	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	1026	0	NR	MCK5020030.1	2735830	g0	i2	39.4	0.0426863375751643	1628	911	4.1	31	49481	54193	2	1610	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	4884	1026	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
10729013	10729013	PRJNA556992_P_NODE_16689_length_824_cov_5.163782_g14877_i0	PRJNA556992	16689	824	5.163782	42.54956368	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	302	2.36e-97	NR	MCK5020147.1	2735830	g14877	i0	63.2	1.65655339805825	228	82	83	1	823	140	209	434	MCK5020147.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	1365	302	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
27236633	27236633	PRJNA556992_P_NODE_679343_length_252_cov_4.033520_g677154_i0	PRJNA556992	679343	252	4.03352	10.1644704	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	110	3.15e-26	NR	MCK5020147.1	2735830	g677154	i0	64.7	1.01190476190476	85	28	100	2	1	252	18	101	MCK5020147.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	255	110	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
27300044	27300044	PRJNA556992_P_NODE_8843_length_1109_cov_3.122587_g7518_i0	PRJNA556992	8843	1109	3.122587	34.62948983	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	277	1.5e-79	NR	MCK5020030.1	2735830	g7518	i0	42.3	2.01532912533814	376	206	99.3	7	7	1107	430	803	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	2235	277	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
27363093	27363093	PRJNA556992_P_NODE_1144023_length_203_cov_4.092308_g1141832_i0	PRJNA556992	1144023	203	4.092308	8.30738524	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	66.2	7.12e-12	NR	MCB9804246.1	2053688	g1141832	i0	58.7	0.931034482758621	63	23	93.1	1	12	200	15	74	MCB9804246.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	189	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
27520745	27520745	PRJNA556992_P_NODE_202083_length_326_cov_1.822134_g199895_i0	PRJNA556992	202083	326	1.822134	5.94015684	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	71.6	7.4e-12	NR	MCK5020030.1	2735830	g199895	i0	42.7	1.76687116564417	96	49	82.8	2	272	3	1506	1601	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	576	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
28009021	28009021	PRJNA556992_P_NODE_439065_length_273_cov_1.200000_g436876_i0	PRJNA556992	439065	273	1.2	3.276	Bacteria	2	Bacteria	Bacteria	42.7	0.0475	NR	MCA9377718.1	2030811	g436876	i0	34.5	2.81318681318681	84	47	90.1	3	2	247	55	132	MCA9377718.1 hypothetical protein [Candidatus Peregrinibacteria bacterium]	diamond	768	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
28878482	28878482	PRJNA556992_P_NODE_506628_length_266_cov_5.160622_g504439_i0	PRJNA556992	506628	266	5.160622	13.72725452	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	77	7.13e-15	NR	MBI5413290.1	2030811	g504439	i0	51.3	2.36842105263158	76	35	83.5	1	234	13	4	79	MBI5413290.1 aquaporin [Candidatus Peregrinibacteria bacterium]	diamond	630	77	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
28892789	28892789	PRJNA556992_P_NODE_817588_length_245_cov_1.401163_g815398_i0	PRJNA556992	817588	245	1.401163	3.43284935	Bacteria	2	Bacteria	Bacteria	47.4	8.87e-4	NR	ALM09455.1	1735162	g815398	i0	31.8	4.29795918367347	88	51	96.7	1	6	242	238	325	ALM09455.1 MAG: hypothetical protein PeribacterA2_0058 [Candidatus Peribacter riflensis]	diamond	1053	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacter	Candidatus Peribacter riflensis
29240239	29240239	PRJNA556992_P_NODE_188769_length_333_cov_3.526923_g186581_i0	PRJNA556992	188769	333	3.526923	11.74465359	root	1	Root_unresolved	Root_unresolved	113	4.62e-27	NR	MCK5020112.1	2735830	g186581	i0	53.2	1.96396396396396	109	51	98.2	0	331	5	161	269	MCK5020112.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	654	113	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
29320783	29320783	PRJNA556992_P_NODE_916749_length_239_cov_2.843373_g914559_i0	PRJNA556992	916749	239	2.843373	6.79566147	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	59.3	3.43e-8	NR	MBT7929336.1	2030811	g914559	i0	36.8	0.853556485355649	68	43	85.4	0	14	217	66	133	MBT7929336.1 glycosyltransferase family 2 protein [Candidatus Peregrinibacteria bacterium]	diamond	204	59.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
29398136	29398136	PRJNA556992_P_NODE_802069_length_246_cov_0.890173_g799879_i0	PRJNA556992	802069	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	142	4.02e-39	NR	MDO8649060.1	2030811	g799879	i0	84.1	19	82	13	100	0	1	246	171	252	MDO8649060.1 formate--phosphoribosylaminoimidazolecarboxamide ligase [Candidatus Peregrinibacteria bacterium]	diamond	4674	142	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
29635836	29635836	PRJNA556992_P_NODE_126590_length_377_cov_2.799342_g124403_i0	PRJNA556992	126590	377	2.799342	10.55351934	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	130	1.5099999999999999e-32	NR	MCK5020017.1	2735830	g124403	i0	51.2	0.994694960212202	125	60	99.5	1	375	1	27	150	MCK5020017.1 AAA family ATPase [Candidatus Peribacteraceae bacterium]	diamond	375	130	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
29635866	29635866	PRJNA556992_P_NODE_178510_length_339_cov_3.387218_g176322_i0	PRJNA556992	178510	339	3.387218	11.48266902	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	114	6.350000000000001e-27	NR	MCK5020088.1	2735830	g176322	i0	40.5	0.982300884955752	111	66	98.2	0	3	335	37	147	MCK5020088.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	333	114	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
30520649	30520649	PRJNA556992_P_NODE_1135613_length_204_cov_10.679389_g1133422_i0	PRJNA556992	1135613	204	10.679389	21.78595356	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	61.2	4.47e-9	NR	MCA9377718.1	2030811	g1133422	i0	50.8	0.926470588235294	63	26	92.6	1	193	5	187	244	MCA9377718.1 hypothetical protein [Candidatus Peregrinibacteria bacterium]	diamond	189	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
30646877	30646877	PRJNA556992_P_NODE_23813_length_698_cov_3.465600_g21806_i0	PRJNA556992	23813	698	3.4656	24.189888	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	57.4	3.04e-6	NR	MCK5020162.1	2735830	g21806	i0	39.3	0.459885386819484	107	54	44.3	4	364	672	7	106	MCK5020162.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	321	57.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
30678899	30678899	PRJNA556992_P_NODE_892453_length_241_cov_1.779762_g890263_i0	PRJNA556992	892453	241	1.779762	4.28922642	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	52.8	1.03e-5	NR	MDD5469506.1	2735830	g890263	i0	53.1	4.03319502074689	49	20	61	2	227	81	429	474	MDD5469506.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	972	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
30900060	30900060	PRJNA556992_P_NODE_28234_length_647_cov_1.839721_g26157_i0	PRJNA556992	28234	647	1.839721	11.90299487	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	96.3	4.98e-19	NR	MCK5020017.1	2735830	g26157	i0	52.7	0.421947449768161	91	43	42.2	0	1	273	480	570	MCK5020017.1 AAA family ATPase [Candidatus Peribacteraceae bacterium]	diamond	273	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
31198301	31198301	PRJNA556992_P_NODE_578555_length_260_cov_4.588235_g576366_i0	PRJNA556992	578555	260	4.588235	11.929411	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00954	NR	PIZ75326.1	1974774	g576366	i0	47.9	2.48076923076923	48	24	54.2	1	87	227	117	164	PIZ75326.1 MAG: hypothetical protein COY05_04295 [Candidatus Peregrinibacteria bacterium CG_4_10_14_0_2_um_filter_38_24]	diamond	645	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium CG_4_10_14_0_2_um_filter_38_24
31247486	31247486	PRJNA556992_P_NODE_30335_length_627_cov_4.046931_g28239_i0	PRJNA556992	30335	627	4.046931	25.37425737	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	182	3.72e-49	NR	MCK5020030.1	2735830	g28239	i0	46.6	0.995215311004785	208	109	98.6	2	622	5	229	436	MCK5020030.1 DUF4815 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	624	182	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
31658690	31658690	PRJNA556992_P_NODE_667797_length_253_cov_3.400000_g665608_i0	PRJNA556992	667797	253	3.4	8.602	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	60.5	1.25e-8	NR	MDR1945527.1	2053688	g665608	i0	34.5	1.99209486166008	84	55	99.6	0	1	252	153	236	MDR1945527.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	504	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
31785093	31785093	PRJNA556992_P_NODE_376797_length_279_cov_1.674757_g374608_i0	PRJNA556992	376797	279	1.674757	4.67257203	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	76.6	6.62e-16	NR	MDR1945524.1	2053688	g374608	i0	67.2	1.38709677419355	64	21	68.8	0	6	197	32	95	MDR1945524.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	387	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
32638723	32638723	PRJNA556992_P_NODE_1121140_length_208_cov_4.266667_g1118949_i0	PRJNA556992	1121140	208	4.266667	8.87466736	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	47.4	4.37e-4	NR	MCX6734162.1	2030811	g1118949	i0	43.4	0.764423076923077	53	30	76.4	0	207	49	141	193	MCX6734162.1 MIP family channel protein [Candidatus Peregrinibacteria bacterium]	diamond	159	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria 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);;