metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax

34 rows where analysis = "blastn", bioproject = "PRJEB17675" 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
21640	21640	PRJEB17675_P_NODE_10721_length_264_cov_0.873362_g10417_i0	PRJEB17675	10721	264	0.873362	2.30567568	Mesobacillus foraminis	279826	Bacteria	Bacteria	58.4	5.18e-4	NTclustered	gi\|1494009830\|gb\|CP033044.1\|	279826	g10417	i0	94.737	0.143939393939394	38	1	14	1	27	63	4503331	4503368	Mesobacillus foraminis strain Bac44 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus foraminis
1295816	1295816	PRJEB17675_P_NODE_10202_length_273_cov_1.273109_g9898_i0	PRJEB17675	10202	273	1.273109	3.47558757	Streptococcus sp. Marseille-Q6470	2972784	Bacteria	Bacteria	497	2.68e-136	NTclustered	gi\|2306632708\|emb\|OX336385.1\|	2972784	g9898	i0	99.632	326.798534798535	272	1	99	0	2	273	1040890	1041161	Streptococcus sp. Marseille-Q6470 genome assembly, chromosome: contig00001	blastn	89216	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q6470
1295859	1295859	PRJEB17675_P_NODE_22002_length_163_cov_5.937500_g21698_i0	PRJEB17675	22002	163	5.9375	9.678125	Hathewaya histolytica	1498	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g21698	i0	100	86.4294478527607	163	0	100	0	1	163	40613	40451	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	14088	302	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
2261144	2261144	PRJEB17675_P_NODE_662_length_1118_cov_3.868883_g540_i0	PRJEB17675	662	1118	3.868883	43.25411194	Intestinimonas	1392389	Bacteria	Bacteria	54.7	0.032	NTclustered	gi\|2766251240\|gb\|CP159998.1\|	1297617	g540	i0	90.698	0.115384615384615	43	0	4	4	209	250	1043599	1043638	Intestinimonas butyriciproducens strain AN405 chromosome	blastn	129	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Intestinimonas	Intestinimonas butyriciproducens
3847874	3847874	PRJEB17675_P_NODE_25144_length_151_cov_1.379310_g24840_i0	PRJEB17675	25144	151	1.37931	2.0827581	Hathewaya histolytica	1498	Bacteria	Bacteria	213	5.34e-51	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g24840	i0	94.853	0.900662251655629	136	7	90	0	16	151	2169253	2169388	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	136	213	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
4813694	4813694	PRJEB17675_P_NODE_6384_length_372_cov_3.833828_g6081_i0	PRJEB17675	6384	372	3.833828	14.26184016	Streptococcus	1301	Bacteria	Bacteria	671	0	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g6081	i0	99.194	578.010752688172	372	3	100	0	1	372	18604	18975	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	215020	671	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
5124034	5124034	PRJEB17675_P_NODE_12285_length_240_cov_1.219512_g11981_i0	PRJEB17675	12285	240	1.219512	2.9268288	Caldifermentibacillus hisashii	996558	Bacteria	Bacteria	67.6	7.71e-7	NTclustered	gi\|2781740904\|gb\|CP163263.1\|	996558	g11981	i0	93.333	0.508333333333333	45	3	19	0	124	168	984423	984467	Caldifermentibacillus hisashii strain FSL K6-2747 chromosome, complete genome	blastn	122	67.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldifermentibacillus	Caldifermentibacillus hisashii
5124035	5124035	PRJEB17675_P_NODE_12345_length_239_cov_1.764706_g12041_i0	PRJEB17675	12345	239	1.764706	4.21764734	Hathewaya histolytica	1498	Bacteria	Bacteria	73.1	1.65e-8	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g12041	i0	95.556	0.188284518828452	45	2	19	0	1	45	2168739	2168783	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	45	73.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
7363556	7363556	PRJEB17675_P_NODE_6906_length_355_cov_1.837500_g6603_i0	PRJEB17675	6906	355	1.8375	6.523125	Streptococcus	1301	Bacteria	Bacteria	641	1.5699999999999994e-179	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g6603	i0	99.433	555.538028169014	353	2	99	0	1	353	17037	16685	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	197216	641	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
7363557	7363557	PRJEB17675_P_NODE_7046_length_350_cov_1.739683_g6743_i0	PRJEB17675	7046	350	1.739683	6.0888905	Caldicellulosiruptor	44000	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|4836163\|gb\|AF078737.1\|AF078737	80339	g6743	i0	94.286	0.182857142857143	35	2	10	0	56	90	9226	9192	Caldicellulosiruptor sp. Tok7B.1 XynA (xynA) and CelB (celB) genes, complete cds; and unknown genes	blastn	64	54.7	1	Bacteria	Bacillati	Bacillota		Caldicellulosiruptorales	Caldicellulosiruptoraceae	Caldicellulosiruptor	Caldicellulosiruptor sp. Tok7B.1
8638936	8638936	PRJEB17675_P_NODE_16607_length_196_cov_3.248447_g16303_i0	PRJEB17675	16607	196	3.248447	6.36695612	Salinicoccus	45669	Bacteria	Bacteria	351	1.49e-92	NTclustered	gi\|1214736818\|gb\|CP020916.1\|	1437774	g16303	i0	98.98	532.801020408163	196	2	100	0	1	196	492599	492794	Salinicoccus sp. BAB 3246 strain BAB3246 chromosome, complete genome	blastn	104429	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus sp. BAB 3246
8948654	8948654	PRJEB17675_P_NODE_15308_length_207_cov_1.162791_g15004_i0	PRJEB17675	15308	207	1.162791	2.40697737	Pontibacillus chungwhensis	265426	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2513827645\|gb\|CP126446.1\|	265426	g15004	i0	96.774	0.14975845410628	31	1	15	0	177	207	3751723	3751753	Pontibacillus chungwhensis strain HN14 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus chungwhensis
8948702	8948702	PRJEB17675_P_NODE_428_length_1341_cov_2.422665_g346_i0	PRJEB17675	428	1341	2.422665	32.48793765	Waltera intestinalis	2606635	Bacteria	Bacteria	71.3	3.79e-7	NTclustered	gi\|2689837243\|dbj\|AP028995.1\|	2606635	g346	i0	89.286	0.170768083519761	56	6	11	0	94	149	1126793	1126848	Waltera intestinalis 19YCFAH0.3Co2 DNA, complete genome	blastn	229	71.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Waltera	Waltera intestinalis
10224381	10224381	PRJEB17675_P_NODE_129_length_1952_cov_7.406886_g106_i0	PRJEB17675	129	1952	7.406886	144.58241472	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	0.001	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g106	i0	100	0.0163934426229508	32	0	2	0	1008	1039	112237	112206	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
10224434	10224434	PRJEB17675_P_NODE_3069_length_562_cov_2.802657_g2799_i0	PRJEB17675	3069	562	2.802657	15.75093234	Hathewaya histolytica	1498	Bacteria	Bacteria	1005	0	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g2799	i0	98.932	8.01957295373665	562	6	100	0	1	562	2174675	2175236	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	4507	1005	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
10224463	10224463	PRJEB17675_P_NODE_949_length_976_cov_7.753454_g803_i0	PRJEB17675	949	976	7.753454	75.67371104	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	5.91e-4	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g803	i0	100	0.0327868852459016	32	0	3	0	56	87	112206	112237	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
12465012	12465012	PRJEB17675_P_NODE_17150_length_192_cov_2.089172_g16846_i0	PRJEB17675	17150	192	2.089172	4.01121024	Staphylococcus	1279	Bacteria	Bacteria	355	1.13e-93	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g16846	i0	100	474.234375	192	0	100	0	1	192	750508	750699	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	91053	355	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12775226	12775226	PRJEB17675_P_NODE_18571_length_183_cov_0.804054_g18267_i0	PRJEB17675	18571	183	0.804054	1.47141882	Hathewaya histolytica	1498	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g18267	i0	100	1.62295081967213	183	0	100	0	1	183	2165658	2165840	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	297	339	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
12775236	12775236	PRJEB17675_P_NODE_19911_length_174_cov_1.712230_g19607_i0	PRJEB17675	19911	174	1.71223	2.9792802	Hathewaya histolytica	1498	Bacteria	Bacteria	307	2.8300000000000005e-79	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g19607	i0	98.837	0.988505747126437	172	2	99	0	1	172	2168737	2168566	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	172	307	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
12775299	12775299	PRJEB17675_P_NODE_9351_length_288_cov_3.126482_g9047_i0	PRJEB17675	9351	288	3.126482	9.00426816	Ruminiclostridium cellulolyticum	1521	Bacteria	Bacteria	91.6	5.65e-14	NTclustered	gi\|219997787\|gb\|CP001348.1\|	394503	g9047	i0	87.5	43.9201388888889	80	9	27	1	96	174	4054877	4054956	Ruminiclostridium cellulolyticum H10 chromosome, complete genome	blastn	12649	91.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium cellulolyticum
13739304	13739304	PRJEB17675_P_NODE_11171_length_256_cov_1.638009_g10867_i0	PRJEB17675	11171	256	1.638009	4.19330304	Staphylococcus	1279	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|2521904872\|gb\|CP127705.1\|	1280	g10867	i0	99.609	547.28125	256	1	100	0	1	256	2019982	2019727	Staphylococcus aureus strain C351 chromosome, complete genome	blastn	140104	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13739308	13739308	PRJEB17675_P_NODE_19231_length_178_cov_2.363636_g18927_i0	PRJEB17675	19231	178	2.363636	4.20727208	root	1	Root_unresolved	Root_unresolved	324	2.89e-84	NTclustered	gi\|2211362869\|gb\|ON055621.1\|	1318	g18927	i0	99.438	103	178	1	100	0	1	178	395	218	Streptococcus parasanguinis strain RMB026 16S ribosomal RNA gene, partial sequence	blastn	18334	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
13739309	13739309	PRJEB17675_P_NODE_19971_length_174_cov_1.244604_g19667_i0	PRJEB17675	19971	174	1.244604	2.16561096	Anaerococcus	165779	Bacteria	Bacteria	287	3.69e-73	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g19667	i0	96.532	182.689655172414	173	6	99	0	2	174	1728	1556	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	31788	287	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
13739322	13739322	PRJEB17675_P_NODE_5891_length_391_cov_2.053371_g5591_i0	PRJEB17675	5891	391	2.053371	8.02868061	Streptococcus	1301	Bacteria	Bacteria	634	2.9199999999999996e-177	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g5591	i0	96.373	525.242966751918	386	12	98	2	7	391	162570	162954	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	205370	634	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
14049851	14049851	PRJEB17675_P_NODE_912_length_991_cov_2.991632_g771_i0	PRJEB17675	912	991	2.991632	29.64707312	Viridibacillus sp. JNUCC-6	263475	Bacteria	Bacteria	54.7	0.028	NTclustered	gi\|1927055251\|gb\|CP063302.1\|	2779527	g771	i0	100	0.029263370332997	29	0	3	0	737	765	1347299	1347271	Viridibacillus sp. JNUCC-6 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Viridibacillus	Viridibacillus sp. JNUCC-6
15323794	15323794	PRJEB17675_P_NODE_13313_length_227_cov_3.213542_g13009_i0	PRJEB17675	13313	227	3.213542	7.29474034	Peribacillus asahii	228899	Bacteria	Bacteria	58.4	4.35e-4	NTclustered	gi\|2257768765\|gb\|CP085720.1\|	228899	g13009	i0	100	0.136563876651982	31	0	14	0	55	85	2811942	2811972	Peribacillus asahii strain KF4 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus asahii
16288526	16288526	PRJEB17675_P_NODE_17293_length_191_cov_1.538462_g16989_i0	PRJEB17675	17293	191	1.538462	2.93846242	Staphylococcus	1279	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g16989	i0	100	102	191	0	100	0	1	191	2337617	2337807	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	19482	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16598533	16598533	PRJEB17675_P_NODE_894_length_995_cov_8.871875_g753_i0	PRJEB17675	894	995	8.871875	88.27515625	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	6.03e-4	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g753	i0	100	0.0321608040201005	32	0	3	0	905	936	112206	112237	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
17563720	17563720	PRJEB17675_P_NODE_22774_length_160_cov_1.568000_g22470_i0	PRJEB17675	22774	160	1.568	2.5088	Streptococcus	1301	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|1848533409\|gb\|CP053999.1\|	1338	g22470	i0	100	526.74375	160	0	100	0	1	160	183542	183383	Streptococcus intermedius strain FDAARGOS_769 chromosome, complete genome	blastn	84279	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus intermedius
19147099	19147099	PRJEB17675_P_NODE_12196_length_241_cov_1.747573_g11892_i0	PRJEB17675	12196	241	1.747573	4.21165093	Romboutsia sp. CE17	2724150	Bacteria	Bacteria	169	2.0599999999999997e-37	NTclustered	gi\|1831577921\|gb\|CP051144.1\|	2724150	g11892	i0	79.583	23.4190871369295	240	45	99	4	4	241	1188484	1188721	Romboutsia sp. CE17 chromosome, complete genome	blastn	5644	169	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. CE17
20422353	20422353	PRJEB17675_P_NODE_16097_length_200_cov_1.787879_g15793_i0	PRJEB17675	16097	200	1.787879	3.575758	Shouchella clausii	79880	Bacteria	Bacteria	220	4.5e-53	NTclustered	gi\|922061703\|gb\|CP012475.1\|	79880	g15793	i0	86.634	853.835	202	23	100	4	1	200	1887702	1887901	Bacillus clausii strain ENTPro, complete genome	blastn	170767	220	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
21387968	21387968	PRJEB17675_P_NODE_15797_length_202_cov_2.538922_g15493_i0	PRJEB17675	15797	202	2.538922	5.12862244	Staphylococcus	1279	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g15493	i0	99.505	547.004950495049	202	1	100	0	1	202	699823	700024	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	110495	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21698374	21698374	PRJEB17675_P_NODE_19218_length_178_cov_4.937063_g18914_i0	PRJEB17675	19218	178	4.937063	8.78797214	Hathewaya histolytica	1498	Bacteria	Bacteria	327	2.23e-85	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g18914	i0	100	0.99438202247191	177	0	99	0	2	178	1088837	1088661	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	177	327	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
22973672	22973672	PRJEB17675_P_NODE_6139_length_381_cov_2.930636_g5838_i0	PRJEB17675	6139	381	2.930636	11.16572316	Hathewaya histolytica	1498	Bacteria	Bacteria	669	0	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g5838	i0	99.457	95.7296587926509	368	2	97	0	1	368	756346	756713	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	36473	669	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica

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