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

13 rows where analysis = "blastn", bioproject = "PRJNA951388" 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
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
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
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
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
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
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
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

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