metadata: contig_metadata: 6 rows where bioproject = "PRJNA1182301" and tax

6 rows where bioproject = "PRJNA1182301" and tax_phylum = "Candidatus Methylomirabilota"

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
319235	319235	PRJNA1182301_P_NODE_60721_length_243_cov_0.905882_g60596_i0	PRJNA1182301	60721	243	0.905882	2.20129326	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	207	4.42e-49	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g60596	i0	83.482	0.921810699588477	224	35	92	2	15	237	407211	407433	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	224	207	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
11797778	11797778	PRJNA1182301_P_NODE_60190_length_243_cov_0.905882_g60065_i0	PRJNA1182301	60190	243	0.905882	2.20129326	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	164	2.96e-48	NR	HEX5814528.1	2072417	g60065	i0	86.3	1.97530864197531	80	11	98.8	0	3	242	124	203	HEX5814528.1 alpha/beta hydrolase [Candidatus Methylomirabilota bacterium]	diamond	480	164	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
23271133	23271133	PRJNA1182301_P_NODE_52699_length_248_cov_1.760000_g52574_i0	PRJNA1182301	52699	248	1.76	4.3648	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	215	2.7e-51	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g52574	i0	85.437	4.37903225806452	206	30	83	0	17	222	285053	284848	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	1086	215	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
23993546	23993546	PRJNA1182301_P_NODE_22659_length_285_cov_1.452830_g22534_i0	PRJNA1182301	22659	285	1.45283	4.1405655	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	110	8.01e-26	NR	HEX9821347.1	2072417	g22534	i0	61.5	1.01052631578947	96	35	98.9	1	2	283	397	492	HEX9821347.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	288	110	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
24544254	24544254	PRJNA1182301_P_NODE_23520_length_284_cov_1.454976_g23395_i0	PRJNA1182301	23520	284	1.454976	4.1321318399999996	Pseudomonadati	3379134	Bacteria	Bacteria	144	8.909999999999997e-42	NR	HEY5725375.1	2072417	g23395	i0	75.3	7.89084507042254	93	23	98.2	0	282	4	28	120	HEY5725375.1 aldo/keto reductase [Candidatus Methylomirabilota bacterium]	diamond	2241	145	0.993103448275862	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27420123	27420123	PRJNA1182301_P_NODE_27503_length_278_cov_2.478049_g27378_i0	PRJNA1182301	27503	278	2.478049	6.88897622	Candidatus Methylomirabilis limnetica	2033718	Bacteria	Bacteria	107	7.9499999999999995e-25	NR	WP_239993069.1	2033718	g27378	i0	68.5	0.992805755395683	92	23	99.3	2	2	277	1198	1283	WP_239993069.1 GH36-type glycosyl hydrolase domain-containing protein [Candidatus Methylomirabilis limnetica]	diamond	276	107	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis limnetica

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