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

19 rows where bioproject = "PRJNA1067370", 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
2731782	2731782	PRJNA1067370_S_NODE_5663_length_250_cov_1.209040_g5637_i0	PRJNA1067370	5663	250	1.20904	3.0226	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g5637	i0	99.6	121.688	250	1	100	0	1	250	852511	852262	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	30422	457	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
2731783	2731783	PRJNA1067370_S_NODE_5743_length_249_cov_1.312500_g5717_i0	PRJNA1067370	5743	249	1.3125	3.268125	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g5717	i0	100	96.5341365461847	246	0	99	0	4	249	852103	851858	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	24037	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
7833802	7833802	PRJNA1067370_S_NODE_4307_length_277_cov_2.205882_g4281_i0	PRJNA1067370	4307	277	2.205882	6.11029314	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g4281	i0	100	101.032490974729	277	0	100	0	1	277	850094	849818	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	27986	512	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
10384574	10384574	PRJNA1067370_S_NODE_649_length_519_cov_2.244395_g623_i0	PRJNA1067370	649	519	2.244395	11.64841005	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	959	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g623	i0	100	235.391136801541	519	0	100	0	1	519	851005	850487	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	122168	959	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
20582407	20582407	PRJNA1067370_S_NODE_5877_length_247_cov_2.212644_g5851_i0	PRJNA1067370	5877	247	2.212644	5.46523068	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g5851	i0	100	107.668016194332	247	0	100	0	1	247	852518	852764	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	26594	457	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
24406474	24406474	PRJNA1067370_P_NODE_107660_length_243_cov_0.905882_g107111_i0	PRJNA1067370	107660	243	0.905882	2.20129326	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	388	1.47e-103	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g107111	i0	95.473	264.843621399177	243	11	100	0	1	243	884368	884126	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	64357	388	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27667563	27667563	PRJNA1067370_P_NODE_110904_length_242_cov_0.911243_g110355_i0	PRJNA1067370	110904	242	0.911243	2.20520806	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	98.2	8.89e-24	NR	HEU4715933.1	2973664	g110355	i0	74.2	1.64876033057851	66	16	81.8	1	241	44	102	166	HEU4715933.1 SRPBCC domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	399	98.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27667650	27667650	PRJNA1067370_P_NODE_82924_length_250_cov_0.870056_g82375_i0	PRJNA1067370	82924	250	0.870056	2.17514	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	87	4.12e-19	NR	HEY5268570.1	2973664	g82375	i0	53.3	2.772	75	35	90	0	233	9	115	189	HEY5268570.1 GIY-YIG nuclease family protein [Candidatus Saccharimonadales bacterium]	diamond	693	87	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27722690	27722690	PRJNA1067370_P_NODE_38824_length_323_cov_0.924000_g38276_i0	PRJNA1067370	38824	323	0.924	2.98452	Bacillati	1783272	Bacteria	Bacteria	52.8	3.03e-5	NR	PID33203.1	2026720	g38276	i0	37.1	3.75232198142415	70	39	60.4	1	58	252	2162	2231	PID33203.1 MAG: hypothetical protein CR969_02000 [Candidatus Saccharibacteria bacterium]	diamond	1212	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27785657	27785657	PRJNA1067370_P_NODE_91644_length_248_cov_0.880000_g91095_i0	PRJNA1067370	91644	248	0.88	2.1824	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	47.8	4.4e-4	NR	MFC2369917.1	1917697	g91095	i0	41.5	1.57258064516129	65	32	77.4	2	8	199	80	139	MFC2369917.1 hypothetical protein [Candidatus Saccharimonas sp.]	diamond	390	48.1	0.993762993762994	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
28290462	28290462	PRJNA1067370_P_NODE_56206_length_286_cov_0.910798_g55657_i0	PRJNA1067370	56206	286	0.910798	2.60488228	Bacteria	2	Bacteria	Bacteria	69.3	2.71e-11	NR	QQG51344.1	2026720	g55657	i0	69	2.12937062937063	42	13	44.1	0	126	1	7	48	QQG51344.1 MAG: histidine--tRNA ligase [Candidatus Saccharibacteria bacterium]	diamond	609	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30035747	30035747	PRJNA1067370_P_NODE_96771_length_246_cov_0.890173_g96222_i0	PRJNA1067370	96771	246	0.890173	2.18982558	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	124	1.2699999999999998e-31	NR	TAH31813.1	2026720	g96222	i0	88.9	0.878048780487805	72	8	87.8	0	29	244	259	330	TAH31813.1 MAG: cell division protein FtsW [Candidatus Saccharibacteria bacterium]	diamond	216	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30225191	30225191	PRJNA1067370_P_NODE_77192_length_254_cov_1.276243_g76643_i0	PRJNA1067370	77192	254	1.276243	3.24165722	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	77	2.87e-15	NR	MCA9309021.1	2026720	g76643	i0	48.8	0.968503937007874	82	33	96.9	2	251	6	42	114	MCA9309021.1 ferritin-like domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	246	77	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30312146	30312146	PRJNA1067370_P_NODE_88112_length_249_cov_0.875000_g87563_i0	PRJNA1067370	88112	249	0.875	2.17875	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	160	2.5e-48	NR	HMQ96049.1	2026720	g87563	i0	95.2	11	83	4	100	0	249	1	43	125	HMQ96049.1 NUDIX domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	2739	160	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30825457	30825457	PRJNA1067370_P_NODE_54694_length_288_cov_1.153488_g54145_i0	PRJNA1067370	54694	288	1.153488	3.32204544	Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1	2013831	Bacteria	Bacteria	63.9	2.02e-10	NR	PKL30975.1	2013831	g54145	i0	51.6	0.645833333333333	62	30	64.6	0	5	190	79	140	PKL30975.1 MAG: hypothetical protein CVV43_04610 [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1]	diamond	186	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1
31204110	31204110	PRJNA1067370_P_NODE_102915_length_244_cov_0.900585_g102366_i0	PRJNA1067370	102915	244	0.900585	2.1974274	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	70.9	6.26e-13	NR	HSW91459.1	2973664	g102366	i0	53.5	0.872950819672131	71	32	86.1	1	211	2	41	111	HSW91459.1 PilN domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	213	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31860356	31860356	PRJNA1067370_P_NODE_96497_length_246_cov_0.890173_g95948_i0	PRJNA1067370	96497	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	2.65e-10	NR	MBC7943442.1	2026720	g95948	i0	86.8	13.4146341463415	38	5	46.3	0	11	124	422	459	MBC7943442.1 chromosomal replication initiator protein DnaA [Candidatus Saccharibacteria bacterium]	diamond	3300	65.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32058652	32058652	PRJNA1067370_P_NODE_30018_length_355_cov_2.120567_g29470_i0	PRJNA1067370	30018	355	2.120567	7.52801285	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	75.1	5.83e-13	NR	MCW1907896.1	2026720	g29470	i0	48.1	0.667605633802817	79	40	65.9	1	72	305	41	119	MCW1907896.1 fibronectin type III domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	237	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32533604	32533604	PRJNA1067370_P_NODE_91579_length_248_cov_0.880000_g91030_i0	PRJNA1067370	91579	248	0.88	2.1824	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.6	1.8e-19	NR	HRF28823.1	2026720	g91030	i0	51.9	0.979838709677419	81	39	98	0	5	247	44	124	HRF28823.1 HAD family hydrolase [Candidatus Saccharibacteria bacterium]	diamond	243	88.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);;