metadata: contig_metadata: 20 rows where bioproject = "PRJNA745553" and tax

20 rows where bioproject = "PRJNA745553" and tax_clade = "Bacteria candidate phyla"

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
724032	724032	PRJNA745553_S_NODE_1341_length_721_cov_145.149691_g1213_i0	PRJNA745553	1341	721	145.149691	1046.52927211	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	894	0	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g1213	i0	92.742	230.037447988904	620	44	86	1	15	634	667181	667799	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	165857	894	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
2000126	2000126	PRJNA745553_S_NODE_1562_length_696_cov_17.237560_g216_i1	PRJNA745553	1562	696	17.23756	119.9734176	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	797	0	NTclustered	gi\|2874253748\|emb\|OY969622.1\|	2803731	g216	i1	89.302	219.261494252874	645	56	92	11	25	662	372480	373118	MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1	blastn	152606	797	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
2000356	2000356	PRJNA745553_S_NODE_27902_length_233_cov_4.431250_g27707_i0	PRJNA745553	27902	233	4.43125	10.3248125	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g27707	i0	94.811	239.124463519313	212	11	91	0	1	212	220105	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	55716	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12203724	12203724	PRJNA745553_S_NODE_24890_length_248_cov_8.205714_g24695_i0	PRJNA745553	24890	248	8.205714	20.35017072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	265	2.6499999999999997e-66	NTclustered	gi\|1958070929\|gb\|CP064991.1\|	2026720	g24695	i0	88.584	75.7661290322581	219	24	88	1	14	232	87121	87338	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BAT3C.362_fly chromosome, complete genome	blastn	18790	265	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12203749	12203749	PRJNA745553_S_NODE_26630_length_241_cov_5.934524_g26435_i0	PRJNA745553	26630	241	5.934524	14.30220284	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	313	9.01e-81	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26435	i0	92.342	88.4647302904564	222	13	91	4	10	229	219894	220113	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	21320	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12678276	12678276	PRJNA745553_S_NODE_20750_length_271_cov_6.797980_g20555_i0	PRJNA745553	20750	271	6.79798	18.4225258	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	311	3.71e-80	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g20555	i0	94.118	79.5055350553505	204	12	75	0	12	215	79597	79800	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	21546	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13478175	13478175	PRJNA745553_S_NODE_3471_length_564_cov_6.733198_g3287_i0	PRJNA745553	3471	564	6.733198	37.97523672	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	854	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g3287	i0	93.993	1.15070921985816	566	31	99	1	2	564	232003	231438	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	649	854	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14752956	14752956	PRJNA745553_S_NODE_13572_length_334_cov_1.111111_g13377_i0	PRJNA745553	13572	334	1.111111	3.71111074	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	460	4.409999999999999e-125	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g13377	i0	92.355	66.1167664670659	327	19	97	4	12	334	248068	248392	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	22083	460	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
14753225	14753225	PRJNA745553_S_NODE_29752_length_213_cov_12.478571_g29557_i0	PRJNA745553	29752	213	12.478571	26.57935623	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	263	7.95e-66	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g29557	i0	91.667	44.1079812206573	192	13	90	3	23	213	801421	801232	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	9395	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14753246	14753246	PRJNA745553_S_NODE_3392_length_568_cov_6.800000_g3208_i0	PRJNA745553	3392	568	6.8	38.624	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	809	0	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g3208	i0	93.273	103.431338028169	550	36	97	1	1	549	4746610	4747159	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	58749	809	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
24150242	24150242	PRJNA745553_S_NODE_14859_length_319_cov_6.268293_g14664_i0	PRJNA745553	14859	319	6.268293	19.99585467	Bacteria	2	Bacteria	Bacteria	368	2.61e-97	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g14664	i0	88.141	142.64263322884	312	33	97	2	5	312	595497	595808	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	45503	368	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
26989231	26989231	PRJNA745553_S_NODE_28742_length_227_cov_5.305195_g28547_i0	PRJNA745553	28742	227	5.305195	12.04279265	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	42.7	0.031	NR	MCX7973647.1	2052149	g28547	i0	39.3	0.740088105726872	56	32	74	1	191	24	130	183	MCX7973647.1 PDZ domain-containing protein [Candidatus Aminicenantes bacterium]	diamond	168	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
26989239	26989239	PRJNA745553_S_NODE_8402_length_414_cov_5.287390_g8207_i0	PRJNA745553	8402	414	5.28739	21.8897946	Candidatus Levybacteria bacterium RIFCSPLOWO2_	2052151	Bacteria	Bacteria	56.2	1.43e-6	NR	OGH42948.1	1798626	g8207	i0	51.5	0.478260869565217	66	30	46.4	1	385	194	119	184	OGH42948.1 MAG: ribosome recycling factor [Candidatus Levybacteria bacterium RIFCSPLOWO2_01_FULL_42_15]	diamond	198	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levybacteria bacterium RIFCSPLOWO2_01_FULL_42_15
28610247	28610247	PRJNA745553_S_NODE_27427_length_236_cov_8.926380_g27232_i0	PRJNA745553	27427	236	8.92638	21.0662568	Bacteria	2	Bacteria	Bacteria	55.8	2.64e-8	NR	TWP16668.1	713054	g27232	i0	70.7	2.00847457627119	41	12	52.1	0	145	23	3	43	TWP16668.1 hypothetical protein EUA72_00305 [TM7 phylum sp. oral taxon 352]	diamond	474	56.2	0.99288256227758	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 352
30115850	30115850	PRJNA745553_S_NODE_7892_length_425_cov_3.823864_g7697_i0	PRJNA745553	7892	425	3.823864	16.251422	Parcubacteria group bacterium GW2	2026774	Bacteria	Bacteria	248	1.15e-82	NR	KKT80551.1	1618971	g7697	i0	92.4	0.924705882352941	131	10	92.5	0	23	415	1	131	KKT80551.1 MAG: hypothetical protein UW75_C0003G0011 [Parcubacteria group bacterium GW2011_GWF2_44_8]	diamond	393	248	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWF2_44_8
30147258	30147258	PRJNA745553_S_NODE_17432_length_295_cov_7.927928_g17237_i0	PRJNA745553	17432	295	7.927928	23.3873876	Candidatus Glassbacteria bacterium	2602803	Bacteria	Bacteria	87.8	6.1e-18	NR	MBN2288956.1	2602803	g17237	i0	48.7	2.33898305084746	76	39	77.3	0	24	251	280	355	MBN2288956.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Glassbacteria bacterium]	diamond	690	87.8	1	Bacteria	Bacteria candidate phyla	Candidatus Glassiibacteriota					Candidatus Glassbacteria bacterium
30337561	30337561	PRJNA745553_S_NODE_17812_length_292_cov_5.689498_g17617_i0	PRJNA745553	17812	292	5.689498	16.61333416	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	71.2	3.54e-13	NR	HEY3064851.1	2072417	g17617	i0	56.9	1.3458904109589	65	27	66.8	1	10	204	82	145	HEY3064851.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	393	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30505128	30505128	PRJNA745553_S_NODE_23713_length_254_cov_1.530387_g23518_i0	PRJNA745553	23713	254	1.530387	3.88718298	root	1	Root_unresolved	Root_unresolved	118	1.57e-30	NR	OGF50355.1	1817859	g23518	i0	69.1	5.74015748031496	81	22	95.7	1	243	1	70	147	OGF50355.1 MAG: methyltransferase type 12 [Candidatus Firestonebacteria bacterium RIFOXYA2_FULL_40_8]	diamond	1458	119	0.991596638655462	Bacteria	Bacteria candidate phyla	Candidatus Firestoneibacteriota					Candidatus Firestonebacteria bacterium RIFOXYA2_FULL_40_8
32085793	32085793	PRJNA745553_S_NODE_26918_length_240_cov_3.748503_g26723_i0	PRJNA745553	26918	240	3.748503	8.9964072	Bacillati	1783272	Bacteria	Bacteria	61.2	4.87e-9	NR	NJM09282.1	2044595	g26723	i0	49.2	3.1375	63	31	77.5	1	24	209	46	108	NJM09282.1 ferritin-like domain-containing protein [Candidatus Altimarinota bacterium]	diamond	753	61.6	0.993506493506494	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
32497360	32497360	PRJNA745553_S_NODE_5159_length_499_cov_3.124413_g4965_i0	PRJNA745553	5159	499	3.124413	15.59082087	Bacteria	2	Bacteria	Bacteria	46.6	0.0011	NR	TWP16668.1	713054	g4965	i0	59.5	0.961923847695391	42	17	25.3	0	374	499	2	43	TWP16668.1 hypothetical protein EUA72_00305 [TM7 phylum sp. oral taxon 352]	diamond	480	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 352

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