metadata: contig_metadata: 9 rows where bioproject = "PRJNA743294", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA743294", 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
26767796	26767796	PRJNA743294_P_NODE_22861_length_342_cov_2.007435_g22405_i0	PRJNA743294	22861	342	2.007435	6.8654277	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	99.4	3.74e-22	NR	MEX0595889.1	2053589	g22405	i0	49.4	1.66666666666667	87	41	74.6	2	271	17	25	110	MEX0595889.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Paceibacterota bacterium]	diamond	570	99.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
26957504	26957504	PRJNA743294_P_NODE_20022_length_363_cov_1.724138_g19566_i0	PRJNA743294	20022	363	1.724138	6.25862094	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	99.4	1.3700000000000002e-21	NR	HWA64487.1	2053589	g19566	i0	45.1	1.97520661157025	122	50	96.7	4	363	13	294	403	HWA64487.1 phospholipid carrier-dependent glycosyltransferase [Candidatus Paceibacterota bacterium]	diamond	717	99.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28284140	28284140	PRJNA743294_P_NODE_3846_length_771_cov_3.174785_g3451_i0	PRJNA743294	3846	771	3.174785	24.47759235	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	119	9.03e-31	NR	HRH31009.1	2053589	g3451	i0	91.2	0.221789883268482	57	5	22.2	0	679	509	1	57	HRH31009.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	171	119	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29389581	29389581	PRJNA743294_P_NODE_25509_length_326_cov_2.624506_g25053_i0	PRJNA743294	25509	326	2.624506	8.55588956	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	105	1.49e-24	NR	MEX0595889.1	2053589	g25053	i0	50.9	1.85889570552147	108	49	95.7	1	5	316	168	275	MEX0595889.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Paceibacterota bacterium]	diamond	606	105	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29610077	29610077	PRJNA743294_P_NODE_14970_length_414_cov_5.431085_g14514_i0	PRJNA743294	14970	414	5.431085	22.4846919	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	51.2	2.81e-5	NR	MDR3547919.1	2053589	g14514	i0	32.9	0.572463768115942	79	53	57.2	0	256	20	17	95	MDR3547919.1 EF-hand domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	237	51.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30052465	30052465	PRJNA743294_P_NODE_3991_length_756_cov_7.265007_g3593_i0	PRJNA743294	3991	756	7.265007	54.92345292	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	75.1	3.9e-12	NR	HUS51518.1	2053589	g3593	i0	29.1	0.682539682539683	172	116	67.5	3	63	572	64	231	HUS51518.1 glycoside hydrolase family protein [Candidatus Paceibacterota bacterium]	diamond	516	75.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30210352	30210352	PRJNA743294_P_NODE_29012_length_308_cov_2.863830_g28556_i0	PRJNA743294	29012	308	2.86383	8.8205964	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	114	3.02e-28	NR	HET8581307.1	2053589	g28556	i0	52.9	0.993506493506494	102	48	99.4	0	1	306	12	113	HET8581307.1 phosphagen kinase [Candidatus Paceibacterota bacterium]	diamond	306	114	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30842598	30842598	PRJNA743294_P_NODE_40954_length_266_cov_1.616580_g40498_i0	PRJNA743294	40954	266	1.61658	4.3001028	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	138	2.4699999999999993e-40	NR	MBP9712054.1	2053589	g40498	i0	80.8	0.879699248120301	78	15	88	0	29	262	1	78	MBP9712054.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	234	138	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32833791	32833791	PRJNA743294_P_NODE_44100_length_258_cov_1.378378_g43644_i0	PRJNA743294	44100	258	1.378378	3.5562152400000002	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	99.8	1.18e-22	NR	MDR3548598.1	2053589	g43644	i0	54.9	1.90697674418605	82	37	95.3	0	252	7	6	87	MDR3548598.1 galactokinase family protein [Candidatus Paceibacterota bacterium]	diamond	492	99.8	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);;