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

5 rows where bioproject = "PRJNA683902" 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_genus	tax_species
17243233	17243233	PRJNA683902_S_NODE_26314_length_195_cov_3.379747_g25870_i0	PRJNA683902	26314	195	3.379747	6.59050665	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	296	7.05e-76	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g25870	i0	96.648	60.7230769230769	179	4	91	2	18	195	221725	221548	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	11841	296	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17243330	17243330	PRJNA683902_S_NODE_38414_length_153_cov_3.629310_g37970_i0	PRJNA683902	38414	153	3.62931	5.5528443	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	246	5.36e-61	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g37970	i0	97.241	110.450980392157	145	4	95	0	1	145	220544	220688	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	16899	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
30272042	30272042	PRJNA683902_S_NODE_31772_length_172_cov_2.022222_g31328_i0	PRJNA683902	31772	172	2.022222	3.47822184	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	57.8	6.88e-8	NR	HWT14552.1	2052139	g31328	i0	49.1	7.5	55	28	95.9	0	167	3	607	661	HWT14552.1 Ig-like domain-containing protein [Patescibacteria group bacterium]	diamond	1290	57.8	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
30682300	30682300	PRJNA683902_S_NODE_2853_length_1498_cov_9.131417_g2678_i0	PRJNA683902	2853	1498	9.131417	136.78862666	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	75.5	1.69e-10	NR	MEK7538632.1	2052139	g2678	i0	24.4	0.500667556742323	250	173	48.5	7	1115	390	132	373	MEK7538632.1 hypothetical protein [Patescibacteria group bacterium]	diamond	750	75.5	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
31978731	31978731	PRJNA683902_S_NODE_36998_length_157_cov_1.300000_g36554_i0	PRJNA683902	36998	157	1.3	2.041	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	50.4	2.22e-5	NR	MDR3571461.1	2053589	g36554	i0	50	0.917197452229299	48	24	91.7	0	150	7	110	157	MDR3571461.1 NACHT domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	144	50.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota 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);;