metadata: contig_metadata: 28 rows where bioproject = "PRJNA641707", tax_kingdom = "Bacillati" and tax

28 rows where bioproject = "PRJNA641707", tax_kingdom = "Bacillati" and tax_phylum = "Vulcanimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
617351	617351	PRJNA641707_P_NODE_8521_length_732_cov_23.224012_g6676_i0	PRJNA641707	8521	732	23.224012	169.99976784	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	965	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g6676	i0	90.797	254.704918032787	728	57	99	8	1	726	5033214	5032495	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	186444	965	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
1889285	1889285	PRJNA641707_P_NODE_200862_length_197_cov_6.851351_g198199_i0	PRJNA641707	200862	197	6.851351	13.49716147	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	73.1	1.31e-8	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g198199	i0	100	0.553299492385787	39	0	20	0	159	197	5029017	5029055	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	109	73.1	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
1890516	1890516	PRJNA641707_P_NODE_254182_length_180_cov_8.083969_g251519_i0	PRJNA641707	254182	180	8.083969	14.5511442	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	302	1.37e-77	NTclustered	gi\|2874253878\|emb\|OY969933.1\|	3107663	g251519	i0	98.266	314.327777777778	173	2	96	1	8	180	440247	440076	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD05502.bin.c.2 genome assembly, chromosome: 1	blastn	56579	302	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
4444402	4444402	PRJNA641707_P_NODE_544_length_2039_cov_136.416080_g343_i0	PRJNA641707	544	2039	136.41608	2781.5238712	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1893	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g343	i0	83.779	856.045610593428	2059	270	99	57	8	2036	5031231	5033255	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1745477	1893	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
5719419	5719419	PRJNA641707_P_NODE_320905_length_157_cov_8.305556_g318242_i0	PRJNA641707	320905	157	8.305556	13.03972292	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	185	1.2199999999999999e-42	NTclustered	gi\|2874254158\|emb\|OY970388.1\|	3107663	g318242	i0	89.796	140.770700636943	147	11	92	4	1	145	1879305	1879449	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.231 genome assembly, chromosome: 1	blastn	22101	185	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
6995290	6995290	PRJNA641707_P_NODE_546_length_2038_cov_181.229261_g343_i1	PRJNA641707	546	2038	181.229261	3693.45233918	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1892	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g343	i1	83.747	766.908734052993	2055	277	99	51	8	2035	5031231	5033255	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1562960	1892	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
8265461	8265461	PRJNA641707_P_NODE_160827_length_212_cov_9.625767_g158164_i0	PRJNA641707	160827	212	9.625767	20.40662604	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	211	2.91e-50	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g158164	i0	84.906	126.900943396226	212	29	99	3	2	212	5031538	5031329	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	26903	211	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
8270762	8270762	PRJNA641707_P_NODE_88507_length_246_cov_5.994924_g85844_i0	PRJNA641707	88507	246	5.994924	14.74751304	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	97.8	1.66e-21	NR	HVO03986.1	2952917	g85844	i0	55.9	2.70731707317073	111	18	97.6	1	7	246	185	295	HVO03986.1 phosphoribosylformylglycinamidine synthase subunit PurL [Candidatus Cybelea sp.]	diamond	666	97.8	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
9544642	9544642	PRJNA641707_P_NODE_332268_length_153_cov_6.365385_g329605_i0	PRJNA641707	332268	153	6.365385	9.73903905	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	195	1.97e-45	NTclustered	gi\|2874253636\|emb\|OY968762.1\|	3107663	g329605	i0	91.549	355.856209150327	142	10	92	2	1	141	423744	423604	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1	blastn	54446	195	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
14643495	14643495	PRJNA641707_P_NODE_268112_length_175_cov_3.214286_g265449_i0	PRJNA641707	268112	175	3.214286	5.6250005	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	87.9	4.04e-13	NTclustered	gi\|2874254010\|emb\|OY970335.1\|	3107663	g265449	i0	84.615	25.3485714285714	91	10	51	4	51	139	1802412	1802500	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10064.bin.c.2 genome assembly, chromosome: 1	blastn	4436	87.9	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
15918733	15918733	PRJNA641707_P_NODE_323453_length_156_cov_9.915888_g320790_i0	PRJNA641707	323453	156	9.915888	15.46878528	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	108	2.7e-19	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g320790	i0	80.576	0.891025641025641	139	27	89	0	15	153	2898130	2897992	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	139	108	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17190205	17190205	PRJNA641707_P_NODE_16574_length_533_cov_182.791322_g14179_i0	PRJNA641707	16574	533	182.791322	974.27774626	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	660	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g14179	i0	89.306	691.606003752345	533	47	99	10	1	528	5033779	5033252	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	368626	660	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17195161	17195161	PRJNA641707_P_NODE_78714_length_246_cov_9.055838_g76051_i0	PRJNA641707	78714	246	9.055838	22.27736148	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	180	9.77e-41	NTclustered	gi\|2874254122\|emb\|OY970207.1\|	3107663	g76051	i0	99	41.6056910569106	100	1	78	0	1	100	2165160	2165061	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1	blastn	10235	180	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
18467282	18467282	PRJNA641707_P_NODE_290475_length_167_cov_1.864407_g287812_i0	PRJNA641707	290475	167	1.864407	3.11355969	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	103	1.69e-25	NR	MFA5504023.1	3107663	g287812	i0	94.4	0.970059880239521	54	3	97	0	2	163	47	100	MFA5504023.1 Crp/Fnr family transcriptional regulator [Vulcanimicrobiota bacterium]	diamond	162	103	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
18468618	18468618	PRJNA641707_P_NODE_40435_length_342_cov_80.593857_g37794_i0	PRJNA641707	40435	342	80.593857	275.63099094	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	379	1.31e-100	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g37794	i0	87.059	841.874269005848	340	38	99	6	6	342	5033252	5033588	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	287921	379	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21013785	21013785	PRJNA641707_P_NODE_12677_length_607_cov_29.983871_g10489_i0	PRJNA641707	12677	607	29.983871	182.00209697	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	606	1.0199999999999998e-168	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g10489	i0	84.992	98.0115321252059	613	75	99	13	1	604	5031834	5031230	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	59493	606	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21017482	21017482	PRJNA641707_P_NODE_28937_length_402_cov_55.705382_g26333_i0	PRJNA641707	28937	402	55.705382	223.93563564	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	411	5.519999999999998e-110	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g26333	i0	85.258	135.134328358209	407	50	100	8	1	402	5031433	5031834	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	54324	411	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
22293901	22293901	PRJNA641707_P_NODE_58658_length_278_cov_8.855895_g55997_i0	PRJNA641707	58658	278	8.855895	24.6193881	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	283	8.34e-72	NTclustered	gi\|2874253636\|emb\|OY968762.1\|	3107663	g55997	i0	87.5	50.7158273381295	256	18	92	3	18	273	421910	422151	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1	blastn	14099	283	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
23565346	23565346	PRJNA641707_P_NODE_185679_length_199_cov_8.260000_g183016_i0	PRJNA641707	185679	199	8.26	16.4374	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	333	5.509999999999998e-87	NTclustered	gi\|2874254122\|emb\|OY970207.1\|	3107663	g183016	i0	97.436	0.979899497487437	195	5	98	0	1	195	1543019	1543213	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1	blastn	195	333	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
24843185	24843185	PRJNA641707_P_NODE_6000_length_865_cov_57.052696_g4509_i0	PRJNA641707	6000	865	57.052696	493.5058204	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	647	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g4509	i0	81.773	520.351445086705	812	113	92	34	4	797	5033255	5032461	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	450104	647	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
24843798	24843798	PRJNA641707_P_NODE_8860_length_717_cov_171.803892_g343_i2	PRJNA641707	8860	717	171.803892	1231.83390564	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	416	2.21e-111	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g343	i2	79.128	296.182705718271	642	105	88	26	89	717	5031205	5031830	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	212363	416	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
28281064	28281064	PRJNA641707_P_NODE_238006_length_187_cov_5.224638_g235343_i0	PRJNA641707	238006	187	5.224638	9.77007306	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	79.3	2.25e-15	NR	MFN8611279.1	3107663	g235343	i0	63.3	0.962566844919786	60	20	93	1	180	7	324	383	MFN8611279.1 methionine--tRNA ligase [Vulcanimicrobiota bacterium]	diamond	180	79.3	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
28754916	28754916	PRJNA641707_P_NODE_286807_length_168_cov_2.789916_g284144_i0	PRJNA641707	286807	168	2.789916	4.68705888	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	73.9	1.09e-13	NR	MFA5506428.1	3107663	g284144	i0	70	0.892857142857143	50	15	89.3	0	166	17	324	373	MFA5506428.1 histidinol-phosphate transaminase [Vulcanimicrobiota bacterium]	diamond	150	73.9	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
29228681	29228681	PRJNA641707_P_NODE_175249_length_200_cov_13.536424_g172586_i0	PRJNA641707	175249	200	13.536424	27.072848	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	45.1	0.00318	NR	MFA5508587.1	3107663	g172586	i0	61.5	0.585	39	15	58.5	0	5	121	296	334	MFA5508587.1 adenylate/guanylate cyclase domain-containing protein [Vulcanimicrobiota bacterium]	diamond	117	45.1	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
30713056	30713056	PRJNA641707_P_NODE_326494_length_155_cov_6.981132_g323831_i0	PRJNA641707	326494	155	6.981132	10.8207546	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	85.9	4.8e-18	NR	MFA7484100.1	3107663	g323831	i0	68	1.93548387096774	50	16	96.8	0	6	155	289	338	MFA7484100.1 S-layer homology domain-containing protein [Vulcanimicrobiota bacterium]	diamond	300	85.9	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
31439916	31439916	PRJNA641707_P_NODE_272876_length_173_cov_4.040323_g270213_i0	PRJNA641707	272876	173	4.040323	6.98975879	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	96.7	1.44e-21	NR	MFA5504535.1	3107663	g270213	i0	73.7	1.94219653179191	57	15	98.8	0	2	172	25	81	MFA5504535.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	336	96.7	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
31566849	31566849	PRJNA641707_P_NODE_95916_length_246_cov_4.802030_g93253_i0	PRJNA641707	95916	246	4.80203	11.8129938	Candidatus Elarobacter sp.	3047550	Bacteria	Bacteria	67.4	7.53e-11	NR	HEX3468584.1	3047550	g93253	i0	48.1	0.939024390243902	77	32	84.1	1	12	218	294	370	HEX3468584.1 hypothetical protein [Candidatus Elarobacter sp.]	diamond	231	67.4	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Elarobacter	Candidatus Elarobacter sp.
32893561	32893561	PRJNA641707_P_NODE_221900_length_192_cov_18.069930_g219237_i0	PRJNA641707	221900	192	18.06993	34.6942656	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	115	6.55e-28	NR	MFN8606726.1	3107663	g219237	i0	82.8	1	64	11	100	0	192	1	954	1017	MFN8606726.1 RHS repeat-associated core domain-containing protein [Vulcanimicrobiota bacterium]	diamond	192	115	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota 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);;