metadata: contig_metadata: 30 rows where bioproject = "PRJNA1108487", tax_phylum = "Bacillota" and tax

30 rows where bioproject = "PRJNA1108487", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

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
7398379	7398379	PRJNA1108487_P_NODE_11506_length_234_cov_2.832298_g11440_i0	PRJNA1108487	11506	234	2.832298	6.62757732	Streptococcus	1301	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g11440	i0	100	305.735042735043	230	0	98	0	5	234	18481	18710	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	71542	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
8673801	8673801	PRJNA1108487_P_NODE_5367_length_306_cov_2.223176_g5301_i0	PRJNA1108487	5367	306	2.223176	6.80291856	Leuconostoc	1243	Bacteria	Bacteria	108	6.01e-19	NTclustered	gi\|2876072957\|gb\|PQ835541.1\|	33964	g5301	i0	86.735	30.1372549019608	98	12	32	1	190	287	839	935	Leuconostoc citreum strain TA107-6 16S ribosomal RNA gene, partial sequence	blastn	9222	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc citreum
9141011	9141011	PRJNA1108487_P_NODE_10748_length_244_cov_0.912281_g10682_i0	PRJNA1108487	10748	244	0.912281	2.22596564	Peptoniphilus harei	54005	Bacteria	Bacteria	339	1.51e-88	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g10682	i0	91.803	92.9754098360656	244	19	100	1	1	244	1597033	1596791	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	22686	339	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
9141018	9141018	PRJNA1108487_P_NODE_1368_length_570_cov_1.686117_g1303_i0	PRJNA1108487	1368	570	1.686117	9.6108669	Caproiciproducens sp. CPB-2	3030017	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|2663189403\|gb\|CP142860.1\|	3030017	g1303	i0	96.875	0.056140350877193	32	1	6	0	95	126	2282982	2282951	Caproiciproducens sp. CPB-2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae	Caproiciproducens	Caproiciproducens sp. CPB-2
10416884	10416884	PRJNA1108487_P_NODE_8609_length_252_cov_0.871508_g8543_i0	PRJNA1108487	8609	252	0.871508	2.19620016	Mesobacillus jeotgali	129985	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2324479551\|gb\|CP109811.1\|	129985	g8543	i0	100	0.119047619047619	30	0	12	0	113	142	2718346	2718375	Mesobacillus jeotgali strain SBJS01 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus jeotgali
12499422	12499422	PRJNA1108487_P_NODE_4650_length_324_cov_3.474104_g4584_i0	PRJNA1108487	4650	324	3.474104	11.25609696	Streptococcus	1301	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g4584	i0	100	322	324	0	100	0	1	324	1570711	1570388	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	104328	599	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15048287	15048287	PRJNA1108487_P_NODE_5712_length_298_cov_2.297778_g5646_i0	PRJNA1108487	5712	298	2.297778	6.84737844	Bacteria	2	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g5646	i0	100	475.580536912752	298	0	100	0	1	298	756	459	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	141723	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
17598251	17598251	PRJNA1108487_P_NODE_10794_length_244_cov_0.912281_g10728_i0	PRJNA1108487	10794	244	0.912281	2.22596564	Bacillus	1386	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2170494957\|dbj\|AP022874.1\|	1396	g10728	i0	96.875	3.9344262295082	32	1	13	0	22	53	2378771	2378802	Bacillus cereus MRY14-0057 DNA, complete genome	blastn	960	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
18872159	18872159	PRJNA1108487_P_NODE_5775_length_297_cov_1.294643_g5709_i0	PRJNA1108487	5775	297	1.294643	3.84508971	Streptococcus	1301	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|1943213388\|gb\|CP065706.1\|	1303	g5709	i0	99.663	316.902356902357	297	1	100	0	1	297	198564	198860	Streptococcus oralis strain FDAARGOS_886 chromosome, complete genome	blastn	94120	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
19339299	19339299	PRJNA1108487_P_NODE_5156_length_311_cov_1.613445_g5090_i0	PRJNA1108487	5156	311	1.613445	5.01781395	Pusillibacter faecalis	2714358	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2025056735\|dbj\|AP023420.1\|	2714358	g5090	i0	100	0.0932475884244373	29	0	9	0	68	96	150612	150584	Pusillimonas faecalis MM59 DNA, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pusillibacter	Pusillibacter faecalis
21422625	21422625	PRJNA1108487_P_NODE_437_length_949_cov_3.004566_g388_i0	PRJNA1108487	437	949	3.004566	28.51333134	Bacillati	1783272	Bacteria	Bacteria	84.2	3.4e-11	NTclustered	gi\|1967464082\|gb\|CP035727.2\|	257985	g388	i0	87.5	7.67860906217071	72	9	8	0	498	569	6034978	6034907	Bacillus thuringiensis serovar andalousiensis strain NRRL B-23139 chromosome	blastn	7287	84.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
21422626	21422626	PRJNA1108487_P_NODE_4797_length_320_cov_2.141700_g4731_i0	PRJNA1108487	4797	320	2.1417	6.85344	Staphylococcus	1279	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g4731	i0	100	461.05	320	0	100	0	1	320	708481	708162	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	147536	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21890268	21890268	PRJNA1108487_P_NODE_7858_length_260_cov_1.021390_g7792_i0	PRJNA1108487	7858	260	1.02139	2.655614	Bacillati	1783272	Bacteria	Bacteria	113	1.29e-30	NR	OPX91280.1	1811694	g7792	i0	70.7	5.28461538461538	75	22	86.5	0	260	36	7	81	OPX91280.1 MAG: ATP synthase subunit beta [Pelotomaculum sp. PtaB.Bin117]	diamond	1374	113	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfotomaculaceae	Pelotomaculum	Pelotomaculum sp. PtaB.Bin117
22697533	22697533	PRJNA1108487_P_NODE_10398_length_245_cov_0.906977_g10332_i0	PRJNA1108487	10398	245	0.906977	2.22209365	Anaerococcus	165779	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g10332	i0	98.776	407.261224489796	245	3	100	0	1	245	180522	180766	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	99779	436	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
22697536	22697536	PRJNA1108487_P_NODE_1738_length_510_cov_2.318078_g1672_i0	PRJNA1108487	1738	510	2.318078	11.8221978	Bacteria	2	Bacteria	Bacteria	259	4.72e-81	NR	WP_069800110.1	1883407	g1672	i0	77.6	20.5058823529412	161	35	94.7	1	5	487	145	304	WP_069800110.1 malate synthase A [Tepidibacillus sp. HK-1]	diamond	10458	259	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Tepidibacillus	Tepidibacillus sp. HK-1
26805803	26805803	PRJNA1108487_P_NODE_7661_length_262_cov_2.201058_g7595_i0	PRJNA1108487	7661	262	2.201058	5.76677196	Paenibacillaceae	186822	Bacteria	Bacteria	109	8.4e-29	NR	WP_204516782.1	1125967	g7595	i0	68.5	5.90839694656489	73	23	83.6	0	40	258	2	74	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	1548	110	0.990909090909091	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
26909561	26909561	PRJNA1108487_P_NODE_10682_length_244_cov_0.912281_g10616_i0	PRJNA1108487	10682	244	0.912281	2.22596564	Brevibacillus sp. HB1.3	2738842	Bacteria	Bacteria	45.1	0.00541	NR	WP_172142141.1	2738842	g10616	i0	35.5	1.88114754098361	76	41	83.6	1	242	39	49	124	WP_172142141.1 RCC1 domain-containing protein [Brevibacillus sp. HB1.3]	diamond	459	45.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. HB1.3
27194034	27194034	PRJNA1108487_P_NODE_1622_length_527_cov_1.030837_g1556_i0	PRJNA1108487	1622	527	1.030837	5.43251099	Paenibacillus mendelii	206163	Bacteria	Bacteria	74.7	1.15e-12	NR	WP_204821101.1	206163	g1556	i0	41.1	0.734345351043643	129	48	73.4	3	394	8	8	108	WP_204821101.1 NAD(P)H-binding protein [Paenibacillus mendelii]	diamond	387	74.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus mendelii
27880274	27880274	PRJNA1108487_P_NODE_8205_length_254_cov_1.309392_g8139_i0	PRJNA1108487	8205	254	1.309392	3.32585568	Tepidibacillus	1494427	Bacteria	Bacteria	42.7	0.0416	NR	PZN12808.1	1879010	g8139	i0	26.8	1.57086614173228	71	49	83.9	1	237	25	21	88	PZN12808.1 MAG: 6-phospho-beta-glucosidase [Bacillota bacterium]	diamond	399	43.1	0.990719257540603	Bacteria	Bacillati	Bacillota					Bacillota bacterium
28543563	28543563	PRJNA1108487_P_NODE_4087_length_343_cov_1.155556_g4021_i0	PRJNA1108487	4087	343	1.155556	3.96355708	Bacillati	1783272	Bacteria	Bacteria	132	1.7999999999999998e-35	NR	WP_307338314.1	353224	g4021	i0	57	2.88629737609329	107	46	93.6	0	21	341	67	173	WP_307338314.1 phytanoyl-CoA dioxygenase family protein [Caldalkalibacillus uzonensis]	diamond	990	132	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldalkalibacillus	Caldalkalibacillus uzonensis
28615281	28615281	PRJNA1108487_P_NODE_8907_length_251_cov_0.876404_g8841_i0	PRJNA1108487	8907	251	0.876404	2.19977404	Clostridia bacterium	2044939	Bacteria	Bacteria	77.8	1.84e-14	NR	MBQ1995221.1	2044939	g8841	i0	54	3.02390438247012	63	29	75.3	0	250	62	95	157	MBQ1995221.1 beta-galactosidase [Clostridia bacterium]	diamond	759	77.8	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28994373	28994373	PRJNA1108487_P_NODE_7068_length_272_cov_1.185930_g7002_i0	PRJNA1108487	7068	272	1.18593	3.2257296	Clostridium perfringens	1502	Bacteria	Bacteria	44.3	0.0144	NR	MDU7069709.1	1502	g7002	i0	32.4	0.783088235294118	71	45	78.3	1	269	57	32	99	MDU7069709.1 hypothetical protein [Clostridium perfringens]	diamond	213	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
29341488	29341488	PRJNA1108487_P_NODE_4949_length_316_cov_1.925926_g4883_i0	PRJNA1108487	4949	316	1.925926	6.08592616	Bacilli bacterium	1903720	Bacteria	Bacteria	130	4.65e-33	NR	MBP3799570.1	1903720	g4883	i0	60	0.996835443037975	105	39	99.7	2	316	2	58	159	MBP3799570.1 dynamin family protein [Bacilli bacterium]	diamond	315	130	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
29783371	29783371	PRJNA1108487_P_NODE_2611_length_420_cov_1.342939_g2545_i0	PRJNA1108487	2611	420	1.342939	5.6403438	Eubacteriales bacterium	2831996	Bacteria	Bacteria	165	1.4200000000000001e-44	NR	MDO4266391.1	2831996	g2545	i0	55.4	4.95	139	61	99.3	1	418	2	175	312	MDO4266391.1 glutamine synthetase III [Eubacteriales bacterium]	diamond	2079	165	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
30384087	30384087	PRJNA1108487_P_NODE_11273_length_242_cov_0.923077_g11207_i0	PRJNA1108487	11273	242	0.923077	2.23384634	Gracilibacillus alcaliphilus	1401441	Bacteria	Bacteria	47.4	8.29e-4	NR	WP_204670683.1	1401441	g11207	i0	40.5	1.95867768595041	79	25	97.9	2	4	240	127	183	WP_204670683.1 GTP-binding protein [Gracilibacillus alcaliphilus]	diamond	474	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus alcaliphilus
30478566	30478566	PRJNA1108487_P_NODE_5073_length_313_cov_1.300000_g5007_i0	PRJNA1108487	5073	313	1.3	4.069	Brevibacillus brevis	1393	Bacteria	Bacteria	42	0.023	NR	WP_354142440.1	1393	g5007	i0	31.8	0.63258785942492	66	42	63.3	1	307	110	8	70	WP_354142440.1 stalk domain-containing protein [Brevibacillus brevis]	diamond	198	42	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus brevis
30921004	30921004	PRJNA1108487_P_NODE_5634_length_300_cov_1.039648_g5568_i0	PRJNA1108487	5634	300	1.039648	3.118944	Marinisporobacter sp.	2018664	Bacteria	Bacteria	44.3	0.0211	NR	MCT4604912.1	2018664	g5568	i0	25.9	0.81	81	58	79	1	10	246	16	96	MCT4604912.1 diguanylate cyclase [Marinisporobacter sp.]	diamond	243	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Thermotaleaceae	Marinisporobacter	Marinisporobacter sp.
31837582	31837582	PRJNA1108487_P_NODE_6257_length_287_cov_1.448598_g6191_i0	PRJNA1108487	6257	287	1.448598	4.15747626	Clostridium sp.	1506	Bacteria	Bacteria	44.7	0.0114	NR	MCM1111114.1	1506	g6191	i0	72.4	0.303135888501742	29	8	30.3	0	199	113	109	137	MCM1111114.1 hypothetical protein [Clostridium sp.]	diamond	87	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
31869306	31869306	PRJNA1108487_P_NODE_4297_length_336_cov_0.889734_g4231_i0	PRJNA1108487	4297	336	0.889734	2.98950624	Paenibacillus agaridevorans	171404	Bacteria	Bacteria	99	2.08e-21	NR	WP_108994029.1	171404	g4231	i0	38.7	1.0625	119	65	99.1	1	335	3	144	262	WP_108994029.1 AAA family ATPase [Paenibacillus agaridevorans]	diamond	357	99	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus agaridevorans
32628285	32628285	PRJNA1108487_P_NODE_6100_length_290_cov_1.359447_g6034_i0	PRJNA1108487	6100	290	1.359447	3.9423963	Ruminococcus sp.	41978	Bacteria	Bacteria	47.8	0.0011	NR	MBQ7999854.1	41978	g6034	i0	38.2	1.27241379310345	55	34	56.9	0	235	71	288	342	MBQ7999854.1 HAMP domain-containing histidine kinase [Ruminococcus sp.]	diamond	369	47.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.

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