metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA749559" 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
3277315	3277315	PRJNA749559_P_NODE_4243_length_208_cov_0.870748_g4173_i0	PRJNA749559	4243	208	0.870748	1.81115584	uncultured Brevundimonas sp.	213418	Bacteria	Bacteria	119	2.24e-29	NR	WP_295705670.1	213418	g4173	i0	92.6	0.980769230769231	68	5	98.1	0	3	206	564	631	WP_295705670.1 4-alpha-glucanotransferase [uncultured Brevundimonas sp.]	diamond	204	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	uncultured Brevundimonas sp.
19051610	19051610	PRJNA749559_P_NODE_5055_length_201_cov_0.914286_g4985_i0	PRJNA749559	5055	201	0.914286	1.83771486	Paracoccus aeridis	1966466	Bacteria	Bacteria	89.4	2.15e-19	NR	WP_136649450.1	1966466	g4985	i0	98	0.746268656716418	50	1	74.6	0	52	201	1	50	WP_136649450.1 LysR family transcriptional regulator [Paracoccus aeridis]	diamond	150	89.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus aeridis
19853025	19853025	PRJNA749559_P_NODE_4516_length_206_cov_0.882759_g4446_i0	PRJNA749559	4516	206	0.882759	1.81848354	Massilia sp. MP_M2	3071713	Bacteria	Bacteria	130	5.579999999999999e-34	NR	WP_343026797.1	3071713	g4446	i0	97.1	0.990291262135922	68	2	99	0	206	3	33	100	WP_343026797.1 hemolysin family protein [Massilia sp. MP_M2]	diamond	204	130	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. MP_M2
27905353	27905353	PRJNA749559_P_NODE_4525_length_206_cov_0.882759_g4455_i0	PRJNA749559	4525	206	0.882759	1.81848354	Brevundimonas intermedia	74315	Bacteria	Bacteria	43.5	0.0125	NR	WP_167762577.1	74315	g4455	i0	55.8	1.25242718446602	43	19	62.6	0	146	18	1	43	WP_167762577.1 TonB-dependent receptor [Brevundimonas intermedia]	diamond	258	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas intermedia
28000555	28000555	PRJNA749559_P_NODE_5145_length_194_cov_2.300752_g5075_i0	PRJNA749559	5145	194	2.300752	4.46345888	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	99.8	3.12e-25	NR	MEL6702651.1	1977087	g5075	i0	71	0.958762886597938	62	18	95.9	0	191	6	18	79	MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium]	diamond	186	99.8	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
28347635	28347635	PRJNA749559_P_NODE_1366_length_387_cov_2.515337_g1296_i0	PRJNA749559	1366	387	2.515337	9.73435419	Enterobacter asburiae	61645	Bacteria	Bacteria	49.7	3.25e-5	NR	WP_236551201.1	61645	g1296	i0	55.6	0.348837209302326	45	15	31	1	124	5	16	60	WP_236551201.1 hypothetical protein, partial [Enterobacter asburiae]	diamond	135	49.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter asburiae
29011087	29011087	PRJNA749559_P_NODE_2928_length_253_cov_1.333333_g2858_i0	PRJNA749559	2928	253	1.333333	3.37333249	Psychromonas sp. PRT-SC	1884585	Bacteria	Bacteria	41.2	0.0223	NR	KPU83399.1	1527299	g2858	i0	71.4	0.49802371541502	42	12	49.8	0	2	127	30	71	KPU83399.1 hypothetical protein JI57_01495 [Psychromonas sp. PRT-SC03]	diamond	126	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Psychromonadaceae	Psychromonas	Psychromonas sp. PRT-SC03
29420973	29420973	PRJNA749559_P_NODE_4729_length_204_cov_0.895105_g4659_i0	PRJNA749559	4729	204	0.895105	1.8260142	Kingella	32257	Bacteria	Bacteria	119	6.849999999999998e-30	NR	WP_238748364.1	32257	g4659	i0	98.5	0.985294117647059	67	1	98.5	0	202	2	150	216	WP_238748364.1 MULTISPECIES: sugar MFS transporter [Kingella]	diamond	201	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Kingella
29420974	29420974	PRJNA749559_P_NODE_5049_length_201_cov_0.914286_g4979_i0	PRJNA749559	5049	201	0.914286	1.83771486	Paracoccus litorisediminis	2006130	Bacteria	Bacteria	62	3.4e-9	NR	WP_394207910.1	2006130	g4979	i0	50	0.865671641791045	58	29	86.6	0	11	184	48	105	WP_394207910.1 TraM recognition domain-containing protein [Paracoccus litorisediminis]	diamond	174	62	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus litorisediminis
30274227	30274227	PRJNA749559_P_NODE_5072_length_201_cov_0.907143_g5002_i0	PRJNA749559	5072	201	0.907143	1.82335743	Neorhizobium sp. AL 9.2.2	2712894	Bacteria	Bacteria	111	4.23e-27	NR	WP_174196975.1	2712894	g5002	i0	96.6	0.880597014925373	59	2	88.1	0	200	24	384	442	WP_174196975.1 PLP-dependent aminotransferase family protein [Neorhizobium sp. AL 9.2.2]	diamond	177	111	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Neorhizobium	Neorhizobium sp. AL 9.2.2
31126653	31126653	PRJNA749559_P_NODE_4955_length_202_cov_0.907801_g4885_i0	PRJNA749559	4955	202	0.907801	1.83375802	Rhizobium sp. CC-YZS	391	Bacteria	Bacteria	60.8	3.38e-9	NR	WP_323106240.1	3042153	g4885	i0	100	0.415841584158416	28	0	41.6	0	117	200	1	28	WP_323106240.1 YitT family protein [Rhizobium sp. CC-YZS058]	diamond	84	60.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium sp. CC-YZS058
31358390	31358390	PRJNA749559_P_NODE_4636_length_205_cov_0.888889_g4566_i0	PRJNA749559	4636	205	0.888889	1.82222245	Moraxellaceae	468	Bacteria	Bacteria	124	2.3699999999999998e-32	NR	WP_219332801.1	34062	g4566	i0	86.8	1.9609756097561	68	9	99.5	0	204	1	242	309	WP_219332801.1 glycosyltransferase [Moraxella osloensis]	diamond	402	125	0.992	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
31579846	31579846	PRJNA749559_P_NODE_1916_length_316_cov_5.533333_g1846_i0	PRJNA749559	1916	316	5.533333	17.48533228	Bacteria	2	Bacteria	Bacteria	99.8	7.67e-25	NR	WP_077633843.1	562	g1846	i0	65.1	1.68987341772152	83	29	78.8	0	4	252	11	93	WP_077633843.1 hypothetical protein, partial [Escherichia coli]	diamond	534	100	0.998	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31706190	31706190	PRJNA749559_P_NODE_4397_length_207_cov_0.876712_g4327_i0	PRJNA749559	4397	207	0.876712	1.81479384	Paracoccaceae	31989	Bacteria	Bacteria	99.8	1.94e-22	NR	WP_194886561.1	265	g4327	i0	92.7	3.98550724637681	55	4	79.7	0	167	3	5	59	WP_194886561.1 MULTISPECIES: PhoX family protein [Paracoccus]	diamond	825	100	0.998	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus
31759472	31759472	PRJNA749559_P_NODE_4197_length_209_cov_0.864865_g4127_i0	PRJNA749559	4197	209	0.864865	1.80756785	Paracoccus aeridis	1966466	Bacteria	Bacteria	132	7.52e-36	NR	WP_136652656.1	1966466	g4127	i0	100	0.990430622009569	69	0	99	0	207	1	75	143	WP_136652656.1 LysR family transcriptional regulator [Paracoccus aeridis]	diamond	207	132	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus aeridis
32044275	32044275	PRJNA749559_P_NODE_4358_length_207_cov_0.876712_g4288_i0	PRJNA749559	4358	207	0.876712	1.81479384	Rhizobium sp. Leaf3	391	Bacteria	Bacteria	135	5.65e-35	NR	WP_062456708.1	1736330	g4288	i0	100	1	69	0	100	0	207	1	192	260	WP_062456708.1 DUF3971 domain-containing protein [Rhizobium sp. Leaf306]	diamond	207	135	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium sp. Leaf306
32202500	32202500	PRJNA749559_P_NODE_4258_length_208_cov_0.870748_g4188_i0	PRJNA749559	4258	208	0.870748	1.81115584	Devosia sp.	1871048	Bacteria	Bacteria	97.4	3.3e-22	NR	WP_295415036.1	1871048	g4188	i0	71.6	2.92788461538462	67	19	96.6	0	1	201	205	271	WP_295415036.1 ABC transporter ATP-binding protein [Devosia sp.]	diamond	609	97.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Devosiaceae	Devosia	Devosia sp.
32360919	32360919	PRJNA749559_P_NODE_4739_length_204_cov_0.895105_g4669_i0	PRJNA749559	4739	204	0.895105	1.8260142	Paracoccus marcusii	59779	Bacteria	Bacteria	91.3	3.4e-20	NR	WP_373947273.1	59779	g4669	i0	75	0.941176470588235	64	16	94.1	0	202	11	232	295	WP_373947273.1 EamA family transporter [Paracoccus marcusii]	diamond	192	91.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus marcusii
32739646	32739646	PRJNA749559_P_NODE_2500_length_275_cov_0.967290_g2430_i0	PRJNA749559	2500	275	0.96729	2.6600475	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	44.3	0.0152	NR	WP_395588599.1	251699	g2430	i0	50	2.07272727272727	40	19	43.6	1	40	159	294	332	WP_395588599.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	570	44.3	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);;