metadata: contig_metadata: 7 rows where bioproject = "PRJNA376117", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA376117", 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
13153527	13153527	PRJNA376117_P_NODE_21251_length_300_cov_0.951542_g20949_i0	PRJNA376117	21251	300	0.951542	2.854626	Peredibacter starrii	28202	Bacteria	Bacteria	538	1.76e-148	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g20949	i0	99.003	69.5966666666667	301	2	100	1	1	300	511910	512210	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	20879	538	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19525715	19525715	PRJNA376117_P_NODE_26996_length_276_cov_1.221675_g26694_i0	PRJNA376117	26996	276	1.221675	3.371823	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	431	2.79e-116	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g26694	i0	94.928	17.536231884058	276	13	100	1	1	276	1501803	1502077	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	4840	431	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26916700	26916700	PRJNA376117_P_NODE_44922_length_236_cov_2.503067_g44620_i0	PRJNA376117	44922	236	2.503067	5.90723812	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	167	3.2599999999999998e-52	NR	MCK6599889.1	2026715	g44620	i0	98.7	1.95762711864407	77	1	97.9	0	2	232	14	90	MCK6599889.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	462	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28748620	28748620	PRJNA376117_P_NODE_28587_length_270_cov_1.497462_g28285_i0	PRJNA376117	28587	270	1.497462	4.0431474	Micavibrio sp.	2024841	Bacteria	Bacteria	114	2.49e-28	NR	MDE1151994.1	2024841	g28285	i0	65.2	2.96666666666667	89	31	98.9	0	269	3	82	170	MDE1151994.1 cation diffusion facilitator family transporter [Micavibrio sp.]	diamond	801	114	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
30060239	30060239	PRJNA376117_P_NODE_40411_length_245_cov_0.895349_g40109_i0	PRJNA376117	40411	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	82.4	3.25e-16	NR	MAV91103.1	2026715	g40109	i0	70	1.33469387755102	60	18	73.5	0	184	5	6	65	MAV91103.1 aspartate aminotransferase [Pseudobdellovibrionaceae bacterium]	diamond	327	82.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30548770	30548770	PRJNA376117_P_NODE_38393_length_247_cov_0.885057_g38091_i0	PRJNA376117	38393	247	0.885057	2.18609079	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	63.9	1.3e-9	NR	MBT3982251.1	2081706	g38091	i0	38.3	3.89878542510121	81	50	98.4	0	2	244	190	270	MBT3982251.1 cyclic nucleotide-binding domain-containing protein [Bacteriovoracaceae bacterium]	diamond	963	63.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31781491	31781491	PRJNA376117_P_NODE_33077_length_253_cov_1.705556_g32775_i0	PRJNA376117	33077	253	1.705556	4.31505668	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	86.7	1.9e-18	NR	WP_408097883.1	3383025	g32775	i0	53.7	0.972332015810277	82	38	97.2	0	3	248	6	87	WP_408097883.1 hypothetical protein [Peredibacter sp. HCB2-198]	diamond	246	86.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198

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