metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
677071	677071	PRJNA695273_P_NODE_139281_length_247_cov_0.885057_g138523_i0	PRJNA695273	139281	247	0.885057	2.18609079	Bacteriovorax stolpii	960	Bacteria	Bacteria	375	1.1699999999999999e-99	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g138523	i0	94.286	2.96356275303644	245	14	99	0	1	245	3714349	3714593	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	732	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1182883	1182883	PRJNA695273_P_NODE_46641_length_397_cov_1.425926_g45883_i0	PRJNA695273	46641	397	1.425926	5.66092622	Bdellovibrio	958	Bacteria	Bacteria	701	0	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g45883	i0	98.489	88.5969773299748	397	6	100	0	1	397	784651	784255	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	35173	701	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
1952795	1952795	PRJNA695273_P_NODE_127902_length_250_cov_1.740113_g127144_i0	PRJNA695273	127902	250	1.740113	4.3502825	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g127144	i0	79.116	1.948	249	52	99	0	1	249	5137	4889	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	487	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
8331851	8331851	PRJNA695273_P_NODE_68827_length_332_cov_0.891892_g68069_i0	PRJNA695273	68827	332	0.891892	2.96108144	Bdellovibrio reynosensis	2835041	Bacteria	Bacteria	206	2.27e-48	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g68069	i0	78.086	1.97289156626506	324	71	98	0	4	327	84640	84963	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	655	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
9605500	9605500	PRJNA695273_P_NODE_138648_length_247_cov_0.885057_g137890_i0	PRJNA695273	138648	247	0.885057	2.18609079	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	285	2.02e-72	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g137890	i0	87.5	14.3886639676113	248	29	100	2	1	247	2824989	2825235	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	3554	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
9605895	9605895	PRJNA695273_P_NODE_156048_length_242_cov_0.911243_g155290_i0	PRJNA695273	156048	242	0.911243	2.20520806	Peredibacter starrii	28202	Bacteria	Bacteria	187	5.73e-43	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g155290	i0	81.659	0.946280991735537	229	38	94	2	16	242	936071	935845	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	229	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10882908	10882908	PRJNA695273_P_NODE_75709_length_317_cov_1.696721_g74951_i0	PRJNA695273	75709	317	1.696721	5.37860557	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g74951	i0	100	1	317	0	100	0	1	317	2589671	2589355	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	317	586	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
13431113	13431113	PRJNA695273_P_NODE_150531_length_244_cov_0.900585_g149773_i0	PRJNA695273	150531	244	0.900585	2.1974274	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	169	2.09e-37	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g149773	i0	83.158	35.9303278688525	190	26	77	6	3	189	3792850	3793036	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	8767	169	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
19803229	19803229	PRJNA695273_P_NODE_108676_length_270_cov_1.314721_g107918_i0	PRJNA695273	108676	270	1.314721	3.5497467	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	340	4.719999999999999e-89	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g107918	i0	89.455	268.207407407407	275	21	100	8	1	270	3447721	3447992	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	72416	340	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20308661	20308661	PRJNA695273_P_NODE_156396_length_242_cov_0.911243_g155638_i0	PRJNA695273	156396	242	0.911243	2.20520806	Bdellovibrio	958	Bacteria	Bacteria	268	1.99e-67	NTclustered	gi\|2313021230\|gb\|CP102930.1\|	959	g155638	i0	86.831	29.6942148760331	243	28	99	4	2	242	2251378	2251138	Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome	blastn	7186	268	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);;