metadata: contig_metadata: 19 rows where bioproject = "PRJNA505329", tax_clade = "Bacteria candidate phyla" and tax

19 rows where bioproject = "PRJNA505329", 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
1110206	1110206	PRJNA505329_P_NODE_14241_length_233_cov_2.766304_g13770_i0	PRJNA505329	14241	233	2.766304	6.44548832	Candidatus Southlakia	3350975	Bacteria	Bacteria	187	5.48e-43	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g13770	i0	100	79.1330472103004	101	0	85	0	133	233	905092	904992	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	18438	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
3034321	3034321	PRJNA505329_P_NODE_17843_length_216_cov_3.413174_g17372_i0	PRJNA505329	17843	216	3.413174	7.37245584	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	390	3.559999999999999e-104	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g17372	i0	99.533	246.74537037037	214	1	99	0	1	214	110268	110055	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	53297	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
3034657	3034657	PRJNA505329_P_NODE_4583_length_369_cov_3.112500_g4117_i0	PRJNA505329	4583	369	3.1125	11.485125	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	606	5.969999999999997e-169	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g4117	i0	96.721	191.314363143631	366	9	99	3	2	366	151244	150881	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	70595	606	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
6861125	6861125	PRJNA505329_P_NODE_26446_length_192_cov_2.153846_g25975_i0	PRJNA505329	26446	192	2.153846	4.13538432	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	346	6.77e-91	NTclustered	gi\|220682311\|gb\|FJ542918.1\|	179883	g25975	i0	99.474	98.8645833333333	190	1	99	0	3	192	83	272	Uncultured candidate division TM7 bacterium clone A10-07D 16S ribosomal RNA gene, partial sequence	blastn	18982	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6861470	6861470	PRJNA505329_P_NODE_8106_length_255_cov_2.398058_g7635_i0	PRJNA505329	8106	255	2.398058	6.1150479	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	460	3.25e-125	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g7635	i0	99.603	92.9647058823529	252	1	99	0	1	252	152814	152563	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	23706	460	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
9411645	9411645	PRJNA505329_P_NODE_4628_length_366_cov_4.085174_g4162_i0	PRJNA505329	4628	366	4.085174	14.95173684	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	555	2.1699999999999998e-153	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g4162	i0	94.215	223.983606557377	363	21	99	0	1	363	139192	138830	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	81978	555	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
14512386	14512386	PRJNA505329_P_NODE_36312_length_177_cov_3.984375_g35841_i0	PRJNA505329	36312	177	3.984375	7.05234375	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	309	8.04e-80	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g35841	i0	100	62.1920903954802	167	0	94	0	1	167	693802	693968	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	11008	309	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
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
24709497	24709497	PRJNA505329_P_NODE_45480_length_166_cov_0.888889_g45009_i0	PRJNA505329	45480	166	0.888889	1.47555574	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g45009	i0	100	58.0361445783133	163	0	98	0	1	163	111654	111492	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	9634	302	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae 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);;