metadata: contig_metadata: 10 rows where bioproject = "PRJNA382357", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA382357", 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_class	tax_species
27770240	27770240	PRJNA382357_P_NODE_154044_length_202_cov_19.028369_g153305_i0	PRJNA382357	154044	202	19.028369	38.43730538	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	48.9	5.32e-5	NR	HWB34284.1	2053589	g153305	i0	77.4	0.46039603960395997	31	7	46	0	99	191	121	151	HWB34284.1 ribosome recycling factor [Candidatus Paceibacterota bacterium]	diamond	93	48.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
28622681	28622681	PRJNA382357_P_NODE_162767_length_190_cov_11.782946_g162028_i0	PRJNA382357	162767	190	11.782946	22.3875974	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	67.8	2.61e-11	NR	MDD5165530.1	2053589	g162028	i0	85.3	0.536842105263158	34	5	53.7	0	190	89	55	88	MDD5165530.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	102	67.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
29285497	29285497	PRJNA382357_P_NODE_76489_length_272_cov_3.431280_g75750_i0	PRJNA382357	76489	272	3.43128	9.3330816	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57	5.23e-7	NR	HEY4522728.1	2053589	g75750	i0	66.7	1.42279411764706	48	16	52.9	0	78	221	1364	1411	HEY4522728.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	387	57	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
29759000	29759000	PRJNA382357_P_NODE_101631_length_240_cov_3.547486_g100892_i0	PRJNA382357	101631	240	3.547486	8.5139664	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	46.2	5.03e-4	NR	MFA6325216.1	2053589	g100892	i0	58.5	0.5125	41	17	51.3	0	90	212	2	42	MFA6325216.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	123	46.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
30391478	30391478	PRJNA382357_P_NODE_131013_length_213_cov_7.203947_g130274_i0	PRJNA382357	131013	213	7.203947	15.34440711	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	72	1.24e-12	NR	HEY6020546.1	2053589	g130274	i0	68.1	0.661971830985915	47	15	66.2	0	13	153	178	224	HEY6020546.1 tail fiber protein [Candidatus Paceibacterota bacterium]	diamond	141	72	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
30391520	30391520	PRJNA382357_P_NODE_25893_length_440_cov_2.058047_g25155_i0	PRJNA382357	25893	440	2.058047	9.0554068	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79.7	3.19e-16	NR	MEX0597121.1	2053589	g25155	i0	49.3	0.484090909090909	71	35	48.4	1	4	216	33	102	MEX0597121.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	213	79.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
31338915	31338915	PRJNA382357_P_NODE_12556_length_599_cov_1.356877_g11838_i0	PRJNA382357	12556	599	1.3568770000000001	8.12769323	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	55.1	1.22e-6	NR	HEY6020314.1	2053589	g11838	i0	50	0.230383973288815	46	22	22.5	1	568	434	12	57	HEY6020314.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	138	55.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
31686899	31686899	PRJNA382357_P_NODE_62397_length_297_cov_11.029661_g61658_i0	PRJNA382357	62397	297	11.029661	32.75809317	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	57.4	4.9e-7	NR	MFQ5540773.1	3120121	g61658	i0	100	0.666666666666667	33	0	33.3	0	195	97	391	423	MFQ5540773.1 preprotein translocase subunit SecY [Minisyncoccia bacterium]	diamond	198	57.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Minisyncoccia bacterium
31845033	31845033	PRJNA382357_P_NODE_58557_length_306_cov_1.620408_g57818_i0	PRJNA382357	58557	306	1.620408	4.95844848	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	48.1	9.18e-4	NR	HEY6018607.1	2053589	g57818	i0	68.8	0.313725490196078	32	10	31.4	0	69	164	1	32	HEY6018607.1 peptidoglycan-binding domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	96	48.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
32446516	32446516	PRJNA382357_P_NODE_20239_length_490_cov_2.142191_g19506_i0	PRJNA382357	20239	490	2.142191	10.4967359	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	196	4.2e-57	NR	MFA6416431.1	2053589	g19506	i0	67.4	3.8265306122449	141	37	80.8	1	2	397	192	332	MFA6416431.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	1875	196	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);;