metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB12366" 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
26875111	26875111	PRJEB12366_P_NODE_11441_length_220_cov_1.075676_g11251_i0	PRJEB12366	11441	220	1.075676	2.3664872	Solimonas sp.	1968834	Bacteria	Bacteria	58.2	2.82e-8	NR	HEY9544942.1	1968834	g11251	i0	43.4	2.01818181818182	76	37	98.2	2	218	3	5	78	HEY9544942.1 nuclear transport factor 2 family protein [Solimonas sp.]	diamond	444	58.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Solimonas	Solimonas sp.
26875118	26875118	PRJEB12366_P_NODE_15381_length_181_cov_1.342466_g15191_i0	PRJEB12366	15381	181	1.342466	2.42986346	Undibacterium oligocarboniphilum	666702	Bacteria	Bacteria	124	7.17e-33	NR	WP_176802312.1	666702	g15191	i0	100	0.994475138121547	60	0	99.4	0	181	2	10	69	WP_176802312.1 cell envelope integrity protein TolA [Undibacterium oligocarboniphilum]	diamond	180	124	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium oligocarboniphilum
26906465	26906465	PRJEB12366_P_NODE_18962_length_157_cov_1.311475_g18772_i0	PRJEB12366	18962	157	1.311475	2.05901575	Paludibacterium sp.	1917523	Bacteria	Bacteria	55.5	3.79e-7	NR	WP_293234248.1	1917523	g18772	i0	63	1.75796178343949	46	17	87.9	0	157	20	681	726	WP_293234248.1 beta strand repeat-containing protein, partial [Paludibacterium sp.]	diamond	276	55.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Paludibacterium	Paludibacterium sp.
27311404	27311404	PRJEB12366_P_NODE_19763_length_153_cov_1.228814_g19573_i0	PRJEB12366	19763	153	1.228814	1.88008542	root	1	Root_unresolved	Root_unresolved	65.9	5.32e-11	NR	WP_270022569.1	287	g19573	i0	72.5	376.921568627451	51	14	100	0	1	153	111	161	WP_270022569.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	57669	66.2	0.995468277945619	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28327775	28327775	PRJEB12366_P_NODE_13386_length_198_cov_1.147239_g13196_i0	PRJEB12366	13386	198	1.147239	2.27153322	Roseomonas acroporae	2937791	Bacteria	Bacteria	57	1.78e-7	NR	WP_248668258.1	2937791	g13196	i0	66.7	2.98484848484848	39	13	59.1	0	197	81	301	339	WP_248668258.1 alcohol dehydrogenase AdhP [Roseomonas acroporae]	diamond	591	57	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Roseomonadaceae	Roseomonas	Roseomonas acroporae
28763550	28763550	PRJEB12366_P_NODE_9947_length_240_cov_2.921951_g9757_i0	PRJEB12366	9947	240	2.921951	7.0126824	root	1	Root_unresolved	Root_unresolved	100	4.189999999999999e-24	NR	WP_369065166.1	562	g9757	i0	70	335	80	24	100	0	240	1	16	95	WP_369065166.1 hypothetical protein [Escherichia coli]	diamond	80400	101	0.99009900990099	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28769907	28769907	PRJEB12366_S_NODE_1347_length_202_cov_1.880240_g1339_i0	PRJEB12366	1347	202	1.88024	3.7980848	Gluconobacter cerinus	38307	Bacteria	Bacteria	43.1	0.0155	NR	MBS0993117.1	38307	g1339	i0	47.4	0.564356435643564	38	19	56.4	1	24	137	282	318	MBS0993117.1 Hint domain-containing protein [Gluconobacter cerinus]	diamond	114	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Gluconobacter	Gluconobacter cerinus
28927806	28927806	PRJEB12366_P_NODE_13588_length_196_cov_0.993789_g13398_i0	PRJEB12366	13588	196	0.993789	1.94782644	Klebsiella pneumoniae	573	Bacteria	Bacteria	47.8	2.76e-5	NR	WP_416515521.1	573	g13398	i0	48.9	0.719387755102041	47	24	71.9	0	8	148	16	62	WP_416515521.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	141	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
29521397	29521397	PRJEB12366_P_NODE_3910_length_428_cov_2.211196_g3720_i0	PRJEB12366	3910	428	2.211196	9.46391888	Roseateles	93681	Bacteria	Bacteria	56.6	7.8e-8	NR	WP_378991028.1	431058	g3720	i0	71.1	0.932242990654206	45	5	31.5	1	301	167	1	37	WP_378991028.1 hypothetical protein [Pelomonas aquatica]	diamond	399	56.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Pelomonas aquatica
29780314	29780314	PRJEB12366_P_NODE_18271_length_161_cov_1.246032_g18081_i0	PRJEB12366	18271	161	1.246032	2.00611152	Burkholderiales bacterium	1891238	Bacteria	Bacteria	62.8	1.03e-9	NR	MBV8468073.1	1891238	g18081	i0	59.3	1.09937888198758	59	18	98.8	2	2	160	279	337	MBV8468073.1 hypothetical protein [Burkholderiales bacterium]	diamond	177	62.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
30569867	30569867	PRJEB12366_P_NODE_11013_length_225_cov_1.736842_g10823_i0	PRJEB12366	11013	225	1.736842	3.9078945	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	68.2	3.14e-11	NR	MCP4284336.1	1913989	g10823	i0	65.3	0.653333333333333	49	15	62.7	1	6	146	30	78	MCP4284336.1 hypothetical protein [Gammaproteobacteria bacterium]	diamond	147	68.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
30721679	30721679	PRJEB12366_P_NODE_18854_length_158_cov_0.975610_g18664_i0	PRJEB12366	18854	158	0.97561	1.5414638	Comamonadaceae	80864	Bacteria	Bacteria	48.1	1.18e-4	NR	WP_310345053.1	1484693	g18664	i0	44	6.6075949367088596	50	27	93	1	156	10	108	157	WP_310345053.1 glutathione S-transferase family protein [Rhodoferax saidenbachensis]	diamond	1044	48.5	0.991752577319588	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Rhodoferax	Rhodoferax saidenbachensis
31670108	31670108	PRJEB12366_P_NODE_17797_length_164_cov_0.930233_g17607_i0	PRJEB12366	17797	164	0.930233	1.52558212	root	1	Root_unresolved	Root_unresolved	100	7.22e-26	NR	WP_416561407.1	573	g17607	i0	88.9	21.7134146341463	54	6	98.8	0	163	2	52	105	WP_416561407.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	3561	100	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
32625248	32625248	PRJEB12366_P_NODE_14680_length_187_cov_0.986842_g14490_i0	PRJEB12366	14680	187	0.986842	1.84539454	Thalassospira sp. MA62	2896364	Bacteria	Bacteria	53.5	2.78e-6	NR	MCC9621532.1	2896364	g14490	i0	56.1	4.54010695187166	41	18	65.8	0	186	64	36	76	MCC9621532.1 anthranilate synthase component I [Thalassospira sp. MA62]	diamond	849	53.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Thalassospiraceae	Thalassospira	Thalassospira sp. MA62

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