metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA667863" 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
1163542	1163542	PRJNA667863_P_NODE_9481_length_261_cov_1.031915_g9447_i0	PRJNA667863	9481	261	1.031915	2.69329815	Salsuginibacillus kocurii	427078	Bacteria	Bacteria	150	6.149999999999998e-41	NR	WP_040607081.1	427078	g9447	i0	79.1	12.8505747126437	86	18	98.9	0	2	259	378	463	WP_040607081.1 betaine-aldehyde dehydrogenase [Salsuginibacillus kocurii]	diamond	3354	150	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salsuginibacillus	Salsuginibacillus kocurii
8287266	8287266	PRJNA667863_P_NODE_2227_length_382_cov_2.330097_g2193_i0	PRJNA667863	2227	382	2.330097	8.90097054	FCB group	1783270	Bacteria	Bacteria	165	6.29e-47	NR	WP_090832283.1	185979	g2193	i0	64	8.90575916230367	125	44	98.2	1	377	3	125	248	WP_090832283.1 MULTISPECIES: NADH-dependent flavin oxidoreductase [unclassified Bacillus (in: firmicutes)]	diamond	3402	165	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
14663042	14663042	PRJNA667863_P_NODE_8572_length_266_cov_3.000000_g8538_i0	PRJNA667863	8572	266	3	7.98	Lachnospiraceae	186803	Bacteria	Bacteria	130	6.09e-33	NR	WP_191229643.1	2719315	g8538	i0	68.2	16.296992481203	85	27	95.9	0	3	257	281	365	WP_191229643.1 glutamine synthetase III [Enterocloster sp.]	diamond	4335	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster sp.
21036536	21036536	PRJNA667863_P_NODE_537_length_650_cov_16.428076_g505_i0	PRJNA667863	537	650	16.428076	106.782494	Clostridium perfringens	1502	Bacteria	Bacteria	254	6.94e-83	NR	MDJ8942385.1	1502	g505	i0	79.5	0.72	156	32	72	0	501	34	40	195	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	468	254	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
25390067	25390067	PRJNA667863_P_NODE_8280_length_268_cov_3.902564_g8246_i0	PRJNA667863	8280	268	3.902564	10.45887152	Bacteria	2	Bacteria	Bacteria	129	2.83e-37	NR	WP_207554022.1	1890302	g8246	i0	98.4	1.36567164179104	61	1	68.3	0	266	84	12	72	WP_207554022.1 FeoA family protein, partial [Bacillus wiedmannii]	diamond	366	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus wiedmannii
26733038	26733038	PRJNA667863_P_NODE_4181_length_318_cov_3.183673_g4147_i0	PRJNA667863	4181	318	3.183673	10.12408014	Fictibacillus iocasae	2715437	Bacteria	Bacteria	49.3	4.68e-4	NR	WP_379744814.1	2715437	g4147	i0	29	0.877358490566038	93	65	86.8	1	2	277	1565	1657	WP_379744814.1 carboxypeptidase regulatory-like domain-containing protein [Fictibacillus iocasae]	diamond	279	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Fictibacillus	Fictibacillus iocasae
26860412	26860412	PRJNA667863_P_NODE_18261_length_230_cov_2.019108_g18227_i0	PRJNA667863	18261	230	2.019108	4.6439484	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	79.7	4.67e-17	NR	MBP5166268.1	2485925	g18227	i0	49.3	1.94347826086957	75	32	97.8	1	4	228	29	97	MBP5166268.1 RidA family protein [Oscillospiraceae bacterium]	diamond	447	79.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27113025	27113025	PRJNA667863_P_NODE_13902_length_246_cov_1.497110_g13868_i0	PRJNA667863	13902	246	1.49711	3.6828906	Paraliobacillus ryukyuensis	200904	Bacteria	Bacteria	107	4.32e-25	NR	WP_113866745.1	200904	g13868	i0	78.5	2.36585365853659	65	14	79.3	0	2	196	115	179	WP_113866745.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Paraliobacillus ryukyuensis]	diamond	582	107	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Paraliobacillus	Paraliobacillus ryukyuensis
27283344	27283344	PRJNA667863_P_NODE_12703_length_248_cov_1.760000_g12669_i0	PRJNA667863	12703	248	1.76	4.3648	Bacteria	2	Bacteria	Bacteria	154	9.74e-47	NR	WP_415411022.1	985762	g12669	i0	100	3.96774193548387	82	0	99.2	0	248	3	9	90	WP_415411022.1 hypothetical protein, partial [Staphylococcus agnetis]	diamond	984	154	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus agnetis
27302982	27302982	PRJNA667863_P_NODE_12203_length_249_cov_1.744318_g12169_i0	PRJNA667863	12203	249	1.744318	4.34335182	Bacilliculturomica massiliensis	1917867	Bacteria	Bacteria	68.6	3.11e-11	NR	WP_130861688.1	1917867	g12169	i0	41.9	2.04819277108434	86	44	96.4	2	245	6	342	427	WP_130861688.1 jacalin-like lectin [Bacilliculturomica massiliensis]	diamond	510	68.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Bacilliculturomica	Bacilliculturomica massiliensis
27409919	27409919	PRJNA667863_P_NODE_5943_length_288_cov_2.734884_g5909_i0	PRJNA667863	5943	288	2.734884	7.87646592	FCB group	1783270	Bacteria	Bacteria	111	1.6e-26	NR	WP_118250831.1	2737	g5909	i0	53.8	6.91666666666667	91	42	94.8	0	275	3	280	370	WP_118250831.1 MULTISPECIES: aldehyde dehydrogenase [Vagococcus]	diamond	1992	112	0.991071428571429	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus
27460964	27460964	PRJNA667863_P_NODE_18443_length_228_cov_2.490323_g18409_i0	PRJNA667863	18443	228	2.490323	5.67793644	Bacillus mycoides	1405	Bacteria	Bacteria	145	4.04e-43	NR	OOR48540.1	1405	g18409	i0	100	0.986842105263158	75	0	98.7	0	227	3	21	95	OOR48540.1 hypothetical protein BGP34_31730, partial [Bacillus mycoides]	diamond	225	145	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
27587235	27587235	PRJNA667863_P_NODE_18504_length_227_cov_3.558442_g18470_i0	PRJNA667863	18504	227	3.558442	8.07766334	Anaerococcus sp. WGS1596	3366806	Bacteria	Bacteria	133	2.6999999999999997e-36	NR	WP_394018404.1	3366806	g18470	i0	89.3	0.991189427312775	75	8	99.1	0	226	2	162	236	WP_394018404.1 ABC transporter permease subunit [Anaerococcus sp. WGS1596]	diamond	225	133	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
27934493	27934493	PRJNA667863_P_NODE_8705_length_265_cov_4.859375_g8671_i0	PRJNA667863	8705	265	4.859375	12.87734375	Clostridium perfringens	1502	Bacteria	Bacteria	119	9.8e-33	NR	MDK0604694.1	1502	g8671	i0	86.2	0.984905660377358	87	12	98.5	0	3	263	5	91	MDK0604694.1 tropomyosin [Clostridium perfringens]	diamond	261	119	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
28072679	28072679	PRJNA667863_P_NODE_6085_length_287_cov_1.439252_g6051_i0	PRJNA667863	6085	287	1.439252	4.13065324	Bacteria	2	Bacteria	Bacteria	132	4.44e-38	NR	WP_346329348.1	1296	g6051	i0	100	2.22648083623693	71	0	74.2	0	215	3	1	71	WP_346329348.1 2-vinyl bacteriochlorophyllide hydratase, partial [Mammaliicoccus sciuri]	diamond	639	132	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sciuri
28313393	28313393	PRJNA667863_P_NODE_12326_length_249_cov_0.875000_g12292_i0	PRJNA667863	12326	249	0.875	2.17875	Virgibacillus sp. JSM 1	1872700	Bacteria	Bacteria	107	2.15e-25	NR	WP_375054084.1	1562108	g12292	i0	65.9	6.91566265060241	82	26	98.8	1	2	247	33	112	WP_375054084.1 IS110 family transposase [Virgibacillus sp. JSM 102003]	diamond	1722	107	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus sp. JSM 102003
28451798	28451798	PRJNA667863_P_NODE_2506_length_369_cov_2.270270_g2472_i0	PRJNA667863	2506	369	2.27027	8.3772963	Bacteria	2	Bacteria	Bacteria	226	9.35e-72	NR	MBM5615196.1	1642	g2472	i0	92.6	2.95121951219512	121	9	98.4	0	2	364	141	261	MBM5615196.1 inovirus Gp2 family protein [Listeria innocua]	diamond	1089	226	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria innocua
28546627	28546627	PRJNA667863_P_NODE_12287_length_249_cov_1.250000_g12253_i0	PRJNA667863	12287	249	1.25	3.1125	Bacillales	1385	Bacteria	Bacteria	146	9.25e-39	NR	WP_309312498.1	1392	g12253	i0	87.7	84.0361445783133	81	10	97.6	0	3	245	577	657	WP_309312498.1 SbcC/MukB-like Walker B domain-containing protein, partial [Bacillus anthracis]	diamond	20925	146	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
28546628	28546628	PRJNA667863_P_NODE_14907_length_244_cov_3.409357_g14873_i0	PRJNA667863	14907	244	3.409357	8.31883108	Bacillales	1385	Bacteria	Bacteria	63.5	1.7e-9	NR	WP_126867298.1	1674310	g14873	i0	57.7	1.2172131147541	52	18	63.9	1	242	87	625	672	WP_126867298.1 ABC transporter ATP-binding protein [Peribacillus cavernae]	diamond	297	63.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus cavernae
28912957	28912957	PRJNA667863_P_NODE_18288_length_229_cov_3.685897_g18254_i0	PRJNA667863	18288	229	3.685897	8.44070413	Clostridiales bacterium	1898207	Bacteria	Bacteria	43.9	0.0122	NR	MCF8010988.1	1898207	g18254	i0	39.6	1.51965065502183	48	29	62.9	0	68	211	181	228	MCF8010988.1 DASS family sodium-coupled anion symporter [Clostridiales bacterium]	diamond	348	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29177980	29177980	PRJNA667863_P_NODE_18729_length_225_cov_4.447368_g18695_i0	PRJNA667863	18729	225	4.447368	10.006578	Sporosarcina	1569	Bacteria	Bacteria	74.3	4.41e-15	NR	WP_115360495.1	1474	g18695	i0	79.5	2.30666666666667	44	9	58.7	0	3	134	72	115	WP_115360495.1 30S ribosome-binding factor RbfA [Sporosarcina pasteurii]	diamond	519	74.7	0.994645247657296	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina pasteurii
29197547	29197547	PRJNA667863_P_NODE_1789_length_408_cov_5.549254_g1755_i0	PRJNA667863	1789	408	5.549254	22.64095632	Clostridium perfringens	1502	Bacteria	Bacteria	53.9	4.81e-6	NR	MDJ8942389.1	1502	g1755	i0	44.4	0.595588235294118	81	37	58.1	3	241	5	29	103	MDJ8942389.1 hypothetical protein [Clostridium perfringens]	diamond	243	53.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
29386986	29386986	PRJNA667863_P_NODE_5649_length_291_cov_4.119266_g5615_i0	PRJNA667863	5649	291	4.119266	11.98706406	Clostridia bacterium	2044939	Bacteria	Bacteria	54.3	5.7e-6	NR	MBQ3663758.1	2044939	g5615	i0	41.9	1.90721649484536	93	53	95.9	1	289	11	638	729	MBQ3663758.1 hypothetical protein [Clostridia bacterium]	diamond	555	54.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29525290	29525290	PRJNA667863_P_NODE_11870_length_250_cov_0.870056_g11836_i0	PRJNA667863	11870	250	0.870056	2.17514	Bacillales	1385	Bacteria	Bacteria	112	6.4000000000000005e-27	NR	WP_327866533.1	1391	g11836	i0	68.7	8.904	83	26	99.6	0	250	2	217	299	WP_327866533.1 DHA2 family efflux MFS transporter permease subunit [Aneurinibacillus aneurinilyticus]	diamond	2226	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Aneurinibacillus	Aneurinibacillus aneurinilyticus
29670632	29670632	PRJNA667863_P_NODE_13450_length_247_cov_0.885057_g13416_i0	PRJNA667863	13450	247	0.885057	2.18609079	Limnochorda pilosa	1555112	Bacteria	Bacteria	88.6	2.25e-18	NR	WP_068137502.1	1555112	g13416	i0	58.4	3.87449392712551	77	30	93.5	1	12	242	172	246	WP_068137502.1 putrescine aminotransferase [Limnochorda pilosa]	diamond	957	88.6	1	Bacteria	Bacillati	Bacillota	Limnochordia	Limnochordales	Limnochordaceae	Limnochorda	Limnochorda pilosa
30650108	30650108	PRJNA667863_P_NODE_6413_length_284_cov_1.270142_g6379_i0	PRJNA667863	6413	284	1.270142	3.60720328	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.1	0.0444	NR	MBE5935960.1	1898203	g6379	i0	39	0.623239436619718	59	36	62.3	0	271	95	140	198	MBE5935960.1 extracellular solute-binding protein [Lachnospiraceae bacterium]	diamond	177	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31123907	31123907	PRJNA667863_P_NODE_8375_length_268_cov_1.441026_g8341_i0	PRJNA667863	8375	268	1.441026	3.86194968	Bacillota bacterium	1879010	Bacteria	Bacteria	57.4	3.27e-7	NR	HHW15566.1	1879010	g8341	i0	56.3	2.6865671641791	48	21	53.7	0	110	253	5	52	HHW15566.1 N-acetyl-gamma-glutamyl-phosphate reductase [Bacillota bacterium]	diamond	720	57.4	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31250626	31250626	PRJNA667863_P_NODE_4475_length_313_cov_1.220833_g4441_i0	PRJNA667863	4475	313	1.220833	3.82120729	Clostridium botulinum	1491	Bacteria	Bacteria	50.8	1.14e-4	NR	WP_061301141.1	1491	g4441	i0	38.9	0.690095846645367	72	42	68.1	2	311	99	193	263	WP_061301141.1 SNF2-related protein [Clostridium botulinum]	diamond	216	50.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
31788159	31788159	PRJNA667863_P_NODE_18657_length_226_cov_2.660131_g18623_i0	PRJNA667863	18657	226	2.660131	6.01189606	Evtepia gabavorous	2211183	Bacteria	Bacteria	46.2	0.00182	NR	MFR0912713.1	2211183	g18623	i0	35.7	0.929203539823009	70	31	90.3	3	16	219	660	717	MFR0912713.1 ABC transporter permease [Evtepia gabavorous]	diamond	210	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Evtepia	Evtepia gabavorous
31851497	31851497	PRJNA667863_P_NODE_15977_length_243_cov_0.905882_g15943_i0	PRJNA667863	15977	243	0.905882	2.20129326	Mesobacillus foraminis	279826	Bacteria	Bacteria	97.8	3.52e-22	NR	WP_214897304.1	279826	g15943	i0	53.1	1.98765432098765	81	38	100	0	243	1	23	103	WP_214897304.1 DUF3231 family protein [Mesobacillus foraminis]	diamond	483	97.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus foraminis
31990157	31990157	PRJNA667863_P_NODE_5218_length_299_cov_1.292035_g5184_i0	PRJNA667863	5218	299	1.292035	3.86318465	Bacteria	2	Bacteria	Bacteria	219	3e-72	NR	WP_346329307.1	1296	g5184	i0	100	2.97993311036789	99	0	99.3	0	3	299	5	103	WP_346329307.1 hypothetical protein, partial [Mammaliicoccus sciuri]	diamond	891	219	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sciuri
32199754	32199754	PRJNA667863_P_NODE_16138_length_242_cov_1.727811_g16104_i0	PRJNA667863	16138	242	1.727811	4.18130262	Streptococcus mitis	28037	Bacteria	Bacteria	139	4.92e-36	NR	WP_414309531.1	28037	g16104	i0	100	2.97520661157025	80	0	99.2	0	242	3	346	425	WP_414309531.1 thrombospondin type 3 repeat-containing protein, partial [Streptococcus mitis]	diamond	720	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
32326640	32326640	PRJNA667863_P_NODE_619_length_615_cov_2.939114_g587_i0	PRJNA667863	619	615	2.939114	18.0755511	Clostridia bacterium	2044939	Bacteria	Bacteria	63.5	8.43e-8	NR	MBQ7298540.1	2044939	g587	i0	43.9	0.678048780487805	139	69	67.3	5	2	415	788	918	MBQ7298540.1 hypothetical protein [Clostridia bacterium]	diamond	417	63.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32780076	32780076	PRJNA667863_P_NODE_10860_length_253_cov_1.372222_g10826_i0	PRJNA667863	10860	253	1.372222	3.47172166	Bacteria	2	Bacteria	Bacteria	143	1.19e-38	NR	NLI22754.1	1898207	g10826	i0	79.8	5.97628458498024	84	17	99.6	0	1	252	248	331	NLI22754.1 electron transport complex protein RnfC [Clostridiales bacterium]	diamond	1512	144	0.993055555555556	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales 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);;