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

10 rows where analysis = "blastn", bioproject = "PRJNA474426" 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
4274406	4274406	PRJNA474426_P_NODE_14384_length_274_cov_2.142222_g14179_i0	PRJNA474426	14384	274	2.142222	5.86968828	Bacteriovorax stolpii	960	Bacteria	Bacteria	161	4.01e-35	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g14179	i0	79.757	2.67883211678832	247	31	89	10	21	263	1681660	1681429	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	734	161	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
5551122	5551122	PRJNA474426_P_NODE_24605_length_197_cov_1.378378_g24400_i0	PRJNA474426	24605	197	1.378378	2.71540466	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	139	1.27e-28	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g24400	i0	80.541	0.939086294416244	185	32	93	3	12	194	2686683	2686865	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	185	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
6200103	6200103	PRJNA474426_P_NODE_35805_length_163_cov_0.903509_g35600_i0	PRJNA474426	35805	163	0.903509	1.47271967	Bacteriovorax	146784	Bacteria	Bacteria	226	7.559999999999997e-55	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g35600	i0	92.453	47.2822085889571	159	10	96	2	6	162	135376	135218	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	7707	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
6825170	6825170	PRJNA474426_P_NODE_9926_length_341_cov_1.318493_g9721_i0	PRJNA474426	9926	341	1.318493	4.49606113	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	130	1.45e-25	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g9721	i0	85.385	7.3900293255132	130	13	38	6	39	166	74584	74459	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	2520	130	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8749776	8749776	PRJNA474426_P_NODE_18947_length_231_cov_1.076923_g18742_i0	PRJNA474426	18947	231	1.076923	2.48769213	Bdellovibrio	958	Bacteria	Bacteria	206	1.5e-48	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g18742	i0	85.354	10.4978354978355	198	29	86	0	24	221	1551073	1550876	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	2425	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
9375342	9375342	PRJNA474426_P_NODE_32048_length_168_cov_1.722689_g31843_i0	PRJNA474426	32048	168	1.722689	2.89411752	Bdellovibrio reynosensis	2835041	Bacteria	Bacteria	121	3.8099999999999996e-23	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g31843	i0	85.47	0.696428571428571	117	15	69	2	44	159	667035	666920	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	117	121	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
14476027	14476027	PRJNA474426_P_NODE_23852_length_201_cov_1.335526_g23647_i0	PRJNA474426	23852	201	1.335526	2.68440726	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	135	1.6900000000000003e-27	NTclustered	gi\|2313021230\|gb\|CP102930.1\|	959	g23647	i0	81.006	2.95522388059702	179	27	88	6	22	197	1774062	1774236	Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome	blastn	594	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17024751	17024751	PRJNA474426_P_NODE_23214_length_204_cov_2.845161_g23009_i0	PRJNA474426	23214	204	2.845161	5.80412844	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	163	7.88e-36	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g23009	i0	84	14.0882352941176	175	22	84	4	1	171	3566794	3566966	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	2874	163	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
19573247	19573247	PRJNA474426_P_NODE_21456_length_214_cov_2.321212_g21251_i0	PRJNA474426	21456	214	2.321212	4.96739368	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	267	6.18e-67	NTclustered	gi\|2663436448\|dbj\|AP029180.1\|	3113895	g21251	i0	92.105	0.88785046728972	190	14	88	1	1	189	741	552	Bdellovibrio sp. HAGR004 plasmid pBdHAGR4 DNA, complete sequence	blastn	190	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
23399727	23399727	PRJNA474426_P_NODE_27639_length_184_cov_1.570370_g27434_i0	PRJNA474426	27639	184	1.57037	2.8894808	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	156	1.16e-33	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g27434	i0	84.568	462.157608695652	162	20	87	5	20	179	658461	658303	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	85037	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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