metadata: contig_metadata: 8 rows where bioproject = "PRJNA1249535", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA1249535", 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
3602931	3602931	PRJNA1249535_S_NODE_171243_length_322_cov_3.638554_g167860_i0	PRJNA1249535	171243	322	3.638554	11.71614388	Bacteriovorax	146784	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g167860	i0	96.774	0.183229813664596	31	1	10	0	44	74	501129	501159	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	59	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
8009585	8009585	PRJNA1249535_S_NODE_182367_length_316_cov_2.246914_g178984_i0	PRJNA1249535	182367	316	2.246914	7.10024824	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	315	3.42e-81	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g178984	i0	85.174	181.863924050633	317	36	98	9	7	316	1676519	1676831	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	57469	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
16935285	16935285	PRJNA1249535_S_NODE_341134_length_216_cov_5.538462_g337751_i0	PRJNA1249535	341134	216	5.538462	11.96307792	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2626289182\|emb\|OY843585.1\|	2053517	g337751	i0	100	0.12962962962963	28	0	13	0	83	110	298341	298368	MAG: Bdellovibrionales bacterium isolate 022bb5af-5c53-4953-82b0-2ef8059d9f16 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
18209348	18209348	PRJNA1249535_S_NODE_305595_length_250_cov_1.096045_g302212_i0	PRJNA1249535	305595	250	1.096045	2.7401125	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g302212	i0	100	0.112	28	0	11	0	202	229	3034565	3034538	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27199916	27199916	PRJNA1249535_S_NODE_21282_length_645_cov_13.690559_g18179_i0	PRJNA1249535	21282	645	13.690559	88.30410555	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	47	0.0334	NR	MBT6325452.1	2053517	g18179	i0	27.4	0.493023255813954	106	71	46.5	2	257	556	94	199	MBT6325452.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Bdellovibrionales bacterium]	diamond	318	47	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28337061	28337061	PRJNA1249535_S_NODE_254706_length_277_cov_4.137255_g251323_i0	PRJNA1249535	254706	277	4.137255	11.46019635	Pigmentibacter ruber	2683196	Bacteria	Bacteria	43.9	0.023	NR	WP_158996909.1	2683196	g251323	i0	31	0.768953068592058	71	48	75.8	1	243	34	396	466	WP_158996909.1 protein kinase domain-containing protein [Pigmentibacter ruber]	diamond	213	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter ruber
29189639	29189639	PRJNA1249535_S_NODE_143589_length_339_cov_4.500000_g140206_i0	PRJNA1249535	143589	339	4.5	15.255	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.5	0.0427	NR	MBU6152860.1	2053517	g140206	i0	32	0.663716814159292	75	42	59.3	2	36	236	64	137	MBU6152860.1 thioredoxin-dependent thiol peroxidase [Bdellovibrionales bacterium]	diamond	225	43.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32065181	32065181	PRJNA1249535_S_NODE_267458_length_270_cov_5.035533_g264075_i0	PRJNA1249535	267458	270	5.035533	13.5959391	Fluviispira vulneris	2763012	Bacteria	Bacteria	44.7	0.00609	NR	WP_186648911.1	2763012	g264075	i0	40	0.555555555555556	50	30	55.6	0	245	96	92	141	WP_186648911.1 GNAT family N-acetyltransferase [Fluviispira vulneris]	diamond	150	44.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira vulneris

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