metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
4782729	4782729	PRJNA980585_P_NODE_20404_length_321_cov_1.241935_g20150_i0	PRJNA980585	20404	321	1.241935	3.98661135	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	566	8.699999999999998e-157	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g20150	i0	98.442	203.214953271028	321	5	100	0	1	321	1293176	1292856	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	65232	566	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
8607937	8607937	PRJNA980585_P_NODE_51767_length_245_cov_2.563953_g51513_i0	PRJNA980585	51767	245	2.563953	6.28168485	Peredibacter starrii	28202	Bacteria	Bacteria	383	6.899999999999998e-102	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g51513	i0	95.062	85.065306122449	243	12	99	0	3	245	510857	511099	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	20841	383	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8922188	8922188	PRJNA980585_P_NODE_19787_length_325_cov_0.968254_g19533_i0	PRJNA980585	19787	325	0.968254	3.1468255	Pseudobdellovibrio	2862745	Bacteria	Bacteria	398	3.4099999999999982e-106	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g19533	i0	91.126	78.7753846153846	293	26	90	0	1	293	1510	1218	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	25602	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
8922267	8922267	PRJNA980585_P_NODE_33967_length_268_cov_2.369231_g33713_i0	PRJNA980585	33967	268	2.369231	6.34953908	Bdellovibrio	958	Bacteria	Bacteria	213	1.06e-50	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g33713	i0	81.25	118.25	272	44	100	7	1	268	952932	952664	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	31691	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
10197922	10197922	PRJNA980585_P_NODE_11408_length_400_cov_2.746177_g11154_i0	PRJNA980585	11408	400	2.746177	10.984708	Bdellovibrio	958	Bacteria	Bacteria	459	1.93e-124	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g11154	i0	87.531	136.895	401	45	99	4	1	399	783097	783494	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	54758	459	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11158255	11158255	PRJNA980585_P_NODE_3689_length_642_cov_2.613357_g3438_i0	PRJNA980585	3689	642	2.613357	16.77775194	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	896	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g3438	i0	91.834	222.626168224299	649	43	100	8	1	642	1677006	1677651	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	142926	896	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18806248	18806248	PRJNA980585_P_NODE_16075_length_351_cov_0.812950_g15821_i0	PRJNA980585	16075	351	0.81295	2.8534545	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	497	3.54e-136	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g15821	i0	92.33	201.25641025641	352	24	100	3	1	351	3250989	3250640	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	70641	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
21356346	21356346	PRJNA980585_P_NODE_1037_length_1087_cov_5.382643_g875_i0	PRJNA980585	1037	1087	5.382643	58.50932941	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	56.5	0.009	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g875	i0	100	0.0827966881324747	30	0	3	0	450	479	2534288	2534317	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	90	56.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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