metadata: contig_metadata: 25 rows where bioproject = "PRJNA688655" and tax

25 rows where bioproject = "PRJNA688655" 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_order	tax_family	tax_genus	tax_species
12146539	12146539	PRJNA688655_P_NODE_2230_length_383_cov_1.490323_g2165_i0	PRJNA688655	2230	383	1.490323	5.70793709	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	257	2.64e-82	NR	MFA5433627.1	2053589	g2165	i0	98.4	0.994778067885117	127	2	99.5	0	3	383	230	356	MFA5433627.1 ISNCY family transposase [Candidatus Paceibacterota bacterium]	diamond	381	257	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
17245161	17245161	PRJNA688655_P_NODE_6934_length_262_cov_0.957672_g6869_i0	PRJNA688655	6934	262	0.957672	2.50910064	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	87.8	4.78e-18	NR	MFA5433627.1	2053589	g6869	i0	88.4	0.49236641221374	43	5	49.2	0	260	132	387	429	MFA5433627.1 ISNCY family transposase [Candidatus Paceibacterota bacterium]	diamond	129	87.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
26797427	26797427	PRJNA688655_P_NODE_3721_length_324_cov_0.920319_g3656_i0	PRJNA688655	3721	324	0.920319	2.98183356	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	107	7.02e-25	NR	MBD3279686.1	2053589	g3656	i0	52.7	1.03703703703704	112	48	99.1	1	2	322	158	269	MBD3279686.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	336	107	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
26829228	26829228	PRJNA688655_P_NODE_7761_length_251_cov_0.865169_g7696_i0	PRJNA688655	7761	251	0.865169	2.17157419	Candidatus Yanofskyibacterium parasiticum	3238480	Bacteria	Bacteria	55.8	9.59e-7	NR	GMX57715.1	3238480	g7696	i0	75.6	0.537848605577689	45	11	53.8	0	117	251	126	170	GMX57715.1 MAG: hypothetical protein YFSK_0430 [Candidatus Yanofskyibacterium parasiticum]	diamond	135	55.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Minisyncoccales	Candidatus Yanofskyibacteriaceae	Candidatus Yanofskyibacterium	Candidatus Yanofskyibacterium parasiticum
26861085	26861085	PRJNA688655_P_NODE_13761_length_244_cov_0.900585_g13696_i0	PRJNA688655	13761	244	0.900585	2.1974274	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	80.9	1.13e-15	NR	MCC6711634.1	2053589	g13696	i0	58.2	0.823770491803279	67	28	82.4	0	44	244	3	69	MCC6711634.1 glycosyltransferase family 4 protein [Candidatus Paceibacterota bacterium]	diamond	201	80.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28029901	28029901	PRJNA688655_P_NODE_6945_length_261_cov_2.047872_g6880_i0	PRJNA688655	6945	261	2.047872	5.34494592	Candidatus Pacebacteria bacterium CG_4_1	1974761	Bacteria	Bacteria	53.9	4.88e-6	NR	PIX81499.1	1974761	g6880	i0	47.7	0.747126436781609	65	34	74.7	0	66	260	14	78	PIX81499.1 MAG: IS30 family transposase [Candidatus Pacebacteria bacterium CG_4_10_14_3_um_filter_34_15]	diamond	195	53.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG_4_10_14_3_um_filter_34_15
28503426	28503426	PRJNA688655_P_NODE_12827_length_245_cov_0.895349_g12762_i0	PRJNA688655	12827	245	0.895349	2.19360505	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	155	2.6299999999999997e-45	NR	HNU95371.1	2053589	g12762	i0	100	1.98367346938776	81	0	99.2	0	2	244	150	230	HNU95371.1 MFS transporter [Candidatus Paceibacterota bacterium]	diamond	486	155	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29356005	29356005	PRJNA688655_P_NODE_14769_length_243_cov_0.905882_g14704_i0	PRJNA688655	14769	243	0.905882	2.20129326	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	162	1.6699999999999998e-45	NR	MFA5432569.1	2053589	g14704	i0	98.8	0.987654320987654	80	1	98.8	0	3	242	211	290	MFA5432569.1 AAA family ATPase [Candidatus Paceibacterota bacterium]	diamond	240	162	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29356012	29356012	PRJNA688655_P_NODE_3249_length_338_cov_1.162264_g3184_i0	PRJNA688655	3249	338	1.162264	3.92845232	Candidatus Pacebacteria bacterium CG1	1974769	Bacteria	Bacteria	101	1.57e-24	NR	PIR61740.1	1974769	g3184	i0	63.9	0.736686390532544	83	30	73.7	0	336	88	86	168	PIR61740.1 MAG: hypothetical protein COU66_02135 [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_11]	diamond	249	101	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_11
29450376	29450376	PRJNA688655_P_NODE_10830_length_247_cov_1.770115_g10765_i0	PRJNA688655	10830	247	1.770115	4.37218405	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	174	1.14e-49	NR	MFA5432568.1	2053589	g10765	i0	100	0.995951417004049	82	0	99.6	0	246	1	122	203	MFA5432568.1 site-specific DNA-methyltransferase [Candidatus Paceibacterota bacterium]	diamond	246	174	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29450379	29450379	PRJNA688655_P_NODE_11830_length_246_cov_0.890173_g11765_i0	PRJNA688655	11830	246	0.890173	2.18982558	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	132	6.67e-35	NR	MFA6325502.1	2053589	g11765	i0	84	0.98780487804878	81	13	98.8	0	245	3	6	86	MFA6325502.1 glycosyltransferase family 2 protein [Candidatus Paceibacterota bacterium]	diamond	243	132	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29481907	29481907	PRJNA688655_P_NODE_1390_length_464_cov_1.181586_g1325_i0	PRJNA688655	1390	464	1.181586	5.48255904	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	99.4	3.850000000000001e-21	NR	NCN03610.1	2053589	g1325	i0	64.9	0.497844827586207	77	27	49.8	0	2	232	360	436	NCN03610.1 serine hydroxymethyltransferase [Candidatus Paceibacterota bacterium]	diamond	231	99.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29481916	29481916	PRJNA688655_P_NODE_2610_length_362_cov_1.065744_g2545_i0	PRJNA688655	2610	362	1.065744	3.85799328	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	140	4.74e-39	NR	HCC84115.1	2053589	g2545	i0	57	0.94475138121547	114	49	94.5	0	342	1	39	152	HCC84115.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	342	140	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29525466	29525466	PRJNA688655_P_NODE_2290_length_379_cov_1.006536_g2225_i0	PRJNA688655	2290	379	1.006536	3.81477144	Bacteria	2	Bacteria	Bacteria	84.3	1.03e-16	NR	PIR59499.1	1974771	g2225	i0	56.4	2.05804749340369	94	41	74.4	0	2	283	184	277	PIR59499.1 MAG: molecular chaperone DnaK, partial [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_6]	diamond	780	84.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_6
30430184	30430184	PRJNA688655_P_NODE_6133_length_274_cov_1.532338_g6068_i0	PRJNA688655	6133	274	1.532338	4.19860612	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	100	1.07e-22	NR	NLG06310.1	2053589	g6068	i0	53.7	1.7956204379562	82	38	89.8	0	15	260	225	306	NLG06310.1 FtsW/RodA/SpoVE family cell cycle protein [Candidatus Paceibacterota bacterium]	diamond	492	100	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30493067	30493067	PRJNA688655_P_NODE_4993_length_295_cov_1.387387_g4928_i0	PRJNA688655	4993	295	1.387387	4.09279165	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	197	7.82e-60	NR	MFA5433353.1	2053589	g4928	i0	100	0.996610169491525	98	0	99.7	0	2	295	2	99	MFA5433353.1 PDDEXK nuclease domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	294	197	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30820550	30820550	PRJNA688655_P_NODE_3754_length_323_cov_1.160000_g3689_i0	PRJNA688655	3754	323	1.16	3.7468	Bacteria	2	Bacteria	Bacteria	100	4.66e-22	NR	OIP73902.1	1805300	g3689	i0	75.8	2.44272445820433	66	16	61.3	0	323	126	510	575	OIP73902.1 MAG: hypothetical protein AUK08_05090 [Candidatus Pacebacteria bacterium CG2_30_36_39]	diamond	789	100	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG2_30_36_39
30935427	30935427	PRJNA688655_P_NODE_11234_length_247_cov_0.885057_g11169_i0	PRJNA688655	11234	247	0.885057	2.18609079	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	84	2.78e-19	NR	MFA5432491.1	2053589	g11169	i0	86.7	0.546558704453441	45	6	54.7	0	11	145	24	68	MFA5432491.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	135	84	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31282858	31282858	PRJNA688655_P_NODE_10735_length_248_cov_0.880000_g10670_i0	PRJNA688655	10735	248	0.88	2.1824	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	69.3	1.7e-11	NR	HEV7702294.1	2053589	g10670	i0	42	0.979838709677419	81	46	98	1	2	244	240	319	HEV7702294.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	243	69.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32200391	32200391	PRJNA688655_P_NODE_15278_length_242_cov_0.911243_g15213_i0	PRJNA688655	15278	242	0.911243	2.20520806	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	56.2	5.15e-7	NR	HZS43078.1	2053589	g15213	i0	45	2.29338842975207	60	31	71.9	1	222	49	117	176	HZS43078.1 FkbM family methyltransferase [Candidatus Paceibacterota bacterium]	diamond	555	56.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32232249	32232249	PRJNA688655_P_NODE_3338_length_335_cov_1.049618_g3273_i0	PRJNA688655	3338	335	1.049618	3.5162203	Candidatus Pacebacteria bacterium CG1	1974772	Bacteria	Bacteria	174	2.43e-51	NR	PIR59450.1	1974772	g3273	i0	73	1.98805970149254	111	30	99.4	0	3	335	142	252	PIR59450.1 MAG: UDP-glucose 4-epimerase GalE [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_56_10]	diamond	666	174	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_56_10
32327307	32327307	PRJNA688655_P_NODE_4979_length_295_cov_1.932432_g4914_i0	PRJNA688655	4979	295	1.932432	5.7006744	Candidatus Pacebacteria bacterium CG1	1974768	Bacteria	Bacteria	147	3.54e-40	NR	PIR62445.1	1974768	g4914	i0	89.7	0.986440677966102	97	10	98.6	0	3	293	10	106	PIR62445.1 MAG: DUF2130 domain-containing protein [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_12]	diamond	291	147	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_12
32485297	32485297	PRJNA688655_P_NODE_6819_length_263_cov_1.621053_g6754_i0	PRJNA688655	6819	263	1.621053	4.26336939	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	144	2.579999999999999e-38	NR	MBD3279108.1	2053589	g6754	i0	77.1	2.78326996197719	83	19	94.7	0	261	13	518	600	MBD3279108.1 CTP synthase [Candidatus Paceibacterota bacterium]	diamond	732	144	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32622894	32622894	PRJNA688655_P_NODE_3680_length_325_cov_0.916667_g3615_i0	PRJNA688655	3680	325	0.916667	2.97916775	Bacteria	2	Bacteria	Bacteria	124	1.07e-33	NR	OGJ38260.1	1801887	g3615	i0	61	2.92615384615385	105	40	96.9	1	325	11	3	106	OGJ38260.1 MAG: 50S ribosomal protein L17 [Candidatus Pacebacteria bacterium RIFCSPLOWO2_01_FULL_47_12]	diamond	951	125	0.992	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium RIFCSPLOWO2_01_FULL_47_12
32717465	32717465	PRJNA688655_P_NODE_9060_length_250_cov_0.870056_g8995_i0	PRJNA688655	9060	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	78.6	8.08e-15	NR	OGJ37636.1	1801887	g8995	i0	75.5	5.088	53	13	63.6	0	2	160	348	400	OGJ37636.1 MAG: hypothetical protein A3A82_01850 [Candidatus Pacebacteria bacterium RIFCSPLOWO2_01_FULL_47_12]	diamond	1272	79	0.994936708860759	Bacteria	Bacteria candidate phyla	Minisyncoccota					Candidatus Pacebacteria bacterium RIFCSPLOWO2_01_FULL_47_12

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);;