metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1088503" 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
1017405	1017405	PRJNA1088503_P_NODE_4761_length_382_cov_30343.651558_g4395_i0	PRJNA1088503	4761	382	30343.651558	115912.74895156	Staphylococcus	1279	Bacteria	Bacteria	638	2.2e-178	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g4395	i0	99.713	68.7251308900524	349	0	91	1	34	382	590268	589921	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	26253	638	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
1017406	1017406	PRJNA1088503_P_NODE_6821_length_286_cov_2.439689_g6449_i0	PRJNA1088503	6821	286	2.439689	6.97751054	root	1	Root_unresolved	Root_unresolved	501	2.18e-137	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g6449	i0	98.252	103.402097902098	286	5	100	0	1	286	1099	1384	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	29573	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
1017410	1017410	PRJNA1088503_P_NODE_9981_length_191_cov_65885.228395_g9609_i0	PRJNA1088503	9981	191	65885.228395	125840.78623445	Staphylococcus	1279	Bacteria	Bacteria	204	4.289999999999999e-48	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g9609	i0	99.115	309.712041884817	113	1	59	0	1	113	748621	748509	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	59155	204	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1469070	1469070	PRJNA1088503_P_NODE_10322_length_182_cov_128.908497_g9950_i0	PRJNA1088503	10322	182	128.908497	234.61346454	Staphylococcus epidermidis	1282	Bacteria	Bacteria	285	1.4e-72	NTclustered	gi\|2484084503\|gb\|CP121486.1\|	1282	g9950	i0	100	84.6153846153846	154	0	85	0	27	180	1743101	1743254	Staphylococcus epidermidis strain 32FSE02 chromosome, complete genome	blastn	15400	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1469108	1469108	PRJNA1088503_P_NODE_5242_length_354_cov_60195.329231_g4870_i0	PRJNA1088503	5242	354	60195.329231	213091.46547774	Staphylococcus aureus	1280	Bacteria	Bacteria	62.1	5.56e-5	NTclustered	gi\|1373526687\|gb\|CP020544.1\|	1280	g4870	i0	97.297	98.0508474576271	37	0	10	1	308	343	2524174	2524138	Staphylococcus aureus strain CR14-035 chromosome	blastn	34710	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
2292873	2292873	PRJNA1088503_P_NODE_4442_length_404_cov_24629.826667_g4081_i0	PRJNA1088503	4442	404	24629.826667	99504.49973468	Staphylococcus	1279	Bacteria	Bacteria	669	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g4081	i0	99.194	92.0792079207921	372	1	92	2	2	371	1911450	1911821	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	37200	669	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2292875	2292875	PRJNA1088503_P_NODE_9202_length_211_cov_58549.939560_g8830_i0	PRJNA1088503	9202	211	58549.93956	123540.3724716	Thermoanaerobacter	1754	Bacteria	Bacteria	318	1.66e-82	NTclustered	gi\|1511915278\|gb\|CP033580.1\|	509192	g8830	i0	97.838	5.27488151658768	185	3	87	1	26	209	1777573	1777757	Thermoanaerobacter ethanolicus JW 200 chromosome, complete genome	blastn	1113	318	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacter	Thermoanaerobacter ethanolicus
2745201	2745201	PRJNA1088503_P_NODE_10683_length_173_cov_14.611111_g10311_i0	PRJNA1088503	10683	173	14.611111	25.27722203	Staphylococcus epidermidis	1282	Bacteria	Bacteria	267	4.77e-67	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g10311	i0	99.32	84.364161849711	147	1	85	0	26	172	1041246	1041100	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	14595	267	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2745238	2745238	PRJNA1088503_P_NODE_4603_length_393_cov_25900.390110_g4240_i0	PRJNA1088503	4603	393	25900.39011	101788.5331323	Clostridium sp. JS66	3064705	Bacteria	Bacteria	424	6.91e-114	NTclustered	gi\|2620058225\|gb\|CP131467.1\|	3064705	g4240	i0	88.169	1.02290076335878	355	42	90	0	5	359	2485246	2485600	Clostridium sp. JS66 chromosome, complete genome	blastn	402	424	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. JS66
3568131	3568131	PRJNA1088503_P_NODE_11523_length_155_cov_1.904762_g11151_i0	PRJNA1088503	11523	155	1.904762	2.9523811	root	1	Root_unresolved	Root_unresolved	283	4.15e-72	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g11151	i0	100	99.0129032258065	153	0	99	0	1	153	1258	1106	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	15347	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4021115	4021115	PRJNA1088503_P_NODE_10404_length_180_cov_1528.463576_g10032_i0	PRJNA1088503	10404	180	1528.463576	2751.2344368	Staphylococcus hominis	1290	Bacteria	Bacteria	268	1.3899999999999999e-67	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g10032	i0	99.324	21.2222222222222	148	1	82	0	29	176	2077046	2076899	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	3820	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4021168	4021168	PRJNA1088503_P_NODE_6804_length_286_cov_37989.428016_g6432_i0	PRJNA1088503	6804	286	37989.428016	108649.76412576	Staphylococcus aureus	1280	Bacteria	Bacteria	62.1	4.39e-5	NTclustered	gi\|1373526687\|gb\|CP020544.1\|	1280	g6432	i0	97.297	121.363636363636	37	0	13	1	12	47	2524138	2524174	Staphylococcus aureus strain CR14-035 chromosome	blastn	34710	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4845584	4845584	PRJNA1088503_P_NODE_8764_length_222_cov_55730.025907_g8392_i0	PRJNA1088503	8764	222	55730.025907	123720.65751354	Bacillota	1239	Bacteria	Bacteria	294	2.96e-75	NTclustered	gi\|2782658147\|gb\|CP163137.1\|	1515	g8392	i0	94.709	25.481981981982	189	10	85	0	34	222	1101625	1101813	Acetivibrio thermocellus strain PAL5 chromosome, complete genome	blastn	5657	294	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Acetivibrio	Acetivibrio thermocellus
5297323	5297323	PRJNA1088503_P_NODE_5425_length_346_cov_28971.347003_g5053_i0	PRJNA1088503	5425	346	28971.347003	100240.86063038	Gemella haemolysans	1379	Bacteria	Bacteria	562	1.22e-155	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g5053	i0	99.042	8.17630057803468	313	3	90	0	34	346	368300	368612	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	2829	562	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
7847210	7847210	PRJNA1088503_P_NODE_7127_length_274_cov_38049.967347_g6755_i0	PRJNA1088503	7127	274	38049.967347	104256.91053078	Staphylococcus hominis	1290	Bacteria	Bacteria	420	5.99e-113	NTclustered	gi\|1519019899\|gb\|CP033732.1\|	1290	g6755	i0	100	21.5401459854015	227	0	83	0	15	241	1971597	1971371	Staphylococcus hominis strain FDAARGOS_575 chromosome, complete genome	blastn	5902	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8670749	8670749	PRJNA1088503_P_NODE_7707_length_255_cov_48128.756637_g7335_i0	PRJNA1088503	7707	255	48128.756637	122728.32942435	Staphylococcus	1279	Bacteria	Bacteria	399	7.179999999999999e-107	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g7335	i0	99.103	41.1764705882353	223	1	87	1	34	255	2034960	2034738	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10500	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
9122137	9122137	PRJNA1088503_P_NODE_5108_length_362_cov_28347.750751_g4738_i0	PRJNA1088503	5108	362	28347.750751	102618.85771862	Streptococcus australis	113107	Bacteria	Bacteria	435	2.9200000000000003e-117	NTclustered	gi\|1654236162\|emb\|LR594040.1\|	113107	g4738	i0	92.691	31.5110497237569	301	22	83	0	1	301	688790	688490	Streptococcus australis strain NCTC5338 genome assembly, chromosome: 1	blastn	11407	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus australis
9122156	9122156	PRJNA1088503_P_NODE_8468_length_231_cov_10076.247525_g8096_i0	PRJNA1088503	8468	231	10076.247525	23276.13178275	Thermincola potens	863643	Bacteria	Bacteria	357	3.91e-94	NTclustered	gi\|296030128\|gb\|CP002028.1\|	635013	g8096	i0	98.515	0.874458874458874	202	3	87	0	2	203	2317604	2317805	Thermincola potens JR chromosome, complete genome	blastn	202	357	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Thermincolaceae	Thermincola	Thermincola potens
13770855	13770855	PRJNA1088503_P_NODE_10931_length_167_cov_219.876812_g10559_i0	PRJNA1088503	10931	167	219.876812	367.19427604	root	1	Root_unresolved	Root_unresolved	254	3.58e-63	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10559	i0	99.286	83.8323353293413	140	1	84	0	27	166	726270	726409	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	14000	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15045199	15045199	PRJNA1088503_P_NODE_8092_length_243_cov_503.873832_g7720_i0	PRJNA1088503	8092	243	503.873832	1224.41341176	Staphylococcus	1279	Bacteria	Bacteria	398	2.4399999999999997e-106	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7720	i0	100	88.477366255144	215	0	88	0	29	243	178480	178266	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	21500	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16320021	16320021	PRJNA1088503_P_NODE_8293_length_236_cov_575.748792_g7921_i0	PRJNA1088503	8293	236	575.748792	1358.76714912	root	1	Root_unresolved	Root_unresolved	351	1.86e-92	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7921	i0	98.492	84.3220338983051	199	3	84	0	10	208	1842458	1842656	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	19900	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17595295	17595295	PRJNA1088503_P_NODE_6174_length_312_cov_32803.275618_g5802_i0	PRJNA1088503	6174	312	32803.275618	102346.21992816	Geobacillus	129337	Bacteria	Bacteria	496	1.12e-135	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g5802	i0	99.631	28.1025641025641	271	1	87	0	11	281	456138	455868	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	8768	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
19320240	19320240	PRJNA1088503_P_NODE_2996_length_520_cov_22406.162933_g2698_i0	PRJNA1088503	2996	520	22406.162933	116512.0472516	Staphylococcus epidermidis	1282	Bacteria	Bacteria	821	0	NTclustered	gi\|1785980122\|gb\|CP043847.1\|	1282	g2698	i0	99.556	86.5384615384615	450	2	87	0	70	519	1047562	1047113	Staphylococcus epidermidis strain NCCP 16828 chromosome, complete genome	blastn	45000	821	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19320243	19320243	PRJNA1088503_P_NODE_3276_length_494_cov_20272.264516_g2961_i0	PRJNA1088503	3276	494	20272.264516	100144.98670904	Clostridium drakei	332101	Bacteria	Bacteria	678	0	NTclustered	gi\|1387255471\|gb\|CP020953.1\|	332101	g2961	i0	93.64	2.61740890688259	456	25	92	3	8	461	2051087	2051540	Clostridium drakei strain SL1 chromosome, complete genome	blastn	1293	678	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium drakei
20595593	20595593	PRJNA1088503_P_NODE_4817_length_378_cov_27127.965616_g4450_i0	PRJNA1088503	4817	378	27127.965616	102543.71002848	Clostridium sp. JS66	3064705	Bacteria	Bacteria	617	2.83e-172	NTclustered	gi\|2620058225\|gb\|CP131467.1\|	3064705	g4450	i0	99.703	1.78306878306878	337	1	89	0	34	370	3023066	3022730	Clostridium sp. JS66 chromosome, complete genome	blastn	674	617	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. JS66
22694374	22694374	PRJNA1088503_P_NODE_6338_length_305_cov_38973.605072_g5966_i0	PRJNA1088503	6338	305	38973.605072	118869.4954696	Lactococcus	1357	Bacteria	Bacteria	503	6.53e-138	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g5966	i0	100	41.1409836065574	272	0	89	0	34	305	298036	297765	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	12548	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
23146689	23146689	PRJNA1088503_P_NODE_6759_length_288_cov_41139.532819_g6387_i0	PRJNA1088503	6759	288	41139.532819	118481.85451872	Pelosinus fermentans	365349	Bacteria	Bacteria	100	9.38e-17	NTclustered	gi\|763683107\|gb\|CP010978.1\|	1192197	g6387	i0	76.636	0.913194444444444	214	30	74	14	1	212	2332300	2332495	Pelosinus fermentans JBW45, complete genome	blastn	263	100	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Pelosinus	Pelosinus fermentans
23146696	23146696	PRJNA1088503_P_NODE_8179_length_240_cov_24045.928910_g7807_i0	PRJNA1088503	8179	240	24045.92891	57710.229384	Staphylococcus cohnii	29382	Bacteria	Bacteria	128	3.4899999999999998e-25	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g7807	i0	82.979	5.86666666666667	141	24	59	0	76	216	2692859	2692999	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	1408	128	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
23969887	23969887	PRJNA1088503_P_NODE_1619_length_719_cov_16794.133333_g1437_i0	PRJNA1088503	1619	719	16794.133333	120749.81866427	Staphylococcus	1279	Bacteria	Bacteria	1243	0	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g1437	i0	99.852	39.5744089012517	676	1	94	0	4	679	2270683	2270008	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	28454	1243	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
23969891	23969891	PRJNA1088503_P_NODE_7379_length_266_cov_39811.873418_g7007_i0	PRJNA1088503	7379	266	39811.873418	105899.58329188	Staphylococcus	1279	Bacteria	Bacteria	398	2.7099999999999996e-106	NTclustered	gi\|1821208350\|gb\|CP043783.1\|	1282	g7007	i0	98.238	86.484962406015	227	4	85	0	3	229	1661	1435	Staphylococcus epidermidis strain SESURV_p1_0563 plasmid unnamed2	blastn	23005	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25243838	25243838	PRJNA1088503_P_NODE_5980_length_321_cov_1.986301_g5608_i0	PRJNA1088503	5980	321	1.986301	6.37602621	root	1	Root_unresolved	Root_unresolved	577	4.02e-160	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g5608	i0	99.065	170.261682242991	321	3	100	0	1	321	1069	749	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	54654	582	0.991408934707904	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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