metadata: contig_metadata: 11 rows where bioproject = "PRJNA879067", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA879067", 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
9781644	9781644	PRJNA879067_P_NODE_103688_length_250_cov_1.887006_g100202_i0	PRJNA879067	103688	250	1.887006	4.717515	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	113	2.84e-30	NR	RKW00526.1	1917697	g100202	i0	94.6	0.672	56	3	67.2	0	227	60	73	128	RKW00526.1 MAG: ATP-binding protein, partial [Candidatus Saccharimonas sp.]	diamond	168	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
9782301	9782301	PRJNA879067_P_NODE_24148_length_889_cov_5.637255_g21014_i0	PRJNA879067	24148	889	5.637255	50.11519695	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	434	4.8899999999999984e-151	NR	MBR3377935.1	2026720	g21014	i0	89.6	1.62654668166479	241	25	81.3	0	723	1	1	241	MBR3377935.1 50S ribosomal protein L2 [Candidatus Saccharibacteria bacterium]	diamond	1446	434	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13607451	13607451	PRJNA879067_P_NODE_105931_length_247_cov_1.770115_g102445_i0	PRJNA879067	105931	247	1.770115	4.37218405	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	296	9.34e-76	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g102445	i0	88.259	1	247	29	100	0	1	247	217756	218002	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	247	296	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
17433405	17433405	PRJNA879067_P_NODE_47874_length_543_cov_3.304255_g44398_i0	PRJNA879067	47874	543	3.304255	17.94210465	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	797	0	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g44398	i0	94.902	114.351749539595	510	25	94	1	34	543	597636	597128	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	62093	797	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
21258604	21258604	PRJNA879067_P_NODE_97377_length_272_cov_1.376884_g93891_i0	PRJNA879067	97377	272	1.376884	3.74512448	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	134	1.63e-36	NR	HSW90672.1	2973664	g93891	i0	71.9	1.94117647058824	89	25	98.2	0	268	2	33	121	HSW90672.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Saccharimonadales bacterium]	diamond	528	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
22916592	22916592	PRJNA879067_P_NODE_30278_length_759_cov_11.517493_g26965_i0	PRJNA879067	30278	759	11.517493	87.41777187	Bacteria	2	Bacteria	Bacteria	826	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g26965	i0	87.211	103.297760210804	735	83	96	10	1	731	905328	906055	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	78403	832	0.992788461538462	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
25081598	25081598	PRJNA879067_P_NODE_59580_length_452_cov_3.290237_g56095_i0	PRJNA879067	59580	452	3.290237	14.87187124	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	492	2.1799999999999996e-134	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g56095	i0	88	89.141592920354	425	39	94	2	1	425	138707	138295	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	40292	492	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
27624154	27624154	PRJNA879067_P_NODE_89764_length_299_cov_2.725664_g86278_i0	PRJNA879067	89764	299	2.725664	8.14973536	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	71.6	5.05e-12	NR	NCC19523.1	2026720	g86278	i0	42.4	0.923076923076923	92	52	91.3	1	2	274	463	554	NCC19523.1 RNA-directed DNA polymerase [Candidatus Saccharibacteria bacterium]	diamond	276	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30434755	30434755	PRJNA879067_P_NODE_70813_length_384_cov_1.289389_g67328_i0	PRJNA879067	70813	384	1.289389	4.95125376	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	71.2	1.88e-11	NR	MAU34011.1	2026720	g67328	i0	32.1	0.875	112	64	87.5	2	41	376	548	647	MAU34011.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	336	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30845228	30845228	PRJNA879067_P_NODE_91854_length_291_cov_2.743119_g88368_i0	PRJNA879067	91854	291	2.743119	7.98247629	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	122	3.22e-30	NR	MBR3332244.1	2026720	g88368	i0	64.7	0.876288659793814	85	30	87.6	0	28	282	370	454	MBR3332244.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	255	122	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32363390	32363390	PRJNA879067_P_NODE_107719_length_245_cov_0.895349_g104233_i0	PRJNA879067	107719	245	0.895349	2.19360505	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	125	6.179999999999998e-32	NR	HSX48993.1	2973664	g104233	i0	81.3	0.979591836734694	80	15	98	0	2	241	145	224	HSX48993.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	240	125	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;