metadata: contig_metadata: 16 rows where bioproject = "PRJNA1136505", tax_phylum = "Bdellovibrionota" and tax

16 rows where bioproject = "PRJNA1136505", tax_phylum = "Bdellovibrionota" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
284445	284445	PRJNA1136505_P_NODE_114061_length_270_cov_1.406091_g107201_i0	PRJNA1136505	114061	270	1.406091	3.7964457	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	112	1.7600000000000002e-26	NR	HEY8280078.1	3034175	g107201	i0	81.2	0.766666666666667	69	13	76.7	0	208	2	1	69	HEY8280078.1 response regulator [Bdellovibrionota bacterium]	diamond	207	112	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
11763086	11763086	PRJNA1136505_P_NODE_120650_length_262_cov_1.444444_g113790_i0	PRJNA1136505	120650	262	1.444444	3.78444328	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	440	4.369999999999998e-119	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g113790	i0	96.947	37.4007633587786	262	8	100	0	1	262	700473	700212	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	9799	440	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
13038187	13038187	PRJNA1136505_P_NODE_133611_length_250_cov_0.870056_g126751_i0	PRJNA1136505	133611	250	0.870056	2.17514	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	154	2.45e-43	NR	HEY8278660.1	3034175	g126751	i0	91.6	0.996	83	7	99.6	0	1	249	58	140	HEY8278660.1 cell division protein FtsA [Bdellovibrionota bacterium]	diamond	249	154	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
16861574	16861574	PRJNA1136505_P_NODE_113414_length_271_cov_1.186869_g106554_i0	PRJNA1136505	113414	271	1.186869	3.21641499	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	178	9.61e-53	NR	HEY8280086.1	3034175	g106554	i0	91.1	1.99261992619926	90	8	99.6	0	1	270	75	164	HEY8280086.1 tyrosine--tRNA ligase [Bdellovibrionota bacterium]	diamond	540	178	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
19410452	19410452	PRJNA1136505_P_NODE_88456_length_308_cov_2.225532_g81596_i0	PRJNA1136505	88456	308	2.225532	6.85463856	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	558	1.39e-154	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g81596	i0	99.351	106.597402597403	308	2	100	0	1	308	700739	700432	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	32832	558	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
23236805	23236805	PRJNA1136505_P_NODE_147719_length_244_cov_0.900585_g140859_i0	PRJNA1136505	147719	244	0.900585	2.1974274	Bdellovibrio bacteriovorus W	765869	Bacteria	Bacteria	134	2.8799999999999997e-35	NR	AHI04961.1	765869	g140859	i0	80	1.9672131147541	80	16	98.4	0	240	1	145	224	AHI04961.1 tetracycline-efflux transporter [Bdellovibrio bacteriovorus W]	diamond	480	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26690494	26690494	PRJNA1136505_P_NODE_144581_length_245_cov_0.895349_g137721_i0	PRJNA1136505	144581	245	0.895349	2.19360505	Halobacteriovorax sp.	2020862	Bacteria	Bacteria	83.6	1.61e-16	NR	MBK25175.1	2020862	g137721	i0	51.9	3.93061224489796	81	37	99.2	1	1	243	474	552	MBK25175.1 hypothetical protein [Halobacteriovorax sp.]	diamond	963	83.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp.
26943704	26943704	PRJNA1136505_P_NODE_137442_length_248_cov_0.880000_g130582_i0	PRJNA1136505	137442	248	0.88	2.1824	Oligoflexia bacterium	2599941	Bacteria	Bacteria	53.9	2.45e-6	NR	MBF0314245.1	2599941	g130582	i0	36.4	1.65725806451613	77	48	91.9	1	2	229	125	201	MBF0314245.1 YceI family protein [Oligoflexia bacterium]	diamond	411	53.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
28806989	28806989	PRJNA1136505_P_NODE_146588_length_244_cov_1.391813_g139728_i0	PRJNA1136505	146588	244	1.391813	3.39602372	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	107	4.8e-25	NR	HEY8279876.1	3034175	g139728	i0	60.8	0.971311475409836	79	31	97.1	0	6	242	1828	1906	HEY8279876.1 PD-(D/E)XK nuclease family protein [Bdellovibrionota bacterium]	diamond	237	107	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28922480	28922480	PRJNA1136505_P_NODE_58788_length_394_cov_2.439252_g51928_i0	PRJNA1136505	58788	394	2.439252	9.61065288	Pseudomonadati	3379134	Bacteria	Bacteria	95.5	1.67e-20	NR	WP_102242841.1	960	g51928	i0	44.3	7.19543147208122	106	58	80.7	1	323	6	4	108	WP_102242841.1 fatty acid desaturase [Bacteriovorax stolpii]	diamond	2835	96.3	0.991692627206646	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
30355239	30355239	PRJNA1136505_P_NODE_131892_length_250_cov_1.706215_g125032_i0	PRJNA1136505	131892	250	1.706215	4.2655375	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	47	0.00125	NR	HEY8278818.1	3034175	g125032	i0	54	0.6	50	23	60	0	150	1	274	323	HEY8278818.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	150	47	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31144160	31144160	PRJNA1136505_P_NODE_122095_length_260_cov_1.647059_g115235_i0	PRJNA1136505	122095	260	1.647059	4.2823534	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	126	2.89e-34	NR	HEY8279498.1	3034175	g115235	i0	70.6	0.980769230769231	85	25	98.1	0	5	259	17	101	HEY8279498.1 M15 family metallopeptidase [Bdellovibrionota bacterium]	diamond	255	126	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31713871	31713871	PRJNA1136505_P_NODE_153277_length_242_cov_0.911243_g146417_i0	PRJNA1136505	153277	242	0.911243	2.20520806	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	129	1.11e-32	NR	WP_409478962.1	3386277	g146417	i0	91.5	0.880165289256198	71	6	88	0	28	240	498	568	WP_409478962.1 PrkA family serine protein kinase [Pseudobdellovibrio sp. HCB154]	diamond	213	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
31808777	31808777	PRJNA1136505_P_NODE_98977_length_290_cov_0.995392_g92117_i0	PRJNA1136505	98977	290	0.995392	2.8866368	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	186	3.3799999999999996e-56	NR	HEY8278275.1	3034175	g92117	i0	86.5	0.993103448275862	96	13	99.3	0	290	3	82	177	HEY8278275.1 nucleotidyltransferase [Bdellovibrionota bacterium]	diamond	288	186	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32082490	32082490	PRJNA1136505_P_NODE_100538_length_287_cov_2.378505_g93678_i0	PRJNA1136505	100538	287	2.378505	6.82630935	Pseudomonadati	3379134	Bacteria	Bacteria	106	6.07e-25	NR	WP_325144466.1	1971216	g93678	i0	50.5	8.59233449477352	95	47	99.3	0	287	3	231	325	WP_325144466.1 alkane 1-monooxygenase [Oligoflexus sp.]	diamond	2466	107	0.990654205607477	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
32441859	32441859	PRJNA1136505_P_NODE_122999_length_259_cov_1.569892_g116139_i0	PRJNA1136505	122999	259	1.569892	4.06602028	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	87.8	4.26e-18	NR	MFT6068097.1	2081706	g116139	i0	66.7	0.694980694980695	60	20	69.5	0	243	64	344	403	MFT6068097.1 cobalt-zinc-cadmium efflux system outer membrane protein [Bacteriovoracaceae bacterium]	diamond	180	87.8	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);;