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

8 rows where bioproject = "PRJNA1011844", 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
27982430	27982430	PRJNA1011844_P_NODE_51025_length_615_cov_3.931734_g42756_i0	PRJNA1011844	51025	615	3.931734	24.1801641	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	196	3.5500000000000004e-58	NR	MEX0595889.1	2053589	g42756	i0	49.8	0.990243902439024	203	94	96.6	3	16	609	88	287	MEX0595889.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Paceibacterota bacterium]	diamond	609	196	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28487751	28487751	PRJNA1011844_P_NODE_90067_length_359_cov_2.381119_g81510_i0	PRJNA1011844	90067	359	2.381119	8.54821721	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	53.9	7.56e-6	NR	HYF10293.1	2053589	g81510	i0	50	0.350974930362117	42	21	35.1	0	4	129	153	194	HYF10293.1 nucleoside monophosphate kinase [Candidatus Paceibacterota bacterium]	diamond	126	53.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30287878	30287878	PRJNA1011844_P_NODE_110732_length_301_cov_1.736842_g102157_i0	PRJNA1011844	110732	301	1.736842	5.22789442	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	52	4.14e-5	NR	MFA6050302.1	2053589	g102157	i0	34.8	1.67441860465116	89	57	87.7	1	268	5	36	124	MFA6050302.1 peptidoglycan-binding protein [Candidatus Paceibacterota bacterium]	diamond	504	52	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30477231	30477231	PRJNA1011844_P_NODE_151913_length_247_cov_0.885057_g143334_i0	PRJNA1011844	151913	247	0.885057	2.18609079	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57	3.81e-7	NR	MCK5022158.1	2053589	g143334	i0	70.3	0.947368421052632	37	11	44.9	0	13	123	62	98	MCK5022158.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	234	57	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31520183	31520183	PRJNA1011844_P_NODE_102836_length_319_cov_2.792683_g94266_i0	PRJNA1011844	102836	319	2.792683	8.90865877	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	90.1	8.13e-19	NR	MEX0595889.1	2053589	g94266	i0	52.4	0.77115987460815	82	38	76.2	1	76	318	119	200	MEX0595889.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Paceibacterota bacterium]	diamond	246	90.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32152794	32152794	PRJNA1011844_P_NODE_134418_length_264_cov_1.523560_g125840_i0	PRJNA1011844	134418	264	1.52356	4.0221984	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.1	0.0364	NR	HRY62222.1	2053589	g125840	i0	35.7	0.636363636363636	56	35	63.6	1	222	55	151	205	HRY62222.1 tetratricopeptide repeat protein [Candidatus Paceibacterota bacterium]	diamond	168	43.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32374411	32374411	PRJNA1011844_P_NODE_155119_length_245_cov_0.895349_g146539_i0	PRJNA1011844	155119	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	96.7	3.32e-21	NR	HVX90663.1	2053589	g146539	i0	65.2	0.844897959183673	69	24	84.5	0	213	7	225	293	HVX90663.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	207	96.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32745515	32745515	PRJNA1011844_P_NODE_86640_length_371_cov_9.956376_g78090_i0	PRJNA1011844	86640	371	9.956376	36.93815496	Bacteria	2	Bacteria	Bacteria	90.1	4.02e-18	NR	MBP6858268.1	2053589	g78090	i0	54.7	1.73854447439353	75	34	60.6	0	18	242	396	470	MBP6858268.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	645	90.1	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);;