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

11 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
1250673	1250673	PRJNA911178_P_NODE_59241_length_454_cov_1.052493_g56795_i0	PRJNA911178	59241	454	1.052493	4.77831822	Candidatus Methylomirabilis	1170227	Bacteria	Bacteria	351	3.87e-92	NTclustered	gi\|507148395\|ref\|NR_103198.1\|	671143	g56795	i0	82.423	317.671806167401	421	57	91	12	33	443	1510	1097	Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence	blastn	144223	351	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera
2168901	2168901	PRJNA911178_P_NODE_84422_length_388_cov_1.546032_g81955_i0	PRJNA911178	84422	388	1.546032	5.99860416	Candidatus Gottesmanbacteria bacterium	2282145	Bacteria	Bacteria	132	4.63e-26	NTclustered	gi\|2874253727\|emb\|OY969569.1\|	2282145	g81955	i0	78.027	2.5979381443299	223	40	56	8	53	268	737497	737277	MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1	blastn	1008	132	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota					Candidatus Gottesmanbacteria bacterium
9819673	9819673	PRJNA911178_P_NODE_160248_length_296_cov_1.358744_g157775_i0	PRJNA911178	160248	296	1.358744	4.02188224	candidate division TM6 bacterium GW2011_GWF2_28_16	1619077	Bacteria	Bacteria	180	1.2099999999999999e-40	NTclustered	gi\|837367205\|gb\|CP011212.1\|	1619077	g157775	i0	78.188	25.3412162162162	298	54	99	11	4	296	132896	133187	Candidate division TM6 bacterium GW2011_GWF2_28_16 chromosome, complete genome	blastn	7501	180	1	Bacteria	Bacteria candidate phyla						candidate division TM6 bacterium GW2011_GWF2_28_16
9819711	9819711	PRJNA911178_P_NODE_164688_length_292_cov_2.474886_g162215_i0	PRJNA911178	164688	292	2.474886	7.22666712	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	475	1.3599999999999999e-129	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g162215	i0	96.831	154.102739726027	284	9	97	0	1	284	963815	964098	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	44998	475	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
12372023	12372023	PRJNA911178_P_NODE_299090_length_235_cov_3.296296_g296616_i0	PRJNA911178	299090	235	3.296296	7.7462956	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	375	1.1e-99	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g296616	i0	95.708	90.6382978723404	233	10	99	0	3	235	964847	964615	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	21300	375	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
17470264	17470264	PRJNA911178_P_NODE_191854_length_276_cov_1.512315_g189381_i0	PRJNA911178	191854	276	1.512315	4.1739894	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	494	3.51e-135	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g189381	i0	99.267	3.98550724637681	273	2	99	0	1	273	891289	891017	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	1100	494	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
17828227	17828227	PRJNA911178_P_NODE_78134_length_401_cov_2.131098_g75669_i0	PRJNA911178	78134	401	2.131098	8.54570298	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	662	0	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g75669	i0	97.668	332.341645885287	386	8	96	1	17	401	143132	143517	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	133269	662	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
18744394	18744394	PRJNA911178_P_NODE_288675_length_242_cov_0.911243_g286201_i0	PRJNA911178	288675	242	0.911243	2.20520806	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	110	1.28e-19	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g286201	i0	84.034	3.02479338842975	119	14	48	5	72	188	628433	628318	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	732	110	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
21294110	21294110	PRJNA911178_P_NODE_206697_length_268_cov_1.497436_g204223_i0	PRJNA911178	206697	268	1.497436	4.01312848	candidate division TM6 bacterium GW2011_GWF2_28_16	1619077	Bacteria	Bacteria	235	2.27e-57	NTclustered	gi\|837367205\|gb\|CP011212.1\|	1619077	g204223	i0	83.525	273.541044776119	261	34	95	7	4	257	133171	133429	Candidate division TM6 bacterium GW2011_GWF2_28_16 chromosome, complete genome	blastn	73309	235	1	Bacteria	Bacteria candidate phyla						candidate division TM6 bacterium GW2011_GWF2_28_16
22569827	22569827	PRJNA911178_P_NODE_280138_length_243_cov_1.705882_g277664_i0	PRJNA911178	280138	243	1.705882	4.14529326	uncultured Candidatus Babeliaceae bacterium	2501594	Bacteria	Bacteria	283	7.14e-72	NTclustered	gi\|2874253872\|emb\|OY969927.1\|	2501594	g277664	i0	87.903	22.7695473251029	248	21	99	8	1	242	75456	75700	MAG: uncultured Candidatus Babeliaceae bacterium isolate MFD01476.bin.c.8 genome assembly, chromosome: 1	blastn	5533	283	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		uncultured Candidatus Babeliaceae bacterium
22570715	22570715	PRJNA911178_P_NODE_96118_length_367_cov_2.071429_g93648_i0	PRJNA911178	96118	367	2.071429	7.60214443	Candidatus Methylomirabilis oxygeniifera	671143	Bacteria	Bacteria	71.3	9.62e-8	NTclustered	gi\|258590833\|emb\|FP565575.1\|	671143	g93648	i0	92.157	21.6130790190736	51	2	16	2	30	79	1646719	1646768	Candidatus Methylomirabilis oxyfera complete genome	blastn	7932	71.3	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera

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