metadata: contig_metadata: 33 rows where bioproject = "PRJNA229468" and tax

33 rows where bioproject = "PRJNA229468" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1056633	1056633	PRJNA229468_S_NODE_961_length_173_cov_1.233871_g948_i0	PRJNA229468	961	173	1.233871	2.13459683	Rothia	32207	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g948	i0	100	291.132947976879	173	0	100	0	1	173	652615	652443	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	50366	320	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
4884545	4884545	PRJNA229468_S_NODE_644_length_203_cov_0.948052_g631_i0	PRJNA229468	644	203	0.948052	1.92454556	Micrococcales	85006	Bacteria	Bacteria	326	9.44e-85	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g631	i0	95.567	360.162561576355	203	9	100	0	1	203	652910	653112	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	73113	326	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8020686	8020686	PRJNA229468_S_NODE_1007_length_170_cov_1.264463_g994_i0	PRJNA229468	1007	170	1.264463	2.1495871	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	300	4.6e-77	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g994	i0	98.256	276.317647058824	172	1	100	1	1	170	552297	552468	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	46974	300	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
8020687	8020687	PRJNA229468_S_NODE_287_length_292_cov_1.263374_g274_i0	PRJNA229468	287	292	1.263374	3.68905208	Arthrobacter dokdonellae	2211210	Bacteria	Bacteria	510	3.71e-140	NTclustered	gi\|1409665507\|gb\|CP029642.1\|	2211210	g274	i0	98.282	458.366438356164	291	5	99	0	2	292	551070	550780	Arthrobacter dokdonellae, complete genome	blastn	133843	510	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter dokdonellae
11259789	11259789	PRJNA229468_S_NODE_1149_length_164_cov_1.208696_g1136_i0	PRJNA229468	1149	164	1.208696	1.98226144	Corynebacterium	1716	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|2212856580\|gb\|CP051667.1\|	37637	g1136	i0	96.933	323.018292682927	163	3	100	2	4	164	1103762	1103600	Corynebacterium pseudodiphtheriticum strain 10700 chromosome	blastn	52975	272	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum
11259790	11259790	PRJNA229468_S_NODE_1169_length_163_cov_2.421053_g1156_i0	PRJNA229468	1169	163	2.421053	3.94631639	Paenibacillus	44249	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1240338366\|gb\|MF872593.1\|	58172	g1156	i0	100	226	163	0	100	0	1	163	1342	1180	Paenibacillus sp. strain 16H1F15 16S ribosomal RNA gene, partial sequence	blastn	36838	302	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp.
11259793	11259793	PRJNA229468_S_NODE_449_length_234_cov_1.578378_g436_i0	PRJNA229468	449	234	1.578378	3.69340452	Paenibacillus	44249	Bacteria	Bacteria	431	2.3e-116	NTclustered	gi\|686561105\|gb\|CP009428.1\|	189426	g436	i0	100	965.32905982906	233	0	99	0	1	233	14719	14951	Paenibacillus odorifer strain DSM 15391, complete genome	blastn	225887	431	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus odorifer
13809992	13809992	PRJNA229468_S_NODE_1231_length_162_cov_0.902655_g1218_i0	PRJNA229468	1231	162	0.902655	1.4623011	Bacillales	1385	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2264387772\|gb\|CP015553.1\|	1281	g1218	i0	99.383	486.006172839506	162	1	100	0	1	162	124482	124321	Staphylococcus carnosus strain TMW 2.1596 chromosome, complete genome	blastn	78733	294	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus carnosus
13809994	13809994	PRJNA229468_S_NODE_611_length_207_cov_0.955696_g598_i0	PRJNA229468	611	207	0.955696	1.97829072	Modestobacter	88138	Bacteria	Bacteria	363	7.369999999999998e-96	NTclustered	gi\|470491309\|ref\|NR_077032.1\|	477641	g598	i0	99.01	379.289855072464	202	2	98	0	1	202	1018	817	Modestobacter marinus strain BC501 23S ribosomal RNA, complete sequence	blastn	78513	363	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter marinus
15670093	15670093	PRJNA229468_S_NODE_713_length_195_cov_1.527397_g700_i0	PRJNA229468	713	195	1.527397	2.97842415	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	333	5.369999999999999e-87	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g700	i0	97.436	614.671794871795	195	5	100	0	1	195	5033557	5033751	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	119861	333	1	Bacteria		Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
16944567	16944567	PRJNA229468_S_NODE_174_length_361_cov_1.634615_g161_i0	PRJNA229468	174	361	1.634615	5.90096015	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	592	1.6299999999999996e-164	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g161	i0	96.143	543.487534626039	363	12	100	2	1	361	5032293	5032655	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	196199	592	1	Bacteria		Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17634185	17634185	PRJNA229468_S_NODE_434_length_238_cov_1.068783_g421_i0	PRJNA229468	434	238	1.068783	2.54370354	root	1	Root_unresolved	Root_unresolved	125	4.95e-35	NR	MBO8831362.1	1280	g421	i0	69.6	91.6008403361345	79	24	99.6	0	238	2	22	100	MBO8831362.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	21801	125	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
17634189	17634189	PRJNA229468_S_NODE_834_length_182_cov_1.646617_g821_i0	PRJNA229468	834	182	1.646617	2.99684294	Arthrobacter	1663	Bacteria	Bacteria	320	3.84e-83	NTclustered	gi\|2921126289\|gb\|CP102608.1\|	619291	g821	i0	98.352	428.796703296703	182	3	100	0	1	182	459346	459165	Arthrobacter sp. N1 chromosome, complete genome	blastn	78041	320	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. N1
19493238	19493238	PRJNA229468_S_NODE_1016_length_169_cov_2.775000_g1003_i0	PRJNA229468	1016	169	2.775	4.68975	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	252	1.3e-62	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1003	i0	93.529	700.585798816568	170	10	100	1	1	169	5031878	5032047	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	118399	252	1	Bacteria		Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21458301	21458301	PRJNA229468_S_NODE_357_length_265_cov_2.222222_g344_i0	PRJNA229468	357	265	2.222222	5.8888883	Cutibacterium	1912216	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g344	i0	100	268.256603773585	265	0	100	0	1	265	56512	56248	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	71088	490	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22043870	22043870	PRJNA229468_S_NODE_598_length_209_cov_2.018750_g585_i0	PRJNA229468	598	209	2.01875	4.2191875	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	287	4.61e-73	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g585	i0	91.429	405.832535885167	210	16	100	2	1	209	5033288	5033496	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	84819	287	1	Bacteria		Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
22733344	22733344	PRJNA229468_S_NODE_38_length_727_cov_4.001475_g32_i0	PRJNA229468	38	727	4.001475	29.09072325	Cutibacterium	1912216	Bacteria	Bacteria	1343	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g32	i0	100	282.95598349381	727	0	100	0	1	727	56164	55438	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	205709	1343	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23319334	23319334	PRJNA229468_S_NODE_1139_length_165_cov_0.775862_g1126_i0	PRJNA229468	1139	165	0.775862	1.2801723	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	5.98e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1126	i0	91.139	386.018181818182	158	12	96	1	8	165	5032914	5033069	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	63693	213	1	Bacteria		Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
24008524	24008524	PRJNA229468_S_NODE_139_length_410_cov_1.637119_g126_i0	PRJNA229468	139	410	1.637119	6.7121879	Paenibacillus	44249	Bacteria	Bacteria	747	0	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g126	i0	99.512	1055.00731707317	410	2	100	0	1	410	15308	15717	Paenibacillus sp. FSL R5-0345, complete genome	blastn	432553	747	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
24008526	24008526	PRJNA229468_S_NODE_739_length_191_cov_0.894366_g726_i0	PRJNA229468	739	191	0.894366	1.70823906	Streptococcus	1301	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g726	i0	100	617.952879581152	191	0	100	0	1	191	17677	17487	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	118029	353	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
25282653	25282653	PRJNA229468_S_NODE_20_length_915_cov_3.091224_g16_i0	PRJNA229468	20	915	3.091224	28.2846996	Cutibacterium	1912216	Bacteria	Bacteria	1674	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g16	i0	99.672	280.55737704918	915	3	100	0	1	915	56490	57404	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	256710	1674	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27358639	27358639	PRJNA229468_S_NODE_423_length_241_cov_1.088542_g410_i0	PRJNA229468	423	241	1.088542	2.62338622	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	96.3	1.0100000000000002e-21	NR	HXY94086.1	2080302	g410	i0	65	5.70124481327801	80	25	99.6	2	240	1	70	146	HXY94086.1 SDR family NAD(P)-dependent oxidoreductase [Acidimicrobiia bacterium]	diamond	1374	96.3	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
27453407	27453407	PRJNA229468_S_NODE_123_length_445_cov_1.373737_g110_i0	PRJNA229468	123	445	1.373737	6.11312965	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	89.7	8.58e-20	NR	POH17992.1	1625	g110	i0	67.1	0.492134831460674	73	24	49.2	0	1	219	59	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	219	89.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
27990070	27990070	PRJNA229468_S_NODE_705_length_196_cov_1.183673_g692_i0	PRJNA229468	705	196	1.183673	2.31999908	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.5	9.22e-10	NR	MBX9666278.1	2364082	g692	i0	56.6	0.811224489795918	53	23	81.1	0	171	13	42	94	MBX9666278.1 FAD-dependent monooxygenase [Candidatus Obscuribacterales bacterium]	diamond	159	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28179158	28179158	PRJNA229468_S_NODE_46_length_669_cov_3.180645_g39_i0	PRJNA229468	46	669	3.180645	21.27851505	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	117	3.8999999999999995e-28	NR	HZB94728.1	2720503	g39	i0	46.4	0.802690582959641	179	85	76.7	7	74	586	28	203	HZB94728.1 DUF4397 domain-containing protein [Herpetosiphonaceae bacterium]	diamond	537	117	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
30832237	30832237	PRJNA229468_S_NODE_554_length_214_cov_1.048485_g541_i0	PRJNA229468	554	214	1.048485	2.2437579	Cyanobacteria bacterium P01_H01_bin.153	3023316	Bacteria	Bacteria	93.2	3.5700000000000003e-22	NR	MEM1309679.1	3023316	g541	i0	67.8	1.65420560747664	59	19	82.7	0	213	37	91	149	MEM1309679.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_H01_bin.153]	diamond	354	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.153
31591173	31591173	PRJNA229468_S_NODE_816_length_184_cov_1.133333_g803_i0	PRJNA229468	816	184	1.133333	2.08533272	Plectonema radiosum	945768	Bacteria	Bacteria	43.9	0.00693	NR	MCV3215606.1	2986073	g803	i0	46.8	1.43478260869565	47	24	76.6	1	4	144	9102	9147	MCV3215606.1 PKD domain-containing protein [Plectonema radiosum NIES-515]	diamond	264	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
31843895	31843895	PRJNA229468_S_NODE_397_length_250_cov_1.074627_g384_i0	PRJNA229468	397	250	1.074627	2.6865675	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	92.8	4.900000000000001e-22	NR	POH17992.1	1625	g384	i0	68.8	0.924	77	24	92.4	0	236	6	28	104	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	231	92.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
32128984	32128984	PRJNA229468_S_NODE_998_length_170_cov_2.504132_g985_i0	PRJNA229468	998	170	2.504132	4.2570244	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	63.5	6.67e-11	NR	MDH5420796.1	2080302	g985	i0	52.9	0.9	51	24	90	0	169	17	20	70	MDH5420796.1 SRPBCC family protein [Acidimicrobiia bacterium]	diamond	153	63.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32146593	32146593	PRJNA229468_S_NODE_458_length_232_cov_0.956284_g445_i0	PRJNA229468	458	232	0.956284	2.21857888	Bacteria	2	Bacteria	Bacteria	116	4.8399999999999994e-30	NR	WP_308153850.1	1423	g445	i0	71.4	13.8879310344828	77	22	99.6	0	231	1	2	78	WP_308153850.1 glucose 1-dehydrogenase [Bacillus subtilis]	diamond	3222	117	0.991452991452991	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
32146594	32146594	PRJNA229468_S_NODE_718_length_194_cov_1.406897_g705_i0	PRJNA229468	718	194	1.406897	2.72938018	FCB group	1783270	Bacteria	Bacteria	58.9	4.09e-9	NR	MET0802013.1	2900548	g705	i0	60.5	2.64432989690722	43	16	64.9	1	194	69	83	125	MET0802013.1 SDR family NAD(P)-dependent oxidoreductase [Actinomycetota bacterium]	diamond	513	59.3	0.993254637436762	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
32255731	32255731	PRJNA229468_S_NODE_1078_length_166_cov_2.025641_g1065_i0	PRJNA229468	1078	166	2.025641	3.36256406	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.9	4.72e-11	NR	MEZ4515128.1	2026724	g1065	i0	52.8	0.957831325301205	53	25	95.8	0	160	2	41	93	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	159	63.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32791914	32791914	PRJNA229468_S_NODE_360_length_265_cov_1.046296_g347_i0	PRJNA229468	360	265	1.046296	2.7726844	Chloroflexia bacterium	2448782	Bacteria	Bacteria	76.6	2.21e-14	NR	HEX2912625.1	2448782	g347	i0	49.4	1.00754716981132	89	43	99.6	2	264	1	43	130	HEX2912625.1 PfkB family carbohydrate kinase [Chloroflexia bacterium]	diamond	267	76.6	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				Chloroflexia 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);;