metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1101946" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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
2295326	2295326	PRJNA1101946_S_NODE_10442_length_243_cov_6.912371_g10343_i0	PRJNA1101946	10442	243	6.912371	16.79706153	root	1	Root_unresolved	Root_unresolved	449	6.65e-122	NTclustered	gi\|2702654880\|gb\|CP148059.1\|	1280	g10343	i0	100	231.366255144033	243	0	100	0	1	243	1932341	1932583	Staphylococcus aureus strain BSN156 chromosome	blastn	56222	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
2295329	2295329	PRJNA1101946_S_NODE_10662_length_241_cov_4.510417_g10563_i0	PRJNA1101946	10662	241	4.510417	10.87010497	Clostridium	1485	Bacteria	Bacteria	387	5.24e-103	NTclustered	gi\|1321427195\|gb\|CP013847.1\|	1491	g10563	i0	95.473	848.381742738589	243	9	100	2	1	241	11846	12088	Clostridium botulinum strain Af650, complete sequence.	blastn	204460	390	0.992307692307692	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
3570444	3570444	PRJNA1101946_S_NODE_4723_length_315_cov_5.781955_g4624_i0	PRJNA1101946	4723	315	5.781955	18.21315825	Kurthia	1649	Bacteria	Bacteria	582	8.459999999999998e-162	NTclustered	gi\|2700494444\|gb\|CP147847.1\|	33946	g4624	i0	100	1074.51746031746	315	0	100	0	1	315	94791	94477	Kurthia gibsonii strain ND2 chromosome, complete genome	blastn	338473	582	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Kurthia	Kurthia gibsonii
4037990	4037990	PRJNA1101946_S_NODE_21484_length_174_cov_1.464000_g21385_i0	PRJNA1101946	21484	174	1.464	2.54736	Ectobacillus sp. JY-23	2933872	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2225259389\|gb\|CP095462.1\|	2933872	g21385	i0	100	0.160919540229885	28	0	16	0	76	103	1698143	1698170	Ectobacillus sp. JY-23 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ectobacillus	Ectobacillus sp. JY-23
4847974	4847974	PRJNA1101946_S_NODE_4304_length_323_cov_7.751825_g4205_i0	PRJNA1101946	4304	323	7.751825	25.03839475	FCB group	1783270	Bacteria	Bacteria	597	3.11e-166	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g4205	i0	100	532	323	0	100	0	1	323	522533	522855	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	171836	597	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
5314179	5314179	PRJNA1101946_S_NODE_8885_length_259_cov_3.157143_g8786_i0	PRJNA1101946	8885	259	3.157143	8.17700037	uncultured Clostridium sp.	59620	Bacteria	Bacteria	307	4.5600000000000005e-79	NTclustered	gi\|1899225347\|gb\|MT967816.1\|	59620	g8786	i0	88.123	1067.20077220077	261	28	100	3	1	259	2131	1872	Uncultured Clostridium sp. clone asv_315_2178 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	276405	307	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
6589360	6589360	PRJNA1101946_S_NODE_13986_length_215_cov_2.451807_g13887_i0	PRJNA1101946	13986	215	2.451807	5.27138505	Lacrimispora sphenoides	29370	Bacteria	Bacteria	292	1.0299999999999999e-74	NTclustered	gi\|1096105184\|emb\|LT630003.1\|	1297793	g13887	i0	91.163	2.77209302325581	215	19	100	0	1	215	3740160	3740374	[Clostridium] sphenoides JCM 1415 strain ATCC 19403 genome assembly, chromosome: I	blastn	596	292	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sphenoides
6589384	6589384	PRJNA1101946_S_NODE_2906_length_358_cov_5.537217_g2807_i0	PRJNA1101946	2906	358	5.537217	19.82323686	Lacrimispora sp. HJ-01	3375704	Bacteria	Bacteria	558	1.64e-154	NTclustered	gi\|2852291485\|gb\|CP173277.1\|	3375704	g2807	i0	95.184	6.83519553072626	353	17	99	0	6	358	3573092	3572740	Lacrimispora sp. HJ-01 chromosome, complete genome	blastn	2447	558	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sp. HJ-01
7397694	7397694	PRJNA1101946_S_NODE_18126_length_189_cov_4.721429_g18027_i0	PRJNA1101946	18126	189	4.721429	8.92350081	Streptococcus	1301	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|433515\|emb\|X68036.1\|	1348	g18027	i0	100	513.730158730159	189	0	100	0	1	189	2360	2172	S.parauberis gene for 23S rRNA	blastn	97095	350	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parauberis
7397704	7397704	PRJNA1101946_S_NODE_2606_length_369_cov_3.625000_g2507_i0	PRJNA1101946	2606	369	3.625	13.37625	FCB group	1783270	Bacteria	Bacteria	669	0	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g2507	i0	100	516.024390243902	362	0	98	0	8	369	523491	523130	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	190413	669	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
7397721	7397721	PRJNA1101946_S_NODE_5106_length_308_cov_7.482625_g5007_i0	PRJNA1101946	5106	308	7.482625	23.046485	Peribacillus	2675229	Bacteria	Bacteria	547	3.0099999999999987e-151	NTclustered	gi\|2673064830\|emb\|OY970400.1\|	450367	g5007	i0	100	61.9155844155844	296	0	96	0	1	296	1256557	1256262	Peribacillus frigoritolerans isolate BFRIG genome assembly, chromosome: 1	blastn	19070	547	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus frigoritolerans
7863985	7863985	PRJNA1101946_S_NODE_7267_length_277_cov_54.837719_g7168_i0	PRJNA1101946	7267	277	54.837719	151.90048163	Romboutsia ilealis	1115758	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1172272411\|emb\|LN555523.1\|	1115758	g7168	i0	100	0.104693140794224	29	0	10	0	160	188	1274284	1274312	Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
8673193	8673193	PRJNA1101946_S_NODE_8567_length_262_cov_5.422535_g8468_i0	PRJNA1101946	8567	262	5.422535	14.2070417	Staphylococcus	1279	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g8468	i0	100	100	262	0	100	0	1	262	1221005	1220744	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	26200	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9138850	9138850	PRJNA1101946_S_NODE_11848_length_231_cov_3.362637_g11749_i0	PRJNA1101946	11848	231	3.362637	7.76769147	Metabacillus sp. B2-18	2897333	Bacteria	Bacteria	84.2	7.32e-12	NTclustered	gi\|2161689137\|gb\|CP088245.1\|	2897333	g11749	i0	83.333	1.59307359307359	96	10	40	6	78	169	742285	742378	Metabacillus sp. B2-18 chromosome, complete genome	blastn	368	84.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus sp. B2-18
9948029	9948029	PRJNA1101946_S_NODE_10168_length_246_cov_3.883249_g10069_i0	PRJNA1101946	10168	246	3.883249	9.55279254	Kurthia	1649	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2700494444\|gb\|CP147847.1\|	33946	g10069	i0	99.593	93.3373983739837	246	1	100	0	1	246	903636	903391	Kurthia gibsonii strain ND2 chromosome, complete genome	blastn	22961	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Kurthia	Kurthia gibsonii
9948088	9948088	PRJNA1101946_S_NODE_3428_length_343_cov_6.210884_g3329_i0	PRJNA1101946	3428	343	6.210884	21.30333212	Bacillaceae	186817	Bacteria	Bacteria	601	2.57e-167	NTclustered	gi\|2166719243\|gb\|CP088268.1\|	152268	g3329	i0	98.251	1011.07871720117	343	6	100	0	1	343	349413	349071	Metabacillus litoralis strain NCTR108 chromosome, complete genome	blastn	346800	606	0.991749174917492	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus litoralis
10414650	10414650	PRJNA1101946_S_NODE_20049_length_180_cov_1.167939_g19950_i0	PRJNA1101946	20049	180	1.167939	2.1022902	Vagococcus fluvialis	2738	Bacteria	Bacteria	287	3.85e-73	NTclustered	gi\|2124551616\|gb\|CP081461.1\|	2738	g19950	i0	100	475.85	155	0	86	0	1	155	426170	426324	Vagococcus fluvialis strain 36B2 chromosome, complete genome	blastn	85653	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus fluvialis
11223306	11223306	PRJNA1101946_S_NODE_16329_length_199_cov_4.453333_g16230_i0	PRJNA1101946	16329	199	4.453333	8.86213267	Streptococcus	1301	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g16230	i0	100	100	199	0	100	0	1	199	1784415	1784217	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	19900	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
11689938	11689938	PRJNA1101946_S_NODE_10450_length_243_cov_5.783505_g10351_i0	PRJNA1101946	10450	243	5.783505	14.05391715	Candidatus Sarcina troglodytae	2726954	Bacteria	Bacteria	289	1.53e-73	NTclustered	gi\|1938574842\|gb\|CP051754.1\|	2726954	g10351	i0	88.333	47.9135802469136	240	28	99	0	1	240	2071170	2071409	Sarcina sp. JB2 chromosome, complete genome	blastn	11643	289	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Sarcina	Candidatus Sarcina troglodytae
11689978	11689978	PRJNA1101946_S_NODE_6030_length_294_cov_6.848980_g5931_i0	PRJNA1101946	6030	294	6.84898	20.1360012	Lacrimispora sphenoides	29370	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|1096105184\|emb\|LT630003.1\|	1297793	g5931	i0	100	491.819727891156	294	0	100	0	1	294	3647157	3647450	[Clostridium] sphenoides JCM 1415 strain ATCC 19403 genome assembly, chromosome: I	blastn	144595	544	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sphenoides
12498696	12498696	PRJNA1101946_S_NODE_16230_length_200_cov_0.940397_g16131_i0	PRJNA1101946	16230	200	0.940397	1.880794	Lacrimispora	2719231	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|1096105184\|emb\|LT630003.1\|	1297793	g16131	i0	99.5	425.985	200	1	100	0	1	200	3417492	3417691	[Clostridium] sphenoides JCM 1415 strain ATCC 19403 genome assembly, chromosome: I	blastn	85197	364	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sphenoides
12498722	12498722	PRJNA1101946_S_NODE_20710_length_177_cov_1.992188_g20611_i0	PRJNA1101946	20710	177	1.992188	3.52617276	Streptococcus	1301	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g20611	i0	99.435	100	177	1	100	0	1	177	1784065	1784241	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	17700	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
12965131	12965131	PRJNA1101946_S_NODE_6031_length_294_cov_6.812245_g5932_i0	PRJNA1101946	6031	294	6.812245	20.0280003	Hathewaya histolytica	1498	Bacteria	Bacteria	525	1.3399999999999995e-144	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g5932	i0	99.31	893.724489795918	290	2	99	0	5	294	10822	11111	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	262755	525	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
12965133	12965133	PRJNA1101946_S_NODE_6471_length_288_cov_2.987448_g6372_i0	PRJNA1101946	6471	288	2.987448	8.60385024	Anoxybacillus sp. FSL W8-1294	2954655	Bacteria	Bacteria	363	1.08e-95	NTclustered	gi\|2709517709\|gb\|CP150179.1\|	2954655	g6372	i0	92.248	3.52430555555556	258	17	90	1	31	288	2682883	2683137	Anoxybacillus sp. FSL W8-1294 chromosome, complete genome	blastn	1015	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus sp. FSL W8-1294
14240044	14240044	PRJNA1101946_S_NODE_23732_length_165_cov_5.275862_g23633_i0	PRJNA1101946	23732	165	5.275862	8.7051723	Lacrimispora sp. HJ-01	3375704	Bacteria	Bacteria	267	4.53e-67	NTclustered	gi\|2852291485\|gb\|CP173277.1\|	3375704	g23633	i0	95.758	2	165	7	100	0	1	165	2216471	2216307	Lacrimispora sp. HJ-01 chromosome, complete genome	blastn	330	267	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sp. HJ-01
15047609	15047609	PRJNA1101946_S_NODE_6172_length_292_cov_3.987654_g6073_i0	PRJNA1101946	6172	292	3.987654	11.64394968	Erysipelothrix	1647	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|3821804\|dbj\|AB019249.1\|	1648	g6073	i0	100	506.167808219178	292	0	100	0	1	292	2119	1828	Erysipelothrix rhusiopathiae genes for 16S rRNA, 23S rRNA, 5S rRNA, partial and complete sequences, strain:Pecs 56	blastn	147801	540	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix rhusiopathiae
16322350	16322350	PRJNA1101946_S_NODE_11253_length_236_cov_2.754011_g11154_i0	PRJNA1101946	11253	236	2.754011	6.49946596	Bacillaceae	186817	Bacteria	Bacteria	379	8.549999999999999e-101	NTclustered	gi\|2257773141\|gb\|CP085722.1\|	228899	g11154	i0	95.763	1117.53813559322	236	9	100	1	1	236	59792	60026	Peribacillus asahii strain KF4 plasmid unnamed2, complete sequence	blastn	263739	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus asahii
16322371	16322371	PRJNA1101946_S_NODE_1753_length_411_cov_5.864641_g1654_i0	PRJNA1101946	1753	411	5.864641	24.10367451	Brevibacillus	55080	Bacteria	Bacteria	616	1.1199999999999996e-171	NTclustered	gi\|2886835063\|gb\|CP176857.1\|	54910	g1654	i0	94.307	1127.05596107056	404	20	98	3	1	403	329634	330035	Brevibacillus centrosporus strain MPB16 plasmid unnamed, complete sequence	blastn	463220	621	0.99194847020934	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus centrosporus
16788386	16788386	PRJNA1101946_S_NODE_15814_length_202_cov_6.000000_g15715_i0	PRJNA1101946	15814	202	6	12.12	Staphylococcus epidermidis	1282	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2811870118\|gb\|CP170248.1\|	1282	g15715	i0	100	100	202	0	100	0	1	202	1177763	1177562	Staphylococcus epidermidis strain PS25 chromosome, complete genome	blastn	20200	374	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18062961	18062961	PRJNA1101946_S_NODE_4035_length_329_cov_5.117857_g3936_i0	PRJNA1101946	4035	329	5.117857	16.83774953	Niallia sp. RD1	2962858	Bacteria	Bacteria	592	1.4799999999999996e-164	NTclustered	gi\|2269758154\|gb\|CP100420.1\|	2962858	g3936	i0	99.088	1087.07902735562	329	3	100	0	1	329	1539336	1539008	Niallia sp. RD1 chromosome, complete genome	blastn	357649	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia sp. RD1
18062978	18062978	PRJNA1101946_S_NODE_6595_length_286_cov_3.607595_g6496_i0	PRJNA1101946	6595	286	3.607595	10.3177217	Lacrimispora sp. HJ-01	3375704	Bacteria	Bacteria	523	4.659999999999998e-144	NTclustered	gi\|2852291485\|gb\|CP173277.1\|	3375704	g6496	i0	99.65	466.199300699301	286	1	100	0	1	286	2715055	2715340	Lacrimispora sp. HJ-01 chromosome, complete genome	blastn	133333	523	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sp. HJ-01
18871476	18871476	PRJNA1101946_S_NODE_17975_length_190_cov_3.439716_g17876_i0	PRJNA1101946	17975	190	3.439716	6.5354604	Lysinibacillus	400634	Bacteria	Bacteria	309	8.77e-80	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g17876	i0	99.412	892.852631578947	170	1	89	0	21	190	12266	12435	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	169642	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus

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