metadata: contig_metadata: 7 rows where bioproject = "PRJEB17675", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJEB17675", 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
1295819	1295819	PRJEB17675_P_NODE_11162_length_256_cov_1.990950_g10858_i0	PRJEB17675	11162	256	1.99095	5.096832	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	440	4.249999999999998e-119	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g10858	i0	97.656	87.05078125	256	6	100	0	1	256	666661	666916	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	22285	440	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
12465033	12465033	PRJEB17675_P_NODE_9370_length_288_cov_1.873518_g9066_i0	PRJEB17675	9370	288	1.873518	5.39573184	Bacteriovorax	146784	Bacteria	Bacteria	279	1.12e-70	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g9066	i0	86.26	260.888888888889	262	30	90	6	30	288	1660621	1660363	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	75136	279	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20422325	20422325	PRJEB17675_P_NODE_1077_length_927_cov_2.979821_g917_i0	PRJEB17675	1077	927	2.979821	27.62294067	root	1	Root_unresolved	Root_unresolved	370	3.68e-124	NR	RME17908.1	28201	g917	i0	56.7	47.7864077669903	307	130	99.4	2	925	5	68	371	RME17908.1 MAG: cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	44298	370	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
26805115	26805115	PRJEB17675_P_NODE_14661_length_213_cov_1.235955_g14357_i0	PRJEB17675	14661	213	1.235955	2.63258415	Bacteria	2	Bacteria	Bacteria	48.9	1.63e-4	NR	MCB0391223.1	2053517	g14357	i0	46.5	2.42253521126761	43	21	60.6	1	82	210	1	41	MCB0391223.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	516	48.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26805119	26805119	PRJEB17675_P_NODE_7801_length_327_cov_2.130137_g7497_i0	PRJEB17675	7801	327	2.130137	6.96554799	Pseudomonadati	3379134	Bacteria	Bacteria	51.2	1.12e-4	NR	HHW97697.1	2687297	g7497	i0	45.9	2.23853211009174	61	30	54.1	2	198	22	1334	1393	HHW97697.1 hypothetical protein [Oligoflexales bacterium]	diamond	732	51.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
28833207	28833207	PRJEB17675_P_NODE_20148_length_173_cov_1.202899_g19844_i0	PRJEB17675	20148	173	1.202899	2.08101527	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.6	2.06e-14	NR	MCB0371038.1	2053517	g19844	i0	56.6	0.919075144508671	53	23	91.9	0	14	172	45	97	MCB0371038.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium]	diamond	159	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31170344	31170344	PRJEB17675_P_NODE_17595_length_189_cov_1.298701_g17291_i0	PRJEB17675	17595	189	1.298701	2.45454489	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	42.7	0.0157	NR	MBL7664855.1	2081706	g17291	i0	48.8	1.92063492063492	41	21	65.1	0	149	27	176	216	MBL7664855.1 2-hydroxychromene-2-carboxylate isomerase [Bacteriovoracaceae bacterium]	diamond	363	42.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;