metadata: contig_metadata: 26 rows where bioproject = "PRJNA222400", tax_phylum = "Bacillota" and tax

26 rows where bioproject = "PRJNA222400", 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
2331796	2331796	PRJNA222400_P_NODE_2122_length_343_cov_1.408163_g2089_i0	PRJNA222400	2122	343	1.408163	4.82999909	Streptococcus	1301	Bacteria	Bacteria	601	2.57e-167	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2089	i0	99.396	323.081632653061	331	2	97	0	1	331	1570737	1570407	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	110817	606	0.991749174917492	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3607025	3607025	PRJNA222400_P_NODE_5183_length_196_cov_1.544218_g5150_i0	PRJNA222400	5183	196	1.544218	3.02666728	Bacillus	1386	Bacteria	Bacteria	243	9.37e-60	NTclustered	gi\|2509182168\|gb\|CP106987.1\|	1396	g5150	i0	97.872	850.178571428571	141	2	71	1	57	196	1138027	1137887	Bacillus cereus strain IBA1 chromosome, complete genome	blastn	166635	243	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
8709219	8709219	PRJNA222400_P_NODE_1687_length_392_cov_1.253644_g1654_i0	PRJNA222400	1687	392	1.253644	4.91428448	Priestia	2800373	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2780461943\|gb\|CP162497.1\|	1404	g1654	i0	100	0.311224489795918	29	0	7	0	153	181	2411835	2411807	Priestia megaterium strain 10 chromosome, complete genome	blastn	122	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
8709230	8709230	PRJNA222400_P_NODE_3567_length_239_cov_3.505263_g3534_i0	PRJNA222400	3567	239	3.505263	8.37757857	Streptococcus	1301	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g3534	i0	100	318	239	0	100	0	1	239	18365	18127	Streptococcus oralis strain SOD chromosome, complete genome	blastn	76002	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9295295	9295295	PRJNA222400_P_NODE_6008_length_183_cov_1.552239_g5975_i0	PRJNA222400	6008	183	1.552239	2.84059737	Secundilactobacillus paracollinoides	240427	Bacteria	Bacteria	80.5	7.15e-11	NTclustered	gi\|1050781558\|gb\|CP014915.1\|	240427	g5975	i0	76.074	14.5956284153005	163	33	87	6	12	171	970733	970574	Secundilactobacillus paracollinoides strain TMW 1.1994 chromosome, complete genome	blastn	2671	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Secundilactobacillus	Secundilactobacillus paracollinoides
9295311	9295311	PRJNA222400_P_NODE_6988_length_170_cov_1.636364_g6955_i0	PRJNA222400	6988	170	1.636364	2.7818188	Dysosmobacter sp. Marseille-Q4140	2830675	Bacteria	Bacteria	75	3.03e-9	NTclustered	gi\|2031400201\|gb\|CP073694.1\|	2830675	g6955	i0	92.453	0.311764705882353	53	2	31	2	51	102	2353692	2353743	Dysosmobacter sp. Marseille-Q4140 chromosome	blastn	53	75	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Dysosmobacter	Dysosmobacter sp. Marseille-Q4140
9295312	9295312	PRJNA222400_P_NODE_7128_length_169_cov_1.300000_g7095_i0	PRJNA222400	7128	169	1.3	2.197	Lactobacillus iners	147802	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g7095	i0	100	490.544378698225	168	0	99	0	1	168	3359	3526	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	82902	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
16358943	16358943	PRJNA222400_P_NODE_7633_length_167_cov_1.677966_g7600_i0	PRJNA222400	7633	167	1.677966	2.80220322	Bacteria	2	Bacteria	Bacteria	217	4.69e-52	NTclustered	gi\|1147724948\|gb\|KY622910.1\|	1290	g7600	i0	99.174	103.245508982036	121	0	100	1	48	167	246	126	Staphylococcus hominis strain OA313 16S ribosomal RNA gene, partial sequence	blastn	17242	219	0.990867579908676	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
18218874	18218874	PRJNA222400_P_NODE_495_length_725_cov_3.152367_g466_i0	PRJNA222400	495	725	3.152367	22.85466075	Bacillus mycoides	1405	Bacteria	Bacteria	60.2	4.34e-4	NTclustered	gi\|2049754127\|gb\|CP036116.1\|	1405	g466	i0	100	0.437241379310345	32	0	4	0	578	609	74362	74393	Bacillus mycoides strain JAS481 plasmid p124	blastn	317	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
18218917	18218917	PRJNA222400_P_NODE_8635_length_164_cov_1.304348_g8602_i0	PRJNA222400	8635	164	1.304348	2.13913072	Ezakiella coagulans	46507	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g8602	i0	100	294.865853658537	164	0	100	0	1	164	160660	160497	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	48358	303	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
18218924	18218924	PRJNA222400_P_NODE_9535_length_156_cov_2.261682_g9502_i0	PRJNA222400	9535	156	2.261682	3.52822392	Lactobacillus iners	147802	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g9502	i0	100	560.019230769231	156	0	100	0	1	156	3002	2847	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	87363	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
27597416	27597416	PRJNA222400_P_NODE_8084_length_166_cov_0.888889_g8051_i0	PRJNA222400	8084	166	0.888889	1.47555574	PVC group	1783257	Bacteria	Bacteria	63.2	7.02e-10	NR	WP_129077981.1	1548597	g8051	i0	50.9	3.90361445783133	55	27	99.4	0	165	1	73	127	WP_129077981.1 6-bladed beta-propeller [Anaerobacillus alkaliphilus]	diamond	648	63.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Anaerobacillus	Anaerobacillus alkaliphilus
27944634	27944634	PRJNA222400_P_NODE_525_length_707_cov_1.655015_g496_i0	PRJNA222400	525	707	1.655015	11.70095605	Bacillati	1783272	Bacteria	Bacteria	163	1.3e-44	NR	WP_188647295.1	1571185	g496	i0	46	21.5516265912306	189	78	80.2	4	29	595	199	363	WP_188647295.1 4-hydroxyphenylpyruvate dioxygenase [Marinithermofilum abyssi]	diamond	15237	164	0.99390243902439	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Marinithermofilum	Marinithermofilum abyssi
28291726	28291726	PRJNA222400_P_NODE_4406_length_211_cov_1.925926_g4373_i0	PRJNA222400	4406	211	1.925926	4.06370386	Bacillales	1385	Bacteria	Bacteria	95.9	1.36e-23	NR	WP_056469398.1	1712029	g4373	i0	64.8	8.70142180094787	71	24	99.5	1	2	211	1	71	WP_056469398.1 group I truncated hemoglobin [Bacillus sp. FJAT-25509]	diamond	1836	96.3	0.995846313603323	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-25509
28653045	28653045	PRJNA222400_P_NODE_1967_length_360_cov_2.758842_g1934_i0	PRJNA222400	1967	360	2.758842	9.9318312	Blautia sp. MSK.2	1955243	Bacteria	Bacteria	43.1	0.0213	NR	WP_174088999.1	2709718	g1934	i0	33.7	0.766666666666667	92	59	75.8	2	84	356	11	101	WP_174088999.1 prealbumin-like fold domain-containing protein, partial [Blautia sp. MSK.20.85]	diamond	276	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia sp. MSK.20.85
28905358	28905358	PRJNA222400_P_NODE_2668_length_294_cov_2.000000_g2635_i0	PRJNA222400	2668	294	2	5.88	Bacillus weihaiensis	1547283	Bacteria	Bacteria	108	1.25e-26	NR	WP_083584509.1	1547283	g2635	i0	55.7	2.95918367346939	97	43	99	0	3	293	27	123	WP_083584509.1 nucleoside phosphorylase [Bacillus weihaiensis]	diamond	870	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus weihaiensis
28937285	28937285	PRJNA222400_P_NODE_5908_length_185_cov_1.088235_g5875_i0	PRJNA222400	5908	185	1.088235	2.01323475	Niameybacter massiliensis	1658108	Bacteria	Bacteria	56.2	2.97e-7	NR	WP_053984370.1	1658108	g5875	i0	51.9	4.32972972972973	52	25	84.3	0	158	3	329	380	WP_053984370.1 ABC transporter ATP-binding protein [Niameybacter massiliensis]	diamond	801	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Niameybacter	Niameybacter massiliensis
29221541	29221541	PRJNA222400_P_NODE_1929_length_364_cov_1.679365_g1896_i0	PRJNA222400	1929	364	1.679365	6.1128886	Priestia megaterium	1404	Bacteria	Bacteria	99.8	5.31e-23	NR	WP_114896361.1	1404	g1896	i0	44.7	0.93956043956044	114	59	94	2	19	360	2	111	WP_114896361.1 SDR family oxidoreductase [Priestia megaterium]	diamond	342	99.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
29333852	29333852	PRJNA222400_P_NODE_1089_length_495_cov_1.405830_g1056_i0	PRJNA222400	1089	495	1.40583	6.9588585	root	1	Root_unresolved	Root_unresolved	88.2	8.37e-20	NR	WP_369599335.1	1590	g1056	i0	90.7	51.8606060606061	43	4	26.1	0	495	367	17	59	WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	25671	89	0.991011235955056	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
29933957	29933957	PRJNA222400_P_NODE_1691_length_391_cov_1.666667_g1658_i0	PRJNA222400	1691	391	1.666667	6.51666797	PVC group	1783257	Bacteria	Bacteria	62.4	2.65e-8	NR	MBR5302381.1	2044939	g1658	i0	46.6	4.12020460358056	73	34	53.7	2	68	277	363	433	MBR5302381.1 cation-translocating P-type ATPase [Clostridia bacterium]	diamond	1611	62.8	0.993630573248408	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30249960	30249960	PRJNA222400_P_NODE_2932_length_276_cov_1.647577_g2899_i0	PRJNA222400	2932	276	1.647577	4.54731252	PVC group	1783257	Bacteria	Bacteria	51.2	2.66e-5	NR	WP_126810078.1	180344	g2899	i0	41.8	13.5760869565217	79	43	82.6	1	6	233	105	183	WP_126810078.1 ribosome recycling factor [Vagococcus elongatus]	diamond	3747	51.6	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus elongatus
30390363	30390363	PRJNA222400_P_NODE_1153_length_479_cov_2.290698_g1120_i0	PRJNA222400	1153	479	2.290698	10.97244342	Clostridia bacterium	2044939	Bacteria	Bacteria	54.3	3.5e-5	NR	MBQ8739326.1	2044939	g1120	i0	48.8	0.782881002087683	43	22	26.9	0	17	145	156	198	MBQ8739326.1 hypothetical protein [Clostridia bacterium]	diamond	375	54.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30800570	30800570	PRJNA222400_P_NODE_674_length_633_cov_2.642123_g644_i0	PRJNA222400	674	633	2.6421230000000002	16.72463859	Pontibacillus sp. HMF3514	2692425	Bacteria	Bacteria	147	2.35e-41	NR	WP_160098424.1	2692425	g644	i0	47.9	1.96208530805687	140	73	66.4	0	502	83	5	144	WP_160098424.1 OsmC family protein [Pontibacillus sp. HMF3514]	diamond	1242	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus sp. HMF3514
30895620	30895620	PRJNA222400_P_NODE_6374_length_178_cov_0.953488_g6341_i0	PRJNA222400	6374	178	0.953488	1.69720864	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	46.6	6.81e-4	NR	MBR2801936.1	2049044	g6341	i0	41.2	0.859550561797753	51	30	86	0	2	154	333	383	MBR2801936.1 glucosyltransferase [Erysipelotrichaceae bacterium]	diamond	153	46.6	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
31292367	31292367	PRJNA222400_P_NODE_7695_length_167_cov_1.169492_g7662_i0	PRJNA222400	7695	167	1.169492	1.95305164	PVC group	1783257	Bacteria	Bacteria	111	3.3e-27	NR	WP_093227905.1	46223	g7662	i0	92.7	78.0538922155689	55	4	98.8	0	3	167	99	153	WP_093227905.1 NADP-dependent isocitrate dehydrogenase [Thermoflavimicrobium dichotomicum]	diamond	13035	112	0.991071428571429	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Thermoflavimicrobium	Thermoflavimicrobium dichotomicum
32904203	32904203	PRJNA222400_P_NODE_2440_length_315_cov_1.139098_g2407_i0	PRJNA222400	2440	315	1.139098	3.5881587	Bacteria	2	Bacteria	Bacteria	136	1.85e-35	NR	WP_322158004.1	1406	g2407	i0	56.9	8.72380952380952	116	39	100	2	1	315	38	153	WP_322158004.1 GH39 family glycosyl hydrolase [Paenibacillus polymyxa]	diamond	2748	136	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa

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