metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA474911" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA474911" 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
2372569	2372569	PRJNA474911_P_NODE_6282_length_223_cov_1.469136_g6155_i0	PRJNA474911	6282	223	1.469136	3.27617328	Sphingomonas sp.	28214	Bacteria	Bacteria	72.4	6.98e-15	NR	WP_300493146.1	28214	g6155	i0	88.1	1.13004484304933	42	5	56.5	0	126	1	1	42	WP_300493146.1 hypothetical protein [Sphingomonas sp.]	diamond	252	72.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp.
2998369	2998369	PRJNA474911_P_NODE_8263_length_201_cov_0.914286_g8136_i0	PRJNA474911	8263	201	0.914286	1.83771486	Mycobacterium gordonae	1778	Bacteria	Bacteria	136	7.65e-38	NR	WP_069434356.1	1778	g8136	i0	100	2	67	0	100	0	1	201	112	178	WP_069434356.1 arylamine N-acetyltransferase family protein [Mycobacterium gordonae]	diamond	402	136	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium gordonae
9375443	9375443	PRJNA474911_P_NODE_5808_length_234_cov_1.109827_g5681_i0	PRJNA474911	5808	234	1.109827	2.59699518	Rheinheimera sp.	1869214	Bacteria	Bacteria	145	2.12e-41	NR	HAT43178.1	1869214	g5681	i0	98.7	1	78	1	100	0	1	234	102	179	HAT43178.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Rheinheimera sp.]	diamond	234	145	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp.
18299197	18299197	PRJNA474911_P_NODE_7495_length_206_cov_0.882759_g7368_i0	PRJNA474911	7495	206	0.882759	1.81848354	Sphingomonas sp.	28214	Bacteria	Bacteria	132	4.849999999999998e-35	NR	WP_300494976.1	28214	g7368	i0	100	0.975728155339806	67	0	97.6	0	2	202	198	264	WP_300494976.1 serine hydrolase [Sphingomonas sp.]	diamond	201	132	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp.
26601141	26601141	PRJNA474911_P_NODE_7061_length_209_cov_0.864865_g6934_i0	PRJNA474911	7061	209	0.864865	1.80756785	Microvirga arabica	1128671	Bacteria	Bacteria	129	1.12e-33	NR	WP_377030868.1	1128671	g6934	i0	91.3	0.990430622009569	69	6	99	0	2	208	340	408	WP_377030868.1 CmpA/NrtA family ABC transporter substrate-binding protein [Microvirga arabica]	diamond	207	129	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Microvirga	Microvirga arabica
26696316	26696316	PRJNA474911_P_NODE_5281_length_247_cov_2.919355_g5154_i0	PRJNA474911	5281	247	2.919355	7.21080685	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42.7	0.0242	NR	MCC6427943.1	2052180	g5154	i0	47.5	0.48582995951417	40	20	48.6	1	81	200	125	163	MCC6427943.1 PepSY domain-containing protein [Phycisphaerales bacterium]	diamond	120	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26791525	26791525	PRJNA474911_P_NODE_7481_length_206_cov_0.882759_g7354_i0	PRJNA474911	7481	206	0.882759	1.81848354	Cupriavidus sp. UGS-1	2899826	Bacteria	Bacteria	139	3.32e-36	NR	WP_232205132.1	2899826	g7354	i0	100	0.990291262135922	68	0	99	0	206	3	2488	2555	WP_232205132.1 filamentous hemagglutinin N-terminal domain-containing protein [Cupriavidus sp. UGS-1]	diamond	204	139	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus sp. UGS-1
26918093	26918093	PRJNA474911_P_NODE_7002_length_209_cov_0.864865_g6875_i0	PRJNA474911	7002	209	0.864865	1.80756785	Streptococcus rubneri	1234680	Bacteria	Bacteria	139	3.039999999999999e-38	NR	WP_195563958.1	1234680	g6875	i0	100	0.976076555023923	68	0	97.6	0	207	4	245	312	WP_195563958.1 hypothetical protein [Streptococcus rubneri]	diamond	204	139	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus rubneri
27250381	27250381	PRJNA474911_P_NODE_2863_length_361_cov_1.440000_g2737_i0	PRJNA474911	2863	361	1.44	5.1984	PVC group	1783257	Bacteria	Bacteria	63.2	3.17e-9	NR	MCK4859712.1	2035772	g2737	i0	62.5	1.66204986149584	40	15	33.2	0	325	206	2	41	MCK4859712.1 adenylate kinase [Candidatus Omnitrophota bacterium]	diamond	600	63.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27265985	27265985	PRJNA474911_P_NODE_6463_length_219_cov_0.797468_g6336_i0	PRJNA474911	6463	219	0.797468	1.74645492	Nocardioides daedukensis	634462	Bacteria	Bacteria	42	0.00997	NR	WP_179503640.1	634462	g6336	i0	42.6	0.73972602739726	54	20	74	2	47	208	31	73	WP_179503640.1 hypothetical protein [Nocardioides daedukensis]	diamond	162	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides daedukensis
27676758	27676758	PRJNA474911_P_NODE_8304_length_201_cov_0.914286_g8177_i0	PRJNA474911	8304	201	0.914286	1.83771486	Klebsiella pneumoniae	573	Bacteria	Bacteria	47	7.16e-5	NR	WP_416493070.1	573	g8177	i0	65.1	0.641791044776119	43	15	64.2	0	46	174	26	68	WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	129	47	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
27865802	27865802	PRJNA474911_P_NODE_7125_length_208_cov_1.312925_g6998_i0	PRJNA474911	7125	208	1.312925	2.730884	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	42.7	0.0244	NR	MBQ6248075.1	2212473	g6998	i0	51.2	0.591346153846154	41	16	59.1	1	2	124	20	56	MBQ6248075.1 DEAD/DEAH box helicase family protein [Kiritimatiellia bacterium]	diamond	123	42.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27992358	27992358	PRJNA474911_P_NODE_7305_length_207_cov_0.876712_g7178_i0	PRJNA474911	7305	207	0.876712	1.81479384	Candidatus Deferrimicrobium sp.	3060586	Bacteria	Bacteria	43.9	0.00858	NR	HLO36228.1	3060586	g7178	i0	34.5	0.797101449275362	55	33	79.7	1	21	185	7	58	HLO36228.1 GNAT family N-acetyltransferase [Candidatus Deferrimicrobium sp.]	diamond	165	43.9	1	Bacteria			Candidatus Deferrimicrobiota	Candidatus Deferrimicrobia	Candidatus Deferrimicrobiales	Candidatus Deferrimicrobiaceae	Candidatus Deferrimicrobium	Candidatus Deferrimicrobium sp.
28023921	28023921	PRJNA474911_P_NODE_7845_length_204_cov_0.895105_g7718_i0	PRJNA474911	7845	204	0.895105	1.8260142	Phenylobacterium sp.	1871053	Bacteria	Bacteria	132	6.32e-35	NR	WP_333586332.1	1871053	g7718	i0	100	1.97058823529412	67	0	98.5	0	3	203	41	107	WP_333586332.1 mechanosensitive ion channel [Phenylobacterium sp.]	diamond	402	132	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Phenylobacterium	Phenylobacterium sp.
28213007	28213007	PRJNA474911_P_NODE_6146_length_226_cov_1.236364_g6019_i0	PRJNA474911	6146	226	1.236364	2.79418264	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	42	0.0448	NR	MEN1727192.1	1977087	g6019	i0	38	0.663716814159292	50	29	63.7	1	32	175	113	162	MEN1727192.1 hypothetical protein [Pseudomonadota bacterium]	diamond	150	42	1	Bacteria		Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
28308072	28308072	PRJNA474911_P_NODE_7806_length_204_cov_0.895105_g7679_i0	PRJNA474911	7806	204	0.895105	1.8260142	Tsukamurella sp. PLM1	2929795	Bacteria	Bacteria	43.1	0.0121	NR	BDH59710.1	2929795	g7679	i0	33.3	3.52941176470588	60	38	88.2	1	21	200	86	143	BDH59710.1 hypothetical protein MTP03_46490 [Tsukamurella sp. PLM1]	diamond	720	43.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella sp. PLM1
28671532	28671532	PRJNA474911_P_NODE_7927_length_203_cov_0.901408_g7800_i0	PRJNA474911	7927	203	0.901408	1.82985824	Sphingomonas	13687	Bacteria	Bacteria	53.1	9.69e-7	NR	WP_138995789.1	1112213	g7800	i0	47.5	2.61576354679803	61	32	90.1	0	203	21	17	77	WP_138995789.1 hypothetical protein [Sphingomonas sp. PAMC 26621]	diamond	531	53.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. PAMC 26621
28750047	28750047	PRJNA474911_P_NODE_6987_length_209_cov_0.864865_g6860_i0	PRJNA474911	6987	209	0.864865	1.80756785	Bradyrhizobium lablabi	722472	Bacteria	Bacteria	120	2.24e-31	NR	WP_212217550.1	722472	g6860	i0	81.2	0.990430622009569	69	13	99	0	209	3	32	100	WP_212217550.1 amidohydrolase family protein [Bradyrhizobium lablabi]	diamond	207	120	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium lablabi
28844555	28844555	PRJNA474911_P_NODE_5148_length_252_cov_0.848168_g5021_i0	PRJNA474911	5148	252	0.848168	2.13738336	Agrococcus sp. Ld7	649148	Bacteria	Bacteria	41.6	0.0404	NR	WP_405219380.1	649148	g5021	i0	34.4	0.761904761904762	64	42	76.2	0	3	194	28	91	WP_405219380.1 fluoride efflux transporter FluC [Agrococcus sp. Ld7]	diamond	192	41.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agrococcus	Agrococcus sp. Ld7
29019023	29019023	PRJNA474911_P_NODE_6548_length_217_cov_1.230769_g6421_i0	PRJNA474911	6548	217	1.230769	2.67076873	Rhizomicrobium	1241326	Bacteria	Bacteria	96.3	3.7e-21	NR	MCP5043391.1	1869227	g6421	i0	62	16.6589861751152	71	27	98.2	0	2	214	66	136	MCP5043391.1 long-chain-acyl-CoA synthetase [bacterium]	diamond	3615	96.3	1	Bacteria								bacterium
29696852	29696852	PRJNA474911_P_NODE_3030_length_348_cov_1.024390_g2904_i0	PRJNA474911	3030	348	1.02439	3.5648772	Candidatus Amarolinea dominans	3140696	Bacteria	Bacteria	45.8	0.00911	NR	MBK9230563.1	3140696	g2904	i0	34.1	1.51724137931034	88	53	71.6	1	90	338	69	156	MBK9230563.1 amidohydrolase [Candidatus Amarolinea dominans]	diamond	528	45.8	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Candidatus Amarolineaceae	Candidatus Amarolinea	Candidatus Amarolinea dominans
29760244	29760244	PRJNA474911_P_NODE_8471_length_193_cov_2.287879_g8344_i0	PRJNA474911	8471	193	2.287879	4.41560647	Acinetobacter baumannii	470	Bacteria	Bacteria	76.6	1.82e-16	NR	WP_306225785.1	470	g8344	i0	92.7	0.854922279792746	55	4	85.5	0	3	167	5	59	WP_306225785.1 hypothetical protein [Acinetobacter baumannii]	diamond	165	76.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
30107775	30107775	PRJNA474911_P_NODE_2952_length_353_cov_1.534247_g2826_i0	PRJNA474911	2952	353	1.534247	5.41589191	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	62.8	3.22e-9	NR	MDO4241565.1	1873462	g2826	i0	35.5	1.02832861189802	121	52	98.6	4	3	350	68	167	MDO4241565.1 adenylate kinase [Microbacteriaceae bacterium]	diamond	363	62.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
30297911	30297911	PRJNA474911_P_NODE_4712_length_265_cov_1.509804_g4585_i0	PRJNA474911	4712	265	1.509804	4.0009806	Sulfuricella sp. T	2099377	Bacteria	Bacteria	50.8	5.74e-5	NR	WP_144408221.1	1632857	g4585	i0	40.8	0.80377358490566	71	41	80.4	1	50	262	150	219	WP_144408221.1 phosphatase PAP2 family protein [Sulfuricella sp. T08]	diamond	213	50.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Sulfuricellaceae	Sulfuricella	Sulfuricella sp. T08
30676432	30676432	PRJNA474911_P_NODE_7913_length_203_cov_1.218310_g7786_i0	PRJNA474911	7913	203	1.21831	2.4731693	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	42.7	0.0219	NR	MES2919868.1	1977087	g7786	i0	46.4	0.827586206896552	56	26	79.8	2	187	26	396	449	MES2919868.1 DUF3999 domain-containing protein [Pseudomonadota bacterium]	diamond	168	42.7	1	Bacteria		Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
30739735	30739735	PRJNA474911_P_NODE_7054_length_209_cov_0.864865_g6927_i0	PRJNA474911	7054	209	0.864865	1.80756785	Acinetobacter lwoffii	28090	Bacteria	Bacteria	135	5.77e-36	NR	WP_253114842.1	28090	g6927	i0	100	0.990430622009569	69	0	99	0	2	208	314	382	WP_253114842.1 hypothetical protein [Acinetobacter lwoffii]	diamond	207	135	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
30914021	30914021	PRJNA474911_P_NODE_8554_length_188_cov_2.007874_g8427_i0	PRJNA474911	8554	188	2.007874	3.77480312	Yoonia	2211641	Bacteria	Bacteria	43.1	0.0131	NR	WP_409696605.1	2212373	g8427	i0	42.6	1.9468085106383	61	32	97.3	1	187	5	25	82	WP_409696605.1 hypothetical protein [Yoonia sp.]	diamond	366	43.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Yoonia	Yoonia sp.
31056042	31056042	PRJNA474911_P_NODE_3575_length_315_cov_1.480315_g3449_i0	PRJNA474911	3575	315	1.480315	4.66299225	Rhizobacter sp.	1909292	Bacteria	Bacteria	116	3.38e-30	NR	MET0334258.1	1909292	g3449	i0	52.8	1.00952380952381	106	49	100	1	315	1	75	180	MET0334258.1 glutathione transferase GstA [Rhizobacter sp.]	diamond	318	116	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Rhizobacter	Rhizobacter sp.
31150061	31150061	PRJNA474911_P_NODE_7215_length_208_cov_0.870748_g7088_i0	PRJNA474911	7215	208	0.870748	1.81115584	Rickettsia endosymbiont of Ixodes persulcatus	2005673	Bacteria	Bacteria	147	1.71e-42	NR	MCZ6914134.1	2005673	g7088	i0	95.7	0.995192307692308	69	3	99.5	0	208	2	131	199	MCZ6914134.1 endonuclease/exonuclease/phosphatase family protein [Rickettsia endosymbiont of Ixodes persulcatus]	diamond	207	147	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia endosymbiont of Ixodes persulcatus
31308518	31308518	PRJNA474911_P_NODE_7015_length_209_cov_0.864865_g6888_i0	PRJNA474911	7015	209	0.864865	1.80756785	Sphingomonas liriopis	2949094	Bacteria	Bacteria	112	5.880000000000001e-27	NR	WP_254289494.1	2949094	g6888	i0	79.7	4.95215311004785	69	14	99	0	3	209	123	191	WP_254289494.1 amino acid permease [Sphingomonas liriopis]	diamond	1035	112	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas liriopis
31340218	31340218	PRJNA474911_P_NODE_6976_length_209_cov_1.182432_g6849_i0	PRJNA474911	6976	209	1.182432	2.47128288	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	42	0.0453	NR	AZZ35451.1	1916293	g6849	i0	45	0.574162679425837	40	22	57.4	0	130	11	314	353	AZZ35451.1 catalase/peroxidase HPI [Bdellovibrio sp. qaytius]	diamond	120	42	1	Bacteria		Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
31466899	31466899	PRJNA474911_P_NODE_7616_length_205_cov_0.888889_g7489_i0	PRJNA474911	7616	205	0.888889	1.82222245	Corynebacterium kroppenstedtii	161879	Bacteria	Bacteria	134	9.05e-37	NR	WP_303735073.1	161879	g7489	i0	100	0.980487804878049	67	0	98	0	203	3	89	155	WP_303735073.1 ornithine cyclodeaminase [Corynebacterium kroppenstedtii]	diamond	201	134	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
32036117	32036117	PRJNA474911_P_NODE_7938_length_203_cov_0.901408_g7811_i0	PRJNA474911	7938	203	0.901408	1.82985824	Candidatus Mediterraneibacter norwichensis	2838680	Bacteria	Bacteria	47	6.74e-4	NR	HIV52785.1	2838680	g7811	i0	51	1.49261083743842	49	24	72.4	0	7	153	257	305	HIV52785.1 L-lactate dehydrogenase [Candidatus Mediterraneibacter norwichensis]	diamond	303	47	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Candidatus Mediterraneibacter norwichensis
32099377	32099377	PRJNA474911_P_NODE_4398_length_277_cov_1.393519_g4271_i0	PRJNA474911	4398	277	1.393519	3.86004763	Paracoccus spongiarum	3064387	Bacteria	Bacteria	42.4	0.0303	NR	WP_305962362.1	3064387	g4271	i0	45.7	0.498194945848375	46	25	49.8	0	71	208	53	98	WP_305962362.1 YraN family protein [Paracoccus spongiarum]	diamond	138	42.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus spongiarum

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