metadata: contig_metadata: 10 rows where bioproject = "PRJNA407087", tax_phylum = "Bdellovibrionota" and tax

10 rows where bioproject = "PRJNA407087", 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
15109410	15109410	PRJNA407087_S_NODE_7812_length_173_cov_3.555556_g7349_i0	PRJNA407087	7812	173	3.555556	6.15111188	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	75.5	3.97e-14	NR	MES2803345.1	3034175	g7349	i0	64.3	8.70520231213873	56	20	97.1	0	169	2	123	178	MES2803345.1 DEAD/DEAH box helicase [Bdellovibrionota bacterium]	diamond	1506	75.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27945038	27945038	PRJNA407087_S_NODE_9845_length_151_cov_5.598361_g9382_i0	PRJNA407087	9845	151	5.598361	8.45352511	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	1.27e-13	NR	OFZ28416.1	1797389	g9382	i0	74	10.9271523178808	50	13	99.3	0	1	150	311	360	OFZ28416.1 MAG: cystathionine gamma-synthase [Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29]	diamond	1650	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29
28039754	28039754	PRJNA407087_S_NODE_3665_length_298_cov_5.739777_g3202_i0	PRJNA407087	3665	298	5.739777	17.10453546	Pseudomonadati	3379134	Bacteria	Bacteria	110	3.91e-26	NR	WP_015467316.1	349221	g3202	i0	56.6	12.9161073825503	99	43	99.7	0	297	1	32	130	WP_015467316.1 acyl-CoA dehydrogenase [Micavibrio aeruginosavorus]	diamond	3849	111	0.990990990990991	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
28243835	28243835	PRJNA407087_S_NODE_8126_length_169_cov_2.507143_g7663_i0	PRJNA407087	8126	169	2.507143	4.23707167	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	45.1	0.00209	NR	HAZ14553.1	2053517	g7663	i0	63.4	5.59171597633136	41	14	72.8	1	123	1	30	69	HAZ14553.1 short chain dehydrogenase [Bdellovibrionales bacterium]	diamond	945	45.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28686302	28686302	PRJNA407087_S_NODE_8527_length_164_cov_2.903704_g8064_i0	PRJNA407087	8527	164	2.903704	4.76207456	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	45.8	0.00104	NR	MBX9766461.1	2053517	g8064	i0	50	0.878048780487805	48	20	87.8	2	2	145	421	464	MBX9766461.1 aldehyde dehydrogenase family protein [Bdellovibrionales bacterium]	diamond	144	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28938757	28938757	PRJNA407087_S_NODE_9188_length_157_cov_5.062500_g8725_i0	PRJNA407087	9188	157	5.0625	7.948125	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	72	7.64e-14	NR	MCB0369154.1	2053517	g8725	i0	71.7	1.01273885350318	53	13	99.4	2	1	156	67	118	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	159	72	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29317488	29317488	PRJNA407087_S_NODE_8429_length_165_cov_2.757353_g7966_i0	PRJNA407087	8429	165	2.757353	4.54963245	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	103	3.4299999999999995e-24	NR	MCB0371130.1	2053517	g7966	i0	85.5	1	55	8	100	0	165	1	259	313	MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium]	diamond	165	103	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31134469	31134469	PRJNA407087_S_NODE_1395_length_587_cov_6.107527_g993_i0	PRJNA407087	1395	587	6.107527	35.85118349	Bdellovibrio	958	Bacteria	Bacteria	239	1.32e-76	NR	MBO9668790.1	28201	g993	i0	63.4	10.2163543441227	183	67	93.5	0	2	550	51	233	MBO9668790.1 PLP-dependent transferase [Bdellovibrio sp.]	diamond	5997	240	0.995833333333333	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
31149265	31149265	PRJNA407087_S_NODE_9695_length_153_cov_2.120968_g9232_i0	PRJNA407087	9695	153	2.120968	3.24508104	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	78.2	3.15e-15	NR	MCB0371130.1	2053517	g9232	i0	66	6.86274509803922	50	17	98	0	151	2	90	139	MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium]	diamond	1050	78.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32066862	32066862	PRJNA407087_S_NODE_6538_length_195_cov_1.885542_g6075_i0	PRJNA407087	6538	195	1.885542	3.6768069	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	103	5.84e-25	NR	MCB0370750.1	2053517	g6075	i0	80.6	1.03076923076923	67	11	100	1	195	1	141	207	MCB0370750.1 inositol-3-phosphate synthase [Bdellovibrionales bacterium]	diamond	201	103	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);;