metadata: contig_metadata: 10 rows where bioproject = "PRJNA1137393", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA1137393", 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
284654	284654	PRJNA1137393_P_NODE_15241_length_221_cov_1.209302_g14725_i0	PRJNA1137393	15241	221	1.209302	2.67255742	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	211	3.05e-50	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g14725	i0	84.163	7.38914027149321	221	32	99	3	1	220	469335	469553	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	1633	211	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
2835369	2835369	PRJNA1137393_P_NODE_28943_length_183_cov_1.537313_g28427_i0	PRJNA1137393	28943	183	1.537313	2.81328279	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	274	3.06e-69	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g28427	i0	93.923	87.8524590163934	181	11	99	0	3	183	779074	779254	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	16077	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7937693	7937693	PRJNA1137393_P_NODE_17387_length_211_cov_2.746914_g16871_i0	PRJNA1137393	17387	211	2.746914	5.79598854	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	148	2.3e-31	NTclustered	gi\|2907625691\|emb\|OZ223251.1\|	2081706	g16871	i0	80.193	248.881516587678	207	33	96	8	3	205	90798	91000	MAG: Bacteriovoracaceae bacterium isolate 56684ba0-df17-47c9-bcf5-ee076427a4fa genome assembly, chromosome: 1	blastn	52514	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
10488263	10488263	PRJNA1137393_P_NODE_38729_length_169_cov_6.075000_g38213_i0	PRJNA1137393	38729	169	6.075	10.26675	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	178	2.23e-40	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g38213	i0	86.145	118.934911242604	166	21	98	2	4	168	467075	467239	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	20100	178	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
10488326	10488326	PRJNA1137393_P_NODE_55849_length_165_cov_2.750000_g55333_i0	PRJNA1137393	55849	165	2.75	4.5375	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	182	1.6899999999999996e-41	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g55333	i0	91.603	297.854545454545	131	11	79	0	18	148	728670	728800	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	49146	182	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
16861867	16861867	PRJNA1137393_P_NODE_51694_length_166_cov_1.752137_g51178_i0	PRJNA1137393	51694	166	1.752137	2.90854742	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	109	3.5300000000000003e-26	NR	MBX3018825.1	2026715	g51178	i0	81.5	0.975903614457831	54	10	97.6	0	165	4	461	514	MBX3018825.1 FAD-dependent oxidoreductase [Pseudobdellovibrionaceae bacterium]	diamond	162	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
21961662	21961662	PRJNA1137393_P_NODE_9278_length_272_cov_2.443946_g8762_i0	PRJNA1137393	9278	272	2.443946	6.64753312	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	274	4.889999999999998e-69	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g8762	i0	85.036	213.805147058824	274	35	99	5	1	270	469435	469164	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	58155	274	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28175642	28175642	PRJNA1137393_P_NODE_69486_length_162_cov_1.672566_g68970_i0	PRJNA1137393	69486	162	1.672566	2.70955692	Peredibacter starrii	28202	Bacteria	Bacteria	99	4.02e-24	NR	WP_321399668.1	28202	g68970	i0	84.9	0.981481481481482	53	8	98.1	0	160	2	36	88	WP_321399668.1 lysophospholipid acyltransferase family protein [Peredibacter starrii]	diamond	159	99	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
28933659	28933659	PRJNA1137393_P_NODE_67808_length_163_cov_0.912281_g67292_i0	PRJNA1137393	67808	163	0.912281	1.48701803	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	83.2	2.21e-17	NR	MEQ1723686.1	2862747	g67292	i0	67.9	0.975460122699387	53	17	97.5	0	1	159	190	242	MEQ1723686.1 hypothetical protein [Pseudobdellovibrio sp.]	diamond	159	83.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
31840252	31840252	PRJNA1137393_P_NODE_41957_length_169_cov_0.866667_g41441_i0	PRJNA1137393	41957	169	0.866667	1.46466723	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	89.4	5.24e-19	NR	MBS1961671.1	2053517	g41441	i0	87.5	0.85207100591716	48	6	85.2	0	169	26	566	613	MBS1961671.1 ABC transporter ATP-binding protein [Bdellovibrionales bacterium]	diamond	144	89.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium

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