metadata: contig_metadata: 17 rows where bioproject = "PRJNA526367", tax_clade = "Bacteria candidate phyla" and tax

17 rows where bioproject = "PRJNA526367", 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_genus	tax_species
6217420	6217420	PRJNA526367_P_NODE_51265_length_166_cov_3.521368_g51055_i0	PRJNA526367	51265	166	3.521368	5.84547088	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	283	4.53e-72	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g51055	i0	98.742	1.91566265060241	159	2	96	0	8	166	691087	690929	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	318	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
8766395	8766395	PRJNA526367_P_NODE_13847_length_324_cov_3.036364_g13638_i0	PRJNA526367	13847	324	3.036364	9.83781936	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	185	2.88e-42	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g13638	i0	100	51.9413580246914	100	0	60	0	225	324	148162	148261	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	16829	185	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
15798749	15798749	PRJNA526367_P_NODE_45653_length_173_cov_6.572581_g45443_i0	PRJNA526367	45653	173	6.572581	11.37056513	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	95.5	2.8000000000000004e-22	NR	MBC7512126.1	2026720	g45443	i0	95.8	3.32947976878613	48	2	83.2	0	23	166	1	48	MBC7512126.1 ParA family protein [Candidatus Saccharibacteria bacterium]	diamond	576	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
23448727	23448727	PRJNA526367_P_NODE_62619_length_154_cov_9.085714_g62409_i0	PRJNA526367	62619	154	9.085714	13.99199956	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	143	7.289999999999999e-30	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g62409	i0	84.564	0.967532467532468	149	18	96	3	4	151	368841	368697	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	149	143	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
27456816	27456816	PRJNA526367_P_NODE_9343_length_324_cov_3.756364_g9134_i0	PRJNA526367	9343	324	3.756364	12.17061936	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	62	1.62e-8	NR	HEX8227426.1	2973664	g9134	i0	84.4	0.592592592592593	32	5	29.6	0	324	229	342	373	HEX8227426.1 sugar transferase [Candidatus Saccharimonadales bacterium]	diamond	192	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28498716	28498716	PRJNA526367_P_NODE_41547_length_180_cov_4.396947_g41337_i0	PRJNA526367	41547	180	4.396947	7.9145046	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	104	1.63e-25	NR	MCA9309401.1	2026720	g41337	i0	86	0.95	57	8	95	0	179	9	73	129	MCA9309401.1 rhodanese-related sulfurtransferase [Candidatus Saccharibacteria bacterium]	diamond	171	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28561811	28561811	PRJNA526367_P_NODE_30847_length_323_cov_1.981752_g30638_i0	PRJNA526367	30847	323	1.981752	6.40105896	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	103	2.1699999999999998e-23	NR	HBO64924.1	2026720	g30638	i0	55.1	0.993808049535604	107	25	99.4	1	321	1	103	186	HBO64924.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	321	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29824493	29824493	PRJNA526367_P_NODE_29651_length_324_cov_1.567273_g29442_i0	PRJNA526367	29651	324	1.567273	5.07796452	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	65.1	1.36e-9	NR	RTK94962.1	2026720	g29442	i0	97	4.27777777777778	33	1	30.6	0	324	226	224	256	RTK94962.1 MAG: ribonuclease Y [Candidatus Saccharibacteria bacterium]	diamond	1386	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30045624	30045624	PRJNA526367_P_NODE_40631_length_182_cov_2.195489_g40421_i0	PRJNA526367	40631	182	2.195489	3.99578998	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94.4	9.96e-21	NR	MCA9334911.1	2026720	g40421	i0	79.3	1.91208791208791	58	10	92.3	1	8	175	206	263	MCA9334911.1 glycosyltransferase family 2 protein [Candidatus Saccharibacteria bacterium]	diamond	348	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30804055	30804055	PRJNA526367_P_NODE_59574_length_158_cov_9.862385_g59364_i0	PRJNA526367	59574	158	9.862385	15.5825683	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	77.8	1.11e-15	NR	HSH17798.1	2973664	g59364	i0	80	0.949367088607595	50	10	94.9	0	2	151	59	108	HSH17798.1 magnesium chelatase domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	150	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31214413	31214413	PRJNA526367_P_NODE_61615_length_156_cov_3.813084_g61405_i0	PRJNA526367	61615	156	3.813084	5.94841104	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	47.8	1.9e-4	NR	MBA3758678.1	2026720	g61405	i0	76.9	0.5	26	6	50	0	107	30	1	26	MBA3758678.1 CapA family protein [Candidatus Saccharibacteria bacterium]	diamond	78	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31324873	31324873	PRJNA526367_P_NODE_22715_length_324_cov_2.203636_g22506_i0	PRJNA526367	22715	324	2.203636	7.13978064	Pseudomonadati	3379134	Bacteria	Bacteria	58.2	3.52e-7	NR	TWP21115.1	713049	g22506	i0	100	17.4166666666667	32	0	29.6	0	4	99	275	306	TWP21115.1 preprotein translocase subunit SecY, partial [TM7 phylum sp. oral taxon 346]	diamond	5643	58.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 346
31563006	31563006	PRJNA526367_P_NODE_52336_length_165_cov_4.603448_g52126_i0	PRJNA526367	52336	165	4.603448	7.5956892	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	76.6	1.28e-15	NR	MDB5178053.1	2026720	g52126	i0	76.9	0.709090909090909	39	9	70.9	0	2	118	150	188	MDB5178053.1 fimbrial protein pilin [Candidatus Saccharibacteria bacterium]	diamond	117	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31594618	31594618	PRJNA526367_P_NODE_49396_length_168_cov_3.327731_g49186_i0	PRJNA526367	49396	168	3.327731	5.59058808	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	57.8	6.55e-8	NR	HSX30522.1	2973664	g49186	i0	88.9	0.482142857142857	27	3	48.2	0	82	2	1	27	HSX30522.1 methionine--tRNA ligase [Candidatus Saccharimonadales bacterium]	diamond	81	57.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31594621	31594621	PRJNA526367_P_NODE_50896_length_166_cov_7.376068_g50686_i0	PRJNA526367	50896	166	7.376068	12.24427288	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	89	3.08e-20	NR	MEJ0073200.1	2026720	g50686	i0	85.5	0.993975903614458	55	8	99.4	0	2	166	23	77	MEJ0073200.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	165	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32005661	32005661	PRJNA526367_P_NODE_22818_length_324_cov_2.196364_g22609_i0	PRJNA526367	22818	324	2.196364	7.11621936	TM7 phylum sp. oral taxon 35	713052	Bacteria	Bacteria	68.6	6.35e-11	NR	TWP08687.1	713052	g22609	i0	100	0.305555555555556	33	0	30.6	0	225	323	114	146	TWP08687.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [TM7 phylum sp. oral taxon 350]	diamond	99	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 350
32005663	32005663	PRJNA526367_P_NODE_33458_length_223_cov_1.172414_g33248_i0	PRJNA526367	33458	223	1.172414	2.61448322	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	126	3.14e-33	NR	MBA3758157.1	2026720	g33248	i0	82.9	0.94170403587444	70	12	94.2	0	8	217	52	121	MBA3758157.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Candidatus Saccharibacteria bacterium]	diamond	210	126	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);;