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

10 rows where bioproject = "PRJNA715462", 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
5809292	5809292	PRJNA715462_P_NODE_26185_length_352_cov_0.824373_g25389_i0	PRJNA715462	26185	352	0.824373	2.90179296	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2626289182\|emb\|OY843585.1\|	2053517	g25389	i0	100	0.0795454545454545	28	0	8	0	40	67	298368	298341	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
19044006	19044006	PRJNA715462_P_NODE_29715_length_327_cov_2.421260_g28919_i0	PRJNA715462	29715	327	2.42126	7.9175202	Peredibacter	263370	Bacteria	Bacteria	544	4.16e-150	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g28919	i0	96.646	211.079510703364	328	10	100	1	1	327	511251	511578	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	69023	549	0.990892531876138	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19833198	19833198	PRJNA715462_P_NODE_57296_length_247_cov_1.770115_g56500_i0	PRJNA715462	57296	247	1.770115	4.37218405	Bdellovibrio sp. HCB117	3394359	Bacteria	Bacteria	198	2.71e-46	NTclustered	gi\|2895987660\|gb\|CP178622.1\|	3394359	g56500	i0	81.481	1.73279352226721	243	43	98	2	6	247	2734488	2734729	Bdellovibrio sp. HCB117 chromosome, complete genome	blastn	428	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB117
26862422	26862422	PRJNA715462_P_NODE_35001_length_299_cov_0.840708_g34205_i0	PRJNA715462	35001	299	0.840708	2.51371692	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	44.3	0.0197	NR	MBN22457.1	2026715	g34205	i0	37.7	0.531772575250836	53	33	53.2	0	108	266	335	387	MBN22457.1 AAA family ATPase [Pseudobdellovibrionaceae bacterium]	diamond	159	44.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27567927	27567927	PRJNA715462_P_NODE_56184_length_248_cov_0.880000_g55388_i0	PRJNA715462	56184	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	53.1	8.49e-6	NR	MBO9666903.1	28201	g55388	i0	42	11.4314516129032	81	44	98	3	248	6	373	450	MBO9666903.1 S9 family peptidase [Bdellovibrio sp.]	diamond	2835	53.5	0.992523364485981	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
27873193	27873193	PRJNA715462_P_NODE_62445_length_245_cov_0.895349_g61649_i0	PRJNA715462	62445	245	0.895349	2.19360505	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	43.1	0.0221	NR	WP_015470185.1	453816	g61649	i0	40	0.73469387755102	60	36	73.5	0	1	180	146	205	WP_015470185.1 HdeD family acid-resistance protein [Pseudobdellovibrio exovorus]	diamond	180	43.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
29514868	29514868	PRJNA715462_P_NODE_46070_length_263_cov_1.247368_g45274_i0	PRJNA715462	46070	263	1.247368	3.28057784	Oligoflexia bacterium	2599941	Bacteria	Bacteria	63.5	8.93e-10	NR	MDR3605782.1	2599941	g45274	i0	42.5	0.992395437262357	87	38	99.2	1	262	2	124	198	MDR3605782.1 SEC59/DGK1/VTE5 family protein [Oligoflexia bacterium]	diamond	261	63.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
29862393	29862393	PRJNA715462_P_NODE_56871_length_248_cov_0.880000_g56075_i0	PRJNA715462	56871	248	0.88	2.1824	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	63.2	6.17e-10	NR	WP_374080345.1	959	g56075	i0	44.2	0.931451612903226	77	41	91.9	2	246	19	79	154	WP_374080345.1 HEAT repeat domain-containing protein [Bdellovibrio bacteriovorus]	diamond	231	63.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31769171	31769171	PRJNA715462_P_NODE_26237_length_351_cov_1.589928_g25441_i0	PRJNA715462	26237	351	1.589928	5.58064728	root	1	Root_unresolved	Root_unresolved	163	3.58e-46	NR	MBC7743086.1	28201	g25441	i0	75	9	108	27	92.3	0	1	324	282	389	MBC7743086.1 cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	3159	164	0.99390243902439	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32454979	32454979	PRJNA715462_P_NODE_35579_length_296_cov_1.031390_g34783_i0	PRJNA715462	35579	296	1.03139	3.0529144	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	46.6	0.0021	NR	NQY99292.1	2053517	g34783	i0	47.6	1.86486486486486	42	22	42.6	0	244	119	162	203	NQY99292.1 50S ribosomal protein L4 [Bdellovibrionales bacterium]	diamond	552	46.6	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);;