metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1168532" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1168532" 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
27281089	27281089	PRJNA1168532_S_NODE_169343_length_242_cov_1.964824_g166400_i0	PRJNA1168532	169343	242	1.964824	4.75487408	Nitrosomonas	914	Bacteria	Bacteria	75.1	1.46e-13	NR	WP_082110325.1	914	g166400	i0	49.4	4.97107438016529	81	40	99.2	1	1	240	383	463	WP_082110325.1 MULTISPECIES: glycosyltransferase [Nitrosomonas]	diamond	1203	75.5	0.994701986754967	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosomonas
28430247	28430247	PRJNA1168532_S_NODE_363046_length_150_cov_0.878505_g360103_i0	PRJNA1168532	363046	150	0.878505	1.3177575	Pseudomonas oryzihabitans	47885	Bacteria	Bacteria	75.9	9.81e-15	NR	WP_313333256.1	47885	g360103	i0	100	0.78	39	0	78	0	149	33	256	294	WP_313333256.1 LysR family transcriptional regulator [Pseudomonas oryzihabitans]	diamond	117	75.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas oryzihabitans
31165272	31165272	PRJNA1168532_S_NODE_314215_length_164_cov_0.809917_g311272_i0	PRJNA1168532	314215	164	0.809917	1.32826388	root	1	Root_unresolved	Root_unresolved	90.1	3.4900000000000005e-21	NR	WP_236536977.1	317	g311272	i0	83.3	36.530487804878	54	9	98.8	0	1	162	76	129	WP_236536977.1 phosphotransferase, partial [Pseudomonas syringae]	diamond	5991	90.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae
31241040	31241040	PRJNA1168532_S_NODE_182275_length_232_cov_1.174603_g179332_i0	PRJNA1168532	182275	232	1.174603	2.72507896	Pseudomonas aeruginosa	287	Bacteria	Bacteria	75.1	4.4e-16	NR	WP_410954888.1	287	g179332	i0	86	0.556034482758621	43	6	55.6	0	99	227	7	49	WP_410954888.1 hypothetical protein, partial [Pseudomonas aeruginosa]	diamond	129	75.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
32127106	32127106	PRJNA1168532_S_NODE_160498_length_250_cov_1.338164_g157555_i0	PRJNA1168532	160498	250	1.338164	3.34541	Sulfitobacter sp.	1903071	Bacteria	Bacteria	44.3	0.00695	NR	MEH6831101.1	1903071	g157555	i0	46.2	0.468	39	20	45.6	1	128	15	36	74	MEH6831101.1 GNAT family N-acetyltransferase [Sulfitobacter sp.]	diamond	117	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Sulfitobacter	Sulfitobacter sp.

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