metadata: contig_metadata: 12 rows where bioproject = "PRJNA572587" and tax

12 rows where bioproject = "PRJNA572587" 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
5662848	5662848	PRJNA572587_P_NODE_46725_length_161_cov_3.196429_g46397_i0	PRJNA572587	46725	161	3.196429	5.14625069	Peredibacter	263370	Bacteria	Bacteria	75.9	1.53e-14	NR	WP_321389441.1	28202	g46397	i0	76.7	1.60248447204969	43	10	80.1	0	159	31	158	200	WP_321389441.1 hypothetical protein [Peredibacter starrii]	diamond	258	76.3	0.99475753604194	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10064499	10064499	PRJNA572587_P_NODE_34428_length_188_cov_9.381295_g34100_i0	PRJNA572587	34428	188	9.381295	17.6368346	Peredibacter	263370	Bacteria	Bacteria	254	4.12e-63	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g34100	i0	95.57	156.744680851064	158	7	84	0	31	188	512935	513092	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	29468	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15861269	15861269	PRJNA572587_P_NODE_11773_length_341_cov_94.876712_g11445_i0	PRJNA572587	11773	341	94.876712	323.52958792	Peredibacter starrii	28202	Bacteria	Bacteria	492	1.5999999999999996e-134	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11445	i0	97.895	25.3049853372434	285	5	84	1	35	319	512499	512216	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	8629	492	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
24088003	24088003	PRJNA572587_P_NODE_5159_length_557_cov_135.421260_g4843_i0	PRJNA572587	5159	557	135.42126	754.2964182	Peredibacter	263370	Bacteria	Bacteria	863	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4843	i0	97.988	95.9228007181328	497	10	89	0	38	534	511180	510684	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	53429	869	0.993095512082854	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
24784989	24784989	PRJNA572587_P_NODE_21040_length_246_cov_15.918782_g20712_i0	PRJNA572587	21040	246	15.918782	39.16020372	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g20712	i0	91.892	84.0569105691057	222	18	90	0	25	246	1292537	1292758	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	20678	311	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
28153556	28153556	PRJNA572587_P_NODE_31065_length_199_cov_11.213333_g30737_i0	PRJNA572587	31065	199	11.213333	22.31453267	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	53.5	3.17e-6	NR	MEO5668519.1	3034175	g30737	i0	42.4	1.98994974874372	66	36	98	2	199	5	29	93	MEO5668519.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	396	53.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29573979	29573979	PRJNA572587_P_NODE_35310_length_185_cov_23.566176_g34982_i0	PRJNA572587	35310	185	23.566176	43.5974256	Bdellovibrionales bacterium GWB1_55_8	1797386	Bacteria	Bacteria	67.4	2.98e-11	NR	OFZ20096.1	1797386	g34982	i0	64.3	1.81621621621622	56	20	90.8	0	3	170	262	317	OFZ20096.1 MAG: hypothetical protein A2X94_09300 [Bdellovibrionales bacterium GWB1_55_8]	diamond	336	67.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWB1_55_8
30061324	30061324	PRJNA572587_P_NODE_29331_length_205_cov_11.916667_g29003_i0	PRJNA572587	29331	205	11.916667	24.42916735	Bdellovibrio	958	Bacteria	Bacteria	84	3.85e-19	NR	WP_142697577.1	2220073	g29003	i0	68.4	2.50243902439024	57	18	83.4	0	195	25	45	101	WP_142697577.1 polyhydroxyalkanoic acid system family protein [Bdellovibrio sp. NC01]	diamond	513	84	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
30269343	30269343	PRJNA572587_P_NODE_16072_length_286_cov_5.443038_g15744_i0	PRJNA572587	16072	286	5.443038	15.56708868	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	67	1.88e-10	NR	HLD99388.1	3034175	g15744	i0	58.8	1.04895104895105	51	21	53.5	0	210	58	744	794	HLD99388.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	300	67	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31768190	31768190	PRJNA572587_P_NODE_7617_length_440_cov_200.370844_g7292_i0	PRJNA572587	7617	440	200.370844	881.6317136	Peredibacter	263370	Bacteria	Bacteria	108	3.62e-24	NR	WP_321394767.1	28202	g7292	i0	72.4	1.76590909090909	87	22	58	1	283	29	102	188	WP_321394767.1 TrkH family potassium uptake protein [Peredibacter starrii]	diamond	777	109	0.990825688073395	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
31912821	31912821	PRJNA572587_P_NODE_18857_length_262_cov_3.497653_g18529_i0	PRJNA572587	18857	262	3.497653	9.16385086	Oligoflexales bacterium	2687297	Bacteria	Bacteria	50.4	3.45e-5	NR	MBF0443082.1	2687297	g18529	i0	34.3	0.767175572519084	67	25	55	1	118	261	51	117	MBF0443082.1 hypothetical protein [Oligoflexales bacterium]	diamond	201	50.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
32545853	32545853	PRJNA572587_P_NODE_22019_length_240_cov_83.162304_g21691_i0	PRJNA572587	22019	240	83.162304	199.5895296	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	89	1.97e-18	NR	WP_063205553.1	959	g21691	i0	50.7	2.7375	73	36	91.3	0	22	240	30	102	WP_063205553.1 replication restart helicase PriA [Bdellovibrio bacteriovorus]	diamond	657	89	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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