metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA550047" 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
3065598	3065598	PRJNA550047_P_NODE_298823_length_297_cov_10.281250_g296854_i0	PRJNA550047	298823	297	10.28125	30.5353125	uncultured Oligoflexales bacterium	2735263	Bacteria	Bacteria	176	1.57e-39	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g296854	i0	87.662	123.097643097643	154	15	51	4	147	297	955964	956116	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	36560	176	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
5618817	5618817	PRJNA550047_P_NODE_323125_length_294_cov_4.194570_g321155_i0	PRJNA550047	323125	294	4.19457	12.3320358	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	215	3.29e-51	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g321155	i0	80.496	3.58163265306122	282	53	96	2	12	292	1044116	1043836	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	1053	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6225932	6225932	PRJNA550047_P_NODE_590405_length_201_cov_4.992188_g588432_i0	PRJNA550047	590405	201	4.992188	10.03429788	Bdellovibrio	958	Bacteria	Bacteria	174	3.58e-39	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g588432	i0	83.871	76.4676616915423	186	26	92	4	1	184	3058838	3059021	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	15370	174	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8775244	8775244	PRJNA550047_P_NODE_598607_length_198_cov_12.920000_g596634_i0	PRJNA550047	598607	198	12.92	25.5816	Peredibacter	263370	Bacteria	Bacteria	348	1.95e-91	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g596634	i0	98.477	96.8434343434343	197	3	99	0	1	197	512880	513076	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	19175	348	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11992778	11992778	PRJNA550047_P_NODE_231830_length_301_cov_5.460526_g229861_i0	PRJNA550047	231830	301	5.460526	16.43618326	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	134	9.72e-27	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g229861	i0	87.395	0.395348837209302	119	12	39	3	1	118	3251757	3251641	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	119	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
15815285	15815285	PRJNA550047_P_NODE_111453_length_345_cov_7.444853_g109493_i0	PRJNA550047	111453	345	7.444853	25.68474285	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	113	1.48e-20	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g109493	i0	81.618	0.666666666666667	136	25	39	0	13	148	2941147	2941282	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	230	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15817649	15817649	PRJNA550047_P_NODE_310493_length_296_cov_4.049327_g308524_i0	PRJNA550047	310493	296	4.049327	11.98600792	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	150	9.469999999999999e-32	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g308524	i0	92.523	0.722972972972973	107	5	35	3	15	118	3401396	3401502	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	214	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
17096465	17096465	PRJNA550047_P_NODE_93934_length_345_cov_9.033088_g91974_i0	PRJNA550047	93934	345	9.033088	31.1641536	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	128	5.27e-25	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g91974	i0	83.453	11.3536231884058	139	21	40	2	198	335	1068445	1068308	Micavibrio aeruginosavorus EPB, complete genome	blastn	3917	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
18367622	18367622	PRJNA550047_P_NODE_399675_length_265_cov_6.947917_g397703_i0	PRJNA550047	399675	265	6.947917	18.41198005	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	309	1.3e-79	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g397703	i0	87.879	1.97358490566038	264	30	99	2	3	265	92568	92306	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	523	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
20918031	20918031	PRJNA550047_P_NODE_396157_length_266_cov_12.031088_g394185_i0	PRJNA550047	396157	266	12.031088	32.00269408	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	464	2.64e-126	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g394185	i0	98.12	1	266	5	100	0	1	266	788335	788070	Micavibrio aeruginosavorus EPB, complete genome	blastn	266	464	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
21522694	21522694	PRJNA550047_P_NODE_259237_length_300_cov_5.436123_g257268_i0	PRJNA550047	259237	300	5.436123	16.308369	Bdellovibrio	958	Bacteria	Bacteria	97.1	1.27e-15	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g257268	i0	90.411	0.486666666666667	73	7	24	0	221	293	1181072	1181144	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	146	97.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22191489	22191489	PRJNA550047_P_NODE_296498_length_297_cov_15.785714_g294529_i0	PRJNA550047	296498	297	15.785714	46.88357058	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	119	2.68e-22	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g294529	i0	94.737	27.5387205387205	76	4	26	0	222	297	61783	61858	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	8179	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
24074068	24074068	PRJNA550047_P_NODE_554419_length_212_cov_8.892086_g552446_i0	PRJNA550047	554419	212	8.892086	18.85122232	Pseudomonadati	3379134	Bacteria	Bacteria	239	1.33e-58	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g552446	i0	87.5	180.278301886792	208	24	98	2	6	212	658671	658465	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	38219	239	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
24743504	24743504	PRJNA550047_P_NODE_514000_length_226_cov_5.143791_g512027_i0	PRJNA550047	514000	226	5.143791	11.62496766	Peredibacter starrii	28202	Bacteria	Bacteria	372	1.36e-98	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g512027	i0	96.444	11.5176991150442	225	8	99	0	2	226	512412	512188	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	2603	372	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25347767	25347767	PRJNA550047_P_NODE_415520_length_259_cov_6.166667_g413548_i0	PRJNA550047	415520	259	6.166667	15.97166753	Bdellovibrio	958	Bacteria	Bacteria	195	3.7e-45	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g413548	i0	88.485	3.95752895752896	165	14	63	5	94	256	2018744	2018905	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	1025	195	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);;