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

31 rows where analysis = "blastn", bioproject = "PRJNA664479" 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
1905259	1905259	PRJNA664479_S_NODE_16562_length_164_cov_0.886957_g16486_i0	PRJNA664479	16562	164	0.886957	1.45460948	Anaerococcus obesiensis	1287640	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|1954927112\|gb\|CP067016.1\|	1287640	g16486	i0	97.561	2	164	4	100	0	1	164	1467358	1467195	Anaerococcus obesiensis strain FDAARGOS_989 chromosome, complete genome	blastn	328	281	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus obesiensis
3180062	3180062	PRJNA664479_S_NODE_923_length_486_cov_5.709382_g848_i0	PRJNA664479	923	486	5.709382	27.74759652	Paenibacillus sp. FSL R5-0623	2921651	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2709784333\|gb\|CP150233.1\|	2921651	g848	i0	100	0.0576131687242798	28	0	6	0	247	274	5234524	5234551	Paenibacillus sp. FSL R5-0623 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0623
4457076	4457076	PRJNA664479_S_NODE_17424_length_163_cov_0.894737_g17348_i0	PRJNA664479	17424	163	0.894737	1.45842131	Staphylococcus aureus	1280	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1712340123\|gb\|CP042047.1\|	1280	g17348	i0	100	1	163	0	100	0	1	163	51478	51640	Staphylococcus aureus strain B2-7A plasmid pSALNBL75, complete sequence	blastn	163	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6266076	6266076	PRJNA664479_S_NODE_10785_length_183_cov_1.880597_g10709_i0	PRJNA664479	10785	183	1.880597	3.44149251	Streptococcus	1301	Bacteria	Bacteria	327	2.31e-85	NTclustered	gi\|1851386209\|gb\|CP047883.1\|	28037	g10709	i0	98.907	326	183	2	100	0	1	183	163124	163306	Streptococcus mitis strain S022-V3-A4 chromosome, complete genome	blastn	59658	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
6266079	6266079	PRJNA664479_S_NODE_14225_length_167_cov_1.296610_g14149_i0	PRJNA664479	14225	167	1.29661	2.1653387	Bacilli	91061	Bacteria	Bacteria	276	7.64e-70	NTclustered	gi\|453201778\|gb\|JQ999686.1\|	165192	g14149	i0	96.407	346.25149700598803	167	6	100	0	1	167	18	184	Uncultured Pediococcus sp. clone GKJWQY101AMK4B 23S ribosomal RNA gene, partial sequence	blastn	57824	276	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	uncultured Pediococcus sp.
7540164	7540164	PRJNA664479_S_NODE_14666_length_167_cov_0.864407_g14590_i0	PRJNA664479	14666	167	0.864407	1.44355969	Lactococcus	1357	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g14590	i0	100	100	167	0	100	0	1	167	11748	11582	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	16700	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
7540169	7540169	PRJNA664479_S_NODE_18606_length_161_cov_0.919643_g18530_i0	PRJNA664479	18606	161	0.919643	1.48062523	Anoxybacillus	150247	Bacteria	Bacteria	220	3.46e-53	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g18530	i0	91.358	751.04347826087	162	12	100	2	1	161	2167058	2166898	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	120918	220	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
8815247	8815247	PRJNA664479_S_NODE_11707_length_178_cov_2.813953_g11631_i0	PRJNA664479	11707	178	2.813953	5.00883634	Staphylococcus	1279	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1042399354\|gb\|KU555851.1\|	29382	g11631	i0	100	477.275280898876	178	0	100	0	1	178	625	448	Staphylococcus cohnii strain SCO15222-2 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	84955	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
10090820	10090820	PRJNA664479_S_NODE_2908_length_294_cov_11.155102_g2832_i0	PRJNA664479	2908	294	11.155102	32.79599988	root	1	Root_unresolved	Root_unresolved	544	3.69e-150	NTclustered	gi\|332002471\|gb\|JF803540.1\|	1379	g2832	i0	100	109	294	0	100	0	1	294	1398	1105	Gemella haemolysans strain M347 16S ribosomal RNA gene, partial sequence	blastn	32046	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
10833279	10833279	PRJNA664479_S_NODE_18229_length_162_cov_0.902655_g18153_i0	PRJNA664479	18229	162	0.902655	1.4623011	Anoxybacillus gonensis	198467	Bacteria	Bacteria	211	2.1e-50	NTclustered	gi\|906363419\|gb\|CP012152.1\|	198467	g18153	i0	90.123	16.0493827160494	162	16	100	0	1	162	1838411	1838572	Anoxybacillus gonensis strain G2, complete genome	blastn	2600	211	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus gonensis
10833285	10833285	PRJNA664479_S_NODE_9169_length_193_cov_1.409722_g9093_i0	PRJNA664479	9169	193	1.409722	2.72076346	Granulicatella elegans	137732	Bacteria	Bacteria	346	6.82e-91	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g9093	i0	98.969	544.740932642487	194	1	100	1	1	193	104991	104798	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	105135	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
12641483	12641483	PRJNA664479_S_NODE_810_length_523_cov_5.324895_g737_i0	PRJNA664479	810	523	5.324895	27.84920085	Streptococcus	1301	Bacteria	Bacteria	955	0	NTclustered	gi\|1943213388\|gb\|CP065706.1\|	1303	g737	i0	99.618	305.994263862333	523	2	100	0	1	523	198561	198039	Streptococcus oralis strain FDAARGOS_886 chromosome, complete genome	blastn	160035	955	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13383211	13383211	PRJNA664479_S_NODE_2511_length_313_cov_1.484848_g2435_i0	PRJNA664479	2511	313	1.484848	4.64757424	Gracilibacillus salinarum	2932255	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2221911765\|gb\|CP095071.1\|	2932255	g2435	i0	97.059	0.108626198083067	34	0	11	1	221	254	3287354	3287322	Gracilibacillus salinarum strain SSPM10-3 chromosome, complete genome	blastn	34	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus salinarum
13916231	13916231	PRJNA664479_S_NODE_5851_length_224_cov_2.011429_g5775_i0	PRJNA664479	5851	224	2.011429	4.50560096	Streptococcus	1301	Bacteria	Bacteria	368	1.74e-97	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g5775	i0	97.685	330.955357142857	216	1	95	1	13	224	1571343	1571558	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	74134	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14658113	14658113	PRJNA664479_S_NODE_15672_length_165_cov_0.879310_g15596_i0	PRJNA664479	15672	165	0.87931	1.4508615	Peptoniphilus harei	54005	Bacteria	Bacteria	298	1.61e-76	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g15596	i0	99.39	17.0060606060606	164	1	99	0	1	164	600977	600814	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	2806	298	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
14658115	14658115	PRJNA664479_S_NODE_17932_length_162_cov_0.902655_g17856_i0	PRJNA664479	17932	162	0.902655	1.4623011	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g17856	i0	100	38	162	0	100	0	1	162	2306365	2306526	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	6156	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
14658117	14658117	PRJNA664479_S_NODE_18052_length_162_cov_0.902655_g17976_i0	PRJNA664479	18052	162	0.902655	1.4623011	Levilactobacillus parabrevis	357278	Bacteria	Bacteria	272	9.51e-69	NTclustered	gi\|2842853189\|gb\|CP168688.1\|	357278	g17976	i0	96.914	6.94444444444444	162	5	100	0	1	162	1644391	1644552	Levilactobacillus parabrevis strain FUA 30082 chromosome, complete genome	blastn	1125	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Levilactobacillus	Levilactobacillus parabrevis
15190808	15190808	PRJNA664479_S_NODE_15132_length_166_cov_0.871795_g15056_i0	PRJNA664479	15132	166	0.871795	1.4471797	Staphylococcus	1279	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2624851299\|gb\|CP120073.1\|	29385	g15056	i0	100	25.0602409638554	166	0	100	0	1	166	32399	32234	Staphylococcus saprophyticus strain Dog122 chromosome, complete genome	blastn	4160	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus
15190817	15190817	PRJNA664479_S_NODE_8852_length_195_cov_4.760274_g8776_i0	PRJNA664479	8852	195	4.760274	9.2825343	Streptococcus	1301	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g8776	i0	100	327	195	0	100	0	1	195	625402	625208	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	63765	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
15932017	15932017	PRJNA664479_S_NODE_15773_length_165_cov_0.879310_g15697_i0	PRJNA664479	15773	165	0.87931	1.4508615	Exiguobacterium undae	169177	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|2851161950\|gb\|CP085018.1\|	169177	g15697	i0	97.576	3.90909090909091	165	4	100	0	1	165	562215	562051	Exiguobacterium undae strain SLM-182 chromosome, complete genome	blastn	645	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium undae
15932019	15932019	PRJNA664479_S_NODE_1693_length_373_cov_1.398148_g1617_i0	PRJNA664479	1693	373	1.398148	5.21509204	uncultured Eubacteriales bacterium	172733	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2729058706\|emb\|OZ007006.1\|	172733	g1617	i0	100	0.0750670241286863	28	0	8	0	70	97	1227202	1227229	MAG: uncultured Eubacteriales bacterium isolate metabat2_pooled_hifiasm.126 MAG genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
17207199	17207199	PRJNA664479_S_NODE_10514_length_185_cov_1.014706_g10438_i0	PRJNA664479	10514	185	1.014706	1.8772061	Bacillus paramobilis	2817477	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2717062971\|gb\|CP151108.1\|	2817477	g10438	i0	100	0.151351351351351	28	0	15	0	136	163	2715322	2715295	Bacillus paramobilis strain IMGN7 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paramobilis
17207208	17207208	PRJNA664479_S_NODE_18934_length_161_cov_0.910714_g18858_i0	PRJNA664479	18934	161	0.910714	1.46624954	Staphylococcus epidermidis	1282	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g18858	i0	100	100	161	0	100	0	1	161	421636	421796	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	16100	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18481551	18481551	PRJNA664479_S_NODE_13695_length_169_cov_1.391667_g13619_i0	PRJNA664479	13695	169	1.391667	2.35191723	Granulicatella elegans	137732	Bacteria	Bacteria	296	5.9e-76	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g13619	i0	98.225	340.917159763314	169	3	100	0	1	169	105941	105773	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	57615	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
19013841	19013841	PRJNA664479_S_NODE_10955_length_182_cov_2.345865_g10879_i0	PRJNA664479	10955	182	2.345865	4.2694743	root	1	Root_unresolved	Root_unresolved	337	3.82e-88	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g10879	i0	100	103	182	0	100	0	1	182	1572990	1572809	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	18746	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
19013846	19013846	PRJNA664479_S_NODE_18095_length_162_cov_0.902655_g18019_i0	PRJNA664479	18095	162	0.902655	1.4623011	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1844054309\|gb\|CP053477.1\|	1292	g18019	i0	100	22.1913580246914	162	0	100	0	1	162	628689	628850	Staphylococcus warneri strain WB224 chromosome, complete genome	blastn	3595	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20288614	20288614	PRJNA664479_S_NODE_19336_length_158_cov_2.137615_g19260_i0	PRJNA664479	19336	158	2.137615	3.3774317	root	1	Root_unresolved	Root_unresolved	292	7.07e-75	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g19260	i0	100	106	158	0	100	0	1	158	7555	7712	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	16748	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
21564251	21564251	PRJNA664479_S_NODE_14697_length_167_cov_0.864407_g14621_i0	PRJNA664479	14697	167	0.864407	1.44355969	Megasphaera	906	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|507148370\|ref\|NR_103173.1\|	907	g14621	i0	100	750.730538922156	167	0	100	0	1	167	997	831	Megasphaera elsdenii strain DSM 20460 23S ribosomal RNA gene, complete sequence	blastn	125372	309	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
21564254	21564254	PRJNA664479_S_NODE_18717_length_161_cov_0.910714_g18641_i0	PRJNA664479	18717	161	0.910714	1.46624954	Streptococcus	1301	Bacteria	Bacteria	281	1.57e-71	NTclustered	gi\|1780487221\|gb\|CP046335.1\|	28037	g18641	i0	98.137	22	161	3	100	0	1	161	1234819	1234979	Streptococcus mitis strain FDAARGOS_684 chromosome, complete genome	blastn	3542	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
22306461	22306461	PRJNA664479_S_NODE_16558_length_164_cov_0.886957_g16482_i0	PRJNA664479	16558	164	0.886957	1.45460948	Staphylococcus epidermidis	1282	Bacteria	Bacteria	302	1.23e-77	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g16482	i0	100	99.390243902439	163	0	99	0	2	164	1274624	1274786	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	16300	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24114206	24114206	PRJNA664479_S_NODE_14559_length_167_cov_0.864407_g14483_i0	PRJNA664479	14559	167	0.864407	1.44355969	Staphylococcus	1279	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2624851299\|gb\|CP120073.1\|	29385	g14483	i0	100	43.7844311377246	167	0	100	0	1	167	16900	16734	Staphylococcus saprophyticus strain Dog122 chromosome, complete genome	blastn	7312	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus

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