metadata: contig_metadata: 8 rows where bioproject = "PRJEB6584" and tax

8 rows where bioproject = "PRJEB6584" 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
26024121	26024121	PRJEB6584e_S_NODE_932_length_264_cov_4.799127_g917_i0	PRJEB6584	932	264	4.799127	12.66969528	Bacteriovorax	146784	Bacteria	Bacteria	250	7.97e-62	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g917	i0	83.895	261.477272727273	267	37	100	6	1	264	1660672	1660409	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	69030	250	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26160551	26160551	PRJEB6584o_S_NODE_16061_length_221_cov_6.306452_g15953_i0	PRJEB6584	16061	221	6.306452	13.93725892	Bacteriovorax	146784	Bacteria	Bacteria	339	1.34e-88	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g15953	i0	97.475	195.79185520362	198	5	92	0	1	198	1661450	1661647	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	43270	339	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26296133	26296133	PRJEB6584k_S_NODE_1406_length_241_cov_5.140777_g1385_i0	PRJEB6584	1406	241	5.140777	12.38927257	Bacteriovorax	146784	Bacteria	Bacteria	204	5.66e-48	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1385	i0	83.043	284.547717842324	230	33	94	6	1	227	1660436	1660662	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	68576	204	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26296256	26296256	PRJEB6584o_S_NODE_1150_length_566_cov_27.033898_g1084_i0	PRJEB6584	1150	566	27.033898	153.01186268	Bacteriovorax	146784	Bacteria	Bacteria	525	2.739999999999999e-144	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1084	i0	86.089	151.925795053004	496	60	87	9	17	507	1660838	1660347	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	85990	525	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26432095	26432095	PRJEB6584i_S_NODE_127_length_485_cov_28.084444_g117_i0	PRJEB6584	127	485	28.084444	136.2095534	Bacteriovorax	146784	Bacteria	Bacteria	520	1.08e-142	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g117	i0	86.094	188.835051546392	489	60	100	8	1	485	1660830	1660346	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	91585	520	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26432104	26432104	PRJEB6584j_S_NODE_103_length_507_cov_65.993644_g78_i0	PRJEB6584	103	507	65.993644	334.58777508	Bacteriovorax	146784	Bacteria	Bacteria	497	5.3e-136	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g78	i0	86.111	146.07100591716	468	57	92	8	24	487	1660347	1660810	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	74058	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26477186	26477186	PRJEB6584o_S_NODE_18416_length_209_cov_4.178161_g18308_i0	PRJEB6584	18416	209	4.178161	8.73235649	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	270	4.65e-68	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g18308	i0	90	131.8995215311	210	19	100	2	1	209	778305	778097	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	27567	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32963447	32963447	PRJEB6584h_S_NODE_12290_length_194_cov_1.949686_g12228_i0	PRJEB6584	12290	194	1.949686	3.78239084	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	39.3	0.0467	NR	MBK9322320.1	2026715	g12228	i0	51.5	0.510309278350515	33	16	51	0	18	116	20	52	MBK9322320.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	99	39.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium

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