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

31 rows where analysis = "blastn", bioproject = "PRJNA1136957" 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
1032009	1032009	PRJNA1136957_S_NODE_11361_length_254_cov_1.415385_g11264_i0	PRJNA1136957	11361	254	1.415385	3.5950779	Streptococcus	1301	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|2563200286\|dbj\|AP028603.1\|	1313	g11264	i0	99.606	339	254	1	100	0	1	254	18537	18284	Streptococcus pneumoniae Pne2 DNA, complete genome	blastn	86106	464	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
1032022	1032022	PRJNA1136957_S_NODE_5181_length_350_cov_1.467354_g5084_i0	PRJNA1136957	5181	350	1.467354	5.135739	Planktothrix	54304	Bacteria	Bacteria	65.8	4.25e-6	NTclustered	gi\|2261189783\|emb\|LR882967.1\|	132604	g5084	i0	90.385	3.53142857142857	52	2	15	3	202	253	3341439	3341391	Planktothrix pseudagardhii strain No.713 genome assembly, chromosome: I	blastn	1236	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix pseudagardhii
1559141	1559141	PRJNA1136957_S_NODE_11362_length_254_cov_1.410256_g11265_i0	PRJNA1136957	11362	254	1.410256	3.58205024	Nocardioides scoriae	642780	Bacteria	Bacteria	100	8.12e-17	NTclustered	gi\|1085860874\|emb\|LT629757.1\|	642780	g11265	i0	96.667	0.47244094488189	60	2	24	0	40	99	2658689	2658748	Marmoricola scoriae strain DSM 22127 genome assembly, chromosome: I	blastn	120	100	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides scoriae
1559164	1559164	PRJNA1136957_S_NODE_15462_length_221_cov_1.759259_g15365_i0	PRJNA1136957	15462	221	1.759259	3.88796239	Actinomyces wuliandei	2057743	Bacteria	Bacteria	58.4	4.21e-4	NTclustered	gi\|1552076344\|gb\|CP025227.1\|	2057743	g15365	i0	90.909	0.199095022624434	44	2	19	2	174	216	2740185	2740227	Actinomyces wuliandei strain 299 chromosome, complete genome	blastn	44	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces wuliandei
2835280	2835280	PRJNA1136957_S_NODE_5623_length_339_cov_1.728571_g5526_i0	PRJNA1136957	5623	339	1.728571	5.85985569	Bacillus manliponensis	574376	Bacteria	Bacteria	60.2	1.91e-4	NTclustered	gi\|2785673827\|gb\|CP165965.1\|	574376	g5526	i0	97.143	6.80530973451327	35	1	10	0	56	90	2808510	2808476	Bacillus manliponensis strain jeju3-1 chromosome, complete genome	blastn	2307	60.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus manliponensis
2835300	2835300	PRJNA1136957_S_NODE_8483_length_289_cov_1.326087_g8386_i0	PRJNA1136957	8483	289	1.326087	3.83239143	Agrococcus sp. SL85	2995141	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2381128626\|gb\|CP113066.1\|	2995141	g8386	i0	100	0.100346020761246	29	0	10	0	171	199	1718431	1718403	Agrococcus sp. SL85 chromosome	blastn	29	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agrococcus	Agrococcus sp. SL85
5387778	5387778	PRJNA1136957_S_NODE_17985_length_205_cov_1.671233_g17888_i0	PRJNA1136957	17985	205	1.671233	3.42602765	Miltoncostaea marina	2843215	Bacteria	Bacteria	215	2.16e-51	NTclustered	gi\|2030071733\|gb\|CP064655.1\|	2843215	g17888	i0	86.07	20.7853658536585	201	26	98	2	1	200	1293900	1294099	Miltoncostaea marina strain SCSIO 60955 chromosome, complete genome	blastn	4261	215	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Miltoncostaeales	Miltoncostaeaceae	Miltoncostaea	Miltoncostaea marina
6662385	6662385	PRJNA1136957_S_NODE_10166_length_267_cov_2.639423_g10069_i0	PRJNA1136957	10166	267	2.639423	7.04725941	Micromonospora sp. NBC_01813	2975988	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2651870791\|gb\|CP109067.1\|	2975988	g10069	i0	100	0.112359550561798	30	0	11	0	85	114	6185696	6185725	Micromonospora sp. NBC_01813 chromosome, complete genome	blastn	30	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. NBC_01813
7409947	7409947	PRJNA1136957_S_NODE_926_length_586_cov_15.631879_g843_i0	PRJNA1136957	926	586	15.631879	91.60281094	Clostridioides	1870884	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2319031117\|gb\|CP107108.1\|	1496	g843	i0	97.059	5.29863481228669	34	1	6	0	55	88	3418885	3418918	Clostridioides difficile strain R_phiCD75-3 chromosome, complete genome	blastn	3105	58.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
9212622	9212622	PRJNA1136957_S_NODE_5008_length_354_cov_2.715254_g4911_i0	PRJNA1136957	5008	354	2.715254	9.61199916	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4911	i0	100	0.0790960451977401	28	0	8	0	210	237	7263647	7263620	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11235368	11235368	PRJNA1136957_S_NODE_8649_length_287_cov_0.885965_g8552_i0	PRJNA1136957	8649	287	0.885965	2.54271955	Arthrobacter	1663	Bacteria	Bacteria	470	6.18e-128	NTclustered	gi\|2921126289\|gb\|CP102608.1\|	619291	g8552	i0	96.167	224.073170731707	287	11	100	0	1	287	460417	460131	Arthrobacter sp. N1 chromosome, complete genome	blastn	64309	470	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. N1
12510739	12510739	PRJNA1136957_S_NODE_12330_length_245_cov_1.725806_g12233_i0	PRJNA1136957	12330	245	1.725806	4.2282247	Streptococcus	1301	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g12233	i0	100	353.277551020408	245	0	100	0	1	245	1571225	1571469	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	86553	453	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
12510753	12510753	PRJNA1136957_S_NODE_9310_length_278_cov_1.566210_g9213_i0	PRJNA1136957	9310	278	1.56621	4.3540638	Micrococcus	1269	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g9213	i0	100	283.712230215827	278	0	100	0	1	278	2260522	2260799	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	78872	514	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
13038276	13038276	PRJNA1136957_S_NODE_13531_length_234_cov_63.160000_g13434_i0	PRJNA1136957	13531	234	63.16	147.7944	Romboutsia ilealis	1115758	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1172272411\|emb\|LN555523.1\|	1115758	g13434	i0	100	0.123931623931624	29	0	12	0	165	193	1274284	1274312	Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
13038292	13038292	PRJNA1136957_S_NODE_16211_length_216_cov_2.331210_g16114_i0	PRJNA1136957	16211	216	2.33121	5.0354136	Clavibacter capsici	1874630	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1826985222\|gb\|CP048045.1\|	1874630	g16114	i0	94.444	0.944444444444444	36	0	17	2	102	137	366925	366892	Clavibacter capsici strain 1207 chromosome, complete genome	blastn	204	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter capsici
13785387	13785387	PRJNA1136957_S_NODE_8571_length_288_cov_0.986900_g8474_i0	PRJNA1136957	8571	288	0.9869	2.842272	root	1	Root_unresolved	Root_unresolved	505	1.7e-138	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g8474	i0	98.264	103.493055555556	288	5	100	0	1	288	1212	925	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	29806	510	0.990196078431373	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
15059695	15059695	PRJNA1136957_S_NODE_18192_length_204_cov_1.489655_g18095_i0	PRJNA1136957	18192	204	1.489655	3.0388962	Granulicatella	117563	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g18095	i0	99.02	473.779411764706	204	2	100	0	1	204	13687	13890	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	96651	366	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
15587453	15587453	PRJNA1136957_S_NODE_14293_length_229_cov_1.076471_g14196_i0	PRJNA1136957	14293	229	1.076471	2.46511859	Mycoplasma ovis	171632	Bacteria	Bacteria	132	2.55e-26	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g14196	i0	80.952	0.733624454148472	168	31	73	1	1	167	200005	200172	Mycoplasma ovis str. Michigan, complete genome	blastn	168	132	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
15587468	15587468	PRJNA1136957_S_NODE_17193_length_210_cov_1.615894_g17096_i0	PRJNA1136957	17193	210	1.615894	3.3933774	Microbacterium sp. PM5	2014534	Bacteria	Bacteria	289	1.29e-73	NTclustered	gi\|1419380645\|gb\|CP022162.1\|	2014534	g17096	i0	91.429	7.35238095238095	210	18	100	0	1	210	173850	174059	Microbacterium sp. PM5 genome	blastn	1544	289	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. PM5
16334419	16334419	PRJNA1136957_S_NODE_13213_length_237_cov_1.758427_g13116_i0	PRJNA1136957	13213	237	1.758427	4.16747199	root	1	Root_unresolved	Root_unresolved	438	1.4e-118	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g13116	i0	100	407.04641350211	237	0	100	0	1	237	559849	560085	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	96470	438	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
16861681	16861681	PRJNA1136957_S_NODE_17054_length_211_cov_1.203947_g16957_i0	PRJNA1136957	17054	211	1.203947	2.54032817	Mycoplasma wenyonii	65123	Bacteria	Bacteria	150	6.389999999999998e-32	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16957	i0	83.537	0.777251184834123	164	23	77	4	35	196	99414	99253	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	164	150	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19410494	19410494	PRJNA1136957_S_NODE_14556_length_227_cov_1.452381_g14459_i0	PRJNA1136957	14556	227	1.452381	3.29690487	Mycoplasma wenyonii	65123	Bacteria	Bacteria	230	8.699999999999997e-56	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g14459	i0	84.956	0.995594713656388	226	34	99	0	2	227	649918	649693	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	226	230	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19410508	19410508	PRJNA1136957_S_NODE_17056_length_211_cov_1.203947_g16959_i0	PRJNA1136957	17056	211	1.203947	2.54032817	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2874254042\|emb\|OY970366.1\|	152507	g16959	i0	100	0.14218009478673	30	0	14	0	34	63	193999	194028	MAG: uncultured Actinomycetes bacterium isolate MFD02923.bin.c.1 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
21433920	21433920	PRJNA1136957_S_NODE_5097_length_352_cov_1.402730_g5000_i0	PRJNA1136957	5097	352	1.40273	4.9376096	Cutibacterium	1912216	Bacteria	Bacteria	651	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g5000	i0	100	285.159090909091	352	0	100	0	1	352	608943	608592	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	100376	651	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21961325	21961325	PRJNA1136957_S_NODE_13758_length_233_cov_1.051724_g13661_i0	PRJNA1136957	13758	233	1.051724	2.45051692	Ligilactobacillus aviarius	1606	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2729058697\|emb\|OZ006997.1\|	1606	g13661	i0	100	575.296137339056	233	0	100	0	1	233	318192	318424	MAG: Ligilactobacillus aviarius isolate pooled_s2189.ctg002983c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	134044	431	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus aviarius
21961341	21961341	PRJNA1136957_S_NODE_15958_length_218_cov_1.534591_g15861_i0	PRJNA1136957	15958	218	1.534591	3.34540838	Amycolatopsis bartoniae	941986	Bacteria	Bacteria	75	4.11e-9	NTclustered	gi\|2884838259\|gb\|CP174150.1\|	941986	g15861	i0	88.889	1.05045871559633	63	4	28	3	131	190	2931098	2931160	Amycolatopsis bartoniae strain DSM 45807 chromosome, complete genome	blastn	229	75	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis bartoniae
22708892	22708892	PRJNA1136957_S_NODE_4738_length_361_cov_4.860927_g4641_i0	PRJNA1136957	4738	361	4.860927	17.54794647	Bacillati	1783272	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2657055515\|gb\|CP108334.1\|	1961	g4641	i0	100	0.473684210526316	28	0	8	0	278	305	3284904	3284931	Streptomyces virginiae strain NBC_00131 chromosome, complete genome	blastn	171	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
23236905	23236905	PRJNA1136957_S_NODE_3839_length_389_cov_2.754545_g3742_i0	PRJNA1136957	3839	389	2.754545	10.71518005	Nocardioides ochotonae	2685869	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1910930591\|gb\|CP061769.1\|	2685869	g3742	i0	96.875	0.0822622107969152	32	0	8	1	266	297	379040	379010	Nocardioides ochotonae strain ZJ1313 chromosome, complete genome	blastn	32	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides ochotonae
23984329	23984329	PRJNA1136957_S_NODE_16359_length_215_cov_2.737179_g16262_i0	PRJNA1136957	16359	215	2.737179	5.88493485	Streptomyces	1883	Bacteria	Bacteria	119	1.84e-22	NTclustered	gi\|2667573168\|gb\|CP107811.1\|	2975770	g16262	i0	84.426	62.1162790697674	122	17	56	2	9	129	3117344	3117224	Streptomyces sp. NBC_00539 chromosome, complete genome	blastn	13355	119	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00539
25258313	25258313	PRJNA1136957_S_NODE_12080_length_247_cov_1.888298_g11983_i0	PRJNA1136957	12080	247	1.888298	4.66409606	Cutibacterium	1912216	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11983	i0	100	268.141700404858	247	0	100	0	1	247	56944	56698	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	66231	457	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25258318	25258318	PRJNA1136957_S_NODE_13900_length_232_cov_1.005780_g13803_i0	PRJNA1136957	13900	232	1.00578	2.3334096	Bacillati	1783272	Bacteria	Bacteria	412	8.26e-111	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g13803	i0	98.707	117.086206896552	232	3	100	0	1	232	738	507	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	27164	412	1	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);;