metadata: contig_metadata: 15 rows where bioproject = "PRJNA976345" and tax

15 rows where bioproject = "PRJNA976345" 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
7645277	7645277	PRJNA976345_P_NODE_23846_length_344_cov_2.721683_g22245_i0	PRJNA976345	23846	344	2.721683	9.36258952	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	207	2.06e-66	NR	MCB0369646.1	2053517	g22245	i0	87.7	0.994186046511628	114	14	99.4	0	342	1	54	167	MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium]	diamond	342	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
9876129	9876129	PRJNA976345_P_NODE_159248_length_162_cov_3.763780_g157640_i0	PRJNA976345	159248	162	3.76378	6.0973236	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	58.4	2.9e-4	NTclustered	gi\|2626289182\|emb\|OY843585.1\|	2053517	g157640	i0	97.143	0.561728395061728	35	0	21	1	89	122	855366	855332	MAG: Bdellovibrionales bacterium isolate 022bb5af-5c53-4953-82b0-2ef8059d9f16 genome assembly, chromosome: 1	blastn	91	58.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26645916	26645916	PRJNA976345_P_NODE_118341_length_179_cov_1.111111_g116733_i0	PRJNA976345	118341	179	1.111111	1.98888869	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	90.1	2.92e-22	NR	MCB0369463.1	2053517	g116733	i0	98	0.854748603351955	51	1	85.5	0	3	155	6	56	MCB0369463.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	153	90.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26836371	26836371	PRJNA976345_P_NODE_73261_length_213_cov_1.207865_g71653_i0	PRJNA976345	73261	213	1.207865	2.57275245	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	42.7	0.00484	NR	MCB9063107.1	2026745	g71653	i0	38	0.704225352112676	50	31	70.4	0	211	62	38	87	MCB9063107.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	150	42.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
26868089	26868089	PRJNA976345_P_NODE_97781_length_191_cov_2.448718_g96173_i0	PRJNA976345	97781	191	2.448718	4.67705138	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	45.4	0.00204	NR	MFP5387489.1	3058048	g96173	i0	50	2.15183246073298	44	18	69.1	1	179	48	72	111	MFP5387489.1 GNAT family N-acetyltransferase/peptidase C39 family protein [Bacteriovoracia bacterium]	diamond	411	45.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
27279031	27279031	PRJNA976345_P_NODE_60743_length_228_cov_2.647668_g59135_i0	PRJNA976345	60743	228	2.647668	6.03668304	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	101	7.7e-26	NR	MCB0368210.1	2053517	g59135	i0	62.5	0.947368421052632	72	26	93.4	1	15	227	32	103	MCB0368210.1 LITAF-like zinc ribbon domain-containing protein [Bdellovibrionales bacterium]	diamond	216	101	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27531557	27531557	PRJNA976345_P_NODE_117243_length_179_cov_2.194444_g115635_i0	PRJNA976345	117243	179	2.194444	3.92805476	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	54.3	4.01e-8	NR	MCB0369377.1	2053517	g115635	i0	59.2	0.82122905027933	49	20	82.1	0	31	177	2	50	MCB0369377.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	147	54.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27531600	27531600	PRJNA976345_P_NODE_40883_length_269_cov_2.611111_g39275_i0	PRJNA976345	40883	269	2.611111	7.02388859	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	113	9.92e-31	NR	MCB0369232.1	2053517	g39275	i0	68	0.836431226765799	75	21	80.3	1	269	54	4	78	MCB0369232.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	225	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28447458	28447458	PRJNA976345_P_NODE_60026_length_229_cov_2.876289_g58418_i0	PRJNA976345	60026	229	2.876289	6.58670181	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	45.8	0.00197	NR	MCO4755062.1	2081706	g58418	i0	68	0.327510917030568	25	8	32.8	0	123	49	79	103	MCO4755062.1 acireductone synthase [Bacteriovoracaceae bacterium]	diamond	75	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30152204	30152204	PRJNA976345_P_NODE_66972_length_220_cov_1.902703_g65364_i0	PRJNA976345	66972	220	1.902703	4.1859466	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	54.7	1.65e-6	NR	MCB0386755.1	2053517	g65364	i0	41	1.06363636363636	78	31	94.1	5	4	210	299	370	MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium]	diamond	234	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30657932	30657932	PRJNA976345_P_NODE_142553_length_169_cov_2.925373_g140945_i0	PRJNA976345	142553	169	2.925373	4.94388037	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	68.9	3.33e-13	NR	MCB0368029.1	2053517	g140945	i0	79.5	0.692307692307692	39	8	69.2	0	51	167	59	97	MCB0368029.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	117	68.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30847576	30847576	PRJNA976345_P_NODE_82814_length_203_cov_2.142857_g81206_i0	PRJNA976345	82814	203	2.142857	4.34999971	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	95.5	4.6e-21	NR	MCB0368268.1	2053517	g81206	i0	70	0.886699507389163	60	18	88.7	0	1	180	413	472	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	180	95.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31890932	31890932	PRJNA976345_P_NODE_31157_length_303_cov_2.044776_g29551_i0	PRJNA976345	31157	303	2.044776	6.19567128	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	148	1.83e-43	NR	MCB0368309.1	2053517	g29551	i0	77.8	0.98019801980198	99	22	98	0	2	298	44	142	MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	297	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32207374	32207374	PRJNA976345_P_NODE_132598_length_174_cov_1.812950_g130990_i0	PRJNA976345	132598	174	1.81295	3.154533	Bdellovibrio sp.	28201	Bacteria	Bacteria	93.2	2.02e-20	NR	MBC7743147.1	28201	g130990	i0	70.2	2.94827586206897	57	17	98.3	0	3	173	402	458	MBC7743147.1 homospermidine synthase [Bdellovibrio sp.]	diamond	513	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32492328	32492328	PRJNA976345_P_NODE_34899_length_288_cov_2.845850_g33292_i0	PRJNA976345	34899	288	2.84585	8.196048	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	151	7.44e-45	NR	MCB0369869.1	2053517	g33292	i0	85.9	0.885416666666667	85	12	88.5	0	287	33	63	147	MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium]	diamond	255	151	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;