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

10 rows where bioproject = "PRJNA635397", 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
9534451	9534451	PRJNA635397_P_NODE_44288_length_245_cov_0.906977_g43834_i0	PRJNA635397	44288	245	0.906977	2.22209365	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	122	2.26e-30	NR	MEK6705537.1	3034175	g43834	i0	70	4.00408163265306	80	24	98	0	1	240	407	486	MEK6705537.1 apolipoprotein N-acyltransferase [Bdellovibrionota bacterium]	diamond	981	122	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
18457798	18457798	PRJNA635397_P_NODE_28895_length_296_cov_1.381166_g28441_i0	PRJNA635397	28895	296	1.381166	4.08825136	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	118	8.09e-31	NR	MBX9767773.1	2053517	g28441	i0	62.1	3.44594594594595	87	33	88.2	0	34	294	1	87	MBX9767773.1 ABC transporter ATP-binding protein [Bdellovibrionales bacterium]	diamond	1020	118	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26700943	26700943	PRJNA635397_P_NODE_39581_length_252_cov_0.871508_g39127_i0	PRJNA635397	39581	252	0.871508	2.19620016	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	76.3	5.88e-14	NR	MEK6556004.1	3034175	g39127	i0	54.8	1	84	27	98.8	3	2	250	56	129	MEK6556004.1 LysM peptidoglycan-binding domain-containing protein [Bdellovibrionota bacterium]	diamond	252	76.3	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27080919	27080919	PRJNA635397_P_NODE_35582_length_265_cov_1.843750_g35128_i0	PRJNA635397	35582	265	1.84375	4.8859375	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	114	2.66e-29	NR	MEK6553756.1	3034175	g35128	i0	78.4	0.837735849056604	74	16	83.8	0	264	43	138	211	MEK6553756.1 MarC family protein [Bdellovibrionota bacterium]	diamond	222	114	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27776098	27776098	PRJNA635397_P_NODE_35884_length_264_cov_1.628272_g35430_i0	PRJNA635397	35884	264	1.628272	4.29863808	Oligoflexales bacterium	2687297	Bacteria	Bacteria	57.4	2.73e-7	NR	MFK7873693.1	2687297	g35430	i0	59.1	2.56818181818182	44	18	50	0	78	209	24	67	MFK7873693.1 inositol oxygenase family protein [Oligoflexales bacterium]	diamond	678	57.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
28186115	28186115	PRJNA635397_P_NODE_40846_length_250_cov_0.875706_g40392_i0	PRJNA635397	40846	250	0.875706	2.189265	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	142	3.04e-41	NR	MBA2406045.1	2053517	g40392	i0	85.5	0.912	76	11	91.2	0	248	21	75	150	MBA2406045.1 DUF4416 family protein [Bdellovibrionales bacterium]	diamond	228	142	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28660100	28660100	PRJNA635397_P_NODE_11987_length_493_cov_3.750000_g11534_i0	PRJNA635397	11987	493	3.75	18.4875	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	265	8.68e-88	NR	MBX9767865.1	2053517	g11534	i0	90.8	0.858012170385396	141	13	85.8	0	2	424	61	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	423	265	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29354723	29354723	PRJNA635397_P_NODE_46749_length_242_cov_0.905325_g46295_i0	PRJNA635397	46749	242	0.905325	2.1908865	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	81.6	2.18e-16	NR	HVK62389.1	2053517	g46295	i0	62.7	0.731404958677686	59	22	73.1	0	7	183	51	109	HVK62389.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	177	81.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29967140	29967140	PRJNA635397_P_NODE_40891_length_250_cov_0.870056_g40437_i0	PRJNA635397	40891	250	0.870056	2.17514	Peredibacter	263370	Bacteria	Bacteria	82	5.48e-17	NR	WP_321397035.1	28202	g40437	i0	79.1	1.548	43	9	51.6	0	131	3	1	43	WP_321397035.1 class I SAM-dependent methyltransferase [Peredibacter starrii]	diamond	387	82.4	0.995145631067961	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
32672985	32672985	PRJNA635397_P_NODE_42040_length_248_cov_0.891429_g41586_i0	PRJNA635397	42040	248	0.891429	2.21074392	Bdellovibrionales bacterium CG1	2053517	Bacteria	Bacteria	114	1.01e-29	NR	PIU00241.1	1973927	g41586	i0	73.9	0.834677419354839	69	18	83.5	0	3	209	131	199	PIU00241.1 MAG: hypothetical protein COT74_04715 [Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34]	diamond	207	114	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34

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