metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1085664" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1085664" 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
1017248	1017248	PRJNA1085664_S_NODE_15641_length_220_cov_1.316384_g15222_i0	PRJNA1085664	15641	220	1.316384	2.8960448	root	1	Root_unresolved	Root_unresolved	396	7.809999999999997e-106	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g15222	i0	99.095	96.6454545454545	221	1	100	1	1	220	1316	1096	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	21262	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
1468192	1468192	PRJNA1085664_S_NODE_29342_length_164_cov_1.165289_g28923_i0	PRJNA1085664	29342	164	1.165289	1.91107396	Hathewaya histolytica	1498	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g28923	i0	100	1.85975609756098	164	0	100	0	1	164	2093558	2093721	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	305	303	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
11220760	11220760	PRJNA1085664_S_NODE_12009_length_251_cov_1.355769_g11590_i0	PRJNA1085664	12009	251	1.355769	3.40298019	Streptococcus	1301	Bacteria	Bacteria	440	4.149999999999998e-119	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g11590	i0	98.406	563.163346613546	251	3	99	1	1	250	17856	18106	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	141354	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
12496143	12496143	PRJNA1085664_S_NODE_29450_length_163_cov_2.741667_g29031_i0	PRJNA1085664	29450	163	2.741667	4.46891721	Lactobacillus	1578	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2323788530\|gb\|CP109946.1\|	1584	g29031	i0	100	557.914110429448	163	0	100	0	1	163	745674	745512	Lactobacillus delbrueckii strain sunkii chromosome, complete genome	blastn	90940	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
18868964	18868964	PRJNA1085664_S_NODE_11775_length_253_cov_1.961905_g11356_i0	PRJNA1085664	11775	253	1.961905	4.96361965	root	1	Root_unresolved	Root_unresolved	424	4.22e-114	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g11356	i0	100	156.513833992095	229	0	91	0	25	253	819	1047	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	39598	424	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);;