metadata: contig_metadata: 33 rows where bioproject = "PRJNA306153" and tax

33 rows where bioproject = "PRJNA306153" 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
1651159	1651159	PRJNA306153_S_NODE_562_length_309_cov_35.889286_g549_i0	PRJNA306153	562	309	35.889286	110.89789374	Staphylococcus epidermidis	1282	Bacteria	Bacteria	507	5.12e-139	NTclustered	gi\|2505659350\|gb\|CP118842.1\|	1282	g549	i0	97.643	527.427184466019	297	4	95	3	1	294	977165	976869	Staphylococcus epidermidis strain 7049 chromosome, complete genome	blastn	162975	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2337496	2337496	PRJNA306153_S_NODE_1242_length_215_cov_6.478495_g1229_i0	PRJNA306153	1242	215	6.478495	13.92876425	Anaerococcus	165779	Bacteria	Bacteria	368	1.66e-97	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g1229	i0	97.674	266.497674418605	215	4	100	1	1	215	1839	1626	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	57297	368	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
2927022	2927022	PRJNA306153_S_NODE_1063_length_232_cov_3.448276_g1050_i0	PRJNA306153	1063	232	3.448276	8.00000032	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	291	4.04e-74	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g1050	i0	89.27	145.375	233	23	100	2	1	232	437775	438006	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	33727	291	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
2927035	2927035	PRJNA306153_S_NODE_323_length_384_cov_9.171831_g310_i0	PRJNA306153	323	384	9.171831	35.21983104	Dolosigranulum pigrum	29394	Bacteria	Bacteria	710	0	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g310	i0	100	461.098958333333	384	0	100	0	1	384	1791836	1791453	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	177062	710	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
3612784	3612784	PRJNA306153_S_NODE_143_length_521_cov_27.788618_g133_i0	PRJNA306153	143	521	27.788618	144.77869978	Staphylococcus	1279	Bacteria	Bacteria	948	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g133	i0	99.615	542.426103646833	519	2	99	0	1	519	748929	748411	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	282604	948	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3612791	3612791	PRJNA306153_S_NODE_643_length_293_cov_21.609848_g630_i0	PRJNA306153	643	293	21.609848	63.31685464	Thermobacillus	76632	Bacteria	Bacteria	261	4.15e-65	NTclustered	gi\|485099170\|ref\|NR_102564.1\|	377615	g630	i0	83.056	181.825938566553	301	38	100	13	1	293	474	179	Thermobacillus composti strain KWC4 23S ribosomal RNA gene, complete sequence	blastn	53275	261	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Thermobacillus	Thermobacillus composti
7440215	7440215	PRJNA306153_S_NODE_1706_length_188_cov_9.163522_g1693_i0	PRJNA306153	1706	188	9.163522	17.22742136	Streptococcus	1301	Bacteria	Bacteria	331	1.85e-86	NTclustered	gi\|1578069334\|emb\|LR216032.1\|	1313	g1693	i0	98.404	322	188	3	100	0	1	188	23295	23482	Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1	blastn	60536	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
7440228	7440228	PRJNA306153_S_NODE_726_length_279_cov_13.924000_g713_i0	PRJNA306153	726	279	13.924	38.84796	Geobacillus	129337	Bacteria	Bacteria	311	3.84e-80	NTclustered	gi\|1799620842\|gb\|CP034952.1\|	1422	g713	i0	87.226	912.480286738351	274	34	98	1	1	274	227377	227649	Geobacillus stearothermophilus strain B5 chromosome, complete genome	blastn	254582	313	0.993610223642173	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
8714890	8714890	PRJNA306153_S_NODE_127_length_547_cov_36.073359_g10_i1	PRJNA306153	127	547	36.073359	197.32127373	Staphylococcus	1279	Bacteria	Bacteria	1000	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10	i1	99.816	539.446069469835	544	1	100	0	4	547	2278334	2277791	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	295077	1000	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8714892	8714892	PRJNA306153_S_NODE_1567_length_195_cov_9.277108_g1554_i0	PRJNA306153	1567	195	9.277108	18.0903606	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|2675654968\|gb\|PP338727.1\|	1579	g1554	i0	100	120	195	0	100	0	1	195	583	777	Lactobacillus acidophilus strain RG-07 16S ribosomal RNA gene, partial sequence	blastn	23400	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus
10580297	10580297	PRJNA306153_S_NODE_289_length_399_cov_10.005405_g277_i0	PRJNA306153	289	399	10.005405	39.92156595	Dolosigranulum pigrum	29394	Bacteria	Bacteria	737	0	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g277	i0	100	398.290726817043	399	0	100	0	1	399	1419476	1419078	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	158918	737	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
11265463	11265463	PRJNA306153_S_NODE_2789_length_150_cov_13.123967_g2776_i0	PRJNA306153	2789	150	13.123967	19.6859505	Streptococcus	1301	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2776	i0	100	299.52	129	0	86	0	22	150	1571230	1571358	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	44928	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
12540755	12540755	PRJNA306153_S_NODE_1230_length_216_cov_4.561497_g1217_i0	PRJNA306153	1230	216	4.561497	9.85283352	Finegoldia	150022	Bacteria	Bacteria	399	5.909999999999999e-107	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g1217	i0	100	464.138888888889	216	0	100	0	1	216	164005	164220	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	100254	399	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
12540760	12540760	PRJNA306153_S_NODE_2650_length_154_cov_4.680000_g2637_i0	PRJNA306153	2650	154	4.68	7.2072	FCB group	1783270	Bacteria	Bacteria	283	4.12e-72	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g2637	i0	100	528.551948051948	153	0	99	0	1	153	523234	523386	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	81397	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
12540769	12540769	PRJNA306153_S_NODE_910_length_249_cov_13.154545_g897_i0	PRJNA306153	910	249	13.154545	32.75481705	Dolosigranulum	29393	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g897	i0	100	432.128514056225	249	0	100	0	1	249	427304	427056	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	107600	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
15089903	15089903	PRJNA306153_S_NODE_972_length_243_cov_19.317757_g959_i0	PRJNA306153	972	243	19.317757	46.94214951	Streptococcus	1301	Bacteria	Bacteria	431	2.4099999999999995e-116	NTclustered	gi\|1539702073\|emb\|LR134266.1\|	78535	g959	i0	100	435.333333333333	233	0	96	0	2	234	18586	18818	Streptococcus viridans strain NCTC3166 genome assembly, chromosome: 1	blastn	105786	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus viridans
15679123	15679123	PRJNA306153_S_NODE_2613_length_155_cov_3.158730_g2600_i0	PRJNA306153	2613	155	3.15873	4.8960315	Anaerococcus nagyae	1755241	Bacteria	Bacteria	281	1.49e-71	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g2600	i0	99.355	38.6774193548387	155	1	100	0	1	155	121862	122016	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	5995	281	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
16364749	16364749	PRJNA306153_S_NODE_1073_length_231_cov_4.554455_g1060_i0	PRJNA306153	1073	231	4.554455	10.52079105	Finegoldia	150022	Bacteria	Bacteria	355	1.4e-93	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g1060	i0	94.421	469.987012987013	233	9	100	4	1	231	164235	164005	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	108567	355	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
16364762	16364762	PRJNA306153_S_NODE_753_length_275_cov_13.593496_g740_i0	PRJNA306153	753	275	13.593496	37.382114	Streptococcus	1301	Bacteria	Bacteria	488	1.6299999999999995e-133	NTclustered	gi\|1686100227\|gb\|MK330575.1\|	28037	g740	i0	99.259	318.021818181818	270	2	98	0	1	270	2041	1772	Streptococcus mitis strain PL429 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	87456	488	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
17639900	17639900	PRJNA306153_S_NODE_1914_length_179_cov_4.653333_g1901_i0	PRJNA306153	1914	179	4.653333	8.32946607	root	1	Root_unresolved	Root_unresolved	331	1.74e-86	NTclustered	gi\|7621529\|gb\|AF243172.1\|	47770	g1901	i0	100	108	179	0	100	0	1	179	327	149	Lactobacillus crispatus strain TL25a 16S ribosomal RNA gene, partial sequence	blastn	19332	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
17639902	17639902	PRJNA306153_S_NODE_2574_length_155_cov_14.579365_g2561_i0	PRJNA306153	2574	155	14.579365	22.59801575	Enterococcus	1350	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|939198273\|gb\|CP010060.1\|	44008	g2561	i0	100	427.025806451613	155	0	100	0	1	155	140655	140809	Enterococcus cecorum strain SA1 genome	blastn	66189	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
17639903	17639903	PRJNA306153_S_NODE_2674_length_153_cov_23.540323_g2661_i0	PRJNA306153	2674	153	23.540323	36.01669419	Streptococcus	1301	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2661	i0	98.693	331	153	2	100	0	1	153	1571253	1571101	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	50643	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
18228047	18228047	PRJNA306153_S_NODE_2595_length_155_cov_5.126984_g2582_i0	PRJNA306153	2595	155	5.126984	7.9468252	uncultured Eubacteriales bacterium	172733	Bacteria	Bacteria	243	7.05e-60	NTclustered	gi\|297346667\|gb\|HM080213.1\|	172733	g2582	i0	95.395	97.5806451612903	152	7	98	0	4	155	233	82	Uncultured Clostridiales bacterium clone E171E08 16S ribosomal RNA gene, partial sequence	blastn	15125	243	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
19502330	19502330	PRJNA306153_S_NODE_236_length_436_cov_19.828010_g224_i0	PRJNA306153	236	436	19.82801	86.4501236	Staphylococcus epidermidis	1282	Bacteria	Bacteria	575	2.0199999999999994e-159	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g224	i0	91.101	517.855504587156	427	35	98	3	3	428	265603	266027	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	225785	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19502334	19502334	PRJNA306153_S_NODE_376_length_363_cov_10.508982_g363_i0	PRJNA306153	376	363	10.508982	38.14760466	Anoxybacillus sp. PDR2	1636720	Bacteria	Bacteria	503	7.91e-138	NTclustered	gi\|1790794628\|gb\|CP047158.1\|	1636720	g363	i0	95.57	724.939393939394	316	11	87	3	49	363	14053	14366	Anoxybacillus sp. PDR2 chromosome, complete genome	blastn	263153	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus sp. PDR2
19502337	19502337	PRJNA306153_S_NODE_716_length_281_cov_39.730159_g703_i0	PRJNA306153	716	281	39.730159	111.64174679	Romboutsia sp. 13154	2708052	Bacteria	Bacteria	429	1.02e-115	NTclustered	gi\|2034578690\|gb\|CP048740.1\|	2708052	g703	i0	94.326	548.88256227758	282	13	100	3	1	281	2510721	2510442	Romboutsia sp. 13154 chromosome	blastn	154236	429	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. 13154
20188322	20188322	PRJNA306153_S_NODE_1236_length_215_cov_30.725806_g1223_i0	PRJNA306153	1236	215	30.725806	66.0604829	Streptococcus	1301	Bacteria	Bacteria	379	7.659999999999998e-101	NTclustered	gi\|1578069334\|emb\|LR216032.1\|	1313	g1223	i0	99.052	339.176744186047	211	2	98	0	1	211	20619	20829	Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1	blastn	72923	381	0.994750656167979	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
21463984	21463984	PRJNA306153_S_NODE_1237_length_215_cov_18.860215_g1224_i0	PRJNA306153	1237	215	18.860215	40.54946225	root	1	Root_unresolved	Root_unresolved	377	2.75e-100	NTclustered	gi\|289541377\|gb\|GU395995.1\|	29394	g1224	i0	100	97.7627906976744	204	0	95	0	1	204	531	734	Dolosigranulum pigrum strain 33929-06 16S ribosomal RNA gene, partial sequence	blastn	21019	379	0.994722955145119	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
21463989	21463989	PRJNA306153_S_NODE_77_length_645_cov_15.355519_g71_i0	PRJNA306153	77	645	15.355519	99.04309755	Bacillaceae	186817	Bacteria	Bacteria	460	8.99e-125	NTclustered	gi\|1662226728\|gb\|CP040441.1\|	86665	g71	i0	79.939	189.395348837209	658	107	100	24	1	645	27712	28357	Halalkalibacterium halodurans isolate LB-1 chromosome, complete genome	blastn	122160	464	0.991379310344828	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halalkalibacterium (ex Joshi et al. 2022)	Halalkalibacterium halodurans
22739046	22739046	PRJNA306153_S_NODE_1678_length_189_cov_26.593750_g1665_i0	PRJNA306153	1678	189	26.59375	50.2621875	Brevibacillus	55080	Bacteria	Bacteria	254	4.14e-63	NTclustered	gi\|2554582126\|emb\|OY569118.1\|	927786	g1665	i0	91.398	912.830687830688	186	15	98	1	1	186	496611	496795	Brevibacillus aydinogluensis strain 4475 genome assembly, chromosome: 4475	blastn	172525	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus aydinogluensis
22739047	22739047	PRJNA306153_S_NODE_1818_length_183_cov_9.993506_g1805_i0	PRJNA306153	1818	183	9.993506	18.28811598	Anoxybacillus	150247	Bacteria	Bacteria	292	8.44e-75	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g1805	i0	97.647	809.20218579235	170	4	93	0	14	183	2166796	2166965	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	148084	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
22739053	22739053	PRJNA306153_S_NODE_318_length_386_cov_7820.350140_g305_i0	PRJNA306153	318	386	7820.35014	30186.5515404	Geobacillus	129337	Bacteria	Bacteria	460	5.169999999999999e-125	NTclustered	gi\|2533118191\|gb\|CP129217.1\|	213419	g305	i0	91.94	636.70725388601	335	18	86	9	55	386	13355	13027	Geobacillus zalihae strain JS1-2 chromosome, complete genome	blastn	245769	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus zalihae
28242635	28242635	PRJNA306153_S_NODE_2066_length_173_cov_4.680556_g2053_i0	PRJNA306153	2066	173	4.680556	8.09736188	Staphylococcus aureus	1280	Bacteria	Bacteria	39.7	0.0325	NR	MCS5093794.1	1280	g2053	i0	92.3	0.450867052023121	26	2	45.1	0	11	88	3	28	MCS5093794.1 hypothetical protein [Staphylococcus aureus]	diamond	78	39.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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