metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA615175" 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
4977988	4977988	PRJNA615175_P_NODE_33464_length_243_cov_1.811765_g33296_i0	PRJNA615175	33464	243	1.811765	4.40258895	Bdellovibrio	958	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g33296	i0	99.177	88.3456790123457	243	2	100	0	1	243	816610	816368	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	21468	438	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6973365	6973365	PRJNA615175_P_NODE_23806_length_280_cov_1.961353_g23638_i0	PRJNA615175	23806	280	1.961353	5.4917884	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	374	4.849999999999998e-99	NTclustered	gi\|2593445765\|gb\|OR698905.1\|	2972972	g23638	i0	98.131	74.1071428571429	214	4	76	0	67	280	2	215	Bdellovibrio svalbardensis 16S ribosomal RNA gene, partial sequence	blastn	20750	374	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis
6973670	6973670	PRJNA615175_P_NODE_9646_length_474_cov_2.501247_g9478_i0	PRJNA615175	9646	474	2.501247	11.85591078	Peredibacter starrii	28202	Bacteria	Bacteria	822	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9478	i0	97.899	184.835443037975	476	8	100	2	1	474	512105	511630	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	87612	822	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9523215	9523215	PRJNA615175_P_NODE_16048_length_351_cov_2.755396_g15880_i0	PRJNA615175	16048	351	2.755396	9.67143996	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	267	1.09e-66	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g15880	i0	80.508	5.02849002849003	354	63	100	6	1	351	1666763	1667113	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	1765	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
10799467	10799467	PRJNA615175_P_NODE_6189_length_613_cov_4.700000_g6024_i0	PRJNA615175	6189	613	4.7	28.811	Peredibacter starrii	28202	Bacteria	Bacteria	595	2.2399999999999995e-165	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g6024	i0	84.202	61.4942903752039	614	95	100	2	1	613	3613644	3614256	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	37696	595	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12074062	12074062	PRJNA615175_P_NODE_11950_length_417_cov_1.613372_g11782_i0	PRJNA615175	11950	417	1.613372	6.72776124	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	675	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g11782	i0	98.187	69.599520383693	386	7	93	0	1	386	1292645	1292260	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	29023	675	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
16452652	16452652	PRJNA615175_P_NODE_9693_length_473_cov_2.107500_g9525_i0	PRJNA615175	9693	473	2.1075	9.968475	Peredibacter	263370	Bacteria	Bacteria	809	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9525	i0	97.665	189.30866807611	471	11	99	0	1	471	511640	511170	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	89543	809	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20276193	20276193	PRJNA615175_P_NODE_15896_length_353_cov_2.171429_g15728_i0	PRJNA615175	15896	353	2.171429	7.66514437	Bdellovibrio	958	Bacteria	Bacteria	294	5.02e-75	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g15728	i0	81.766	1.98016997167139	351	64	99	0	3	353	2216376	2216026	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	699	294	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);;