metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2610140	2610140	PRJEB43370_P_NODE_5423_length_195_cov_1.369863_g5380_i0	PRJEB43370	5423	195	1.369863	2.67123285	Ligilactobacillus salivarius	1624	Bacteria	Bacteria	159	9.65e-35	NTclustered	gi\|2246265477\|gb\|CP097639.1\|	1624	g5380	i0	85.256	63.974358974359	156	21	79	2	40	194	629769	629923	Ligilactobacillus salivarius strain S01 chromosome, complete genome	blastn	12475	159	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
2610161	2610161	PRJEB43370_P_NODE_7643_length_169_cov_0.866667_g7600_i0	PRJEB43370	7643	169	0.866667	1.46466723	Actinomyces qiguomingii	2057800	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1560770216\|gb\|CP025228.1\|	2057800	g7600	i0	90	23.0532544378698	90	9	53	0	71	160	2813612	2813701	Actinomyces qiguomingii strain 410 chromosome, complete genome	blastn	3896	117	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces qiguomingii
2610175	2610175	PRJEB43370_P_NODE_9203_length_165_cov_1.465517_g9160_i0	PRJEB43370	9203	165	1.465517	2.41810305	Stanieria sp. NIES-3757	1807358	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1003382826\|dbj\|AP017375.1\|	1807358	g9160	i0	87.654	0.490909090909091	81	10	49	0	5	85	2190362	2190442	Stanieria sp. NIES-3757 DNA, complete genome	blastn	81	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. NIES-3757
2610179	2610179	PRJEB43370_P_NODE_9903_length_164_cov_0.904348_g9860_i0	PRJEB43370	9903	164	0.904348	1.48313072	Spiroplasma endosymbiont of Notiophilus biguttatus	3066285	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2719904880\|emb\|OZ034993.1\|	3066285	g9860	i0	100	0.170731707317073	28	0	17	0	39	66	773620	773647	Spiroplasma endosymbiont of Notiophilus biguttatus isolate 54805 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Notiophilus biguttatus
3540446	3540446	PRJEB43370_P_NODE_1883_length_316_cov_1.625468_g1840_i0	PRJEB43370	1883	316	1.625468	5.13647888	Mycobacteriaceae	1762	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1806304829\|dbj\|AP022581.1\|	169765	g1840	i0	96.97	3.15189873417722	33	1	10	0	254	286	27572	27540	Mycobacterium lacus JCM 15657 DNA, complete genome	blastn	996	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium lacus
3886359	3886359	PRJEB43370_P_NODE_9264_length_165_cov_0.896552_g9221_i0	PRJEB43370	9264	165	0.896552	1.4793108	Streptomyces sp. NBC_00448	2903652	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2658430807\|gb\|CP107913.1\|	2903652	g9221	i0	100	0.16969696969697	28	0	17	0	30	57	8489766	8489793	Streptomyces sp. NBC_00448 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00448
4817798	4817798	PRJEB43370_P_NODE_5084_length_200_cov_2.066225_g5041_i0	PRJEB43370	5084	200	2.066225	4.13245	FCB group	1783270	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|281186802\|gb\|GU227407.1\|	2099	g5041	i0	99.5	100	200	1	100	0	1	200	545	744	Mycoplasma hyopneumoniae strain USP14P 16S ribosomal RNA gene, partial sequence	blastn	20000	364	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyopneumoniae
6093063	6093063	PRJEB43370_P_NODE_5865_length_188_cov_2.244604_g5822_i0	PRJEB43370	5865	188	2.244604	4.21985552	Mollicutes	31969	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1958638472\|gb\|MW498281.1\|	2100	g5822	i0	100	95.0904255319149	188	0	100	0	1	188	1966	2153	Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence	blastn	17877	348	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6093064	6093064	PRJEB43370_P_NODE_6465_length_180_cov_1.786260_g6422_i0	PRJEB43370	6465	180	1.78626	3.215268	Mycobacteriaceae	1762	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|1806225195\|dbj\|AP022563.1\|	39688	g6422	i0	100	129.927777777778	171	0	95	0	10	180	1558638	1558468	Mycolicibacterium duvalii JCM 6396 DNA, complete genome	blastn	23387	316	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium duvalii
6093069	6093069	PRJEB43370_P_NODE_9305_length_165_cov_0.896552_g9262_i0	PRJEB43370	9305	165	0.896552	1.4793108	Nocardiopsis	2013	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|1540223313\|emb\|LR134501.1\|	2014	g9262	i0	97.143	1.83636363636364	35	1	21	0	20	54	3001746	3001780	Nocardiopsis dassonvillei strain NCTC10488 genome assembly, chromosome: 1	blastn	303	60.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis dassonvillei
11193296	11193296	PRJEB43370_P_NODE_10809_length_162_cov_0.920354_g10766_i0	PRJEB43370	10809	162	0.920354	1.49097348	Streptomyces	1883	Bacteria	Bacteria	139	1.01e-28	NTclustered	gi\|1863100227\|gb\|CP056041.1\|	1969	g10766	i0	87.603	35.1296296296296	121	13	74	2	43	162	10896460	10896341	Streptomyces chartreusis strain NA02069 chromosome, complete genome	blastn	5691	139	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces chartreusis
11193310	11193310	PRJEB43370_P_NODE_9429_length_165_cov_0.896552_g9386_i0	PRJEB43370	9429	165	0.896552	1.4793108	Streptomyces	1883	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1688905926\|gb\|CP040467.1\|	1886	g9386	i0	100	0.509090909090909	28	0	17	0	94	121	25820	25847	Streptomyces albidoflavus strain UYFA156 plasmid unnamed, complete sequence	blastn	84	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
12469015	12469015	PRJEB43370_P_NODE_8870_length_166_cov_0.888889_g8827_i0	PRJEB43370	8870	166	0.888889	1.47555574	Winkia	2692118	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2435992455\|gb\|CP116394.1\|	29318	g8827	i0	100	4	166	0	100	0	1	166	200931	201096	Winkia neuii subsp. anitrata strain NY0527 chromosome, complete genome	blastn	664	307	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Winkia	Winkia neuii
12813707	12813707	PRJEB43370_P_NODE_3731_length_228_cov_1.452514_g3688_i0	PRJEB43370	3731	228	1.452514	3.31173192	Clostridium carboxidivorans	217159	Bacteria	Bacteria	111	3.31e-20	NTclustered	gi\|848258874\|gb\|CP011803.1\|	536227	g3688	i0	84.348	1.83333333333333	115	16	50	2	26	139	5092042	5091929	Clostridium carboxidivorans P7, complete genome	blastn	418	111	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium carboxidivorans
13743405	13743405	PRJEB43370_P_NODE_11071_length_159_cov_2.836364_g11028_i0	PRJEB43370	11071	159	2.836364	4.50981876	Mycobacteriaceae	1762	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1806215240\|dbj\|AP022561.1\|	1799	g11028	i0	100	168.918238993711	159	0	100	0	1	159	3182899	3182741	Mycolicibacterium aichiense JCM 6376 DNA, complete genome	blastn	26858	294	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aichiense
13743414	13743414	PRJEB43370_P_NODE_3951_length_223_cov_1.195402_g3908_i0	PRJEB43370	3951	223	1.195402	2.66574646	FCB group	1783270	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g3908	i0	100	99.865470852017907	223	0	100	0	1	223	429046	428824	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	22270	412	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13743415	13743415	PRJEB43370_P_NODE_4291_length_215_cov_1.879518_g4248_i0	PRJEB43370	4291	215	1.879518	4.0409637	Mollicutes	31969	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|1958638505\|gb\|MW498314.1\|	2100	g4248	i0	100	99.3488372093023	215	0	100	0	1	215	2624	2838	Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence	blastn	21360	398	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15017759	15017759	PRJEB43370_P_NODE_3232_length_243_cov_0.876289_g3189_i0	PRJEB43370	3232	243	0.876289	2.12938227	root	1	Root_unresolved	Root_unresolved	449	6.65e-122	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g3189	i0	100	99.522633744856	243	0	100	0	1	243	2753771	2753529	Staphylococcus aureus strain WH3018 chromosome	blastn	24184	449	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15362433	15362433	PRJEB43370_P_NODE_7373_length_169_cov_1.300000_g7330_i0	PRJEB43370	7373	169	1.3	2.197	Candidatus Sarcina troglodytae	2726954	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1938574842\|gb\|CP051754.1\|	2726954	g7330	i0	80.795	4.31952662721894	151	27	89	2	15	164	287670	287521	Sarcina sp. JB2 chromosome, complete genome	blastn	730	117	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Sarcina	Candidatus Sarcina troglodytae
15362438	15362438	PRJEB43370_P_NODE_8413_length_167_cov_0.881356_g8370_i0	PRJEB43370	8413	167	0.881356	1.47186452	Companilactobacillus ginsenosidimutans	1007676	Bacteria	Bacteria	159	8.02e-35	NTclustered	gi\|873923078\|gb\|CP012034.1\|	1007676	g8370	i0	84.568	3.18562874251497	162	23	96	2	7	167	1412338	1412178	Companilactobacillus ginsenosidimutans strain EMML 3041 chromosome, complete genome	blastn	532	159	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus ginsenosidimutans
15362442	15362442	PRJEB43370_P_NODE_9013_length_166_cov_0.888889_g8970_i0	PRJEB43370	9013	166	0.888889	1.47555574	Malacoplasma penetrans	28227	Bacteria	Bacteria	86.1	1.37e-12	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g8970	i0	78	0.903614457831325	150	23	87	10	20	164	307399	307543	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	150	86.1	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
16637006	16637006	PRJEB43370_P_NODE_5054_length_201_cov_1.368421_g5011_i0	PRJEB43370	5054	201	1.368421	2.75052621	Clostridium intestinale	36845	Bacteria	Bacteria	132	2.18e-26	NTclustered	gi\|1880427247\|gb\|CP059378.1\|	36845	g5011	i0	83.333	66.0497512437811	144	22	71	2	59	201	1113462	1113604	Clostridium intestinale strain Lx1 chromosome, complete genome	blastn	13276	132	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
17567736	17567736	PRJEB43370_P_NODE_1394_length_368_cov_2.576803_g1351_i0	PRJEB43370	1394	368	2.576803	9.48263504	Turicibacter	191303	Bacteria	Bacteria	292	1.89e-74	NTclustered	gi\|984737891\|gb\|CP013476.1\|	1712675	g1351	i0	81.843	752.304347826087	369	48	98	14	7	368	954890	955246	Turicibacter sp. H121 chromosome, complete genome	blastn	276848	292	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sp. H121
17567755	17567755	PRJEB43370_P_NODE_9394_length_165_cov_0.896552_g9351_i0	PRJEB43370	9394	165	0.896552	1.4793108	Actinomycetes	1760	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1907669513\|gb\|CP031142.1\|	333966	g9351	i0	77.711	49.5818181818182	166	30	98	5	5	165	7301066	7301229	Saccharopolyspora pogona strain NRRL30141 chromosome, complete genome	blastn	8181	95.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora pogona
18841618	18841618	PRJEB43370_P_NODE_6335_length_182_cov_1.563910_g6292_i0	PRJEB43370	6335	182	1.56391	2.8463162	Lactiplantibacillus	2767842	Bacteria	Bacteria	73.1	1.19e-8	NTclustered	gi\|2788798707\|gb\|CP166731.1\|	1590	g6292	i0	90.741	29.456043956044	54	5	30	0	107	160	1687523	1687576	Lactiplantibacillus plantarum strain HD02 chromosome, complete genome	blastn	5361	73.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
20461075	20461075	PRJEB43370_P_NODE_8657_length_167_cov_0.881356_g8614_i0	PRJEB43370	8657	167	0.881356	1.47186452	Janibacter terrae	103817	Bacteria	Bacteria	243	7.739999999999999e-60	NTclustered	gi\|2732501705\|gb\|CP144167.1\|	103817	g8614	i0	92.857	192.760479041916	168	11	100	1	1	167	2460941	2461108	Janibacter terrae strain Sec5.9 chromosome, complete genome	blastn	32191	243	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter terrae
21392020	21392020	PRJEB43370_P_NODE_3917_length_224_cov_1.011429_g3874_i0	PRJEB43370	3917	224	1.011429	2.26560096	Bacteria	2	Bacteria	Bacteria	82.4	2.54e-11	NTclustered	gi\|2285394500\|gb\|CP097984.1\|	2045	g3874	i0	77.273	26.1741071428571	154	26	69	9	10	163	3701549	3701405	Pimelobacter simplex strain N39 chromosome, complete genome	blastn	5863	82.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Pimelobacter	Pimelobacter simplex
22666827	22666827	PRJEB43370_P_NODE_5998_length_187_cov_0.891304_g5955_i0	PRJEB43370	5998	187	0.891304	1.66673848	Metabacillus	2675233	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|1891105402\|gb\|CP055263.1\|	2745198	g5955	i0	95	0.427807486631016	40	2	21	0	141	180	946174	946135	Metabacillus sp. KUDC1714 chromosome, complete genome	blastn	80	63.9	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus elymi
22666829	22666829	PRJEB43370_P_NODE_6638_length_178_cov_1.503876_g6595_i0	PRJEB43370	6638	178	1.503876	2.67689928	Staphylococcaceae	90964	Bacteria	Bacteria	121	4.0699999999999996e-23	NTclustered	gi\|2073000562\|gb\|CP079109.1\|	489910	g6595	i0	79.444	191.522471910112	180	30	99	7	1	176	208442	208618	Nosocomiicoccus ampullae strain 19-00310 chromosome, complete genome	blastn	34091	122	0.991803278688525	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus ampullae
23012126	23012126	PRJEB43370_P_NODE_10019_length_164_cov_0.904348_g9976_i0	PRJEB43370	10019	164	0.904348	1.48313072	Mycolicibacterium rufum	318424	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2294186521\|gb\|CP092427.2\|	318424	g9976	i0	98.78	166.536585365854	164	2	100	0	1	164	209585	209422	Mycolicibacterium rufum strain JCM 16372 chromosome, complete genome	blastn	27312	292	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rufum
23942248	23942248	PRJEB43370_P_NODE_2159_length_295_cov_1.991870_g2116_i0	PRJEB43370	2159	295	1.99187	5.8760165	Exiguobacterium	33986	Bacteria	Bacteria	427	3.8899999999999996e-115	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g2116	i0	93.127	799.566101694915	291	20	99	0	1	291	14250	13960	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	235872	427	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
25216049	25216049	PRJEB43370_P_NODE_7060_length_172_cov_4.219512_g7017_i0	PRJEB43370	7060	172	4.219512	7.25756064	root	1	Root_unresolved	Root_unresolved	318	1.2899999999999999e-82	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g7017	i0	100	59.8372093023256	172	0	100	0	1	172	2682517	2682346	Staphylococcus aureus strain WH3018 chromosome	blastn	10292	318	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);;