metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
1678872	1678872	PRJNA382357_P_NODE_57682_length_308_cov_1.578947_g56943_i0	PRJNA382357	57682	308	1.578947	4.86315676	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	115	3.62e-21	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g56943	i0	78.142	0.944805194805195	183	38	59	2	1	182	1714793	1714974	Bdellovibrio exovorus JSS, complete genome	blastn	291	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4231468	4231468	PRJNA382357_P_NODE_71224_length_281_cov_0.990909_g70485_i0	PRJNA382357	71224	281	0.990909	2.78445429	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	174	5.3e-39	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g70485	i0	93.22	1.00355871886121	118	8	99	0	161	278	3089495	3089612	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	282	174	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
5505970	5505970	PRJNA382357_P_NODE_100725_length_241_cov_3.088889_g99986_i0	PRJNA382357	100725	241	3.088889	7.44422249	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	215	2.61e-51	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g99986	i0	93.151	149.50622406639	146	10	92	0	96	241	3252711	3252856	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	36031	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
5507106	5507106	PRJNA382357_P_NODE_17965_length_516_cov_4.918681_g17235_i0	PRJNA382357	17965	516	4.918681	25.38039396	Peredibacter starrii	28202	Bacteria	Bacteria	486	1.17e-132	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g17235	i0	97.535	57.5833333333333	284	7	100	0	46	329	510956	511239	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	29713	486	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9330548	9330548	PRJNA382357_P_NODE_111168_length_231_cov_1.529412_g110429_i0	PRJNA382357	111168	231	1.529412	3.53294172	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	198	2.51e-46	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g110429	i0	94.531	129.017316017316	128	7	94	0	1	128	666547	666420	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	29803	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
9331693	9331693	PRJNA382357_P_NODE_3088_length_1068_cov_45.873883_g2561_i0	PRJNA382357	3088	1068	45.873883	489.93307044	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	525	5.319999999999999e-144	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g2561	i0	85.243	205.486891385768	515	70	96	6	437	950	3251038	3251547	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	219460	525	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
9332124	9332124	PRJNA382357_P_NODE_55608_length_313_cov_2.277778_g54869_i0	PRJNA382357	55608	313	2.277778	7.12944514	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	296	1.22e-75	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g54869	i0	87.795	365.115015974441	254	30	81	1	1	253	3446506	3446253	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	114281	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
13156220	13156220	PRJNA382357_P_NODE_112431_length_230_cov_1.153846_g111692_i0	PRJNA382357	112431	230	1.153846	2.6538458	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	226	1.1399999999999999e-54	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g111692	i0	84.581	0.98695652173913	227	35	99	0	3	229	2188996	2188770	Micavibrio aeruginosavorus EPB, complete genome	blastn	227	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
18254499	18254499	PRJNA382357_P_NODE_140795_length_208_cov_1.755102_g140056_i0	PRJNA382357	140795	208	1.755102	3.65061216	Peredibacter starrii	28202	Bacteria	Bacteria	200	6.149999999999998e-47	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g140056	i0	96.667	46.4230769230769	120	4	88	0	1	120	510872	510991	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9656	200	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18254725	18254725	PRJNA382357_P_NODE_157575_length_199_cov_47.913043_g156836_i0	PRJNA382357	157575	199	47.913043	95.34695557	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	235	1.5999999999999998e-57	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g156836	i0	100	1.55778894472362	127	0	78	0	40	166	2722610	2722484	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	310	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
20805471	20805471	PRJNA382357_P_NODE_48397_length_333_cov_2.275735_g47658_i0	PRJNA382357	48397	333	2.275735	7.57819755	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	429	1.2399999999999996e-115	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g47658	i0	90.244	170.993993993994	328	32	98	0	2	329	3251227	3250900	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	56941	429	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
23355257	23355257	PRJNA382357_P_NODE_160119_length_195_cov_2.305970_g159380_i0	PRJNA382357	160119	195	2.30597	4.4966415	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	119	1.6400000000000001e-22	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g159380	i0	81.818	12.7384615384615	143	24	73	2	1	142	3252280	3252139	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	2484	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
24628945	24628945	PRJNA382357_P_NODE_120960_length_222_cov_2.223602_g120221_i0	PRJNA382357	120960	222	2.223602	4.93639644	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	250	6.51e-62	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g120221	i0	88.152	199.45045045045	211	24	95	1	1	210	3446196	3446406	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	44278	250	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337

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