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

8 rows where bioproject = "PRJNA657343" and tax_clade = "Bacteria candidate phyla"

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_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8276722	8276722	PRJNA657343_S_NODE_13467_length_247_cov_3.070707_g13442_i0	PRJNA657343	13467	247	3.070707	7.58464629	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g13442	i0	94.57	81.1336032388664	221	12	89	0	24	244	964628	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	20040	342	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
21025361	21025361	PRJNA657343_P_NODE_17197_length_219_cov_2.388235_g17173_i0	PRJNA657343	17197	219	2.388235	5.23023465	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	126	3.1499999999999997e-35	NR	HRO65834.1	2099670	g17173	i0	82.6	1.89041095890411	69	12	94.5	0	212	6	15	83	HRO65834.1 uL15 family ribosomal protein [Candidatus Dojkabacteria bacterium]	diamond	414	126	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
22300417	22300417	PRJNA657343_P_NODE_40658_length_165_cov_0.896552_g40634_i0	PRJNA657343	40658	165	0.896552	1.4793108	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	291	2.69e-74	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g40634	i0	99.375	133.345454545455	160	1	97	0	3	162	222074	222233	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	22002	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
26713492	26713492	PRJNA657343_P_NODE_27801_length_184_cov_1.496296_g27777_i0	PRJNA657343	27801	184	1.496296	2.75318464	Bacillati	1783272	Bacteria	Bacteria	48.9	1.04e-4	NR	MBI3282903.1	2750075	g27777	i0	40.4	2.72282608695652	57	34	92.9	0	1	171	1	57	MBI3282903.1 ATP synthase F1 subunit gamma [Candidatus Curtissbacteria bacterium]	diamond	501	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota					Candidatus Curtissbacteria bacterium
27934224	27934224	PRJNA657343_P_NODE_26105_length_188_cov_1.899281_g26081_i0	PRJNA657343	26105	188	1.899281	3.57064828	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	73.2	2.22e-14	NR	MFA6159379.1	2053589	g26081	i0	63.3	0.957446808510638	60	20	95.7	1	186	7	88	145	MFA6159379.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	180	73.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28091990	28091990	PRJNA657343_P_NODE_13065_length_243_cov_1.309278_g13041_i0	PRJNA657343	13065	243	1.309278	3.18154554	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	121	2.91e-30	NR	NUP88512.1	2715255	g13041	i0	64.1	0.962962962962963	78	27	96.3	1	243	10	271	347	NUP88512.1 FAD-dependent oxidoreductase [Candidatus Sumerlaeia bacterium]	diamond	234	121	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
29575781	29575781	PRJNA657343_P_NODE_230_length_936_cov_8.133033_g224_i0	PRJNA657343	230	936	8.133033	76.12518888	Candidatus Chromulinivoraceae bacterium	2953759	Bacteria	Bacteria	77.4	3.04e-13	NR	HSW77891.1	2953759	g224	i0	35.3	1.73076923076923	133	77	42.6	3	250	648	33	156	HSW77891.1 TspO/MBR family protein [Candidatus Chromulinivoraceae bacterium]	diamond	1620	77.4	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae		Candidatus Chromulinivoraceae bacterium
30713222	30713222	PRJNA657343_P_NODE_1074_length_591_cov_5.673432_g1054_i0	PRJNA657343	1074	591	5.673432	33.52998312	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	78.2	6.78e-14	NR	HLJ30839.1	2803731	g1054	i0	33.6	0.771573604060914	152	80	71.1	4	589	170	73	215	HLJ30839.1 nuclear transport factor 2 family protein [Candidatus Babeliales bacterium]	diamond	456	78.2	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales 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);;