metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA645397" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA645397" 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
2434338	2434338	PRJNA645397_P_NODE_7322_length_191_cov_1.084507_g7249_i0	PRJNA645397	7322	191	1.084507	2.07140837	Staphylococcus	1279	Bacteria	Bacteria	292	8.89e-75	NTclustered	gi\|1835046049\|gb\|CP051643.1\|	29380	g7249	i0	97.661	513.251308900524	171	3	90	1	21	191	62417	62248	Staphylococcus caprae strain SY333 chromosome, complete genome	blastn	98031	294	0.993197278911565	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
4447360	4447360	PRJNA645397_P_NODE_9544_length_168_cov_0.873950_g9471_i0	PRJNA645397	9544	168	0.87395	1.468236	Salinicoccus halodurans	407035	Bacteria	Bacteria	254	3.6e-63	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g9471	i0	98.601	1.18452380952381	143	2	85	0	26	168	362630	362772	Salinicoccus halodurans strain H3B36, complete genome	blastn	199	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
7537069	7537069	PRJNA645397_P_NODE_9446_length_168_cov_0.873950_g9373_i0	PRJNA645397	9446	168	0.87395	1.468236	Bacillus	1386	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g9373	i0	99.405	100	168	1	100	0	1	168	180963	180796	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	16800	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
8272868	8272868	PRJNA645397_S_NODE_927_length_193_cov_1.048611_g925_i0	PRJNA645397	927	193	1.048611	2.02381923	Ruoffia tabacinasalis	87458	Bacteria	Bacteria	324	3.19e-84	NTclustered	gi\|2686201366\|gb\|CP144682.1\|	87458	g925	i0	96.891	5.22279792746114	193	6	100	0	1	193	2242587	2242395	Ruoffia tabacinasalis strain jzb001 chromosome, complete genome	blastn	1008	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Ruoffia	Ruoffia tabacinasalis
21022025	21022025	PRJNA645397_P_NODE_8277_length_179_cov_0.984615_g8204_i0	PRJNA645397	8277	179	0.984615	1.76246085	Salinicoccus halodurans	407035	Bacteria	Bacteria	268	1.3799999999999999e-67	NTclustered	gi\|820755876\|gb\|CP011366.1\|	407035	g8204	i0	97.468	0.88268156424581	158	2	88	2	22	179	1086101	1086256	Salinicoccus halodurans strain H3B36, complete genome	blastn	158	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus halodurans
21022034	21022034	PRJNA645397_P_NODE_9937_length_166_cov_0.888889_g9864_i0	PRJNA645397	9937	166	0.888889	1.47555574	Clostridioides difficile	1496	Bacteria	Bacteria	263	5.9e-66	NTclustered	gi\|2062474862\|gb\|CP072118.1\|	1496	g9864	i0	95.181	70.789156626506	166	8	100	0	1	166	4058394	4058229	Clostridioides difficile isolate MAR286 chromosome, complete genome	blastn	11751	263	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
24111063	24111063	PRJNA645397_P_NODE_11119_length_162_cov_0.876106_g11046_i0	PRJNA645397	11119	162	0.876106	1.41929172	Bacillus	1386	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2582827010\|gb\|CP135060.1\|	1396	g11046	i0	99.383	101	162	1	100	0	1	162	2094077	2093916	Bacillus cereus strain B126_1 chromosome, complete genome	blastn	16362	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus

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