metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax

11 rows where analysis = "blastn", 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

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