metadata: contig_metadata: 10 rows where bioproject = "PRJNA1182301", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA1182301", 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
6696978	6696978	PRJNA1182301_P_NODE_57666_length_245_cov_0.895349_g57541_i0	PRJNA1182301	57666	245	0.895349	2.19360505	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|1805661181\|gb\|CP047921.1\|	713059	g57541	i0	91.837	9.95510204081633	245	20	100	0	1	245	816505	816261	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS05P-B chromosome, complete genome	blastn	2439	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
15621589	15621589	PRJNA1182301_P_NODE_45553_length_255_cov_1.181319_g45428_i0	PRJNA1182301	45553	255	1.181319	3.01236345	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	158	8.27e-43	NR	WP_129693694.1	1986206	g45428	i0	97.6	2.96470588235294	84	2	98.8	0	253	2	63	146	WP_129693694.1 type I DNA topoisomerase [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	756	159	0.993710691823899	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
15621618	15621618	PRJNA1182301_P_NODE_46593_length_253_cov_2.250000_g46468_i0	PRJNA1182301	46593	253	2.25	5.6925	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	401	1.9799999999999994e-107	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g46468	i0	95.257	6.91304347826087	253	12	100	0	1	253	434458	434206	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1749	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
19444346	19444346	PRJNA1182301_P_NODE_25416_length_281_cov_2.072115_g25291_i0	PRJNA1182301	25416	281	2.072115	5.82264315	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	1.0299999999999997e-110	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g25291	i0	93.214	2.98932384341637	280	19	99	0	1	280	603439	603160	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	840	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28146289	28146289	PRJNA1182301_P_NODE_38005_length_264_cov_2.628272_g37880_i0	PRJNA1182301	38005	264	2.628272	6.93863808	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	116	7.07e-28	NR	HYH92452.1	2973664	g37880	i0	75.3	6.05681818181818	89	21	100	1	264	1	377	465	HYH92452.1 S8 family serine peptidase [Candidatus Saccharimonadales bacterium]	diamond	1599	116	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28398666	28398666	PRJNA1182301_P_NODE_48186_length_251_cov_2.140449_g48061_i0	PRJNA1182301	48186	251	2.140449	5.37252699	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	89	4.87e-19	NR	MEO8912199.1	1917697	g48061	i0	79.2	1.14741035856574	48	10	57.4	0	180	37	69	116	MEO8912199.1 FISUMP domain-containing protein [Candidatus Saccharimonas sp.]	diamond	288	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29282551	29282551	PRJNA1182301_P_NODE_40229_length_261_cov_3.106383_g40104_i0	PRJNA1182301	40229	261	3.106383	8.10765963	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	79.7	3.49e-17	NR	HRJ06203.1	2026720	g40104	i0	85.4	0.551724137931034	48	2	55.2	1	3	146	57	99	HRJ06203.1 RNA-binding protein [Candidatus Saccharibacteria bacterium]	diamond	144	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30564941	30564941	PRJNA1182301_P_NODE_30753_length_274_cov_1.532338_g30628_i0	PRJNA1182301	30753	274	1.532338	4.19860612	Bacteria	2	Bacteria	Bacteria	167	1.0899999999999999e-47	NR	MBC7564998.1	2026720	g30628	i0	88.9	6.95255474452555	90	10	98.5	0	1	270	82	171	MBC7564998.1 pyruvate kinase [Candidatus Saccharibacteria bacterium]	diamond	1905	167	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30862097	30862097	PRJNA1182301_P_NODE_50214_length_250_cov_0.870056_g50089_i0	PRJNA1182301	50214	250	0.870056	2.17514	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	58.5	3.83e-8	NR	PID31589.1	2026720	g50089	i0	41	3.984	83	49	99.6	0	2	250	103	185	PID31589.1 MAG: dephospho-CoA kinase [Candidatus Saccharibacteria bacterium]	diamond	996	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31482140	31482140	PRJNA1182301_P_NODE_39776_length_262_cov_1.629630_g39651_i0	PRJNA1182301	39776	262	1.62963	4.2696306	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	62.4	2.52e-9	NR	TWP17489.1	713054	g39651	i0	82.9	2.80534351145038	35	6	40.1	0	260	156	200	234	TWP17489.1 RimK family alpha-L-glutamate ligase, partial [TM7 phylum sp. oral taxon 352]	diamond	735	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 352

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