metadata: contig_metadata: 14 rows where bioproject = "PRJEB11748" and tax

14 rows where bioproject = "PRJEB11748" 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
1294071	1294071	PRJEB11748_P_NODE_65582_length_522_cov_31.108460_g63441_i0	PRJEB11748	65582	522	31.10846	162.3861612	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	188	1.0499999999999999e-54	NR	PYN91304.1	2053607	g63441	i0	60.4	0.885057471264368	154	61	88.5	0	485	24	230	383	PYN91304.1 MAG: IS110 family transposase [Candidatus Rokuibacteriota bacterium]	diamond	462	188	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
15317347	15317347	PRJEB11748_P_NODE_160253_length_323_cov_2.664122_g158071_i0	PRJEB11748	160253	323	2.664122	8.60511406	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	134	1.12e-36	NR	PYO11862.1	2053607	g158071	i0	69.4	0.910216718266254	98	30	91	0	22	315	31	128	PYO11862.1 MAG: glycosyltransferase family 2 protein [Candidatus Rokuibacteriota bacterium]	diamond	294	134	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
27253931	27253931	PRJEB11748_P_NODE_158523_length_325_cov_3.147727_g156341_i0	PRJEB11748	158523	325	3.147727	10.23011275	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	76.3	1.72e-13	NR	PYN49999.1	2053607	g156341	i0	41.9	1.93846153846154	105	56	93.2	3	325	23	753	856	PYN49999.1 MAG: hypothetical protein DME00_07300, partial [Candidatus Rokuibacteriota bacterium]	diamond	630	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
27506975	27506975	PRJEB11748_P_NODE_151383_length_333_cov_8.985294_g149202_i0	PRJEB11748	151383	333	8.985294	29.92102902	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	192	6.16e-60	NR	MFI5324842.1	2053607	g149202	i0	92	2.71171171171171	100	8	90.1	0	316	17	91	190	MFI5324842.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Rokuibacteriota bacterium]	diamond	903	192	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28548967	28548967	PRJEB11748_P_NODE_213027_length_273_cov_1.919811_g210844_i0	PRJEB11748	213027	273	1.919811	5.24108403	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	92.8	4.81e-20	NR	MFI5328545.1	2053607	g210844	i0	90.9	0.483516483516484	44	4	48.4	0	273	142	309	352	MFI5328545.1 ribonucleotide-diphosphate reductase subunit alpha [Candidatus Rokuibacteriota bacterium]	diamond	132	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28832785	28832785	PRJEB11748_P_NODE_113768_length_390_cov_1.957447_g111594_i0	PRJEB11748	113768	390	1.957447	7.6340433	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	54.7	1.01e-5	NR	MBI2528485.1	2053607	g111594	i0	42	0.623076923076923	81	43	62.3	2	19	261	38	114	MBI2528485.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	243	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28953292	28953292	PRJEB11748_P_NODE_118608_length_381_cov_5.403125_g116433_i0	PRJEB11748	118608	381	5.403125	20.58590625	Bacteria	2	Bacteria	Bacteria	143	4.649999999999999e-40	NR	MBI3629837.1	2053607	g116433	i0	63.9	5.99212598425197	108	39	85	0	354	31	122	229	MBI3629837.1 TerC family protein [Candidatus Rokuibacteriota bacterium]	diamond	2283	144	0.993055555555556	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29363603	29363603	PRJEB11748_P_NODE_181789_length_300_cov_4.058577_g179606_i0	PRJEB11748	181789	300	4.058577	12.175731	Pseudomonadati	3379134	Bacteria	Bacteria	91.3	4.81e-19	NR	PYO11865.1	2053607	g179606	i0	53.3	1.84	92	43	92	0	284	9	154	245	PYO11865.1 MAG: hypothetical protein DMD75_09310 [Candidatus Rokuibacteriota bacterium]	diamond	552	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29621806	29621806	PRJEB11748_P_NODE_203770_length_280_cov_10.968037_g201587_i0	PRJEB11748	203770	280	10.968037	30.7105036	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	117	3.0599999999999996e-32	NR	PYM45980.1	2053607	g201587	i0	84.9	0.782142857142857	73	11	78.2	0	221	3	8	80	PYM45980.1 MAG: hypothetical protein DME16_15990 [Candidatus Rokuibacteriota bacterium]	diamond	219	117	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29938242	29938242	PRJEB11748_P_NODE_306951_length_216_cov_3.270968_g304768_i0	PRJEB11748	306951	216	3.270968	7.06529088	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	77	2.99e-16	NR	HAM59860.1	2053607	g304768	i0	67.9	0.777777777777778	56	17	76.4	1	200	36	54	109	HAM59860.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	168	77	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
30538282	30538282	PRJEB11748_P_NODE_168753_length_313_cov_8.515873_g166570_i0	PRJEB11748	168753	313	8.515873	26.65468249	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	116	1.23e-30	NR	PYN97992.1	2053607	g166570	i0	84.6	1.24600638977636	65	10	62.3	0	243	49	1	65	PYN97992.1 MAG: hypothetical protein DMD91_16200 [Candidatus Rokuibacteriota bacterium]	diamond	390	116	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31575397	31575397	PRJEB11748_P_NODE_263496_length_239_cov_1.303371_g261313_i0	PRJEB11748	263496	239	1.303371	3.11505669	Pseudomonadati	3379134	Bacteria	Bacteria	48.9	2.24e-4	NR	MBI2462428.1	2053607	g261313	i0	56.3	1.20502092050209	48	20	60.3	1	197	54	290	336	MBI2462428.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Rokuibacteriota bacterium]	diamond	288	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31929270	31929270	PRJEB11748_P_NODE_132497_length_359_cov_3.476510_g130320_i0	PRJEB11748	132497	359	3.47651	12.4806709	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	164	2.35e-45	NR	HAM57584.1	2053607	g130320	i0	75.9	1.8050139275766	108	26	90.3	0	341	18	131	238	HAM57584.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	648	164	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
32688129	32688129	PRJEB11748_P_NODE_377980_length_181_cov_5.141667_g375797_i0	PRJEB11748	377980	181	5.141667	9.30641727	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	50.8	1.25e-5	NR	MFI5328610.1	2053607	g375797	i0	56.1	0.94475138121547	57	20	89.5	2	163	2	39	93	MFI5328610.1 amidohydrolase family protein [Candidatus Rokuibacteriota bacterium]	diamond	171	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota 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);;