metadata: contig_metadata: 11 rows where bioproject = "PRJNA356682", tax_phylum = "Bdellovibrionota" and tax

11 rows where bioproject = "PRJNA356682", 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
4899939	4899939	PRJNA356682_P_NODE_11404_length_415_cov_1.956140_g10714_i0	PRJNA356682	11404	415	1.95614	8.117981	Bacteriovorax	146784	Bacteria	Bacteria	569	8.91e-158	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g10714	i0	91.587	134.638554216867	416	29	99	6	3	415	1661726	1662138	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	55875	569	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9326034	9326034	PRJNA356682_P_NODE_45868_length_234_cov_2.167702_g45177_i0	PRJNA356682	45868	234	2.167702	5.07242268	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	113	9.48e-21	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g45177	i0	83.74	37.5897435897436	123	17	52	3	17	137	2321707	2321828	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	8796	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
12551059	12551059	PRJNA356682_P_NODE_47050_length_220_cov_4.346939_g46359_i0	PRJNA356682	47050	220	4.346939	9.5632658	Pseudobdellovibrio	2862745	Bacteria	Bacteria	274	3.82e-69	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g46359	i0	89.14	159.468181818182	221	22	99	2	1	219	308	88	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	35083	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15100347	15100347	PRJNA356682_P_NODE_4852_length_643_cov_18.489474_g4178_i0	PRJNA356682	4852	643	18.489474	118.88731782	Bacteriovorax	146784	Bacteria	Bacteria	1140	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g4178	i0	98.607	372.790046656299	646	5	99	3	1	642	1661494	1662139	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	239704	1140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
17650047	17650047	PRJNA356682_P_NODE_42394_length_243_cov_4.547059_g41703_i0	PRJNA356682	42394	243	4.547059	11.04935337	Pseudobdellovibrio	2862745	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g41703	i0	95.868	214.20987654321	242	8	99	2	1	240	2624	2865	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	52053	390	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
19523325	19523325	PRJNA356682_P_NODE_2656_length_908_cov_12.922156_g1055_i1	PRJNA356682	2656	908	12.922156	117.33317648	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	1404	0	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g1055	i1	94.895	188.838105726872	901	40	99	5	1	897	666157	667055	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	171465	1404	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
19523776	19523776	PRJNA356682_P_NODE_46356_length_230_cov_2.242038_g45665_i0	PRJNA356682	46356	230	2.242038	5.1566874	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	387	4.96e-103	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g45665	i0	96.957	280.339130434783	230	7	100	0	1	230	698931	699160	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	64478	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
21473919	21473919	PRJNA356682_P_NODE_23397_length_301_cov_3.899123_g22706_i0	PRJNA356682	23397	301	3.899123	11.73636023	Bacteriovorax	146784	Bacteria	Bacteria	545	1.0499999999999999e-150	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g22706	i0	99.336	151.770764119601	301	2	100	0	1	301	1660663	1660363	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	45683	545	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
22074621	22074621	PRJNA356682_P_NODE_8778_length_471_cov_7.608040_g8089_i0	PRJNA356682	8778	471	7.60804	35.8338684	Peredibacter starrii	28202	Bacteria	Bacteria	839	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8089	i0	98.732	172.091295116773	473	4	100	1	1	471	512138	511666	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	81055	839	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25298568	25298568	PRJNA356682_P_NODE_34400_length_255_cov_4.758242_g33709_i0	PRJNA356682	34400	255	4.758242	12.1335171	Pseudobdellovibrio	2862745	Bacteria	Bacteria	267	7.6e-67	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g33709	i0	85.882	84.6117647058824	255	31	99	5	3	255	1506	1255	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	21576	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
30296461	30296461	PRJNA356682_P_NODE_14112_length_377_cov_1.013158_g13422_i0	PRJNA356682	14112	377	1.013158	3.81960566	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	209	1.13e-66	NR	MBP9675022.1	2081706	g13422	i0	84.3	0.962864721485411	121	18	95.5	1	373	14	6	126	MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium]	diamond	363	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;