metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA397736" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA397736" 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
26617294	26617294	PRJNA397736_S_NODE_2001_length_191_cov_15.913580_g1965_i0	PRJNA397736	2001	191	15.91358	30.3949378	root	1	Root_unresolved	Root_unresolved	126	7.91e-36	NR	WP_214674608.1	562	g1965	i0	98.4	72.2356020942408	63	1	99	0	3	191	25	87	WP_214674608.1 hypothetical protein, partial [Escherichia coli]	diamond	13797	127	0.992125984251969	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27012046	27012046	PRJNA397736_S_NODE_1882_length_199_cov_3.505882_g1846_i0	PRJNA397736	1882	199	3.505882	6.97670518	Salmonella enterica	28901	Bacteria	Bacteria	67.4	2.96e-12	NR	MEY6259408.1	593905	g1846	i0	100	3.46733668341709	33	0	49.7	0	198	100	23	55	MEY6259408.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Corvallis]	diamond	690	67.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
28717672	28717672	PRJNA397736_S_NODE_2807_length_158_cov_3.945736_g2771_i0	PRJNA397736	2807	158	3.945736	6.23426288	Enterobacter hormaechei	158836	Bacteria	Bacteria	113	7.489999999999999e-30	NR	WP_149350502.1	158836	g2771	i0	100	50.1835443037975	52	0	98.7	0	158	3	136	187	WP_149350502.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	7929	113	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29254096	29254096	PRJNA397736_S_NODE_1909_length_197_cov_5.125000_g1873_i0	PRJNA397736	1909	197	5.125	10.09625	Klebsiella pneumoniae	573	Bacteria	Bacteria	135	1.85e-38	NR	KAB1688404.1	573	g1873	i0	98.5	60.3807106598985	65	1	99	0	197	3	17	81	KAB1688404.1 hypothetical protein FNE65_30290, partial [Klebsiella pneumoniae]	diamond	11895	135	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
29365843	29365843	PRJNA397736_S_NODE_2549_length_166_cov_2.737226_g2513_i0	PRJNA397736	2549	166	2.737226	4.54379516	root	1	Root_unresolved	Root_unresolved	105	2.25e-27	NR	WP_240057741.1	573	g2513	i0	100	135.180722891566	55	0	99.4	0	2	166	47	101	WP_240057741.1 cation-transporting P-type ATPase, partial [Klebsiella pneumoniae]	diamond	22440	105	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
29790881	29790881	PRJNA397736_S_NODE_431_length_448_cov_4.720764_g396_i0	PRJNA397736	431	448	4.720764	21.14902272	Salmonella enterica	28901	Bacteria	Bacteria	50.1	7.07e-5	NR	MEY6403347.1	593905	g396	i0	69.8	0.743303571428571	43	12	28.1	1	447	322	25	67	MEY6403347.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Corvallis]	diamond	333	50.4	0.994047619047619	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29885998	29885998	PRJNA397736_S_NODE_2351_length_175_cov_11.335616_g2315_i0	PRJNA397736	2351	175	11.335616	19.837328	Salmonella enterica	28901	Bacteria	Bacteria	114	2.6199999999999997e-30	NR	MEY6333246.1	593905	g2315	i0	98.3	21.8742857142857	58	1	99.4	0	175	2	58	115	MEY6333246.1 Hsp70 family protein [Salmonella enterica subsp. enterica serovar Corvallis]	diamond	3828	114	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
30282088	30282088	PRJNA397736_S_NODE_1452_length_232_cov_5.517241_g1416_i0	PRJNA397736	1452	232	5.517241	12.79999912	root	1	Root_unresolved	Root_unresolved	151	1.06e-45	NR	WP_248807857.1	573	g1416	i0	100	81.6336206896552	77	0	99.6	0	231	1	25	101	WP_248807857.1 KH domain-containing protein, partial [Klebsiella pneumoniae]	diamond	18939	151	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
31292751	31292751	PRJNA397736_S_NODE_2235_length_180_cov_5.556291_g2199_i0	PRJNA397736	2235	180	5.556291	10.0013238	root	1	Root_unresolved	Root_unresolved	112	1.01e-29	NR	WP_175283833.1	562	g2199	i0	100	217.433333333333	58	0	96.7	0	175	2	61	118	WP_175283833.1 Hsp70 family protein, partial [Escherichia coli]	diamond	39138	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32178765	32178765	PRJNA397736_S_NODE_1958_length_194_cov_4.860606_g1922_i0	PRJNA397736	1958	194	4.860606	9.42957564	root	1	Root_unresolved	Root_unresolved	107	2.6e-28	NR	WP_353960168.1	573	g1922	i0	100	59.1494845360825	51	0	78.9	0	192	40	66	116	WP_353960168.1 50S ribosomal protein L14 [Klebsiella pneumoniae]	diamond	11475	107	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);;