metadata: contig_metadata: 32 rows where bioproject = "PRJNA393181" and tax

32 rows where bioproject = "PRJNA393181" 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
2353916	2353916	PRJNA393181_S_NODE_32202_length_195_cov_3.113924_g32096_i0	PRJNA393181	32202	195	3.113924	6.0721518	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g32096	i0	100	100.097435897436	195	0	100	0	1	195	2742151	2741957	Staphylococcus aureus strain WH3018 chromosome	blastn	19519	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4906584	4906584	PRJNA393181_S_NODE_39144_length_171_cov_10.343284_g39038_i0	PRJNA393181	39144	171	10.343284	17.68701564	root	1	Root_unresolved	Root_unresolved	296	5.99e-76	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g39038	i0	100	95.1695906432749	160	0	94	0	1	160	2463677	2463836	Staphylococcus aureus strain WH9628 chromosome	blastn	16274	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4906588	4906588	PRJNA393181_S_NODE_39484_length_170_cov_3.827068_g39378_i0	PRJNA393181	39484	170	3.827068	6.5060156	Bacteria	2	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2240231723\|gb\|CP097282.1\|	292800	g39378	i0	100	16.6941176470588	30	0	19	0	18	47	134773	134802	Flavonifractor plautii strain NB2A-20-GAM chromosome	blastn	2838	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
6788099	6788099	PRJNA393181_S_NODE_24486_length_233_cov_1.969388_g24380_i0	PRJNA393181	24486	233	1.969388	4.58867404	Virgibacillus litoralis	578221	Bacteria	Bacteria	59.7	2.79e-8	NR	WP_209482258.1	578221	g24380	i0	40.3	0.991416309012876	77	41	99.1	2	1	231	36	107	WP_209482258.1 arginase [Virgibacillus litoralis]	diamond	231	59.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus litoralis
9338626	9338626	PRJNA393181_S_NODE_29848_length_205_cov_3.458333_g29742_i0	PRJNA393181	29848	205	3.458333	7.08958265	Caldinitratiruptor microaerophilus	671077	Bacteria	Bacteria	99	2.27e-16	NTclustered	gi\|2317219343\|dbj\|AP025628.1\|	671077	g29742	i0	81.301	0.770731707317073	123	21	60	2	49	170	1063266	1063145	Caldinitratiruptor microaerophilus JCM 16183 DNA, complete genome	blastn	158	99	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae	Caldinitratiruptor	Caldinitratiruptor microaerophilus
10006738	10006738	PRJNA393181_S_NODE_43468_length_160_cov_1.569106_g43362_i0	PRJNA393181	43468	160	1.569106	2.5105696	Blautia	572511	Bacteria	Bacteria	239	9.49e-59	NTclustered	gi\|2884834591\|gb\|CP176627.1\|	40520	g43362	i0	93.711	74.2	159	10	99	0	2	160	2578	2736	Blautia obeum strain SFAD70 chromosome, complete genome	blastn	11872	239	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
10614604	10614604	PRJNA393181_S_NODE_40269_length_168_cov_2.549618_g40163_i0	PRJNA393181	40269	168	2.549618	4.28335824	Flavonifractor plautii	292800	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1173509597\|gb\|CP015406.2\|	292800	g40163	i0	94.286	2.25595238095238	35	2	21	0	35	69	3497001	3497035	Flavonifractor plautii strain YL31 chromosome, complete genome	blastn	379	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
11889913	11889913	PRJNA393181_S_NODE_9230_length_396_cov_3.905292_g9124_i0	PRJNA393181	9230	396	3.905292	15.46495632	Catenibacterium sp. co_0103	2478954	Bacteria	Bacteria	708	0	NTclustered	gi\|1997760561\|emb\|LR994472.1\|	2478954	g9124	i0	99.486	230.335858585859	389	2	98	0	3	391	681501	681113	Catenibacterium sp. co_0103 isolate Catenibacterium canine HQ MAG genome assembly, chromosome: 1	blastn	91213	708	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium sp. co_0103
12557357	12557357	PRJNA393181_S_NODE_47190_length_151_cov_2.350877_g47084_i0	PRJNA393181	47190	151	2.350877	3.54982427	Catenibacterium	135858	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g47084	i0	100	201.635761589404	151	0	100	0	1	151	143284	143434	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	30447	279	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
13164465	13164465	PRJNA393181_S_NODE_36991_length_178_cov_2.319149_g36885_i0	PRJNA393181	36991	178	2.319149	4.12808522	Staphylococcus aureus	1280	Bacteria	Bacteria	109	1.93e-29	NR	WP_160401609.1	1280	g36885	i0	89.8	0.99438202247191	59	6	99.4	0	178	2	23	81	WP_160401609.1 ABC transporter substrate-binding protein, partial [Staphylococcus aureus]	diamond	177	109	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15713186	15713186	PRJNA393181_S_NODE_29533_length_207_cov_2.047059_g29427_i0	PRJNA393181	29533	207	2.047059	4.23741213	Acetilactobacillus jinshanensis	1720083	Bacteria	Bacteria	58.4	3.89e-4	NTclustered	gi\|2833683980\|gb\|CP171343.1\|	1720083	g29427	i0	100	0.285024154589372	31	0	15	0	42	72	534297	534267	MAG: Acetilactobacillus jinshanensis isolate AJITA chromosome	blastn	59	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Acetilactobacillus	Acetilactobacillus jinshanensis
15713429	15713429	PRJNA393181_S_NODE_39673_length_170_cov_1.759398_g39567_i0	PRJNA393181	39673	170	1.759398	2.9909766	Catenibacterium sp. co_0103	2478954	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1997760561\|emb\|LR994472.1\|	2478954	g39567	i0	100	70.2529411764706	170	0	100	0	1	170	142453	142284	Catenibacterium sp. co_0103 isolate Catenibacterium canine HQ MAG genome assembly, chromosome: 1	blastn	11943	315	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium sp. co_0103
16987640	16987640	PRJNA393181_S_NODE_17514_length_284_cov_2.761134_g17408_i0	PRJNA393181	17514	284	2.761134	7.84162056	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621704007\|emb\|OY762962.1\|	2054177	g17408	i0	100	0.0985915492957746	28	0	10	0	91	118	2006332	2006359	MAG: Christensenellaceae bacterium isolate 71fbd196-4d72-4d9d-b023-dc0a1f92e7b0 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
17656042	17656042	PRJNA393181_S_NODE_25834_length_225_cov_2.037234_g25728_i0	PRJNA393181	25834	225	2.037234	4.5837765	Bacteria	2	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2240231723\|gb\|CP097282.1\|	292800	g25728	i0	100	2.24	28	0	12	0	1	28	507712	507739	Flavonifractor plautii strain NB2A-20-GAM chromosome	blastn	504	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
18261631	18261631	PRJNA393181_S_NODE_11355_length_358_cov_2.373832_g11249_i0	PRJNA393181	11355	358	2.373832	8.49831856	Cytobacillus gottheilii	859144	Bacteria	Bacteria	63.9	1.57e-5	NTclustered	gi\|2046389985\|gb\|CP071709.1\|	859144	g11249	i0	95	0.268156424581006	40	2	11	0	97	136	2831017	2830978	Cytobacillus gottheilii strain 1839 chromosome, complete genome	blastn	96	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus gottheilii
20204738	20204738	PRJNA393181_S_NODE_37856_length_175_cov_3.086957_g37750_i0	PRJNA393181	37856	175	3.086957	5.40217475	Blautia	572511	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2884834591\|gb\|CP176627.1\|	40520	g37750	i0	98.857	429.885714285714	175	2	100	0	1	175	2199026	2198852	Blautia obeum strain SFAD70 chromosome, complete genome	blastn	75230	313	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
22087112	22087112	PRJNA393181_S_NODE_35538_length_183_cov_2.061644_g35432_i0	PRJNA393181	35538	183	2.061644	3.77280852	Paenibacillus albicereus	2726185	Bacteria	Bacteria	152	1.49e-32	NTclustered	gi\|1833310551\|gb\|CP051428.1\|	2726185	g35432	i0	84.375	73.1639344262295	160	19	86	6	12	168	539955	539799	Paenibacillus albicereus strain UniB2 chromosome, complete genome	blastn	13389	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus albicereus
26902454	26902454	PRJNA393181_S_NODE_44981_length_156_cov_2.294118_g44875_i0	PRJNA393181	44981	156	2.294118	3.57882408	Paenibacillus	44249	Bacteria	Bacteria	58.9	1.42e-8	NR	WP_175491797.1	1333845	g44875	i0	61.5	2	52	20	100	0	1	156	25	76	WP_175491797.1 ABC transporter permease [Paenibacillus sophorae]	diamond	312	58.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sophorae
27517715	27517715	PRJNA393181_S_NODE_43403_length_160_cov_1.780488_g43297_i0	PRJNA393181	43403	160	1.780488	2.8487808	Firmicutes bacterium 13_1_4	1879010	Bacteria	Bacteria	92	1.56e-20	NR	OLD06924.1	1805156	g43297	i0	80.8	0.975	52	10	97.5	0	159	4	213	264	OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11]	diamond	156	92	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium 13_1_40CM_3_65_11
27770492	27770492	PRJNA393181_S_NODE_30564_length_202_cov_2.490909_g30458_i0	PRJNA393181	30564	202	2.490909	5.03163618	Lactobacillus crispatus	47770	Bacteria	Bacteria	50.4	2.52e-5	NR	WP_133534204.1	47770	g30458	i0	38.4	1.08415841584158	73	37	99.5	2	1	201	66	136	WP_133534204.1 hypothetical protein, partial [Lactobacillus crispatus]	diamond	219	50.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
28528222	28528222	PRJNA393181_S_NODE_17367_length_286_cov_1.594378_g17261_i0	PRJNA393181	17367	286	1.594378	4.55992108	Firmicutes bacterium 13_1_4	1879010	Bacteria	Bacteria	78.2	1.2e-14	NR	OLD06924.1	1805156	g17261	i0	57.1	0.734265734265734	70	30	73.4	0	4	213	262	331	OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11]	diamond	210	78.2	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium 13_1_40CM_3_65_11
28622906	28622906	PRJNA393181_S_NODE_18227_length_278_cov_2.547718_g18121_i0	PRJNA393181	18227	278	2.547718	7.08265604	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	82.4	5.66e-16	NR	MBQ9413227.1	2485925	g18121	i0	63.5	3.09712230215827	74	26	79.9	1	56	277	1	73	MBQ9413227.1 MBOAT family protein [Oscillospiraceae bacterium]	diamond	861	82.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28780466	28780466	PRJNA393181_S_NODE_20147_length_262_cov_2.475556_g20041_i0	PRJNA393181	20147	262	2.475556	6.48595672	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	56.2	7.85e-7	NR	MBQ6319266.1	1898203	g20041	i0	39.5	1.84351145038168	81	47	90.5	1	21	257	341	421	MBQ6319266.1 serine/threonine protein kinase [Lachnospiraceae bacterium]	diamond	483	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29033464	29033464	PRJNA393181_S_NODE_30328_length_203_cov_2.397590_g30222_i0	PRJNA393181	30328	203	2.39759	4.8671077	Veillonellaceae bacterium	2049049	Bacteria	Bacteria	97.8	9.63e-23	NR	NMC31201.1	2049049	g30222	i0	68.2	1.96551724137931	66	21	97.5	0	4	201	87	152	NMC31201.1 proline iminopeptidase-family hydrolase [Veillonellaceae bacterium]	diamond	399	97.8	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae		Veillonellaceae bacterium
29208087	29208087	PRJNA393181_S_NODE_38629_length_173_cov_2.000000_g38523_i0	PRJNA393181	38629	173	2	3.46	Bacteria	2	Bacteria	Bacteria	115	2.8399999999999997e-31	NR	WP_213397906.1	1423	g38523	i0	96.5	2.96531791907514	57	2	98.8	0	1	171	62	118	WP_213397906.1 cytochrome P450, partial [Bacillus subtilis]	diamond	513	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
29664321	29664321	PRJNA393181_S_NODE_25510_length_227_cov_1.621053_g25404_i0	PRJNA393181	25510	227	1.621053	3.67979031	Bacillus sp. SIMBA_161	3080866	Bacteria	Bacteria	54.7	7.76e-8	NR	MFP3422661.1	3080866	g25404	i0	49	2.51101321585903	51	26	67.4	0	166	14	2	52	MFP3422661.1 hypothetical protein [Bacillus sp. SIMBA_161]	diamond	570	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. SIMBA_161
30218394	30218394	PRJNA393181_S_NODE_15952_length_300_cov_2.178707_g15846_i0	PRJNA393181	15952	300	2.178707	6.536121	Bacteria	2	Bacteria	Bacteria	53.9	8.57e-6	NR	WP_066330782.1	152268	g15846	i0	72.5	1.83	40	11	40	0	181	300	18	57	WP_066330782.1 MDR family MFS transporter [Metabacillus litoralis]	diamond	549	53.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus litoralis
30486090	30486090	PRJNA393181_S_NODE_22233_length_247_cov_2.776190_g22127_i0	PRJNA393181	22233	247	2.77619	6.8571893	Bacillota bacterium	1879010	Bacteria	Bacteria	57	9.59e-9	NR	MDI9504832.1	1879010	g22127	i0	65	0.48582995951417	40	14	48.6	0	3	122	12	51	MDI9504832.1 sel1 repeat family protein [Bacillota bacterium]	diamond	120	57	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31339186	31339186	PRJNA393181_S_NODE_32196_length_195_cov_3.183544_g32090_i0	PRJNA393181	32196	195	3.183544	6.2079108	Paenibacillus sp. SYP-B4298	2996034	Bacteria	Bacteria	92.8	3.8e-20	NR	WP_270166955.1	2996034	g32090	i0	65.6	2.95384615384615	64	22	98.5	0	3	194	365	428	WP_270166955.1 hypothetical protein [Paenibacillus sp. SYP-B4298]	diamond	576	92.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. SYP-B4298
31893769	31893769	PRJNA393181_S_NODE_33597_length_190_cov_1.921569_g33491_i0	PRJNA393181	33597	190	1.921569	3.6509811	root	1	Root_unresolved	Root_unresolved	44.3	0.0038	NR	MBS5016378.1	41978	g33491	i0	44.1	3.77368421052632	59	32	91.6	1	184	11	81	139	MBS5016378.1 sel1 repeat family protein [Ruminococcus sp.]	diamond	717	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
31940079	31940079	PRJNA393181_S_NODE_23077_length_241_cov_3.465686_g22971_i0	PRJNA393181	23077	241	3.465686	8.35230326	Paenibacillus rhizophilus	1850366	Bacteria	Bacteria	48.1	4.19e-4	NR	WP_124697366.1	1850366	g22971	i0	49.1	0.70954356846473	57	29	71	0	71	241	22	78	WP_124697366.1 ABC transporter permease [Paenibacillus rhizophilus]	diamond	171	48.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus rhizophilus
31971822	31971822	PRJNA393181_S_NODE_13478_length_328_cov_3.216495_g13372_i0	PRJNA393181	13478	328	3.216495	10.5501036	Firmicutes bacterium 13_1_4	1879010	Bacteria	Bacteria	169	2.57e-49	NR	OLD06924.1	1805156	g13372	i0	71.3	0.98780487804878	108	31	98.8	0	326	3	99	206	OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11]	diamond	324	169	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium 13_1_40CM_3_65_11

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