metadata: contig_metadata: 11 rows where bioproject = "PRJNA734348" and tax_phylum = "Candidatus Magasanikiibacteriota"

11 rows where bioproject = "PRJNA734348" and tax_phylum = "Candidatus Magasanikiibacteriota"

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
21121471	21121471	PRJNA734348_P_NODE_78757_length_261_cov_3.686170_g78059_i0	PRJNA734348	78757	261	3.68617	9.6209037	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	138	3.07e-36	NR	MBH41160.1	2026717	g78059	i0	81	2.90804597701149	84	16	96.6	0	256	5	125	208	MBH41160.1 phosphoglycerate mutase (2,3-diphosphoglycerate-independent) [Candidatus Magasanikiibacteriota bacterium]	diamond	759	138	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
22395072	22395072	PRJNA734348_P_NODE_148098_length_206_cov_4.947368_g147400_i0	PRJNA734348	148098	206	4.947368	10.19157808	Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_	2026717	Bacteria	Bacteria	130	1.17e-33	NR	OGH68502.1	1798680	g147400	i0	88.2	1.98058252427184	68	8	99	0	204	1	140	207	OGH68502.1 MAG: threonine--tRNA ligase [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_02_FULL_47_14]	diamond	408	130	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_02_FULL_47_14
28357357	28357357	PRJNA734348_P_NODE_21186_length_434_cov_0.853186_g20495_i0	PRJNA734348	21186	434	0.853186	3.70282724	Bacteria	2	Bacteria	Bacteria	242	3.28e-71	NR	OGH58634.1	1798671	g20495	i0	79.9	6.96774193548387	144	29	99.5	0	433	2	15	158	OGH58634.1 MAG: DNA-directed RNA polymerase subunit beta [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_33_34]	diamond	3024	244	0.991803278688525	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_33_34
28578606	28578606	PRJNA734348_P_NODE_122207_length_243_cov_2.658824_g121509_i0	PRJNA734348	122207	243	2.658824	6.46094232	Bacteria	2	Bacteria	Bacteria	158	9.64e-43	NR	OGH74922.1	1798684	g121509	i0	86.3	1.96296296296296	80	11	98.8	0	3	242	133	212	OGH74922.1 MAG: leucine--tRNA ligase [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_12_FULL_41_16]	diamond	477	158	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_12_FULL_41_16
29420659	29420659	PRJNA734348_P_NODE_47889_length_293_cov_1.050000_g47192_i0	PRJNA734348	47889	293	1.05	3.0765	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	78.2	5.52e-16	NR	MBT3419087.1	2026717	g47192	i0	63.3	0.614334470989761	60	22	61.4	0	113	292	1	60	MBT3419087.1 Rrf2 family transcriptional regulator [Candidatus Magasanikiibacteriota bacterium]	diamond	180	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
29704594	29704594	PRJNA734348_P_NODE_66670_length_273_cov_1.405000_g65973_i0	PRJNA734348	66670	273	1.405	3.83565	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	118	1.56e-28	NR	HBU06624.1	2026717	g65973	i0	61.1	2.91208791208791	90	35	98.9	0	1	270	221	310	HBU06624.1 protein translocase subunit SecD [Candidatus Magasanikiibacteriota bacterium]	diamond	795	118	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
29862863	29862863	PRJNA734348_P_NODE_54631_length_285_cov_1.452830_g53934_i0	PRJNA734348	54631	285	1.45283	4.1405655	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	98.2	2.07e-21	NR	MFH1947132.1	2026717	g53934	i0	68.8	0.673684210526316	64	20	67.4	0	1	192	816	879	MFH1947132.1 ATP-dependent chaperone ClpB [Candidatus Magasanikiibacteriota bacterium]	diamond	192	98.2	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
31042446	31042446	PRJNA734348_P_NODE_131735_length_241_cov_0.916667_g131037_i0	PRJNA734348	131735	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	144	7.04e-38	NR	KKQ27810.1	1619046	g131037	i0	80	9.95850622406639	80	16	99.6	0	2	241	729	808	KKQ27810.1 MAG: UvrABC system protein A [Candidatus Magasanikbacteria bacterium GW2011_GWC2_37_14]	diamond	2400	145	0.993103448275862	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikbacteria bacterium GW2011_GWC2_37_14
32170700	32170700	PRJNA734348_P_NODE_139598_length_233_cov_2.262500_g138900_i0	PRJNA734348	139598	233	2.2625	5.271625	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	95.5	3.5e-21	NR	MBI2990120.1	2026717	g138900	i0	65.8	0.978540772532189	76	26	97.9	0	231	4	49	124	MBI2990120.1 alanine racemase [Candidatus Magasanikiibacteriota bacterium]	diamond	228	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
32202191	32202191	PRJNA734348_P_NODE_48618_length_292_cov_1.210046_g47921_i0	PRJNA734348	48618	292	1.210046	3.53333432	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	52	7.07e-6	NR	MBT4120507.1	2026717	g47921	i0	74.2	0.318493150684932	31	8	31.8	0	98	6	3	33	MBT4120507.1 YraN family protein [Candidatus Magasanikiibacteriota bacterium]	diamond	93	52	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota bacterium
32392028	32392028	PRJNA734348_P_NODE_91059_length_251_cov_2.337079_g90361_i0	PRJNA734348	91059	251	2.337079	5.86606829	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	46.6	0.0018	NR	MBI5222766.1	2026717	g90361	i0	41.5	1.8406374501992	53	28	63.3	2	251	93	330	379	MBI5222766.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium]	diamond	462	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota	Candidatus Magasanikiibacteriota 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);;