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

34 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
434855	434855	PRJNA438572_P_NODE_12541_length_291_cov_1.403670_g12422_i0	PRJNA438572	12541	291	1.40367	4.0846797	Priestia megaterium	1404	Bacteria	Bacteria	62.1	4.48e-5	NTclustered	gi\|1586278148\|gb\|CP025700.2\|	1404	g12422	i0	97.222	1.35395189003436	36	1	12	0	248	283	4768061	4768026	Priestia megaterium strain STB1 chromosome	blastn	394	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
1709893	1709893	PRJNA438572_P_NODE_20882_length_247_cov_0.896552_g20763_i0	PRJNA438572	20882	247	0.896552	2.21448344	Streptococcus infantis	68892	Bacteria	Bacteria	361	3.27e-95	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g20763	i0	93.089	5.91093117408907	246	17	99	0	1	246	1594905	1595150	Streptococcus infantis strain SO chromosome, complete genome	blastn	1460	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
3642104	3642104	PRJNA438572_P_NODE_9883_length_326_cov_1.189723_g9764_i0	PRJNA438572	9883	326	1.189723	3.87849698	Bacteria	2	Bacteria	Bacteria	582	8.789999999999998e-162	NTclustered	gi\|2451579829\|gb\|CP118060.1\|	1283	g9764	i0	98.78	470.478527607362	328	2	100	1	1	326	855591	855918	Staphylococcus haemolyticus strain VSI35 chromosome, complete genome	blastn	153376	582	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
4262026	4262026	PRJNA438572_P_NODE_19004_length_250_cov_0.881356_g18885_i0	PRJNA438572	19004	250	0.881356	2.20339	Staphylococcus saprophyticus	29385	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2624851299\|gb\|CP120073.1\|	29385	g18885	i0	100	60.056	250	0	100	0	1	250	2250778	2250529	Staphylococcus saprophyticus strain Dog122 chromosome, complete genome	blastn	15014	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus
4262027	4262027	PRJNA438572_P_NODE_19264_length_250_cov_0.881356_g19145_i0	PRJNA438572	19264	250	0.881356	2.20339	Staphylococcus epidermidis	1282	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g19145	i0	100	100	250	0	100	0	1	250	1275004	1274755	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25000	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4262243	4262243	PRJNA438572_P_NODE_9464_length_332_cov_1.517375_g9345_i0	PRJNA438572	9464	332	1.517375	5.037685	Jeotgalicoccus sp. WY2	2708346	Bacteria	Bacteria	614	3.1799999999999995e-171	NTclustered	gi\|2043521547\|gb\|CP049818.1\|	2708346	g9345	i0	100	701.698795180723	332	0	100	0	1	332	734447	734116	Jeotgalicoccus sp. WY2 chromosome, complete genome	blastn	232964	614	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. WY2
5538601	5538601	PRJNA438572_P_NODE_13045_length_286_cov_1.990610_g12926_i0	PRJNA438572	13045	286	1.99061	5.6931446	Staphylococcus epidermidis	1282	Bacteria	Bacteria	523	4.659999999999998e-144	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g12926	i0	99.65	100	286	1	100	0	1	286	324310	324025	Staphylococcus epidermidis strain 9 chromosome	blastn	28600	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5538662	5538662	PRJNA438572_P_NODE_16365_length_256_cov_2.049180_g16246_i0	PRJNA438572	16365	256	2.04918	5.2459008	uncultured Paeniclostridium sp.	1849830	Bacteria	Bacteria	459	1.1699999999999999e-124	NTclustered	gi\|1899225345\|gb\|MT967814.1\|	1849830	g16246	i0	99.213	710.6171875	254	2	99	0	1	254	1952	2205	Uncultured Paeniclostridium sp. clone asv_313_2327 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	181918	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paeniclostridium	uncultured Paeniclostridium sp.
6194068	6194068	PRJNA438572_P_NODE_22445_length_245_cov_0.906977_g22326_i0	PRJNA438572	22445	245	0.906977	2.22209365	Enterococcus	1350	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2459064002\|gb\|CP119393.1\|	37734	g22326	i0	100	6	245	0	100	0	1	245	3001562	3001318	Enterococcus casseliflavus strain ASE4 chromosome, complete genome	blastn	1470	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
7469009	7469009	PRJNA438572_P_NODE_21286_length_246_cov_1.849711_g21167_i0	PRJNA438572	21286	246	1.849711	4.55028906	Romboutsia	1501226	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2034578690\|gb\|CP048740.1\|	2708052	g21167	i0	99.187	1161.16260162602	246	2	100	0	1	246	2509426	2509671	Romboutsia sp. 13154 chromosome	blastn	285646	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. 13154
8088190	8088190	PRJNA438572_P_NODE_19087_length_250_cov_0.881356_g18968_i0	PRJNA438572	19087	250	0.881356	2.20339	Paenibacillus sp. FSL K6-2441	2954679	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|2709489395\|gb\|CP150174.1\|	2954679	g18968	i0	95.2	2	250	12	100	0	1	250	4528445	4528694	Paenibacillus sp. FSL K6-2441 chromosome, complete genome	blastn	500	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL K6-2441
10638895	10638895	PRJNA438572_P_NODE_18269_length_251_cov_0.876404_g18150_i0	PRJNA438572	18269	251	0.876404	2.19977404	Streptococcus mitis	28037	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|927035354\|gb\|CP012646.1\|	28037	g18150	i0	99.602	100.378486055777	251	1	100	0	1	251	1261178	1261428	Streptococcus mitis strain KCOM 1350 (= ChDC B183), complete genome	blastn	25195	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
11294150	11294150	PRJNA438572_P_NODE_22509_length_245_cov_0.906977_g22390_i0	PRJNA438572	22509	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g22390	i0	99.592	477.914285714286	245	1	100	0	1	245	713	469	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	117089	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
11913811	11913811	PRJNA438572_P_NODE_23210_length_244_cov_0.894737_g23091_i0	PRJNA438572	23210	244	0.894737	2.18315828	Maliibacterium massiliense	2086585	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1494853420\|emb\|LR026983.1\|	2086585	g23091	i0	96.774	0.127049180327869	31	1	13	0	30	60	1069831	1069801	Christensenella sp. Marseille-P3954 genome assembly, chromosome: contig00001	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Maliibacteriaceae	Maliibacterium	Maliibacterium massiliense
13188646	13188646	PRJNA438572_P_NODE_17691_length_252_cov_0.871508_g17572_i0	PRJNA438572	17691	252	0.871508	2.19620016	Exiguobacterium sp. ZWU0009	1224749	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1109143385\|gb\|CP018057.1\|	1224749	g17572	i0	100	7.90873015873016	252	0	100	0	1	252	600167	599916	Exiguobacterium sp. ZWU0009, complete genome	blastn	1993	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. ZWU0009
13188717	13188717	PRJNA438572_P_NODE_21651_length_246_cov_0.901734_g21532_i0	PRJNA438572	21651	246	0.901734	2.21826564	Lactobacillus iners	147802	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g21532	i0	100	84.6788617886179	246	0	100	0	1	246	405717	405962	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	20831	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
13188852	13188852	PRJNA438572_P_NODE_6491_length_394_cov_0.897196_g6372_i0	PRJNA438572	6491	394	0.897196	3.53495224	Lactobacillus iners	147802	Bacteria	Bacteria	651	0	NTclustered	gi\|1818008110\|gb\|CP049223.1\|	147802	g6372	i0	96.456	420.862944162437	395	12	100	2	1	394	174828	174435	Lactobacillus iners strain C0094A1 chromosome, complete genome	blastn	165820	651	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
13844526	13844526	PRJNA438572_P_NODE_15791_length_262_cov_0.820106_g15672_i0	PRJNA438572	15791	262	0.820106	2.14867772	Geobacillus	129337	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g15672	i0	100	872.580152671756	262	0	100	0	1	262	94078	94339	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	228616	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
15737527	15737527	PRJNA438572_P_NODE_12333_length_293_cov_1.063636_g12214_i0	PRJNA438572	12333	293	1.063636	3.11645348	Lactobacillus helveticus	1587	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|2732034436\|gb\|CP155077.1\|	1587	g12214	i0	100	343.368600682594	293	0	100	0	1	293	87271	86979	Lactobacillus helveticus strain IMAUJBH1 chromosome, complete genome	blastn	100607	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus helveticus
15737553	15737553	PRJNA438572_P_NODE_13573_length_282_cov_1.119617_g13454_i0	PRJNA438572	13573	282	1.119617	3.15731994	Lactobacillus iners	147802	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g13454	i0	100	13	282	0	100	0	1	282	1058233	1057952	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	3666	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
15737656	15737656	PRJNA438572_P_NODE_19253_length_250_cov_0.881356_g19134_i0	PRJNA438572	19253	250	0.881356	2.20339	Streptococcus gordonii	1302	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g19134	i0	99.6	98.14	250	1	100	0	1	250	429777	430026	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	24535	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
17012337	17012337	PRJNA438572_P_NODE_19714_length_249_cov_0.886364_g19595_i0	PRJNA438572	19714	249	0.886364	2.20704636	Bacillus anthracis	1392	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|1858710516\|gb\|CP054801.1\|	1392	g19595	i0	98.394	650.036144578313	249	4	100	0	1	249	1384	1632	Bacillus anthracis strain FDAARGOS_702 plasmid unnamed1	blastn	161859	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
17012357	17012357	PRJNA438572_P_NODE_21174_length_247_cov_0.896552_g21055_i0	PRJNA438572	21174	247	0.896552	2.21448344	Abyssicoccus albus	1817405	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g21055	i0	98.785	1	247	3	100	0	1	247	1343699	1343945	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	247	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
17668614	17668614	PRJNA438572_P_NODE_11294_length_306_cov_1.291845_g11175_i0	PRJNA438572	11294	306	1.291845	3.9530457	Exiguobacterium	33986	Bacteria	Bacteria	566	8.239999999999998e-157	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g11175	i0	100	731.075163398693	306	0	100	0	1	306	13220	13525	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	223709	566	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
17668701	17668701	PRJNA438572_P_NODE_20694_length_247_cov_1.482759_g20575_i0	PRJNA438572	20694	247	1.482759	3.66241473	Staphylococcus	1279	Bacteria	Bacteria	403	5.35e-108	NTclustered	gi\|2452486025\|gb\|CP119115.1\|	1280	g20575	i0	96.694	1.96761133603239	242	8	98	0	6	247	578	819	Staphylococcus aureus strain GENOMIC22-002 plasmid pCFSAN126947_02, complete sequence	blastn	486	407	0.99017199017199	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18942471	18942471	PRJNA438572_P_NODE_19435_length_249_cov_0.886364_g19316_i0	PRJNA438572	19435	249	0.886364	2.20704636	Staphylococcus	1279	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2836169484\|gb\|CP048714.1\|	28035	g19316	i0	99.598	37.9839357429719	249	1	100	0	1	249	2554529	2554281	Staphylococcus lugdunensis strain CGMH-SL36 chromosome, complete genome	blastn	9458	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lugdunensis
19560907	19560907	PRJNA438572_P_NODE_17756_length_252_cov_0.871508_g17637_i0	PRJNA438572	17756	252	0.871508	2.19620016	Staphylococcus warneri	1292	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g17637	i0	100	22.9722222222222	252	0	100	0	1	252	92753	93004	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	5789	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20217244	20217244	PRJNA438572_P_NODE_20336_length_248_cov_0.891429_g20217_i0	PRJNA438572	20336	248	0.891429	2.21074392	Enterococcus	1350	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g20217	i0	100	19.8548387096774	248	0	100	0	1	248	2608093	2607846	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	4924	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
20217247	20217247	PRJNA438572_P_NODE_20796_length_247_cov_0.896552_g20677_i0	PRJNA438572	20796	247	0.896552	2.21448344	Pediococcus	1253	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1035434175\|gb\|CP015918.1\|	1255	g20677	i0	100	3.51417004048583	28	0	11	0	23	50	639126	639153	Pediococcus pentosaceus strain wikim20, complete genome	blastn	868	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
21492974	21492974	PRJNA438572_P_NODE_9777_length_327_cov_1.440945_g9658_i0	PRJNA438572	9777	327	1.440945	4.71189015	Bacteria	2	Bacteria	Bacteria	593	4.0699999999999987e-165	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g9658	i0	99.388	104.993883792049	327	2	100	0	1	327	1130403	1130729	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	34333	593	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
22111642	22111642	PRJNA438572_P_NODE_19678_length_249_cov_0.886364_g19559_i0	PRJNA438572	19678	249	0.886364	2.20704636	Finegoldia magna	1260	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g19559	i0	98.394	9.83935742971888	249	4	100	0	1	249	1104733	1104485	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	2450	438	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
22111644	22111644	PRJNA438572_P_NODE_19758_length_249_cov_0.886364_g19639_i0	PRJNA438572	19758	249	0.886364	2.20704636	Laceyella sacchari	37482	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2294964232\|gb\|CP103866.1\|	37482	g19639	i0	99.598	1	249	1	100	0	1	249	1847408	1847160	Laceyella sacchari strain FBKL4.014 chromosome, complete genome	blastn	249	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Laceyella	Laceyella sacchari
24661287	24661287	PRJNA438572_P_NODE_21600_length_246_cov_0.901734_g21481_i0	PRJNA438572	21600	246	0.901734	2.21826564	Paenibacillus sp. FSL R5-0345	1536770	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g21481	i0	99.593	32.520325203252	246	1	100	0	1	246	5941032	5941277	Paenibacillus sp. FSL R5-0345, complete genome	blastn	8000	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
24661312	24661312	PRJNA438572_P_NODE_23240_length_243_cov_2.376471_g23121_i0	PRJNA438572	23240	243	2.376471	5.77482453	Gemella morbillorum	29391	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|1403530627\|emb\|LS483440.1\|	29391	g23121	i0	97.942	3.11522633744856	243	5	100	0	1	243	832307	832549	Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1	blastn	757	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella morbillorum

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