metadata: contig_metadata: 11 rows where bioproject = "PRJNA1087264", tax_phylum = "Bdellovibrionota" and tax

11 rows where bioproject = "PRJNA1087264", 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
4020711	4020711	PRJNA1087264_P_NODE_7844_length_225_cov_1.147727_g7762_i0	PRJNA1087264	7844	225	1.147727	2.58238575	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	116	1.2499999999999998e-29	NR	MCB0369725.1	2053517	g7762	i0	74.3	0.986666666666667	74	19	98.7	0	223	2	11	84	MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	222	116	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27153314	27153314	PRJNA1087264_P_NODE_19462_length_163_cov_0.894737_g19380_i0	PRJNA1087264	19462	163	0.894737	1.45842131	root	1	Root_unresolved	Root_unresolved	83.6	3.78e-17	NR	MBC7742565.1	28201	g19380	i0	72.2	5.96319018404908	54	15	99.4	0	2	163	35	88	MBC7742565.1 acyl-CoA dehydrogenase family protein [Bdellovibrio sp.]	diamond	972	84.3	0.991696322657177	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
27383694	27383694	PRJNA1087264_P_NODE_17943_length_164_cov_0.886957_g17861_i0	PRJNA1087264	17943	164	0.886957	1.45460948	Bdellovibrio sp. HM	28201	Bacteria	Bacteria	52.8	3.08e-6	NR	BFD64822.1	3113894	g17861	i0	42.6	0.98780487804878	54	31	98.8	0	3	164	168	221	BFD64822.1 hypothetical protein BdHM001_35030 [Bdellovibrio sp. HM001]	diamond	162	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
27604800	27604800	PRJNA1087264_P_NODE_5484_length_273_cov_1.357143_g5402_i0	PRJNA1087264	5484	273	1.357143	3.70500039	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	47.4	0.00119	NR	MCB0369454.1	2053517	g5402	i0	30.5	0.901098901098901	82	57	90.1	0	3	248	235	316	MCB0369454.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	246	47.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28267496	28267496	PRJNA1087264_P_NODE_2026_length_473_cov_1.070755_g1946_i0	PRJNA1087264	2026	473	1.070755	5.06467115	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	292	1.42e-98	NR	MBX9767865.1	2053517	g1946	i0	91.1	0.995771670190275	157	14	99.6	0	472	2	23	179	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	471	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30415424	30415424	PRJNA1087264_P_NODE_16013_length_166_cov_0.871795_g15931_i0	PRJNA1087264	16013	166	0.871795	1.4471797	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	100	4.309999999999999e-23	NR	MCO5113018.1	2026715	g15931	i0	85.5	0.993975903614458	55	8	99.4	0	166	2	256	310	MCO5113018.1 DNA primase [Pseudobdellovibrionaceae bacterium]	diamond	165	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31173013	31173013	PRJNA1087264_P_NODE_11155_length_189_cov_1.157143_g11073_i0	PRJNA1087264	11155	189	1.157143	2.18700027	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.1	0.0134	NR	MBS1969444.1	2053517	g11073	i0	40.4	0.904761904761905	57	33	88.9	1	22	189	181	237	MBS1969444.1 choice-of-anchor A family protein [Bdellovibrionales bacterium]	diamond	171	43.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31268251	31268251	PRJNA1087264_P_NODE_17955_length_164_cov_0.886957_g17873_i0	PRJNA1087264	17955	164	0.886957	1.45460948	Oligoflexales bacterium	2687297	Bacteria	Bacteria	55.5	3.82e-7	NR	NRA44356.1	2687297	g17873	i0	50.9	5.90853658536585	53	26	97	0	162	4	90	142	NRA44356.1 carbonic anhydrase family protein [Oligoflexales bacterium]	diamond	969	55.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
31742542	31742542	PRJNA1087264_P_NODE_4297_length_314_cov_1.154717_g4215_i0	PRJNA1087264	4297	314	1.154717	3.62581138	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	172	9.419999999999999e-53	NR	MCB0370127.1	2053517	g4215	i0	84.2	0.964968152866242	101	16	96.5	0	11	313	30	130	MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium]	diamond	303	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31987025	31987025	PRJNA1087264_P_NODE_12858_length_176_cov_1.204724_g12776_i0	PRJNA1087264	12858	176	1.204724	2.12031424	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	2.81e-5	NR	PZO87517.1	349221	g12776	i0	39.7	2.96590909090909	58	33	98.9	1	175	2	246	301	PZO87517.1 MAG: hydroxyacid dehydrogenase [Micavibrio aeruginosavorus]	diamond	522	50.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32785552	32785552	PRJNA1087264_P_NODE_11500_length_186_cov_1.408759_g11418_i0	PRJNA1087264	11500	186	1.408759	2.62029174	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	82	5.02e-18	NR	MCB0368309.1	2053517	g11418	i0	72.6	1	62	17	100	0	186	1	44	105	MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	186	82	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);;