metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA689790" 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
4496804	4496804	PRJNA689790_S_NODE_7684_length_213_cov_1.806818_g7569_i0	PRJNA689790	7684	213	1.806818	3.84852234	Halobacillus sp. SY10	3381356	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2862535527\|gb\|CP174345.1\|	3381356	g7569	i0	100	0.131455399061033	28	0	13	0	140	167	4000073	4000100	Halobacillus sp. SY10 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus sp. SY10
5006467	5006467	PRJNA689790_S_NODE_8224_length_206_cov_1.378698_g8109_i0	PRJNA689790	8224	206	1.378698	2.84011788	Streptococcus	1301	Bacteria	Bacteria	99	2.28e-16	NTclustered	gi\|2563027315\|gb\|CP132229.1\|	1346	g8109	i0	84.314	18.4902912621359	102	14	49	2	106	206	570220	570320	Streptococcus iniae strain BH16-24 chromosome, complete genome	blastn	3809	99	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus iniae
5772304	5772304	PRJNA689790_S_NODE_15385_length_155_cov_2.508475_g15270_i0	PRJNA689790	15385	155	2.508475	3.88813625	Viridibacillus sp. JNUCC-6	263475	Bacteria	Bacteria	106	9.64e-19	NTclustered	gi\|1927055251\|gb\|CP063302.1\|	2779527	g15270	i0	86	16.0838709677419	100	12	64	2	7	105	2071894	2071992	Viridibacillus sp. JNUCC-6 chromosome, complete genome	blastn	2493	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Viridibacillus	Viridibacillus sp. JNUCC-6
6282120	6282120	PRJNA689790_S_NODE_10985_length_179_cov_1.992958_g10870_i0	PRJNA689790	10985	179	1.992958	3.56739482	Bacillus	1386	Bacteria	Bacteria	58.4	3.26e-4	NTclustered	gi\|2049478593\|gb\|CP036023.1\|	1405	g10870	i0	89.583	3.53072625698324	48	1	26	4	133	179	1838984	1838940	Bacillus mycoides strain BPN52/2 chromosome, complete genome	blastn	632	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
9597239	9597239	PRJNA689790_S_NODE_10428_length_184_cov_1.129252_g10313_i0	PRJNA689790	10428	184	1.129252	2.07782368	Lactobacillus paragasseri	2107999	Bacteria	Bacteria	60.2	9.38e-5	NTclustered	gi\|2574589820\|gb\|CP102851.1\|	2107999	g10313	i0	94.737	1.39673913043478	38	2	21	0	146	183	808073	808036	Lactobacillus paragasseri strain IMAU FB017 chromosome, complete genome	blastn	257	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus paragasseri
9597289	9597289	PRJNA689790_S_NODE_5028_length_269_cov_2.456897_g4913_i0	PRJNA689790	5028	269	2.456897	6.60905293	Rossellomorea marisflavi	189381	Bacteria	Bacteria	62.1	4.09e-5	NTclustered	gi\|2530477131\|gb\|CP128801.1\|	189381	g4913	i0	97.222	0.360594795539033	36	1	13	0	204	239	1432300	1432265	Rossellomorea marisflavi strain SRCM125375 chromosome, complete genome	blastn	97	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea marisflavi
15206765	15206765	PRJNA689790_S_NODE_9852_length_188_cov_6.490066_g9737_i0	PRJNA689790	9852	188	6.490066	12.20132408	Niallia	2837506	Bacteria	Bacteria	331	1.85e-86	NTclustered	gi\|1512459853\|gb\|CP026031.1\|	1397	g9737	i0	98.404	1006.85106382979	188	3	100	0	1	188	2501020	2501207	Niallia circulans strain PK3_109 chromosome, complete genome	blastn	189288	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia circulans
19029826	19029826	PRJNA689790_S_NODE_9735_length_189_cov_7.236842_g9620_i0	PRJNA689790	9735	189	7.236842	13.67763138	Clostridium	1485	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1148326898\|gb\|CP016086.1\|	169679	g9620	i0	100	0.740740740740741	28	0	15	0	29	56	3362433	3362460	Clostridium saccharobutylicum strain NCP 200 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium saccharobutylicum
20304525	20304525	PRJNA689790_S_NODE_13436_length_164_cov_1.283465_g13321_i0	PRJNA689790	13436	164	1.283465	2.1048826	Staphylococcus	1279	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g13321	i0	99.394	555.987804878049	165	0	100	1	1	164	969990	969826	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	91182	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
20304543	20304543	PRJNA689790_S_NODE_6416_length_236_cov_1.175879_g6301_i0	PRJNA689790	6416	236	1.175879	2.77507444	Bacillales	1385	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1654115908\|gb\|CP028083.1\|	2070463	g6301	i0	100	0.23728813559322	28	0	12	0	41	68	2369669	2369696	Lysinibacillus sp. SGAir0095 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. SGAir0095
22855493	22855493	PRJNA689790_S_NODE_5838_length_248_cov_1.469194_g5723_i0	PRJNA689790	5838	248	1.4691940000000001	3.64360112	Bacillus	1386	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1967464082\|gb\|CP035727.2\|	257985	g5723	i0	100	0.338709677419355	28	0	11	0	44	71	5116881	5116854	Bacillus thuringiensis serovar andalousiensis strain NRRL B-23139 chromosome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
25404617	25404617	PRJNA689790_S_NODE_5940_length_245_cov_8.466346_g5825_i0	PRJNA689790	5940	245	8.466346	20.7425477	Sutcliffiella	2837511	Bacteria	Bacteria	394	3.189999999999999e-105	NTclustered	gi\|1231150564\|gb\|CP018866.1\|	33932	g5825	i0	95.902	1168.95918367347	244	8	99	2	2	245	2200	1959	Sutcliffiella cohnii strain DSM 6307 chromosome, complete genome	blastn	286395	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sutcliffiella	Sutcliffiella cohnii

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