metadata: contig_metadata: 25 rows where bioproject = "PRJNA432257", tax_clade = "Bacteria candidate phyla" and tax

25 rows where bioproject = "PRJNA432257", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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_species
430045	430045	PRJNA432257_S_NODE_68701_length_205_cov_1.839286_g68320_i0	PRJNA432257	68701	205	1.839286	3.7705363	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	213	7.76e-51	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g68320	i0	88.202	1.73658536585366	178	21	87	0	13	190	659097	658920	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	356	213	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
1088728	1088728	PRJNA432257_S_NODE_42561_length_245_cov_14.370192_g42180_i0	PRJNA432257	42561	245	14.370192	35.2069704	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g42180	i0	91.628	177.077551020408	215	10	87	5	1	212	150019	149810	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	43384	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 488
1704577	1704577	PRJNA432257_S_NODE_44902_length_240_cov_35.192118_g44521_i0	PRJNA432257	44902	240	35.192118	84.4610832	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	99.4	1.1200000000000001e-22	NR	PKL31715.1	2013831	g44521	i0	88.7	7.9875	53	6	66.3	0	160	2	155	207	PKL31715.1 MAG: peptide chain release factor 1 [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1]	diamond	1917	100	0.994	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1
2979693	2979693	PRJNA432257_S_NODE_110963_length_165_cov_2.445312_g110582_i0	PRJNA432257	110963	165	2.445312	4.0347648	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g110582	i0	100	2	165	0	100	0	1	165	95263	95427	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	330	305	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
3639806	3639806	PRJNA432257_S_NODE_46583_length_237_cov_9.080000_g46202_i0	PRJNA432257	46583	237	9.08	21.5196	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	361	3.1099999999999996e-95	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g46202	i0	98.529	83.8354430379747	204	3	86	0	1	204	79799	79596	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	19869	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
5532658	5532658	PRJNA432257_S_NODE_103865_length_173_cov_1.551471_g103484_i0	PRJNA432257	103865	173	1.551471	2.68404483	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	307	2.81e-79	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g103484	i0	98.844	2.95375722543353	173	1	100	1	1	173	157396	157567	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	511	307	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
14459128	14459128	PRJNA432257_S_NODE_89852_length_184_cov_7.802721_g89471_i0	PRJNA432257	89852	184	7.802721	14.35700664	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	200	5.3e-47	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g89471	i0	91.275	15.8423913043478	149	9	82	4	5	151	212902	212756	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	2915	200	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				TM7 phylum sp. oral taxon 349
14459146	14459146	PRJNA432257_S_NODE_91792_length_182_cov_362.213793_g91411_i0	PRJNA432257	91792	182	362.213793	659.22910326	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	257	3.06e-64	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g91411	i0	98.621	1.59340659340659	145	2	80	0	38	182	388502	388358	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	290	257	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
15732971	15732971	PRJNA432257_S_NODE_94753_length_180_cov_27.230769_g94372_i0	PRJNA432257	94753	180	27.230769	49.0153842	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g94372	i0	98.63	1.62222222222222	146	2	81	0	1	146	536899	536754	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	292	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
19554997	19554997	PRJNA432257_S_NODE_117016_length_159_cov_2.549180_g116635_i0	PRJNA432257	117016	159	2.54918	4.0531962	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	117	4.600000000000001e-22	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g116635	i0	83.871	1.55974842767296	124	18	77	2	1	123	394741	394863	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	248	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
26791061	26791061	PRJNA432257_S_NODE_28781_length_283_cov_12.430894_g28400_i0	PRJNA432257	28781	283	12.430894	35.17943002	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	74.7	3.5e-13	NR	MCA9341841.1	2026720	g28400	i0	42	4.49469964664311	81	46	85.9	1	246	4	532	611	MCA9341841.1 ribonucleoside-diphosphate reductase subunit alpha [Candidatus Saccharibacteria bacterium]	diamond	1272	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
27265513	27265513	PRJNA432257_S_NODE_112883_length_163_cov_2.341270_g112502_i0	PRJNA432257	112883	163	2.34127	3.8162701	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	103	4.42e-25	NR	MBF1024824.1	2725942	g112502	i0	96.2	0.975460122699387	53	2	97.5	0	3	161	61	113	MBF1024824.1 type II restriction endonuclease [Candidatus Nanogingivalaceae bacterium]	diamond	159	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
27644695	27644695	PRJNA432257_S_NODE_27444_length_288_cov_7.553785_g27063_i0	PRJNA432257	27444	288	7.553785	21.7549008	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	101	1.69e-22	NR	HSW76347.1	2973664	g27063	i0	59.5	0.875	84	32	85.4	1	8	253	346	429	HSW76347.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	252	101	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
27644707	27644707	PRJNA432257_S_NODE_44764_length_240_cov_1745.980296_g44383_i0	PRJNA432257	44764	240	1745.980296	4190.3527104	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	92	1.89e-21	NR	MBB1552150.1	2026720	g44383	i0	75	0.85	68	17	85	0	34	237	92	159	MBB1552150.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	204	92	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
27771002	27771002	PRJNA432257_S_NODE_72144_length_201_cov_2.390244_g71763_i0	PRJNA432257	72144	201	2.390244	4.80439044	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	55.1	7.91e-7	NR	HAC56089.1	2026720	g71763	i0	83.9	0.462686567164179	31	5	46.3	0	109	201	1	31	HAC56089.1 ROK family protein [Candidatus Saccharibacteria bacterium]	diamond	93	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
28054813	28054813	PRJNA432257_S_NODE_116185_length_160_cov_1.853659_g115804_i0	PRJNA432257	116185	160	1.853659	2.9658544	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	64.7	4.03e-11	NR	MFO0971469.1	2973664	g115804	i0	88.2	0.6375	34	4	63.8	0	59	160	1	34	MFO0971469.1 inorganic diphosphatase [Candidatus Saccharimonadales bacterium]	diamond	102	64.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
28180978	28180978	PRJNA432257_S_NODE_58826_length_217_cov_77.405556_g58445_i0	PRJNA432257	58826	217	77.405556	167.97005652000001	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	61.2	3.17e-9	NR	HSW76590.1	2973664	g58445	i0	46.9	0.884792626728111	64	32	88.5	1	192	1	102	163	HSW76590.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	192	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
28749587	28749587	PRJNA432257_S_NODE_91767_length_182_cov_410.131034_g91386_i0	PRJNA432257	91767	182	410.131034	746.43848188	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	69.7	3.78e-13	NR	HSX40735.1	2973664	g91386	i0	72.5	0.840659340659341	51	14	84.1	0	153	1	77	127	HSX40735.1 GatB/YqeY domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	153	69.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
28829024	28829024	PRJNA432257_S_NODE_110488_length_166_cov_1.271318_g110107_i0	PRJNA432257	110488	166	1.271318	2.11038788	Bacteria	2	Bacteria	Bacteria	78.6	2.67e-15	NR	MCA9345630.1	2026720	g110107	i0	80	9.19879518072289	50	10	90.4	0	16	165	284	333	MCA9345630.1 ABC transporter permease [Candidatus Saccharibacteria bacterium]	diamond	1527	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
28939115	28939115	PRJNA432257_S_NODE_121488_length_155_cov_3.644068_g121107_i0	PRJNA432257	121488	155	3.644068	5.6483054	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	48.5	1.63e-5	NR	HSW75497.1	2973664	g121107	i0	44.2	1.66451612903226	43	24	83.2	0	23	151	3	45	HSW75497.1 gp7 family phage scaffolding protein [Candidatus Saccharimonadales bacterium]	diamond	258	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
29807860	29807860	PRJNA432257_S_NODE_90251_length_184_cov_1.727891_g89870_i0	PRJNA432257	90251	184	1.727891	3.17931944	Bacillati	1783272	Bacteria	Bacteria	75.5	4.33e-14	NR	MDB5176751.1	2026720	g89870	i0	87	3.09782608695652	46	6	75	0	24	161	311	356	MDB5176751.1 rane protein of unknown function [Candidatus Saccharibacteria bacterium]	diamond	570	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
30265644	30265644	PRJNA432257_S_NODE_111232_length_165_cov_1.757812_g110851_i0	PRJNA432257	111232	165	1.757812	2.9003898	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	45.4	0.00115	NR	HUD11127.1	2890869	g110851	i0	54.5	1.09090909090909	33	15	60	0	9	107	179	211	HUD11127.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	180	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia			Candidatus Saccharimonadia bacterium
30439987	30439987	PRJNA432257_S_NODE_70413_length_203_cov_2.096386_g70032_i0	PRJNA432257	70413	203	2.096386	4.25566358	Bacteria	2	Bacteria	Bacteria	44.7	0.00458	NR	PKL31608.1	2013831	g70032	i0	34.3	2.76354679802956	67	44	99	0	2	202	219	285	PKL31608.1 MAG: DNA polymerase III, subunit gamma and tau [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1]	diamond	561	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1
31118194	31118194	PRJNA432257_S_NODE_58355_length_218_cov_3.337017_g57974_i0	PRJNA432257	58355	218	3.337017	7.27469706	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	129	2.85e-34	NR	MBR0430925.1	2026720	g57974	i0	91.4	7.69266055045872	70	6	96.3	0	2	211	298	367	MBR0430925.1 AI-2E family transporter [Candidatus Saccharibacteria bacterium]	diamond	1677	129	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
32667915	32667915	PRJNA432257_S_NODE_69720_length_204_cov_1.107784_g69339_i0	PRJNA432257	69720	204	1.107784	2.25987936	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	70.1	4.88e-12	NR	HRQ98278.1	2026720	g69339	i0	71.4	4.82352941176471	42	12	61.8	0	78	203	75	116	HRQ98278.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	984	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota 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);;