metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA505329" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA505329" 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
19609506	19609506	PRJNA505329_P_NODE_40796_length_170_cov_4.041322_g40325_i0	PRJNA505329	40796	170	4.041322	6.8702474	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	112	5.85e-28	NR	NCO10741.1	2026720	g40325	i0	94.6	7.90588235294118	56	3	98.8	0	168	1	80	135	NCO10741.1 recombinase RecA [Candidatus Saccharibacteria bacterium]	diamond	1344	112	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26824062	26824062	PRJNA505329_P_NODE_14281_length_233_cov_2.766304_g13810_i0	PRJNA505329	14281	233	2.766304	6.44548832	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	47.8	5.33e-4	NR	MCL1839690.1	2026720	g13810	i0	64.5	2.43347639484979	31	11	39.9	0	227	135	264	294	MCL1839690.1 DNA replication and repair protein RecF [Candidatus Saccharibacteria bacterium]	diamond	567	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27250546	27250546	PRJNA505329_P_NODE_9943_length_233_cov_5.298913_g9472_i0	PRJNA505329	9943	233	5.298913	12.34646729	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	104	1.98e-25	NR	MEO8691604.1	1917697	g9472	i0	54.7	4.09442060085837	106	19	99.1	1	233	3	32	137	MEO8691604.1 RimK family alpha-L-glutamate ligase [Candidatus Saccharimonas sp.]	diamond	954	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
27898191	27898191	PRJNA505329_P_NODE_45425_length_166_cov_0.888889_g44954_i0	PRJNA505329	45425	166	0.888889	1.47555574	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.6	1.87e-19	NR	MDB5162707.1	2026720	g44954	i0	94.3	1.91566265060241	53	3	95.8	0	6	164	230	282	MDB5162707.1 atpG [Candidatus Saccharibacteria bacterium]	diamond	318	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28119278	28119278	PRJNA505329_P_NODE_31885_length_184_cov_2.970370_g31414_i0	PRJNA505329	31885	184	2.97037	5.4654808	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	87.8	2.31e-19	NR	HEU5122105.1	2973664	g31414	i0	71.7	1.95652173913043	60	17	97.8	0	4	183	146	205	HEU5122105.1 YebC/PmpR family DNA-binding transcriptional regulator [Candidatus Saccharimonadales bacterium]	diamond	360	87.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28576805	28576805	PRJNA505329_P_NODE_11647_length_233_cov_3.331522_g11176_i0	PRJNA505329	11647	233	3.331522	7.76244626	Bacteria	2	Bacteria	Bacteria	68.6	2.6e-11	NR	KKW02919.1	1619071	g11176	i0	97	7.6480686695279	33	1	42.5	0	2	100	567	599	KKW02919.1 MAG: Type IV secretory pathway VirB4 component-like protein [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9]	diamond	1782	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9
29476720	29476720	PRJNA505329_P_NODE_45910_length_165_cov_2.663793_g45439_i0	PRJNA505329	45910	165	2.663793	4.39525845	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	67.4	1.58e-11	NR	MBI3889681.1	2026720	g45439	i0	53.7	0.981818181818182	54	25	98.2	0	1	162	105	158	MBI3889681.1 sphingosine kinase [Candidatus Saccharibacteria bacterium]	diamond	162	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31040678	31040678	PRJNA505329_P_NODE_33795_length_181_cov_3.090909_g33324_i0	PRJNA505329	33795	181	3.090909	5.59454529	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	122	1.63e-30	NR	MCA9338224.1	2026720	g33324	i0	95	16.9060773480663	60	3	99.4	0	180	1	496	555	MCA9338224.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saccharibacteria bacterium]	diamond	3060	122	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31562682	31562682	PRJNA505329_P_NODE_25116_length_194_cov_2.813793_g24645_i0	PRJNA505329	25116	194	2.813793	5.45875842	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	1.27e-9	NR	MDB5167905.1	2026720	g24645	i0	81.3	1.48453608247423	32	6	49.5	0	5	100	153	184	MDB5167905.1 putative ribonuclease [Candidatus Saccharibacteria bacterium]	diamond	288	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32258800	32258800	PRJNA505329_P_NODE_10438_length_233_cov_4.157609_g9967_i0	PRJNA505329	10438	233	4.157609	9.68722897	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	64.7	5.87e-10	NR	HRF28388.1	2026720	g9967	i0	93.9	0.424892703862661	33	2	42.5	0	100	2	111	143	HRF28388.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	99	64.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32322049	32322049	PRJNA505329_P_NODE_42779_length_168_cov_2.260504_g42308_i0	PRJNA505329	42779	168	2.260504	3.79764672	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	45.8	0.00109	NR	MCA9338359.1	2026720	g42308	i0	48.1	0.964285714285714	54	27	94.6	1	9	167	129	182	MCA9338359.1 endolytic transglycosylase MltG [Candidatus Saccharibacteria bacterium]	diamond	162	45.8	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);;