metadata: contig_metadata: 26 rows where bioproject = "PRJNA492363", tax_kingdom = "Pseudomonadati" and tax

26 rows where bioproject = "PRJNA492363", 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
25975588	25975588	PRJNA492363_S_NODE_89476_length_207_cov_1.931507_g88655_i0	PRJNA492363	89476	207	1.931507	3.99821949	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	89	1.12e-18	NR	MFP5387462.1	3058048	g88655	i0	75	1.6231884057971	56	14	81.2	0	2	169	192	247	MFP5387462.1 GldG family protein [Bacteriovoracia bacterium]	diamond	336	89	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
25975688	25975688	PRJNA492363_S_NODE_93204_length_205_cov_1.333333_g92383_i0	PRJNA492363	93204	205	1.333333	2.73333265	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	257	3.53e-64	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g92383	i0	89.268	1.58536585365854	205	22	100	0	1	205	903115	902911	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	325	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26110981	26110981	PRJNA492363_S_NODE_51749_length_232_cov_1.122807_g50928_i0	PRJNA492363	51749	232	1.1228070000000001	2.60491224	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	121	3.11e-32	NR	MES2529214.1	3034175	g50928	i0	82.4	0.879310344827586	68	12	87.9	0	27	230	94	161	MES2529214.1 sulfite exporter TauE/SafE family protein [Bdellovibrionota bacterium]	diamond	204	121	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
26111810	26111810	PRJNA492363_S_NODE_96941_length_203_cov_1.352113_g96120_i0	PRJNA492363	96941	203	1.352113	2.74478939	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	134	6.14e-27	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g96120	i0	80.702	11.6650246305419	171	33	84	0	1	171	2103636	2103466	Bacteriovorax sp. HI3 DNA, complete genome	blastn	2368	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
26246250	26246250	PRJNA492363_S_NODE_1046_length_3052_cov_10.773320_g411_i0	PRJNA492363	1046	3052	10.77332	328.8017264	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	555	9.56e-186	NR	QQG35172.1	349221	g411	i0	67.8	0.41480996068152	422	136	41.5	0	2152	887	1	422	QQG35172.1 MAG: relaxase [Micavibrio aeruginosavorus]	diamond	1266	555	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
26247723	26247723	PRJNA492363_S_NODE_85854_length_209_cov_1.729730_g85033_i0	PRJNA492363	85854	209	1.72973	3.6151357	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	154	4.88e-33	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g85033	i0	80.097	0.985645933014354	206	41	99	0	2	207	3261105	3261310	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	206	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26383558	26383558	PRJNA492363_S_NODE_85855_length_209_cov_1.729730_g85034_i0	PRJNA492363	85855	209	1.72973	3.6151357	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	309	9.85e-80	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g85034	i0	93.301	2	209	14	100	0	1	209	1617443	1617235	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	418	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26519903	26519903	PRJNA492363_S_NODE_91392_length_206_cov_1.324138_g90571_i0	PRJNA492363	91392	206	1.324138	2.72772428	Peredibacter starrii	28202	Bacteria	Bacteria	171	4.76e-38	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g90571	i0	82.09	1.98058252427184	201	35	97	1	1	200	2188093	2188293	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	408	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26577521	26577521	PRJNA492363_S_NODE_89888_length_207_cov_0.876712_g89067_i0	PRJNA492363	89888	207	0.876712	1.81479384	Peredibacter	263370	Bacteria	Bacteria	206	1.3099999999999999e-48	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g89067	i0	84.541	2	207	32	100	0	1	207	426509	426715	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	414	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
32917983	32917983	PRJNA492363_S_NODE_100873_length_201_cov_1.285714_g100052_i0	PRJNA492363	100873	201	1.285714	2.58428514	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	130	5.64e-34	NR	MES2526928.1	3034175	g100052	i0	90.8	0.970149253731343	65	6	97	0	196	2	267	331	MES2526928.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	195	130	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32969557	32969557	PRJNA492363_S_NODE_101178_length_201_cov_0.914286_g100357_i0	PRJNA492363	101178	201	0.914286	1.83771486	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	129	6.78e-34	NR	MFL5785505.1	2081706	g100357	i0	83.3	0.985074626865672	66	11	98.5	0	200	3	151	216	MFL5785505.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	198	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32969766	32969766	PRJNA492363_S_NODE_86186_length_209_cov_0.864865_g85365_i0	PRJNA492363	86186	209	0.864865	1.80756785	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	143	6.43e-38	NR	MES2528094.1	3034175	g85365	i0	89.9	1.98086124401914	69	7	99	0	209	3	13	81	MES2528094.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	414	143	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33003495	33003495	PRJNA492363_S_NODE_101139_length_201_cov_0.914286_g100318_i0	PRJNA492363	101139	201	0.914286	1.83771486	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	68.9	1.2e-11	NR	MES2527525.1	3034175	g100318	i0	91.4	0.522388059701492	35	3	52.2	0	3	107	441	475	MES2527525.1 HD domain-containing protein [Bdellovibrionota bacterium]	diamond	105	68.9	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33003728	33003728	PRJNA492363_S_NODE_95091_length_204_cov_1.342657_g94270_i0	PRJNA492363	95091	204	1.342657	2.73902028	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	103	9.55e-25	NR	MES2529235.1	3034175	g94270	i0	81.3	0.941176470588235	64	12	94.1	0	11	202	1	64	MES2529235.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	192	103	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33026846	33026846	PRJNA492363_S_NODE_89820_length_207_cov_0.876712_g88999_i0	PRJNA492363	89820	207	0.876712	1.81479384	Peredibacter	263370	Bacteria	Bacteria	139	5.95e-37	NR	WP_321394678.1	28202	g88999	i0	98.5	3.94202898550725	68	1	98.6	0	206	3	377	444	WP_321394678.1 sigma-54 dependent transcriptional regulator [Peredibacter starrii]	diamond	816	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
33026848	33026848	PRJNA492363_S_NODE_89892_length_207_cov_0.876712_g89071_i0	PRJNA492363	89892	207	0.876712	1.81479384	Bacteria	2	Bacteria	Bacteria	129	1.0699999999999999e-32	NR	MFL5784329.1	2081706	g89071	i0	97	1.94202898550725	67	2	97.1	0	205	5	81	147	MFL5784329.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	402	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
33037860	33037860	PRJNA492363_S_NODE_91636_length_206_cov_0.882759_g90815_i0	PRJNA492363	91636	206	0.882759	1.81848354	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	112	6.47e-29	NR	MES2526115.1	3034175	g90815	i0	85.3	0.990291262135922	68	10	99	0	206	3	79	146	MES2526115.1 response regulator [Bdellovibrionota bacterium]	diamond	204	112	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33054808	33054808	PRJNA492363_S_NODE_70269_length_223_cov_1.580247_g69448_i0	PRJNA492363	70269	223	1.580247	3.52395081	Peredibacter starrii	28202	Bacteria	Bacteria	77.8	8.27e-15	NR	WP_321398940.1	28202	g69448	i0	60.3	0.847533632286996	63	25	84.8	0	191	3	1	63	WP_321398940.1 hypothetical protein [Peredibacter starrii]	diamond	189	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
33054914	33054914	PRJNA492363_S_NODE_94941_length_204_cov_1.720280_g94120_i0	PRJNA492363	94941	204	1.72028	3.5093712	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	58.9	1.94e-8	NR	MCM2348728.1	2081706	g94120	i0	59.6	0.691176470588235	47	19	69.1	0	141	1	2	48	MCM2348728.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	141	58.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
33054939	33054939	PRJNA492363_S_NODE_99029_length_202_cov_0.907801_g98208_i0	PRJNA492363	99029	202	0.907801	1.83375802	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	113	1.76e-28	NR	MFP5458910.1	3058048	g98208	i0	77.6	0.995049504950495	67	15	99.5	0	1	201	140	206	MFP5458910.1 DUF2071 domain-containing protein [Bacteriovoracia bacterium]	diamond	201	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
33071808	33071808	PRJNA492363_S_NODE_78589_length_216_cov_2.064516_g77768_i0	PRJNA492363	78589	216	2.064516	4.45935456	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	130	4.55e-33	NR	MES2527789.1	3034175	g77768	i0	87.3	0.986111111111111	71	9	98.6	0	3	215	543	613	MES2527789.1 phosphoenolpyruvate carboxylase [Bdellovibrionota bacterium]	diamond	213	130	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33089112	33089112	PRJNA492363_S_NODE_99014_length_202_cov_0.907801_g98193_i0	PRJNA492363	99014	202	0.907801	1.83375802	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	97.8	2.15e-22	NR	MES2527733.1	3034175	g98193	i0	94.2	0.772277227722772	52	3	77.2	0	2	157	290	341	MES2527733.1 DUF3108 domain-containing protein [Bdellovibrionota bacterium]	diamond	156	97.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33106106	33106106	PRJNA492363_S_NODE_91590_length_206_cov_0.882759_g90769_i0	PRJNA492363	91590	206	0.882759	1.81848354	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	127	2.05e-33	NR	MES2529199.1	3034175	g90769	i0	86.8	0.990291262135922	68	9	99	0	206	3	247	314	MES2529199.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	204	127	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33140142	33140142	PRJNA492363_S_NODE_86087_length_209_cov_0.864865_g85266_i0	PRJNA492363	86087	209	0.864865	1.80756785	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	105	5.9e-25	NR	MES2528060.1	3034175	g85266	i0	72.5	0.990430622009569	69	19	99	0	209	3	286	354	MES2528060.1 twitch domain-containing radical SAM protein [Bdellovibrionota bacterium]	diamond	207	105	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33157125	33157125	PRJNA492363_S_NODE_86160_length_209_cov_0.864865_g85339_i0	PRJNA492363	86160	209	0.864865	1.80756785	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	127	2.8899999999999996e-32	NR	MES2528527.1	3034175	g85339	i0	89.9	0.990430622009569	69	7	99	0	1	207	172	240	MES2528527.1 ABC transporter substrate-binding protein [Bdellovibrionota bacterium]	diamond	207	127	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
33163108	33163108	PRJNA492363_S_NODE_14200_length_264_cov_1.261084_g13379_i0	PRJNA492363	14200	264	1.261084	3.32926176	Bdellovibrionota	3018035	Bacteria	Bacteria	134	2.1799999999999997e-35	NR	WP_015089288.1	959	g13379	i0	70.5	2	88	26	100	0	1	264	179	266	WP_015089288.1 type II toxin-antitoxin system HipA family toxin [Bdellovibrio bacteriovorus]	diamond	528	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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