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

8 rows where bioproject = "PRJNA1061474", 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
4005461	4005461	PRJNA1061474_P_NODE_54044_length_244_cov_0.900585_g53798_i0	PRJNA1061474	54044	244	0.900585	2.1974274	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	331	2.5200000000000006e-86	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g53798	i0	91.358	195.459016393443	243	20	99	1	1	242	3446255	3446497	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	47692	331	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
19304746	19304746	PRJNA1061474_P_NODE_55456_length_243_cov_0.905882_g55210_i0	PRJNA1061474	55456	243	0.905882	2.20129326	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	115	2.06e-28	NR	MCB0341143.1	2053517	g55210	i0	65.4	3.96296296296296	81	28	100	0	243	1	326	406	MCB0341143.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	963	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
25237942	25237942	PRJNA1061474_P_NODE_40480_length_277_cov_1.132353_g40234_i0	PRJNA1061474	40480	277	1.132353	3.13661781	Bacteriovorax	146784	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g40234	i0	100	132.274368231047	277	0	100	0	1	277	1661764	1662040	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	36640	512	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
27415018	27415018	PRJNA1061474_P_NODE_8403_length_746_cov_2.369985_g8183_i0	PRJNA1061474	8403	746	2.369985	17.6800881	Bacteriovorax sp.	2608087	Bacteria	Bacteria	49.7	0.00594	NR	MBC7714774.1	2608087	g8183	i0	26.4	0.442359249329759	110	76	42.6	2	351	668	266	374	MBC7714774.1 class I SAM-dependent rRNA methyltransferase [Bacteriovorax sp.]	diamond	330	49.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
28172422	28172422	PRJNA1061474_P_NODE_48326_length_249_cov_0.875000_g48080_i0	PRJNA1061474	48326	249	0.875	2.17875	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	93.2	9.55e-21	NR	MEZ0391410.1	2026715	g48080	i0	58.8	1.02409638554217	85	29	95.2	1	1	237	21	105	MEZ0391410.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Pseudobdellovibrionaceae bacterium]	diamond	255	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
29088281	29088281	PRJNA1061474_P_NODE_32588_length_322_cov_1.489960_g32342_i0	PRJNA1061474	32588	322	1.48996	4.7976712	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	72.8	1.63e-14	NR	MBX9703359.1	2654442	g32342	i0	53.3	0.559006211180124	60	24	52.2	1	155	322	1	60	MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	180	72.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
31164380	31164380	PRJNA1061474_P_NODE_53155_length_245_cov_0.895349_g52909_i0	PRJNA1061474	53155	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	145	9.659999999999999e-40	NR	MAV91884.1	2026715	g52909	i0	85.2	4.95918367346939	81	12	99.2	0	245	3	247	327	MAV91884.1 preprotein translocase subunit SecY [Pseudobdellovibrionaceae bacterium]	diamond	1215	145	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31931917	31931917	PRJNA1061474_P_NODE_51497_length_246_cov_0.890173_g51251_i0	PRJNA1061474	51497	246	0.890173	2.18982558	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	100	1.92e-22	NR	MCC2678077.1	2862747	g51251	i0	63	0.98780487804878	81	30	98.8	0	246	4	419	499	MCC2678077.1 large repetitive protein [Pseudobdellovibrio sp.]	diamond	243	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.

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