metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
8716225	8716225	PRJNA312107_P_NODE_13507_length_199_cov_0.953333_g13341_i0	PRJNA312107	13507	199	0.953333	1.89713267	Bacteriovorax	146784	Bacteria	Bacteria	316	5.55e-82	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g13341	i0	95.477	116.859296482412	199	7	99	2	1	197	1662025	1661827	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	23255	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9991774	9991774	PRJNA312107_P_NODE_12368_length_207_cov_1.259494_g12202_i0	PRJNA312107	12368	207	1.259494	2.60715258	Bdellovibrio	958	Bacteria	Bacteria	315	2.09e-81	NTclustered	gi\|485099167\|ref\|NR_102561.1\|	959	g12202	i0	95.897	88.3236714975845	195	7	94	1	14	207	1630	1824	Bdellovibrio bacteriovorus strain Tiberius 23S ribosomal RNA gene, complete sequence	blastn	18283	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18914951	18914951	PRJNA312107_P_NODE_10615_length_222_cov_1.092486_g10449_i0	PRJNA312107	10615	222	1.092486	2.42531892	Peredibacter	263370	Bacteria	Bacteria	405	1.31e-108	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10449	i0	99.55	172.747747747748	222	1	100	0	1	222	511537	511316	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	38350	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18914968	18914968	PRJNA312107_P_NODE_20395_length_167_cov_1.500000_g20229_i0	PRJNA312107	20395	167	1.5	2.505	Bdellovibrionota	3018035	Bacteria	Bacteria	270	3.5499999999999993e-68	NTclustered	gi\|1080116041\|gb\|KY000520.1\|	28201	g20229	i0	95.833	107.670658682635	168	6	100	1	1	167	360	527	Bdellovibrio sp. strain TLH 16S ribosomal RNA gene, partial sequence	blastn	17981	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
21465368	21465368	PRJNA312107_P_NODE_8717_length_243_cov_1.072165_g8551_i0	PRJNA312107	8717	243	1.072165	2.60536095	Peredibacter	263370	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8551	i0	95.062	124.201646090535	243	10	100	2	1	243	511857	512097	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	30181	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23329674	23329674	PRJNA312107_P_NODE_23159_length_165_cov_0.896552_g22993_i0	PRJNA312107	23159	165	0.896552	1.4793108	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g22993	i0	93.373	256.606060606061	166	10	100	1	1	165	3447762	3447927	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	42340	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
24603628	24603628	PRJNA312107_P_NODE_19420_length_168_cov_1.613445_g19254_i0	PRJNA312107	19420	168	1.613445	2.7105876	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g19254	i0	97.5	44.8630952380952	160	4	95	0	9	168	1292577	1292418	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	7537	274	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);;