metadata: contig_metadata: 28 rows where bioproject = "PRJNA345071" and tax

28 rows where bioproject = "PRJNA345071" 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
393456	393456	PRJNA345071_P_NODE_6521_length_266_cov_1.616580_g6481_i0	PRJNA345071	6521	266	1.61658	4.3001028	Rossellomorea sp. y25	3118174	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2689064024\|gb\|CP145886.1\|	3118174	g6481	i0	100	0.105263157894737	28	0	11	0	100	127	643150	643177	Rossellomorea sp. y25 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea sp. y25
1070359	1070359	PRJNA345071_P_NODE_10421_length_243_cov_0.917647_g10381_i0	PRJNA345071	10421	243	0.917647	2.22988221	Bacillales	1385	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10381	i0	100	519.864197530864	243	0	100	0	1	243	748827	748585	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	126327	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5496933	5496933	PRJNA345071_P_NODE_2685_length_358_cov_2.908772_g2645_i0	PRJNA345071	2685	358	2.908772	10.41340376	Anaerococcus nagyae	1755241	Bacteria	Bacteria	610	4.46e-170	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g2645	i0	97.479	152.751396648045	357	9	99	0	1	357	121133	121489	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	54685	610	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
7448253	7448253	PRJNA345071_P_NODE_11086_length_234_cov_3.366460_g11046_i0	PRJNA345071	11086	234	3.36646	7.8775164	Lactobacillus	1578	Bacteria	Bacteria	431	2.3e-116	NTclustered	gi\|1721134184\|emb\|LR698986.1\|	1587	g11046	i0	100	417.388888888889	233	0	99	0	2	234	981333	981565	Lactobacillus helveticus isolate MGYG-HGUT-02384 genome assembly, chromosome: 1	blastn	97669	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus helveticus
7448282	7448282	PRJNA345071_P_NODE_9306_length_247_cov_0.896552_g9266_i0	PRJNA345071	9306	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	457	4.05e-124	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g9266	i0	100	171	247	0	100	0	1	247	1370	1124	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	42237	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9998546	9998546	PRJNA345071_P_NODE_11188_length_230_cov_2.955414_g11148_i0	PRJNA345071	11188	230	2.955414	6.7974522	Bacilli	91061	Bacteria	Bacteria	89	1.65e-18	NR	WP_067971948.1	1375	g11148	i0	68.8	11.2695652173913	64	20	83.5	0	228	37	12	75	WP_067971948.1 MULTISPECIES: pyruvate kinase [Aerococcus]	diamond	2592	89	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus
11273605	11273605	PRJNA345071_P_NODE_7629_length_253_cov_0.866667_g7589_i0	PRJNA345071	7629	253	0.866667	2.19266751	Lactiplantibacillus	2767842	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1611638273\|gb\|CP033616.1\|	1590	g7589	i0	100	100	253	0	100	0	1	253	146403	146655	Lactiplantibacillus plantarum strain J26 chromosome, complete genome	blastn	25300	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
16372931	16372931	PRJNA345071_P_NODE_10193_length_244_cov_0.912281_g10153_i0	PRJNA345071	10193	244	0.912281	2.22596564	Bacillati	1783272	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1663088249\|gb\|CP039160.1\|	1280	g10153	i0	100	53.9877049180328	244	0	100	0	1	244	2779085	2779328	Staphylococcus aureus strain Lr6 chromosome, complete genome	blastn	13173	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18244891	18244891	PRJNA345071_P_NODE_3275_length_335_cov_2.229008_g3235_i0	PRJNA345071	3275	335	2.229008	7.4671768	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	172	2.0299999999999998e-47	NR	MBC7076168.1	2093811	g3235	i0	80.2	19.8805970149254	111	22	99.4	0	2	334	545	655	MBC7076168.1 ATP-dependent chaperone ClpB [Syntrophomonadaceae bacterium]	diamond	6660	172	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
18244895	18244895	PRJNA345071_P_NODE_3455_length_329_cov_3.535156_g3415_i0	PRJNA345071	3455	329	3.535156	11.63066324	Anaerococcus nagyae	1755241	Bacteria	Bacteria	603	6.819999999999999e-168	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g3415	i0	100	318.127659574468	326	0	99	0	3	328	122210	121885	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	104664	603	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
18921871	18921871	PRJNA345071_P_NODE_8475_length_250_cov_0.881356_g8435_i0	PRJNA345071	8475	250	0.881356	2.20339	Anaerococcus	165779	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g8435	i0	99.6	604.6	250	1	100	0	1	250	123153	122904	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	151150	457	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
19519265	19519265	PRJNA345071_P_NODE_9596_length_246_cov_0.901734_g9556_i0	PRJNA345071	9596	246	0.901734	2.21826564	Candidatus Lachnocurva vaginae	699240	Bacteria	Bacteria	377	3.2300000000000003e-100	NTclustered	gi\|1820025701\|gb\|CP049781.1\|	699240	g9556	i0	94.65	0.98780487804878	243	13	99	0	3	245	588851	588609	MAG: Candidatus Lachnocurva vaginae isolate UAB071 chromosome, complete genome	blastn	243	377	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Lachnocurva	Candidatus Lachnocurva vaginae
20794756	20794756	PRJNA345071_P_NODE_4837_length_293_cov_2.031818_g4797_i0	PRJNA345071	4837	293	2.031818	5.95322674	Anaerococcus sp. WGS1596	3366806	Bacteria	Bacteria	492	1.35e-134	NTclustered	gi\|2831295055\|gb\|CP170995.1\|	3366806	g4797	i0	96.939	158.21843003413	294	8	100	1	1	293	481381	481674	Anaerococcus sp. WGS1596 chromosome, complete genome	blastn	46358	492	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
21472120	21472120	PRJNA345071_P_NODE_6857_length_262_cov_1.449735_g6817_i0	PRJNA345071	6857	262	1.449735	3.7983057	Streptococcus	1301	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g6817	i0	100	327	262	0	100	0	1	262	625483	625222	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	85674	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
21472121	21472121	PRJNA345071_P_NODE_7197_length_257_cov_3.201087_g7157_i0	PRJNA345071	7197	257	3.201087	8.22679359	Streptococcus	1301	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1686100227\|gb\|MK330575.1\|	28037	g7157	i0	100	323.906614785992	257	0	100	0	1	257	2041	1785	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	83244	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
23345169	23345169	PRJNA345071_P_NODE_10959_length_239_cov_3.987952_g10919_i0	PRJNA345071	10959	239	3.987952	9.53120528	Anaerococcus nagyae	1755241	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g10919	i0	97.071	593.983263598326	239	7	100	0	1	239	123671	123433	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	141962	403	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
24022186	24022186	PRJNA345071_P_NODE_8139_length_251_cov_0.876404_g8099_i0	PRJNA345071	8139	251	0.876404	2.19977404	Enterococcus	1350	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g8099	i0	100	100	251	0	100	0	1	251	1588216	1587966	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	25100	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
24619602	24619602	PRJNA345071_P_NODE_7660_length_253_cov_0.866667_g7620_i0	PRJNA345071	7660	253	0.866667	2.19266751	Finegoldia magna	1260	Bacteria	Bacteria	379	9.269999999999998e-101	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g7620	i0	93.676	3.02371541501976	253	16	100	0	1	253	935590	935842	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	765	379	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
27074736	27074736	PRJNA345071_P_NODE_642_length_631_cov_2.114695_g602_i0	PRJNA345071	642	631	2.114695	13.34372545	Bacillus cereus	1396	Bacteria	Bacteria	56.2	1.77e-6	NR	WP_098605782.1	1396	g602	i0	54.3	0.437400950871632	46	21	21.9	0	425	288	3	48	WP_098605782.1 lectin [Bacillus cereus]	diamond	276	56.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27895916	27895916	PRJNA345071_P_NODE_7865_length_252_cov_0.871508_g7825_i0	PRJNA345071	7865	252	0.871508	2.19620016	Clostridiales bacterium	1898207	Bacteria	Bacteria	57.4	2.9e-7	NR	PWL98330.1	1898207	g7825	i0	96.6	0.345238095238095	29	1	34.5	0	87	1	1	29	PWL98330.1 MAG: recombinase family protein [Clostridiales bacterium]	diamond	87	57.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27959141	27959141	PRJNA345071_P_NODE_2885_length_349_cov_1.978261_g2845_i0	PRJNA345071	2885	349	1.978261	6.90413089	Enterococcus faecalis	1351	Bacteria	Bacteria	106	1.84e-27	NR	WP_375855466.1	1351	g2845	i0	93.8	0.558739255014327	65	4	55.9	0	348	154	24	88	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	195	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
28401199	28401199	PRJNA345071_P_NODE_8446_length_250_cov_0.881356_g8406_i0	PRJNA345071	8446	250	0.881356	2.20339	Candidatus Stercoripulliclostridium merdigallinarum	2840951	Bacteria	Bacteria	64.7	7.65e-10	NR	HIU60157.1	2840951	g8406	i0	48.1	0.948	79	41	94.8	0	1	237	331	409	HIU60157.1 hypothetical protein [Candidatus Stercoripulliclostridium merdigallinarum]	diamond	237	64.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Candidatus Stercoripulliclostridium	Candidatus Stercoripulliclostridium merdigallinarum
28748484	28748484	PRJNA345071_P_NODE_3507_length_328_cov_1.090196_g3467_i0	PRJNA345071	3507	328	1.090196	3.57584288	Soehngenia saccharolytica	253256	Bacteria	Bacteria	102	8.18e-25	NR	TJX35225.1	253256	g3467	i0	54.1	0.896341463414634	98	38	83.2	1	54	326	31	128	TJX35225.1 J domain-containing protein [Soehngenia saccharolytica]	diamond	294	102	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Soehngenia	Soehngenia saccharolytica
29506205	29506205	PRJNA345071_P_NODE_5650_length_280_cov_1.386473_g5610_i0	PRJNA345071	5650	280	1.386473	3.8821244	Listeria monocytogenes	1639	Bacteria	Bacteria	112	8.43e-30	NR	MBH0213458.1	1639	g5610	i0	70.9	0.846428571428571	79	23	84.6	0	5	241	11	89	MBH0213458.1 hypothetical protein [Listeria monocytogenes]	diamond	237	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30534233	30534233	PRJNA345071_P_NODE_4273_length_305_cov_2.301724_g4233_i0	PRJNA345071	4273	305	2.301724	7.0202582	root	1	Root_unresolved	Root_unresolved	46.6	0.00301	NR	PKM89696.1	2013771	g4233	i0	35.2	7.94754098360656	91	36	89.5	4	31	303	189	256	PKM89696.1 MAG: glycoside hydrolase [Firmicutes bacterium HGW-Firmicutes-10]	diamond	2424	46.6	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium HGW-Firmicutes-10
31275404	31275404	PRJNA345071_P_NODE_10295_length_244_cov_0.888889_g10255_i0	PRJNA345071	10295	244	0.888889	2.16888916	Halobacillus rhizosphaerae	3064889	Bacteria	Bacteria	114	2.71e-27	NR	WP_411788268.1	3064889	g10255	i0	73.8	1.0327868852459	84	19	99.6	1	244	2	190	273	WP_411788268.1 hypothetical protein [Halobacillus rhizosphaerae]	diamond	252	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus rhizosphaerae
31465490	31465490	PRJNA345071_P_NODE_9196_length_247_cov_1.396552_g9156_i0	PRJNA345071	9196	247	1.396552	3.44948344	Listeria monocytogenes	1639	Bacteria	Bacteria	101	1.4e-25	NR	MBH0213458.1	1639	g9156	i0	92	0.607287449392713	50	4	60.7	0	247	98	65	114	MBH0213458.1 hypothetical protein [Listeria monocytogenes]	diamond	150	101	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
31545862	31545862	PRJNA345071_P_NODE_2396_length_374_cov_1.813953_g2356_i0	PRJNA345071	2396	374	1.813953	6.78418422	Bacteria	2	Bacteria	Bacteria	177	4.5399999999999986e-55	NR	MBH0219648.1	1639	g2356	i0	86.6	2.31818181818182	97	13	77.8	0	1	291	13	109	MBH0219648.1 DUF538 domain-containing protein [Listeria monocytogenes]	diamond	867	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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