metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA529241" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA529241" 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
499794	499794	PRJNA529241_P_NODE_283681_length_173_cov_3.786765_g281359_i0	PRJNA529241	283681	173	3.786765	6.55110345	Peredibacter starrii	28202	Bacteria	Bacteria	60.2	8.68e-5	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g281359	i0	88	0.289017341040462	50	6	29	0	98	147	447793	447842	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	50	60.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
502180	502180	PRJNA529241_P_NODE_580701_length_150_cov_3.442478_g578379_i0	PRJNA529241	580701	150	3.442478	5.163717	uncultured Bacteriovoracaceae bacterium	625924	Bacteria	Bacteria	71.3	3.37e-8	NTclustered	gi\|2874253651\|emb\|OY968777.1\|	625924	g578379	i0	90.566	0.353333333333333	53	5	35	0	81	133	950689	950637	MAG: uncultured Bacteriovoracaceae bacterium isolate MFD03250.bin.c.5 genome assembly, chromosome: 1	blastn	53	71.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		uncultured Bacteriovoracaceae bacterium
3051649	3051649	PRJNA529241_P_NODE_395083_length_173_cov_2.264706_g392761_i0	PRJNA529241	395083	173	2.264706	3.91794138	Peredibacter starrii	28202	Bacteria	Bacteria	113	6.5700000000000005e-21	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g392761	i0	93.421	0.867052023121387	76	5	44	0	98	173	113248	113173	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	150	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
4944467	4944467	PRJNA529241_P_NODE_506844_length_151_cov_4.578947_g504522_i0	PRJNA529241	506844	151	4.578947	6.91420997	Pseudomonadati	3379134	Bacteria	Bacteria	100	4.34e-17	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g504522	i0	80.916	6.4635761589404	131	21	87	3	19	149	2526187	2526061	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	976	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9428536	9428536	PRJNA529241_P_NODE_355408_length_173_cov_2.808824_g353086_i0	PRJNA529241	355408	173	2.808824	4.85926552	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	108	3.06e-19	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g353086	i0	92.105	1.92485549132948	76	6	44	0	1	76	3254770	3254695	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	333	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
9431001	9431001	PRJNA529241_P_NODE_90588_length_227_cov_2.052632_g88266_i0	PRJNA529241	90588	227	2.052632	4.65947464	Peredibacter starrii	28202	Bacteria	Bacteria	396	8.109999999999997e-106	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g88266	i0	98.238	19.3039647577093	227	3	100	1	1	227	512380	512155	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	4382	396	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15804948	15804948	PRJNA529241_P_NODE_63033_length_263_cov_1.035398_g60711_i0	PRJNA529241	63033	263	1.035398	2.72309674	Silvanigrella aquatica	1915309	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1114626566\|gb\|CP017834.1\|	1915309	g60711	i0	100	0.106463878326996	28	0	11	0	62	89	1012600	1012627	Silvanigrella aquatica strain MWH-Nonnen-W8red chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Silvanigrella	Silvanigrella aquatica
17077594	17077594	PRJNA529241_P_NODE_361094_length_173_cov_2.757353_g358772_i0	PRJNA529241	361094	173	2.757353	4.77022069	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	91.6	3.08e-14	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g358772	i0	88.158	0.439306358381503	76	9	44	0	98	173	1314264	1314189	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	76	91.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
18350489	18350489	PRJNA529241_P_NODE_176435_length_174_cov_3.846715_g174113_i0	PRJNA529241	176435	174	3.846715	6.6932841	Peredibacter starrii	28202	Bacteria	Bacteria	128	2.3599999999999997e-25	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g174113	i0	97.333	0.431034482758621	75	2	43	0	99	173	2756274	2756200	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	75	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20903798	20903798	PRJNA529241_P_NODE_516357_length_151_cov_4.105263_g514035_i0	PRJNA529241	516357	151	4.105263	6.19894713	Peredibacter starrii	28202	Bacteria	Bacteria	117	4.31e-22	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g514035	i0	95.833	0.95364238410596	72	3	48	0	5	76	489790	489861	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	144	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22176891	22176891	PRJNA529241_P_NODE_343158_length_173_cov_2.970588_g340836_i0	PRJNA529241	343158	173	2.970588	5.13911724	Peredibacter starrii	28202	Bacteria	Bacteria	99	1.84e-16	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g340836	i0	91.549	0.410404624277457	71	6	41	0	3	73	114396	114466	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	71	99	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);;