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

27 rows where bioproject = "PRJNA312107", 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
8716225	8716225	PRJNA312107_P_NODE_13507_length_199_cov_0.953333_g13341_i0	PRJNA312107	13507	199	0.953333	1.89713267	Bacteriovorax	146784	Bacteria	Bacteria	316	5.55e-82	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g13341	i0	95.477	116.859296482412	199	7	99	2	1	197	1662025	1661827	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	23255	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9991774	9991774	PRJNA312107_P_NODE_12368_length_207_cov_1.259494_g12202_i0	PRJNA312107	12368	207	1.259494	2.60715258	Bdellovibrio	958	Bacteria	Bacteria	315	2.09e-81	NTclustered	gi\|485099167\|ref\|NR_102561.1\|	959	g12202	i0	95.897	88.3236714975845	195	7	94	1	14	207	1630	1824	Bdellovibrio bacteriovorus strain Tiberius 23S ribosomal RNA gene, complete sequence	blastn	18283	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18914951	18914951	PRJNA312107_P_NODE_10615_length_222_cov_1.092486_g10449_i0	PRJNA312107	10615	222	1.092486	2.42531892	Peredibacter	263370	Bacteria	Bacteria	405	1.31e-108	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10449	i0	99.55	172.747747747748	222	1	100	0	1	222	511537	511316	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	38350	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18914968	18914968	PRJNA312107_P_NODE_20395_length_167_cov_1.500000_g20229_i0	PRJNA312107	20395	167	1.5	2.505	Bdellovibrionota	3018035	Bacteria	Bacteria	270	3.5499999999999993e-68	NTclustered	gi\|1080116041\|gb\|KY000520.1\|	28201	g20229	i0	95.833	107.670658682635	168	6	100	1	1	167	360	527	Bdellovibrio sp. strain TLH 16S ribosomal RNA gene, partial sequence	blastn	17981	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
21465368	21465368	PRJNA312107_P_NODE_8717_length_243_cov_1.072165_g8551_i0	PRJNA312107	8717	243	1.072165	2.60536095	Peredibacter	263370	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8551	i0	95.062	124.201646090535	243	10	100	2	1	243	511857	512097	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	30181	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23329674	23329674	PRJNA312107_P_NODE_23159_length_165_cov_0.896552_g22993_i0	PRJNA312107	23159	165	0.896552	1.4793108	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g22993	i0	93.373	256.606060606061	166	10	100	1	1	165	3447762	3447927	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	42340	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
24603628	24603628	PRJNA312107_P_NODE_19420_length_168_cov_1.613445_g19254_i0	PRJNA312107	19420	168	1.613445	2.7105876	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g19254	i0	97.5	44.8630952380952	160	4	95	0	9	168	1292577	1292418	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	7537	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26648460	26648460	PRJNA312107_P_NODE_18961_length_169_cov_0.866667_g18795_i0	PRJNA312107	18961	169	0.866667	1.46466723	Bdellovibrio	958	Bacteria	Bacteria	91.7	6.13e-20	NR	MBC7465026.1	28201	g18795	i0	75	4.97041420118343	56	14	99.4	0	169	2	269	324	MBC7465026.1 DEAD/DEAH box helicase [Bdellovibrio sp.]	diamond	840	91.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
26694325	26694325	PRJNA312107_P_NODE_24961_length_163_cov_0.912281_g24795_i0	PRJNA312107	24961	163	0.912281	1.48701803	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	48.5	7.61e-6	NR	MAX65654.1	2026745	g24795	i0	46.8	2.61349693251534	47	25	86.5	0	143	3	3	49	MAX65654.1 50S ribosomal protein L29 [Halobacteriovoraceae bacterium]	diamond	426	48.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
26884573	26884573	PRJNA312107_P_NODE_23121_length_165_cov_0.896552_g22955_i0	PRJNA312107	23121	165	0.896552	1.4793108	Oligoflexus sp.	1971216	Bacteria	Bacteria	112	3.7100000000000005e-27	NR	WP_325143496.1	1971216	g22955	i0	100	0.963636363636364	53	0	96.4	0	161	3	449	501	WP_325143496.1 replication restart helicase PriA [Oligoflexus sp.]	diamond	159	112	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
27042647	27042647	PRJNA312107_P_NODE_25682_length_162_cov_0.920354_g25516_i0	PRJNA312107	25682	162	0.920354	1.49097348	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	50.1	3.17e-5	NR	MBL7716680.1	2053517	g25516	i0	47.1	0.944444444444444	51	27	94.4	0	161	9	391	441	MBL7716680.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	153	50.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27168851	27168851	PRJNA312107_P_NODE_20802_length_167_cov_0.881356_g20636_i0	PRJNA312107	20802	167	0.881356	1.47186452	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	80.1	2.56e-16	NR	HPI40480.1	2026715	g20636	i0	72.7	0.988023952095808	55	15	98.8	0	165	1	58	112	HPI40480.1 peptidylprolyl isomerase [Pseudobdellovibrionaceae bacterium]	diamond	165	80.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27249864	27249864	PRJNA312107_P_NODE_19443_length_168_cov_1.428571_g19277_i0	PRJNA312107	19443	168	1.428571	2.39999928	Bacteria	2	Bacteria	Bacteria	72.4	4.04e-13	NR	MCO5143756.1	2599941	g19277	i0	79.1	1.53571428571429	43	9	76.8	0	131	3	319	361	MCO5143756.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Oligoflexia bacterium]	diamond	258	72.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
27674706	27674706	PRJNA312107_P_NODE_22484_length_165_cov_0.896552_g22318_i0	PRJNA312107	22484	165	0.896552	1.4793108	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	64.7	2.24e-10	NR	PZQ44255.1	349221	g22318	i0	59.3	0.981818181818182	54	22	98.2	0	3	164	224	277	PZQ44255.1 MAG: UDP-N-acetylmuramate--alanine ligase [Micavibrio aeruginosavorus]	diamond	162	64.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
27737975	27737975	PRJNA312107_P_NODE_20064_length_168_cov_0.873950_g19898_i0	PRJNA312107	20064	168	0.87395	1.468236	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	100	5.449999999999999e-23	NR	NOT80326.1	2081706	g19898	i0	85.2	0.964285714285714	54	8	96.4	0	3	164	240	293	NOT80326.1 potassium-transporting ATPase subunit KdpA [Bacteriovoracaceae bacterium]	diamond	162	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
29554746	29554746	PRJNA312107_P_NODE_24230_length_164_cov_0.895652_g24064_i0	PRJNA312107	24230	164	0.895652	1.46886928	Bdellovibrionota	3018035	Bacteria	Bacteria	78.2	6.24e-16	NR	HEX4923610.1	2053517	g24064	i0	64.8	2.96341463414634	54	19	98.8	0	162	1	47	100	HEX4923610.1 MotA/TolQ/ExbB proton channel family protein [Bdellovibrionales bacterium]	diamond	486	78.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29789798	29789798	PRJNA312107_P_NODE_21451_length_166_cov_0.888889_g21285_i0	PRJNA312107	21451	166	0.888889	1.47555574	Bdellovibrionales bacterium RIFOXYC1_FULL_54_43	1797397	Bacteria	Bacteria	97.4	5.04e-23	NR	OFZ52880.1	1797397	g21285	i0	87	0.975903614457831	54	7	97.6	0	163	2	1	54	OFZ52880.1 MAG: flagellar basal-body rod protein FlgG [Bdellovibrionales bacterium RIFOXYC1_FULL_54_43]	diamond	162	97.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYC1_FULL_54_43
29979460	29979460	PRJNA312107_P_NODE_23231_length_165_cov_0.896552_g23065_i0	PRJNA312107	23231	165	0.896552	1.4793108	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	108	6.13e-26	NR	MBX3021641.1	2053517	g23065	i0	94.4	2.94545454545455	54	3	98.2	0	164	3	350	403	MBX3021641.1 DNA-directed RNA polymerase subunit beta [Bdellovibrionales bacterium]	diamond	486	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30042621	30042621	PRJNA312107_P_NODE_26291_length_162_cov_0.920354_g26125_i0	PRJNA312107	26291	162	0.920354	1.49097348	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	41.2	0.0418	NR	NUM88476.1	2053517	g26125	i0	41	0.722222222222222	39	23	72.2	0	145	29	102	140	NUM88476.1 glycosyltransferase [Bdellovibrionales bacterium]	diamond	117	41.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30264130	30264130	PRJNA312107_P_NODE_18952_length_169_cov_0.866667_g18786_i0	PRJNA312107	18952	169	0.866667	1.46466723	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	80.5	1.94e-16	NR	MEO5669010.1	3034175	g18786	i0	76.1	0.816568047337278	46	11	81.7	0	25	162	37	82	MEO5669010.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Bdellovibrionota bacterium]	diamond	138	80.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30628719	30628719	PRJNA312107_P_NODE_19053_length_169_cov_0.866667_g18887_i0	PRJNA312107	19053	169	0.866667	1.46466723	Bdellovibrionota	3018035	Bacteria	Bacteria	91.3	1.04e-19	NR	MCB0407548.1	2053517	g18887	i0	73.2	2.98224852071006	56	15	99.4	0	1	168	218	273	MCB0407548.1 acyl-CoA dehydrogenase [Bdellovibrionales bacterium]	diamond	504	91.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30959022	30959022	PRJNA312107_P_NODE_21454_length_166_cov_0.888889_g21288_i0	PRJNA312107	21454	166	0.888889	1.47555574	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	66.6	4.95e-11	NR	MES2855834.1	3034175	g21288	i0	54.7	0.957831325301205	53	24	95.8	0	7	165	488	540	MES2855834.1 DUF3857 domain-containing protein [Bdellovibrionota bacterium]	diamond	159	66.6	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31008127	31008127	PRJNA312107_P_NODE_25834_length_162_cov_0.920354_g25668_i0	PRJNA312107	25834	162	0.920354	1.49097348	Bdellovibrio	958	Bacteria	Bacteria	73.9	1.02e-13	NR	WP_061835465.1	959	g25668	i0	61.1	3.01851851851852	54	21	100	0	1	162	149	202	WP_061835465.1 cyclic nucleotide-binding domain-containing protein [Bdellovibrio bacteriovorus]	diamond	489	73.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31717779	31717779	PRJNA312107_P_NODE_21157_length_167_cov_0.881356_g20991_i0	PRJNA312107	21157	167	0.881356	1.47186452	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	78.2	3.82e-15	NR	MEK6706183.1	3034175	g20991	i0	59.3	0.970059880239521	54	22	97	0	3	164	142	195	MEK6706183.1 MFS transporter [Bdellovibrionota bacterium]	diamond	162	78.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31875775	31875775	PRJNA312107_P_NODE_23657_length_164_cov_0.904348_g23491_i0	PRJNA312107	23657	164	0.904348	1.48313072	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	56.2	7.27e-8	NR	MCM2351162.1	2081706	g23491	i0	51.9	0.98780487804878	54	26	98.8	0	164	3	79	132	MCM2351162.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	162	56.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32494872	32494872	PRJNA312107_P_NODE_19739_length_168_cov_0.873950_g19573_i0	PRJNA312107	19739	168	0.87395	1.468236	Bdellovibrionota	3018035	Bacteria	Bacteria	107	5.190000000000001e-27	NR	MBA2405567.1	2053517	g19573	i0	85.7	3	56	8	100	0	1	168	116	171	MBA2405567.1 type I methionyl aminopeptidase [Bdellovibrionales bacterium]	diamond	504	108	0.990740740740741	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32572211	32572211	PRJNA312107_P_NODE_22959_length_165_cov_0.896552_g22793_i0	PRJNA312107	22959	165	0.896552	1.4793108	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	93.2	1.83e-22	NR	MEK6628179.1	3034175	g22793	i0	72.7	1	55	15	100	0	165	1	13	67	MEK6628179.1 EVE domain-containing protein [Bdellovibrionota bacterium]	diamond	165	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota 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);;