metadata: contig_metadata: 35 rows where bioproject = "PRJNA934332" and tax

35 rows where bioproject = "PRJNA934332" 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
2185938	2185938	PRJNA934332_P_NODE_2922_length_371_cov_1.033557_g2835_i0	PRJNA934332	2922	371	1.033557	3.83449647	Bacillus	1386	Bacteria	Bacteria	252	1.6100000000000002e-79	NR	WP_003184257.1	1386	g2835	i0	100	2.98382749326146	123	0	99.5	0	2	370	314	436	WP_003184257.1 MULTISPECIES: L-arabinose isomerase [Bacillus]	diamond	1107	252	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
2186010	2186010	PRJNA934332_P_NODE_9242_length_246_cov_1.780347_g9155_i0	PRJNA934332	9242	246	1.780347	4.37965362	Fastidiosipila sanguinis	236753	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1359121252\|gb\|CP027226.1\|	236753	g9155	i0	100	1	246	0	100	0	1	246	1564237	1564482	Fastidiosipila sanguinis strain CCUG 47711 chromosome, complete genome	blastn	246	455	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Fastidiosipila	Fastidiosipila sanguinis
2531095	2531095	PRJNA934332_P_NODE_3922_length_330_cov_1.089494_g3835_i0	PRJNA934332	3922	330	1.089494	3.5953302	Bacillati	1783272	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g3835	i0	100	433.057575757576	330	0	100	0	1	330	1219158	1219487	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	142909	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
3461465	3461465	PRJNA934332_P_NODE_10363_length_243_cov_1.358824_g10276_i0	PRJNA934332	10363	243	1.358824	3.30194232	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	182	2.68e-41	NTclustered	gi\|2621705955\|emb\|OY764017.1\|	2054177	g10276	i0	81.223	81.9382716049383	229	39	93	4	1	227	46896	46670	MAG: Christensenellaceae bacterium isolate da863df8-3121-48c8-a9fd-195775925dd7 genome assembly, chromosome: 1	blastn	19911	182	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
3807462	3807462	PRJNA934332_P_NODE_6463_length_269_cov_1.571429_g6376_i0	PRJNA934332	6463	269	1.571429	4.22714401	Enterococcus	1350	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g6376	i0	100	100	269	0	100	0	1	269	2044434	2044702	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	26900	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
3807466	3807466	PRJNA934332_P_NODE_7423_length_252_cov_0.860335_g7336_i0	PRJNA934332	7423	252	0.860335	2.1680442	Bacillaceae	186817	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1839114216\|gb\|MT437014.1\|	1409	g7336	i0	100	144.035714285714	252	0	100	0	1	252	281	30	Bacillus sp. (in: Bacteria) strain P12-35 16S ribosomal RNA gene, partial sequence	blastn	36297	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
5083752	5083752	PRJNA934332_P_NODE_4164_length_321_cov_2.016129_g4077_i0	PRJNA934332	4164	321	2.016129	6.47177409	Bacillales	1385	Bacteria	Bacteria	593	3.9899999999999986e-165	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g4077	i0	100	109.990654205607	321	0	100	0	1	321	116	436	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	35307	593	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6359457	6359457	PRJNA934332_P_NODE_2645_length_385_cov_1.365385_g2558_i0	PRJNA934332	2645	385	1.365385	5.25673225	Streptococcus	1301	Bacteria	Bacteria	706	0	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g2558	i0	99.74	345.005194805195	385	1	100	0	1	385	424406	424022	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	132827	712	0.991573033707865	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
6359473	6359473	PRJNA934332_P_NODE_7565_length_251_cov_0.865169_g7478_i0	PRJNA934332	7565	251	0.865169	2.17157419	Anoxybacillus	150247	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g7478	i0	99.203	2.99601593625498	251	2	100	0	1	251	1880634	1880384	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	752	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
6359479	6359479	PRJNA934332_P_NODE_9925_length_245_cov_0.895349_g9838_i0	PRJNA934332	9925	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g9838	i0	100	100	245	0	100	0	1	245	2376309	2376065	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24500	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8563587	8563587	PRJNA934332_P_NODE_5767_length_281_cov_1.384615_g5680_i0	PRJNA934332	5767	281	1.384615	3.89076815	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|2446175570\|gb\|CP117963.1\|	853	g5680	i0	100	19.3024911032028	281	0	100	0	1	281	2604072	2604352	Faecalibacterium prausnitzii strain AP34BHI chromosome, complete genome	blastn	5424	520	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
8908221	8908221	PRJNA934332_P_NODE_6967_length_260_cov_1.454545_g6880_i0	PRJNA934332	6967	260	1.454545	3.781817	Carnobacterium	2747	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g6880	i0	100	5.66923076923077	260	0	100	0	1	260	707390	707131	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1474	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
8908226	8908226	PRJNA934332_P_NODE_7687_length_251_cov_0.865169_g7600_i0	PRJNA934332	7687	251	0.865169	2.17157419	Carnobacterium	2747	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g7600	i0	99.203	4	251	2	100	0	1	251	2779113	2779363	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1004	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
11459187	11459187	PRJNA934332_P_NODE_3829_length_333_cov_1.776923_g3742_i0	PRJNA934332	3829	333	1.776923	5.91715359	Paenibacillus	44249	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g3742	i0	100	1109.4984984985	333	0	100	0	1	333	15737	15405	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	369463	616	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
11459195	11459195	PRJNA934332_P_NODE_6269_length_272_cov_2.829146_g6182_i0	PRJNA934332	6269	272	2.829146	7.69527712	Listeria	1637	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|2514039015\|gb\|CP096154.1\|	1639	g6182	i0	100	101.018382352941	272	0	100	0	1	272	1961957	1962228	Listeria monocytogenes strain FSL F2-0695 chromosome, complete genome	blastn	27477	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
12734865	12734865	PRJNA934332_P_NODE_9990_length_244_cov_2.432749_g9903_i0	PRJNA934332	9990	244	2.432749	5.93590756	Paenibacillus	44249	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g9903	i0	100	1115.23360655738	244	0	100	0	1	244	14685	14928	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	272117	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
13664181	13664181	PRJNA934332_P_NODE_11351_length_241_cov_0.916667_g11264_i0	PRJNA934332	11351	241	0.916667	2.20916747	Staphylococcus epidermidis	1282	Bacteria	Bacteria	438	1.4299999999999999e-118	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g11264	i0	99.585	100	241	0	100	1	1	241	682114	681875	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	24100	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13664257	13664257	PRJNA934332_P_NODE_9391_length_246_cov_0.890173_g9304_i0	PRJNA934332	9391	246	0.890173	2.18982558	Clostridia bacterium	2044939	Bacteria	Bacteria	125	3.49e-32	NR	MBP3800546.1	2044939	g9304	i0	73.8	0.975609756097561	80	21	97.6	0	244	5	267	346	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	240	125	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
16557966	16557966	PRJNA934332_P_NODE_9853_length_245_cov_0.895349_g9766_i0	PRJNA934332	9853	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|9623890\|gb\|AF269987.1\|AF269987	1282	g9766	i0	99.592	100	245	1	100	0	1	245	1304	1060	Staphylococcus epidermidis strain SR1 clone step.1038g08 genomic sequence	blastn	24500	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18762330	18762330	PRJNA934332_P_NODE_9055_length_247_cov_0.885057_g8968_i0	PRJNA934332	9055	247	0.885057	2.18609079	Streptococcus sp. Marseille-Q3533	2759692	Bacteria	Bacteria	416	6.869999999999999e-112	NTclustered	gi\|2237347942\|emb\|OW724079.1\|	2759692	g8968	i0	97.154	6.95951417004049	246	7	99	0	1	246	866902	867147	Streptococcus sp. Marseille-Q3533 genome assembly, chromosome: contig00001	blastn	1719	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q3533
20381721	20381721	PRJNA934332_P_NODE_10956_length_242_cov_0.911243_g10869_i0	PRJNA934332	10956	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1982319721\|gb\|CP052971.1\|	1282	g10869	i0	100	100	242	0	100	0	1	242	200069	200310	Staphylococcus epidermidis strain HD33-1 chromosome, complete genome	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20381758	20381758	PRJNA934332_P_NODE_9676_length_245_cov_0.895349_g9589_i0	PRJNA934332	9676	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g9589	i0	99.592	101	245	1	100	0	1	245	1765069	1765313	Staphylococcus epidermidis strain 9 chromosome	blastn	24745	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22587582	22587582	PRJNA934332_P_NODE_3038_length_364_cov_2.013746_g2951_i0	PRJNA934332	3038	364	2.013746	7.33003544	Bacillus	1386	Bacteria	Bacteria	258	7.94e-82	NR	WP_003184257.1	1386	g2951	i0	100	4.94505494505495	120	0	98.9	0	362	3	1	120	WP_003184257.1 MULTISPECIES: L-arabinose isomerase [Bacillus]	diamond	1800	258	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
22933243	22933243	PRJNA934332_P_NODE_11018_length_242_cov_0.911243_g10931_i0	PRJNA934332	11018	242	0.911243	2.20520806	Enterococcus	1350	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1963838897\|emb\|LR962850.1\|	1351	g10931	i0	99.587	100	242	1	100	0	1	242	3078397	3078638	Enterococcus faecalis isolate 27688_1#342 genome assembly, chromosome: 1	blastn	24200	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
22933256	22933256	PRJNA934332_P_NODE_6678_length_266_cov_0.797927_g6591_i0	PRJNA934332	6678	266	0.797927	2.12248582	Bacteria	2	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g6591	i0	97.744	434.018796992481	266	6	100	0	1	266	596	861	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	115449	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
22933267	22933267	PRJNA934332_P_NODE_9258_length_246_cov_1.468208_g9171_i0	PRJNA934332	9258	246	1.468208	3.61179168	Carnobacterium	2747	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g9171	i0	99.405	4.41869918699187	168	1	100	0	79	246	25582	25415	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1087	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
23863015	23863015	PRJNA934332_P_NODE_9439_length_246_cov_0.890173_g9352_i0	PRJNA934332	9439	246	0.890173	2.18982558	Staphylococcus epidermidis	1282	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2716021442\|gb\|CP114450.1\|	1282	g9352	i0	100	100	246	0	100	0	1	246	235612	235367	Staphylococcus epidermidis strain SE 4.8 chromosome, complete genome	blastn	24600	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25481992	25481992	PRJNA934332_P_NODE_2960_length_369_cov_0.966216_g2873_i0	PRJNA934332	2960	369	0.966216	3.56533704	Weissella	46255	Bacteria	Bacteria	676	0	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g2873	i0	99.73	613.970189701897	370	0	100	1	1	369	20767	20398	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	226555	676	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
27948070	27948070	PRJNA934332_P_NODE_6325_length_272_cov_0.854271_g6238_i0	PRJNA934332	6325	272	0.854271	2.32361712	root	1	Root_unresolved	Root_unresolved	53.5	8.49e-6	NR	MEE0515234.1	1926557	g6238	i0	30.9	4.01470588235294	97	60	99.3	2	3	272	75	171	MEE0515234.1 VWA domain-containing protein [Emergencia sp.]	diamond	1092	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Emergencia	Emergencia sp.
28761803	28761803	PRJNA934332_P_NODE_5327_length_289_cov_1.143519_g5240_i0	PRJNA934332	5327	289	1.143519	3.30476991	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0276	NR	GFH95442.1	1898203	g5240	i0	31.3	0.695501730103806	67	42	65.4	1	71	259	68	134	GFH95442.1 hypothetical protein IMSAGC003_01986 [Lachnospiraceae bacterium]	diamond	201	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30189899	30189899	PRJNA934332_P_NODE_9012_length_247_cov_0.885057_g8925_i0	PRJNA934332	9012	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	44.7	0.0071	NR	WP_227277591.1	45462	g8925	i0	57.1	2.5748987854251	35	15	42.5	0	4	108	143	177	WP_227277591.1 ankyrin repeat domain-containing protein [Brevibacillus borstelensis]	diamond	636	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus borstelensis
31295882	31295882	PRJNA934332_P_NODE_11255_length_241_cov_0.916667_g11168_i0	PRJNA934332	11255	241	0.916667	2.20916747	Clostridia	186801	Bacteria	Bacteria	138	9.8e-38	NR	KGF09745.1	1230734	g11168	i0	95.7	1.74273858921162	70	3	87.1	0	3	212	276	345	KGF09745.1 hypothetical protein HMPREF1635_02425 [Clostridiales bacterium S5-A14a]	diamond	420	138	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Clostridiales bacterium S5-A14a
31352221	31352221	PRJNA934332_P_NODE_7236_length_255_cov_1.692308_g7149_i0	PRJNA934332	7236	255	1.692308	4.3153854	Bacillota bacterium	1879010	Bacteria	Bacteria	47.8	2.74e-4	NR	MCE1246774.1	1879010	g7149	i0	47.9	0.564705882352941	48	24	56.5	1	191	48	44	90	MCE1246774.1 OsmC family protein [Bacillota bacterium]	diamond	144	47.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
32333200	32333200	PRJNA934332_P_NODE_11039_length_242_cov_0.881657_g10952_i0	PRJNA934332	11039	242	0.881657	2.13360994	Streptococcus pneumoniae	1313	Bacteria	Bacteria	67	2.02e-12	NR	WP_196301241.1	1313	g10952	i0	59.3	2.03305785123967	54	22	66.9	0	214	53	33	86	WP_196301241.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	492	67	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
32333202	32333202	PRJNA934332_P_NODE_2759_length_379_cov_1.915033_g2672_i0	PRJNA934332	2759	379	1.915033	7.25797507	Clostridia bacterium	2044939	Bacteria	Bacteria	105	4.89e-24	NR	MBP3800462.1	2044939	g2672	i0	39.8	1.0131926121372	128	74	98.9	1	376	2	213	340	MBP3800462.1 hypothetical protein [Clostridia bacterium]	diamond	384	105	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium

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