metadata: contig_metadata: 31 rows where bioproject = "PRJNA407087", tax_kingdom = "Bacillati" and tax

31 rows where bioproject = "PRJNA407087", tax_kingdom = "Bacillati" 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
1081721	1081721	PRJNA407087_S_NODE_7521_length_177_cov_5.324324_g7058_i0	PRJNA407087	7521	177	5.324324	9.42405348	root	1	Root_unresolved	Root_unresolved	327	2.2199999999999996e-85	NTclustered	gi\|2301668455\|gb\|OP432291.1\|	29466	g7058	i0	100	100	177	0	100	0	1	177	879	703	Veillonella parvula strain Granada 16S ribosomal RNA gene, partial sequence	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
4909639	4909639	PRJNA407087_S_NODE_2204_length_438_cov_15.567237_g1744_i0	PRJNA407087	2204	438	15.567237	68.18449806	Streptococcus	1301	Bacteria	Bacteria	787	0	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g1744	i0	99.087	328.799086757991	438	4	100	0	1	438	17669	18106	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	144014	793	0.992433795712484	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
6792704	6792704	PRJNA407087_S_NODE_8166_length_168_cov_4.992806_g7703_i0	PRJNA407087	8166	168	4.992806	8.38791408	Gemella haemolysans	1379	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g7703	i0	99.405	356.916666666667	168	1	100	0	1	168	9597	9764	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	59962	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
11284952	11284952	PRJNA407087_S_NODE_7529_length_177_cov_3.891892_g7066_i0	PRJNA407087	7529	177	3.891892	6.88864884	root	1	Root_unresolved	Root_unresolved	327	2.2199999999999996e-85	NTclustered	gi\|285796811\|gb\|GU406793.1\|	29466	g7066	i0	100	100	177	0	100	0	1	177	193	17	Veillonella parvula clone GZ070 16S ribosomal RNA gene, partial sequence	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
13835171	13835171	PRJNA407087_S_NODE_7991_length_170_cov_102.446809_g7528_i0	PRJNA407087	7991	170	102.446809	174.1595753	Listeria	1637	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|2885371214\|gb\|PQ865990.1\|	1639	g7528	i0	99.412	200.017647058824	170	1	100	0	1	170	760	929	Listeria monocytogenes isolate Hass-Sheep isolate 2 16S ribosomal RNA gene, partial sequence	blastn	34003	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
15109407	15109407	PRJNA407087_S_NODE_5752_length_211_cov_36.829670_g5289_i0	PRJNA407087	5752	211	36.82967	77.7106037	Bacillati	1783272	Bacteria	Bacteria	368	1.6200000000000002e-97	NTclustered	gi\|1821213578\|gb\|CP043788.1\|	1282	g5289	i0	98.104	497.644549763033	211	4	100	0	1	211	1521660	1521870	Staphylococcus epidermidis strain SESURV_p2_0614 chromosome	blastn	105003	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17659226	17659226	PRJNA407087_S_NODE_9214_length_157_cov_3.265625_g8751_i0	PRJNA407087	9214	157	3.265625	5.12703125	Veillonella	29465	Bacteria	Bacteria	285	1.17e-72	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g8751	i0	99.363	494.821656050955	157	1	100	0	1	157	2053	1897	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	77687	285	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
20207835	20207835	PRJNA407087_S_NODE_1916_length_478_cov_34.730512_g1284_i1	PRJNA407087	1916	478	34.730512	166.01184736	Bacteria	2	Bacteria	Bacteria	833	0	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g1284	i1	98.117	462.949790794979	478	9	100	0	1	478	1128437	1128914	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	221290	833	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20816619	20816619	PRJNA407087_S_NODE_6757_length_190_cov_6.751553_g6294_i0	PRJNA407087	6757	190	6.751553	12.8279507	Gemella haemolysans	1379	Bacteria	Bacteria	302	1.47e-77	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g6294	i0	95.263	410.863157894737	190	9	100	0	1	190	10086	10275	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	78064	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
21483370	21483370	PRJNA407087_S_NODE_1717_length_508_cov_46.306889_g1284_i0	PRJNA407087	1717	508	46.306889	235.23899612	Bacteria	2	Bacteria	Bacteria	939	0	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g1284	i0	100	483.663385826772	508	0	100	0	1	508	1128914	1128407	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	245701	939	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
21483371	21483371	PRJNA407087_S_NODE_1837_length_491_cov_20.402597_g1398_i0	PRJNA407087	1837	491	20.402597	100.17675127	Streptococcus	1301	Bacteria	Bacteria	880	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1398	i0	98.982	345.075356415479	491	5	100	0	1	491	1571101	1571591	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	169432	885	0.994350282485876	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22758597	22758597	PRJNA407087_S_NODE_4418_length_258_cov_6.462882_g3955_i0	PRJNA407087	4418	258	6.462882	16.67423556	Staphylococcus	1279	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g3955	i0	100	99.7286821705426	258	0	100	0	1	258	2216266	2216009	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	25730	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
24641406	24641406	PRJNA407087_S_NODE_8200_length_168_cov_2.604317_g7737_i0	PRJNA407087	8200	168	2.604317	4.37525256	Solibacillus sp. FSL W8-0372	2921713	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2709615959\|gb\|CP150204.1\|	2921713	g7737	i0	100	0.166666666666667	28	0	17	0	90	117	873214	873187	Solibacillus sp. FSL W8-0372 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Solibacillus	Solibacillus sp. FSL W8-0372
24641414	24641414	PRJNA407087_S_NODE_9820_length_152_cov_1.878049_g9357_i0	PRJNA407087	9820	152	1.878049	2.85463448	Anaerocolumna sedimenticola	2696063	Bacteria	Bacteria	143	7.17e-30	NTclustered	gi\|1802166926\|gb\|CP048000.1\|	2696063	g9357	i0	86.822	422.907894736842	129	15	85	1	10	138	1199529	1199655	Anaerocolumna sedimenticola strain CBA3638 chromosome, complete genome	blastn	64282	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna sedimenticola
25307795	25307795	PRJNA407087_S_NODE_5560_length_216_cov_3.957219_g5097_i0	PRJNA407087	5560	216	3.957219	8.54759304	Veillonella	29465	Bacteria	Bacteria	385	1.65e-102	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g5097	i0	99.065	535.388888888889	214	2	99	0	3	216	886142	886355	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	115644	385	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
27313587	27313587	PRJNA407087_S_NODE_4443_length_257_cov_7.122807_g3980_i0	PRJNA407087	4443	257	7.122807	18.30561399	root	1	Root_unresolved	Root_unresolved	170	9.32e-53	NR	MDK0657390.1	1502	g3980	i0	98.8	79.3774319066148	85	1	99.2	0	3	257	27	111	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20400	171	0.994152046783626	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
27629415	27629415	PRJNA407087_S_NODE_5484_length_218_cov_4.735450_g5021_i0	PRJNA407087	5484	218	4.73545	10.323281	Peptostreptococcus	1257	Bacteria	Bacteria	92	5.45e-22	NR	WP_002845271.1	1257	g5021	i0	62	7.55504587155963	71	27	97.7	0	214	2	51	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	1647	92.8	0.991379310344828	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
28166055	28166055	PRJNA407087_S_NODE_1945_length_473_cov_9.945946_g1495_i0	PRJNA407087	1945	473	9.945946	47.04432458	Paenibacillaceae	186822	Bacteria	Bacteria	141	3.02e-40	NR	WP_239631023.1	185978	g1495	i0	61.2	7.3446088794926	116	45	73.6	0	410	63	1	116	WP_239631023.1 MULTISPECIES: group I truncated hemoglobin [unclassified Paenibacillus]	diamond	3474	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
28450335	28450335	PRJNA407087_S_NODE_9746_length_152_cov_4.186992_g9283_i0	PRJNA407087	9746	152	4.186992	6.36422784	root	1	Root_unresolved	Root_unresolved	48.1	1.33e-4	NR	WP_007545792.1	1069827	g9283	i0	42.6	5.58552631578947	47	27	92.8	0	152	12	22	68	WP_007545792.1 cation-translocating P-type ATPase, partial [Listeria fleischmannii]	diamond	849	48.5	0.991752577319588	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria fleischmannii
28906851	28906851	PRJNA407087_S_NODE_5768_length_211_cov_4.390110_g5305_i0	PRJNA407087	5768	211	4.39011	9.2631321	Listeria monocytogenes	1639	Bacteria	Bacteria	44.7	7.7e-4	NR	WP_333731483.1	1639	g5305	i0	35	0.853080568720379	60	39	85.3	0	32	211	13	72	WP_333731483.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	180	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28923620	28923620	PRJNA407087_S_NODE_9168_length_158_cov_1.581395_g8705_i0	PRJNA407087	9168	158	1.581395	2.4986041	FCB group	1783270	Bacteria	Bacteria	60.1	8.83e-9	NR	MBQ8925958.1	2044939	g8705	i0	49	15.0949367088608	51	26	96.8	0	4	156	463	513	MBQ8925958.1 alpha-glucosidase [Clostridia bacterium]	diamond	2385	60.1	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29239562	29239562	PRJNA407087_S_NODE_8769_length_161_cov_7.628788_g8306_i0	PRJNA407087	8769	161	7.628788	12.28234868	root	1	Root_unresolved	Root_unresolved	62.4	1.39e-9	NR	QHG77622.1	1280	g8306	i0	86.8	24.6894409937888	53	7	98.8	0	3	161	27	79	QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	3975	62.8	0.993630573248408	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29443591	29443591	PRJNA407087_S_NODE_6170_length_202_cov_2.843931_g5707_i0	PRJNA407087	6170	202	2.843931	5.74474062	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	96.3	3.0300000000000003e-21	NR	MBR5474511.1	1898203	g5707	i0	65.2	2.95544554455446	66	23	98	0	199	2	144	209	MBR5474511.1 alpha-glucosidase [Lachnospiraceae bacterium]	diamond	597	96.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30265327	30265327	PRJNA407087_S_NODE_9332_length_156_cov_2.472441_g8869_i0	PRJNA407087	9332	156	2.472441	3.85700796	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0014	NR	MBP5263707.1	1898203	g8869	i0	43.5	0.884615384615385	46	25	86.5	1	16	150	18	63	MBP5263707.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	138	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30360273	30360273	PRJNA407087_S_NODE_3092_length_346_cov_2.889590_g2629_i0	PRJNA407087	3092	346	2.88959	9.9979814	Lutispora saccharofermentans	3024236	Bacteria	Bacteria	44.3	0.0331	NR	WP_255227675.1	3024236	g2629	i0	32.3	0.858381502890173	99	58	78.9	4	21	293	181	278	WP_255227675.1 sensor histidine kinase [Lutispora saccharofermentans]	diamond	297	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lutisporales	Lutisporaceae	Lutispora	Lutispora saccharofermentans
30675612	30675612	PRJNA407087_S_NODE_933_length_747_cov_6.920613_g510_i1	PRJNA407087	933	747	6.920613	51.69697911	Bacilli bacterium	1903720	Bacteria	Bacteria	62	5e-7	NR	MBO6195346.1	1903720	g510	i1	28.2	0.855421686746988	213	147	83.5	3	31	654	228	439	MBO6195346.1 TMEM198/TM7SF3 family protein [Bacilli bacterium]	diamond	639	62	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31750447	31750447	PRJNA407087_S_NODE_5357_length_222_cov_2.518135_g4894_i0	PRJNA407087	5357	222	2.518135	5.5902597	Bacilli bacterium	1903720	Bacteria	Bacteria	86.7	9.53e-18	NR	MBP3799570.1	1903720	g4894	i0	58.1	6.10810810810811	74	28	100	2	222	1	57	127	MBP3799570.1 dynamin family protein [Bacilli bacterium]	diamond	1356	86.7	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31893803	31893803	PRJNA407087_S_NODE_9657_length_153_cov_2.911290_g9194_i0	PRJNA407087	9657	153	2.91129	4.4542737	Staphylococcus	1279	Bacteria	Bacteria	53.1	2.27e-6	NR	WP_002481138.1	1279	g9194	i0	48	15.1176470588235	50	25	98	1	151	2	572	620	WP_002481138.1 MULTISPECIES: valine--tRNA ligase [Staphylococcus]	diamond	2313	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus
32225256	32225256	PRJNA407087_S_NODE_2618_length_389_cov_36.750000_g2157_i0	PRJNA407087	2618	389	36.75	142.9575	Brevibacillus fulvus	1125967	Bacteria	Bacteria	144	8.87e-42	NR	WP_204516782.1	1125967	g2157	i0	61.9	2.62982005141388	113	43	87.1	0	51	389	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	1023	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
32305459	32305459	PRJNA407087_S_NODE_2259_length_430_cov_8.341646_g1798_i0	PRJNA407087	2259	430	8.341646	35.8690778	Peptostreptococcus	1257	Bacteria	Bacteria	124	1.04e-33	NR	WP_002845271.1	1257	g1798	i0	54.5	4.80697674418605	112	49	78.1	1	35	370	12	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	2067	124	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
32667535	32667535	PRJNA407087_S_NODE_4080_length_274_cov_3.522449_g3617_i0	PRJNA407087	4080	274	3.522449	9.65151026	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	118	3.8e-29	NR	MBR5569308.1	2485925	g3617	i0	60.4	6.97445255474453	91	36	99.6	0	274	2	184	274	MBR5569308.1 aldehyde dehydrogenase [Oscillospiraceae bacterium]	diamond	1911	118	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae 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);;