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

31 rows where bioproject = "PRJDB14275" 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
8653	8653	PRJDB14275_P_NODE_6941_length_171_cov_1.446970_g6882_i0	PRJDB14275	6941	171	1.44697	2.4743187	Ruminococcus sp.	41978	Bacteria	Bacteria	93.2	7.09e-22	NR	MDR0983919.1	41978	g6882	i0	83	3.82456140350877	53	9	93	0	170	12	86	138	MDR0983919.1 ATP-dependent Clp protease proteolytic subunit [Ruminococcus sp.]	diamond	654	93.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
1282869	1282869	PRJDB14275_P_NODE_4942_length_228_cov_1.169312_g4883_i0	PRJDB14275	4942	228	1.169312	2.66603136	Salinicoccus halodurans	407035	Bacteria	Bacteria	339	1.3899999999999998e-88	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4883	i0	93.478	117.5	230	11	99	3	1	226	1914372	1914601	Salinicoccus halodurans strain H3B36, complete genome	blastn	26790	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
1282892	1282892	PRJDB14275_P_NODE_6962_length_171_cov_0.924242_g6903_i0	PRJDB14275	6962	171	0.924242	1.58045382	Streptococcus oralis	1303	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|1878158384\|gb\|CP054134.1\|	1891914	g6903	i0	100	100	171	0	100	0	1	171	602122	601952	Streptococcus oralis subsp. oralis strain SN51445 chromosome	blastn	17100	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
2558498	2558498	PRJDB14275_P_NODE_7823_length_158_cov_1.016807_g7764_i0	PRJDB14275	7823	158	1.016807	1.60655506	Staphylococcus epidermidis	1282	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2180327910\|gb\|CP090991.1\|	1282	g7764	i0	100	108.721518987342	158	0	100	0	1	158	5918	5761	Staphylococcus epidermidis strain 52B plasmid pSE52B-2, complete sequence	blastn	17178	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2558502	2558502	PRJDB14275_P_NODE_8503_length_150_cov_1.054054_g8444_i0	PRJDB14275	8503	150	1.054054	1.581081	Salinicoccus halodurans	407035	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g8444	i0	95.364	626.546666666667	151	6	100	1	1	150	375034	374884	Salinicoccus halodurans strain H3B36, complete genome	blastn	93982	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
3834794	3834794	PRJDB14275_P_NODE_4944_length_228_cov_0.962963_g4885_i0	PRJDB14275	4944	228	0.962963	2.19555564	Dolosigranulum pigrum	29394	Bacteria	Bacteria	416	6.259999999999998e-112	NTclustered	gi\|2020672664\|gb\|CP040417.1\|	29394	g4885	i0	99.561	44.0043859649123	228	1	100	0	1	228	575267	575494	Dolosigranulum pigrum strain KPL3077 chromosome	blastn	10033	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
3834827	3834827	PRJDB14275_P_NODE_8004_length_155_cov_1.750000_g7945_i0	PRJDB14275	8004	155	1.75	2.7125	Finegoldia magna	1260	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g7945	i0	100	14.6064516129032	155	0	100	0	1	155	182624	182470	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	2264	287	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
6084256	6084256	PRJDB14275_P_NODE_5085_length_222_cov_2.322404_g5026_i0	PRJDB14275	5085	222	2.322404	5.15573688	Abiotrophia	46123	Bacteria	Bacteria	392	1.0199999999999999e-104	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g5026	i0	99.537	505.220720720721	216	0	97	1	8	222	863627	863412	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	112159	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva
7660932	7660932	PRJDB14275_P_NODE_6947_length_171_cov_1.242424_g6888_i0	PRJDB14275	6947	171	1.242424	2.12454504	Staphylococcus epidermidis	1282	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2505659350\|gb\|CP118842.1\|	1282	g6888	i0	100	99.9824561403509	171	0	100	0	1	171	151667	151497	Staphylococcus epidermidis strain 7049 chromosome, complete genome	blastn	17097	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8935608	8935608	PRJDB14275_P_NODE_6548_length_179_cov_1.157143_g6489_i0	PRJDB14275	6548	179	1.157143	2.07128597	Finegoldia magna	1260	Bacteria	Bacteria	303	3.79e-78	NTclustered	gi\|1848608259\|gb\|CP054000.1\|	1260	g6489	i0	97.207	5.9776536312849204	179	5	100	0	1	179	598205	598027	Finegoldia magna strain FDAARGOS_764 chromosome, complete genome	blastn	1070	303	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
11486511	11486511	PRJDB14275_P_NODE_5030_length_224_cov_1.983784_g4971_i0	PRJDB14275	5030	224	1.983784	4.44367616	Salinicoccus halodurans	407035	Bacteria	Bacteria	375	1.04e-99	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4971	i0	96.875	8.97767857142857	224	7	100	0	1	224	550437	550214	Salinicoccus halodurans strain H3B36, complete genome	blastn	2011	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
12460323	12460323	PRJDB14275_P_NODE_7530_length_162_cov_1.308943_g7471_i0	PRJDB14275	7530	162	1.308943	2.12048766	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g7471	i0	100	100	162	0	100	0	1	162	1472066	1472227	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	16200	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12460331	12460331	PRJDB14275_P_NODE_830_length_836_cov_5.494354_g789_i0	PRJDB14275	830	836	5.494354	45.93279944	Streptococcus	1301	Bacteria	Bacteria	1485	0	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g789	i0	99.27	335.648325358852	822	6	98	0	1	822	903377	902556	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	280602	1496	0.992647058823529	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14036649	14036649	PRJDB14275_P_NODE_4712_length_237_cov_7.338384_g4653_i0	PRJDB14275	4712	237	7.338384	17.39197008	Salinicoccus halodurans	407035	Bacteria	Bacteria	368	1.86e-97	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g4653	i0	97.664	406.177215189873	214	5	90	0	1	214	374500	374287	Salinicoccus halodurans strain H3B36, complete genome	blastn	96264	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
15008937	15008937	PRJDB14275_P_NODE_4092_length_271_cov_1.275862_g4033_i0	PRJDB14275	4092	271	1.275862	3.45758602	Staphylococcus	1279	Bacteria	Bacteria	477	3.4599999999999986e-130	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g4033	i0	98.519	99.6309963099631	270	4	99	0	1	270	2402505	2402236	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	27000	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17860478	17860478	PRJDB14275_P_NODE_6835_length_173_cov_1.208955_g6776_i0	PRJDB14275	6835	173	1.208955	2.09149215	Finegoldia magna	1260	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|1848608259\|gb\|CP054000.1\|	1260	g6776	i0	100	6	173	0	100	0	1	173	197842	197670	Finegoldia magna strain FDAARGOS_764 chromosome, complete genome	blastn	1038	320	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20107642	20107642	PRJDB14275_P_NODE_6116_length_189_cov_0.806667_g6057_i0	PRJDB14275	6116	189	0.806667	1.52460063	Staphylococcus	1279	Bacteria	Bacteria	331	1.86e-86	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g6057	i0	98.413	101	189	2	100	1	1	189	2173095	2173282	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	19089	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20107676	20107676	PRJDB14275_P_NODE_8296_length_152_cov_0.867257_g8237_i0	PRJDB14275	8296	152	0.867257	1.31823064	Staphylococcus	1279	Bacteria	Bacteria	265	1.47e-66	NTclustered	gi\|2359411665\|gb\|CP110784.1\|	29388	g8237	i0	98.026	30.1315789473684	152	3	100	0	1	152	2095245	2095396	Staphylococcus capitis strain CCSM0123 chromosome, complete genome	blastn	4580	265	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
21383217	21383217	PRJDB14275_P_NODE_3537_length_308_cov_1.356877_g3478_i0	PRJDB14275	3537	308	1.3568770000000001	4.17918116	Marinococcus sp. PL1-	1978491	Bacteria	Bacteria	108	8.36e-28	NR	WP_319630639.1	3095363	g3478	i0	100	0.525974025974026	54	0	52.6	0	146	307	1	54	WP_319630639.1 30S ribosomal protein S12 [Marinococcus sp. PL1-022]	diamond	162	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus sp. PL1-022
23933554	23933554	PRJDB14275_P_NODE_6599_length_177_cov_2.376812_g6540_i0	PRJDB14275	6599	177	2.376812	4.20695724	Bacillati	1783272	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|560878811\|emb\|HF678775.1\|	1371	g6540	i0	100	100	177	0	100	0	1	177	515	339	Marinococcus halophilus partial 16S rRNA gene, isolate BDV4_S4_08a	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus halophilus
24234464	24234464	PRJDB14275_P_NODE_4340_length_256_cov_1.792627_g4281_i0	PRJDB14275	4340	256	1.792627	4.58912512	Anaerococcus sp. WGS1529	3366812	Bacteria	Bacteria	457	4.22e-124	NTclustered	gi\|2831325273\|gb\|CP171112.1\|	3366812	g4281	i0	98.828	86.67578125	256	3	100	0	1	256	663735	663990	Anaerococcus sp. WGS1529 chromosome, complete genome	blastn	22189	457	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1529
24234484	24234484	PRJDB14275_P_NODE_6080_length_189_cov_2.760000_g6021_i0	PRJDB14275	6080	189	2.76	5.2164	Gemella haemolysans	1379	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g6021	i0	99.471	311.587301587302	189	1	100	0	1	189	9702	9514	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	58890	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
25207218	25207218	PRJDB14275_P_NODE_7540_length_162_cov_1.000000_g7481_i0	PRJDB14275	7540	162	1	1.62	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2873239904\|gb\|CP176713.1\|	1280	g7481	i0	100	89.6481481481482	162	0	100	0	1	162	1456	1295	Staphylococcus aureus strain GTVSS-008 plasmid pCFSAN137043_1, complete sequence	blastn	14523	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27221842	27221842	PRJDB14275_P_NODE_3523_length_309_cov_2.266667_g3464_i0	PRJDB14275	3523	309	2.266667	7.00400103	Oenococcus sp. UCMA 17063	2259625	Bacteria	Bacteria	136	1.67e-39	NR	MDN6968925.1	2259625	g3464	i0	100	0.70873786407767	73	0	70.9	0	219	1	1	73	MDN6968925.1 hypothetical protein [Oenococcus sp. UCMA 17063]	diamond	219	136	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Oenococcus	Oenococcus sp. UCMA 17063
27696191	27696191	PRJDB14275_P_NODE_5204_length_217_cov_1.359551_g5145_i0	PRJDB14275	5204	217	1.359551	2.95022567	Streptococcus pneumoniae	1313	Bacteria	Bacteria	139	1.72e-40	NR	WP_203540869.1	1313	g5145	i0	100	0.995391705069124	72	0	99.5	0	1	216	67	138	WP_203540869.1 arginine--tRNA ligase, partial [Streptococcus pneumoniae]	diamond	216	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
28005931	28005931	PRJDB14275_P_NODE_3365_length_323_cov_1.292254_g3306_i0	PRJDB14275	3365	323	1.292254	4.17398042	Bacillati	1783272	Bacteria	Bacteria	223	1.2499999999999998e-73	NR	MCL7548339.1	1280	g3306	i0	99	1.89473684210526	102	1	94.7	0	18	323	1	102	MCL7548339.1 rhodanese-like domain-containing protein [Staphylococcus aureus]	diamond	612	223	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28422239	28422239	PRJDB14275_P_NODE_3306_length_328_cov_2.266436_g3247_i0	PRJDB14275	3306	328	2.266436	7.43391008	Enterococcus faecium	1352	Bacteria	Bacteria	156	3.0299999999999996e-47	NR	WP_164986047.1	1352	g3247	i0	97.4	0.713414634146341	78	2	71.3	0	93	326	1	78	WP_164986047.1 hypothetical protein, partial [Enterococcus faecium]	diamond	234	156	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
30822309	30822309	PRJDB14275_P_NODE_8214_length_153_cov_1.061404_g8155_i0	PRJDB14275	8214	153	1.061404	1.62394812	Marinococcus	1370	Bacteria	Bacteria	80.1	1.9e-18	NR	WP_022794945.1	1370	g8155	i0	100	0.901960784313726	46	0	90.2	0	2	139	12	57	WP_022794945.1 MULTISPECIES: 30S ribosomal protein S21 [Marinococcus]	diamond	138	80.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus
31448686	31448686	PRJDB14275_P_NODE_2956_length_362_cov_1.535604_g2897_i0	PRJDB14275	2956	362	1.535604	5.55888648	Bacteria	2	Bacteria	Bacteria	65.5	1.11e-9	NR	WP_144398806.1	1871336	g2897	i0	44.2	1.23480662983425	77	40	62.2	2	138	362	5	80	WP_144398806.1 zeta toxin family protein [Criibacterium bergeronii]	diamond	447	65.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Criibacterium	Criibacterium bergeronii
31960564	31960564	PRJDB14275_P_NODE_4038_length_274_cov_1.995745_g3979_i0	PRJDB14275	4038	274	1.995745	5.4683413	Streptococcus pneumoniae	1313	Bacteria	Bacteria	49.3	1.46e-5	NR	WP_230677583.1	1313	g3979	i0	60	0.437956204379562	40	14	41.6	1	160	273	3	42	WP_230677583.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	120	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
32023956	32023956	PRJDB14275_P_NODE_6598_length_177_cov_2.485507_g6539_i0	PRJDB14275	6598	177	2.485507	4.39934739	Staphylococcus aureus	1280	Bacteria	Bacteria	53.1	2.02e-7	NR	WP_407819668.1	1280	g6539	i0	75	3.03389830508475	44	11	74.6	0	170	39	1	44	WP_407819668.1 hypothetical protein [Staphylococcus aureus]	diamond	537	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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