metadata: contig_metadata: 35 rows where bioproject = "PRJNA335774", tax_kingdom = "Bacillati" and tax

35 rows where bioproject = "PRJNA335774", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

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
5494373	5494373	PRJNA335774_P_NODE_47425_length_242_cov_0.911243_g47273_i0	PRJNA335774	47425	242	0.911243	2.20520806	Staphylococcus epidermidis	1282	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2315803957\|gb\|CP106835.1\|	1282	g47273	i0	100	7	242	0	100	0	1	242	34701	34460	Staphylococcus epidermidis strain AH6072 plasmid pAH6072_1, complete sequence	blastn	1694	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6767541	6767541	PRJNA335774_P_NODE_10346_length_452_cov_4.567282_g10194_i0	PRJNA335774	10346	452	4.567282	20.64411464	root	1	Root_unresolved	Root_unresolved	187	3.07e-58	NR	MRC56835.1	1428	g10194	i0	80	17.9601769911504	115	22	76.3	1	423	79	10	123	MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis]	diamond	8118	187	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
9318827	9318827	PRJNA335774_P_NODE_4888_length_622_cov_4.562842_g4743_i0	PRJNA335774	4888	622	4.562842	28.38087724	Clostridium perfringens	1502	Bacteria	Bacteria	254	6.99e-83	NR	MDJ8942385.1	1502	g4743	i0	80.5	0.742765273311897	154	30	74.3	0	487	26	42	195	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	462	254	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
11869305	11869305	PRJNA335774_P_NODE_42910_length_247_cov_0.885057_g42758_i0	PRJNA335774	42910	247	0.885057	2.18609079	Streptococcus sp. Marseille-Q6470	2972784	Bacteria	Bacteria	374	4.189999999999998e-99	NTclustered	gi\|2306632708\|emb\|OX336385.1\|	2972784	g42758	i0	93.927	2.98785425101215	247	15	100	0	1	247	231626	231380	Streptococcus sp. Marseille-Q6470 genome assembly, chromosome: contig00001	blastn	738	374	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q6470
12548207	12548207	PRJNA335774_P_NODE_38670_length_251_cov_1.713483_g38518_i0	PRJNA335774	38670	251	1.713483	4.30084233	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g38518	i0	100	534.764940239044	251	0	100	0	1	251	748740	748490	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	134226	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13143720	13143720	PRJNA335774_P_NODE_20191_length_341_cov_1.149254_g20039_i0	PRJNA335774	20191	341	1.149254	3.91895614	Natroniella sp. ANB-PHB2	3384444	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2869714905\|gb\|CP175562.1\|	3384444	g20039	i0	100	0.0850439882697947	29	0	9	0	52	80	1966718	1966746	Natroniella sp. ANB-PHB2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halobacteroidaceae	Natroniella	Natroniella sp. ANB-PHB2
13144424	13144424	PRJNA335774_P_NODE_571_length_1368_cov_2.465637_g528_i0	PRJNA335774	571	1368	2.465637	33.72991416	Clostridium perfringens	1502	Bacteria	Bacteria	210	5.61e-61	NR	MDJ8942383.1	1502	g528	i0	70.2	0.449561403508772	205	59	45	1	1051	437	74	276	MDJ8942383.1 hypothetical protein [Clostridium perfringens]	diamond	615	210	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
13144533	13144533	PRJNA335774_P_NODE_9851_length_462_cov_1.421594_g9699_i0	PRJNA335774	9851	462	1.421594	6.56776428	Bacteria	2	Bacteria	Bacteria	198	6.879999999999999e-60	NR	HHT14665.1	1898207	g9699	i0	61.7	3	154	58	99.4	1	461	3	46	199	HHT14665.1 UDP-glucose 4-epimerase GalE [Clostridiales bacterium]	diamond	1386	198	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
17647194	17647194	PRJNA335774_P_NODE_25274_length_310_cov_1.658228_g25122_i0	PRJNA335774	25274	310	1.658228	5.1405068	Clostridium	1485	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g25122	i0	100	1.96451612903226	29	0	9	0	128	156	3511064	3511036	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	609	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
22067189	22067189	PRJNA335774_P_NODE_4498_length_642_cov_1.246046_g4355_i0	PRJNA335774	4498	642	1.246046	7.99961532	Clostridium sp. MB05	3376682	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2882621205\|gb\|CP174370.1\|	3376682	g4355	i0	100	0.0482866043613707	31	0	5	0	191	221	463333	463363	Clostridium sp. MB05 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. MB05
26680312	26680312	PRJNA335774_P_NODE_2141_length_864_cov_1.902655_g2024_i0	PRJNA335774	2141	864	1.902655	16.4389392	Bacillota	1239	Bacteria	Bacteria	95.9	2.01e-18	NR	WP_007062230.1	217159	g2024	i0	28.4	5.80555555555556	261	164	85.8	8	758	18	7	258	WP_007062230.1 ammonium transporter [Clostridium carboxidivorans]	diamond	5016	95.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium carboxidivorans
26789921	26789921	PRJNA335774_P_NODE_24381_length_315_cov_1.462810_g24229_i0	PRJNA335774	24381	315	1.46281	4.6078515	Streptococcus pneumoniae	1313	Bacteria	Bacteria	42.4	0.0231	NR	WP_233274273.1	1313	g24229	i0	36.2	1.31428571428571	69	43	64.8	1	230	27	14	82	WP_233274273.1 DUF5361 domain-containing protein [Streptococcus pneumoniae]	diamond	414	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
26838990	26838990	PRJNA335774_P_NODE_36321_length_261_cov_1.148936_g36169_i0	PRJNA335774	36321	261	1.148936	2.99872296	Bacillales	1385	Bacteria	Bacteria	108	1.02e-25	NR	WP_069325903.1	44249	g36169	i0	64.7	10.7931034482759	85	27	94.3	1	248	3	118	202	WP_069325903.1 MULTISPECIES: NADH-dependent flavin oxidoreductase [Paenibacillus]	diamond	2817	109	0.990825688073395	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
26979681	26979681	PRJNA335774_P_NODE_5962_length_572_cov_1.212425_g5812_i0	PRJNA335774	5962	572	1.212425	6.935071	[Eubacterium] hominis	2764325	Bacteria	Bacteria	47	0.0165	NR	WP_187426296.1	2764325	g5812	i0	41.2	0.356643356643357	68	32	35.7	1	324	121	4	63	WP_187426296.1 Cof-type HAD-IIB family hydrolase [[Eubacterium] hominis]	diamond	204	47	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Amedibacillus	[Eubacterium] hominis
27154711	27154711	PRJNA335774_P_NODE_3802_length_689_cov_1.498377_g3660_i0	PRJNA335774	3802	689	1.498377	10.32381753	Bacteria	2	Bacteria	Bacteria	44.7	0.0317	NR	WP_053432415.1	86665	g3660	i0	32.7	0.896952104499274	107	55	41.4	3	689	405	2	103	WP_053432415.1 YbjQ family protein [Halalkalibacterium halodurans]	diamond	618	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halalkalibacterium (ex Joshi et al. 2022)	Halalkalibacterium halodurans
27169242	27169242	PRJNA335774_P_NODE_43702_length_246_cov_0.890173_g43550_i0	PRJNA335774	43702	246	0.890173	2.18982558	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	63.5	1.86e-9	NR	MBS3812162.1	2094029	g43550	i0	50	0.585365853658537	48	24	58.5	0	70	213	1	48	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	144	63.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
27454048	27454048	PRJNA335774_P_NODE_11123_length_438_cov_1.506849_g10971_i0	PRJNA335774	11123	438	1.506849	6.59999862	Shimazuella kribbensis	139808	Bacteria	Bacteria	53.5	4.31e-5	NR	WP_051271327.1	139808	g10971	i0	40.7	0.773972602739726	113	56	75.3	4	3	332	211	315	WP_051271327.1 acyltransferase family protein [Shimazuella kribbensis]	diamond	339	53.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Shimazuella	Shimazuella kribbensis
27724094	27724094	PRJNA335774_P_NODE_17944_length_358_cov_1.350877_g17792_i0	PRJNA335774	17944	358	1.350877	4.83613966	root	1	Root_unresolved	Root_unresolved	60.8	1.1e-9	NR	MRA76214.1	1428	g17792	i0	66	0.837988826815642	50	14	40.2	2	2	145	12	60	MRA76214.1 hypothetical protein [Bacillus thuringiensis]	diamond	300	61.2	0.993464052287582	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
27990736	27990736	PRJNA335774_P_NODE_18565_length_353_cov_1.114286_g18413_i0	PRJNA335774	18565	353	1.114286	3.93342958	Bacilli bacterium	1903720	Bacteria	Bacteria	43.9	0.0466	NR	MCI7220744.1	1903720	g18413	i0	37.1	0.824362606232295	97	51	74.8	4	328	65	70	165	MCI7220744.1 hypothetical protein [Bacilli bacterium]	diamond	291	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
28559142	28559142	PRJNA335774_P_NODE_45507_length_244_cov_0.900585_g45355_i0	PRJNA335774	45507	244	0.900585	2.1974274	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	124	7.6799999999999996e-31	NR	MBS3812162.1	2094029	g45355	i0	70.9	0.971311475409836	79	23	97.1	0	237	1	299	377	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	237	124	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
28779818	28779818	PRJNA335774_P_NODE_36327_length_261_cov_1.117021_g36175_i0	PRJNA335774	36327	261	1.117021	2.91542481	Parasporobacterium sp.	2740533	Bacteria	Bacteria	85.9	1.44e-17	NR	MCF0230466.1	2740533	g36175	i0	56.3	0.816091954022989	71	31	81.6	0	48	260	29	99	MCF0230466.1 asparaginase [Parasporobacterium sp.]	diamond	213	85.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Parasporobacterium	Parasporobacterium sp.
28860279	28860279	PRJNA335774_P_NODE_16328_length_372_cov_1.571906_g16176_i0	PRJNA335774	16328	372	1.571906	5.84749032	root	1	Root_unresolved	Root_unresolved	44.7	0.0262	NR	WP_185358167.1	1640	g16176	i0	38.5	2.00806451612903	65	36	49.2	1	341	159	46	110	WP_185358167.1 ATP-binding cassette domain-containing protein [Listeria seeligeri]	diamond	747	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria seeligeri
28906049	28906049	PRJNA335774_P_NODE_23548_length_320_cov_0.931174_g23396_i0	PRJNA335774	23548	320	0.931174	2.9797568	Ligilactobacillus sp. WC1T17	3158786	Bacteria	Bacteria	44.3	0.0187	NR	WP_225355186.1	3158786	g23396	i0	31	0.54375	58	40	54.4	0	205	32	19	76	WP_225355186.1 hypothetical protein [Ligilactobacillus sp. WC1T17]	diamond	174	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus sp. WC1T17
29064300	29064300	PRJNA335774_P_NODE_8468_length_493_cov_1.278571_g8316_i0	PRJNA335774	8468	493	1.278571	6.30335503	Agathobacter sp.	2021311	Bacteria	Bacteria	45.8	0.0313	NR	MBQ6811639.1	2021311	g8316	i0	22.9	0.718052738336714	118	82	71.8	1	457	104	241	349	MBQ6811639.1 CapA family protein [Agathobacter sp.]	diamond	354	45.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter sp.
29474327	29474327	PRJNA335774_P_NODE_41990_length_248_cov_0.880000_g41838_i0	PRJNA335774	41990	248	0.88	2.1824	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	41.6	0.0397	NR	MBE6134480.1	2049044	g41838	i0	31.1	0.737903225806452	61	42	73.8	0	248	66	38	98	MBE6134480.1 hypothetical protein [Erysipelotrichaceae bacterium]	diamond	183	41.6	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
29537684	29537684	PRJNA335774_P_NODE_34190_length_270_cov_0.923858_g34038_i0	PRJNA335774	34190	270	0.923858	2.4944166	Sporofaciens musculi	2681861	Bacteria	Bacteria	42.7	0.0495	NR	WP_159750977.1	2681861	g34038	i0	50	0.511111111111111	46	23	51.1	0	187	50	169	214	WP_159750977.1 MATE family efflux transporter [Sporofaciens musculi]	diamond	138	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Sporofaciens	Sporofaciens musculi
29916850	29916850	PRJNA335774_P_NODE_37271_length_257_cov_1.255435_g37119_i0	PRJNA335774	37271	257	1.255435	3.22646795	Enterococcus faecium	1352	Bacteria	Bacteria	49.3	2.15e-4	NR	WP_334412465.1	1352	g37119	i0	61	0.957198443579767	82	32	95.7	0	3	248	14	95	WP_334412465.1 hypothetical protein, partial [Enterococcus faecium]	diamond	246	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
30123374	30123374	PRJNA335774_P_NODE_41632_length_248_cov_0.880000_g41480_i0	PRJNA335774	41632	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	96.3	5.97e-21	NR	WP_093230995.1	46223	g41480	i0	55.7	20.1411290322581	79	34	95.6	1	10	246	1024	1101	WP_093230995.1 non-ribosomal peptide synthetase [Thermoflavimicrobium dichotomicum]	diamond	4995	96.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Thermoflavimicrobium	Thermoflavimicrobium dichotomicum
30453996	30453996	PRJNA335774_P_NODE_11093_length_439_cov_0.964481_g10941_i0	PRJNA335774	11093	439	0.964481	4.23407159	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	45.4	0.0114	NR	MCI8714955.1	2485925	g10941	i0	32.1	0.533029612756264	78	51	53.3	1	32	265	2	77	MCI8714955.1 GNAT family N-acetyltransferase [Oscillospiraceae bacterium]	diamond	234	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
31085754	31085754	PRJNA335774_P_NODE_495_length_1414_cov_10.059657_g455_i0	PRJNA335774	495	1414	10.059657	142.24354998	Methylomusa anaerophila	1930071	Bacteria	Bacteria	127	4.24e-28	NR	WP_126308322.1	1930071	g455	i0	27.6	1.71004243281471	380	254	78.3	7	1234	128	40	409	WP_126308322.1 ammonium transporter [Methylomusa anaerophila]	diamond	2418	127	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Methylomusa	Methylomusa anaerophila
31324175	31324175	PRJNA335774_P_NODE_12675_length_414_cov_2.563050_g12523_i0	PRJNA335774	12675	414	2.56305	10.611027	root	1	Root_unresolved	Root_unresolved	205	5.41e-63	NR	MRB67411.1	1428	g12523	i0	78.5	34.1884057971015	121	26	87.7	0	52	414	11	131	MRB67411.1 30S ribosomal protein S2 [Bacillus thuringiensis]	diamond	14154	206	0.995145631067961	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
31433387	31433387	PRJNA335774_P_NODE_12596_length_416_cov_0.877551_g12444_i0	PRJNA335774	12596	416	0.877551	3.65061216	Candidatus Mediterraneibacter quadrami	2838684	Bacteria	Bacteria	44.7	0.0393	NR	HJD42471.1	2838684	g12444	i0	22.1	1.07451923076923	149	93	90.9	3	1	378	102	250	HJD42471.1 site-specific integrase [Candidatus Mediterraneibacter quadrami]	diamond	447	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Candidatus Mediterraneibacter quadrami
31686402	31686402	PRJNA335774_P_NODE_43577_length_246_cov_0.890173_g43425_i0	PRJNA335774	43577	246	0.890173	2.18982558	Bacillota bacterium	1879010	Bacteria	Bacteria	112	8.470000000000001e-27	NR	MDP4145640.1	1879010	g43425	i0	77.6	2.42682926829268	67	15	81.7	0	245	45	119	185	MDP4145640.1 portal protein [Bacillota bacterium]	diamond	597	112	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31749642	31749642	PRJNA335774_P_NODE_32597_length_276_cov_1.512315_g32445_i0	PRJNA335774	32597	276	1.512315	4.1739894	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	71.6	3.79e-12	NR	MBS3812162.1	2094029	g32445	i0	50	0.91304347826087	84	41	90.2	1	24	272	765	848	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	252	71.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32729877	32729877	PRJNA335774_P_NODE_33380_length_273_cov_1.240000_g33228_i0	PRJNA335774	33380	273	1.24	3.3852	Neobacillus cucumis	1740721	Bacteria	Bacteria	147	4.98e-41	NR	WP_378575475.1	1740721	g33228	i0	76.4	1.96703296703297	89	21	97.8	0	271	5	184	272	WP_378575475.1 elongation of very long chain fatty acids protein, partial [Neobacillus cucumis]	diamond	537	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus cucumis

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);;