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

5 rows where analysis = "blastn", bioproject = "PRJNA716463" 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
7086544	7086544	PRJNA716463_P_NODE_35106_length_299_cov_3.703540_g34689_i0	PRJNA716463	35106	299	3.70354	11.0735846	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	86.1	2.74e-12	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g34689	i0	96.154	38.0434782608696	52	2	17	0	248	299	1475640	1475691	Bacteriovorax sp. HI3 DNA, complete genome	blastn	11375	86.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
10121710	10121710	PRJNA716463_P_NODE_92708_length_258_cov_1.664865_g92291_i0	PRJNA716463	92708	258	1.664865	4.2953517	Bacteriovorax	146784	Bacteria	Bacteria	399	7.279999999999998e-107	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g92291	i0	95.238	202.651162790698	252	12	98	0	2	253	1662186	1661935	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	52284	399	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
14737605	14737605	PRJNA716463_P_NODE_8412_length_395_cov_4.369565_g7999_i0	PRJNA716463	8412	395	4.369565	17.25978175	Peredibacter starrii	28202	Bacteria	Bacteria	531	3.9799999999999996e-146	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7999	i0	90.977	155.086075949367	399	28	99	6	1	394	511852	512247	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	61259	531	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17285715	17285715	PRJNA716463_P_NODE_22014_length_310_cov_3.375527_g21597_i0	PRJNA716463	22014	310	3.375527	10.4641337	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	178	4.58e-40	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g21597	i0	88	13.6935483870968	150	18	48	0	1	150	54867	55016	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	4245	178	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
19835111	19835111	PRJNA716463_P_NODE_5896_length_445_cov_11.704301_g5487_i0	PRJNA716463	5896	445	11.704301	52.08413945	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	702	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g5487	i0	95.455	158.898876404494	440	20	99	0	1	440	1293006	1292567	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	70710	702	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198

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);;