metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA416866" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA416866" 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
419623	419623	PRJNA416866_P_NODE_6041_length_265_cov_1.911765_g5897_i0	PRJNA416866	6041	265	1.911765	5.06617725	Staphylococcus hominis	1290	Bacteria	Bacteria	483	7.249999999999998e-132	NTclustered	gi\|1854288993\|gb\|CP054550.1\|	1290	g5897	i0	99.621	448.316981132075	264	1	99	0	2	265	1094342	1094079	Staphylococcus hominis strain FDAARGOS_661 chromosome, complete genome	blastn	118804	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
1083761	1083761	PRJNA416866_P_NODE_6421_length_257_cov_1.015306_g6277_i0	PRJNA416866	6421	257	1.015306	2.60933642	Staphylococcaceae	90964	Bacteria	Bacteria	464	2.5299999999999998e-126	NTclustered	gi\|2794445978\|dbj\|LC835073.1\|	1280	g6277	i0	99.222	395.910505836576	257	2	100	0	1	257	23531	23787	Staphylococcus aureus T4 plasmid pW4 DNA, complete sequence	blastn	101749	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
1694486	1694486	PRJNA416866_P_NODE_7482_length_237_cov_1.085227_g7338_i0	PRJNA416866	7482	237	1.085227	2.57198799	Gottfriedia acidiceleris	371036	Bacteria	Bacteria	412	8.47e-111	NTclustered	gi\|2230637776\|gb\|CP096034.1\|	371036	g7338	i0	98.298	1077.24894514768	235	4	99	0	3	237	13097	12863	Gottfriedia acidiceleris strain LH14 chromosome, complete genome	blastn	255308	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia acidiceleris
4246687	4246687	PRJNA416866_P_NODE_11844_length_201_cov_0.914286_g11700_i0	PRJNA416866	11844	201	0.914286	1.83771486	Staphylococcus hominis	1290	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2870745991\|gb\|CP134693.1\|	1290	g11700	i0	100	75.8955223880597	201	0	100	0	1	201	1246370	1246170	Staphylococcus hominis strain acrlw chromosome, complete genome	blastn	15255	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4246731	4246731	PRJNA416866_P_NODE_9284_length_211_cov_1.280000_g9140_i0	PRJNA416866	9284	211	1.28	2.7008	Gemella morbillorum	29391	Bacteria	Bacteria	385	1.61e-102	NTclustered	gi\|1403530627\|emb\|LS483440.1\|	29391	g9140	i0	99.526	480.78672985782	211	1	100	0	1	211	8880	9090	Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1	blastn	101446	385	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella morbillorum
6186799	6186799	PRJNA416866_P_NODE_3485_length_359_cov_1.271812_g3342_i0	PRJNA416866	3485	359	1.271812	4.56580508	Veillonella	29465	Bacteria	Bacteria	664	0	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g3342	i0	100	275.208913649025	359	0	100	0	1	359	80707	80349	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	98800	664	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
6797402	6797402	PRJNA416866_P_NODE_10326_length_206_cov_0.882759_g10182_i0	PRJNA416866	10326	206	0.882759	1.81848354	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g10182	i0	100	480.533980582524	206	0	100	0	1	206	779792	779997	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	98990	381	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
8072944	8072944	PRJNA416866_P_NODE_10127_length_207_cov_0.876712_g9983_i0	PRJNA416866	10127	207	0.876712	1.81479384	Staphylococcus epidermidis	1282	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g9983	i0	100	100	207	0	100	0	1	207	893358	893564	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	20700	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8072945	8072945	PRJNA416866_P_NODE_10207_length_207_cov_0.876712_g10063_i0	PRJNA416866	10207	207	0.876712	1.81479384	Staphylococcus epidermidis	1282	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g10063	i0	100	83.8067632850242	207	0	100	0	1	207	1026320	1026526	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	17348	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8072985	8072985	PRJNA416866_P_NODE_7307_length_239_cov_2.056180_g7163_i0	PRJNA416866	7307	239	2.05618	4.9142702	Clostridium thermarum	1716543	Bacteria	Bacteria	337	5.299999999999998e-88	NTclustered	gi\|1685740129\|gb\|CP040924.1\|	1716543	g7163	i0	92.083	991.083682008368	240	18	100	1	1	239	156924	157163	Clostridium thermarum strain SYSU GA15002 chromosome, complete genome	blastn	236869	337	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermarum
8736641	8736641	PRJNA416866_P_NODE_5247_length_286_cov_1.422222_g5103_i0	PRJNA416866	5247	286	1.422222	4.06755492	Veillonella	29465	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g5103	i0	100	696.755244755245	286	0	100	0	1	286	1701	1416	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	199272	529	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
9347714	9347714	PRJNA416866_P_NODE_11388_length_202_cov_3.531915_g11244_i0	PRJNA416866	11388	202	3.531915	7.1344683	Macrococcus sp. 21M1142	3395467	Bacteria	Bacteria	141	3.65e-29	NTclustered	gi\|2899131459\|gb\|CP179724.1\|	3395469	g11244	i0	80.423	179.668316831683	189	33	92	4	1	186	1823773	1823586	Macrococcus sp. 21M1142 chromosome, complete genome	blastn	36293	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus sp. 21M1142
11287011	11287011	PRJNA416866_P_NODE_3289_length_370_cov_1.404531_g3146_i0	PRJNA416866	3289	370	1.404531	5.1967647	Finegoldia	150022	Bacteria	Bacteria	678	0	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g3146	i0	99.73	374.672972972973	370	1	100	0	1	370	164134	163765	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	138629	678	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
11898496	11898496	PRJNA416866_P_NODE_6410_length_257_cov_1.306122_g6266_i0	PRJNA416866	6410	257	1.306122	3.35673354	Gottfriedia acidiceleris	371036	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2230637776\|gb\|CP096034.1\|	371036	g6266	i0	99.611	1262.96108949416	257	1	100	0	1	257	20361	20105	Gottfriedia acidiceleris strain LH14 chromosome, complete genome	blastn	324581	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia acidiceleris
14448517	14448517	PRJNA416866_P_NODE_11432_length_202_cov_1.361702_g11288_i0	PRJNA416866	11432	202	1.361702	2.75063804	Streptococcus sp. D7B5	3038077	Bacteria	Bacteria	285	1.59e-72	NTclustered	gi\|2484075149\|gb\|CP121467.1\|	3038077	g11288	i0	92.118	8.76732673267327	203	14	100	2	1	202	1177012	1177213	Streptococcus sp. D7B5 chromosome, complete genome	blastn	1771	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. D7B5
16386217	16386217	PRJNA416866_P_NODE_6053_length_265_cov_1.568627_g5909_i0	PRJNA416866	6053	265	1.568627	4.15686155	Bacilli	91061	Bacteria	Bacteria	259	1.33e-64	NTclustered	gi\|2083856584\|gb\|CP081199.1\|	1408	g5909	i0	95.122	400.633962264151	164	8	62	0	1	164	3287677	3287840	Bacillus pumilus strain EB138 chromosome, complete genome	blastn	106168	261	0.992337164750958	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pumilus
16386224	16386224	PRJNA416866_P_NODE_9133_length_212_cov_2.688742_g8989_i0	PRJNA416866	9133	212	2.688742	5.70013304	Enterococcus	1350	Bacteria	Bacteria	200	6.29e-47	NTclustered	gi\|11342510\|emb\|AJ295298.1\|	57732	g8989	i0	83.796	345.783018867925	216	29	99	6	1	211	1717	1503	Enterococcus asini 23S rRNA gene, strain DSM 11492T	blastn	73306	200	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus asini
18271274	18271274	PRJNA416866_P_NODE_11555_length_202_cov_0.907801_g11411_i0	PRJNA416866	11555	202	0.907801	1.83375802	Staphylococcus hominis	1290	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|1373834430\|emb\|LT963438.1\|	1290	g11411	i0	99.505	91.4356435643564	202	1	100	0	1	202	2210104	2209903	Staphylococcus hominis isolate Staphylococcus hominis J11 genome assembly, chromosome: I	blastn	18470	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
18935225	18935225	PRJNA416866_P_NODE_5835_length_270_cov_1.531100_g5691_i0	PRJNA416866	5835	270	1.5311	4.13397	Bacillota	1239	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2722736583\|dbj\|AP031486.1\|	1260	g5691	i0	100	102.988888888889	270	0	100	0	1	270	632031	631762	Finegoldia magna NBRC 113804 DNA, complete genome: sequence1	blastn	27807	499	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
19545452	19545452	PRJNA416866_P_NODE_11296_length_203_cov_0.901408_g11152_i0	PRJNA416866	11296	203	0.901408	1.82985824	Lachnoanaerobaculum umeaense	617123	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|1721134208\|emb\|LR699010.1\|	617123	g11152	i0	99.02	497.812807881773	204	1	100	1	1	203	1657920	1657717	Lachnoanaerobaculum umeaense isolate MGYG-HGUT-02522 genome assembly, chromosome: 1	blastn	101056	364	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum umeaense
19545480	19545480	PRJNA416866_P_NODE_3656_length_348_cov_1.710801_g3513_i0	PRJNA416866	3656	348	1.710801	5.95358748	Gemella haemolysans	1379	Bacteria	Bacteria	616	9.32e-172	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g3513	i0	98.563	484.310344827586	348	5	100	0	1	348	11076	10729	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	168540	616	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
19545498	19545498	PRJNA416866_P_NODE_6956_length_246_cov_1.448649_g6812_i0	PRJNA416866	6956	246	1.448649	3.56367654	Clostridium isatidis	182773	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2921984449\|gb\|CP182825.1\|	182773	g6812	i0	100	0.235772357723577	29	0	12	0	76	104	2562504	2562532	Clostridium isatidis strain BK32 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium isatidis
20821410	20821410	PRJNA416866_P_NODE_9057_length_213_cov_1.894737_g8913_i0	PRJNA416866	9057	213	1.894737	4.03578981	Gottfriedia acidiceleris	371036	Bacteria	Bacteria	383	5.8499999999999996e-102	NTclustered	gi\|2230637776\|gb\|CP096034.1\|	371036	g8913	i0	99.061	1228.55868544601	213	2	100	0	1	213	10779	10991	Gottfriedia acidiceleris strain LH14 chromosome, complete genome	blastn	261683	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia acidiceleris
21485467	21485467	PRJNA416866_P_NODE_4177_length_322_cov_2.770115_g4034_i0	PRJNA416866	4177	322	2.770115	8.9197703	Bacillati	1783272	Bacteria	Bacteria	588	1.8599999999999994e-163	NTclustered	gi\|2219585795\|gb\|CP094859.1\|	1282	g4034	i0	99.689	565.360248447205	322	0	100	1	1	322	794527	794847	Staphylococcus epidermidis strain C99 chromosome, complete genome	blastn	182046	588	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21485470	21485470	PRJNA416866_P_NODE_4897_length_297_cov_1.084746_g4753_i0	PRJNA416866	4897	297	1.084746	3.22169562	Latilactobacillus	2767885	Bacteria	Bacteria	545	1.04e-150	NTclustered	gi\|1031621101\|gb\|KU317787.1\|	1599	g4753	i0	99.663	169.986531986532	297	1	100	0	1	297	326	30	Lactobacillus sakei strain HC2 16S ribosomal RNA gene, partial sequence	blastn	50486	545	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Latilactobacillus	Latilactobacillus sakei
21485475	21485475	PRJNA416866_P_NODE_5857_length_270_cov_0.894737_g5713_i0	PRJNA416866	5857	270	0.894737	2.4157899	Peptostreptococcaceae	186804	Bacteria	Bacteria	333	7.8899999999999995e-87	NTclustered	gi\|2695214537\|gb\|CP124295.1\|	1505	g5713	i0	90.476	1060.92592592593	252	24	93	0	1	252	50106	49855	Paraclostridium sordellii strain C116 chromosome, complete genome	blastn	286450	333	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
21485485	21485485	PRJNA416866_P_NODE_8977_length_214_cov_2.091503_g8833_i0	PRJNA416866	8977	214	2.091503	4.47581642	Streptococcus	1301	Bacteria	Bacteria	390	3.519999999999999e-104	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g8833	i0	99.533	579.990654205607	214	1	100	0	1	214	17144	16931	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	124118	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
22096068	22096068	PRJNA416866_P_NODE_10878_length_204_cov_0.895105_g10734_i0	PRJNA416866	10878	204	0.895105	1.8260142	Staphylococcus arlettae	29378	Bacteria	Bacteria	370	4.33e-98	NTclustered	gi\|2313314935\|gb\|CP094806.1\|	29378	g10734	i0	99.51	502.289215686275	204	0	100	1	1	204	1129403	1129201	Staphylococcus arlettae strain IVB6234 chromosome, complete genome	blastn	102467	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
22096108	22096108	PRJNA416866_P_NODE_8098_length_227_cov_1.469880_g7954_i0	PRJNA416866	8098	227	1.46988	3.3366276	Gottfriedia acidiceleris	371036	Bacteria	Bacteria	409	1.04e-109	NTclustered	gi\|2230637776\|gb\|CP096034.1\|	371036	g7954	i0	99.119	905.383259911894	227	2	100	0	1	227	12586	12360	Gottfriedia acidiceleris strain LH14 chromosome, complete genome	blastn	205522	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia acidiceleris
24035507	24035507	PRJNA416866_P_NODE_1999_length_485_cov_1.514151_g1857_i0	PRJNA416866	1999	485	1.514151	7.34363235	Lachnospiraceae	186803	Bacteria	Bacteria	99	5.99e-16	NTclustered	gi\|2745850269\|gb\|CP125624.1\|	1531	g1857	i0	89.744	1.75257731958763	78	6	16	2	346	422	4984639	4984563	Enterocloster clostridioformis strain LM42 chromosome, complete genome	blastn	850	99	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster clostridioformis
24035518	24035518	PRJNA416866_P_NODE_4339_length_316_cov_2.313725_g4196_i0	PRJNA416866	4339	316	2.313725	7.311371	Veillonella	29465	Bacteria	Bacteria	573	5.109999999999998e-159	NTclustered	gi\|1835309918\|emb\|LR778174.1\|	29466	g4196	i0	99.367	494.721518987342	316	2	100	0	1	316	96938	96623	Veillonella parvula strain SKV38 genome assembly, chromosome: 1	blastn	156332	573	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
24646043	24646043	PRJNA416866_P_NODE_7860_length_230_cov_6.544379_g7716_i0	PRJNA416866	7860	230	6.544379	15.0520717	Tumebacillus algifaecis	1214604	Bacteria	Bacteria	392	1.07e-104	NTclustered	gi\|1229072455\|gb\|CP022657.1\|	1214604	g7716	i0	97.403	1063.14782608696	231	5	100	1	1	230	27691	27921	Tumebacillus algifaecis strain THMBR28, complete genome	blastn	244524	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Tumebacillus	Tumebacillus algifaecis

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