metadata: contig_metadata: 19 rows where bioproject = "PRJEB66218" and tax

19 rows where bioproject = "PRJEB66218" 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_genus	tax_species
131564	131564	PRJEB66218_P_NODE_158481_length_235_cov_1.758621_g156051_i0	PRJEB66218	158481	235	1.758621	4.13275935	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	412	8.39e-111	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g156051	i0	98.298	71.3489361702128	235	4	100	0	1	235	113096	112862	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	16767	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
2682244	2682244	PRJEB66218_P_NODE_191943_length_214_cov_1.274510_g189513_i0	PRJEB66218	191943	214	1.27451	2.7274514	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	379	7.609999999999999e-101	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g189513	i0	98.598	74.1635514018692	214	3	100	0	1	214	111359	111572	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	15871	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
6508703	6508703	PRJEB66218_P_NODE_107366_length_293_cov_7.215517_g104937_i0	PRJEB66218	107366	293	7.215517	21.14146481	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	416	8.359999999999998e-112	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g104937	i0	93.286	132.921501706485	283	17	96	2	12	293	138377	138096	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	38946	416	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
9059447	9059447	PRJEB66218_P_NODE_197808_length_211_cov_0.866667_g195378_i0	PRJEB66218	197808	211	0.866667	1.82866737	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	335	1.6399999999999994e-87	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g195378	i0	95.261	2	211	10	100	0	1	211	777707	777917	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	422	335	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
11197933	11197933	PRJEB66218_P_NODE_212349_length_208_cov_0.884354_g209919_i0	PRJEB66218	212349	208	0.884354	1.83945632	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	363	7.409999999999998e-96	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g209919	i0	98.077	3.99038461538462	208	4	100	0	1	208	89663	89870	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	830	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
11609151	11609151	PRJEB66218_P_NODE_11430_length_1276_cov_12.934979_g9886_i0	PRJEB66218	11430	1276	12.934979	165.05033204	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	2006	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g9886	i0	95.004	299.16144200627	1281	58	100	6	1	1276	799591	800870	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	381730	2006	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12473616	12473616	PRJEB66218_P_NODE_22610_length_809_cov_6.312834_g20463_i0	PRJEB66218	22610	809	6.312834	51.07082706	Bacteria	2	Bacteria	Bacteria	1109	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g20463	i0	93.894	139.313967861557	737	42	91	3	74	808	851947	852682	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	112705	1114	0.995511669658887	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
14160839	14160839	PRJEB66218_P_NODE_213632_length_207_cov_8.102740_g211202_i0	PRJEB66218	213632	207	8.10274	16.7726718	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	278	2.75e-70	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g211202	i0	90.821	57.4444444444444	207	19	100	0	1	207	801410	801204	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11891	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18846691	18846691	PRJEB66218_P_NODE_62775_length_413_cov_0.701705_g60354_i0	PRJEB66218	62775	413	0.701705	2.89804165	Bacteria	2	Bacteria	Bacteria	531	4.18e-146	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g60354	i0	89.88	158.912832929782	415	38	100	4	1	413	658609	659021	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	65631	536	0.990671641791045	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
19258810	19258810	PRJEB66218_P_NODE_34536_length_612_cov_2.490018_g32162_i0	PRJEB66218	34536	612	2.490018	15.23891016	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	832	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g32162	i0	91.205	402.735294117647	614	50	100	3	1	612	110762	111373	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	246474	832	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
21396615	21396615	PRJEB66218_P_NODE_191077_length_214_cov_1.934641_g188647_i0	PRJEB66218	191077	214	1.934641	4.14013174	Candidatus Southlakia	3350975	Bacteria	Bacteria	333	6.009999999999999e-87	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g188647	i0	97.436	110.593457943925	195	5	91	0	20	214	905000	905194	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	23667	333	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
23084660	23084660	PRJEB66218_P_NODE_238339_length_202_cov_1.730496_g235908_i0	PRJEB66218	238339	202	1.730496	3.49560192	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	363	7.149999999999999e-96	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g235908	i0	99.01	232.613861386139	202	2	100	0	1	202	111143	110942	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	46988	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
26653839	26653839	PRJEB66218_P_NODE_166901_length_229_cov_2.000000_g164471_i0	PRJEB66218	166901	229	2	4.58	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	54.7	7.93e-7	NR	HVX48352.1	2973664	g164471	i0	41.1	1.61135371179039	56	33	73.4	0	171	4	8	63	HVX48352.1 ribosome recycling factor [Candidatus Saccharimonadales bacterium]	diamond	369	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27445149	27445149	PRJEB66218_P_NODE_202703_length_210_cov_0.872483_g200273_i0	PRJEB66218	202703	210	0.872483	1.8322143	Candidatus Saccharibacteria bacterium 32-5	1970480	Bacteria	Bacteria	62	2.03e-9	NR	OYX38951.1	1970480	g200273	i0	74.4	0.557142857142857	39	10	55.7	0	1	117	202	240	OYX38951.1 MAG: ribosomal RNA small subunit methyltransferase A [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	117	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-10
31045393	31045393	PRJEB66218_P_NODE_157435_length_236_cov_1.485714_g155005_i0	PRJEB66218	157435	236	1.485714	3.50628504	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	84.3	6.75e-18	NR	WP_260763596.1	2665156	g155005	i0	92	0.635593220338983	50	4	63.6	0	150	1	3	52	WP_260763596.1 fused MFS/spermidine synthase [Candidatus Mycosynbacter amalyticus]	diamond	150	84.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
31329555	31329555	PRJEB66218_P_NODE_230716_length_204_cov_0.909091_g228286_i0	PRJEB66218	230716	204	0.909091	1.85454564	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	61.6	4.87e-9	NR	MCL2037654.1	2026720	g228286	i0	50.8	3.54411764705882	61	30	89.7	0	187	5	800	860	MCL2037654.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	723	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31740629	31740629	PRJEB66218_P_NODE_211317_length_208_cov_0.884354_g208887_i0	PRJEB66218	211317	208	0.884354	1.83945632	Candidatus Saccharibacteria bacterium 32-5	1970481	Bacteria	Bacteria	139	4.11e-37	NR	OYX53248.1	1970481	g208887	i0	100	1.99038461538462	69	0	99.5	0	1	207	305	373	OYX53248.1 MAG: hypothetical protein B7Y92_03620, partial [Candidatus Saccharibacteria bacterium 32-50-13]	diamond	414	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-13
32398173	32398173	PRJEB66218_P_NODE_148059_length_243_cov_1.428571_g145630_i0	PRJEB66218	148059	243	1.428571	3.47142753	Bacillati	1783272	Bacteria	Bacteria	55.5	1.19e-6	NR	MCL2444833.1	2026720	g145630	i0	42.7	11.9506172839506	75	39	92.6	1	227	3	361	431	MCL2444833.1 IPT/TIG domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	2904	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32878248	32878248	PRJEB66218_P_NODE_230920_length_204_cov_0.909091_g228490_i0	PRJEB66218	230920	204	0.909091	1.85454564	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	63.9	7.39e-10	NR	HEX7368197.1	2973664	g228490	i0	45.3	0.941176470588235	64	35	94.1	0	203	12	349	412	HEX7368197.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	192	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;