metadata: contig_metadata: 5 rows where bioproject = "PRJNA846086", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA846086", 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
7211005	7211005	PRJNA846086_P_NODE_4426_length_245_cov_1.790698_g4360_i0	PRJNA846086	4426	245	1.790698	4.3872101	Bacteriovorax stolpii	960	Bacteria	Bacteria	387	5.34e-103	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g4360	i0	95.122	3.33469387755102	246	10	100	2	1	245	1502319	1502075	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	817	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
8485735	8485735	PRJNA846086_P_NODE_5287_length_242_cov_0.911243_g5221_i0	PRJNA846086	5287	242	0.911243	2.20520806	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	375	1.14e-99	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g5221	i0	94.628	3	242	13	100	0	1	242	2491557	2491798	Bacteriovorax sp. HI3 DNA, complete genome	blastn	726	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
13586473	13586473	PRJNA846086_P_NODE_1211_length_338_cov_1.626415_g1145_i0	PRJNA846086	1211	338	1.626415	5.4972827	Peredibacter starrii	28202	Bacteria	Bacteria	353	7.81e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1145	i0	85.63	221.502958579882	341	44	100	5	1	338	510753	511091	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	74868	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21234945	21234945	PRJNA846086_P_NODE_3777_length_248_cov_0.880000_g3711_i0	PRJNA846086	3777	248	0.88	2.1824	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g3711	i0	100	2.31451612903226	248	0	100	0	1	248	3016797	3017044	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	574	459	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
28760004	28760004	PRJNA846086_P_NODE_3487_length_249_cov_1.437500_g3421_i0	PRJNA846086	3487	249	1.4375	3.579375	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	95.1	1.42e-20	NR	WP_323576032.1	3088717	g3421	i0	88	0.602409638554217	50	6	60.2	0	152	3	4	53	WP_323576032.1 NAD(+) synthase [Bacteriovorax antarcticus]	diamond	150	95.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus

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