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

10 rows where bioproject = "PRJNA550047", 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
19641845	19641845	PRJNA550047_P_NODE_36856_length_388_cov_8.168254_g34911_i0	PRJNA550047	36856	388	8.168254	31.69282552	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	185	5.46e-57	NR	HQM18824.1	2053589	g34911	i0	65.1	0.997422680412371	129	45	99.7	0	387	1	15	143	HQM18824.1 sugar-phosphate nucleotidyltransferase [Candidatus Paceibacterota bacterium]	diamond	387	185	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
26603042	26603042	PRJNA550047_P_NODE_420121_length_257_cov_10.163043_g418149_i0	PRJNA550047	420121	257	10.163043	26.11902051	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.1	0.00408	NR	MFA5460414.1	2053589	g418149	i0	59.4	0.373540856031128	32	11	37.4	1	159	254	5	34	MFA5460414.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	96	43.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27930946	27930946	PRJNA550047_P_NODE_48785_length_345_cov_28.253676_g46825_i0	PRJNA550047	48785	345	28.253676	97.4751822	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	89.7	3.74e-18	NR	MDR3557948.1	2053589	g46825	i0	83.7	2.14782608695652	49	8	42.6	0	341	195	433	481	MDR3557948.1 IS66 family transposase [Candidatus Paceibacterota bacterium]	diamond	741	89.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29067762	29067762	PRJNA550047_P_NODE_500988_length_230_cov_7.305732_g499015_i0	PRJNA550047	500988	230	7.305732	16.8031836	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	74.7	1.52e-14	NR	MDP7365831.1	2053589	g499015	i0	42.1	0.991304347826087	76	42	99.1	1	228	1	79	152	MDP7365831.1 phage tail protein [Candidatus Paceibacterota bacterium]	diamond	228	74.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29635665	29635665	PRJNA550047_P_NODE_70770_length_345_cov_12.227941_g68810_i0	PRJNA550047	70770	345	12.227941	42.18639645	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	82.4	9.07e-16	NR	HEY4484458.1	2053589	g68810	i0	38.7	0.965217391304348	111	55	95.7	2	2	331	132	230	HEY4484458.1 glycosyltransferase family protein [Candidatus Paceibacterota bacterium]	diamond	333	82.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30124184	30124184	PRJNA550047_P_NODE_554732_length_212_cov_7.568345_g552759_i0	PRJNA550047	554732	212	7.568345	16.0448914	Bacteria	2	Bacteria	Bacteria	57.8	1.26e-7	NR	HEX4798925.1	2053589	g552759	i0	57.4	3.36792452830189	61	24	86.3	2	26	208	987	1045	HEX4798925.1 DUF2341 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	714	57.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30488814	30488814	PRJNA550047_P_NODE_341273_length_288_cov_13.339535_g339303_i0	PRJNA550047	341273	288	13.339535	38.4178608	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	91.3	2.13e-21	NR	HUO56437.1	2053589	g339303	i0	68.8	0.666666666666667	64	20	66.7	0	95	286	1	64	HUO56437.1 RNA-binding protein [Candidatus Paceibacterota bacterium]	diamond	192	91.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31500221	31500221	PRJNA550047_P_NODE_114536_length_345_cov_7.198529_g112576_i0	PRJNA550047	114536	345	7.198529	24.83492505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	125	1.19e-31	NR	MEX2514888.1	2053589	g112576	i0	59.1	1	115	46	99.1	1	343	2	299	413	MEX2514888.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	345	125	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32859074	32859074	PRJNA550047_P_NODE_242700_length_300_cov_14.083700_g240731_i0	PRJNA550047	242700	300	14.0837	42.2511	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	138	2.34e-35	NR	MCF7831534.1	2053589	g240731	i0	41.8	12.97	184	23	100	1	300	1	426	609	MCF7831534.1 N-6 DNA methylase [Candidatus Paceibacterota bacterium]	diamond	3891	138	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32859261	32859261	PRJNA550047_P_NODE_71940_length_345_cov_12.014706_g69980_i0	PRJNA550047	71940	345	12.014706	41.4507357	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	52.8	3.71e-5	NR	HPP65016.1	2053589	g69980	i0	31.5	0.939130434782609	108	70	93.9	2	343	20	924	1027	HPP65016.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	324	52.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);;