metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA855894" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA855894" and tax_superkingdom = "Bacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1235037	1235037	PRJNA855894_P_NODE_30921_length_249_cov_0.875000_g30799_i0	PRJNA855894	30921	249	0.875	2.17875	Pseudolysinimonas	2680005	Bacteria	Bacteria	120	7.349999999999999e-31	NR	WP_309709767.1	2680009	g30799	i0	81.7	2.92771084337349	82	15	98.8	0	3	248	76	157	WP_309709767.1 DMT family transporter [Pseudolysinimonas sp.]	diamond	729	120	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudolysinimonas	Pseudolysinimonas sp.
3393058	3393058	PRJNA855894_P_NODE_34523_length_241_cov_0.916667_g34401_i0	PRJNA855894	34523	241	0.916667	2.20916747	Phyllobacterium sp. NPDC	1871046	Bacteria	Bacteria	161	1.29e-47	NR	WP_403183558.1	3364404	g34401	i0	100	0.983402489626556	79	0	98.3	0	239	3	162	240	WP_403183558.1 helix-turn-helix transcriptional regulator [Phyllobacterium sp. NPDC097923]	diamond	237	161	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp. NPDC097923
9770225	9770225	PRJNA855894_P_NODE_27608_length_266_cov_1.595855_g27486_i0	PRJNA855894	27608	266	1.595855	4.2449743	Micrococcus flavus	384602	Bacteria	Bacteria	156	2.44e-45	NR	WP_135027581.1	384602	g27486	i0	88.6	0.992481203007519	88	10	99.2	0	265	2	131	218	WP_135027581.1 triose-phosphate isomerase [Micrococcus flavus]	diamond	264	156	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus flavus
16145050	16145050	PRJNA855894_P_NODE_32093_length_246_cov_0.890173_g31971_i0	PRJNA855894	32093	246	0.890173	2.18982558	Micrococcus endophyticus	455343	Bacteria	Bacteria	154	4.0899999999999985e-43	NR	WP_184172599.1	455343	g31971	i0	100	1	82	0	100	0	1	246	224	305	WP_184172599.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Micrococcus endophyticus]	diamond	246	154	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus endophyticus
19968832	19968832	PRJNA855894_P_NODE_31416_length_248_cov_0.880000_g31294_i0	PRJNA855894	31416	248	0.88	2.1824	Roseateles puraquae	431059	Bacteria	Bacteria	115	1.31e-30	NR	WP_241516970.1	431059	g31294	i0	83.6	0.737903225806452	61	10	73.8	0	247	65	102	162	WP_241516970.1 nuclear transport factor 2 family protein [Roseateles puraquae]	diamond	183	115	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles puraquae
19968875	19968875	PRJNA855894_P_NODE_33136_length_244_cov_0.900585_g33014_i0	PRJNA855894	33136	244	0.900585	2.1974274	Sphingobium sp. SCG-1	2072936	Bacteria	Bacteria	67.8	5.39e-11	NR	WP_104951934.1	2072936	g33014	i0	85.7	1.32786885245902	35	5	43	0	241	137	378	412	WP_104951934.1 acyl-CoA dehydrogenase family protein [Sphingobium sp. SCG-1]	diamond	324	67.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium sp. SCG-1
22518850	22518850	PRJNA855894_P_NODE_24458_length_293_cov_1.390909_g24336_i0	PRJNA855894	24458	293	1.390909	4.07536337	Escherichia coli	562	Bacteria	Bacteria	164	3.06e-50	NR	WP_248423348.1	562	g24336	i0	84.7	1.00341296928328	98	14	99.3	1	292	2	10	107	WP_248423348.1 EF-hand domain-containing protein, partial [Escherichia coli]	diamond	294	164	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
26611693	26611693	PRJNA855894_P_NODE_34001_length_242_cov_0.911243_g33879_i0	PRJNA855894	34001	242	0.911243	2.20520806	Methylobacterium	407	Bacteria	Bacteria	171	7.070000000000002e-51	NR	WP_066922281.1	407	g33879	i0	98.8	0.991735537190083	80	1	99.2	0	241	2	100	179	WP_066922281.1 MULTISPECIES: hypothetical protein [Methylobacterium]	diamond	240	171	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium
26801797	26801797	PRJNA855894_P_NODE_9921_length_505_cov_1.601852_g9800_i0	PRJNA855894	9921	505	1.601852	8.0893526	Rhodospirillales bacterium	2026786	Bacteria	Bacteria	48.1	0.0038	NR	MDH3472990.1	2026786	g9800	i0	29.8	0.718811881188119	121	69	63	3	118	435	14	133	MDH3472990.1 glycine--tRNA ligase subunit alpha [Rhodospirillales bacterium]	diamond	363	48.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales			Rhodospirillales bacterium
26991552	26991552	PRJNA855894_P_NODE_33802_length_243_cov_0.905882_g33680_i0	PRJNA855894	33802	243	0.905882	2.20129326	Methylobacterium brachiatum	269660	Bacteria	Bacteria	83.6	2.04e-19	NR	WP_268868898.1	269660	g33680	i0	95.2	0.518518518518518	42	2	51.9	0	213	88	1	42	WP_268868898.1 hypothetical protein [Methylobacterium brachiatum]	diamond	126	83.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium brachiatum
27149434	27149434	PRJNA855894_P_NODE_33682_length_243_cov_0.905882_g33560_i0	PRJNA855894	33682	243	0.905882	2.20129326	Anaerolineales bacterium	2073117	Bacteria	Bacteria	157	4.81e-45	NR	HJR80736.1	2073117	g33560	i0	96.3	0.987654320987654	80	3	98.8	0	241	2	240	319	HJR80736.1 LacI family DNA-binding transcriptional regulator [Anaerolineales bacterium]	diamond	240	157	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28034351	28034351	PRJNA855894_P_NODE_33285_length_244_cov_0.900585_g33163_i0	PRJNA855894	33285	244	0.900585	2.1974274	Brucella anthropi	529	Bacteria	Bacteria	147	4.25e-39	NR	WP_010657720.1	529	g33163	i0	92.5	0.983606557377049	80	6	98.4	0	242	3	167	246	WP_010657720.1 UvrD-helicase domain-containing protein [Brucella anthropi]	diamond	240	147	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
28223471	28223471	PRJNA855894_P_NODE_32046_length_246_cov_1.104046_g31924_i0	PRJNA855894	32046	246	1.104046	2.71595316	Nocardioides sp.	35761	Bacteria	Bacteria	85.5	5.56e-18	NR	MFL6004500.1	35761	g31924	i0	76.9	1.95121951219512	52	12	63.4	0	1	156	43	94	MFL6004500.1 transglycosylase SLT domain-containing protein [Nocardioides sp.]	diamond	480	85.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
28286563	28286563	PRJNA855894_P_NODE_22986_length_306_cov_1.982833_g22864_i0	PRJNA855894	22986	306	1.982833	6.06746898	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	47	1.8e-4	NR	WP_233005565.1	33987	g22864	i0	66.7	0.382352941176471	39	13	38.2	0	118	2	26	64	WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum]	diamond	117	47	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
28326389	28326389	PRJNA855894_P_NODE_32966_length_244_cov_0.900585_g32844_i0	PRJNA855894	32966	244	0.900585	2.1974274	Pseudolysinimonas	2680005	Bacteria	Bacteria	119	4.39e-29	NR	WP_395639570.1	2680009	g32844	i0	74.1	1.99180327868852	81	21	99.6	0	2	244	792	872	WP_395639570.1 hypothetical protein [Pseudolysinimonas sp.]	diamond	486	120	0.991666666666667	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudolysinimonas	Pseudolysinimonas sp.
28476254	28476254	PRJNA855894_P_NODE_33706_length_243_cov_0.905882_g33584_i0	PRJNA855894	33706	243	0.905882	2.20129326	Candidatus Albibeggiatoa sp. nov. NOAA	3162724	Bacteria	Bacteria	80.9	5.45e-18	NR	WP_353312433.1	3162724	g33584	i0	91.3	0.567901234567901	46	4	56.8	0	1	138	6	51	WP_353312433.1 hypothetical protein [Candidatus Albibeggiatoa sp. nov. NOAA]	diamond	138	80.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Thiotrichaceae	Candidatus Albibeggiatoa	Candidatus Albibeggiatoa sp. nov. NOAA
29873727	29873727	PRJNA855894_P_NODE_30651_length_249_cov_0.875000_g30529_i0	PRJNA855894	30651	249	0.875	2.17875	Branchiibius	908251	Bacteria	Bacteria	114	2.25e-29	NR	WP_109684873.1	672460	g30529	i0	91.4	2.09638554216867	58	5	69.9	0	2	175	160	217	WP_109684873.1 SGNH/GDSL hydrolase family protein [Branchiibius hedensis]	diamond	522	114	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Branchiibius	Branchiibius hedensis
30023653	30023653	PRJNA855894_P_NODE_29771_length_251_cov_0.865169_g29649_i0	PRJNA855894	29771	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	52	1.65e-5	NR	MCX6981846.1	2026799	g29649	i0	69.7	0.788844621513944	33	10	39.4	0	245	147	209	241	MCX6981846.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	198	52	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30244764	30244764	PRJNA855894_P_NODE_30052_length_250_cov_0.870056_g29930_i0	PRJNA855894	30052	250	0.870056	2.17514	Klebsiella pneumoniae	573	Bacteria	Bacteria	44.7	8.53e-4	NR	WP_416515521.1	573	g29930	i0	52.9	0.612	51	24	61.2	0	180	28	13	63	WP_416515521.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	153	44.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
30371442	30371442	PRJNA855894_P_NODE_27712_length_265_cov_1.604167_g27590_i0	PRJNA855894	27712	265	1.604167	4.25104255	Delftia tsuruhatensis	180282	Bacteria	Bacteria	182	4.42e-51	NR	WP_082145177.1	180282	g27590	i0	100	0.99622641509434	88	0	99.6	0	264	1	891	978	WP_082145177.1 serine/threonine-protein kinase [Delftia tsuruhatensis]	diamond	264	182	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia tsuruhatensis
30497492	30497492	PRJNA855894_P_NODE_34073_length_242_cov_0.911243_g33951_i0	PRJNA855894	34073	242	0.911243	2.20520806	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	94.7	7.71e-21	NR	MEO8041555.1	1978231	g33951	i0	83.1	2.19421487603306	59	10	73.1	0	177	1	1	59	MEO8041555.1 hypothetical protein [Acidobacteriota bacterium]	diamond	531	94.7	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30528901	30528901	PRJNA855894_P_NODE_34673_length_241_cov_0.916667_g34551_i0	PRJNA855894	34673	241	0.916667	2.20916747	Deinococcus antarcticus	1298767	Bacteria	Bacteria	70.9	5.91e-13	NR	WP_380080136.1	1298767	g34551	i0	97.4	0.485477178423237	39	1	48.5	0	123	239	1	39	WP_380080136.1 2Fe-2S iron-sulfur cluster-binding protein [Deinococcus antarcticus]	diamond	117	70.9	1	Bacteria		Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30592093	30592093	PRJNA855894_P_NODE_31233_length_248_cov_0.880000_g31111_i0	PRJNA855894	31233	248	0.88	2.1824	Pseudomonas	286	Bacteria	Bacteria	169	1.5199999999999998e-47	NR	WP_232881953.1	286	g31111	i0	100	0.991935483870968	82	0	99.2	0	1	246	344	425	WP_232881953.1 MULTISPECIES: integrase [Pseudomonas]	diamond	246	169	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas
30686844	30686844	PRJNA855894_P_NODE_33593_length_243_cov_0.905882_g33471_i0	PRJNA855894	33593	243	0.905882	2.20129326	Rubrobacteraceae bacterium	2740537	Bacteria	Bacteria	113	2.81e-28	NR	HSL00552.1	2740537	g33471	i0	72.5	3.95061728395062	80	22	98.8	0	3	242	2	81	HSL00552.1 ATP-dependent 6-phosphofructokinase [Rubrobacteraceae bacterium]	diamond	960	113	1	Bacteria		Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae		Rubrobacteraceae bacterium
30908281	30908281	PRJNA855894_P_NODE_32594_length_245_cov_0.895349_g32472_i0	PRJNA855894	32594	245	0.895349	2.19360505	Tepidimonas aquatica	247482	Bacteria	Bacteria	165	4.03e-47	NR	WP_144326834.1	247482	g32472	i0	98.8	0.991836734693878	81	1	99.2	0	1	243	45	125	WP_144326834.1 Tol-Pal system beta propeller repeat protein TolB [Tepidimonas aquatica]	diamond	243	165	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Tepidimonas	Tepidimonas aquatica
31255727	31255727	PRJNA855894_P_NODE_30275_length_250_cov_0.870056_g30153_i0	PRJNA855894	30275	250	0.870056	2.17514	Chitinophagaceae	563835	Bacteria	Bacteria	110	5.62e-29	NR	WP_330975041.1	563835	g30153	i0	59	0.996	83	34	99.6	0	249	1	44	126	WP_330975041.1 MULTISPECIES: hypothetical protein [Chitinophagaceae]	diamond	249	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae
31318946	31318946	PRJNA855894_P_NODE_25375_length_285_cov_1.660377_g25253_i0	PRJNA855894	25375	285	1.660377	4.73207445	Vreelandella titanicae	664683	Bacteria	Bacteria	94.4	1.17e-20	NR	WP_278370551.1	664683	g25253	i0	52.1	1.01052631578947	96	43	97.9	3	1	279	78	173	WP_278370551.1 MobV family relaxase [Vreelandella titanicae]	diamond	288	94.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Vreelandella	Vreelandella titanicae
31611909	31611909	PRJNA855894_P_NODE_30316_length_250_cov_0.870056_g30194_i0	PRJNA855894	30316	250	0.870056	2.17514	Alphaproteobacteria	28211	Bacteria	Bacteria	133	6.35e-35	NR	SFU21244.1	999627	g30194	i0	79.5	1.992	83	17	99.6	0	1	249	315	397	SFU21244.1 Transposase [Sedimentitalea nanhaiensis]	diamond	498	134	0.992537313432836	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Sedimentitalea	Sedimentitalea nanhaiensis
31698552	31698552	PRJNA855894_P_NODE_13097_length_430_cov_1.509804_g12975_i0	PRJNA855894	13097	430	1.509804	6.4921572	Thiomonas arsenitoxydans	426114	Bacteria	Bacteria	70.5	1.81e-11	NR	WP_276708422.1	426114	g12975	i0	37.7	1.70232558139535	122	62	85.1	5	2	367	135	242	WP_276708422.1 replication initiation factor domain-containing protein [Thiomonas arsenitoxydans]	diamond	732	70.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Thiomonas	Thiomonas arsenitoxydans
31698553	31698553	PRJNA855894_P_NODE_28537_length_258_cov_1.421622_g28415_i0	PRJNA855894	28537	258	1.421622	3.66778476	Caulobacterales bacterium	2282150	Bacteria	Bacteria	123	3.29e-32	NR	MBI2261021.1	2282150	g28415	i0	75.9	0.965116279069767	83	20	96.5	0	257	9	52	134	MBI2261021.1 aspartyl protease family protein [Caulobacterales bacterium]	diamond	249	123	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales			Caulobacterales bacterium
31730085	31730085	PRJNA855894_P_NODE_27517_length_267_cov_1.201031_g27395_i0	PRJNA855894	27517	267	1.201031	3.20675277	unclassified Herbaspirillum	2624150	Bacteria	Bacteria	105	3.3800000000000006e-27	NR	WP_180665557.1	2624150	g27395	i0	96.3	1.8314606741573	54	2	60.7	0	267	106	66	119	WP_180665557.1 MULTISPECIES: RidA family protein [unclassified Herbaspirillum]	diamond	489	105	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum
32236762	32236762	PRJNA855894_P_NODE_25538_length_284_cov_1.364929_g25416_i0	PRJNA855894	25538	284	1.364929	3.87639836	Undibacterium baiyunense	2828731	Bacteria	Bacteria	190	1.14e-57	NR	WP_212683655.1	2828731	g25416	i0	97.9	0.992957746478873	94	2	99.3	0	3	284	90	183	WP_212683655.1 hypothetical protein [Undibacterium baiyunense]	diamond	282	190	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium baiyunense
32561250	32561250	PRJNA855894_P_NODE_31639_length_247_cov_0.885057_g31517_i0	PRJNA855894	31639	247	0.885057	2.18609079	Pseudomonadota	1224	Bacteria	Bacteria	43.9	0.015	NR	WP_253473026.1	414046	g31517	i0	57.9	2.87854251012146	38	16	46.2	0	134	247	1	38	WP_253473026.1 EAL and HDOD domain-containing protein [Natronocella acetinitrilica]	diamond	711	43.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Ectothiorhodospiraceae	Natronocella	Natronocella acetinitrilica
32710217	32710217	PRJNA855894_P_NODE_32280_length_246_cov_0.890173_g32158_i0	PRJNA855894	32280	246	0.890173	2.18982558	Actinomycetota bacterium	2900548	Bacteria	Bacteria	120	1.33e-29	NR	MDP9466133.1	2900548	g32158	i0	78	2	82	18	100	0	246	1	105	186	MDP9466133.1 ABC transporter substrate-binding protein [Actinomycetota bacterium]	diamond	492	120	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
32867678	32867678	PRJNA855894_P_NODE_33200_length_244_cov_0.900585_g33078_i0	PRJNA855894	33200	244	0.900585	2.1974274	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	68.6	2.97e-11	NR	NOS91015.1	2099675	g33078	i0	43.4	0.934426229508197	76	43	93.4	0	1	228	232	307	NOS91015.1 hypothetical protein [Cyclobacteriaceae bacterium]	diamond	228	68.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium

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