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

7 rows where analysis = "blastn", bioproject = "PRJNA575566" 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
4964869	4964869	PRJNA575566_P_NODE_28224_length_203_cov_0.901408_g28027_i0	PRJNA575566	28224	203	0.901408	1.82985824	Bdellovibrio	958	Bacteria	Bacteria	239	1.27e-58	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g28027	i0	88.776	7.63054187192118	196	20	96	2	1	195	4045413	4045607	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1549	239	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10764440	10764440	PRJNA575566_P_NODE_29869_length_201_cov_0.914286_g29672_i0	PRJNA575566	29869	201	0.914286	1.83771486	Bdellovibrio sp. KM01	2748865	Bacteria	Bacteria	195	2.74e-45	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g29672	i0	84.158	2.00995024875622	202	30	100	2	1	201	341709	341909	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	404	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
12615648	12615648	PRJNA575566_P_NODE_15590_length_267_cov_1.242718_g15393_i0	PRJNA575566	15590	267	1.242718	3.31805706	Bdellovibrio	958	Bacteria	Bacteria	287	6.15e-73	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g15393	i0	87.251	35.8801498127341	251	32	94	0	16	266	806388	806638	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	9580	289	0.993079584775087	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
13890665	13890665	PRJNA575566_P_NODE_12651_length_295_cov_1.581197_g12454_i0	PRJNA575566	12651	295	1.581197	4.66453115	Bdellovibrio	958	Bacteria	Bacteria	479	1.0599999999999996e-130	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g12454	i0	95.946	44.0203389830508	296	11	100	1	1	295	3504713	3504418	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	12986	479	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
19686640	19686640	PRJNA575566_P_NODE_26496_length_206_cov_0.882759_g26299_i0	PRJNA575566	26496	206	0.882759	1.81848354	Bdellovibrio sp. HCB185ZH	3394235	Bacteria	Bacteria	298	2.09e-76	NTclustered	gi\|2895513970\|gb\|CP178624.1\|	3394235	g26299	i0	92.718	14.2766990291262	206	15	100	0	1	206	1199597	1199802	Bdellovibrio sp. HCB185ZH chromosome, complete genome	blastn	2941	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB185ZH
23512284	23512284	PRJNA575566_P_NODE_14539_length_276_cov_1.190698_g14342_i0	PRJNA575566	14539	276	1.190698	3.28632648	Bdellovibrio sp. HCB185ZH	3394235	Bacteria	Bacteria	377	3.69e-100	NTclustered	gi\|2895513970\|gb\|CP178624.1\|	3394235	g14342	i0	91.636	43.6775362318841	275	20	99	2	4	276	2779033	2779306	Bdellovibrio sp. HCB185ZH chromosome, complete genome	blastn	12055	377	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB185ZH
25363121	25363121	PRJNA575566_P_NODE_27860_length_204_cov_0.895105_g27663_i0	PRJNA575566	27860	204	0.895105	1.8260142	Bdellovibrio	958	Bacteria	Bacteria	241	3.54e-59	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g27663	i0	89.894	10.2549019607843	188	17	92	2	1	187	799524	799710	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	2092	241	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01

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