metadata: contig_metadata: 13 rows where bioproject = "PRJNA489308", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA489308", 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
450427	450427	PRJNA489308_P_NODE_7101_length_405_cov_2.198795_g7025_i0	PRJNA489308	7101	405	2.198795	8.90511975	Bdellovibrio sp. CG22_combo_CG1	28201	Bacteria	Bacteria	164	3.769999999999999e-46	NR	PIP95421.1	1975529	g7025	i0	75.5	9.61481481481482	106	26	78.5	0	2	319	300	405	PIP95421.1 MAG: isocitrate dehydrogenase (NADP(+)) [Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27]	diamond	3894	164	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27
17027648	17027648	PRJNA489308_P_NODE_8234_length_382_cov_2.889968_g8158_i0	PRJNA489308	8234	382	2.889968	11.03967776	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	199	3.22e-60	NR	HEY8271873.1	2026715	g8158	i0	79	14.261780104712	124	26	97.4	0	3	374	264	387	HEY8271873.1 cystathionine gamma-synthase [Pseudobdellovibrionaceae bacterium]	diamond	5448	199	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
19576020	19576020	PRJNA489308_P_NODE_32076_length_249_cov_1.750000_g32000_i0	PRJNA489308	32076	249	1.75	4.3575	uncultured Micavibrio sp.	362447	Bacteria	Bacteria	322	1.56e-83	NTclustered	gi\|2621703983\|emb\|OY762938.1\|	362447	g32000	i0	89.96	217.313253012048	249	25	100	0	1	249	962049	962297	MAG: uncultured Micavibrio sp. isolate 194a20bb-105a-45c9-9846-0688499aae06 genome assembly, chromosome: 1	blastn	54111	322	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	uncultured Micavibrio sp.
27092393	27092393	PRJNA489308_P_NODE_302_length_1342_cov_2.078802_g268_i0	PRJNA489308	302	1342	2.078802	27.89752284	Pseudomonadati	3379134	Bacteria	Bacteria	102	3.12e-19	NR	MCO5114315.1	2026715	g268	i0	41	1.5424739195231	139	72	30.2	5	19	423	91	223	MCO5114315.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	2070	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28371186	28371186	PRJNA489308_P_NODE_7006_length_407_cov_3.332335_g6930_i0	PRJNA489308	7006	407	3.332335	13.56260345	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	80.1	2.06e-14	NR	MCB0350352.1	2053517	g6930	i0	38.2	1.71744471744472	123	67	88.5	4	27	386	215	331	MCB0350352.1 Fic family protein [Bdellovibrionales bacterium]	diamond	699	80.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28876346	28876346	PRJNA489308_P_NODE_13248_length_326_cov_1.217391_g13172_i0	PRJNA489308	13248	326	1.217391	3.96869466	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	120	1.91e-32	NR	MFL5813022.1	3034169	g13172	i0	52.8	0.993865030674847	108	50	99.4	1	1	324	29	135	MFL5813022.1 glutathione S-transferase N-terminal domain-containing protein [Bdellovibrionia bacterium]	diamond	324	120	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
29618280	29618280	PRJNA489308_P_NODE_28870_length_256_cov_1.464481_g28794_i0	PRJNA489308	28870	256	1.464481	3.74907136	Bdellovibrio	958	Bacteria	Bacteria	106	4.87e-25	NR	MBC7420993.1	28201	g28794	i0	77.9	4.1015625	68	15	79.7	0	243	40	312	379	MBC7420993.1 cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	1050	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30266238	30266238	PRJNA489308_P_NODE_5492_length_450_cov_3.745358_g5416_i0	PRJNA489308	5492	450	3.745358	16.854111	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	63.2	2.6e-8	NR	MCK5074195.1	2081706	g5416	i0	33.3	1	150	82	98	4	4	444	295	429	MCK5074195.1 Fic family protein [Bacteriovoracaceae bacterium]	diamond	450	63.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31656419	31656419	PRJNA489308_P_NODE_2337_length_635_cov_2.709964_g2262_i0	PRJNA489308	2337	635	2.709964	17.2082714	Pigmentibacter ruber	2683196	Bacteria	Bacteria	162	1.36e-45	NR	WP_158997865.1	2683196	g2262	i0	46	0.935433070866142	198	90	90.2	5	3	575	83	270	WP_158997865.1 hypothetical protein [Pigmentibacter ruber]	diamond	594	162	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter ruber
31846292	31846292	PRJNA489308_P_NODE_28137_length_258_cov_1.600000_g28061_i0	PRJNA489308	28137	258	1.6	4.128	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	81.6	4.59e-18	NR	MCB0368788.1	2053517	g28061	i0	59.4	0.802325581395349	69	28	80.2	0	256	50	17	85	MCB0368788.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	207	81.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32036199	32036199	PRJNA489308_P_NODE_10378_length_352_cov_1.512545_g10302_i0	PRJNA489308	10378	352	1.512545	5.3241584	Oligoflexia bacterium	2599941	Bacteria	Bacteria	83.2	8.11e-16	NR	MBC7397006.1	2599941	g10302	i0	44.5	0.9375	110	58	93.8	2	19	348	5	111	MBC7397006.1 carboxypeptidase M32 [Oligoflexia bacterium]	diamond	330	83.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32289745	32289745	PRJNA489308_P_NODE_13279_length_325_cov_3.261905_g13203_i0	PRJNA489308	13279	325	3.261905	10.60119125	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	48.5	8.92e-4	NR	MCK5072433.1	2081706	g13203	i0	35	0.738461538461539	80	47	73.8	3	317	78	126	200	MCK5072433.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	240	48.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32352913	32352913	PRJNA489308_P_NODE_24139_length_271_cov_1.469697_g24063_i0	PRJNA489308	24139	271	1.469697	3.98287887	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	129	4.38e-34	NR	MBX9768715.1	2053517	g24063	i0	68.5	14.6789667896679	89	28	98.5	0	268	2	148	236	MBX9768715.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	3978	129	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);;