metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1073005" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1073005" 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
1015959	1015959	PRJNA1073005_P_NODE_8661_length_260_cov_1.235294_g8542_i0	PRJNA1073005	8661	260	1.235294	3.2117644	Siminovitchia	2837510	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2710008362\|gb\|CP150282.1\|	2921432	g8542	i0	100	34.1923076923077	260	0	100	0	1	260	2703737	2703478	Siminovitchia sp. FSL H7-0308 chromosome, complete genome	blastn	8890	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL H7-0308
1461564	1461564	PRJNA1073005_P_NODE_9422_length_248_cov_0.880000_g9303_i0	PRJNA1073005	9422	248	0.88	2.1824	Siminovitchia sp. FSL H7-0308	2921432	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2710008362\|gb\|CP150282.1\|	2921432	g9303	i0	99.194	2	248	2	100	0	1	248	722530	722777	Siminovitchia sp. FSL H7-0308 chromosome, complete genome	blastn	496	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL H7-0308
6119172	6119172	PRJNA1073005_P_NODE_9645_length_246_cov_0.890173_g9526_i0	PRJNA1073005	9645	246	0.890173	2.18982558	Tissierellales	1737405	Bacteria	Bacteria	228	3.4399999999999986e-55	NTclustered	gi\|1124780165\|emb\|LT669839.1\|	1288971	g9526	i0	83.333	2.90650406504065	246	41	100	0	1	246	414207	413962	[Clostridium] ultunense Esp isolate Clostridium ultunense strain Esp genome assembly, chromosome: chrI	blastn	715	228	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tepidimicrobiaceae	Schnuerera	Schnuerera ultunensis
6564953	6564953	PRJNA1073005_P_NODE_8926_length_251_cov_1.297753_g8807_i0	PRJNA1073005	8926	251	1.297753	3.25736003	Globicatella sp. PHS-GS-PNBC-21-1553	2885764	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2620023749\|gb\|CP085470.1\|	2885764	g8807	i0	99.602	1.98804780876494	251	1	100	0	1	251	581131	580881	Globicatella sp. PHS-GS-PNBC-21-1553 chromosome, complete genome	blastn	499	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Globicatella	Globicatella sp. PHS-GS-PNBC-21-1553
7393552	7393552	PRJNA1073005_P_NODE_10206_length_242_cov_0.911243_g10087_i0	PRJNA1073005	10206	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g10087	i0	99.587	52.0082644628099	242	1	100	0	1	242	1120335	1120094	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	12586	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
7393725	7393725	PRJNA1073005_P_NODE_7566_length_300_cov_0.748899_g7447_i0	PRJNA1073005	7566	300	0.748899	2.246697	Bacillaceae	186817	Bacteria	Bacteria	532	8.18e-147	NTclustered	gi\|1893059056\|gb\|CP060137.1\|	2760090	g7447	i0	98.667	1171.84666666667	300	4	100	0	1	300	916011	915712	Bacillus sp. PAMC26568 chromosome, complete genome	blastn	351554	532	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. PAMC26568
10390270	10390270	PRJNA1073005_P_NODE_6229_length_360_cov_1.073171_g6110_i0	PRJNA1073005	6229	360	1.073171	3.8634156	Neobacillus sp. SuZ13	3047875	Bacteria	Bacteria	255	2.42e-63	NTclustered	gi\|2511415156\|gb\|CP126107.1\|	3047875	g6110	i0	81.056	8.14722222222222	322	59	89	2	40	360	2386659	2386339	Neobacillus sp. SuZ13 chromosome, complete genome	blastn	2933	255	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. SuZ13
10390282	10390282	PRJNA1073005_P_NODE_8909_length_251_cov_1.837079_g8790_i0	PRJNA1073005	8909	251	1.837079	4.61106829	Lactobacillus iners	147802	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g8790	i0	99.209	517.322709163347	253	0	100	1	1	251	3366	3618	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	129848	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
11219456	11219456	PRJNA1073005_P_NODE_9329_length_248_cov_1.508571_g9210_i0	PRJNA1073005	9329	248	1.508571	3.74125608	Clostridia	186801	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|166852915\|gb\|CP000923.1\|	399726	g9210	i0	100	12	248	0	100	0	1	248	1297803	1298050	Thermoanaerobacter sp. X514, complete genome	blastn	2976	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacter	Thermoanaerobacter sp. X514
12494852	12494852	PRJNA1073005_P_NODE_8930_length_251_cov_1.297753_g8811_i0	PRJNA1073005	8930	251	1.297753	3.25736003	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2313047233\|gb\|CP094726.1\|	1282	g8811	i0	100	516.597609561753	251	0	100	0	1	251	2353100	2352850	Staphylococcus epidermidis strain IVB6256 chromosome, complete genome	blastn	129666	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12494855	12494855	PRJNA1073005_P_NODE_9290_length_249_cov_0.875000_g9171_i0	PRJNA1073005	9290	249	0.875	2.17875	Siminovitchia	2837510	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2710008362\|gb\|CP150282.1\|	2921432	g9171	i0	100	2	249	0	100	0	1	249	3437305	3437057	Siminovitchia sp. FSL H7-0308 chromosome, complete genome	blastn	498	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL H7-0308
12940741	12940741	PRJNA1073005_P_NODE_9431_length_248_cov_0.880000_g9312_i0	PRJNA1073005	9431	248	0.88	2.1824	Lysinibacillus sp. FSL K6-0075	2921415	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|2723297826\|gb\|CP151947.1\|	2921415	g9312	i0	82.819	0.915322580645161	227	39	92	0	1	227	2839009	2839235	Lysinibacillus sp. FSL K6-0075 chromosome, complete genome	blastn	227	204	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. FSL K6-0075
13769346	13769346	PRJNA1073005_P_NODE_8871_length_253_cov_0.933333_g8752_i0	PRJNA1073005	8871	253	0.933333	2.36133249	Staphylococcus	1279	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g8752	i0	98.419	493.150197628458	253	4	100	0	1	253	776373	776625	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	124767	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
14215666	14215666	PRJNA1073005_P_NODE_7792_length_290_cov_1.046083_g7673_i0	PRJNA1073005	7792	290	1.046083	3.0336407	Paenibacillus sp. 19GGS1-52	2758563	Bacteria	Bacteria	512	1.02e-140	NTclustered	gi\|2198385953\|gb\|CP059724.1\|	2758563	g7673	i0	98.955	972.279310344828	287	1	99	2	1	286	158161	157876	Paenibacillus sp. 19GGS1-52 chromosome	blastn	281961	512	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 19GGS1-52
14215676	14215676	PRJNA1073005_P_NODE_8852_length_253_cov_1.550000_g8733_i0	PRJNA1073005	8852	253	1.55	3.9215	Streptococcus oralis	1303	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g8733	i0	98.024	100	253	5	100	0	1	253	1663428	1663176	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	25300	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15043479	15043479	PRJNA1073005_P_NODE_10192_length_242_cov_0.911243_g10073_i0	PRJNA1073005	10192	242	0.911243	2.20520806	Kurthia	1649	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|982216470\|gb\|CP013217.1\|	1750719	g10073	i0	98.76	3	242	3	100	0	1	242	751606	751847	Kurthia sp. 11kri321 chromosome, complete genome	blastn	726	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Kurthia	Kurthia sp. 11kri321
15489619	15489619	PRJNA1073005_P_NODE_7653_length_296_cov_0.901345_g7534_i0	PRJNA1073005	7653	296	0.901345	2.6679812	Clostridium bornimense	1216932	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|584454940\|emb\|HG917868.1\|	1216932	g7534	i0	100	11.9628378378378	296	0	100	0	1	296	759193	758898	Clostridium bornimense replicon M2/40_rep1, complete genome, type strain M2/40T	blastn	3541	547	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium bornimense
16763911	16763911	PRJNA1073005_P_NODE_9954_length_244_cov_0.900585_g9835_i0	PRJNA1073005	9954	244	0.900585	2.1974274	Siminovitchia sp. FSL W7-1587	2954699	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2709485242\|gb\|CP150169.1\|	2954699	g9835	i0	100	2	244	0	100	0	1	244	951855	951612	Siminovitchia sp. FSL W7-1587 chromosome, complete genome	blastn	488	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL W7-1587
19312664	19312664	PRJNA1073005_P_NODE_7836_length_288_cov_1.200000_g7717_i0	PRJNA1073005	7836	288	1.2	3.456	Siminovitchia sp. FSL W7-1587	2954699	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|2709485242\|gb\|CP150169.1\|	2954699	g7717	i0	99.653	2.09027777777778	288	1	100	0	1	288	321413	321700	Siminovitchia sp. FSL W7-1587 chromosome, complete genome	blastn	602	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL W7-1587
20142414	20142414	PRJNA1073005_P_NODE_9216_length_249_cov_0.875000_g9097_i0	PRJNA1073005	9216	249	0.875	2.17875	Bacillaceae	186817	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|1229099743\|gb\|CP017703.1\|	33936	g9097	i0	93.574	20.8755020080321	249	16	100	0	1	249	1433009	1432761	Aeribacillus pallidus strain KCTC3564 chromosome, complete genome	blastn	5198	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aeribacillus	Aeribacillus pallidus
20588044	20588044	PRJNA1073005_P_NODE_7737_length_292_cov_1.319635_g7618_i0	PRJNA1073005	7737	292	1.319635	3.8533342	Aerococcus urinaeequi	51665	Bacteria	Bacteria	414	2.9999999999999993e-111	NTclustered	gi\|1919119126\|gb\|CP063065.1\|	51665	g7618	i0	99.559	391.547945205479	227	1	78	0	1	227	253595	253369	Aerococcus urinaeequi strain T43 chromosome, complete genome	blastn	114332	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus urinaeequi
21417937	21417937	PRJNA1073005_P_NODE_2417_length_710_cov_2.324961_g2305_i0	PRJNA1073005	2417	710	2.324961	16.5072231	Streptococcus	1301	Bacteria	Bacteria	1267	0	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g2305	i0	98.875	575.140845070423	711	7	100	1	1	710	18230	17520	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	408350	1267	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
21863847	21863847	PRJNA1073005_P_NODE_9078_length_250_cov_0.870056_g8959_i0	PRJNA1073005	9078	250	0.870056	2.17514	Parageobacillus sp. KH3-4	2916802	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|2199623895\|dbj\|AP025627.1\|	2916802	g8959	i0	93.227	10.492	251	15	99	2	1	249	2958579	2958829	Parageobacillus sp. KH3-4 DNA, complete genome	blastn	2623	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Parageobacillus	Parageobacillus sp. KH3-4
22692902	22692902	PRJNA1073005_P_NODE_6198_length_361_cov_5.868056_g6079_i0	PRJNA1073005	6198	361	5.868056	21.18368216	root	1	Root_unresolved	Root_unresolved	614	3.479999999999999e-171	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g6079	i0	97.493	99.4570637119114	359	9	99	0	3	361	4002653	4002295	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	35904	617	0.995137763371151	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
25242301	25242301	PRJNA1073005_P_NODE_9540_length_247_cov_0.885057_g9421_i0	PRJNA1073005	9540	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	401	1.9199999999999992e-107	NTclustered	gi\|2046783536\|gb\|CP075685.1\|	1496	g9421	i0	95.951	12.1093117408907	247	10	100	0	1	247	466263	466509	Clostridioides difficile strain MT5121 chromosome, complete genome	blastn	2991	401	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
25242305	25242305	PRJNA1073005_P_NODE_9920_length_244_cov_0.900585_g9801_i0	PRJNA1073005	9920	244	0.900585	2.1974274	Siminovitchia	2837510	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2710008362\|gb\|CP150282.1\|	2921432	g9801	i0	99.59	26.266393442623	244	1	100	0	1	244	1514913	1514670	Siminovitchia sp. FSL H7-0308 chromosome, complete genome	blastn	6409	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Siminovitchia	Siminovitchia sp. FSL H7-0308

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