metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA610520" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA610520" 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
26605113	26605113	PRJNA610520_S_NODE_70221_length_236_cov_2.834356_g70131_i0	PRJNA610520	70221	236	2.834356	6.68908016	Pleionea sediminis	2569479	Bacteria	Bacteria	64.3	5.05e-10	NR	WP_144392370.1	2569479	g70131	i0	41.6	2.9364406779661	77	45	97.9	0	6	236	23	99	WP_144392370.1 TatD family hydrolase [Pleionea sediminis]	diamond	693	64.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Pleioneaceae	Pleionea	Pleionea sediminis
26921962	26921962	PRJNA610520_S_NODE_22622_length_349_cov_1.094203_g22532_i0	PRJNA610520	22622	349	1.094203	3.81876847	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	113	3.18e-28	NR	MBP5215296.1	1913988	g22532	i0	60	3.30085959885387	100	39	86	1	347	48	150	248	MBP5215296.1 chaperonin GroEL [Alphaproteobacteria bacterium]	diamond	1152	113	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
27838081	27838081	PRJNA610520_S_NODE_47564_length_277_cov_2.882353_g47474_i0	PRJNA610520	47564	277	2.882353	7.98411781	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	61.2	1.49e-8	NR	MCH9845700.1	1913988	g47474	i0	44.6	0.703971119133574	65	36	70.4	0	4	198	89	153	MCH9845700.1 thioredoxin [Alphaproteobacteria bacterium]	diamond	195	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28059197	28059197	PRJNA610520_S_NODE_65925_length_245_cov_0.895349_g65835_i0	PRJNA610520	65925	245	0.895349	2.19360505	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	47	4.71e-4	NR	WP_395515008.1	251699	g65835	i0	42.1	1.82448979591837	76	42	90.6	1	21	242	48	123	WP_395515008.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	447	47	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7
28103799	28103799	PRJNA610520_S_NODE_54825_length_262_cov_9.142857_g54735_i0	PRJNA610520	54825	262	9.142857	23.95428534	root	1	Root_unresolved	Root_unresolved	41.6	0.0185	NR	WP_143213185.1	470	g54735	i0	100	87.9389312977099	20	0	22.9	0	262	203	55	74	WP_143213185.1 hypothetical protein, partial [Acinetobacter baumannii]	diamond	23040	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
31217190	31217190	PRJNA610520_S_NODE_60195_length_252_cov_2.553073_g60105_i0	PRJNA610520	60195	252	2.553073	6.43374396	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	47.8	6.78e-4	NR	RMH17565.1	1913989	g60105	i0	35.7	0.666666666666667	56	36	66.7	0	30	197	336	391	RMH17565.1 MAG: DUF4124 domain-containing protein [Gammaproteobacteria bacterium]	diamond	168	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
31723588	31723588	PRJNA610520_S_NODE_61937_length_250_cov_1.056497_g61847_i0	PRJNA610520	61937	250	1.056497	2.6412425	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	42.7	0.0325	NR	WP_395569333.1	251699	g61847	i0	44.4	0.756	63	16	74.4	3	54	239	153	197	WP_395569333.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	189	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7

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