metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
547644	547644	PRJNA564013_P_NODE_15321_length_918_cov_5.858810_g13309_i0	PRJNA564013	15321	918	5.85881	53.7838758	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	797	0	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g13309	i0	83.372	3.38562091503268	872	133	94	10	33	898	1433820	1432955	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	3108	797	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
1825450	1825450	PRJNA564013_P_NODE_260982_length_252_cov_12.010471_g258130_i0	PRJNA564013	260982	252	12.010471	30.26638692	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	375	1.1899999999999998e-99	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g258130	i0	99.515	1.04761904761905	206	1	82	0	24	229	2089798	2089593	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	264	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
4376555	4376555	PRJNA564013_P_NODE_217284_length_290_cov_2.480349_g214433_i0	PRJNA564013	217284	290	2.480349	7.1930121	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	490	4.799999999999999e-134	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g214433	i0	99.627	2.77241379310345	268	1	92	0	23	290	2676863	2677130	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	804	490	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
5654841	5654841	PRJNA564013_P_NODE_320105_length_213_cov_4.315789_g317253_i0	PRJNA564013	320105	213	4.315789	9.19263057	Peredibacter starrii	28202	Bacteria	Bacteria	285	1.7e-72	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g317253	i0	94.118	0.877934272300469	187	11	88	0	4	190	4039896	4039710	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	187	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10754688	10754688	PRJNA564013_P_NODE_28289_length_710_cov_26.919877_g25761_i0	PRJNA564013	28289	710	26.919877	191.1311267	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	1190	0	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g25761	i0	99.845	0.911267605633803	647	1	91	0	24	670	549388	548742	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	647	1190	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
13306796	13306796	PRJNA564013_P_NODE_71151_length_479_cov_3.124402_g68339_i0	PRJNA564013	71151	479	3.124402	14.96588558	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	774	0	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g68339	i0	99.763	1.75782881002088	422	1	88	0	21	442	1328123	1327702	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	842	774	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
14582025	14582025	PRJNA564013_P_NODE_95592_length_418_cov_3.224090_g92759_i0	PRJNA564013	95592	418	3.22409	13.4766962	Peredibacter starrii	28202	Bacteria	Bacteria	438	2.639999999999999e-118	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g92759	i0	89.368	2.75598086124402	348	37	83	0	25	372	1187367	1187020	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	1152	438	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15853286	15853286	PRJNA564013_P_NODE_290773_length_231_cov_4.205882_g287921_i0	PRJNA564013	290773	231	4.205882	9.71558742	Halobacteriovorax sp. BALOs_7	2109558	Bacteria	Bacteria	152	1.98e-32	NTclustered	gi\|1486380477\|gb\|CP027772.1\|	2109558	g287921	i0	83.851	550.831168831169	161	25	70	1	2	162	250261	250102	Halobacteriovorax sp. BALOs_7 chromosome, complete genome	blastn	127242	152	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp. BALOs_7
15855604	15855604	PRJNA564013_P_NODE_80873_length_451_cov_1.871795_g78047_i0	PRJNA564013	80873	451	1.871795	8.44179545	Peredibacter starrii	28202	Bacteria	Bacteria	294	6.58e-75	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g78047	i0	79.95	1.52771618625277	404	77	89	4	29	430	2295132	2294731	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	689	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17126716	17126716	PRJNA564013_P_NODE_210774_length_296_cov_2.604255_g207923_i0	PRJNA564013	210774	296	2.604255	7.7085948	Peredibacter starrii	28202	Bacteria	Bacteria	259	1.51e-64	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g207923	i0	85.484	0.837837837837838	248	36	84	0	24	271	2581082	2581329	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	248	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18403537	18403537	PRJNA564013_P_NODE_342275_length_203_cov_1.746479_g339423_i0	PRJNA564013	342275	203	1.746479	3.54535237	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	342	9.369999999999999e-90	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g339423	i0	97.044	7.74384236453202	203	6	100	0	1	203	2322866	2323068	Micavibrio aeruginosavorus EPB, complete genome	blastn	1572	342	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
19675442	19675442	PRJNA564013_P_NODE_206516_length_300_cov_3.029289_g203665_i0	PRJNA564013	206516	300	3.029289	9.087867	Bdellovibrio sp. ZAP7	2231053	Bacteria	Bacteria	440	5.099999999999998e-119	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g203665	i0	95.324	38.6466666666667	278	12	93	1	22	299	787378	787102	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	11594	440	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
22223558	22223558	PRJNA564013_P_NODE_106818_length_399_cov_17.295858_g103979_i0	PRJNA564013	106818	399	17.295858	69.01047342	Pigmentibacter sp. JX0631	2976982	Bacteria	Bacteria	230	1.6499999999999996e-55	NTclustered	gi\|2496589869\|gb\|CP123622.1\|	2976982	g103979	i0	77.807	2.99498746867168	374	82	93	1	19	391	673505	673878	Pigmentibacter sp. JX0631 chromosome, complete genome	blastn	1195	230	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter sp. JX0631
23499811	23499811	PRJNA564013_P_NODE_142259_length_359_cov_2.191275_g139410_i0	PRJNA564013	142259	359	2.191275	7.86667725	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	311	5.08e-80	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g139410	i0	83.533	1.73259052924791	334	53	93	2	7	339	369904	370236	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	622	311	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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