metadata: contig_metadata: 27 rows where bioproject = "PRJNA399711", tax_kingdom = "Pseudomonadati" and tax

27 rows where bioproject = "PRJNA399711", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

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
25564267	25564267	PRJNA399711_S_NODE_63161_length_183_cov_2.082192_g63019_i0	PRJNA399711	63161	183	2.082192	3.81041136	Oligoflexia bacterium	2599941	Bacteria	Bacteria	107	2.89e-25	NR	MCM2277905.1	2599941	g63019	i0	83.6	3	61	10	100	0	1	183	390	450	MCM2277905.1 aminopeptidase N [Oligoflexia bacterium]	diamond	549	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
26033156	26033156	PRJNA399711_S_NODE_82908_length_166_cov_1.728682_g82766_i0	PRJNA399711	82908	166	1.728682	2.86961212	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	86.3	5.85e-18	NR	WP_235068168.1	349221	g82766	i0	75.9	0.975903614457831	54	13	97.6	0	164	3	717	770	WP_235068168.1 response regulator [Micavibrio aeruginosavorus]	diamond	162	86.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
26577039	26577039	PRJNA399711_S_NODE_82048_length_166_cov_5.658915_g81906_i0	PRJNA399711	82048	166	5.658915	9.3937989	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	96.7	1.36e-21	NR	HEY8279469.1	3034175	g81906	i0	88.7	0.957831325301205	53	6	95.8	0	165	7	588	640	HEY8279469.1 ATP-dependent DNA helicase RecG [Bdellovibrionota bacterium]	diamond	159	96.7	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31244416	31244416	PRJNA399711_P_NODE_21275_length_157_cov_1.275000_g21209_i0	PRJNA399711	21275	157	1.275	2.00175	Bdellovibrionales bacterium RIFOXYA1_FULL_38_2	2053517	Bacteria	Bacteria	65.9	3.25e-11	NR	OFZ26718.1	1797392	g21209	i0	58	0.955414012738854	50	21	95.5	0	8	157	137	186	OFZ26718.1 MAG: hypothetical protein A2181_08155 [Bdellovibrionales bacterium RIFOXYA1_FULL_38_20]	diamond	150	65.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYA1_FULL_38_20
32917825	32917825	PRJNA399711_S_NODE_71545_length_175_cov_1.434783_g71403_i0	PRJNA399711	71545	175	1.434783	2.51087025	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	85.5	4.3e-18	NR	PZP55631.1	349221	g71403	i0	65.5	0.994285714285714	58	20	99.4	0	175	2	112	169	PZP55631.1 MAG: hypothetical protein DI586_06240 [Micavibrio aeruginosavorus]	diamond	174	85.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32917869	32917869	PRJNA399711_S_NODE_78905_length_169_cov_1.136364_g78763_i0	PRJNA399711	78905	169	1.136364	1.92045516	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	73.2	2.19e-13	NR	HEY8279114.1	3034175	g78763	i0	64.6	0.85207100591716	48	17	85.2	0	145	2	1	48	HEY8279114.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	144	73.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32917887	32917887	PRJNA399711_S_NODE_82993_length_166_cov_1.465116_g82851_i0	PRJNA399711	82993	166	1.465116	2.43209256	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	100	2.3299999999999994e-23	NR	MBA2405565.1	2053517	g82851	i0	83.6	0.993975903614458	55	9	99.4	0	165	1	196	250	MBA2405565.1 arginase family protein [Bdellovibrionales bacterium]	diamond	165	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32923996	32923996	PRJNA399711_S_NODE_106625_length_151_cov_4.991228_g106483_i0	PRJNA399711	106625	151	4.9912280000000004	7.53675428	Bacteria	2	Bacteria	Bacteria	77.8	1.92e-15	NR	MCM2350681.1	2081706	g106483	i0	83.3	4.17218543046358	42	7	83.4	0	1	126	204	245	MCM2350681.1 rod shape-determining protein MreC [Bacteriovoracaceae bacterium]	diamond	630	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32934781	32934781	PRJNA399711_S_NODE_4145_length_453_cov_5.079327_g4010_i0	PRJNA399711	4145	453	5.079327	23.00935131	Peredibacter starrii	28202	Bacteria	Bacteria	133	3.5499999999999995e-35	NR	WP_321398164.1	28202	g4010	i0	52.4	1.36423841059603	103	49	68.2	0	3	311	115	217	WP_321398164.1 (2Fe-2S)-binding protein [Peredibacter starrii]	diamond	618	133	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
32952040	32952040	PRJNA399711_S_NODE_45946_length_205_cov_4.517857_g45804_i0	PRJNA399711	45946	205	4.517857	9.26160685	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	125	2.1199999999999996e-31	NR	HEY8280614.1	3034175	g45804	i0	89.7	0.995121951219512	68	6	99.5	1	1	204	165	231	HEY8280614.1 serine protein kinase [Bdellovibrionota bacterium]	diamond	204	125	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32952067	32952067	PRJNA399711_S_NODE_49226_length_200_cov_3.613497_g49084_i0	PRJNA399711	49226	200	3.613497	7.226994	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	55.1	1.43e-7	NR	MBY0515507.1	2081706	g49084	i0	54.7	1.515	53	24	79.5	0	200	42	43	95	MBY0515507.1 RNA-binding protein [Bacteriovoracaceae bacterium]	diamond	303	55.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32952153	32952153	PRJNA399711_S_NODE_6050_length_404_cov_3.839237_g5908_i0	PRJNA399711	6050	404	3.839237	15.51051748	Bacteriovorax sp.	2608087	Bacteria	Bacteria	95.5	3.54e-20	NR	MFA6236085.1	2608087	g5908	i0	54.3	0.601485148514851	81	37	60.1	0	248	6	3	83	MFA6236085.1 Na+/H+ antiporter NhaA [Bacteriovorax sp.]	diamond	243	95.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
32952361	32952361	PRJNA399711_S_NODE_96090_length_157_cov_3.325000_g95948_i0	PRJNA399711	96090	157	3.325	5.22025	Peredibacter starrii	28202	Bacteria	Bacteria	71.2	1.01e-12	NR	WP_321398936.1	28202	g95948	i0	73.1	0.993630573248408	52	14	99.4	0	156	1	164	215	WP_321398936.1 hypothetical protein [Peredibacter starrii]	diamond	156	71.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
32968956	32968956	PRJNA399711_S_NODE_104010_length_153_cov_1.301724_g103868_i0	PRJNA399711	104010	153	1.301724	1.99163772	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	76.3	8.07e-15	NR	MCM2350501.1	2081706	g103868	i0	85.4	0.941176470588235	48	7	94.1	0	10	153	1	48	MCM2350501.1 LysR family transcriptional regulator [Bacteriovoracaceae bacterium]	diamond	144	76.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
33020362	33020362	PRJNA399711_S_NODE_73036_length_173_cov_6.382353_g72894_i0	PRJNA399711	73036	173	6.382353	11.04147069	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	72.8	2.72e-14	NR	MCM2349205.1	2081706	g72894	i0	58.8	1.78612716763006	51	21	88.4	0	9	161	71	121	MCM2349205.1 chemotaxis protein CheX [Bacteriovoracaceae bacterium]	diamond	309	72.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
33037064	33037064	PRJNA399711_S_NODE_14780_length_305_cov_4.921642_g14638_i0	PRJNA399711	14780	305	4.921642	15.0110081	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	140	2.46e-36	NR	MBK9323013.1	2026715	g14638	i0	71	1.9672131147541	100	29	98.4	0	305	6	4	103	MBK9323013.1 relaxase/mobilization nuclease domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	600	140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
33071189	33071189	PRJNA399711_S_NODE_28309_length_244_cov_2.004831_g28167_i0	PRJNA399711	28309	244	2.004831	4.89178764	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	91.7	2.26e-19	NR	WP_323576326.1	3088717	g28167	i0	97.8	0.55327868852459	45	1	55.3	0	137	3	1	45	WP_323576326.1 UvrD-helicase domain-containing protein [Bacteriovorax antarcticus]	diamond	135	91.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus
33071525	33071525	PRJNA399711_S_NODE_81957_length_166_cov_6.596899_g81815_i0	PRJNA399711	81957	166	6.596899	10.95085234	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	82	1.63e-17	NR	MFN9065658.1	2053517	g81815	i0	70	1.80722891566265	50	15	90.4	0	165	16	25	74	MFN9065658.1 response regulator [Bdellovibrionales bacterium]	diamond	300	82	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
33111905	33111905	PRJNA399711_S_NODE_89702_length_161_cov_2.580645_g89560_i0	PRJNA399711	89702	161	2.580645	4.15483845	Bdellovibrionota	3018035	Bacteria	Bacteria	87.4	6.5100000000000005e-21	NR	PIU01355.1	1973927	g89560	i0	89.1	2.57142857142857	46	5	85.7	0	3	140	45	90	PIU01355.1 MAG: type II toxin-antitoxin system RelE/ParE family toxin [Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34]	diamond	414	87.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34
33122573	33122573	PRJNA399711_S_NODE_45975_length_205_cov_4.226190_g45833_i0	PRJNA399711	45975	205	4.22619	8.6636895	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	75.1	2.77e-15	NR	MES2964926.1	3034175	g45833	i0	55.4	1.88780487804878	65	29	95.1	0	2	196	25	89	MES2964926.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	387	75.1	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33122575	33122575	PRJNA399711_S_NODE_46447_length_204_cov_6.796407_g46305_i0	PRJNA399711	46447	204	6.796407	13.86467028	Oligoflexus sp.	1971216	Bacteria	Bacteria	100	1.2099999999999999e-23	NR	WP_324949503.1	1971216	g46305	i0	70.1	1.97058823529412	67	20	98.5	0	203	3	54	120	WP_324949503.1 tetratricopeptide repeat protein [Oligoflexus sp.]	diamond	402	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
33122702	33122702	PRJNA399711_S_NODE_62663_length_183_cov_6.205479_g62521_i0	PRJNA399711	62663	183	6.205479	11.35602657	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	109	4.47e-26	NR	MBK7842920.1	2053517	g62521	i0	88.3	1.9672131147541	60	7	98.4	0	4	183	545	604	MBK7842920.1 efflux RND transporter permease subunit [Bdellovibrionales bacterium]	diamond	360	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
33139649	33139649	PRJNA399711_S_NODE_48143_length_202_cov_1.618182_g48001_i0	PRJNA399711	48143	202	1.618182	3.26872764	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	48.1	1.83e-5	NR	HXH32195.1	2081706	g48001	i0	100	0.341584158415842	23	0	34.2	0	134	202	1	23	HXH32195.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	69	48.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
33139902	33139902	PRJNA399711_S_NODE_92287_length_159_cov_5.393443_g92145_i0	PRJNA399711	92287	159	5.393443	8.57557437	Bdellovibrio sp.	28201	Bacteria	Bacteria	47	3.47e-4	NR	WP_347358995.1	28201	g92145	i0	63.4	1.54716981132075	41	15	77.4	0	140	18	212	252	WP_347358995.1 hypothetical protein [Bdellovibrio sp.]	diamond	246	47	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
33146123	33146123	PRJNA399711_S_NODE_82791_length_166_cov_2.093023_g82649_i0	PRJNA399711	82791	166	2.093023	3.47441818	Peredibacter	263370	Bacteria	Bacteria	82.4	1.79e-17	NR	WP_321389773.1	28202	g82649	i0	79.6	4.33734939759036	49	10	88.6	0	18	164	1	49	WP_321389773.1 LysE/ArgO family amino acid transporter [Peredibacter starrii]	diamond	720	82.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
33156882	33156882	PRJNA399711_S_NODE_93904_length_158_cov_6.537190_g93762_i0	PRJNA399711	93904	158	6.53719	10.3287602	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	73.6	3.98e-14	NR	HEY8278601.1	3034175	g93762	i0	71.2	0.987341772151899	52	15	98.7	0	1	156	147	198	HEY8278601.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	156	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33173927	33173927	PRJNA399711_S_NODE_57912_length_189_cov_1.243421_g57770_i0	PRJNA399711	57912	189	1.243421	2.35006569	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	111	2.5e-29	NR	MCM2351287.1	2081706	g57770	i0	85.5	1.96825396825397	62	9	98.4	0	3	188	51	112	MCM2351287.1 YchJ family protein [Bacteriovoracaceae bacterium]	diamond	372	111	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;