metadata: contig_metadata: 5 rows where bioproject = "PRJEB48872" and tax

5 rows where bioproject = "PRJEB48872" 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
20469178	20469178	PRJEB48872_P_NODE_223957_length_358_cov_1.275862_g208146_i0	PRJEB48872	223957	358	1.275862	4.56758596	Candidatus Methylomirabilis oxygeniifera	671143	Bacteria	Bacteria	298	3.94e-76	NTclustered	gi\|507148395\|ref\|NR_103198.1\|	671143	g208146	i0	82.386	122.396648044693	352	53	97	8	13	358	1148	1496	Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence	blastn	43818	298	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera
26716566	26716566	PRJEB48872_P_NODE_573281_length_174_cov_2.000000_g557469_i0	PRJEB48872	573281	174	2	3.48	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	58.2	5.51e-8	NR	RJQ27558.1	2762014	g557469	i0	49.1	0.948275862068966	55	28	94.8	0	171	7	6	60	RJQ27558.1 MAG: DEAD/DEAH box helicase [Candidatus Parcubacteria bacterium]	diamond	165	58.2	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
28644312	28644312	PRJEB48872_P_NODE_648127_length_159_cov_1.025000_g632315_i0	PRJEB48872	648127	159	1.025	1.62975	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	52.4	4.61e-6	NR	HOL54201.1	2053589	g632315	i0	49	0.962264150943396	51	26	96.2	0	155	3	118	168	HOL54201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	153	52.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31202078	31202078	PRJEB48872_P_NODE_546615_length_181_cov_1.154930_g530803_i0	PRJEB48872	546615	181	1.15493	2.0904233	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	107	5.38e-26	NR	HVX91236.1	2053589	g530803	i0	86.4	0.977900552486188	59	8	97.8	0	179	3	105	163	HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium]	diamond	177	107	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32563119	32563119	PRJEB48872_P_NODE_578339_length_173_cov_1.641791_g562527_i0	PRJEB48872	578339	173	1.641791	2.84029843	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	78.2	4.65e-15	NR	HZO80131.1	2785449	g562527	i0	75	2.93063583815029	56	14	97.1	0	6	173	786	841	HZO80131.1 cation-transporting P-type ATPase [Candidatus Binataceae bacterium]	diamond	507	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae 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);;