metadata: contig_metadata: 15 rows where bioproject = "PRJNA1137393", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA1137393", 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
5387923	5387923	PRJNA1137393_P_NODE_37545_length_171_cov_1.344262_g37029_i0	PRJNA1137393	37545	171	1.344262	2.29868802	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	255	1.02e-63	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g37029	i0	93.567	5.62573099415205	171	11	100	0	1	171	849915	850085	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	962	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5388013	5388013	PRJNA1137393_P_NODE_60705_length_164_cov_1.504348_g60189_i0	PRJNA1137393	60705	164	1.504348	2.46713072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g60189	i0	96.341	37.859756097561	164	6	100	0	1	164	636081	636244	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	6209	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6134925	6134925	PRJNA1137393_P_NODE_38705_length_170_cov_0.809917_g38189_i0	PRJNA1137393	38705	170	0.809917	1.3768589	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g38189	i0	95.679	61.6764705882353	162	6	95	1	1	161	694875	694714	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	10485	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
8685114	8685114	PRJNA1137393_P_NODE_12367_length_238_cov_3.079365_g11851_i0	PRJNA1137393	12367	238	3.079365	7.3288887	Bacteria	2	Bacteria	Bacteria	401	1.8399999999999994e-107	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g11851	i0	97.083	283.457983193277	240	3	100	3	1	238	800134	800371	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	67463	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14313631	14313631	PRJNA1137393_P_NODE_28732_length_183_cov_2.373134_g28216_i0	PRJNA1137393	28732	183	2.373134	4.34283522	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.949999999999999e-68	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g28216	i0	93.443	60.4590163934426	183	10	99	2	2	183	799953	800134	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11064	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22708900	22708900	PRJNA1137393_P_NODE_12658_length_236_cov_1.358289_g12142_i0	PRJNA1137393	12658	236	1.358289	3.20556204	Bacteria	2	Bacteria	Bacteria	387	5.11e-103	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g12142	i0	96.186	187.525423728814	236	9	100	0	1	236	850590	850825	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	44256	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23237004	23237004	PRJNA1137393_P_NODE_34159_length_175_cov_1.706349_g33643_i0	PRJNA1137393	34159	175	1.706349	2.98611075	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g33643	i0	99.419	272.811428571429	172	1	98	0	4	175	599004	598833	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	47742	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
26880723	26880723	PRJNA1137393_P_NODE_69001_length_163_cov_0.912281_g68485_i0	PRJNA1137393	69001	163	0.912281	1.48701803	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	71.2	1.08e-12	NR	HEY1063943.1	2973664	g68485	i0	66	0.975460122699387	53	18	97.5	0	1	159	237	289	HEY1063943.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	159	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27323302	27323302	PRJNA1137393_P_NODE_68923_length_163_cov_0.912281_g68407_i0	PRJNA1137393	68923	163	0.912281	1.48701803	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	100	2.9099999999999996e-23	NR	MBP9667703.1	2026720	g68407	i0	88.9	0.993865030674847	54	6	99.4	0	2	163	363	416	MBP9667703.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	162	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27691617	27691617	PRJNA1137393_P_NODE_55924_length_165_cov_1.948276_g55408_i0	PRJNA1137393	55924	165	1.948276	3.2146554	Bacteria	2	Bacteria	Bacteria	106	4.14e-25	NR	NCC20352.1	2026720	g55408	i0	90.9	7	55	5	100	0	1	165	320	374	NCC20352.1 M1 family peptidase [Candidatus Saccharibacteria bacterium]	diamond	1155	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28965330	28965330	PRJNA1137393_P_NODE_59108_length_165_cov_0.896552_g58592_i0	PRJNA1137393	59108	165	0.896552	1.4793108	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	84.3	2.42e-18	NR	MEO5949493.1	1917697	g58592	i0	71.7	0.963636363636364	53	15	96.4	0	6	164	129	181	MEO5949493.1 phosphatase PAP2 family protein [Candidatus Saccharimonas sp.]	diamond	159	84.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29691030	29691030	PRJNA1137393_P_NODE_63890_length_164_cov_0.904348_g63374_i0	PRJNA1137393	63890	164	0.904348	1.48313072	Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_	1802132	Bacteria	Bacteria	58.5	3.38e-8	NR	OGL22522.1	1802132	g63374	i0	50	0.98780487804878	54	27	98.8	0	164	3	626	679	OGL22522.1 MAG: hypothetical protein A2707_04325 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15]	diamond	162	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15
31587529	31587529	PRJNA1137393_P_NODE_40216_length_169_cov_0.866667_g39700_i0	PRJNA1137393	40216	169	0.866667	1.46466723	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	101	1.3299999999999995e-23	NR	HSI63942.1	2890869	g39700	i0	80.4	3.8698224852071	56	11	99.4	0	168	1	81	136	HSI63942.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	654	101	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
31840262	31840262	PRJNA1137393_P_NODE_70677_length_162_cov_0.920354_g70161_i0	PRJNA1137393	70677	162	0.920354	1.49097348	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	1.93e-9	NR	MBP6962308.1	2026720	g70161	i0	52.8	1.96296296296296	53	25	98.1	0	2	160	98	150	MBP6962308.1 ComEC/Rec2 family competence protein [Candidatus Saccharibacteria bacterium]	diamond	318	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32462371	32462371	PRJNA1137393_P_NODE_68859_length_163_cov_0.912281_g68343_i0	PRJNA1137393	68859	163	0.912281	1.48701803	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	89	8.18e-21	NR	WP_015641906.1	1332188	g68343	i0	84.9	2.92638036809816	53	8	97.5	0	161	3	61	113	WP_015641906.1 transcription elongation factor GreA [Candidatus Saccharimonas aalborgensis]	diamond	477	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis

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);;