metadata: contig_metadata: 8 rows where bioproject = "PRJNA670521", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA670521", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"

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_species
10842290	10842290	PRJNA670521_P_NODE_59369_length_274_cov_1.532338_g58624_i0	PRJNA670521	59369	274	1.532338	4.19860612	Bacteria	2	Bacteria	Bacteria	134	2.64e-34	NR	HUZ07743.1	2053589	g58624	i0	70.8	23.6167883211679	89	26	97.4	0	267	1	215	303	HUZ07743.1 aminomethyl-transferring glycine dehydrogenase [Candidatus Paceibacterota bacterium]	diamond	6471	135	0.992592592592593	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27176325	27176325	PRJNA670521_P_NODE_56942_length_280_cov_1.115942_g56197_i0	PRJNA670521	56942	280	1.115942	3.1246376	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57.4	4.12e-7	NR	MEZ0208986.1	2053589	g56197	i0	29.9	0.932142857142857	87	60	92.1	1	260	3	1357	1443	MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	261	57.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27934582	27934582	PRJNA670521_P_NODE_44485_length_310_cov_1.299578_g43740_i0	PRJNA670521	44485	310	1.299578	4.0286918	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	58.9	1.36e-7	NR	MEZ0209065.1	2053589	g43740	i0	36.4	0.958064516129032	99	60	95.8	2	299	3	202	297	MEZ0209065.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	297	58.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31041874	31041874	PRJNA670521_P_NODE_86315_length_244_cov_0.900585_g85570_i0	PRJNA670521	86315	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	87.4	6.47e-18	NR	HUX35538.1	2053589	g85570	i0	58	2.92622950819672	81	34	99.6	0	244	2	72	152	HUX35538.1 ABC-F family ATP-binding cassette domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	714	87.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31187204	31187204	PRJNA670521_P_NODE_17795_length_443_cov_1.040541_g17053_i0	PRJNA670521	17795	443	1.040541	4.60959663	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	74.3	2.93e-12	NR	MEZ0208921.1	2053589	g17053	i0	41.2	1.00225733634312	148	85	99.5	2	1	441	330	476	MEZ0208921.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	444	74.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31345729	31345729	PRJNA670521_P_NODE_45696_length_307_cov_1.264957_g44951_i0	PRJNA670521	45696	307	1.264957	3.88341799	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.5	0.0416	NR	MFA5715097.1	2053589	g44951	i0	42	0.674267100977199	69	33	67.4	2	80	286	394	455	MFA5715097.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	207	43.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31819996	31819996	PRJNA670521_P_NODE_71417_length_251_cov_0.865169_g70672_i0	PRJNA670521	71417	251	0.865169	2.17157419	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	149	1.88e-39	NR	MEZ0208791.1	2053589	g70672	i0	81.9	0.99203187250996006	83	15	99.2	0	251	3	36	118	MEZ0208791.1 glucoamylase family protein [Candidatus Paceibacterota bacterium]	diamond	249	149	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32295094	32295094	PRJNA670521_P_NODE_62679_length_267_cov_1.190722_g61934_i0	PRJNA670521	62679	267	1.190722	3.17922774	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	82	7.35e-16	NR	MEZ0209064.1	2053589	g61934	i0	51.9	0.887640449438202	79	38	88.8	0	6	242	363	441	MEZ0209064.1 DNA N-6-adenine-methyltransferase [Candidatus Paceibacterota bacterium]	diamond	237	82	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota 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);;