metadata: contig_metadata: 31 rows where bioproject = "PRJNA287283" and tax

31 rows where bioproject = "PRJNA287283" 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
372219	372219	PRJNA287283_P_NODE_9661_length_178_cov_0.896000_g9437_i0	PRJNA287283	9661	178	0.896	1.59488	Streptococcus parasuis	1501662	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|2529181809\|gb\|CP128410.1\|	1501662	g9437	i0	100	18	178	0	100	0	1	178	1459322	1459145	Streptococcus parasuis strain 7500 chromosome, complete genome	blastn	3204	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasuis
1059220	1059220	PRJNA287283_P_NODE_10241_length_176_cov_0.910569_g10017_i0	PRJNA287283	10241	176	0.910569	1.60260144	Peptacetobacter	2743582	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1957925084\|gb\|CP066811.1\|	89152	g10017	i0	100	1029.90340909091	176	0	100	0	1	176	18290	18465	Peptacetobacter hiranonis strain DGF055142 chromosome, complete genome	blastn	181263	326	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptacetobacter	Peptacetobacter hiranonis
1646953	1646953	PRJNA287283_P_NODE_8522_length_183_cov_0.861538_g8298_i0	PRJNA287283	8522	183	0.861538	1.57661454	Streptococcus gordonii	1302	Bacteria	Bacteria	333	4.97e-87	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g8298	i0	99.454	14.0109289617486	183	1	100	0	1	183	868894	868712	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	2564	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
2922860	2922860	PRJNA287283_P_NODE_9463_length_179_cov_0.888889_g9239_i0	PRJNA287283	9463	179	0.888889	1.59111131	Carnobacterium inhibens	147709	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|554508411\|gb\|CP006812.1\|	1266845	g9239	i0	97.765	354.620111731844	179	4	100	0	1	179	132925	132747	Carnobacterium inhibens subsp. gilichinskyi strain WN1359 chromosome, complete genome	blastn	63477	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium inhibens
3609721	3609721	PRJNA287283_P_NODE_10223_length_176_cov_0.910569_g9999_i0	PRJNA287283	10223	176	0.910569	1.60260144	Bacillus	1386	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1339799779\|gb\|CP026522.1\|	1402	g9999	i0	100	100	176	0	100	0	1	176	3346844	3346669	Bacillus licheniformis strain MBGJa67 chromosome	blastn	17600	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
3609732	3609732	PRJNA287283_P_NODE_8003_length_189_cov_1.058824_g7779_i0	PRJNA287283	8003	189	1.058824	2.00117736	Granulicatella	117563	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g7779	i0	99.471	693.359788359788	189	1	100	0	1	189	1631380	1631568	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	131045	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
4887136	4887136	PRJNA287283_P_NODE_4264_length_303_cov_2.936000_g4040_i0	PRJNA287283	4264	303	2.936	8.89608	Streptococcus	1301	Bacteria	Bacteria	545	1.06e-150	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g4040	i0	100	335.871287128713	295	0	97	0	1	295	1571587	1571293	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	101769	545	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
4887140	4887140	PRJNA287283_P_NODE_9704_length_178_cov_0.896000_g9480_i0	PRJNA287283	9704	178	0.896	1.59488	Bacillus	1386	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1721134181\|emb\|LR698983.1\|	1402	g9480	i0	100	100	178	0	100	0	1	178	695522	695345	Bacillus licheniformis isolate MGYG-HGUT-02357 genome assembly, chromosome: 1	blastn	17800	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
7437100	7437100	PRJNA287283_P_NODE_8846_length_181_cov_1.593750_g8622_i0	PRJNA287283	8846	181	1.59375	2.8846875	Finegoldia	150022	Bacteria	Bacteria	252	1.41e-62	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g8622	i0	91.803	95.0552486187845	183	12	100	2	1	181	163346	163527	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	17205	252	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
7437101	7437101	PRJNA287283_P_NODE_9386_length_179_cov_0.888889_g9162_i0	PRJNA287283	9386	179	0.888889	1.59111131	Bacillus	1386	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1339799779\|gb\|CP026522.1\|	1402	g9162	i0	100	100	179	0	100	0	1	179	2540647	2540469	Bacillus licheniformis strain MBGJa67 chromosome	blastn	17900	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
8711874	8711874	PRJNA287283_P_NODE_5987_length_236_cov_1.852459_g5763_i0	PRJNA287283	5987	236	1.852459	4.37180324	Anoxybacillus	150247	Bacteria	Bacteria	431	2.33e-116	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g5763	i0	99.576	903.351694915254	236	1	100	0	1	236	1490564	1490799	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	213191	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
9300259	9300259	PRJNA287283_P_NODE_7028_length_208_cov_1.445161_g6804_i0	PRJNA287283	7028	208	1.445161	3.00593488	Veillonella rogosae	423477	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|2446175566\|gb\|CP117967.1\|	423477	g6804	i0	100	550.346153846154	208	0	100	0	1	208	1006782	1006989	Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome	blastn	114472	385	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
9987319	9987319	PRJNA287283_P_NODE_9948_length_177_cov_0.903226_g9724_i0	PRJNA287283	9948	177	0.903226	1.59871002	Lactobacillales	186826	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|2557228072\|gb\|CP054420.1\|	1252	g9724	i0	100	98.6045197740113	177	0	100	0	1	177	3387	3563	Leuconostoc carnosum strain 4010 plasmid pLC4010-2, complete sequence	blastn	17453	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc carnosum
11850835	11850835	PRJNA287283_P_NODE_8750_length_182_cov_0.868217_g8526_i0	PRJNA287283	8750	182	0.868217	1.58015494	Exiguobacterium alkaliphilum	1428684	Bacteria	Bacteria	326	8.260000000000001e-85	NTclustered	gi\|2029360986\|gb\|CP073101.1\|	1428684	g8526	i0	98.901	7.32967032967033	182	2	100	0	1	182	2212728	2212909	Exiguobacterium alkaliphilum strain B-3531D chromosome, complete genome	blastn	1334	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium alkaliphilum
12537688	12537688	PRJNA287283_P_NODE_10110_length_176_cov_0.910569_g9886_i0	PRJNA287283	10110	176	0.910569	1.60260144	Staphylococcus	1279	Bacteria	Bacteria	283	4.839999999999999e-72	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g9886	i0	100	12.0340909090909	153	0	87	0	24	176	1532642	1532490	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	2118	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
13812568	13812568	PRJNA287283_P_NODE_10031_length_176_cov_2.195122_g9807_i0	PRJNA287283	10031	176	2.195122	3.86341472	Streptococcus	1301	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1539757975\|emb\|LR134292.1\|	1335	g9807	i0	100	530.011363636364	176	0	100	0	1	176	6442	6617	Streptococcus equinus strain NCTC10389 genome assembly, chromosome: 1	blastn	93282	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
13812574	13812574	PRJNA287283_P_NODE_9691_length_178_cov_0.896000_g9467_i0	PRJNA287283	9691	178	0.896	1.59488	Anoxybacillus	150247	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g9467	i0	100	940.651685393258	178	0	100	0	1	178	1490479	1490302	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	167436	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
15086788	15086788	PRJNA287283_P_NODE_9652_length_178_cov_0.896000_g9428_i0	PRJNA287283	9652	178	0.896	1.59488	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|1963777636\|emb\|LR962307.1\|	1351	g9428	i0	100	106	178	0	100	0	1	178	14603	14780	Enterococcus faecalis isolate 27725_1#8 genome assembly, plasmid: 2	blastn	18868	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
16949574	16949574	PRJNA287283_P_NODE_3754_length_328_cov_1.661818_g3530_i0	PRJNA287283	3754	328	1.661818	5.45076304	Planococcus halotolerans	2233542	Bacteria	Bacteria	595	1.1399999999999998e-165	NTclustered	gi\|1590409075\|gb\|MK618646.1\|	2233542	g3530	i0	99.692	162.896341463415	325	1	99	0	1	325	325	1	Planococcus halotolerans strain IITR55 16S ribosomal RNA gene, partial sequence	blastn	53430	595	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus halotolerans
16949576	16949576	PRJNA287283_P_NODE_5614_length_247_cov_1.649485_g5390_i0	PRJNA287283	5614	247	1.649485	4.07422795	Aerococcus viridans	1377	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g5390	i0	97.973	344.817813765182	148	2	60	1	1	147	25687	25834	Aerococcus viridans strain CCUG4311, complete genome	blastn	85170	255	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
17636810	17636810	PRJNA287283_P_NODE_4654_length_285_cov_1.594828_g4430_i0	PRJNA287283	4654	285	1.594828	4.5452598	Leuconostoc	1243	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|846358970\|gb\|KR857408.1\|	1244	g4430	i0	98.601	103.361403508772	286	3	100	1	1	285	445	730	Leuconostoc gelidum strain AS-97 16S ribosomal RNA gene, partial sequence	blastn	29458	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc gelidum
18223852	18223852	PRJNA287283_P_NODE_8495_length_183_cov_0.861538_g8271_i0	PRJNA287283	8495	183	0.861538	1.57661454	Anaerococcus prevotii	33034	Bacteria	Bacteria	239	1.11e-58	NTclustered	gi\|256797400\|gb\|CP001708.1\|	525919	g8271	i0	90.556	0.983606557377049	180	17	98	0	2	181	1479380	1479559	Anaerococcus prevotii DSM 20548, complete genome	blastn	180	239	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
21460942	21460942	PRJNA287283_P_NODE_8937_length_181_cov_0.875000_g8713_i0	PRJNA287283	8937	181	0.875	1.58375	Bacillus	1386	Bacteria	Bacteria	313	6.39e-81	NTclustered	gi\|1453193303\|gb\|CP031643.1\|	1392	g8713	i0	97.79	98.8674033149171	181	4	100	0	1	181	4554132	4553952	Bacillus anthracis strain MCCC 1A01412 chromosome, complete genome	blastn	17895	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
23324225	23324225	PRJNA287283_P_NODE_7699_length_194_cov_1.539007_g7475_i0	PRJNA287283	7699	194	1.539007	2.98567358	Thermaerobacillus caldiproteolyticus	247480	Bacteria	Bacteria	337	4.13e-88	NTclustered	gi\|1929914214\|gb\|CP064060.1\|	247480	g7475	i0	97.938	779.963917525773	194	4	100	0	1	194	3682256	3682063	Thermaerobacillus caldiproteolyticus strain U458 chromosome, complete genome	blastn	151313	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Thermaerobacillus	Thermaerobacillus caldiproteolyticus
27358794	27358794	PRJNA287283_P_NODE_3843_length_323_cov_4.848148_g3619_i0	PRJNA287283	3843	323	4.848148	15.65951804	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	47.4	1.52e-4	NR	WP_233005565.1	33987	g3619	i0	88.9	0.25077399380805	27	3	25.1	0	112	32	30	56	WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum]	diamond	81	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
27390387	27390387	PRJNA287283_P_NODE_7363_length_201_cov_0.945946_g7139_i0	PRJNA287283	7363	201	0.945946	1.90135146	Listeria monocytogenes	1639	Bacteria	Bacteria	54.7	4.75e-8	NR	WP_369698196.1	1639	g7139	i0	100	0.343283582089552	23	0	34.3	0	49	117	38	60	WP_369698196.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	69	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28400605	28400605	PRJNA287283_P_NODE_7786_length_193_cov_0.864286_g7562_i0	PRJNA287283	7786	193	0.864286	1.66807198	Listeria monocytogenes	1639	Bacteria	Bacteria	53.1	1.86e-7	NR	WP_369698293.1	1639	g7562	i0	82.4	1.50777202072539	34	2	46.6	1	191	102	31	64	WP_369698293.1 hypothetical protein [Listeria monocytogenes]	diamond	291	53.5	0.992523364485981	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29252840	29252840	PRJNA287283_P_NODE_9349_length_179_cov_0.888889_g9125_i0	PRJNA287283	9349	179	0.888889	1.59111131	Streptococcus mitis	28037	Bacteria	Bacteria	120	4.17e-31	NR	WP_414309482.1	28037	g9125	i0	100	0.988826815642458	59	0	98.9	0	178	2	125	183	WP_414309482.1 AAA family ATPase [Streptococcus mitis]	diamond	177	120	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
29284474	29284474	PRJNA287283_P_NODE_7229_length_204_cov_0.920530_g7005_i0	PRJNA287283	7229	204	0.92053	1.8778812	Listeria monocytogenes	1639	Bacteria	Bacteria	67.4	4.16e-12	NR	WP_369698292.1	1639	g7005	i0	62.7	0.985294117647059	67	23	98.5	1	2	202	77	141	WP_369698292.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	201	67.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
31622724	31622724	PRJNA287283_P_NODE_7276_length_203_cov_0.773333_g7052_i0	PRJNA287283	7276	203	0.773333	1.56986599	Listeria monocytogenes	1639	Bacteria	Bacteria	127	1.7399999999999997e-35	NR	WP_369698296.1	1639	g7052	i0	100	3.96059113300493	67	0	99	0	2	202	62	128	WP_369698296.1 RNA-directed DNA polymerase, partial [Listeria monocytogenes]	diamond	804	127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32445600	32445600	PRJNA287283_P_NODE_3279_length_353_cov_0.956667_g3055_i0	PRJNA287283	3279	353	0.956667	3.37703451	Listeria monocytogenes	1639	Bacteria	Bacteria	67.8	8.23e-12	NR	WP_369698193.1	1639	g3055	i0	91.7	0.305949008498584	36	2	30.6	1	215	322	1	35	WP_369698193.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	108	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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