metadata: contig_metadata: 25 rows where bioproject = "PRJNA492363" and tax

25 rows where bioproject = "PRJNA492363" 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_species
25567076	25567076	PRJNA492363_S_NODE_85889_length_209_cov_1.668919_g85068_i0	PRJNA492363	85889	209	1.668919	3.48804071	Microgenomates group bacterium	2461418	Bacteria	Bacteria	98.6	2.98e-22	NR	MFA9229314.1	2461418	g85068	i0	89.7	0.832535885167464	58	6	83.3	0	36	209	60	117	MFA9229314.1 sodium:proton antiporter NhaD [Microgenomates group bacterium]	diamond	174	98.6	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
26169409	26169409	PRJNA492363_S_NODE_1613_length_840_cov_22118.237484_g853_i0	PRJNA492363	1613	840	22118.237484	185793.1948656	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	254	1.36e-75	NR	MCK9345045.1	2053589	g853	i0	54.3	1.64285714285714	230	104	81.8	1	772	86	484	713	MCK9345045.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	1380	254	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
26246582	26246582	PRJNA492363_S_NODE_1526_length_922_cov_12.540070_g772_i0	PRJNA492363	1526	922	12.54007	115.6194454	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	364	2.15e-117	NR	MCK9345045.1	2053589	g772	i0	63.9	0.927331887201735	285	103	92.7	0	912	58	194	478	MCK9345045.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	855	364	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
26518487	26518487	PRJNA492363_S_NODE_12888_length_274_cov_2.868545_g12067_i0	PRJNA492363	12888	274	2.868545	7.8598133	Microgenomates group bacterium	2461418	Bacteria	Bacteria	80.5	1.52e-17	NR	MFA9229200.1	2461418	g12067	i0	80	1.64233576642336	50	10	54.7	0	2	151	38	87	MFA9229200.1 hypothetical protein [Microgenomates group bacterium]	diamond	450	80.5	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
26519060	26519060	PRJNA492363_S_NODE_4384_length_424_cov_2.561983_g3563_i0	PRJNA492363	4384	424	2.561983	10.86280792	Microgenomates group bacterium	2461418	Bacteria	Bacteria	230	1.77e-71	NR	MFA9229314.1	2461418	g3563	i0	87.9	0.933962264150943	132	16	93.4	0	3	398	220	351	MFA9229314.1 sodium:proton antiporter NhaD [Microgenomates group bacterium]	diamond	396	230	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
26577253	26577253	PRJNA492363_S_NODE_22256_length_246_cov_1.037838_g21435_i0	PRJNA492363	22256	246	1.037838	2.55308148	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	130	3.0600000000000004e-36	NR	MDO9028178.1	2282149	g21435	i0	100	0.804878048780488	66	0	80.5	0	49	246	64	129	MDO9028178.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	198	130	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota			Candidatus Roizmanbacteria bacterium
32935160	32935160	PRJNA492363_S_NODE_113113_length_192_cov_2.061069_g112292_i0	PRJNA492363	113113	192	2.061069	3.95725248	Microgenomates group bacterium	2461418	Bacteria	Bacteria	97.8	5.66e-22	NR	MFA9230971.1	2461418	g112292	i0	76.3	0.921875	59	14	92.2	0	190	14	19	77	MFA9230971.1 amino acid ABC transporter permease [Microgenomates group bacterium]	diamond	177	97.8	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
32935176	32935176	PRJNA492363_S_NODE_11889_length_282_cov_2.696833_g11068_i0	PRJNA492363	11889	282	2.696833	7.60506906	Microgenomates group bacterium	2461418	Bacteria	Bacteria	65.9	4.09e-10	NR	MFA9229714.1	2461418	g11068	i0	81.1	1.20212765957447	37	7	39.4	0	280	170	382	418	MFA9229714.1 Hsp70 family protein [Microgenomates group bacterium]	diamond	339	65.9	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
32935203	32935203	PRJNA492363_S_NODE_15681_length_256_cov_2.625641_g14860_i0	PRJNA492363	15681	256	2.625641	6.72164096	Microgenomates group bacterium	2461418	Bacteria	Bacteria	121	3.07e-32	NR	MFA9231276.1	2461418	g14860	i0	76.2	0.984375	84	20	98.4	0	1	252	107	190	MFA9231276.1 DUF2306 domain-containing protein [Microgenomates group bacterium]	diamond	252	121	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
32935384	32935384	PRJNA492363_S_NODE_93273_length_205_cov_1.152778_g92452_i0	PRJNA492363	93273	205	1.152778	2.3631949	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	50.1	5.92e-5	NR	KKQ34614.1	1618742	g92452	i0	37.5	1.87317073170732	64	40	93.7	0	1	192	33	96	KKQ34614.1 MAG: Resolvase-like protein [Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5]	diamond	384	50.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5
32935402	32935402	PRJNA492363_S_NODE_96865_length_203_cov_1.352113_g96044_i0	PRJNA492363	96865	203	1.352113	2.74478939	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	53.5	3.46e-6	NR	OYX40715.1	1970479	g96044	i0	49.2	0.960591133004926	65	33	96.1	0	7	201	579	643	OYX40715.1 MAG: hypothetical protein B7Y94_06095 [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	195	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-49-12
32952395	32952395	PRJNA492363_S_NODE_100786_length_201_cov_1.371429_g99965_i0	PRJNA492363	100786	201	1.371429	2.75657229	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	130	2.1399999999999996e-37	NR	HTD86170.1	2838779	g99965	i0	90.9	1.97014925373134	66	6	98.5	0	200	3	16	81	HTD86170.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	396	130	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
32986603	32986603	PRJNA492363_S_NODE_2275_length_603_cov_6.378229_g1475_i0	PRJNA492363	2275	603	6.378229	38.46072087	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	214	1.44e-61	NR	MCK9345045.1	2053589	g1475	i0	57.1	0.985074626865672	198	81	98.5	1	596	3	4	197	MCK9345045.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	594	214	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
33026841	33026841	PRJNA492363_S_NODE_87932_length_208_cov_1.204082_g87111_i0	PRJNA492363	87932	208	1.204082	2.50449056	Bacteria	2	Bacteria	Bacteria	75.9	6.5e-15	NR	OGE30267.1	1797768	g87111	i0	58.2	2.89903846153846	67	26	96.6	1	203	3	69	133	OGE30267.1 MAG: hypothetical protein A3C59_04790 [Candidatus Daviesbacteria bacterium RIFCSPHIGHO2_02_FULL_36_13]	diamond	603	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Daviesiibacteriota			Candidatus Daviesbacteria bacterium RIFCSPHIGHO2_02_FULL_36_13
33037748	33037748	PRJNA492363_S_NODE_49132_length_233_cov_1.668605_g48311_i0	PRJNA492363	49132	233	1.668605	3.88784965	Microgenomates group bacterium	2461418	Bacteria	Bacteria	99.8	1.22e-24	NR	MFA9231278.1	2461418	g48311	i0	66.2	1.96995708154506	77	26	99.1	0	233	3	69	145	MFA9231278.1 hypothetical protein [Microgenomates group bacterium]	diamond	459	99.8	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
33037751	33037751	PRJNA492363_S_NODE_51732_length_232_cov_1.122807_g50911_i0	PRJNA492363	51732	232	1.1228070000000001	2.60491224	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	100	1.5000000000000002e-22	NR	MFA7717428.1	2927939	g50911	i0	68.9	0.956896551724138	74	23	95.7	0	227	6	124	197	MFA7717428.1 leucine-rich repeat domain-containing protein [Candidatus Absconditabacterales bacterium]	diamond	222	100	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		Candidatus Absconditabacterales	Candidatus Absconditabacterales bacterium
33054680	33054680	PRJNA492363_S_NODE_114157_length_191_cov_2.461538_g113336_i0	PRJNA492363	114157	191	2.461538	4.70153758	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	97.8	3.78e-22	NR	MDD2657816.1	2053589	g113336	i0	94	0.785340314136126	50	3	78.5	0	41	190	1	50	MDD2657816.1 TRAFs-binding domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	150	97.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
33054887	33054887	PRJNA492363_S_NODE_89661_length_207_cov_1.315068_g88840_i0	PRJNA492363	89661	207	1.315068	2.72219076	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	81.3	2.5e-17	NR	MDB5176130.1	2026720	g88840	i0	85.7	0.608695652173913	42	6	60.9	0	128	3	1	42	MDB5176130.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	126	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
33054898	33054898	PRJNA492363_S_NODE_91653_length_206_cov_0.882759_g90832_i0	PRJNA492363	91653	206	0.882759	1.81848354	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	70.5	1.85e-12	NR	MFQ5883011.1	3159508	g90832	i0	59.2	0.713592233009709	49	19	71.4	1	204	58	224	271	MFQ5883011.1 hypothetical protein [Candidatus Methylomirabilales bacterium]	diamond	147	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilales bacterium
33054916	33054916	PRJNA492363_S_NODE_95125_length_204_cov_1.258741_g94304_i0	PRJNA492363	95125	204	1.258741	2.56783164	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	100	6.399999999999999e-24	NR	HZC22858.1	2838779	g94304	i0	64.1	0.941176470588235	64	23	94.1	0	2	193	156	219	HZC22858.1 glycosyl hydrolase family 65 protein [Candidatus Binatia bacterium]	diamond	192	100	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
33071640	33071640	PRJNA492363_S_NODE_10165_length_302_cov_1.933610_g9344_i0	PRJNA492363	10165	302	1.93361	5.8395022	Microgenomates group bacterium	2461418	Bacteria	Bacteria	173	5.35e-48	NR	MFA9231571.1	2461418	g9344	i0	83.8	5.93046357615894	99	16	98.3	0	2	298	499	597	MFA9231571.1 FAD-dependent oxidoreductase [Microgenomates group bacterium]	diamond	1791	173	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium
33071864	33071864	PRJNA492363_S_NODE_89917_length_207_cov_0.876712_g89096_i0	PRJNA492363	89917	207	0.876712	1.81479384	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	124	1.6199999999999998e-32	NR	MEO6026083.1	2838779	g89096	i0	79.4	1.97101449275362	68	14	98.6	0	206	3	240	307	MEO6026083.1 TIGR03617 family F420-dependent LLM class oxidoreductase [Candidatus Binatia bacterium]	diamond	408	124	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
33088917	33088917	PRJNA492363_S_NODE_16246_length_254_cov_2.321244_g15425_i0	PRJNA492363	16246	254	2.321244	5.89595976	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	64.3	1.07e-9	NR	MEO0075684.1	2052148	g15425	i0	42.9	1.99606299212598	84	44	99.2	2	2	253	571	650	MEO0075684.1 S8 family peptidase [candidate division WOR-3 bacterium]	diamond	507	64.3	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3			candidate division WOR-3 bacterium
33106102	33106102	PRJNA492363_S_NODE_91366_length_206_cov_1.324138_g90545_i0	PRJNA492363	91366	206	1.324138	2.72772428	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	94.7	1.12e-20	NR	HXG22443.1	2072417	g90545	i0	69.1	0.990291262135922	68	21	99	0	1	204	71	138	HXG22443.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	204	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota			Candidatus Methylomirabilota bacterium
33106149	33106149	PRJNA492363_S_NODE_98966_length_202_cov_0.907801_g98145_i0	PRJNA492363	98966	202	0.907801	1.83375802	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	61.6	4.84e-9	NR	OYX40715.1	1970479	g98145	i0	44.6	0.965346534653465	65	35	95	1	202	11	387	451	OYX40715.1 MAG: hypothetical protein B7Y94_06095 [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	195	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-49-12

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