metadata: contig_metadata: 10 rows where bioproject = "PRJNA399711" and tax

10 rows where bioproject = "PRJNA399711" 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
25973109	25973109	PRJNA399711_S_NODE_73868_length_173_cov_1.551471_g73726_i0	PRJNA399711	73868	173	1.551471	2.68404483	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	209	8.15e-50	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g73726	i0	88.889	107.50289017341	171	17	99	2	1	171	219941	220109	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	18598	209	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
26106176	26106176	PRJNA399711_S_NODE_100557_length_154_cov_18.094017_g100415_i0	PRJNA399711	100557	154	18.094017	27.86478618	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	241	2.51e-59	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g100415	i0	94.805	3	154	8	100	0	1	154	204948	205101	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	462	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
26109587	26109587	PRJNA399711_S_NODE_86661_length_163_cov_2.896825_g86519_i0	PRJNA399711	86661	163	2.896825	4.72182475	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	94	4.5400000000000005e-22	NR	HRK41121.1	2026720	g86519	i0	91.8	42.9018404907975	49	4	90.2	0	148	2	110	158	HRK41121.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Candidatus Saccharibacteria bacterium]	diamond	6993	94	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26243973	26243973	PRJNA399711_S_NODE_38422_length_219_cov_2.351648_g38280_i0	PRJNA399711	38422	219	2.351648	5.15010912	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	294	2.92e-75	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g38280	i0	91.204	0.986301369863014	216	19	99	0	1	216	54519	54304	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	216	294	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
27959756	27959756	PRJNA399711_P_NODE_11585_length_188_cov_3.774834_g11519_i0	PRJNA399711	11585	188	3.774834	7.09668792	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	70.5	4.88e-13	NR	MDO5343689.1	2026720	g11519	i0	60	1.91489361702128	60	22	92.6	1	187	14	103	162	MDO5343689.1 alpha/beta hydrolase [Candidatus Saccharibacteria bacterium]	diamond	360	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32958424	32958424	PRJNA399711_S_NODE_32114_length_233_cov_3.173469_g31972_i0	PRJNA399711	32114	233	3.173469	7.39418277	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	102	1.67e-24	NR	MCA9334820.1	2026720	g31972	i0	68.5	1.931330472103	73	23	94	0	221	3	151	223	MCA9334820.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	450	103	0.990291262135922	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
33043749	33043749	PRJNA399711_S_NODE_77492_length_170_cov_1.842105_g77350_i0	PRJNA399711	77492	170	1.842105	3.1315785	Bacillati	1783272	Bacteria	Bacteria	45.8	9.39e-4	NR	MBQ7040969.1	2026720	g77350	i0	70.8	1.23529411764706	24	7	42.4	0	3	74	196	219	MBQ7040969.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Candidatus Saccharibacteria bacterium]	diamond	210	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
33105508	33105508	PRJNA399711_S_NODE_40046_length_216_cov_1.541899_g39904_i0	PRJNA399711	40046	216	1.541899	3.33050184	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	63.2	6.1e-10	NR	MCA9332930.1	2026720	g39904	i0	38	1.94444444444444	71	43	97.2	1	210	1	4	74	MCA9332930.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	420	63.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
33105772	33105772	PRJNA399711_S_NODE_84398_length_165_cov_1.195312_g84256_i0	PRJNA399711	84398	165	1.195312	1.9722648	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	81.6	3.49e-17	NR	MBB1566001.1	2026720	g84256	i0	70.4	2.92727272727273	54	16	98.2	0	4	165	52	105	MBB1566001.1 di-trans,poly-cis-decaprenylcistransferase [Candidatus Saccharibacteria bacterium]	diamond	483	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
33122476	33122476	PRJNA399711_S_NODE_31607_length_234_cov_6.228426_g31465_i0	PRJNA399711	31607	234	6.228426	14.57451684	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	61.6	2.92e-9	NR	MEJ0073515.1	2026720	g31465	i0	77.4	0.794871794871795	31	7	39.7	0	3	95	185	215	MEJ0073515.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Candidatus Saccharibacteria bacterium]	diamond	186	61.6	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);;