metadata: contig_metadata: 9 rows where bioproject = "PRJEB49404" and tax

9 rows where bioproject = "PRJEB49404" 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
100319	100319	PRJEB49404_P_NODE_284161_length_274_cov_2.195745_g270360_i0	PRJEB49404	284161	274	2.195745	6.0163413	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	159	7.689999999999999e-45	NR	HSR58777.1	2785449	g270360	i0	86.4	0.963503649635037	88	12	96.4	0	264	1	96	183	HSR58777.1 IS3 family transposase [Candidatus Binataceae bacterium]	diamond	264	159	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
15401871	15401871	PRJEB49404_P_NODE_266833_length_287_cov_1.512097_g253032_i0	PRJEB49404	266833	287	1.512097	4.33971839	Bacteria	2	Bacteria	Bacteria	99	9.15e-22	NR	MBN2206529.1	2052149	g253032	i0	58.4	6.47038327526132	89	37	93	0	20	286	304	392	MBN2206529.1 PAS domain S-box protein [Candidatus Aminicenantes bacterium]	diamond	1857	100	0.99	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
21783378	21783378	PRJEB49404_P_NODE_416738_length_207_cov_3.113095_g402937_i0	PRJEB49404	416738	207	3.113095	6.44410665	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	132	3.38e-35	NR	HVX91236.1	2053589	g402937	i0	91.2	3.94202898550725	68	6	98.6	0	2	205	188	255	HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium]	diamond	816	132	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29559667	29559667	PRJEB49404_P_NODE_305910_length_260_cov_1.769231_g292109_i0	PRJEB49404	305910	260	1.769231	4.6000006	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	72	7.6e-14	NR	HKN01053.1	2785449	g292109	i0	45.2	0.842307692307692	73	40	84.2	0	4	222	8	80	HKN01053.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	219	72	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30121456	30121456	PRJEB49404_P_NODE_236652_length_312_cov_2.699634_g222851_i0	PRJEB49404	236652	312	2.699634	8.42285808	Pseudomonadati	3379134	Bacteria	Bacteria	89	2.52e-18	NR	HVX91236.1	2053589	g222851	i0	78.9	1.70192307692308	57	10	52.9	1	312	148	305	361	HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium]	diamond	531	89.7	0.992196209587514	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31170716	31170716	PRJEB49404_P_NODE_225755_length_323_cov_1.880282_g211956_i0	PRJEB49404	225755	323	1.880282	6.07331086	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	193	5.279999999999999e-57	NR	HZC21821.1	2838779	g211956	i0	83.2	7.95046439628483	107	18	99.4	0	321	1	370	476	HZC21821.1 fucose isomerase [Candidatus Binatia bacterium]	diamond	2568	193	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31480831	31480831	PRJEB49404_P_NODE_352516_length_235_cov_1.255102_g338715_i0	PRJEB49404	352516	235	1.255102	2.9494897	Pseudomonadati	3379134	Bacteria	Bacteria	95.1	1.98e-21	NR	MEN9552163.1	2762014	g338715	i0	53.2	1.92765957446809	77	36	98.3	0	231	1	210	286	MEN9552163.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	453	95.1	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
31613730	31613730	PRJEB49404_P_NODE_617576_length_156_cov_1.401709_g603775_i0	PRJEB49404	617576	156	1.401709	2.18666604	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	69.3	4.59e-12	NR	HVN84295.1	2838779	g603775	i0	66	0.961538461538462	50	17	96.2	0	3	152	343	392	HVN84295.1 OprD family outer membrane porin [Candidatus Binatia bacterium]	diamond	150	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32113287	32113287	PRJEB49404_P_NODE_621238_length_155_cov_2.060345_g607437_i0	PRJEB49404	621238	155	2.060345	3.19353475	Bacteria	2	Bacteria	Bacteria	63.9	3.69e-10	NR	HSB71033.1	2032687	g607437	i0	62.7	1.89677419354839	51	19	98.7	0	154	2	147	197	HSB71033.1 C13 family peptidase [Candidatus Methylomirabilis sp.]	diamond	294	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.

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