metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
1454150	1454150	PRJNA1063685_S_NODE_25022_length_466_cov_3.094148_g24482_i0	PRJNA1063685	25022	466	3.094148	14.41872968	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g24482	i0	96.97	0.130901287553648	33	0	7	1	174	206	2446139	2446170	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	61	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
2730002	2730002	PRJNA1063685_S_NODE_28443_length_440_cov_7.743869_g27902_i0	PRJNA1063685	28443	440	7.743869	34.0730236	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	564	4.419999999999999e-156	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g27902	i0	91.872	24.2772727272727	406	30	92	3	24	428	1293672	1294075	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	10682	564	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
6557390	6557390	PRJNA1063685_S_NODE_23926_length_474_cov_21.790524_g23386_i0	PRJNA1063685	23926	474	21.790524	103.28708376	Pigmentibacter sp. JX0631	2976982	Bacteria	Bacteria	329	1.9e-85	NTclustered	gi\|2496589869\|gb\|CP123622.1\|	2976982	g23386	i0	80.31	140.246835443038	452	75	94	14	30	474	369795	369351	Pigmentibacter sp. JX0631 chromosome, complete genome	blastn	66477	329	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter sp. JX0631
8665058	8665058	PRJNA1063685_S_NODE_26947_length_451_cov_7.645503_g26406_i0	PRJNA1063685	26947	451	7.645503	34.48121853	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	737	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g26406	i0	97.674	151.541019955654	430	8	95	1	24	451	575	1004	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	68345	739	0.997293640054127	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
9940031	9940031	PRJNA1063685_S_NODE_25628_length_461_cov_5.030928_g25088_i0	PRJNA1063685	25628	461	5.030928	23.19257808	Bdellovibrio	958	Bacteria	Bacteria	739	0	NTclustered	gi\|485099167\|ref\|NR_102561.1\|	959	g25088	i0	97.039	90.4902386117137	439	13	95	0	1	439	1590	1152	Bdellovibrio bacteriovorus strain Tiberius 23S ribosomal RNA gene, complete sequence	blastn	41716	739	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11658383	11658383	PRJNA1063685_S_NODE_64870_length_264_cov_4.109948_g64327_i0	PRJNA1063685	64870	264	4.109948	10.85026272	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	357	4.5599999999999997e-94	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g64327	i0	93.361	30.5606060606061	241	16	91	0	1	241	1292686	1292446	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	8068	357	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
15039513	15039513	PRJNA1063685_S_NODE_22592_length_485_cov_14.434466_g22052_i0	PRJNA1063685	22592	485	14.434466	70.0071601	Bacteriovorax	146784	Bacteria	Bacteria	837	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g22052	i0	98.523	209.861855670103	474	7	98	0	1	474	1660819	1660346	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	101783	837	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15039519	15039519	PRJNA1063685_S_NODE_23552_length_477_cov_10.995050_g23012_i0	PRJNA1063685	23552	477	10.99505	52.4463885	Bdellovibrio	958	Bacteria	Bacteria	344	6.839999999999999e-90	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g23012	i0	80.819	239.341719077568	464	68	95	16	1	455	783542	783091	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	114166	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
16756556	16756556	PRJNA1063685_S_NODE_43414_length_350_cov_5.815884_g42871_i0	PRJNA1063685	43414	350	5.815884	20.355594	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	534	2.69e-147	NTclustered	gi\|33521462\|gb\|AY338169.1\|	239744	g42871	i0	98.671	92.46	301	4	86	0	50	350	1	301	Uncultured Bdellovibrio sp. clone M13-72 16S ribosomal RNA gene, partial sequence	blastn	32361	534	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
20138497	20138497	PRJNA1063685_S_NODE_58276_length_286_cov_2.558685_g57733_i0	PRJNA1063685	58276	286	2.558685	7.3178391	Peredibacter	263370	Bacteria	Bacteria	449	8.02e-122	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g57733	i0	96.014	117.70979020979	276	11	97	0	2	277	510959	510684	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	33665	451	0.995565410199557	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20138564	20138564	PRJNA1063685_S_NODE_68836_length_253_cov_1.377778_g68293_i0	PRJNA1063685	68836	253	1.377778	3.48577834	Peredibacter	263370	Bacteria	Bacteria	394	3.309999999999999e-105	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g68293	i0	96.25	176.537549407115	240	9	95	0	12	251	512828	513067	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	44664	396	0.994949494949495	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23131914	23131914	PRJNA1063685_S_NODE_41699_length_359_cov_4.506993_g41156_i0	PRJNA1063685	41699	359	4.506993	16.18010487	Peredibacter starrii	28202	Bacteria	Bacteria	580	3.51e-161	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g41156	i0	97.917	111.289693593315	336	5	93	1	24	357	511841	512176	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	39953	580	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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