metadata: contig_metadata: 11 rows where bioproject = "PRJNA1245487" and tax

11 rows where bioproject = "PRJNA1245487" 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_genus	tax_species
2901888	2901888	PRJNA1245487_P_NODE_14623_length_296_cov_2.582960_g14285_i0	PRJNA1245487	14623	296	2.58296	7.6455616	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	189	1.26e-60	NR	HRN86952.1	2099670	g14285	i0	100	0.932432432432432	92	0	93.2	0	21	296	1	92	HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	276	189	1	Bacteria	Bacteria candidate phyla				Candidatus Dojkabacteria bacterium
9279431	9279431	PRJNA1245487_P_NODE_7348_length_455_cov_1.628272_g7012_i0	PRJNA1245487	7348	455	1.628272	7.4086376	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	270	1.12e-67	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g7012	i0	81.493	74.9010989010989	335	57	73	5	23	355	4745871	4745540	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	34080	270	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota			uncultured Methylomirabilota bacterium
13104960	13104960	PRJNA1245487_P_NODE_16771_length_273_cov_1.970000_g16433_i0	PRJNA1245487	16771	273	1.97	5.3781	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	466	7.55e-127	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g16433	i0	97.455	255.490842490842	275	3	100	4	1	273	963815	963543	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	69749	466	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium
16928354	16928354	PRJNA1245487_P_NODE_21674_length_243_cov_0.917647_g21336_i0	PRJNA1245487	21674	243	0.917647	2.22988221	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	387	5.29e-103	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g21336	i0	95.473	100.197530864198	243	10	99	1	1	242	597317	597075	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	24348	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
18202929	18202929	PRJNA1245487_P_NODE_9495_length_390_cov_4.678233_g9157_i0	PRJNA1245487	9495	390	4.678233	18.2451087	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	171	2.16e-52	NR	HRN86953.1	2099670	g9157	i0	98.8	0.653846153846154	85	1	65.4	0	389	135	25	109	HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	255	171	1	Bacteria	Bacteria candidate phyla				Candidatus Dojkabacteria bacterium
18902797	18902797	PRJNA1245487_P_NODE_14655_length_296_cov_1.573991_g14317_i0	PRJNA1245487	14655	296	1.573991	4.65901336	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	455	1.7900000000000002e-123	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g14317	i0	94.595	163.277027027027	296	12	100	3	1	296	220428	220719	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	48330	457	0.99562363238512	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
23303537	23303537	PRJNA1245487_P_NODE_23019_length_227_cov_3.571429_g22681_i0	PRJNA1245487	23019	227	3.571429	8.10714383	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	363	8.219999999999999e-96	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g22681	i0	95.595	143.145374449339	227	8	99	2	2	227	678454	678229	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	32494	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia		Candidatus Saccharimonadia bacterium
28084195	28084195	PRJNA1245487_P_NODE_19645_length_251_cov_0.876404_g19307_i0	PRJNA1245487	19645	251	0.876404	2.19977404	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	45.4	0.00314	NR	MDE1946233.1	2052139	g19307	i0	40	1.07569721115538	45	27	53.8	0	241	107	16	60	MDE1946233.1 hypothetical protein [Patescibacteria group bacterium]	diamond	270	45.4	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
28936856	28936856	PRJNA1245487_P_NODE_23568_length_199_cov_9.087302_g23230_i0	PRJNA1245487	23568	199	9.087302	18.08373098	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	42.7	0.00708	NR	HEX9819910.1	2072417	g23230	i0	40	1.05527638190955	70	29	93.5	3	9	194	2	66	HEX9819910.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	210	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota			Candidatus Methylomirabilota bacterium
31622104	31622104	PRJNA1245487_P_NODE_19636_length_251_cov_0.876404_g19298_i0	PRJNA1245487	19636	251	0.876404	2.19977404	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	90.1	5e-19	NR	HEX9146665.1	2838779	g19298	i0	72.2	0.645418326693227	54	15	64.5	0	167	6	2	55	HEX9146665.1 alpha/beta fold hydrolase [Candidatus Binatia bacterium]	diamond	162	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
31875100	31875100	PRJNA1245487_P_NODE_18137_length_261_cov_1.244681_g17799_i0	PRJNA1245487	18137	261	1.244681	3.24861741	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	125	1.04e-34	NR	MDR3570669.1	2053589	g17799	i0	87.5	0.827586206896552	72	9	82.8	0	260	45	42	113	MDR3570669.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	216	125	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);;