metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJNA554794" and tax

34 rows where analysis = "blastn", bioproject = "PRJNA554794" 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
520918	520918	PRJNA554794_P_NODE_25301_length_152_cov_2.747573_g21372_i0	PRJNA554794	25301	152	2.747573	4.17631096	Bacillus chungangensis	587633	Bacteria	Bacteria	268	1.13e-67	NTclustered	gi\|930174153\|gb\|KR997575.1\|	587633	g21372	i0	98.675	109.664473684211	151	2	99	0	1	151	1068	1218	Bacillus chungangensis strain DCRUST BT FtS-5 16S ribosomal RNA gene, partial sequence	blastn	16669	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus chungangensis
1123483	1123483	PRJNA554794_P_NODE_20201_length_198_cov_1.107383_g16272_i0	PRJNA554794	20201	198	1.107383	2.19261834	Bacillati	1783272	Bacteria	Bacteria	361	2.51e-95	NTclustered	gi\|470488168\|ref\|NR_076854.1\|	1579	g16272	i0	99.495	418.676767676768	198	1	100	0	1	198	2641	2838	Lactobacillus acidophilus strain 30SC 23S ribosomal RNA gene, complete sequence	blastn	82898	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus
1123555	1123555	PRJNA554794_P_NODE_22641_length_167_cov_0.864407_g18712_i0	PRJNA554794	22641	167	0.864407	1.44355969	Staphylococcus	1279	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g18712	i0	100	44.2455089820359	167	0	100	0	1	167	1725236	1725402	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	7389	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
2398777	2398777	PRJNA554794_P_NODE_12842_length_263_cov_0.906542_g8913_i0	PRJNA554794	12842	263	0.906542	2.38420546	Streptococcus	1301	Bacteria	Bacteria	383	7.499999999999999e-102	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g8913	i0	93.774	335.566539923954	257	12	97	4	9	263	1571305	1571559	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	88254	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
2398987	2398987	PRJNA554794_P_NODE_23682_length_164_cov_0.869565_g19753_i0	PRJNA554794	23682	164	0.869565	1.4260866	Bacillales	1385	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2432632113\|gb\|OP378667.1\|	1280	g19753	i0	100	100	164	0	100	0	1	164	14720	14557	Staphylococcus aureus strain MRSA10075 plasmid pMRSA10075_2, complete sequence	blastn	16400	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
3674685	3674685	PRJNA554794_P_NODE_12963_length_259_cov_1.433333_g9034_i0	PRJNA554794	12963	259	1.433333	3.71233247	Staphylococcus	1279	Bacteria	Bacteria	440	4.309999999999998e-119	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g9034	i0	97.297	562.799227799228	259	7	100	0	1	259	1130656	1130914	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	145765	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
3674877	3674877	PRJNA554794_P_NODE_22923_length_166_cov_0.871795_g18994_i0	PRJNA554794	22923	166	0.871795	1.4471797	Staphylococcus	1279	Bacteria	Bacteria	219	1.3e-52	NTclustered	gi\|2780418090\|gb\|CP162632.1\|	2282419	g18994	i0	90.361	16.433734939759	166	16	100	0	1	166	263829	263664	Staphylococcus pseudoxylosus strain Hao 2022 chromosome, complete genome	blastn	2728	219	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudoxylosus
3674894	3674894	PRJNA554794_P_NODE_24243_length_162_cov_0.902655_g20314_i0	PRJNA554794	24243	162	0.902655	1.4623011	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g20314	i0	100	26.5	162	0	100	0	1	162	93333	93494	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	4293	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
4348049	4348049	PRJNA554794_P_NODE_24264_length_162_cov_0.902655_g20335_i0	PRJNA554794	24264	162	0.902655	1.4623011	Staphylococcus warneri	1292	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g20335	i0	100	79.0061728395062	162	0	100	0	1	162	1997482	1997643	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	12799	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
4951528	4951528	PRJNA554794_P_NODE_13124_length_254_cov_1.653659_g9195_i0	PRJNA554794	13124	254	1.653659	4.20029386	Lactobacillus	1578	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g9195	i0	100	431.05905511811	254	0	100	0	1	254	90425	90678	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	109489	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
6227240	6227240	PRJNA554794_P_NODE_24145_length_162_cov_0.955752_g20216_i0	PRJNA554794	24145	162	0.955752	1.54831824	root	1	Root_unresolved	Root_unresolved	300	4.36e-77	NTclustered	gi\|1663095690\|gb\|CP039164.1\|	1280	g20216	i0	100	2	162	0	100	0	1	162	2821414	2821575	Staphylococcus aureus strain R46 chromosome, complete genome	blastn	324	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6898849	6898849	PRJNA554794_P_NODE_24186_length_162_cov_0.902655_g20257_i0	PRJNA554794	24186	162	0.902655	1.4623011	Jeotgalicoccus sp. ATCC 8456	946435	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g20257	i0	100	1.69135802469136	162	0	100	0	1	162	8772	8611	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	274	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
8173683	8173683	PRJNA554794_P_NODE_20507_length_193_cov_1.138889_g16578_i0	PRJNA554794	20507	193	1.138889	2.19805577	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	67.6	5.94e-7	NTclustered	gi\|2814788368\|emb\|OY764195.2\|	3030912	g16578	i0	100	0.186528497409326	36	0	19	0	96	131	2271763	2271798	MAG: Anaerovoracaceae bacterium isolate cdaadf04-e2f3-4fd8-80f9-b39a06479d73 genome assembly, chromosome: 1	blastn	36	67.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
8776488	8776488	PRJNA554794_P_NODE_23187_length_165_cov_0.879310_g19258_i0	PRJNA554794	23187	165	0.87931	1.4508615	Staphylococcus	1279	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g19258	i0	100	22.9818181818182	165	0	100	0	1	165	2428496	2428332	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	3792	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
8776495	8776495	PRJNA554794_P_NODE_23487_length_164_cov_0.886957_g19558_i0	PRJNA554794	23487	164	0.886957	1.45460948	Staphylococcus	1279	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g19558	i0	100	100	164	0	100	0	1	164	928538	928375	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	16400	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10051986	10051986	PRJNA554794_P_NODE_23208_length_165_cov_0.879310_g19279_i0	PRJNA554794	23208	165	0.87931	1.4508615	Staphylococcus	1279	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1143273938\|gb\|CP019597.1\|	29382	g19279	i0	100	4	165	0	100	0	1	165	883456	883292	Staphylococcus cohnii strain SNUDS-2 chromosome, complete genome	blastn	660	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
10051988	10051988	PRJNA554794_P_NODE_23248_length_165_cov_0.870690_g19319_i0	PRJNA554794	23248	165	0.87069	1.4366385	Enterococcus	1350	Bacteria	Bacteria	259	7.57e-65	NTclustered	gi\|2647032458\|gb\|CP141640.1\|	37734	g19319	i0	100	18.5575757575758	140	0	85	0	26	165	865695	865556	Enterococcus casseliflavus strain Dec0527 chromosome, complete genome	blastn	3062	259	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
10052002	10052002	PRJNA554794_P_NODE_24128_length_162_cov_1.247788_g20199_i0	PRJNA554794	24128	162	1.247788	2.02141656	Lactobacillus	1578	Bacteria	Bacteria	298	1.57e-76	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g20199	i0	100	415.395061728395	161	0	99	0	1	161	90758	90918	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	67294	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
10052281	10052281	PRJNA554794_P_NODE_7888_length_582_cov_1.474672_g4297_i0	PRJNA554794	7888	582	1.474672	8.58259104	Staphylococcus	1279	Bacteria	Bacteria	568	4.62e-157	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g4297	i0	96.176	513.659793814433	340	10	100	1	243	582	784288	784624	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	298950	568	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
11326459	11326459	PRJNA554794_P_NODE_12969_length_259_cov_0.895238_g9040_i0	PRJNA554794	12969	259	0.895238	2.31866642	Bacillati	1783272	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g9040	i0	98.842	115.687258687259	259	3	100	0	1	259	440	698	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	29963	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
11326564	11326564	PRJNA554794_P_NODE_19849_length_204_cov_1.412903_g15920_i0	PRJNA554794	19849	204	1.412903	2.88232212	Lactobacillus	1578	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g15920	i0	100	463.049019607843	204	0	100	0	1	204	91715	91512	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	94462	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11326581	11326581	PRJNA554794_P_NODE_20389_length_195_cov_1.095890_g16460_i0	PRJNA554794	20389	195	1.09589	2.1369855	Bacillales	1385	Bacteria	Bacteria	254	4.3e-63	NTclustered	gi\|1699462837\|gb\|CP035485.1\|	2502791	g16460	i0	90.625	587.497435897436	192	17	98	1	4	195	2051283	2051473	Salicibibacter halophilus strain NKC3-5 chromosome, complete genome	blastn	114562	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salicibibacter	Salicibibacter halophilus
11326657	11326657	PRJNA554794_P_NODE_23229_length_165_cov_0.879310_g19300_i0	PRJNA554794	23229	165	0.87931	1.4508615	Clostridia	186801	Bacteria	Bacteria	281	1.62e-71	NTclustered	gi\|295114602\|emb\|FP929060.1\|	245012	g19300	i0	98.137	465.418181818182	161	3	98	0	1	161	2424	2584	Clostridiales sp. SM4/1 draft genome	blastn	76794	283	0.992932862190813	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			butyrate-producing bacterium SM4/1
11999854	11999854	PRJNA554794_P_NODE_20210_length_198_cov_0.771812_g16281_i0	PRJNA554794	20210	198	0.771812	1.52818776	Kroppenstedtia eburnea	714067	Bacteria	Bacteria	268	1.5699999999999998e-67	NTclustered	gi\|1848988486\|gb\|CP048103.1\|	714067	g16281	i0	91.414	761.333333333333	198	13	99	4	3	198	3066805	3066610	Kroppenstedtia eburnea strain DSM 45196 chromosome, complete genome	blastn	150744	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Kroppenstedtia	Kroppenstedtia eburnea
15151640	15151640	PRJNA554794_P_NODE_24692_length_161_cov_0.901786_g20763_i0	PRJNA554794	24692	161	0.901786	1.45187546	Staphylococcus	1279	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1982319721\|gb\|CP052971.1\|	1282	g20763	i0	100	100	161	0	100	0	1	161	2268467	2268307	Staphylococcus epidermidis strain HD33-1 chromosome, complete genome	blastn	16100	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15823695	15823695	PRJNA554794_P_NODE_22653_length_167_cov_0.864407_g18724_i0	PRJNA554794	22653	167	0.864407	1.44355969	Staphylococcus epidermidis	1282	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g18724	i0	100	100	167	0	100	0	1	167	2153733	2153567	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	16700	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15823701	15823701	PRJNA554794_P_NODE_23153_length_165_cov_0.879310_g19224_i0	PRJNA554794	23153	165	0.87931	1.4508615	Staphylococcus aureus	1280	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g19224	i0	100	100	165	0	100	0	1	165	594749	594913	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	16500	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15823706	15823706	PRJNA554794_P_NODE_23793_length_163_cov_0.894737_g19864_i0	PRJNA554794	23793	163	0.894737	1.45842131	Staphylococcus epidermidis	1282	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2505659350\|gb\|CP118842.1\|	1282	g19864	i0	100	100	163	0	100	0	1	163	264744	264906	Staphylococcus epidermidis strain 7049 chromosome, complete genome	blastn	16300	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17098471	17098471	PRJNA554794_P_NODE_12314_length_279_cov_1.500000_g8385_i0	PRJNA554794	12314	279	1.5	4.185	Weissella confusa	1583	Bacteria	Bacteria	438	1.6899999999999996e-118	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g8385	i0	98.016	516.94623655914	252	5	90	0	28	279	20578	20327	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	144228	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
17701493	17701493	PRJNA554794_P_NODE_22534_length_167_cov_3.432203_g18605_i0	PRJNA554794	22534	167	3.432203	5.73177901	Bacilli	91061	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g18605	i0	100	119	167	0	100	0	1	167	972329	972163	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	19873	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18372669	18372669	PRJNA554794_P_NODE_20255_length_197_cov_1.108108_g16326_i0	PRJNA554794	20255	197	1.108108	2.18297276	Bulleidia sp. 10714-15	3241172	Bacteria	Bacteria	75	3.64e-9	NTclustered	gi\|2793725965\|dbj\|AP036017.1\|	3241172	g16326	i0	83.333	7.47208121827411	84	10	41	4	117	197	140452	140370	Bulleidia sp. 10714-15 DNA, complete genome	blastn	1472	75	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Bulleidia	Bulleidia sp. 10714-15
18974944	18974944	PRJNA554794_P_NODE_24055_length_163_cov_0.868421_g20126_i0	PRJNA554794	24055	163	0.868421	1.41552623	Staphylococcus	1279	Bacteria	Bacteria	281	1.59e-71	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g20126	i0	98.137	98.7730061349693	161	3	99	0	3	163	519977	519817	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16100	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20250070	20250070	PRJNA554794_P_NODE_24516_length_161_cov_1.232143_g20587_i0	PRJNA554794	24516	161	1.232143	1.98375023	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|2094528003\|gb\|OK103944.1\|	1305	g20587	i0	100	100	161	0	100	0	1	161	451	611	Streptococcus sanguinis strain Baghdad.cov.4 16S ribosomal RNA gene, partial sequence	blastn	16100	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
21525625	21525625	PRJNA554794_P_NODE_24677_length_161_cov_0.901786_g20748_i0	PRJNA554794	24677	161	0.901786	1.45187546	Staphylococcus	1279	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g20748	i0	100	98.3167701863354	161	0	100	0	1	161	1517677	1517517	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	15829	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis

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