metadata: contig_metadata: 11 rows where bioproject = "PRJNA864829", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA864829", 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
1236873	1236873	PRJNA864829_S_NODE_5781_length_250_cov_1.587065_g5695_i0	PRJNA864829	5781	250	1.587065	3.9676625	Pseudobdellovibrio	2862745	Bacteria	Bacteria	412	9.02e-111	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g5695	i0	99.558	85.168	226	1	90	0	25	250	1646	1871	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	21292	412	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
5950584	5950584	PRJNA864829_S_NODE_3425_length_302_cov_3.011858_g3339_i0	PRJNA864829	3425	302	3.011858	9.09581116	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	261	4.29e-65	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g3339	i0	82.392	292.367549668874	301	52	99	1	2	302	468921	468622	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	88295	261	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
9775282	9775282	PRJNA864829_S_NODE_10168_length_198_cov_1.664430_g10082_i0	PRJNA864829	10168	198	1.66443	3.2955714	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	154	4.5700000000000005e-33	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g10082	i0	83.951	175.979797979798	162	24	81	2	17	177	465446	465286	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	34844	154	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
14875277	14875277	PRJNA864829_S_NODE_1372_length_424_cov_3.090667_g1286_i0	PRJNA864829	1372	424	3.090667	13.10442808	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	172	3.01e-38	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g1286	i0	75.385	89.0471698113208	390	79	90	13	45	424	665608	665990	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	37756	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
17425439	17425439	PRJNA864829_S_NODE_12834_length_179_cov_1.238462_g12748_i0	PRJNA864829	12834	179	1.238462	2.21684698	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	86.1	1.5e-12	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g12748	i0	100	1.79329608938547	46	0	26	0	26	71	469849	469804	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	321	86.1	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27181375	27181375	PRJNA864829_S_NODE_5822_length_249_cov_3.395000_g5736_i0	PRJNA864829	5822	249	3.395	8.45355	Bdellovibrionales bacterium GWB1_55_8	1797386	Bacteria	Bacteria	140	7.47e-41	NR	OFZ21052.1	1797386	g5736	i0	85.4	2.96385542168675	82	12	98.8	0	247	2	40	121	OFZ21052.1 MAG: flagellar basal body rod protein FlgC [Bdellovibrionales bacterium GWB1_55_8]	diamond	738	140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWB1_55_8
27718955	27718955	PRJNA864829_S_NODE_9564_length_203_cov_1.727273_g9478_i0	PRJNA864829	9564	203	1.727273	3.50636419	Oligoflexia bacterium	2599941	Bacteria	Bacteria	63.9	7.04e-10	NR	MCM2324033.1	2599941	g9478	i0	78.6	0.620689655172414	42	8	62.1	1	126	1	9	49	MCM2324033.1 phosphoglycerate kinase [Oligoflexia bacterium]	diamond	126	63.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
27907675	27907675	PRJNA864829_S_NODE_4865_length_267_cov_2.371560_g4779_i0	PRJNA864829	4865	267	2.37156	6.3320652	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	117	1.67e-29	NR	MES2964497.1	3034175	g4779	i0	58.4	1	89	37	100	0	1	267	188	276	MES2964497.1 c-type cytochrome [Bdellovibrionota bacterium]	diamond	267	117	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28349966	28349966	PRJNA864829_S_NODE_4366_length_278_cov_1.410480_g4280_i0	PRJNA864829	4366	278	1.41048	3.9211344	Bdellovibrionales bacterium RIFOXYC1_FULL_54_43	1797397	Bacteria	Bacteria	69.7	7.27e-12	NR	OFZ53503.1	1797397	g4280	i0	39.8	1.05755395683453	98	48	98.2	2	276	4	136	229	OFZ53503.1 MAG: hypothetical protein A2428_14120 [Bdellovibrionales bacterium RIFOXYC1_FULL_54_43]	diamond	294	69.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYC1_FULL_54_43
29738974	29738974	PRJNA864829_S_NODE_2150_length_357_cov_1.616883_g2064_i0	PRJNA864829	2150	357	1.616883	5.77227231	Oligoflexia bacterium	2599941	Bacteria	Bacteria	177	2.91e-52	NR	MDR3606861.1	2599941	g2064	i0	78	1.98319327731092	118	25	99.2	1	2	355	146	262	MDR3606861.1 6-phosphofructokinase [Oligoflexia bacterium]	diamond	708	177	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32363244	32363244	PRJNA864829_S_NODE_13279_length_176_cov_1.677165_g13193_i0	PRJNA864829	13279	176	1.677165	2.9518104	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	101	7.16e-24	NR	MCB0405581.1	2053517	g13193	i0	80.7	0.971590909090909	57	11	97.2	0	2	172	94	150	MCB0405581.1 ABC transporter permease subunit [Bdellovibrionales bacterium]	diamond	171	101	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);;