metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJEB55250" and tax

33 rows where analysis = "blastn", bioproject = "PRJEB55250" 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
121788	121788	PRJEB55250_P_NODE_16521_length_241_cov_0.916667_g16397_i0	PRJEB55250	16521	241	0.916667	2.20916747	Fictibacillus sp. JL2B1089	3399565	Bacteria	Bacteria	351	1.91e-92	NTclustered	gi\|2917482651\|gb\|CP182294.1\|	3399565	g16397	i0	92.975	2.01659751037344	242	16	100	1	1	241	4020661	4020902	Fictibacillus sp. JL2B1089 chromosome, complete genome	blastn	486	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Fictibacillus	Fictibacillus sp. JL2B1089
991832	991832	PRJEB55250_P_NODE_12541_length_249_cov_0.875000_g12417_i0	PRJEB55250	12541	249	0.875	2.17875	Streptococcus	1301	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g12417	i0	100	100	249	0	100	0	1	249	883408	883160	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
991846	991846	PRJEB55250_P_NODE_14081_length_246_cov_0.890173_g13957_i0	PRJEB55250	14081	246	0.890173	2.18982558	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2669657801\|gb\|CP090014.1\|	1290	g13957	i0	100	91.6626016260163	246	0	100	0	1	246	105352	105597	Staphylococcus hominis strain acrlk chromosome, complete genome	blastn	22549	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
2672016	2672016	PRJEB55250_P_NODE_9383_length_266_cov_1.284974_g9259_i0	PRJEB55250	9383	266	1.284974	3.41803084	Bacillus sp. Y1	352858	Bacteria	Bacteria	381	2.7299999999999996e-101	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g9259	i0	92.481	1.21428571428571	266	20	100	0	1	266	3118130	3118395	Bacillus sp. Y1 chromosome, complete genome	blastn	323	381	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
7774107	7774107	PRJEB55250_P_NODE_12567_length_249_cov_0.875000_g12443_i0	PRJEB55250	12567	249	0.875	2.17875	Priestia filamentosa	1402861	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|1021457645\|gb\|CP015325.1\|	1402861	g12443	i0	84.492	1.49397590361446	187	24	73	3	1	183	41058	41243	Priestia filamentosa strain Hbe603 plasmid pBEH3, complete sequence	blastn	372	180	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia filamentosa
7774310	7774310	PRJEB55250_P_NODE_7007_length_284_cov_1.459716_g6883_i0	PRJEB55250	7007	284	1.459716	4.14559344	Staphylococcus epidermidis	1282	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|2505679996\|gb\|CP118820.1\|	1282	g6883	i0	100	100	284	0	100	0	1	284	1036994	1037277	Staphylococcus epidermidis strain 7057 chromosome, complete genome	blastn	28400	525	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8645011	8645011	PRJEB55250_P_NODE_17067_length_231_cov_2.474684_g16943_i0	PRJEB55250	17067	231	2.474684	5.71652004	Staphylococcus	1279	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g16943	i0	100	444.969696969697	231	0	100	0	1	231	707010	707240	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	102788	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
9048907	9048907	PRJEB55250_P_NODE_11668_length_251_cov_0.865169_g11544_i0	PRJEB55250	11668	251	0.865169	2.17157419	Bacillus sp. Y1	352858	Bacteria	Bacteria	366	7.15e-97	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g11544	i0	93.173	5	249	17	99	0	3	251	4236315	4236067	Bacillus sp. Y1 chromosome, complete genome	blastn	1255	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
9920006	9920006	PRJEB55250_P_NODE_12348_length_249_cov_1.750000_g12224_i0	PRJEB55250	12348	249	1.75	4.3575	Bacillus	1386	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2550811076\|gb\|CP130288.1\|	1396	g12224	i0	100	18.7710843373494	249	0	100	0	1	249	11457	11705	Bacillus cereus strain Z4 plasmid unnamed4, complete sequence	blastn	4674	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
9920036	9920036	PRJEB55250_P_NODE_14748_length_244_cov_2.678363_g14624_i0	PRJEB55250	14748	244	2.678363	6.53520572	Enterococcus	1350	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g14624	i0	100	67.2704918032787	244	0	100	0	1	244	3232687	3232444	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	16414	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
10324899	10324899	PRJEB55250_P_NODE_6469_length_288_cov_1.916279_g6345_i0	PRJEB55250	6469	288	1.916279	5.51888352	Bacillus sp. Y1	352858	Bacteria	Bacteria	453	6.25e-123	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g6345	i0	95.423	79.1493055555556	284	13	99	0	5	288	67672	67389	Bacillus sp. Y1 chromosome, complete genome	blastn	22795	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
11195284	11195284	PRJEB55250_P_NODE_9689_length_263_cov_2.094737_g9565_i0	PRJEB55250	9689	263	2.094737	5.50915831	Staphylococcus	1279	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g9565	i0	100	99.6958174904943	263	0	100	0	1	263	1340243	1339981	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	26220	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
11600038	11600038	PRJEB55250_P_NODE_10690_length_256_cov_1.683060_g10566_i0	PRJEB55250	10690	256	1.68306	4.3086336	Staphylococcus epidermidis	1282	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|2522199385\|gb\|CP127869.1\|	1282	g10566	i0	100	99.265625	256	0	100	0	1	256	322965	322710	Staphylococcus epidermidis strain NG02 chromosome, complete genome	blastn	25412	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11600045	11600045	PRJEB55250_P_NODE_10950_length_254_cov_1.701657_g10826_i0	PRJEB55250	10950	254	1.701657	4.32220878	Staphylococcus epidermidis	1282	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g10826	i0	100	100	254	0	100	0	1	254	2367561	2367308	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	25400	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11600134	11600134	PRJEB55250_P_NODE_14470_length_245_cov_0.895349_g14346_i0	PRJEB55250	14470	245	0.895349	2.19360505	Bacillus sp. Y1	352858	Bacteria	Bacteria	364	2.5e-96	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g14346	i0	93.469	1	245	16	100	0	1	245	3689477	3689233	Bacillus sp. Y1 chromosome, complete genome	blastn	245	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
11600158	11600158	PRJEB55250_P_NODE_15470_length_243_cov_0.905882_g15346_i0	PRJEB55250	15470	243	0.905882	2.20129326	Bacillus sp. Y1	352858	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g15346	i0	98.354	4.62551440329218	243	4	100	0	1	243	3187973	3188215	Bacillus sp. Y1 chromosome, complete genome	blastn	1124	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
12470815	12470815	PRJEB55250_P_NODE_14570_length_245_cov_0.895349_g14446_i0	PRJEB55250	14570	245	0.895349	2.19360505	Planococcus	1372	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2851047638\|gb\|CP087726.1\|	200991	g14446	i0	100	4	245	0	100	0	1	245	753673	753429	Planococcus rifietoensis strain QJJ-917 chromosome, complete genome	blastn	980	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus rifietoensis
13745224	13745224	PRJEB55250_P_NODE_10251_length_259_cov_2.069892_g10127_i0	PRJEB55250	10251	259	2.069892	5.36102028	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2633045940\|gb\|CP132148.1\|	1496	g10127	i0	92.5	1.50965250965251	40	2	15	1	100	139	117172	117134	Clostridioides difficile strain SC084-01-01 plasmid p840101_2, complete sequence	blastn	391	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
14150001	14150001	PRJEB55250_P_NODE_11792_length_251_cov_0.865169_g11668_i0	PRJEB55250	11792	251	0.865169	2.17157419	Bacillus sp. Y1	352858	Bacteria	Bacteria	392	1.18e-104	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g11668	i0	94.821	1	251	13	100	0	1	251	650646	650896	Bacillus sp. Y1 chromosome, complete genome	blastn	251	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
15424276	15424276	PRJEB55250_P_NODE_7293_length_282_cov_1.239234_g7169_i0	PRJEB55250	7293	282	1.239234	3.49463988	Streptococcus infantarius	102684	Bacteria	Bacteria	508	1.28e-139	NTclustered	gi\|1948576487\|gb\|CP065994.1\|	102684	g7169	i0	99.291	16.9574468085106	282	1	100	1	1	282	1451052	1451332	Streptococcus infantarius strain FDAARGOS_1019 chromosome, complete genome	blastn	4782	508	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantarius
16698400	16698400	PRJEB55250_P_NODE_14754_length_244_cov_2.368421_g14630_i0	PRJEB55250	14754	244	2.368421	5.77894724	Amygdalobacter nucleatus	3029274	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2452650939\|gb\|CP118869.1\|	3029274	g14630	i0	99.59	1	244	1	100	0	1	244	1348547	1348790	Amygdalobacter nucleatus strain ACE 1-034E1-9, complete genome	blastn	244	446	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Amygdalobacter	Amygdalobacter nucleatus
16698426	16698426	PRJEB55250_P_NODE_16034_length_242_cov_0.911243_g15910_i0	PRJEB55250	16034	242	0.911243	2.20520806	Anaerococcus vaginalis	33037	Bacteria	Bacteria	375	1.14e-99	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g15910	i0	94.628	86.7768595041322	242	13	100	0	1	242	776167	775926	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	21000	375	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
17973325	17973325	PRJEB55250_P_NODE_14555_length_245_cov_0.895349_g14431_i0	PRJEB55250	14555	245	0.895349	2.19360505	Jeotgalicoccus sp. ATCC 8456	946435	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g14431	i0	99.59	0.995918367346939	244	1	99	0	2	245	1537127	1537370	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	244	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
17973506	17973506	PRJEB55250_P_NODE_8015_length_276_cov_1.517241_g7891_i0	PRJEB55250	8015	276	1.517241	4.18758516	Bacillus sp. Y1	352858	Bacteria	Bacteria	399	7.869999999999998e-107	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g7891	i0	92.754	1	276	20	100	0	1	276	2295813	2296088	Bacillus sp. Y1 chromosome, complete genome	blastn	276	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
20522663	20522663	PRJEB55250_P_NODE_15937_length_242_cov_0.911243_g15813_i0	PRJEB55250	15937	242	0.911243	2.20520806	Bacillus sp. Y1	352858	Bacteria	Bacteria	359	1.15e-94	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g15813	i0	93.388	1	242	16	100	0	1	242	325275	325516	Bacillus sp. Y1 chromosome, complete genome	blastn	242	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
21798374	21798374	PRJEB55250_P_NODE_12158_length_250_cov_0.870056_g12034_i0	PRJEB55250	12158	250	0.870056	2.17514	Bacillus sp. Y1	352858	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g12034	i0	98.406	7.172	251	3	100	1	1	250	4004021	4003771	Bacillus sp. Y1 chromosome, complete genome	blastn	1793	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
21798612	21798612	PRJEB55250_P_NODE_7458_length_280_cov_2.710145_g7334_i0	PRJEB55250	7458	280	2.710145	7.588406	Bacillus sp. Y1	352858	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g7334	i0	100	1003.41071428571	280	0	100	0	1	280	12356	12635	Bacillus sp. Y1 chromosome, complete genome	blastn	280955	518	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
23073681	23073681	PRJEB55250_P_NODE_11799_length_251_cov_0.865169_g11675_i0	PRJEB55250	11799	251	0.865169	2.17157419	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	285	2.06e-72	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g11675	i0	94.595	20.9521912350598	185	9	74	1	67	251	441751	441934	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	5259	285	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
23073747	23073747	PRJEB55250_P_NODE_14279_length_245_cov_1.831395_g14155_i0	PRJEB55250	14279	245	1.831395	4.48691775	Faecalicatena sp. Marseille-Q4148	2823316	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2031376327\|gb\|CP073692.1\|	2823316	g14155	i0	100	0.114285714285714	28	0	11	0	153	180	333841	333814	Faecalicatena sp. Marseille-Q4148 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Faecalicatena	Faecalicatena sp. Marseille-Q4148
23073761	23073761	PRJEB55250_P_NODE_15019_length_244_cov_0.900585_g14895_i0	PRJEB55250	15019	244	0.900585	2.1974274	Bacillus sp. Y1	352858	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g14895	i0	96.721	14.4918032786885	244	8	100	0	1	244	2872113	2872356	Bacillus sp. Y1 chromosome, complete genome	blastn	3536	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
23073769	23073769	PRJEB55250_P_NODE_15299_length_243_cov_1.811765_g15175_i0	PRJEB55250	15299	243	1.811765	4.40258895	Bacillus sp. Y1	352858	Bacteria	Bacteria	383	6.84e-102	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g15175	i0	95.062	1.48559670781893	243	12	100	0	1	243	3528478	3528720	Bacillus sp. Y1 chromosome, complete genome	blastn	361	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
24347470	24347470	PRJEB55250_P_NODE_10000_length_261_cov_1.638298_g9876_i0	PRJEB55250	10000	261	1.638298	4.27595778	Ezakiella massiliensis	1852374	Bacteria	Bacteria	433	7.27e-117	NTclustered	gi\|1104678117\|emb\|LT635475.1\|	1852374	g9876	i0	96.552	1	261	9	100	0	1	261	312345	312605	Ezakiella sp. Marseille-P2951 strain Marseille-P2951T genome assembly, chromosome: contig00001	blastn	261	433	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella massiliensis
24347534	24347534	PRJEB55250_P_NODE_12740_length_249_cov_0.875000_g12616_i0	PRJEB55250	12740	249	0.875	2.17875	Macrococcus bovicus	69968	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2529040664\|gb\|CP128470.1\|	69968	g12616	i0	99.598	3	249	1	100	0	1	249	1831836	1831588	Macrococcus bovicus strain LI0213 chromosome LI0213, complete sequence	blastn	747	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus bovicus

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