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

12 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
4545900	4545900	PRJNA734348_P_NODE_139984_length_232_cov_2.855346_g139286_i0	PRJNA734348	139984	232	2.855346	6.62440272	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	237	5.34e-58	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g139286	i0	86.301	14.0387931034483	219	28	94	2	3	220	1477375	1477592	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	3257	237	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
4546555	4546555	PRJNA734348_P_NODE_35984_length_325_cov_2.138889_g35288_i0	PRJNA734348	35984	325	2.138889	6.95138925	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	196	1.33e-45	NTclustered	gi\|2907625691\|emb\|OZ223251.1\|	2081706	g35288	i0	82.96	2.29230769230769	223	32	68	5	16	235	90929	90710	MAG: Bacteriovoracaceae bacterium isolate 56684ba0-df17-47c9-bcf5-ee076427a4fa genome assembly, chromosome: 1	blastn	745	196	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
6301619	6301619	PRJNA734348_P_NODE_89845_length_252_cov_2.184358_g89147_i0	PRJNA734348	89845	252	2.184358	5.50458216	Pseudobdellovibrio	2862745	Bacteria	Bacteria	366	7.19e-97	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g89147	i0	92.857	150.535714285714	252	18	100	0	1	252	309	58	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	37935	366	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
7095512	7095512	PRJNA734348_P_NODE_106246_length_247_cov_2.385057_g105548_i0	PRJNA734348	106246	247	2.385057	5.89109079	Peredibacter starrii	28202	Bacteria	Bacteria	198	2.71e-46	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g105548	i0	82.174	0.931174089068826	230	41	93	0	1	230	3020853	3021082	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	230	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8370894	8370894	PRJNA734348_P_NODE_150327_length_197_cov_6.338710_g149629_i0	PRJNA734348	150327	197	6.33871	12.4872587	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	224	3.419999999999999e-54	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g149629	i0	87.629	0.984771573604061	194	22	98	2	4	196	1628326	1628134	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	194	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
9646155	9646155	PRJNA734348_P_NODE_18388_length_477_cov_5.200495_g17698_i0	PRJNA734348	18388	477	5.200495	24.80636115	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	525	2.2799999999999993e-144	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g17698	i0	87.257	169.218029350105	463	56	97	3	14	474	468673	469134	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	80717	525	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
12677223	12677223	PRJNA734348_P_NODE_9950_length_748_cov_2.942222_g9330_i0	PRJNA734348	9950	748	2.942222	22.00782056	Peredibacter	263370	Bacteria	Bacteria	1330	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9330	i0	98.795	139.331550802139	747	9	99	0	2	748	510761	511507	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	104220	1330	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15226040	15226040	PRJNA734348_P_NODE_77232_length_263_cov_1.526316_g76534_i0	PRJNA734348	77232	263	1.526316	4.01421108	Bacteriovorax	146784	Bacteria	Bacteria	398	2.6799999999999995e-106	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g76534	i0	93.916	3	263	16	100	0	1	263	3564996	3564734	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	789	401	0.992518703241895	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16020550	16020550	PRJNA734348_P_NODE_29433_length_358_cov_3.933333_g28737_i0	PRJNA734348	29433	358	3.933333	14.08133214	Peredibacter starrii	28202	Bacteria	Bacteria	641	1.5799999999999994e-179	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g28737	i0	98.889	192.513966480447	360	2	100	1	1	358	511798	512157	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	68920	641	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17295931	17295931	PRJNA734348_P_NODE_24634_length_395_cov_1.732919_g23939_i0	PRJNA734348	24634	395	1.732919	6.84503005	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	235	3.5e-57	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g23939	i0	78.515	177.448101265823	377	67	94	13	1	372	1292934	1293301	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	70092	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
19048905	19048905	PRJNA734348_P_NODE_26275_length_380_cov_6.260586_g25580_i0	PRJNA734348	26275	380	6.260586	23.7902268	Peredibacter	263370	Bacteria	Bacteria	641	1.69e-179	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g25580	i0	97.105	149.884210526316	380	11	100	0	1	380	512610	512231	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	56956	641	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25423796	25423796	PRJNA734348_P_NODE_29860_length_356_cov_1.618375_g29164_i0	PRJNA734348	29860	356	1.618375	5.761415	Bdellovibrio	958	Bacteria	Bacteria	263	1.43e-65	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g29164	i0	81.176	29.0224719101124	340	53	94	11	19	353	784625	784292	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	10332	263	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);;