metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA951388" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA951388" 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
934758	934758	PRJNA951388_S_NODE_11301_length_243_cov_1.358824_g11174_i0	PRJNA951388	11301	243	1.358824	3.30194232	Rhodococcus sp. DN22	357684	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2675877924\|gb\|CP133326.1\|	357684	g11174	i0	100	48	243	0	100	0	1	243	4270423	4270181	Rhodococcus sp. DN22 strain strain DN22 chromosome, complete genome	blastn	11664	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. DN22
2210015	2210015	PRJNA951388_S_NODE_10322_length_256_cov_5.344262_g10195_i0	PRJNA951388	10322	256	5.344262	13.68131072	Mycoplasma wenyonii	65123	Bacteria	Bacteria	440	4.249999999999998e-119	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10195	i0	97.656	1	256	6	100	0	1	256	397112	397367	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	256	440	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3814793	3814793	PRJNA951388_S_NODE_10503_length_254_cov_2.232044_g10376_i0	PRJNA951388	10503	254	2.232044	5.66939176	Paenibacillus	44249	Bacteria	Bacteria	451	1.95e-122	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g10376	i0	98.819	4.97637795275591	254	2	100	1	1	254	3891529	3891781	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1264	451	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
3814796	3814796	PRJNA951388_S_NODE_3983_length_408_cov_2.591045_g3856_i0	PRJNA951388	3983	408	2.591045	10.5714636	Cutibacterium	1912216	Bacteria	Bacteria	754	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g3856	i0	100	273.882352941176	408	0	100	0	1	408	608485	608892	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	111744	754	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5091099	5091099	PRJNA951388_S_NODE_6004_length_346_cov_1.974359_g5877_i0	PRJNA951388	6004	346	1.974359	6.83128214	Paenibacillus	44249	Bacteria	Bacteria	623	5.529999999999999e-174	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g5877	i0	99.133	5	346	3	100	0	1	346	1480794	1481139	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1730	623	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
6037878	6037878	PRJNA951388_S_NODE_11765_length_235_cov_3.783951_g11638_i0	PRJNA951388	11765	235	3.783951	8.89228485	Staphylococcus cohnii	29382	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g11638	i0	100	99.2255319148936	235	0	100	0	1	235	538828	538594	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	23318	435	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
6037898	6037898	PRJNA951388_S_NODE_8705_length_285_cov_1.816038_g8578_i0	PRJNA951388	8705	285	1.816038	5.1757083	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	387	6.349999999999998e-103	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g8578	i0	91.228	134.126315789474	285	24	99	1	1	284	1774	2058	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38226	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6366800	6366800	PRJNA951388_S_NODE_10925_length_248_cov_1.245714_g10798_i0	PRJNA951388	10925	248	1.245714	3.08937072	Bacillales	1385	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g10798	i0	100	471.778225806452	248	0	100	0	1	248	771518	771765	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	117001	459	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
7640721	7640721	PRJNA951388_S_NODE_11786_length_235_cov_2.364198_g11659_i0	PRJNA951388	11786	235	2.364198	5.5558653	Kocuria	57493	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1540076968\|emb\|LR134391.1\|	1275	g11659	i0	100	270.527659574468	235	0	100	0	1	235	1080204	1080438	Kocuria rosea strain NCTC7514 genome assembly, chromosome: 1	blastn	63574	435	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
7640724	7640724	PRJNA951388_S_NODE_2646_length_469_cov_2.732323_g2519_i0	PRJNA951388	2646	469	2.732323	12.81459487	Corynebacterium	1716	Bacteria	Bacteria	771	0	NTclustered	gi\|1958403034\|gb\|CP068165.1\|	169292	g2519	i0	96.391	401.92750533049	471	12	100	5	1	469	400190	399723	Corynebacterium aurimucosum strain FDAARGOS_1110 chromosome, complete genome	blastn	188504	771	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium aurimucosum
11138416	11138416	PRJNA951388_S_NODE_9969_length_262_cov_1.201058_g9842_i0	PRJNA951388	9969	262	1.201058	3.14677196	Paenibacillus glucanolyticus	59843	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g9842	i0	100	5	262	0	100	0	1	262	3900129	3900390	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1310	484	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
12413841	12413841	PRJNA951388_S_NODE_2990_length_452_cov_2.266491_g2863_i0	PRJNA951388	2990	452	2.266491	10.24453932	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	643	5.679999999999999e-180	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g2863	i0	92.308	129.860619469027	455	31	100	3	1	452	3061	3514	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	58697	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12413860	12413860	PRJNA951388_S_NODE_7950_length_300_cov_1.356828_g7823_i0	PRJNA951388	7950	300	1.356828	4.070484	Dolosigranulum pigrum	29394	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|2020672664\|gb\|CP040417.1\|	29394	g7823	i0	100	25	300	0	100	0	1	300	1749628	1749329	Dolosigranulum pigrum strain KPL3077 chromosome	blastn	7500	555	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
12413864	12413864	PRJNA951388_S_NODE_8930_length_280_cov_3.946860_g8803_i0	PRJNA951388	8930	280	3.94686	11.051208	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	484	2.15e-132	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g8803	i0	97.857	327.960714285714	280	6	100	0	1	280	552129	551850	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	91829	484	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
12413866	12413866	PRJNA951388_S_NODE_9710_length_266_cov_1.797927_g9583_i0	PRJNA951388	9710	266	1.797927	4.78248582	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	486	5.629999999999999e-133	NTclustered	gi\|2094528057\|gb\|CP065376.1\|	853	g9583	i0	99.624	374.65037593985	266	1	100	0	1	266	1907144	1907409	Faecalibacterium prausnitzii strain Fp360 chromosome, complete genome	blastn	99657	486	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
13688414	13688414	PRJNA951388_S_NODE_7631_length_307_cov_2.303419_g7504_i0	PRJNA951388	7631	307	2.303419	7.07149633	Mammaliicoccus stepanovicii	643214	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1231729876\|emb\|LT906462.1\|	643214	g7504	i0	94.286	0.11400651465798	35	1	11	1	108	142	1704667	1704700	Staphylococcus stepanovicii strain NCTC13839 genome assembly, chromosome: 1	blastn	35	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus stepanovicii
16565290	16565290	PRJNA951388_S_NODE_6633_length_330_cov_1.354086_g6506_i0	PRJNA951388	6633	330	1.354086	4.4684838	Streptococcus	1301	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|2288405307\|gb\|CP076703.1\|	1335	g6506	i0	100	538.990909090909	330	0	100	0	1	330	19075	19404	Streptococcus equinus strain S1 chromosome, complete genome	blastn	177867	610	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
17512877	17512877	PRJNA951388_S_NODE_13054_length_204_cov_23.015267_g12927_i0	PRJNA951388	13054	204	23.015267	46.95114468	Caloranaerobacter azorensis	116090	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1810187734\|gb\|CP048617.1\|	116090	g12927	i0	100	0.142156862745098	29	0	14	0	47	75	1707585	1707613	Caloranaerobacter azorensis strain T3-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Thermohalobacteraceae	Caloranaerobacter	Caloranaerobacter azorensis
19114105	19114105	PRJNA951388_S_NODE_7635_length_307_cov_1.970085_g7508_i0	PRJNA951388	7635	307	1.970085	6.04816095	Staphylococcus	1279	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|2521904872\|gb\|CP127705.1\|	1280	g7508	i0	100	506.026058631922	307	0	100	0	1	307	2019802	2020108	Staphylococcus aureus strain C351 chromosome, complete genome	blastn	155350	568	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
21336811	21336811	PRJNA951388_S_NODE_11037_length_246_cov_3.115607_g10910_i0	PRJNA951388	11037	246	3.115607	7.66439322	Caproiciproducens sp. CPB-2	3030017	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2663189403\|gb\|CP142860.1\|	3030017	g10910	i0	100	0.121951219512195	30	0	12	0	67	96	1892626	1892655	Caproiciproducens sp. CPB-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae	Caproiciproducens	Caproiciproducens sp. CPB-2
22940506	22940506	PRJNA951388_S_NODE_12538_length_219_cov_4.500000_g12411_i0	PRJNA951388	12538	219	4.5	9.855	Cutibacterium	1912216	Bacteria	Bacteria	383	6.05e-102	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g12411	i0	98.182	239.936073059361	220	3	100	1	1	219	55619	55838	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	52546	383	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22940511	22940511	PRJNA951388_S_NODE_5498_length_360_cov_3.473868_g5371_i0	PRJNA951388	5498	360	3.473868	12.5059248	Paenibacillus	44249	Bacteria	Bacteria	654	0	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g5371	i0	99.444	13.7638888888889	360	2	100	0	1	360	4099727	4100086	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	4955	654	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
22940520	22940520	PRJNA951388_S_NODE_8658_length_286_cov_1.784038_g8531_i0	PRJNA951388	8658	286	1.784038	5.10234868	Cellulomonas	1707	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2571366987\|gb\|OR498076.1\|	40001	g8531	i0	100	103	286	0	100	0	1	286	874	589	Cellulomonas sp. strain ATA003 16S ribosomal RNA gene, partial sequence	blastn	29458	529	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas sp.
25489293	25489293	PRJNA951388_S_NODE_10680_length_251_cov_2.960674_g10553_i0	PRJNA951388	10680	251	2.960674	7.43129174	Mycoplasma	2093	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|470490338\|ref\|NR_076982.1\|	65123	g10553	i0	100	126.051792828685	251	0	100	0	1	251	2741	2491	Mycoplasma wenyonii strain Massachusetts 23S ribosomal RNA gene, complete sequence	blastn	31639	464	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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