metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB55250" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB55250" 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
7774262	7774262	PRJEB55250_P_NODE_4727_length_322_cov_1.293173_g4603_i0	PRJEB55250	4727	322	1.293173	4.16401706	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	556	5.25e-154	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g4603	i0	97.826	198.717391304348	322	7	100	0	1	322	660312	660633	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	63987	556	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
17973369	17973369	PRJEB55250_P_NODE_16335_length_241_cov_1.732143_g16211_i0	PRJEB55250	16335	241	1.732143	4.17446463	Bacteriovorax stolpii	960	Bacteria	Bacteria	375	1.1299999999999998e-99	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g16211	i0	94.979	2.98340248962656	239	12	99	0	1	239	1109992	1110230	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	719	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18843466	18843466	PRJEB55250_P_NODE_2335_length_428_cov_2.157746_g2212_i0	PRJEB55250	2335	428	2.157746	9.23515288	Peredibacter	263370	Bacteria	Bacteria	669	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2212	i0	94.86	190.707943925234	428	22	100	0	1	428	511270	511697	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	81623	675	0.991111111111111	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21393981	21393981	PRJEB55250_P_NODE_5777_length_298_cov_2.791111_g5653_i0	PRJEB55250	5777	298	2.791111	8.31751078	Bacteriovorax	146784	Bacteria	Bacteria	507	4.92e-139	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g5653	i0	97.315	307.456375838926	298	8	100	0	1	298	1660838	1660541	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	91622	507	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
24347679	24347679	PRJEB55250_P_NODE_4560_length_326_cov_3.624506_g4436_i0	PRJEB55250	4560	326	3.624506	11.81588956	Peredibacter starrii	28202	Bacteria	Bacteria	553	6.889999999999998e-153	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4436	i0	97.531	27.8374233128834	324	7	99	1	3	326	512477	512155	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9075	553	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);;