metadata: contig_metadata: 10 rows where bioproject = "PRJNA1068830" and tax

10 rows where bioproject = "PRJNA1068830" 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_species
29183298	29183298	PRJNA1068830_P_NODE_23169_length_489_cov_1.963942_g22468_i0	PRJNA1068830	23169	489	1.963942	9.60367638	Candidatus Roizmanbacteria bacterium CG_4_1	2282149	Bacteria	Bacteria	46.6	0.0176	NR	PIY71633.1	1974826	g22468	i0	29.6	0.932515337423313	152	92	88.3	7	462	31	69	213	PIY71633.1 MAG: IMP dehydrogenase [Candidatus Roizmanbacteria bacterium CG_4_10_14_0_8_um_filter_33_9]	diamond	456	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG_4_10_14_0_8_um_filter_33_9
29341091	29341091	PRJNA1068830_P_NODE_31069_length_408_cov_3.641791_g30366_i0	PRJNA1068830	31069	408	3.641791	14.85850728	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	52.4	1.94e-5	NR	MFA4880568.1	2052150	g30366	i0	37.8	1.33088235294118	90	47	64	4	147	407	3	86	MFA4880568.1 dUTP diphosphatase [Candidatus Doudnabacteria bacterium]	diamond	543	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium
29341093	29341093	PRJNA1068830_P_NODE_45189_length_328_cov_1.482353_g44486_i0	PRJNA1068830	45189	328	1.482353	4.86211784	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	195	2.2000000000000008e-59	NR	RMD61734.1	2762014	g44486	i0	88.9	0.98780487804878	108	12	98.8	0	326	3	119	226	RMD61734.1 MAG: N4-gp56 family major capsid protein [Candidatus Parcubacteria bacterium]	diamond	324	195	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29751197	29751197	PRJNA1068830_P_NODE_39851_length_353_cov_0.828571_g39148_i0	PRJNA1068830	39851	353	0.828571	2.92485563	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	187	1.0799999999999998e-56	NR	MDO8340819.1	2026804	g39148	i0	80.4	0.909348441926346	107	21	90.9	0	351	31	186	292	MDO8340819.1 AAA family ATPase [Candidatus Woesebacteria bacterium]	diamond	321	187	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
29909510	29909510	PRJNA1068830_P_NODE_31171_length_408_cov_1.325373_g30468_i0	PRJNA1068830	31171	408	1.325373	5.40752184	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	55.1	1.18e-5	NR	HVX90321.1	2053589	g30468	i0	32.5	0.838235294117647	114	65	82.4	5	386	51	332	435	HVX90321.1 carbohydrate-binding protein [Candidatus Paceibacterota bacterium]	diamond	342	55.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30730792	30730792	PRJNA1068830_P_NODE_24554_length_473_cov_1.120000_g23853_i0	PRJNA1068830	24554	473	1.12	5.2976	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	173	3.71e-51	NR	MBX6334425.1	2026720	g23853	i0	67.5	0.799154334038055	126	40	79.9	1	378	1	6	130	MBX6334425.1 DUF2815 domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	378	173	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30857159	30857159	PRJNA1068830_P_NODE_24394_length_474_cov_2.553616_g23693_i0	PRJNA1068830	24394	474	2.553616	12.10413984	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	107	7.3e-26	NR	MCK9416830.1	2099670	g23693	i0	47	0.740506329113924	117	57	72.8	2	464	120	61	174	MCK9416830.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	351	107	1	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
31268050	31268050	PRJNA1068830_P_NODE_62975_length_274_cov_0.940299_g62272_i0	PRJNA1068830	62975	274	0.940299	2.57641926	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	145	2.39e-40	NR	RMD61734.1	2762014	g62272	i0	81.9	0.908759124087591	83	15	90.9	0	249	1	1	83	RMD61734.1 MAG: N4-gp56 family major capsid protein [Candidatus Parcubacteria bacterium]	diamond	249	145	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31615962	31615962	PRJNA1068830_P_NODE_88896_length_242_cov_0.923077_g88193_i0	PRJNA1068830	88896	242	0.923077	2.23384634	Candidatus Buchananbacteria bacterium	2268182	Bacteria	Bacteria	46.2	0.00216	NR	MBD3359655.1	2268182	g88193	i0	40	0.681818181818182	55	30	68.2	1	15	179	322	373	MBD3359655.1 hypothetical protein [Candidatus Buchananbacteria bacterium]	diamond	165	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Buchananiibacteriota	Candidatus Buchananbacteria bacterium
32153794	32153794	PRJNA1068830_P_NODE_24418_length_474_cov_1.980050_g23717_i0	PRJNA1068830	24418	474	1.98005	9.385437	Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_	2750075	Bacteria	Bacteria	45.4	0.0217	NR	OGD92854.1	1797712	g23717	i0	30.8	0.677215189873418	107	66	63.9	4	25	327	70	174	OGD92854.1 MAG: hypothetical protein A2697_05265 [Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_41_44]	diamond	321	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_41_44

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