metadata: contig_metadata: 8 rows where bioproject = "PRJNA857143", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA857143", tax_kingdom = "Pseudomonadati" 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
10163822	10163822	PRJNA857143_S_NODE_145208_length_270_cov_1.984772_g144115_i0	PRJNA857143	145208	270	1.984772	5.3588844	Bdellovibrio sp. KM	28201	Bacteria	Bacteria	151	8.939999999999999e-45	NR	WP_181606074.1	2748865	g144115	i0	78.2	4.82222222222222	87	19	96.7	0	262	2	19	105	WP_181606074.1 glutathione peroxidase [Bdellovibrio sp. KM01]	diamond	1302	151	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
17812745	17812745	PRJNA857143_S_NODE_129894_length_283_cov_1.857143_g128801_i0	PRJNA857143	129894	283	1.857143	5.25571469	Bacteriovorax	146784	Bacteria	Bacteria	468	2.19e-127	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g128801	i0	96.466	309.360424028269	283	10	100	0	1	283	1661300	1661018	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	87549	468	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
22520961	22520961	PRJNA857143_S_NODE_60658_length_372_cov_2.244147_g59565_i0	PRJNA857143	60658	372	2.244147	8.34822684	Bdellovibrionota	3018035	Bacteria	Bacteria	126	6.699999999999999e-32	NR	PIP95421.1	1975529	g59565	i0	72.9	2.78225806451613	85	23	68.5	0	372	118	321	405	PIP95421.1 MAG: isocitrate dehydrogenase (NADP(+)) [Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27]	diamond	1035	127	0.992125984251969	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27
26897035	26897035	PRJNA857143_S_NODE_49581_length_397_cov_2.003086_g48488_i0	PRJNA857143	49581	397	2.003086	7.95225142	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	70.9	2.81e-11	NR	PZO79293.1	349221	g48488	i0	44.2	0.717884130982368	95	42	70.3	4	329	51	351	436	PZO79293.1 MAG: hypothetical protein DI626_11630 [Micavibrio aeruginosavorus]	diamond	285	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
28981621	28981621	PRJNA857143_S_NODE_100408_length_313_cov_0.954167_g99315_i0	PRJNA857143	100408	313	0.954167	2.98654271	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	95.9	1.95e-20	NR	MBS1969835.1	2053517	g99315	i0	91.3	0.440894568690096	46	4	44.1	0	313	176	1429	1474	MBS1969835.1 endonuclease/exonuclease/phosphatase family protein [Bdellovibrionales bacterium]	diamond	138	95.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29518099	29518099	PRJNA857143_S_NODE_159270_length_259_cov_4.575269_g158177_i0	PRJNA857143	159270	259	4.575269	11.84994671	Bdellovibrio sp. 28-41-41	1970323	Bacteria	Bacteria	158	3.2e-47	NR	OYZ21784.1	1970323	g158177	i0	84.9	0.996138996138996	86	13	99.6	0	1	258	71	156	OYZ21784.1 MAG: hypothetical protein B7Y39_08430 [Bdellovibrio sp. 28-41-41]	diamond	258	158	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
31698561	31698561	PRJNA857143_S_NODE_138077_length_276_cov_1.541872_g136984_i0	PRJNA857143	138077	276	1.541872	4.25556672	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	75.5	1.71e-13	NR	MBS1969835.1	2053517	g136984	i0	54.4	0.739130434782609	68	31	73.9	0	3	206	1400	1467	MBS1969835.1 endonuclease/exonuclease/phosphatase family protein [Bdellovibrionales bacterium]	diamond	204	75.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32836177	32836177	PRJNA857143_S_NODE_76900_length_343_cov_2.311111_g75807_i0	PRJNA857143	76900	343	2.311111	7.92711073	Micavibrio sp.	2024841	Bacteria	Bacteria	48.9	7.58e-4	NR	HEU4839277.1	2024841	g75807	i0	44.9	0.428571428571429	49	25	42.9	1	1	147	244	290	HEU4839277.1 thrombospondin type-1 domain-containing protein [Micavibrio sp.]	diamond	147	48.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.

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