metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
3488675	3488675	PRJNA951810_P_NODE_80883_length_299_cov_3.792035_g80539_i0	PRJNA951810	80883	299	3.792035	11.33818465	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	139	2.07e-28	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g80539	i0	90.826	37.2675585284281	109	3	34	2	198	299	1677972	1677864	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	11143	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
7313815	7313815	PRJNA951810_P_NODE_128086_length_274_cov_4.890547_g127741_i0	PRJNA951810	128086	274	4.890547	13.40009878	Bdellovibrio sp. HCB117	3394359	Bacteria	Bacteria	185	2.3799999999999993e-42	NTclustered	gi\|2895987660\|gb\|CP178622.1\|	3394359	g127741	i0	78.986	2.01094890510949	276	54	100	4	1	274	2338177	2338450	Bdellovibrio sp. HCB117 chromosome, complete genome	blastn	551	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB117
7641392	7641392	PRJNA951810_P_NODE_173586_length_239_cov_3.819277_g173241_i0	PRJNA951810	173586	239	3.819277	9.12807203	Bdellovibrio	958	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g173241	i0	98.745	127.753138075314	239	3	100	0	1	239	2952242	2952004	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	30533	425	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12415831	12415831	PRJNA951810_P_NODE_188230_length_219_cov_12.424658_g187885_i0	PRJNA951810	188230	219	12.424658	27.21000102	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	327	2.87e-85	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g187885	i0	93.665	181.762557077626	221	10	100	4	1	219	3446518	3446300	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	39806	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
14964019	14964019	PRJNA951810_P_NODE_151852_length_256_cov_5.945355_g151507_i0	PRJNA951810	151852	256	5.945355	15.2201088	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	132	2.9100000000000004e-26	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g151507	i0	84.848	0.515625	132	18	51	2	114	244	3483842	3483712	Bdellovibrio sp. HM001 DNA, complete genome	blastn	132	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
17840782	17840782	PRJNA951810_P_NODE_167034_length_244_cov_8.719298_g166689_i0	PRJNA951810	167034	244	8.719298	21.27508712	Bdellovibrio	958	Bacteria	Bacteria	209	1.23e-49	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g166689	i0	82.231	3.86065573770492	242	43	99	0	2	243	2773047	2773288	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	942	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17840813	17840813	PRJNA951810_P_NODE_171574_length_241_cov_2.964286_g171229_i0	PRJNA951810	171574	241	2.964286	7.14392926	Bdellovibrio	958	Bacteria	Bacteria	141	4.5e-29	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g171229	i0	95.506	42.7510373443983	89	3	37	1	81	169	3074124	3074037	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	10303	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20062824	20062824	PRJNA951810_P_NODE_148656_length_259_cov_2.720430_g148311_i0	PRJNA951810	148656	259	2.72043	7.0459137	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	259	1.29e-64	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g148311	i0	84.942	7.18146718146718	259	36	99	3	1	256	909592	909850	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	1860	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
23888319	23888319	PRJNA951810_P_NODE_136439_length_268_cov_4.543590_g136094_i0	PRJNA951810	136439	268	4.54359	12.1768212	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	104	6.68e-18	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g136094	i0	83.929	7.07835820895522	112	15	41	3	150	258	3253216	3253327	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	1897	104	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae 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);;