metadata: contig_metadata: 11 rows where bioproject = "PRJNA929522", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA929522", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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
9833201	9833201	PRJNA929522_S_NODE_1648_length_515_cov_1.386878_g1578_i0	PRJNA929522	1648	515	1.386878	7.1424217	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	289	2.0099999999999998e-94	NR	MCL4419852.1	2052139	g1578	i0	80.1	0.996116504854369	171	34	99.6	0	2	514	56	226	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	513	289	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
16208289	16208289	PRJNA929522_S_NODE_4453_length_325_cov_1.611111_g4383_i0	PRJNA929522	4453	325	1.611111	5.23611075	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	184	4.08e-53	NR	MBN1867418.1	2107588	g4383	i0	76.4	18.5723076923077	106	25	97.8	0	7	324	224	329	MBN1867418.1 hydroxylamine reductase [Candidatus Sumerlaeota bacterium]	diamond	6036	184	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
28667266	28667266	PRJNA929522_S_NODE_247_length_1137_cov_2.555451_g215_i0	PRJNA929522	247	1137	2.555451	29.05547787	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	227	2.2799999999999998e-62	NR	HEY7164970.1	2838779	g215	i0	38.3	4.0131926121372	376	211	95.5	12	1135	50	132	500	HEY7164970.1 S8 family serine peptidase [Candidatus Binatia bacterium]	diamond	4563	227	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29109299	29109299	PRJNA929522_S_NODE_6508_length_280_cov_1.115942_g6438_i0	PRJNA929522	6508	280	1.115942	3.1246376	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	52.4	2.32e-5	NR	HOW45102.1	2052149	g6438	i0	32.2	0.932142857142857	87	45	78.2	3	62	280	246	332	HOW45102.1 Do family serine endopeptidase [Candidatus Aminicenantes bacterium]	diamond	261	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
29677113	29677113	PRJNA929522_S_NODE_5950_length_290_cov_1.064516_g5880_i0	PRJNA929522	5950	290	1.064516	3.0870964	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	113	2.93e-27	NR	MCT4592580.1	2044595	g5880	i0	64.9	5.5448275862069	77	24	79.7	1	236	6	284	357	MCT4592580.1 DNA photolyase family protein [Candidatus Altimarinota bacterium]	diamond	1608	113	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
29810750	29810750	PRJNA929522_S_NODE_7011_length_271_cov_1.555556_g6941_i0	PRJNA929522	7011	271	1.555556	4.21555676	Bacteria	2	Bacteria	Bacteria	89	2.4e-18	NR	WP_171814744.1	673862	g6941	i0	52	4.77121771217712	75	36	83	0	4	228	191	265	WP_171814744.1 glycoside hydrolase family 1 protein [Candidatus Babela massiliensis]	diamond	1293	89.4	0.995525727069351	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
29835291	29835291	PRJNA929522_S_NODE_4651_length_319_cov_1.089431_g4581_i0	PRJNA929522	4651	319	1.089431	3.47528489	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	53.5	1.57e-5	NR	MCL2173995.1	2026720	g4581	i0	36.5	1.81504702194357	96	46	81.8	2	304	44	2206	2295	MCL2173995.1 IPT/TIG domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	579	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29866984	29866984	PRJNA929522_S_NODE_3711_length_350_cov_1.505415_g3641_i0	PRJNA929522	3711	350	1.505415	5.2689525	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_	2282149	Bacteria	Bacteria	60.1	2.48e-8	NR	OGK16646.1	1802031	g3641	i0	62.8	1.84285714285714	43	16	36.9	0	350	222	96	138	OGK16646.1 MAG: peptide-methionine (S)-S-oxide reductase [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_12c]	diamond	645	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_12c
32238115	32238115	PRJNA929522_S_NODE_838_length_687_cov_3.247557_g777_i0	PRJNA929522	838	687	3.247557	22.31071659	Candidatus Acetothermia bacterium	2053493	Bacteria	Bacteria	116	2.88e-26	NR	MCI2430758.1	2053493	g777	i0	35.4	4.13100436681223	178	105	77.7	2	581	48	50	217	MCI2430758.1 S8 family serine peptidase [Candidatus Acetothermia bacterium]	diamond	2838	116	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Acetothermia bacterium
32403205	32403205	PRJNA929522_S_NODE_5579_length_297_cov_1.959821_g5509_i0	PRJNA929522	5579	297	1.959821	5.82066837	Bacteria	2	Bacteria	Bacteria	61.2	2.23e-8	NR	NLM18391.1	2053586	g5509	i0	50	2.67676767676768	64	31	63.6	1	189	1	25	88	NLM18391.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Candidatus Rifleibacteriota bacterium]	diamond	795	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota					Candidatus Rifleibacteriota bacterium
32687199	32687199	PRJNA929522_S_NODE_9500_length_245_cov_0.895349_g9430_i0	PRJNA929522	9500	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	129	1.09e-32	NR	HXS83616.1	2072417	g9430	i0	67.1	12.6367346938776	79	26	96.7	0	241	5	37	115	HXS83616.1 Nramp family divalent metal transporter [Candidatus Methylomirabilota bacterium]	diamond	3096	129	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota 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);;