metadata: contig_metadata: 29 rows where bioproject = "PRJNA864829" and tax

29 rows where bioproject = "PRJNA864829" 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_order	tax_family	tax_genus	tax_species
2512379	2512379	PRJNA864829_S_NODE_1522_length_409_cov_3.288889_g1436_i0	PRJNA864829	1522	409	3.288889	13.45155601	Bacteria	2	Bacteria	Bacteria	189	2.8699999999999998e-43	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g1436	i0	76.238	69.520782396088	404	69	95	23	21	409	595944	595553	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	28434	189	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
3397997	3397997	PRJNA864829_S_NODE_12483_length_181_cov_1.712121_g12397_i0	PRJNA864829	12483	181	1.712121	3.09893901	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	169	1.4599999999999998e-37	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g12397	i0	87.248	48.1381215469613	149	17	82	2	9	156	2261845	2261698	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	8713	169	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
7614907	7614907	PRJNA864829_S_NODE_4066_length_285_cov_1.364407_g3980_i0	PRJNA864829	4066	285	1.364407	3.88855995	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	68.2	2.34e-12	NR	HEX7409976.1	2838779	g3980	i0	62.5	0.673684210526316	64	21	67.4	1	84	275	1	61	HEX7409976.1 peptidoglycan-binding domain-containing protein [Candidatus Binatia bacterium]	diamond	192	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
9775306	9775306	PRJNA864829_S_NODE_3828_length_290_cov_2.929461_g3742_i0	PRJNA864829	3828	290	2.929461	8.4954369	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	241	5.340000000000001e-59	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g3742	i0	82.253	105.955172413793	293	38	99	11	5	290	2262509	2262794	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	30727	241	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
11051007	11051007	PRJNA864829_S_NODE_1889_length_374_cov_2.756923_g1803_i0	PRJNA864829	1889	374	2.756923	10.31089202	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	195	5.59e-45	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g1803	i0	76.684	63.7941176470588	386	69	100	16	1	374	2070086	2070462	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	23859	195	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
11051036	11051036	PRJNA864829_S_NODE_6389_length_241_cov_1.276042_g6303_i0	PRJNA864829	6389	241	1.276042	3.07526122	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	248	2.58e-61	NTclustered	gi\|2874253748\|emb\|OY969622.1\|	2803731	g6303	i0	88.406	114.344398340249	207	23	86	1	35	241	373410	373615	MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1	blastn	27557	248	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
13600969	13600969	PRJNA864829_S_NODE_3331_length_305_cov_1.710938_g3245_i0	PRJNA864829	3331	305	1.710938	5.2183609	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	239	2.03e-58	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g3245	i0	81.544	428.701639344262	298	48	97	6	2	298	160528	160819	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	130754	239	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
14875317	14875317	PRJNA864829_S_NODE_7192_length_229_cov_1.444444_g7106_i0	PRJNA864829	7192	229	1.444444	3.30777676	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	137	7.81e-37	NR	MDX2176735.1	2715255	g7106	i0	89.2	0.96943231441048	74	8	96.9	0	225	4	113	186	MDX2176735.1 serine/threonine-protein kinase [Candidatus Sumerlaeia bacterium]	diamond	222	137	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
17425453	17425453	PRJNA864829_S_NODE_1714_length_389_cov_47.250000_g1628_i0	PRJNA864829	1714	389	47.25	183.8025	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	296	1.56e-75	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g1628	i0	85.971	486.706940874036	278	37	71	2	112	389	3394159	3394434	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	189329	296	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
17425492	17425492	PRJNA864829_S_NODE_7474_length_225_cov_2.761364_g7388_i0	PRJNA864829	7474	225	2.761364	6.213069	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	92.8	6.42e-20	NR	HXJ33722.1	2212470	g7388	i0	69.9	0.973333333333333	73	21	96	1	1	216	299	371	HXJ33722.1 glycosyltransferase family 4 protein [Candidatus Eiseniibacteriota bacterium]	diamond	219	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
22523973	22523973	PRJNA864829_S_NODE_13118_length_177_cov_1.750000_g13032_i0	PRJNA864829	13118	177	1.75	3.0975	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	92.4	3.58e-20	NR	MFI5367200.1	2838779	g13032	i0	79.3	0.983050847457627	58	12	98.3	0	176	3	24	81	MFI5367200.1 sigma-54-dependent transcriptional regulator [Candidatus Binatia bacterium]	diamond	174	92.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27371480	27371480	PRJNA864829_S_NODE_9043_length_208_cov_1.691824_g8957_i0	PRJNA864829	9043	208	1.691824	3.51899392	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	81.3	6e-16	NR	MBX7246206.1	2315423	g8957	i0	57.4	0.879807692307692	61	26	88	0	206	24	477	537	MBX7246206.1 DUF1800 domain-containing protein [Candidatus Sumerlaeaceae bacterium]	diamond	183	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium
27529065	27529065	PRJNA864829_S_NODE_9203_length_206_cov_2.828025_g9117_i0	PRJNA864829	9203	206	2.828025	5.8257315	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42	0.0441	NR	MFQ5666412.1	2838779	g9117	i0	42.6	0.990291262135922	68	39	99	0	1	204	317	384	MFQ5666412.1 chromosome segregation protein SMC [Candidatus Binatia bacterium]	diamond	204	42	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
28318390	28318390	PRJNA864829_S_NODE_11606_length_187_cov_1.949275_g11520_i0	PRJNA864829	11606	187	1.949275	3.64514425	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	68.2	1.83e-11	NR	MEX1028124.1	2053589	g11520	i0	55.2	0.93048128342246	58	26	93	0	182	9	173	230	MEX1028124.1 HEAT repeat domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	174	68.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28444883	28444883	PRJNA864829_S_NODE_16086_length_162_cov_2.964602_g16000_i0	PRJNA864829	16086	162	2.964602	4.80265524	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	64.7	8.21e-11	NR	MEO0248113.1	2052148	g16000	i0	66.7	0.833333333333333	45	15	83.3	0	162	28	176	220	MEO0248113.1 LAGLIDADG endonuclease [candidate division WOR-3 bacterium]	diamond	135	64.7	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3					candidate division WOR-3 bacterium
28507929	28507929	PRJNA864829_S_NODE_14187_length_171_cov_1.770492_g14101_i0	PRJNA864829	14187	171	1.770492	3.02754132	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	99.4	7.09e-23	NR	HEV8674898.1	2072417	g14101	i0	82.1	0.982456140350877	56	10	98.2	0	170	3	192	247	HEV8674898.1 nucleotide sugar dehydrogenase [Candidatus Methylomirabilota bacterium]	diamond	168	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28918134	28918134	PRJNA864829_S_NODE_7668_length_223_cov_1.534483_g7582_i0	PRJNA864829	7668	223	1.534483	3.42189709	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	99	2.54e-22	NR	MBI1784187.1	2107588	g7582	i0	63	0.982062780269058	73	27	98.2	0	3	221	14	86	MBI1784187.1 VCBS repeat-containing protein [Candidatus Sumerlaeota bacterium]	diamond	219	99	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
29171056	29171056	PRJNA864829_S_NODE_13309_length_176_cov_1.259843_g13223_i0	PRJNA864829	13309	176	1.259843	2.21732368	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	103	5.9e-25	NR	MBI3735722.1	2107588	g13223	i0	81	0.988636363636364	58	11	98.9	0	2	175	153	210	MBI3735722.1 FAD binding domain-containing protein [Candidatus Sumerlaeota bacterium]	diamond	174	103	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
29234151	29234151	PRJNA864829_S_NODE_9029_length_208_cov_2.283019_g8943_i0	PRJNA864829	9029	208	2.283019	4.74867952	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	68.2	2.56e-11	NR	MFQ5665161.1	2838779	g8943	i0	44.9	0.995192307692308	69	34	93.8	1	14	208	252	320	MFQ5665161.1 FG-GAP-like repeat-containing protein [Candidatus Binatia bacterium]	diamond	207	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29360417	29360417	PRJNA864829_S_NODE_13609_length_174_cov_1.672000_g13523_i0	PRJNA864829	13609	174	1.672	2.90928	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	49.3	7.14e-5	NR	MBI1785113.1	2107588	g13523	i0	45.1	0.879310344827586	51	28	87.9	0	172	20	315	365	MBI1785113.1 tetratricopeptide repeat protein [Candidatus Sumerlaeota bacterium]	diamond	153	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
29400048	29400048	PRJNA864829_S_NODE_5849_length_249_cov_1.875000_g5763_i0	PRJNA864829	5849	249	1.875	4.66875	Pseudomonadati	3379134	Bacteria	Bacteria	142	3.76e-37	NR	GIW43802.1	2838779	g5763	i0	78.3	4	83	18	100	0	1	249	60	142	GIW43802.1 MAG: ribonucleoside-diphosphate reductase subunit alpha [Candidatus Binatia bacterium]	diamond	996	143	0.993006993006993	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29802332	29802332	PRJNA864829_S_NODE_5511_length_254_cov_2.478049_g5425_i0	PRJNA864829	5511	254	2.478049	6.29424446	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	144	1.31e-39	NR	MFI5366530.1	2838779	g5425	i0	82.1	0.992125984251969	84	14	99.2	1	2	253	67	149	MFI5366530.1 Coenzyme F420 hydrogenase/dehydrogenase, beta subunit C-terminal domain [Candidatus Binatia bacterium]	diamond	252	144	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30118182	30118182	PRJNA864829_S_NODE_2492_length_338_cov_1.301038_g2406_i0	PRJNA864829	2492	338	1.301038	4.39750844	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	132	2.3499999999999997e-35	NR	MBI1785660.1	2107588	g2406	i0	59.8	0.86094674556213	97	39	86.1	0	47	337	135	231	MBI1785660.1 response regulator [Candidatus Sumerlaeota bacterium]	diamond	291	132	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
30118183	30118183	PRJNA864829_S_NODE_8252_length_216_cov_1.724551_g8166_i0	PRJNA864829	8252	216	1.724551	3.72503016	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52.8	7.81e-6	NR	HLK10506.1	2838779	g8166	i0	44.6	2.75	56	31	77.8	0	1	168	304	359	HLK10506.1 sulfatase-like hydrolase/transferase [Candidatus Binatia bacterium]	diamond	594	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30592161	30592161	PRJNA864829_S_NODE_9673_length_202_cov_1.490196_g9587_i0	PRJNA864829	9673	202	1.490196	3.01019592	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	73.6	2.96e-13	NR	MFI5396453.1	2838779	g9587	i0	56.1	0.98019801980198	66	29	98	0	4	201	224	289	MFI5396453.1 GumC family protein [Candidatus Binatia bacterium]	diamond	198	73.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31105761	31105761	PRJNA864829_S_NODE_15015_length_168_cov_0.907563_g14929_i0	PRJNA864829	15015	168	0.907563	1.52470584	Bacteria	2	Bacteria	Bacteria	48.9	1.44e-5	NR	MBC7546622.1	2026720	g14929	i0	64.7	2.17857142857143	34	12	60.7	0	6	107	53	86	MBC7546622.1 RNA-binding protein [Candidatus Saccharibacteria bacterium]	diamond	366	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31833116	31833116	PRJNA864829_S_NODE_2657_length_330_cov_2.861210_g2571_i0	PRJNA864829	2657	330	2.86121	9.441993	Bacteria	2	Bacteria	Bacteria	114	5.45e-29	NR	MCC6546374.1	2107588	g2571	i0	77	1.35454545454545	74	17	67.3	0	227	6	10	83	MCC6546374.1 glycosyltransferase family 2 protein [Candidatus Sumerlaeota bacterium]	diamond	447	114	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
32836230	32836230	PRJNA864829_S_NODE_16220_length_161_cov_2.169643_g16134_i0	PRJNA864829	16220	161	2.169643	3.49312523	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	45.4	0.00137	NR	MDX2177323.1	2715255	g16134	i0	45.7	0.857142857142857	46	22	85.7	1	159	22	150	192	MDX2177323.1 hypothetical protein [Candidatus Sumerlaeia bacterium]	diamond	138	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
32836231	32836231	PRJNA864829_S_NODE_2880_length_321_cov_2.654412_g2794_i0	PRJNA864829	2880	321	2.654412	8.52066252	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	159	1.12e-45	NR	MBI1785705.1	2107588	g2794	i0	74.3	0.981308411214953	105	27	98.1	0	6	320	21	125	MBI1785705.1 PP2C family protein-serine/threonine phosphatase [Candidatus Sumerlaeota bacterium]	diamond	315	159	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota 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);;