metadata: contig_metadata: 9 rows where bioproject = "PRJEB14175", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJEB14175", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"

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
25746669	25746669	PRJEB14175_P_NODE_36250_length_619_cov_42.354839_g34084_i0	PRJEB14175	36250	619	42.354839	262.17645341	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	174	6.239999999999999e-48	NR	MBI2207367.1	2053607	g34084	i0	49.8	1.0032310177706	207	96	99.4	3	4	618	6	206	MBI2207367.1 long-chain fatty acid--CoA ligase [Candidatus Rokuibacteriota bacterium]	diamond	621	174	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
25879166	25879166	PRJEB14175_P_NODE_114075_length_330_cov_1.550186_g111809_i0	PRJEB14175	114075	330	1.550186	5.1156138	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	90.1	5.49e-20	NR	RPH80465.1	2053607	g111809	i0	89.6	0.436363636363636	48	5	43.6	0	1	144	131	178	RPH80465.1 MAG: hypothetical protein EHM88_12650 [Candidatus Rokuibacteriota bacterium]	diamond	144	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
26015406	26015406	PRJEB14175_P_NODE_107460_length_342_cov_6.622776_g105194_i0	PRJEB14175	107460	342	6.622776	22.64989392	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	161	2.2499999999999993e-43	NR	MBI4272121.1	2053607	g105194	i0	76	5.26315789473684	100	24	87.7	0	30	329	245	344	MBI4272121.1 molybdopterin-dependent oxidoreductase [Candidatus Rokuibacteriota bacterium]	diamond	1800	161	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
32994393	32994393	PRJEB14175_P_NODE_179475_length_245_cov_3.804348_g177208_i0	PRJEB14175	179475	245	3.804348	9.3206526	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	82.8	1.57e-17	NR	MCI0547876.1	2053607	g177208	i0	92.7	0.502040816326531	41	3	50.2	0	107	229	1	41	MCI0547876.1 HD domain-containing protein [Candidatus Rokuibacteriota bacterium]	diamond	123	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
33011288	33011288	PRJEB14175_P_NODE_163924_length_261_cov_1.215000_g161657_i0	PRJEB14175	163924	261	1.215	3.17115	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	117	1.8899999999999999e-28	NR	PWU25513.1	2053607	g161657	i0	67.4	0.988505747126437	86	28	98.9	0	259	2	111	196	PWU25513.1 MAG: hypothetical protein C5B48_00970 [Candidatus Rokuibacteriota bacterium]	diamond	258	117	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
33027862	33027862	PRJEB14175_P_NODE_104956_length_347_cov_5.489510_g102690_i0	PRJEB14175	104956	347	5.48951	19.0485997	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	116	2.23e-29	NR	PYO10546.1	2053607	g102690	i0	84.4	1.31412103746398	77	12	66.6	0	288	58	1	77	PYO10546.1 MAG: hypothetical protein DMD75_13240 [Candidatus Rokuibacteriota bacterium]	diamond	456	116	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
33028988	33028988	PRJEB14175_P_NODE_230180_length_208_cov_2.551020_g227912_i0	PRJEB14175	230180	208	2.55102	5.3061216	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	47	3.4e-4	NR	MBI4638506.1	2053607	g227912	i0	71.4	0.403846153846154	28	7	40.4	1	89	172	55	81	MBI4638506.1 HNH endonuclease [Candidatus Rokuibacteriota bacterium]	diamond	84	47	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
33046491	33046491	PRJEB14175_P_NODE_39205_length_596_cov_2.024299_g37020_i0	PRJEB14175	39205	596	2.024299	12.06482204	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	215	3.76e-68	NR	PYN36941.1	2053607	g37020	i0	68.4	3.19127516778523	158	49	79.5	1	525	52	3	159	PYN36941.1 MAG: hypothetical protein DME01_06105 [Candidatus Rokuibacteriota bacterium]	diamond	1902	215	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
33093289	33093289	PRJEB14175_P_NODE_170494_length_254_cov_1.823834_g168227_i0	PRJEB14175	170494	254	1.823834	4.63253836	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	7.16e-20	NR	OGL04120.1	1802103	g168227	i0	75	15.4724409448819	60	11	66.1	1	56	223	330	389	OGL04120.1 MAG: urease subunit alpha, partial [Candidatus Rokubacteria bacterium RIFCSPHIGHO2_12_FULL_73_22]	diamond	3930	93.2	0.991416309012876	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokubacteria bacterium RIFCSPHIGHO2_12_FULL_73_22

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