metadata: contig_metadata: 13 rows where bioproject = "PRJDB9741" and tax

13 rows where bioproject = "PRJDB9741" 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
11013	11013	PRJDB9741_P_NODE_36721_length_162_cov_2.628319_g36404_i0	PRJDB9741	36721	162	2.628319	4.25787678	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g36404	i0	100	0.172839506172839	28	0	17	0	1	28	1046402	1046429	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
12764478	12764478	PRJDB9741_P_NODE_26451_length_168_cov_1.630252_g26134_i0	PRJDB9741	26451	168	1.630252	2.73882336	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g26134	i0	97.024	8.92857142857143	168	5	100	0	1	168	93239	93072	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1500	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
14038977	14038977	PRJDB9741_P_NODE_26432_length_168_cov_1.663866_g26115_i0	PRJDB9741	26432	168	1.663866	2.79529488	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26115	i0	90.533	11.1488095238095	169	15	100	1	1	168	221451	221619	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	1873	222	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
14039171	14039171	PRJDB9741_P_NODE_8772_length_213_cov_3.329268_g8455_i0	PRJDB9741	8772	213	3.329268	7.09134084	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.15e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8455	i0	94.811	77.4084507042254	212	11	99	0	1	212	221191	221402	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	16488	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
16284451	16284451	PRJDB9741_P_NODE_2233_length_500_cov_2.847007_g1920_i0	PRJDB9741	2233	500	2.847007	14.235035	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	763	0	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g1920	i0	94.223	216.902	502	25	100	4	1	500	146310	146809	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	108451	763	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
16587970	16587970	PRJDB9741_P_NODE_8954_length_211_cov_3.845679_g8637_i0	PRJDB9741	8954	211	3.845679	8.11438269	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	368	1.6200000000000002e-97	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8637	i0	98.104	64.0947867298578	211	4	100	0	1	211	222683	222473	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	13524	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17862810	17862810	PRJDB9741_P_NODE_35735_length_163_cov_0.894737_g35418_i0	PRJDB9741	35735	163	0.894737	1.45842131	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	113	6.14e-21	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g35418	i0	83.077	0.797546012269939	130	16	79	4	23	151	440664	440540	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	130	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23934321	23934321	PRJDB9741_P_NODE_5719_length_263_cov_1.471963_g5403_i0	PRJDB9741	5719	263	1.471963	3.87126269	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	363	9.769999999999999e-96	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g5403	i0	91.76	80.7490494296578	267	13	100	6	1	263	142474	142213	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	21237	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
28043293	28043293	PRJDB9741_P_NODE_36225_length_163_cov_0.894737_g35908_i0	PRJDB9741	36225	163	0.894737	1.45842131	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	66.2	6.49e-11	NR	MBP7760746.1	2026720	g35908	i0	55.6	0.993865030674847	54	24	99.4	0	2	163	24	77	MBP7760746.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	162	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30664430	30664430	PRJDB9741_P_NODE_43413_length_151_cov_2.500000_g43096_i0	PRJDB9741	43413	151	2.5	3.775	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	99	8.19e-25	NR	MBB1567657.1	2026720	g43096	i0	95.9	0.973509933774834	49	2	97.4	0	149	3	97	145	MBB1567657.1 septum formation initiator family protein [Candidatus Saccharibacteria bacterium]	diamond	147	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32435630	32435630	PRJDB9741_P_NODE_25319_length_170_cov_1.239669_g25002_i0	PRJDB9741	25319	170	1.239669	2.1074373	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	112	1.46e-27	NR	RKW01118.1	1917697	g25002	i0	96.4	0.970588235294118	55	2	97.1	0	5	169	309	363	RKW01118.1 MAG: hypothetical protein D8B38_04740 [Candidatus Saccharimonas sp.]	diamond	165	112	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
32556228	32556228	PRJDB9741_P_NODE_9659_length_210_cov_2.472050_g9342_i0	PRJDB9741	9659	210	2.47205	5.191305	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	64.3	4.79e-10	NR	RKW04463.1	1917697	g9342	i0	96.9	1.47142857142857	32	1	45.7	0	208	113	2	33	RKW04463.1 MAG: pyridine nucleotide-disulfide oxidoreductase, partial [Candidatus Saccharimonas sp.]	diamond	309	64.7	0.993817619783617	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
32902186	32902186	PRJDB9741_P_NODE_34200_length_164_cov_0.886957_g33883_i0	PRJDB9741	34200	164	0.886957	1.45460948	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	104	1.11e-24	NR	HPQ82428.1	1917697	g33883	i0	94.4	1.97560975609756	54	3	98.8	0	164	3	181	234	HPQ82428.1 HAD-IC family P-type ATPase [Candidatus Saccharimonas sp.]	diamond	324	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.

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