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

34 rows where analysis = "blastn", bioproject = "PRJEB28589" 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
25935	25935	PRJEB28589_S_NODE_3461_length_356_cov_7.074434_g3353_i0	PRJEB28589	3461	356	7.074434	25.18498504	Staphylococcus hominis	1290	Bacteria	Bacteria	647	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g3353	i0	99.438	77.2584269662921	356	2	100	0	1	356	1990926	1991281	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	27504	647	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
988026	988026	PRJEB28589_S_NODE_3161_length_364_cov_9.170347_g3053_i0	PRJEB28589	3161	364	9.170347	33.38006308	Streptococcus	1301	Bacteria	Bacteria	617	2.72e-172	NTclustered	gi\|2587845447\|gb\|CP135436.1\|	3077584	g3053	i0	97.253	99.4697802197802	364	10	100	0	1	364	188699	188336	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006 chromosome, complete genome	blastn	36207	619	0.996768982229402	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006
988029	988029	PRJEB28589_S_NODE_4341_length_338_cov_7.934708_g4233_i0	PRJEB28589	4341	338	7.934708	26.81931304	Staphylococcus	1279	Bacteria	Bacteria	625	1.4999999999999999e-174	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g4233	i0	100	100.029585798817	338	0	100	0	1	338	761427	761090	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	33810	625	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
2263329	2263329	PRJEB28589_S_NODE_5742_length_312_cov_3.554717_g5634_i0	PRJEB28589	5742	312	3.554717	11.09071704	Staphylococcus	1279	Bacteria	Bacteria	560	3.92e-155	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g5634	i0	99.038	88.8076923076923	312	3	100	0	1	312	1520928	1521239	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	27708	560	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
2263341	2263341	PRJEB28589_S_NODE_9622_length_253_cov_5.252427_g9514_i0	PRJEB28589	9622	253	5.252427	13.28864031	Staphylococcus	1279	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g9514	i0	100	100	253	0	100	0	1	253	938558	938306	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25300	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2575875	2575875	PRJEB28589_S_NODE_7463_length_285_cov_9.554622_g7355_i0	PRJEB28589	7463	285	9.554622	27.2306727	Streptococcus nidrosiense	3140788	Bacteria	Bacteria	412	1.0499999999999999e-110	NTclustered	gi\|2808367144\|gb\|CP152419.1\|	3140788	g7355	i0	92.958	99.6280701754386	284	19	99	1	3	285	1702923	1703206	Streptococcus nidrosiense strain SO-23-1 chromosome, complete genome	blastn	28394	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus nidrosiense
2575876	2575876	PRJEB28589_S_NODE_7483_length_285_cov_5.163866_g7375_i0	PRJEB28589	7483	285	5.163866	14.7170181	Streptococcus sp. Marseille-Q3533	2759692	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|2237347942\|emb\|OW724079.1\|	2759692	g7375	i0	100	99.9964912280702	285	0	100	0	1	285	1601670	1601386	Streptococcus sp. Marseille-Q3533 genome assembly, chromosome: contig00001	blastn	28499	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q3533
3538631	3538631	PRJEB28589_S_NODE_4783_length_329_cov_7.021277_g4675_i0	PRJEB28589	4783	329	7.021277	23.10000133	Streptococcus	1301	Bacteria	Bacteria	608	1.4599999999999995e-169	NTclustered	gi\|1948603152\|gb\|CP066021.1\|	1303	g4675	i0	100	30.9726443768997	329	0	100	0	1	329	842892	842564	Streptococcus oralis strain FDAARGOS_1020 chromosome, complete genome	blastn	10190	608	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3852169	3852169	PRJEB28589_S_NODE_8164_length_274_cov_5.911894_g8056_i0	PRJEB28589	8164	274	5.911894	16.19858956	Staphylococcus epidermidis	1282	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g8056	i0	100	100	274	0	100	0	1	274	777645	777372	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	27400	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3852177	3852177	PRJEB28589_S_NODE_9424_length_256_cov_4.004785_g9316_i0	PRJEB28589	9424	256	4.004785	10.2522496	Streptococcus mitis	28037	Bacteria	Bacteria	361	3.4e-95	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g9316	i0	92.188	99.59765625	256	19	100	1	1	256	1237254	1237000	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	25497	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
4815894	4815894	PRJEB28589_S_NODE_11064_length_233_cov_4.069892_g10956_i0	PRJEB28589	11064	233	4.069892	9.48284836	Staphylococcus	1279	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2089711188\|gb\|MT647891.1\|	1290	g10956	i0	100	100.163090128755	233	0	100	0	1	233	217	449	Staphylococcus hominis strain S16 superoxide dismutase (sodA) gene, partial cds	blastn	23338	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4815905	4815905	PRJEB28589_S_NODE_19064_length_158_cov_0.918919_g18956_i0	PRJEB28589	19064	158	0.918919	1.45189202	root	1	Root_unresolved	Root_unresolved	239	9.34e-59	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g18956	i0	94.805	132.670886075949	154	6	100	2	6	158	933	781	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	20962	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5128352	5128352	PRJEB28589_S_NODE_18045_length_163_cov_0.879310_g17937_i0	PRJEB28589	18045	163	0.87931	1.4332753	Paenibacillus sp. WG02	3242372	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2793718170\|dbj\|AP036016.1\|	3242372	g17937	i0	100	0.184049079754601	30	0	18	0	76	105	325249	325220	Paenibacillus sp. WG02 DNA, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. WG02
6091138	6091138	PRJEB28589_S_NODE_16485_length_174_cov_1.606299_g16377_i0	PRJEB28589	16485	174	1.606299	2.79496026	Granulicatella	117563	Bacteria	Bacteria	316	4.7e-82	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g16377	i0	99.425	6.95977011494253	174	1	100	0	1	174	357487	357314	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	1211	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
6091142	6091142	PRJEB28589_S_NODE_2745_length_378_cov_2.800604_g2637_i0	PRJEB28589	2745	378	2.800604	10.58628312	Staphylococcus	1279	Bacteria	Bacteria	688	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g2637	i0	99.472	76.3756613756614	379	1	100	1	1	378	2028228	2028606	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	28870	688	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
7365636	7365636	PRJEB28589_S_NODE_19186_length_157_cov_1.390909_g19078_i0	PRJEB28589	19186	157	1.390909	2.18372713	Terrisporobacter	1505652	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2678800743\|gb\|CP117523.1\|	1121315	g19078	i0	100	1.07006369426752	28	0	18	0	69	96	4025936	4025909	Terrisporobacter glycolicus ATCC 14880 = DSM 1288 chromosome, complete genome	blastn	168	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Terrisporobacter	Terrisporobacter glycolicus
7678200	7678200	PRJEB28589_S_NODE_18987_length_158_cov_1.378378_g18879_i0	PRJEB28589	18987	158	1.378378	2.17783724	Lachnospiraceae bacterium GAM79	2109691	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2127625274\|gb\|CP085928.1\|	2109691	g18879	i0	100	0.354430379746835	28	0	18	0	52	79	41522	41495	Lachnospiraceae bacterium GAM79 strain FDAARGOS_1585 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium GAM79
7678243	7678243	PRJEB28589_S_NODE_6807_length_295_cov_8.201613_g6699_i0	PRJEB28589	6807	295	8.201613	24.19475835	Lachnoanaerobaculum gingivalis	2490855	Bacteria	Bacteria	479	1.0599999999999996e-130	NTclustered	gi\|2504688929\|gb\|CP124777.1\|	2490855	g6699	i0	95.932	2.14915254237288	295	12	100	0	1	295	1034715	1035009	Lachnoanaerobaculum gingivalis strain SHL-20230108WGSARO1-L360107582 chromosome, complete genome	blastn	634	479	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum gingivalis
8641213	8641213	PRJEB28589_S_NODE_6987_length_293_cov_3.552846_g6879_i0	PRJEB28589	6987	293	3.552846	10.40983878	Streptococcus	1301	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g6879	i0	100	100	293	0	100	0	1	293	209055	208763	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	29300	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8952980	8952980	PRJEB28589_S_NODE_2448_length_389_cov_7.064327_g2340_i0	PRJEB28589	2448	389	7.064327	27.48023203	Streptococcus sp. LPB0220	2610896	Bacteria	Bacteria	669	0	NTclustered	gi\|1752759834\|gb\|CP044230.1\|	2610896	g2340	i0	97.686	45.3290488431877	389	9	100	0	1	389	657629	657241	Streptococcus sp. LPB0220 chromosome, complete genome	blastn	17633	669	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. LPB0220
10228749	10228749	PRJEB28589_S_NODE_4649_length_332_cov_6.978947_g4541_i0	PRJEB28589	4649	332	6.978947	23.17010404	Anaerococcus sp. WGS1596	3366806	Bacteria	Bacteria	315	3.61e-81	NTclustered	gi\|2831295055\|gb\|CP170995.1\|	3366806	g4541	i0	84.049	1.96385542168675	326	52	98	0	1	326	1047609	1047934	Anaerococcus sp. WGS1596 chromosome, complete genome	blastn	652	315	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
11191343	11191343	PRJEB28589_S_NODE_13669_length_201_cov_1.675325_g13561_i0	PRJEB28589	13669	201	1.675325	3.36740325	Staphylococcus	1279	Bacteria	Bacteria	361	2.5599999999999998e-95	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g13561	i0	99.005	99.8557213930348	201	2	100	0	1	201	2016563	2016363	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	20071	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
12467123	12467123	PRJEB28589_S_NODE_19150_length_157_cov_2.090909_g19042_i0	PRJEB28589	19150	157	2.090909	3.28272713	Streptococcus	1301	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|1735232771\|gb\|CP040804.1\|	1304	g19042	i0	100	97.3503184713376	157	0	100	0	1	157	241109	240953	Streptococcus salivarius strain LAB813 chromosome, complete genome	blastn	15284	291	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
15328091	15328091	PRJEB28589_S_NODE_1153_length_500_cov_11.152318_g1049_i0	PRJEB28589	1153	500	11.152318	55.76159	Gemella haemolysans	1379	Bacteria	Bacteria	848	0	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g1049	i0	97.4	277.774	500	10	100	2	1	500	9358	9854	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	138887	848	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
18839752	18839752	PRJEB28589_S_NODE_7915_length_278_cov_6.142857_g7807_i0	PRJEB28589	7915	278	6.142857	17.07714246	Streptococcus	1301	Bacteria	Bacteria	425	1.31e-114	NTclustered	gi\|2587845447\|gb\|CP135436.1\|	3077584	g7807	i0	94.245	8.8705035971223	278	16	100	0	1	278	1585103	1585380	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006 chromosome, complete genome	blastn	2466	427	0.995316159250585	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006
20426684	20426684	PRJEB28589_S_NODE_4717_length_331_cov_4.281690_g4609_i0	PRJEB28589	4717	331	4.28169	14.1723939	Anaerococcus nagyae	1755241	Bacteria	Bacteria	257	6.150000000000001e-64	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g4609	i0	82.432	3.3595166163142	296	50	89	2	27	321	1018941	1018647	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	1112	257	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
21702665	21702665	PRJEB28589_S_NODE_10798_length_237_cov_4.700000_g10690_i0	PRJEB28589	10798	237	4.7	11.139	Virgibacillus halodenitrificans	1482	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1102502082\|gb\|CP017963.1\|	1482	g10690	i0	100	0.118143459915612	28	0	12	0	35	62	33347	33374	Virgibacillus halodenitrificans strain PDB-F2 plasmid unnamed1, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus halodenitrificans
21702676	21702676	PRJEB28589_S_NODE_12418_length_215_cov_2.619048_g12310_i0	PRJEB28589	12418	215	2.619048	5.6309532	Lactobacillus iners	147802	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g12310	i0	100	14.0558139534884	215	0	100	0	1	215	601884	602098	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	3022	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
21702715	21702715	PRJEB28589_S_NODE_2078_length_407_cov_20.780556_g1970_i0	PRJEB28589	2078	407	20.780556	84.57686292	Clostridium argentinense	29341	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1169607782\|gb\|CP014176.1\|	29341	g1970	i0	100	0.0687960687960688	28	0	7	0	372	399	1386692	1386665	Clostridium argentinense strain 89G, complete genome.	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium argentinense
22977920	22977920	PRJEB28589_S_NODE_12579_length_213_cov_4.385542_g12471_i0	PRJEB28589	12579	213	4.385542	9.34120446	Nosocomiicoccus massiliensis	1232430	Bacteria	Bacteria	392	9.72e-105	NTclustered	gi\|2612677914\|gb\|CP136964.1\|	1232430	g12471	i0	100	0.995305164319249	212	0	99	0	1	212	897342	897553	Nosocomiicoccus massiliensis strain UMB0959 chromosome, complete genome	blastn	212	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus massiliensis
22977941	22977941	PRJEB28589_S_NODE_1779_length_429_cov_4.609948_g1671_i0	PRJEB28589	1779	429	4.609948	19.77667692	Staphylococcus epidermidis	1282	Bacteria	Bacteria	787	0	NTclustered	gi\|2271285580\|gb\|CP090941.1\|	1282	g1671	i0	99.767	100	429	1	100	0	1	429	1100285	1100713	Staphylococcus epidermidis strain HAF242 chromosome, complete genome	blastn	42900	787	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23940388	23940388	PRJEB28589_S_NODE_7739_length_281_cov_7.431624_g7631_i0	PRJEB28589	7739	281	7.431624	20.88286344	Staphylococcus	1279	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7631	i0	100	100	281	0	100	0	1	281	1990130	1990410	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	28100	520	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25214082	25214082	PRJEB28589_S_NODE_13560_length_202_cov_1.645161_g13452_i0	PRJEB28589	13560	202	1.645161	3.32322522	Clostridioides	1870884	Bacteria	Bacteria	58.4	3.78e-4	NTclustered	gi\|2319031117\|gb\|CP107108.1\|	1496	g13452	i0	90.909	9.14851485148515	44	3	21	1	8	50	3310007	3310050	Clostridioides difficile strain R_phiCD75-3 chromosome, complete genome	blastn	1848	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
25214105	25214105	PRJEB28589_S_NODE_7640_length_283_cov_2.377119_g7532_i0	PRJEB28589	7640	283	2.377119	6.72724677	Staphylococcus	1279	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g7532	i0	100	90.1342756183746	283	0	100	0	1	283	1943626	1943344	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	25508	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis

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