metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
1819590	1819590	PRJNA560029_S_NODE_22942_length_289_cov_1.425926_g22718_i0	PRJNA560029	22942	289	1.425926	4.12092614	root	1	Root_unresolved	Root_unresolved	89.7	3.89e-20	NR	WP_140424235.1	562	g22718	i0	82.6	5.76124567474048	46	8	47.8	0	1	138	124	169	WP_140424235.1 ADP-ribosylation factor-like protein, partial [Escherichia coli]	diamond	1665	89.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
1819592	1819592	PRJNA560029_S_NODE_23042_length_288_cov_3.232558_g22818_i0	PRJNA560029	23042	288	3.232558	9.30976704	Necropsobacter massiliensis	1400001	Bacteria	Bacteria	141	6.379999999999999e-37	NR	WP_040976343.1	1400001	g22818	i0	81.1	4.94791666666667	95	18	99	0	286	2	533	627	WP_040976343.1 MacB family efflux pump subunit [Necropsobacter massiliensis]	diamond	1425	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Necropsobacter	Necropsobacter massiliensis
26712902	26712902	PRJNA560029_S_NODE_14161_length_336_cov_2.832700_g13937_i0	PRJNA560029	14161	336	2.8327	9.517872	Brevundimonas	41275	Bacteria	Bacteria	61.6	2.64e-9	NR	WP_288757434.1	213418	g13937	i0	31.5	2.375	92	58	77.7	1	1	261	18	109	WP_288757434.1 helix-turn-helix domain-containing protein [uncultured Brevundimonas sp.]	diamond	798	61.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	uncultured Brevundimonas sp.
26903287	26903287	PRJNA560029_S_NODE_3121_length_504_cov_5.146172_g2899_i0	PRJNA560029	3121	504	5.146172	25.93670688	Pseudomonadati	3379134	Bacteria	Bacteria	87	2.28e-16	NR	WP_006747729.1	108010	g2899	i0	51.2	1	84	41	50	0	503	252	1063	1146	WP_006747729.1 hypothetical protein [Thioalkalivibrio paradoxus]	diamond	504	87.4	0.995423340961098	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Ectothiorhodospiraceae	Thioalkalivibrio	Thioalkalivibrio paradoxus
27110377	27110377	PRJNA560029_S_NODE_23262_length_287_cov_2.714953_g23038_i0	PRJNA560029	23262	287	2.714953	7.79191511	Pseudomonas aeruginosa	287	Bacteria	Bacteria	191	1.3e-57	NR	WP_128675315.1	287	g23038	i0	93.6	4.94425087108014	94	6	98.3	0	1	282	269	362	WP_128675315.1 AAA family ATPase [Pseudomonas aeruginosa]	diamond	1419	191	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28261357	28261357	PRJNA560029_S_NODE_32306_length_250_cov_1.542373_g32082_i0	PRJNA560029	32306	250	1.542373	3.8559325	Gammaproteobacteria	1236	Bacteria	Bacteria	157	1.73e-47	NR	WP_280287793.1	287	g32082	i0	94.8	1.848	77	4	92.4	0	16	246	1	77	WP_280287793.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	462	157	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28500242	28500242	PRJNA560029_S_NODE_18707_length_309_cov_2.593220_g18483_i0	PRJNA560029	18707	309	2.59322	8.0130498	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	95.5	5.26e-22	NR	RYY03573.1	1913989	g18483	i0	62.7	6.61165048543689	75	28	72.8	0	231	7	1	75	RYY03573.1 MAG: superoxide dismutase [Fe] [Gammaproteobacteria bacterium]	diamond	2043	95.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
28500248	28500248	PRJNA560029_S_NODE_4927_length_438_cov_2.350685_g4703_i0	PRJNA560029	4927	438	2.350685	10.2960003	Massilia aerilata	453817	Bacteria	Bacteria	269	3.18e-84	NR	WP_379767854.1	453817	g4703	i0	90.3	0.986301369863014	144	14	98.6	0	1	432	29	172	WP_379767854.1 esterase/lipase family protein [Massilia aerilata]	diamond	432	269	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia aerilata
28608882	28608882	PRJNA560029_S_NODE_2247_length_569_cov_4.032258_g2026_i0	PRJNA560029	2247	569	4.032258	22.94354802	Pseudomonadati	3379134	Bacteria	Bacteria	112	2.21e-27	NR	TAK50721.1	1913989	g2026	i0	65.8	1.20738137082601	73	20	38.5	2	547	329	117	184	TAK50721.1 MAG: superoxide dismutase [Gammaproteobacteria bacterium]	diamond	687	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
28721230	28721230	PRJNA560029_S_NODE_15867_length_325_cov_2.333333_g15643_i0	PRJNA560029	15867	325	2.333333	7.58333225	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	67	2.81e-10	NR	MBQ8251038.1	1913988	g15643	i0	43.4	0.701538461538462	76	42	70.2	1	96	323	105	179	MBQ8251038.1 aryl-sulfate sulfotransferase [Alphaproteobacteria bacterium]	diamond	228	67	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28987965	28987965	PRJNA560029_S_NODE_31648_length_252_cov_2.581006_g31424_i0	PRJNA560029	31648	252	2.581006	6.50413512	Gammaproteobacteria	1236	Bacteria	Bacteria	112	1.31e-28	NR	WP_029933506.1	934	g31424	i0	70.9	1.9047619047619	79	23	94	0	8	244	1	79	WP_029933506.1 5'-methylthioadenosine/S-adenosylhomocysteine nucleosidase [Thiomicrospira pelophila]	diamond	480	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Piscirickettsiaceae	Thiomicrospira	Thiomicrospira pelophila
29226584	29226584	PRJNA560029_S_NODE_5549_length_423_cov_56.982857_g5325_i0	PRJNA560029	5549	423	56.982857	241.03748511	Enterobacter hormaechei	158836	Bacteria	Bacteria	249	2.97e-83	NR	WP_223145253.1	158836	g5325	i0	99.2	0.865248226950355	122	1	86.5	0	1	366	1	122	WP_223145253.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	366	249	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29447138	29447138	PRJNA560029_S_NODE_13090_length_343_cov_3.270370_g12866_i0	PRJNA560029	13090	343	3.2703700000000002	11.2173691	Glaciecola sp.	1905676	Bacteria	Bacteria	65.1	6.18e-10	NR	WP_415049859.1	1905676	g12866	i0	56.1	6.6297376093294504	57	25	49.9	0	89	259	151	207	WP_415049859.1 DUF1294 domain-containing protein [Glaciecola sp.]	diamond	2274	65.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Glaciecola	Glaciecola sp.
29573441	29573441	PRJNA560029_S_NODE_11430_length_355_cov_3.244681_g11206_i0	PRJNA560029	11430	355	3.244681	11.51861755	Enterobacter hormaechei	158836	Bacteria	Bacteria	104	2.62e-26	NR	RAM39467.1	158836	g11206	i0	100	0.794366197183099	47	0	39.7	0	1	141	71	117	RAM39467.1 hypothetical protein DOZ52_29115 [Enterobacter hormaechei]	diamond	282	104	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29587339	29587339	PRJNA560029_S_NODE_22830_length_289_cov_3.291667_g22606_i0	PRJNA560029	22830	289	3.291667	9.51291763	Enterobacter	547	Bacteria	Bacteria	137	1.59e-36	NR	WP_314352737.1	158836	g22606	i0	100	2.05536332179931	66	0	68.5	0	200	3	1	66	WP_314352737.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	594	137	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29682044	29682044	PRJNA560029_S_NODE_14450_length_334_cov_3.540230_g14226_i0	PRJNA560029	14450	334	3.54023	11.8243682	Gammaproteobacteria	1236	Bacteria	Bacteria	61.2	2.93e-8	NR	URM14412.1	29497	g14226	i0	40.8	1.66167664670659	71	39	61.1	1	332	129	92	162	URM14412.1 glycosyltransferase [Vibrio splendidus]	diamond	555	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio splendidus
30205071	30205071	PRJNA560029_S_NODE_23232_length_287_cov_3.892523_g23008_i0	PRJNA560029	23232	287	3.892523	11.17154101	Ralstonia pickettii	329	Bacteria	Bacteria	179	1.0499999999999999e-54	NR	WP_173004240.1	329	g23008	i0	98.9	0.909407665505226	87	1	90.9	0	261	1	1	87	WP_173004240.1 response regulator transcription factor [Ralstonia pickettii]	diamond	261	179	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
30236962	30236962	PRJNA560029_S_NODE_8932_length_377_cov_2.802632_g8708_i0	PRJNA560029	8932	377	2.802632	10.56592264	Sphingomonas sp.	28214	Bacteria	Bacteria	91.7	1.27e-18	NR	RZL28055.1	28214	g8708	i0	59.5	0.588859416445623	74	30	58.9	0	2	223	586	659	RZL28055.1 MAG: hypothetical protein EOP64_05680 [Sphingomonas sp.]	diamond	222	91.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp.
30268850	30268850	PRJNA560029_S_NODE_24692_length_281_cov_1.846154_g24468_i0	PRJNA560029	24692	281	1.846154	5.18769274	Nitrosomonas halophila	44576	Bacteria	Bacteria	43.9	0.0227	NR	WP_090414403.1	44576	g24468	i0	36.2	0.736654804270463	69	44	73.7	0	53	259	512	580	WP_090414403.1 hypothetical protein [Nitrosomonas halophila]	diamond	207	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosomonas	Nitrosomonas halophila
30314658	30314658	PRJNA560029_S_NODE_37292_length_224_cov_4.649007_g37068_i0	PRJNA560029	37292	224	4.649007	10.41377568	Bacteria	2	Bacteria	Bacteria	82	1.56e-16	NR	MFK7995568.1	1943584	g37068	i0	60	10.8214285714286	55	22	73.7	0	168	4	3	57	MFK7995568.1 NAD(P)/FAD-dependent oxidoreductase [Granulosicoccus sp.]	diamond	2424	82	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Granulosicoccaceae	Granulosicoccus	Granulosicoccus sp.
30552760	30552760	PRJNA560029_S_NODE_10233_length_365_cov_2.342466_g10009_i0	PRJNA560029	10233	365	2.342466	8.5500009	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	79	1.31e-15	NR	MFC1602388.1	1977087	g10009	i0	62.3	2.28493150684932	53	20	43.6	0	354	196	113	165	MFC1602388.1 thiol peroxidase [Pseudomonadota bacterium]	diamond	834	79	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
30552768	30552768	PRJNA560029_S_NODE_28293_length_265_cov_3.609375_g28069_i0	PRJNA560029	28293	265	3.609375	9.56484375	Pseudomonas fluorescens	294	Bacteria	Bacteria	58.5	1.37e-7	NR	WP_081006351.1	294	g28069	i0	36.6	3.70188679245283	82	50	90.6	1	22	261	216	297	WP_081006351.1 metallophosphoesterase [Pseudomonas fluorescens]	diamond	981	58.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
30584316	30584316	PRJNA560029_S_NODE_6953_length_401_cov_1.865854_g6729_i0	PRJNA560029	6953	401	1.865854	7.48207454	Neisseriaceae bacterium	2014784	Bacteria	Bacteria	141	2.34e-38	NR	MFH4416074.1	2014784	g6729	i0	58.6	3.34413965087282	111	46	83	0	1	333	197	307	MFH4416074.1 glycosyltransferase family 2 protein [Neisseriaceae bacterium]	diamond	1341	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae		Neisseriaceae bacterium
31027005	31027005	PRJNA560029_S_NODE_6295_length_410_cov_13.821958_g6071_i0	PRJNA560029	6295	410	13.821958	56.6700278	Wohlfahrtiimonas chitiniclastica	400946	Bacteria	Bacteria	146	4.48e-42	NR	WP_094491519.1	400946	g6071	i0	60.3	3.71707317073171	126	50	92.2	0	21	398	17	142	WP_094491519.1 GNAT family N-acetyltransferase [Wohlfahrtiimonas chitiniclastica]	diamond	1524	146	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cardiobacteriales	Ignatzschineriaceae	Wohlfahrtiimonas	Wohlfahrtiimonas chitiniclastica
31469630	31469630	PRJNA560029_S_NODE_14356_length_335_cov_1.763359_g14132_i0	PRJNA560029	14356	335	1.763359	5.90725265	Aggregatibacter actinomycetemcomitans	714	Bacteria	Bacteria	127	3.4399999999999996e-35	NR	WP_231098916.1	714	g14132	i0	71.1	1.4865671641791	83	24	74.3	0	83	331	48	130	WP_231098916.1 hypothetical protein [Aggregatibacter actinomycetemcomitans]	diamond	498	127	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Aggregatibacter	Aggregatibacter actinomycetemcomitans
31596208	31596208	PRJNA560029_S_NODE_19196_length_307_cov_1.452991_g18972_i0	PRJNA560029	19196	307	1.452991	4.46068237	Simplicispira hankyongi	2315688	Bacteria	Bacteria	46.6	0.00178	NR	WP_158606155.1	2315688	g18972	i0	34.4	0.596091205211726	61	35	59.6	1	286	104	82	137	WP_158606155.1 flavodoxin family protein [Simplicispira hankyongi]	diamond	183	46.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Simplicispira	Simplicispira hankyongi
31627522	31627522	PRJNA560029_S_NODE_12216_length_349_cov_2.981884_g11992_i0	PRJNA560029	12216	349	2.981884	10.40677516	Thiolinea sp.	2212699	Bacteria	Bacteria	50.4	2.16e-4	NR	HPY41230.1	2212699	g11992	i0	48.3	1.00573065902579	60	31	51.6	0	349	170	246	305	HPY41230.1 PfkB family carbohydrate kinase [Thiolinea sp.]	diamond	351	50.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Thiolinaceae	Thiolinea	Thiolinea sp.
31989508	31989508	PRJNA560029_S_NODE_21738_length_294_cov_3.144796_g21514_i0	PRJNA560029	21738	294	3.144796	9.24570024	Bacteria	2	Bacteria	Bacteria	119	5.83e-30	NR	WP_220359234.1	727	g21514	i0	64.4	6.26530612244898	87	30	88.8	1	289	29	132	217	WP_220359234.1 DNA cytosine methyltransferase [Haemophilus influenzae]	diamond	1842	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus influenzae
32464349	32464349	PRJNA560029_S_NODE_8759_length_379_cov_2.016340_g8535_i0	PRJNA560029	8759	379	2.01634	7.6419286	Bacteria	2	Bacteria	Bacteria	115	3.1e-28	NR	WP_028451386.1	362520	g8535	i0	53.3	2.75461741424802	120	53	94.2	3	4	360	204	321	WP_028451386.1 gluconeogenesis factor YvcK family protein [Chitinilyticum aquatile]	diamond	1044	115	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chitinibacteraceae	Chitinilyticum	Chitinilyticum aquatile
32608175	32608175	PRJNA560029_S_NODE_10160_length_365_cov_10.102740_g9936_i0	PRJNA560029	10160	365	10.10274	36.875001	Sphingobium rhizovicinum	432308	Bacteria	Bacteria	60.5	1.34e-8	NR	WP_380798192.1	432308	g9936	i0	33.7	1.65205479452055	104	63	83.8	2	353	48	53	152	WP_380798192.1 MarR family winged helix-turn-helix transcriptional regulator [Sphingobium rhizovicinum]	diamond	603	60.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium rhizovicinum

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