metadata: contig_metadata: 11 rows where bioproject = "PRJNA577226", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA577226", 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
4389365	4389365	PRJNA577226_S_NODE_39024_length_199_cov_1.790123_g38085_i0	PRJNA577226	39024	199	1.790123	3.56234477	Peredibacter starrii	28202	Bacteria	Bacteria	329	7.12e-86	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g38085	i0	96.482	35.8894472361809	199	7	100	0	1	199	512473	512275	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	7142	329	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
4965456	4965456	PRJNA577226_S_NODE_35084_length_210_cov_2.213873_g34145_i0	PRJNA577226	35084	210	2.213873	4.6491333	Bdellovibrio	958	Bacteria	Bacteria	215	2.22e-51	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g34145	i0	88.701	22.2095238095238	177	18	84	2	35	210	784530	784355	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	4664	217	0.990783410138249	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7515284	7515284	PRJNA577226_S_NODE_44426_length_187_cov_1.186667_g43487_i0	PRJNA577226	44426	187	1.186667	2.21906729	Pseudobdellovibrio	2862745	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g43487	i0	90.957	89.8128342245989	188	15	100	2	1	187	1543	1729	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	16795	252	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
9490772	9490772	PRJNA577226_S_NODE_57288_length_165_cov_2.625000_g56349_i0	PRJNA577226	57288	165	2.625	4.33125	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g56349	i0	93.333	229.751515151515	165	11	100	0	1	165	665702	665538	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	37909	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
16439994	16439994	PRJNA577226_S_NODE_35113_length_210_cov_1.976879_g34174_i0	PRJNA577226	35113	210	1.976879	4.1514459	Bacteriovorax	146784	Bacteria	Bacteria	235	1.6999999999999998e-57	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g34174	i0	86.854	155.047619047619	213	24	100	3	1	210	1660596	1660385	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	32560	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16440238	16440238	PRJNA577226_S_NODE_54613_length_169_cov_1.803030_g53674_i0	PRJNA577226	54613	169	1.80303	3.0471207	Bacteriovorax	146784	Bacteria	Bacteria	291	2.75e-74	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g53674	i0	97.633	22.491124260355	169	4	100	0	1	169	1661759	1661591	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	3801	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18988815	18988815	PRJNA577226_S_NODE_47435_length_181_cov_1.493056_g46496_i0	PRJNA577226	47435	181	1.493056	2.70243136	Bacteriovorax	146784	Bacteria	Bacteria	313	6.39e-81	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g46496	i0	97.802	9.24309392265193	182	3	100	1	1	181	1661746	1661927	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1673	313	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18988961	18988961	PRJNA577226_S_NODE_59415_length_163_cov_1.230159_g58476_i0	PRJNA577226	59415	163	1.230159	2.00515917	Bacteriovorax	146784	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g58476	i0	98.16	532.398773006135	163	3	100	0	1	163	1661178	1661016	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	86781	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
24089497	24089497	PRJNA577226_S_NODE_55759_length_168_cov_0.893130_g54820_i0	PRJNA577226	55759	168	0.89313	1.5004584	Bacteriovorax	146784	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g54820	i0	98.81	192.928571428571	168	2	100	0	1	168	1662589	1662422	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	32412	300	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
25363751	25363751	PRJNA577226_S_NODE_40740_length_195_cov_1.329114_g39801_i0	PRJNA577226	40740	195	1.329114	2.5917723	Peredibacter	263370	Bacteria	Bacteria	327	2.5e-85	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g39801	i0	96.923	386.882051282051	195	6	100	0	1	195	511893	512087	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	75442	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26921407	26921407	PRJNA577226_S_NODE_14242_length_342_cov_4.163934_g13303_i0	PRJNA577226	14242	342	4.163934	14.24065428	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	128	4.009999999999999e-32	NR	PZQ45584.1	349221	g13303	i0	55.7	2.02631578947368	115	48	98.2	1	5	340	178	292	PZQ45584.1 MAG: glutamate--tRNA ligase [Micavibrio aeruginosavorus]	diamond	693	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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