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

5 rows where bioproject = "PRJNA815356", 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
2503412	2503412	PRJNA815356_P_NODE_1602_length_512_cov_2.735763_g1440_i0	PRJNA815356	1602	512	2.735763	14.00710656	Bdellovibrio	958	Bacteria	Bacteria	566	1.4499999999999996e-156	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g1440	i0	87.885	216.4296875	487	51	95	8	1	485	945144	945624	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	110812	571	0.991243432574431	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11431659	11431659	PRJNA815356_P_NODE_11449_length_227_cov_3.259740_g11286_i0	PRJNA815356	11449	227	3.25974	7.3996098	Bacteriovorax	146784	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g11286	i0	97.797	215.488986784141	227	5	100	0	1	227	1661034	1660808	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	48916	392	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
11431668	11431668	PRJNA815356_P_NODE_5449_length_308_cov_1.919149_g5286_i0	PRJNA815356	5449	308	1.919149	5.91097892	Bacteriovorax	146784	Bacteria	Bacteria	357	5.44e-94	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g5286	i0	87.869	309.623376623377	305	35	99	2	1	304	1660825	1660522	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	95364	357	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
13572706	13572706	PRJNA815356_P_NODE_6311_length_290_cov_2.479263_g6148_i0	PRJNA815356	6311	290	2.479263	7.1898627	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	228	4.1599999999999985e-55	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g6148	i0	83.077	52.3620689655172	260	34	88	9	34	288	3251792	3251538	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	15185	228	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
14847179	14847179	PRJNA815356_P_NODE_1092_length_610_cov_3.698324_g932_i0	PRJNA815356	1092	610	3.698324	22.5597764	Bacteriovorax stolpii	960	Bacteria	Bacteria	990	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g932	i0	96.053	243.34262295082	608	24	99	0	1	608	1661047	1661654	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	148439	990	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii

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