metadata: contig_metadata: 9 rows where bioproject = "PRJNA772154", tax_phylum = "Bdellovibrionota" and tax

9 rows where bioproject = "PRJNA772154", 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
747379	747379	PRJNA772154_P_NODE_19301_length_249_cov_1.227273_g19116_i0	PRJNA772154	19301	249	1.227273	3.05590977	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	333	7.189999999999999e-87	NTclustered	gi\|2893356071\|emb\|OZ220494.1\|	2053517	g19116	i0	90.837	198.939759036145	251	20	99	3	2	249	964520	964770	MAG: Bdellovibrionales bacterium isolate 95f108ca-4012-4f55-a596-77f5f94b2342 genome assembly, chromosome: 1	blastn	49536	333	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
10135400	10135400	PRJNA772154_P_NODE_20368_length_247_cov_0.896552_g20183_i0	PRJNA772154	20368	247	0.896552	2.21448344	Bdellovibrio	958	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g20183	i0	80.816	8.67206477732794	245	47	99	0	1	245	835969	836213	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	2142	193	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27464247	27464247	PRJNA772154_P_NODE_17703_length_253_cov_0.866667_g17518_i0	PRJNA772154	17703	253	0.866667	2.19266751	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	42.4	0.0108	NR	MCC2678057.1	2862747	g17518	i0	52.2	0.545454545454545	46	22	54.5	0	253	116	41	86	MCC2678057.1 hypothetical protein [Pseudobdellovibrio sp.]	diamond	138	42.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
28221701	28221701	PRJNA772154_P_NODE_21506_length_245_cov_0.906977_g21321_i0	PRJNA772154	21506	245	0.906977	2.22209365	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	110	7.55e-26	NR	MBL7716941.1	2053517	g21321	i0	58.8	0.979591836734694	80	33	98	0	240	1	646	725	MBL7716941.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	240	110	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28443051	28443051	PRJNA772154_P_NODE_18526_length_251_cov_0.876404_g18341_i0	PRJNA772154	18526	251	0.876404	2.19977404	Micavibrio sp.	2024841	Bacteria	Bacteria	48.9	1.12e-4	NR	MAE51675.1	2024841	g18341	i0	35.7	1.00398406374502	84	48	93.2	1	16	249	8	91	MAE51675.1 hypothetical protein [Micavibrio sp.]	diamond	252	48.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
28443052	28443052	PRJNA772154_P_NODE_19066_length_250_cov_0.881356_g18881_i0	PRJNA772154	19066	250	0.881356	2.20339	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	158	2.13e-43	NR	MCH2534402.1	2053517	g18881	i0	97.6	0.996	83	2	99.6	0	250	2	369	451	MCH2534402.1 chloride channel protein [Bdellovibrionales bacterium]	diamond	249	158	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28957849	28957849	PRJNA772154_P_NODE_22408_length_243_cov_0.917647_g22223_i0	PRJNA772154	22408	243	0.917647	2.22988221	Bdellovibrio	958	Bacteria	Bacteria	143	1.67e-38	NR	WP_374031657.1	959	g22223	i0	80	11.7654320987654	80	16	98.8	0	241	2	371	450	WP_374031657.1 metallophosphoesterase [Bdellovibrio bacteriovorus]	diamond	2859	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
29200847	29200847	PRJNA772154_P_NODE_18689_length_251_cov_0.876404_g18504_i0	PRJNA772154	18689	251	0.876404	2.19977404	Bdellovibrio sp. KM	28201	Bacteria	Bacteria	79.7	6.63e-17	NR	WP_181605507.1	2748865	g18504	i0	62.7	1.42231075697211	59	22	70.5	0	3	179	67	125	WP_181605507.1 hypothetical protein [Bdellovibrio sp. KM01]	diamond	357	79.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
32802945	32802945	PRJNA772154_P_NODE_21360_length_245_cov_0.906977_g21175_i0	PRJNA772154	21360	245	0.906977	2.22209365	Bdellovibrionales bacterium GWB1_55_8	1797386	Bacteria	Bacteria	42.7	0.0392	NR	OFZ22225.1	1797386	g21175	i0	43.9	0.502040816326531	41	23	50.2	0	130	8	536	576	OFZ22225.1 MAG: hypothetical protein A2X94_01845 [Bdellovibrionales bacterium GWB1_55_8]	diamond	123	42.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWB1_55_8

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