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

11 rows where bioproject = "PRJNA1046144", 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
5275122	5275122	PRJNA1046144_P_NODE_39925_length_271_cov_3.579208_g39630_i0	PRJNA1046144	39925	271	3.579208	9.69965368	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	196	1.08e-45	NTclustered	gi\|2907625691\|emb\|OZ223251.1\|	2081706	g39630	i0	82.96	23.7859778597786	223	32	81	5	41	260	90929	90710	MAG: Bacteriovoracaceae bacterium isolate 56684ba0-df17-47c9-bcf5-ee076427a4fa genome assembly, chromosome: 1	blastn	6446	196	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
7824865	7824865	PRJNA1046144_P_NODE_37527_length_279_cov_1.371429_g37232_i0	PRJNA1046144	37527	279	1.371429	3.82628691	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	230	1.1099999999999995e-55	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g37232	i0	81.915	55.3799283154122	282	42	99	5	2	279	665905	665629	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	15451	230	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
23124546	23124546	PRJNA1046144_P_NODE_38339_length_276_cov_2.062802_g38044_i0	PRJNA1046144	38339	276	2.062802	5.69333352	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	196	1.11e-45	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g38044	i0	80.989	80.9057971014493	263	37	93	12	21	276	3251502	3251758	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	22330	196	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27572349	27572349	PRJNA1046144_P_NODE_65564_length_229_cov_0.900000_g65269_i0	PRJNA1046144	65564	229	0.9	2.061	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	95.9	2.45e-21	NR	MFA5584750.1	2081706	g65269	i0	67.2	2.63318777292576	67	21	87.8	1	201	1	1	66	MFA5584750.1 ABC transporter transmembrane domain-containing protein [Bacteriovoracaceae bacterium]	diamond	603	95.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
28140963	28140963	PRJNA1046144_P_NODE_57245_length_234_cov_1.636364_g56950_i0	PRJNA1046144	57245	234	1.636364	3.82909176	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	78.2	1.07e-14	NR	MES2857009.1	3034175	g56950	i0	54.1	1.85897435897436	74	34	94.9	0	224	3	1	74	MES2857009.1 M3 family metallopeptidase [Bdellovibrionota bacterium]	diamond	435	78.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29214484	29214484	PRJNA1046144_P_NODE_56909_length_235_cov_0.867470_g56614_i0	PRJNA1046144	56909	235	0.86747	2.0385545	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	70.1	6.76e-12	NR	WP_011165300.1	959	g56614	i0	60.4	2.13191489361702	53	21	67.7	0	28	186	319	371	WP_011165300.1 AGE family epimerase/isomerase [Bdellovibrio bacteriovorus]	diamond	501	70.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
29308867	29308867	PRJNA1046144_P_NODE_68629_length_227_cov_0.911392_g68334_i0	PRJNA1046144	68629	227	0.911392	2.06885984	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	101	8.04e-25	NR	MEK7356618.1	3034175	g68334	i0	62.7	0.991189427312775	75	28	99.1	0	227	3	97	171	MEK7356618.1 BamA/TamA family outer membrane protein [Bdellovibrionota bacterium]	diamond	225	101	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30003776	30003776	PRJNA1046144_P_NODE_70791_length_220_cov_2.834437_g70496_i0	PRJNA1046144	70791	220	2.834437	6.2357614	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	121	4.86e-30	NR	HEY8278246.1	3034175	g70496	i0	86.3	0.995454545454545	73	10	99.5	0	219	1	308	380	HEY8278246.1 methionine synthase [Bdellovibrionota bacterium]	diamond	219	121	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30983295	30983295	PRJNA1046144_P_NODE_61374_length_231_cov_1.777778_g61079_i0	PRJNA1046144	61374	231	1.777778	4.10666718	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	108	2.01e-26	NR	MCM2280836.1	2026715	g61079	i0	67.1	1.97402597402597	76	25	98.7	0	3	230	160	235	MCM2280836.1 esterase family protein [Pseudobdellovibrionaceae bacterium]	diamond	456	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31931674	31931674	PRJNA1046144_P_NODE_55817_length_235_cov_1.656627_g55522_i0	PRJNA1046144	55817	235	1.656627	3.89307345	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	88.2	9.14e-20	NR	MCB0407745.1	2053517	g55522	i0	61.3	0.791489361702128	62	24	79.1	0	6	191	109	170	MCB0407745.1 Hsp20/alpha crystallin family protein [Bdellovibrionales bacterium]	diamond	186	88.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32438294	32438294	PRJNA1046144_P_NODE_70059_length_226_cov_0.917197_g69764_i0	PRJNA1046144	70059	226	0.917197	2.07286522	Peredibacter starrii	28202	Bacteria	Bacteria	56.6	3.65e-7	NR	WP_321399652.1	28202	g69764	i0	44.1	0.902654867256637	68	38	90.3	0	205	2	182	249	WP_321399652.1 cation:proton antiporter [Peredibacter starrii]	diamond	204	56.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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