metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA594101" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA594101" 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
1842826	1842826	PRJNA594101_S_NODE_58522_length_232_cov_2.899371_g58220_i0	PRJNA594101	58522	232	2.899371	6.72654072	uncultured Acetobacterium sp.	217139	Bacteria	Bacteria	58.4	4.46e-4	NTclustered	gi\|2907625634\|emb\|OZ223194.1\|	217139	g58220	i0	97.059	0.146551724137931	34	1	15	0	51	84	1102498	1102531	MAG: uncultured Acetobacterium sp. isolate 6abcf8f7-2dc5-46ce-9e35-983ba889e1c3 genome assembly, chromosome: 4	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Acetobacterium	uncultured Acetobacterium sp.
3117950	3117950	PRJNA594101_S_NODE_21863_length_359_cov_5.433566_g21561_i0	PRJNA594101	21863	359	5.433566	19.50650194	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2621786371\|emb\|OY782829.1\|	3030912	g21561	i0	94.286	0.0974930362116992	35	2	10	0	314	348	751070	751036	MAG: Anaerovoracaceae bacterium isolate 4d0eff97-7de3-49ad-953d-66426f0db4f8 genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
3118270	3118270	PRJNA594101_S_NODE_783_length_1515_cov_26.245492_g682_i0	PRJNA594101	783	1515	26.245492	397.6192038	Lacrimispora xylanolytica	29375	Bacteria	Bacteria	76.8	9.23e-9	NTclustered	gi\|2392079227\|gb\|CP113524.1\|	29375	g682	i0	78.226	0.139273927392739	124	23	8	3	389	508	1756870	1756747	Lacrimispora xylanolytica strain sy1 chromosome, complete genome	blastn	211	76.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora xylanolytica
3690875	3690875	PRJNA594101_S_NODE_27143_length_326_cov_1.620553_g26841_i0	PRJNA594101	27143	326	1.620553	5.28300278	Streptococcus	1301	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2582929504\|gb\|CP134147.1\|	1318	g26841	i0	94.444	0.978527607361963	36	0	10	2	56	89	352275	352310	Streptococcus parasanguinis strain 30.8.10 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
5670832	5670832	PRJNA594101_S_NODE_3345_length_868_cov_3.290566_g3102_i0	PRJNA594101	3345	868	3.290566	28.56211288	Clostridium sp.	1506	Bacteria	Bacteria	73.1	6.72e-8	NTclustered	gi\|2913933232\|gb\|CP181268.1\|	1506	g3102	i0	84.932	0.1463133640553	73	9	8	2	195	266	2060964	2060893	MAG: Clostridium sp. isolate UW_FK_CLOS2_1 chromosome	blastn	127	73.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
6243043	6243043	PRJNA594101_S_NODE_33645_length_297_cov_1.718750_g33343_i0	PRJNA594101	33645	297	1.71875	5.1046875	Clostridium	1485	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1095307724\|gb\|CP013019.1\|	1501	g33343	i0	100	0.390572390572391	29	0	10	0	82	110	4033302	4033330	Clostridium pasteurianum strain M150B chromosome, complete genome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium pasteurianum
6945309	6945309	PRJNA594101_S_NODE_39406_length_277_cov_1.480392_g39104_i0	PRJNA594101	39406	277	1.480392	4.10068584	Bacillus pseudomycoides	64104	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|673972667\|gb\|CP007626.1\|	64104	g39104	i0	100	0.202166064981949	28	0	10	0	180	207	3357703	3357676	Bacillus pseudomycoides strain 219298, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pseudomycoides
6945373	6945373	PRJNA594101_S_NODE_48426_length_251_cov_3.050562_g48124_i0	PRJNA594101	48426	251	3.050562	7.65691062	Staphylococcus simulans	1286	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|1247177777\|gb\|CP023497.1\|	1286	g48124	i0	100	0.247011952191235	31	0	12	0	93	123	1874177	1874147	Staphylococcus simulans strain FDAARGOS_383 chromosome, complete genome	blastn	62	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus simulans
8220210	8220210	PRJNA594101_S_NODE_25807_length_333_cov_2.403846_g25505_i0	PRJNA594101	25807	333	2.403846	8.00480718	Clostridiaceae bacterium HFYG-1003	2961947	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2282824529\|gb\|CP102060.1\|	2961947	g25505	i0	100	0.0840840840840841	28	0	8	0	36	63	982692	982665	Clostridiaceae bacterium HFYG-1003 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium HFYG-1003
8220293	8220293	PRJNA594101_S_NODE_36727_length_286_cov_1.333333_g36425_i0	PRJNA594101	36727	286	1.333333	3.81333238	Enterococcus sp. DIV0849a	2230879	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2707319616\|gb\|CP147249.1\|	2230879	g36425	i0	100	0.101398601398601	29	0	10	0	44	72	234146	234174	Enterococcus sp. DIV0849a chromosome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus sp. DIV0849a
8220442	8220442	PRJNA594101_S_NODE_58547_length_232_cov_2.421384_g58245_i0	PRJNA594101	58547	232	2.421384	5.61761088	Niallia sp. RD1	2962858	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2269758154\|gb\|CP100420.1\|	2962858	g58245	i0	100	0.129310344827586	30	0	13	0	175	204	1498722	1498693	Niallia sp. RD1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia sp. RD1
8792252	8792252	PRJNA594101_S_NODE_32287_length_303_cov_1.004348_g31985_i0	PRJNA594101	32287	303	1.004348	3.04317444	Lactobacillaceae	33958	Bacteria	Bacteria	82.4	3.6e-11	NTclustered	gi\|2116759285\|gb\|CP084701.1\|	1247	g31985	i0	83.721	3.77227722772277	86	14	28	0	12	97	958212	958297	Oenococcus oeni strain AWRIB429 chromosome, complete genome	blastn	1143	82.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Oenococcus	Oenococcus oeni
10771421	10771421	PRJNA594101_S_NODE_42409_length_268_cov_1.066667_g42107_i0	PRJNA594101	42409	268	1.066667	2.85866756	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2318961074\|gb\|CP107211.1\|	2485925	g42107	i0	100	0.104477611940299	28	0	10	0	30	57	811386	811413	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0066 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
12046145	12046145	PRJNA594101_S_NODE_27490_length_324_cov_2.183267_g27188_i0	PRJNA594101	27490	324	2.183267	7.07378508	Bombilactobacillus bombi	1303590	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1474734871\|gb\|CP031513.1\|	1303590	g27188	i0	100	0.0864197530864197	28	0	9	0	123	150	1380521	1380494	Bombilactobacillus bombi strain BI-2.5 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Bombilactobacillus	Bombilactobacillus bombi
12046385	12046385	PRJNA594101_S_NODE_57670_length_241_cov_0.916667_g57368_i0	PRJNA594101	57670	241	0.916667	2.20916747	Romboutsia sp. CE17	2724150	Bacteria	Bacteria	58.4	4.66e-4	NTclustered	gi\|1831577921\|gb\|CP051144.1\|	2724150	g57368	i0	94.737	0.157676348547718	38	1	15	1	138	174	960457	960420	Romboutsia sp. CE17 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. CE17
15167533	15167533	PRJNA594101_S_NODE_37952_length_282_cov_1.105263_g37650_i0	PRJNA594101	37952	282	1.105263	3.11684166	Clostridium	1485	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1245312327\|gb\|CP018624.1\|	46867	g37650	i0	96.774	0.407801418439716	31	1	11	0	16	46	2191670	2191700	Clostridium chauvoei strain DSM 7528 chromosome, complete genome	blastn	115	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium chauvoei
15869706	15869706	PRJNA594101_S_NODE_24053_length_344_cov_2.431734_g23751_i0	PRJNA594101	24053	344	2.431734	8.36516496	Lachnospiraceae bacterium KM106-2	2093742	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|1776939693\|dbj\|AP018794.1\|	2093742	g23751	i0	100	0.0813953488372093	28	0	8	0	67	94	3577393	3577366	Lachnospiraceae bacterium KM106-2 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium KM106-2
18418778	18418778	PRJNA594101_S_NODE_15115_length_426_cov_2.331445_g14813_i0	PRJNA594101	15115	426	2.331445	9.9319557	Paenibacillus sp. FSL H8-0537	2921399	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2710073530\|gb\|CP150290.1\|	2921399	g14813	i0	100	0.0657276995305164	28	0	7	0	223	250	6325575	6325548	Paenibacillus sp. FSL H8-0537 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H8-0537
19693323	19693323	PRJNA594101_S_NODE_13256_length_454_cov_1.028871_g12954_i0	PRJNA594101	13256	454	1.028871	4.67107434	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g12954	i0	92.5	0.0881057268722467	40	3	9	0	234	273	1813403	1813364	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	40	58.4	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
19693507	19693507	PRJNA594101_S_NODE_36676_length_286_cov_1.446009_g36374_i0	PRJNA594101	36676	286	1.446009	4.13558574	uncultured Saccharofermentans sp.	1434378	Bacteria	Bacteria	150	9.11e-32	NTclustered	gi\|2621780347\|emb\|OY776634.1\|	1434378	g36374	i0	80.952	4.92657342657343	189	36	66	0	53	241	1165429	1165241	MAG: uncultured Saccharofermentans sp. isolate 458ea057-a119-4e25-ad7c-619b59e424da genome assembly, chromosome: 1	blastn	1409	150	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Saccharofermentans	uncultured Saccharofermentans sp.
19693534	19693534	PRJNA594101_S_NODE_4016_length_801_cov_1.901099_g3752_i0	PRJNA594101	4016	801	1.901099	15.22780299	Vagococcus luciliae	2920380	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|2284907802\|gb\|CP102451.1\|	2920380	g3752	i0	86.538	0.0649188514357054	52	5	6	2	491	541	139225	139175	Vagococcus luciliae strain G314F chromosome, complete genome	blastn	52	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus luciliae
19693623	19693623	PRJNA594101_S_NODE_51416_length_248_cov_0.880000_g51114_i0	PRJNA594101	51416	248	0.88	2.1824	Dolosigranulum pigrum	29394	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2020675058\|gb\|CP040416.1\|	29394	g51114	i0	98.79	25.9032258064516	248	3	100	0	1	248	1453040	1453287	Dolosigranulum pigrum strain KPL3084 chromosome, complete genome	blastn	6424	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
20265890	20265890	PRJNA594101_S_NODE_18196_length_390_cov_3.006309_g17894_i0	PRJNA594101	18196	390	3.006309	11.7246051	root	1	Root_unresolved	Root_unresolved	76.8	2.21e-9	NTclustered	gi\|2189478397\|gb\|CP091735.1\|	1506	g17894	i0	73.413	2.07948717948718	252	48	63	13	87	330	1181465	1181705	MAG: Clostridium sp. isolate nC29_bin.1.fa chromosome, complete genome	blastn	811	76.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
20969256	20969256	PRJNA594101_S_NODE_29157_length_316_cov_1.584362_g28855_i0	PRJNA594101	29157	316	1.584362	5.00658392	Clostridium botulinum	1491	Bacteria	Bacteria	58.4	6.36e-4	NTclustered	gi\|1944081129\|gb\|CP063959.1\|	1491	g28855	i0	90.698	0.272151898734177	43	4	14	0	20	62	1311206	1311164	Clostridium botulinum strain 3859/11 chromosome, complete genome	blastn	86	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
20969308	20969308	PRJNA594101_S_NODE_3557_length_844_cov_7.132296_g3311_i0	PRJNA594101	3557	844	7.132296	60.19657824	Bacillus thuringiensis	1428	Bacteria	Bacteria	65.8	1.09e-5	NTclustered	gi\|2324136775\|gb\|CP097257.1\|	1428	g3311	i0	93.182	0.158767772511848	44	3	5	0	216	259	5722768	5722811	Bacillus thuringiensis strain Bt Gxmzu777-1 chromosome, complete genome	blastn	134	65.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
23519460	23519460	PRJNA594101_S_NODE_34019_length_296_cov_1.035874_g33717_i0	PRJNA594101	34019	296	1.035874	3.06618704	Clostridiales bacterium	1898207	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1928725541\|gb\|CP042469.1\|	1898207	g33717	i0	100	0.097972972972973	29	0	10	0	117	145	806583	806555	Clostridiales bacterium strain MT110 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
24091380	24091380	PRJNA594101_S_NODE_5739_length_679_cov_2.336634_g5451_i0	PRJNA594101	5739	679	2.336634	15.86574486	Bacillales	1385	Bacteria	Bacteria	60.2	4.05e-4	NTclustered	gi\|873407766\|gb\|CP012024.1\|	1479	g5451	i0	100	0.147275405007364	32	0	5	0	120	151	1331172	1331203	Bacillus smithii strain DSM 4216, complete genome	blastn	100	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus smithii
24793323	24793323	PRJNA594101_S_NODE_47200_length_254_cov_2.861878_g46898_i0	PRJNA594101	47200	254	2.861878	7.26917012	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	97.1	1.05e-15	NTclustered	gi\|2250069141\|gb\|CP098411.1\|	1597	g46898	i0	85.106	11.8228346456693	94	14	43	0	95	188	434959	434866	Lacticaseibacillus paracasei strain 401 chromosome, complete genome	blastn	3003	97.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei

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