metadata: contig_metadata: 17 rows where bioproject = "PRJNA976345" and tax

17 rows where bioproject = "PRJNA976345" and tax_clade = "Bacteria candidate phyla"

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
6051089	6051089	PRJNA976345_P_NODE_146985_length_167_cov_3.242424_g145377_i0	PRJNA976345	146985	167	3.242424	5.41484808	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2518551991\|emb\|OX638351.1\|	265321	g145377	i0	96.97	0.197604790419162	33	1	20	0	135	167	541036	541068	MAG: uncultured Poribacteria bacterium isolate d4690918-7cf6-4b6d-bcb0-07eb3c50a363 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					uncultured Poribacteria bacterium
18800358	18800358	PRJNA976345_P_NODE_50555_length_246_cov_2.246445_g48947_i0	PRJNA976345	50555	246	2.246445	5.5262547	Candidatus Collierbacteria bacterium RIFOXYD1_FULL_4	2053540	Bacteria	Bacteria	155	1.09e-44	NR	OGD81566.1	1817731	g48947	i0	97.5	0.98780487804878	81	2	98.8	0	2	244	45	125	OGD81566.1 MAG: Holliday junction DNA helicase RuvB [Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9]	diamond	243	155	1	Bacteria	Bacteria candidate phyla	Candidatus Collieribacteriota					Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9
21669265	21669265	PRJNA976345_P_NODE_114737_length_181_cov_0.856164_g113129_i0	PRJNA976345	114737	181	0.856164	1.54965684	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	246	6.57e-61	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g113129	i0	94.375	49.0110497237569	160	9	88	0	22	181	77999	77840	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	8871	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22944936	22944936	PRJNA976345_P_NODE_24538_length_340_cov_1.029508_g22936_i0	PRJNA976345	24538	340	1.029508	3.5003272	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	318	2.869999999999999e-82	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g22936	i0	83.776	7.95588235294118	339	52	99	3	2	338	28373	28036	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	2705	318	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
25173906	25173906	PRJNA976345_P_NODE_135080_length_173_cov_1.543478_g133472_i0	PRJNA976345	135080	173	1.543478	2.67021694	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2870347126\|gb\|CP175956.1\|	2045217	g133472	i0	100	0.161849710982659	28	0	16	0	63	90	362597	362570	MAG: Candidatus Moraniibacteriota bacterium isolate MKparc2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
26931176	26931176	PRJNA976345_P_NODE_83142_length_203_cov_1.613095_g81534_i0	PRJNA976345	83142	203	1.613095	3.27458285	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	111	1.06e-26	NR	NJK47637.1	2044595	g81534	i0	83.6	3.96059113300493	67	11	99	0	201	1	258	324	NJK47637.1 sodium:proton antiporter [Candidatus Altimarinota bacterium]	diamond	804	111	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
28225976	28225976	PRJNA976345_P_NODE_42686_length_264_cov_2.751092_g41078_i0	PRJNA976345	42686	264	2.751092	7.26288288	Candidatus Microsaccharimonas sp.	3069365	Bacteria	Bacteria	79.3	6.53e-15	NR	HEY8886679.1	3069365	g41078	i0	53.8	0.909090909090909	80	37	90.9	0	23	262	620	699	HEY8886679.1 IPT/TIG domain-containing protein [Candidatus Microsaccharimonas sp.]	diamond	240	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Microsaccharimonas	Candidatus Microsaccharimonas sp.
28510433	28510433	PRJNA976345_P_NODE_178667_length_156_cov_1.396694_g177059_i0	PRJNA976345	178667	156	1.396694	2.17884264	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	101	2.29e-25	NR	MDD4804476.1	2053589	g177059	i0	98	0.942307692307692	49	1	94.2	0	148	2	130	178	MDD4804476.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	147	101	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28573527	28573527	PRJNA976345_P_NODE_88067_length_199_cov_1.213415_g86459_i0	PRJNA976345	88067	199	1.213415	2.41469585	Candidatus Aerophobetes bacterium	2030807	Bacteria	Bacteria	47	6.48e-4	NR	PCI92091.1	2030807	g86459	i0	51.3	0.587939698492462	39	19	58.8	0	72	188	117	155	PCI92091.1 MAG: hypothetical protein COB11_07915, partial [Candidatus Aerophobetes bacterium]	diamond	117	47	1	Bacteria	Bacteria candidate phyla	Candidatus Aerophobota					Candidatus Aerophobota bacterium
28794353	28794353	PRJNA976345_P_NODE_106747_length_185_cov_2.353333_g105139_i0	PRJNA976345	106747	185	2.353333	4.35366605	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	117	5.08e-29	NR	NCC20175.1	2026720	g105139	i0	100	0.989189189189189	61	0	98.9	0	1	183	520	580	NCC20175.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	183	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30342576	30342576	PRJNA976345_P_NODE_79632_length_206_cov_2.087719_g78024_i0	PRJNA976345	79632	206	2.087719	4.30070114	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.5	2.04e-4	NR	MBR6124363.1	2026720	g78024	i0	40.4	0.757281553398058	52	31	75.7	0	6	161	8	59	MBR6124363.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	156	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30689448	30689448	PRJNA976345_P_NODE_58633_length_232_cov_1.005076_g57025_i0	PRJNA976345	58633	232	1.005076	2.33177632	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	134	1.23e-38	NR	MDD4804356.1	2053589	g57025	i0	100	0.866379310344828	67	0	86.6	0	1	201	46	112	MDD4804356.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	201	134	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31194664	31194664	PRJNA976345_P_NODE_162935_length_161_cov_1.936508_g161327_i0	PRJNA976345	162935	161	1.936508	3.11777788	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	92	2.0500000000000003e-21	NR	RKW01774.1	1917697	g161327	i0	91.8	0.91304347826087	49	4	91.3	0	160	14	12	60	RKW01774.1 MAG: CHAP domain-containing protein [Candidatus Saccharimonas sp.]	diamond	147	92	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
31385025	31385025	PRJNA976345_P_NODE_71216_length_215_cov_1.777778_g69608_i0	PRJNA976345	71216	215	1.777778	3.8222227	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	44.3	0.00725	NR	GIW62757.1	2052139	g69608	i0	36.7	0.837209302325581	60	36	83.7	2	199	20	154	211	GIW62757.1 MAG: glycosidase [Patescibacteria group bacterium]	diamond	180	44.3	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32023796	32023796	PRJNA976345_P_NODE_195498_length_151_cov_1.379310_g193890_i0	PRJNA976345	195498	151	1.37931	2.0827581	Pseudomonadati	3379134	Bacteria	Bacteria	65.1	1.2e-10	NR	HWS97550.1	2032687	g193890	i0	93.8	1.90728476821192	32	2	63.6	0	151	56	96	127	HWS97550.1 glycosyltransferase family 4 protein [Candidatus Methylomirabilis sp.]	diamond	288	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
32175912	32175912	PRJNA976345_P_NODE_167838_length_159_cov_2.951613_g166230_i0	PRJNA976345	167838	159	2.951613	4.69306467	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42	0.0223	NR	MES2216505.1	2052139	g166230	i0	37.3	0.962264150943396	51	32	96.2	0	5	157	50	100	MES2216505.1 RNase H-like domain-containing protein [Patescibacteria group bacterium]	diamond	153	42	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32587115	32587115	PRJNA976345_P_NODE_189639_length_152_cov_4.111111_g188031_i0	PRJNA976345	189639	152	4.111111	6.24888872	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	45.8	8.8e-4	NR	HRN86934.1	2099670	g188031	i0	43.8	1.75657894736842	48	27	94.7	0	150	7	122	169	HRN86934.1 reverse transcriptase family protein [Candidatus Dojkabacteria bacterium]	diamond	267	45.8	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria 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);;