metadata: contig_metadata: 18 rows where bioproject = "PRJNA756891", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA756891", 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
5835520	5835520	PRJNA756891_P_NODE_10585_length_269_cov_1.571429_g10516_i0	PRJNA756891	10585	269	1.571429	4.22714401	Pseudomonadati	3379134	Bacteria	Bacteria	177	6.34e-50	NR	HLW57438.1	2081706	g10516	i0	94.4	1.98513011152416	89	5	99.3	0	268	2	170	258	HLW57438.1 3'-5' exonuclease [Bacteriovoracaceae bacterium]	diamond	534	177	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
7110680	7110680	PRJNA756891_P_NODE_12726_length_250_cov_0.870056_g12657_i0	PRJNA756891	12726	250	0.870056	2.17514	Bacteriovorax stolpii	960	Bacteria	Bacteria	285	2.05e-72	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g12657	i0	87.2	1.988	250	32	100	0	1	250	2814549	2814300	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	497	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19859008	19859008	PRJNA756891_P_NODE_12116_length_251_cov_0.865169_g12047_i0	PRJNA756891	12116	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	125	5.639999999999999e-32	NR	MFM6927754.1	28201	g12047	i0	70	13.1832669322709	80	24	95.6	0	11	250	127	206	MFM6927754.1 hypothetical protein [Bdellovibrio sp.]	diamond	3309	126	0.992063492063492	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
19859053	19859053	PRJNA756891_P_NODE_3496_length_448_cov_1.232000_g3428_i0	PRJNA756891	3496	448	1.232	5.51936	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	189	1.4899999999999999e-52	NR	HEY8270449.1	2026715	g3428	i0	64.4	13.9620535714286	149	50	99.8	2	2	448	278	423	HEY8270449.1 aminomethyl-transferring glycine dehydrogenase [Pseudobdellovibrionaceae bacterium]	diamond	6255	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
25428884	25428884	PRJNA756891_P_NODE_13620_length_247_cov_1.770115_g13551_i0	PRJNA756891	13620	247	1.770115	4.37218405	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	91.3	1.29e-19	NR	WP_277579582.1	2972972	g13551	i0	51.3	0.97165991902834	80	39	97.2	0	240	1	250	329	WP_277579582.1 NADH:flavin oxidoreductase/NADH oxidase [Bdellovibrio svalbardensis]	diamond	240	91.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis
26704522	26704522	PRJNA756891_P_NODE_11161_length_262_cov_1.629630_g11092_i0	PRJNA756891	11161	262	1.62963	4.2696306	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	91.3	3.42e-19	NR	MCB0368268.1	2053517	g11092	i0	48	0.858778625954199	75	39	85.9	0	229	5	1	75	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	225	91.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27568196	27568196	PRJNA756891_P_NODE_9764_length_279_cov_1.495146_g9695_i0	PRJNA756891	9764	279	1.495146	4.17145734	Pseudomonadati	3379134	Bacteria	Bacteria	77.8	2.66e-14	NR	MBC7659784.1	1971216	g9695	i0	72.3	5.46236559139785	47	13	50.5	0	126	266	624	670	MBC7659784.1 hypothetical protein [Oligoflexus sp.]	diamond	1524	78.2	0.994884910485933	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
28568772	28568772	PRJNA756891_P_NODE_9407_length_284_cov_1.260664_g9338_i0	PRJNA756891	9407	284	1.260664	3.58028576	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.6	1.65e-13	NR	MBX3022063.1	2053517	g9338	i0	54.5	0.813380281690141	77	32	80.3	2	49	276	17	91	MBX3022063.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	231	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28663651	28663651	PRJNA756891_P_NODE_9787_length_279_cov_1.451456_g9718_i0	PRJNA756891	9787	279	1.451456	4.04956224	Bacteriovorax stolpii	960	Bacteria	Bacteria	55.5	1.14e-6	NR	WP_142409330.1	960	g9718	i0	77.1	0.376344086021505	35	8	37.6	0	277	173	198	232	WP_142409330.1 hypothetical protein [Bacteriovorax stolpii]	diamond	105	55.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
28884484	28884484	PRJNA756891_P_NODE_12368_length_251_cov_0.865169_g12299_i0	PRJNA756891	12368	251	0.865169	2.17157419	Bdellovibrio sp. HCB185ZH	3394235	Bacteria	Bacteria	48.9	2.8e-4	NR	WP_413292987.1	3394235	g12299	i0	38.7	1.48207171314741	62	38	74.1	0	4	189	270	331	WP_413292987.1 kelch repeat-containing protein [Bdellovibrio sp. HCB185ZH]	diamond	372	48.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB185ZH
29831789	29831789	PRJNA756891_P_NODE_951_length_820_cov_6.113788_g891_i0	PRJNA756891	951	820	6.1137879999999996	50.1330616	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	61.6	2.32e-7	NR	MBK8201443.1	2053517	g891	i0	25.3	0.665853658536585	182	115	64.4	7	77	604	29	195	MBK8201443.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	546	61.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29895082	29895082	PRJNA756891_P_NODE_13751_length_247_cov_0.885057_g13682_i0	PRJNA756891	13751	247	0.885057	2.18609079	Halobacteriovorax sp.	2020862	Bacteria	Bacteria	57	3.74e-7	NR	MBH46836.1	2020862	g13682	i0	46.8	0.753036437246964	62	32	75.3	1	11	196	59	119	MBH46836.1 hypothetical protein [Halobacteriovorax sp.]	diamond	186	57	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp.
30748072	30748072	PRJNA756891_P_NODE_16094_length_242_cov_0.911243_g16025_i0	PRJNA756891	16094	242	0.911243	2.20520806	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	89.4	4.55e-19	NR	MFA5582894.1	2081706	g16025	i0	65.7	0.830578512396694	67	23	83.1	0	3	203	255	321	MFA5582894.1 glycosyltransferase [Bacteriovoracaceae bacterium]	diamond	201	89.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30874390	30874390	PRJNA756891_P_NODE_4354_length_403_cov_1.166667_g4285_i0	PRJNA756891	4354	403	1.166667	4.70166801	Oligoflexales bacterium	2687297	Bacteria	Bacteria	46.6	0.00856	NR	MBP6219427.1	2687297	g4285	i0	46.9	0.722084367245658	49	26	36.5	0	401	255	340	388	MBP6219427.1 ankyrin repeat domain-containing protein [Oligoflexales bacterium]	diamond	291	46.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
31538453	31538453	PRJNA756891_P_NODE_1196_length_739_cov_3.097598_g1133_i0	PRJNA756891	1196	739	3.097598	22.89124922	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	95.9	6.36e-20	NR	WP_132319276.1	1513793	g1133	i0	33	0.775372124492558	191	113	75.9	7	104	664	27	206	WP_132319276.1 START domain-containing protein [Pseudobacteriovorax antillogorgiicola]	diamond	573	95.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
31696410	31696410	PRJNA756891_P_NODE_6937_length_326_cov_1.521739_g6868_i0	PRJNA756891	6937	326	1.521739	4.96086914	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	168	7.479999999999999e-52	NR	MCB0367912.1	2053517	g6868	i0	85.6	0.892638036809816	97	14	89.3	0	323	33	1	97	MCB0367912.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	291	168	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32392453	32392453	PRJNA756891_P_NODE_10199_length_274_cov_1.139303_g10130_i0	PRJNA756891	10199	274	1.139303	3.12169022	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	53.9	2.96e-6	NR	WP_408095783.1	3383025	g10130	i0	43.1	0.635036496350365	58	33	63.5	0	99	272	4	61	WP_408095783.1 rhomboid family intramembrane serine protease [Peredibacter sp. HCB2-198]	diamond	174	53.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
32582404	32582404	PRJNA756891_P_NODE_7039_length_324_cov_1.227092_g6970_i0	PRJNA756891	7039	324	1.227092	3.97577808	Bacteriovorax sp. MedPE-SWde	1860085	Bacteria	Bacteria	81.3	2.86e-15	NR	OIQ15484.1	1860085	g6970	i0	54.1	0.685185185185185	74	31	68.5	1	314	93	247	317	OIQ15484.1 MAG: hypothetical protein BM556_17755 [Bacteriovorax sp. MedPE-SWde]	diamond	222	81.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. MedPE-SWde

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