metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1085664" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1085664" and tax_phylum = "Pseudomonadota"

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
26687618	26687618	PRJNA1085664_S_NODE_8221_length_301_cov_3.542636_g7802_i0	PRJNA1085664	8221	301	3.542636	10.66333436	Shigella sonnei	624	Bacteria	Bacteria	108	1.47e-28	NR	WP_353763804.1	624	g7802	i0	95.1	0.60797342192691	61	2	60.8	1	226	44	23	82	WP_353763804.1 hypothetical protein, partial [Shigella sonnei]	diamond	183	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei
29152094	29152094	PRJNA1085664_S_NODE_35309_length_152_cov_0.880734_g34890_i0	PRJNA1085664	35309	152	0.880734	1.33871568	Salmonella enterica	28901	Bacteria	Bacteria	42.4	0.00299	NR	WP_348968400.1	28901	g34890	i0	52.5	0.789473684210526	40	18	77	1	148	32	8	47	WP_348968400.1 hypothetical protein, partial [Salmonella enterica]	diamond	120	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29688173	29688173	PRJNA1085664_S_NODE_9950_length_275_cov_3.818966_g9531_i0	PRJNA1085664	9950	275	3.818966	10.5021565	Escherichia coli	562	Bacteria	Bacteria	43.1	0.00451	NR	WP_318767919.1	562	g9531	i0	52.5	0.436363636363636	40	18	42.5	1	171	55	16	55	WP_318767919.1 RBD-like domain-containing protein, partial [Escherichia coli]	diamond	120	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31711045	31711045	PRJNA1085664_S_NODE_34437_length_153_cov_0.872727_g34018_i0	PRJNA1085664	34437	153	0.872727	1.33527231	Gammaproteobacteria bacterium 28-57-27	1970513	Bacteria	Bacteria	43.5	0.00574	NR	OYY73998.1	1970513	g34018	i0	35.7	0.823529411764706	42	27	82.4	0	152	27	331	372	OYY73998.1 MAG: hypothetical protein B7Y40_07020 [Gammaproteobacteria bacterium 28-57-27]	diamond	126	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium 28-57-27
32027411	32027411	PRJNA1085664_S_NODE_28998_length_165_cov_1.163934_g28579_i0	PRJNA1085664	28998	165	1.163934	1.9204911	Rouxiella aceris	2703884	Bacteria	Bacteria	41.2	0.0377	NR	WP_169402176.1	2703884	g28579	i0	42.6	0.854545454545454	47	26	83.6	1	163	26	141	187	WP_169402176.1 type III secretion system domain-containing protein [Rouxiella aceris]	diamond	141	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Rouxiella	Rouxiella aceris
32848601	32848601	PRJNA1085664_S_NODE_21540_length_188_cov_5.296552_g21121_i0	PRJNA1085664	21540	188	5.296552	9.95751776	Klebsiella pneumoniae	573	Bacteria	Bacteria	48.5	4.63e-5	NR	WP_416532855.1	573	g21121	i0	59.4	1.00531914893617	32	13	51.1	0	186	91	100	131	WP_416532855.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	189	48.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae

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