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

32 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
895045	895045	PRJNA915212_P_NODE_12901_length_165_cov_0.879310_g12863_i0	PRJNA915212	12901	165	0.87931	1.4508615	Actinomadura sp. NAK00032	2742128	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1860167784\|gb\|CP054932.1\|	2742128	g12863	i0	100	0.16969696969697	28	0	17	0	44	71	2541788	2541761	Actinomadura sp. NAK00032 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp. NAK00032
895123	895123	PRJNA915212_P_NODE_8481_length_200_cov_1.013245_g8443_i0	PRJNA915212	8481	200	1.013245	2.02649	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	359	9.14e-95	NTclustered	gi\|1806463312\|dbj\|AP022616.1\|	319706	g8443	i0	99.005	172.17	201	1	100	1	1	200	418430	418630	Mycolicibacterium phocaicum JCM 15301 DNA, nearly complete genome	blastn	34434	359	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
2170576	2170576	PRJNA915212_P_NODE_7022_length_221_cov_0.872093_g6984_i0	PRJNA915212	7022	221	0.872093	1.92732553	Dolichospermum sp. DL01	2717871	Bacteria	Bacteria	86.1	1.93e-12	NTclustered	gi\|2004368895\|gb\|CP050884.1\|	2717871	g6984	i0	94.545	23.3755656108597	55	3	25	0	8	62	712392	712338	MAG: Dolichospermum sp. DL01 chromosome, complete genome	blastn	5166	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. DL01
2526669	2526669	PRJNA915212_P_NODE_14062_length_163_cov_0.894737_g14024_i0	PRJNA915212	14062	163	0.894737	1.45842131	Microbacteriaceae	85023	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|2230249747\|gb\|CP078077.1\|	2851646	g14024	i0	93.023	5.14110429447853	43	0	25	3	65	105	528179	528138	Microbacterium galbinum strain SSW1-36 chromosome	blastn	838	60.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium galbinum
3446049	3446049	PRJNA915212_P_NODE_7743_length_210_cov_0.950311_g7705_i0	PRJNA915212	7743	210	0.950311	1.9956531	Clostridium botulinum	1491	Bacteria	Bacteria	58.4	3.96e-4	NTclustered	gi\|2331077869\|dbj\|AP025140.1\|	1491	g7705	i0	97.059	0.161904761904762	34	1	16	0	79	112	2996489	2996522	Clostridium botulinum Osaka2020 DNA, complete genome	blastn	34	58.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
3446058	3446058	PRJNA915212_P_NODE_9243_length_191_cov_1.246479_g9205_i0	PRJNA915212	9243	191	1.246479	2.38077489	Halothermothrix orenii	31909	Bacteria	Bacteria	143	9.479999999999999e-30	NTclustered	gi\|219992160\|gb\|CP001098.1\|	373903	g9205	i0	83.019	20.7643979057592	159	25	83	2	11	168	1689024	1689181	Halothermothrix orenii H 168, complete genome	blastn	3966	143	1	Bacteria		Bacillati	Bacillota	Clostridia	Halanaerobiales	Halothermotrichaceae	Halothermothrix	Halothermothrix orenii
4723643	4723643	PRJNA915212_P_NODE_12664_length_165_cov_1.310345_g12626_i0	PRJNA915212	12664	165	1.310345	2.16206925	Selenomonas sp.	2053611	Bacteria	Bacteria	124	2.88e-24	NTclustered	gi\|2913850746\|gb\|CP181254.1\|	2053611	g12626	i0	80.488	85.3090909090909	164	30	99	2	1	163	309614	309776	MAG: Selenomonas sp. isolate UW_FK_SELE1_1 chromosome	blastn	14076	124	1	Bacteria		Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp.
5998347	5998347	PRJNA915212_P_NODE_13005_length_165_cov_0.879310_g12967_i0	PRJNA915212	13005	165	0.87931	1.4508615	Streptomyces sp. R39	3238631	Bacteria	Bacteria	93.5	8.13e-15	NTclustered	gi\|2783507500\|gb\|CP163442.1\|	3238631	g12967	i0	80.833	29.5151515151515	120	21	72	2	3	121	256120	256002	Streptomyces sp. R39 plasmid unnamed1, complete sequence	blastn	4870	93.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. R39
6355116	6355116	PRJNA915212_P_NODE_545_length_901_cov_1.816901_g523_i0	PRJNA915212	545	901	1.816901	16.37027801	Mycobacteriaceae	1762	Bacteria	Bacteria	1447	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g523	i0	95.686	187.638179800222	904	31	100	4	1	901	1312776	1313674	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	169062	1447	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
7273332	7273332	PRJNA915212_P_NODE_13686_length_163_cov_0.894737_g13648_i0	PRJNA915212	13686	163	0.894737	1.45842131	Mycolicibacterium goodii	134601	Bacteria	Bacteria	261	2.07e-65	NTclustered	gi\|2289144095\|gb\|CP092364.2\|	134601	g13648	i0	95.706	165.263803680982	163	6	100	1	1	163	1003765	1003926	Mycolicibacterium goodii strain ATCC 700504 chromosome, complete genome	blastn	26938	261	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium goodii
8548075	8548075	PRJNA915212_P_NODE_1787_length_497_cov_2.008929_g1752_i0	PRJNA915212	1787	497	2.008929	9.98437713	Streptomyces virginiae	1961	Bacteria	Bacteria	303	1.21e-77	NTclustered	gi\|2687121656\|gb\|CP145515.1\|	1961	g1752	i0	78.511	80.0603621730382	470	95	94	5	3	469	3199931	3200397	Streptomyces virginiae strain THA-960 chromosome, complete genome	blastn	39790	303	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
8903878	8903878	PRJNA915212_P_NODE_6667_length_227_cov_0.859551_g6629_i0	PRJNA915212	6667	227	0.859551	1.95118077	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2513827645\|gb\|CP126446.1\|	265426	g6629	i0	96.875	0.295154185022026	32	1	14	0	191	222	3462833	3462802	Pontibacillus chungwhensis strain HN14 chromosome, complete genome	blastn	67	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus chungwhensis
9823046	9823046	PRJNA915212_P_NODE_4828_length_273_cov_1.584821_g4790_i0	PRJNA915212	4828	273	1.584821	4.32656133	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	364	2.8299999999999993e-96	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g4790	i0	90.842	176.032967032967	273	23	99	2	1	272	1832	2103	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48057	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9823064	9823064	PRJNA915212_P_NODE_6908_length_222_cov_2.271676_g6870_i0	PRJNA915212	6908	222	2.271676	5.04312072	Tsukamurella pulmonis	47312	Bacteria	Bacteria	86.1	1.94e-12	NTclustered	gi\|2174344570\|dbj\|AP025457.1\|	47312	g6870	i0	86.076	40.4279279279279	79	11	36	0	48	126	1608458	1608380	Tsukamurella pulmonis TP-B0596 DNA, complete genome	blastn	8975	86.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella pulmonis
9823083	9823083	PRJNA915212_P_NODE_8988_length_194_cov_1.055172_g8950_i0	PRJNA915212	8988	194	1.055172	2.04703368	Streptomyces sp. NBC_01276	2903808	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2661462342\|gb\|CP108442.1\|	2903808	g8950	i0	100	0.438144329896907	29	0	15	0	78	106	7536489	7536461	Streptomyces sp. NBC_01276 chromosome, complete genome	blastn	85	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01276
10179610	10179610	PRJNA915212_P_NODE_10868_length_174_cov_1.400000_g10830_i0	PRJNA915212	10868	174	1.4	2.436	Streptomyces	1883	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2657704044\|gb\|CP109044.1\|	1944	g10830	i0	100	0.32183908045977	28	0	16	0	122	149	3015218	3015191	Streptomyces halstedii strain NBC 00641 chromosome, complete genome	blastn	56	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces halstedii
11098615	11098615	PRJNA915212_P_NODE_11489_length_168_cov_2.117647_g11451_i0	PRJNA915212	11489	168	2.117647	3.55764696	Rhodococcus opacus	37919	Bacteria	Bacteria	63.9	6.52e-6	NTclustered	gi\|2921205402\|gb\|CP134707.1\|	37919	g11451	i0	100	4.76190476190476	34	0	20	0	135	168	3965997	3966030	Rhodococcus opacus strain DSM 43205 chromosome, complete genome	blastn	800	63.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
12374251	12374251	PRJNA915212_P_NODE_12930_length_165_cov_0.879310_g12892_i0	PRJNA915212	12930	165	0.87931	1.4508615	Ilumatobacter coccineus	467094	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|464097432\|dbj\|AP012057.1\|	1313172	g12892	i0	92.683	0.248484848484848	41	3	25	0	112	152	692553	692513	Ilumatobacter coccineus YM16-304 DNA, complete genome	blastn	41	60.2	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae	Ilumatobacter	Ilumatobacter coccineus
12374253	12374253	PRJNA915212_P_NODE_13210_length_164_cov_0.886957_g13172_i0	PRJNA915212	13210	164	0.886957	1.45460948	Paenibacillus sp. RC67	3039392	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2506068966\|gb\|CP125098.1\|	3039392	g13172	i0	100	0.170731707317073	28	0	17	0	18	45	287401	287428	Paenibacillus sp. RC67 chromosome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. RC67
12374258	12374258	PRJNA915212_P_NODE_14470_length_162_cov_0.902655_g14432_i0	PRJNA915212	14470	162	0.902655	1.4623011	uncultured cyanobacterium	1211	Bacteria	Bacteria	279	5.68e-71	NTclustered	gi\|146142255\|gb\|EF522759.1\|	1211	g14432	i0	98.125	98.9753086419753	160	3	99	0	3	162	55	214	Uncultured cyanobacterium clone SCSS058 16S ribosomal RNA gene, partial sequence	blastn	16034	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13648768	13648768	PRJNA915212_P_NODE_4491_length_286_cov_1.232068_g4453_i0	PRJNA915212	4491	286	1.232068	3.52371448	Yimella sp. cx-51	2770551	Bacteria	Bacteria	122	1.99e-23	NTclustered	gi\|2019559805\|gb\|CP072113.1\|	2770551	g4453	i0	91.111	31.3216783216783	90	8	31	0	61	150	2085599	2085510	Yimella sp. cx-51 chromosome, complete genome	blastn	8958	122	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Yimella	Yimella sp. cx-51
13648777	13648777	PRJNA915212_P_NODE_5471_length_253_cov_2.122549_g5433_i0	PRJNA915212	5471	253	2.122549	5.37004897	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	420	5.46e-113	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g5433	i0	97.551	129.328063241107	245	6	97	0	9	253	1312827	1312583	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	32720	420	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
14923105	14923105	PRJNA915212_P_NODE_4052_length_304_cov_2.125490_g4014_i0	PRJNA915212	4052	304	2.12549	6.4614896	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2697500286\|gb\|CP146988.1\|	68042	g4014	i0	100	0.1875	29	0	10	0	224	252	9087023	9087051	Streptomyces hygroscopicus subsp. hygroscopicus strain DSM 41954 chromosome, complete genome	blastn	57	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
15278996	15278996	PRJNA915212_P_NODE_3492_length_335_cov_1.783217_g3455_i0	PRJNA915212	3492	335	1.783217	5.97377695	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g3455	i0	86.538	0.952238805970149	52	4	15	3	71	120	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
16197988	16197988	PRJNA915212_P_NODE_11313_length_170_cov_1.264463_g11275_i0	PRJNA915212	11313	170	1.264463	2.1495871	Terribacillus sp. FSL K6-0262	2921447	Bacteria	Bacteria	159	8.139999999999998e-35	NTclustered	gi\|2709996983\|gb\|CP150277.1\|	2921447	g11275	i0	85.621	163.458823529412	153	20	89	2	1	152	1537701	1537852	Terribacillus sp. FSL K6-0262 chromosome, complete genome	blastn	27788	159	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terribacillus	Terribacillus sp. FSL K6-0262
16197992	16197992	PRJNA915212_P_NODE_11753_length_167_cov_0.864407_g11715_i0	PRJNA915212	11753	167	0.864407	1.44355969	Microbacterium sp. JZ31	1906274	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1972867151\|gb\|CP017661.1\|	1906274	g11715	i0	94.118	0.203592814371257	34	2	20	0	107	140	3083320	3083287	Microbacterium sp. JZ31, complete genome	blastn	34	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. JZ31
16198032	16198032	PRJNA915212_P_NODE_2533_length_408_cov_2.359331_g2497_i0	PRJNA915212	2533	408	2.359331	9.62607048	Blastococcus saxobsidens	138336	Bacteria	Bacteria	75	8.36e-9	NTclustered	gi\|378781357\|emb\|FO117623.1\|	1146883	g2497	i0	92.308	0.379901960784314	52	4	13	0	73	124	4765870	4765921	Blastococcus saxobsidens DD2 complete genome	blastn	155	75	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
16198083	16198083	PRJNA915212_P_NODE_7073_length_220_cov_1.157895_g7035_i0	PRJNA915212	7073	220	1.157895	2.547369	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	1.16e-4	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g7035	i0	100	0.145454545454545	32	0	15	0	109	140	112206	112237	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
16553518	16553518	PRJNA915212_P_NODE_10273_length_180_cov_1.809160_g10235_i0	PRJNA915212	10273	180	1.80916	3.256488	root	1	Root_unresolved	Root_unresolved	69.4	1.52e-7	NTclustered	gi\|2049644612\|gb\|CP036059.1\|	1405	g10235	i0	82.143	8.47777777777778	84	12	45	2	17	97	53685	53768	Bacillus mycoides strain JAS06/1 plasmid p88	blastn	1526	69.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
16553529	16553529	PRJNA915212_P_NODE_3193_length_354_cov_2.003279_g3156_i0	PRJNA915212	3193	354	2.003279	7.09160766	Actinomycetes	1760	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|610391492\|gb\|CP006842.1\|	1404245	g3156	i0	96.875	0.172316384180791	32	1	9	0	88	119	1711868	1711837	Corynebacterium glyciniphilum AJ 3170, complete genome	blastn	61	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glyciniphilum
17828551	17828551	PRJNA915212_P_NODE_12174_length_166_cov_1.179487_g12136_i0	PRJNA915212	12174	166	1.179487	1.95794842	Mycobacteriaceae	1762	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g12136	i0	100	112.530120481928	166	0	100	0	1	166	1312468	1312303	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	18680	307	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
23847461	23847461	PRJNA915212_P_NODE_9419_length_189_cov_1.450000_g9381_i0	PRJNA915212	9419	189	1.45	2.7405	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2581474101\|gb\|CP134769.1\|	1590	g9381	i0	92.308	0.354497354497354	39	3	21	0	90	128	882489	882451	Lactiplantibacillus plantarum strain SYBC-SM2 chromosome, complete genome	blastn	67	56.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum

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