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

17 rows where bioproject = "PRJNA414225" 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_genus	tax_species
2969660	2969660	PRJNA414225_P_NODE_51803_length_167_cov_0.864407_g51716_i0	PRJNA414225	51803	167	0.864407	1.44355969	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	182	1.71e-41	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g51716	i0	86.826	4.11377245508982	167	17	99	4	3	167	791138	790975	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	687	182	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota				Candidatus Nomurabacteria bacterium
3633940	3633940	PRJNA414225_P_NODE_24083_length_184_cov_1.496296_g23996_i0	PRJNA414225	24083	184	1.496296	2.75318464	Bacteria	2	Bacteria	Bacteria	326	8.37e-85	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g23996	i0	98.901	332.483695652174	182	2	99	0	1	182	598624	598443	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	61177	326	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				uncultured Candidatus Saccharibacteria bacterium
11897787	11897787	PRJNA414225_P_NODE_49210_length_167_cov_0.864407_g49123_i0	PRJNA414225	49210	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	96.7	3.0500000000000003e-22	NR	MBI1963501.1	2053607	g49123	i0	85.5	8.87425149700599	55	8	98.8	0	167	3	258	312	MBI1963501.1 TRAP transporter substrate-binding protein [Candidatus Rokuibacteriota bacterium]	diamond	1482	96.7	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota				Candidatus Rokuibacteriota bacterium
14447750	14447750	PRJNA414225_P_NODE_11912_length_202_cov_2.300654_g11825_i0	PRJNA414225	11912	202	2.300654	4.64732108	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	350	5.57e-92	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g11825	i0	98.01	183.287128712871	201	4	99	0	1	201	597419	597619	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	37024	350	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				uncultured Candidatus Saccharibacteria bacterium
22095437	22095437	PRJNA414225_P_NODE_83438_length_162_cov_1.805310_g83351_i0	PRJNA414225	83438	162	1.80531	2.9246022	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	91.7	2.77e-21	NR	HUS25317.1	2838779	g83351	i0	84.6	1.92592592592593	52	8	96.3	0	156	1	125	176	HUS25317.1 glutathione S-transferase family protein [Candidatus Binatia bacterium]	diamond	312	91.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
26885925	26885925	PRJNA414225_P_NODE_76381_length_163_cov_1.789474_g76294_i0	PRJNA414225	76381	163	1.789474	2.91684262	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	68.2	1.3e-11	NR	MFA6535044.1	2803731	g76294	i0	54.7	2.92638036809816	53	24	97.5	0	3	161	393	445	MFA6535044.1 hypothetical protein [Candidatus Babeliales bacterium]	diamond	477	68.2	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales		Candidatus Babeliales bacterium
27138345	27138345	PRJNA414225_P_NODE_3882_length_257_cov_0.903846_g3795_i0	PRJNA414225	3882	257	0.903846	2.32288422	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	163	1.59e-44	NR	RME30642.1	2762014	g3795	i0	96.5	0.992217898832685	85	3	99.2	0	1	255	119	203	RME30642.1 MAG: DEAD/DEAH box helicase [Candidatus Parcubacteria bacterium]	diamond	255	163	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria				Candidatus Parcubacteria bacterium
27313631	27313631	PRJNA414225_P_NODE_50323_length_167_cov_0.864407_g50236_i0	PRJNA414225	50323	167	0.864407	1.44355969	Pyrinomonas	1562565	Bacteria	Bacteria	107	9.27e-27	NR	MER3581264.1	2052139	g50236	i0	96.4	1.97604790419162	55	2	98.8	0	3	167	196	250	MER3581264.1 hypothetical protein [Patescibacteria group bacterium]	diamond	330	107	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
27928404	27928404	PRJNA414225_P_NODE_21985_length_186_cov_1.160584_g21898_i0	PRJNA414225	21985	186	1.160584	2.15868624	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	109	3.79e-26	NR	GMU19327.1	2803731	g21898	i0	73.8	0.983870967741935	61	16	98.4	0	3	185	164	224	GMU19327.1 MAG: hypothetical protein AMXMBFR12_05190 [Candidatus Babeliales bacterium]	diamond	183	109	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales		Candidatus Babeliales bacterium
29380798	29380798	PRJNA414225_P_NODE_67469_length_165_cov_0.879310_g67382_i0	PRJNA414225	67469	165	0.87931	1.4508615	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	76.3	6.73e-15	NR	MBI4863108.1	2053586	g67382	i0	67.3	1	55	18	100	0	165	1	95	149	MBI4863108.1 PrsW family intramembrane metalloprotease [Candidatus Rifleibacteriota bacterium]	diamond	165	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacteriota bacterium
29443698	29443698	PRJNA414225_P_NODE_35950_length_174_cov_1.640000_g35863_i0	PRJNA414225	35950	174	1.64	2.8536	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	50.4	2.43e-5	NR	NCU30406.1	2026720	g35863	i0	60	0.775862068965517	45	16	77.6	1	171	37	187	229	NCU30406.1 DNA (cytosine-5-)-methyltransferase [Candidatus Saccharibacteria bacterium]	diamond	135	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
29822599	29822599	PRJNA414225_P_NODE_32571_length_177_cov_1.593750_g32484_i0	PRJNA414225	32571	177	1.59375	2.8209375	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	70.5	1.72e-12	NR	WP_260763560.1	2665156	g32484	i0	57.9	0.966101694915254	57	20	96.6	1	2	172	236	288	WP_260763560.1 UDP-N-acetylglucosamine-transferase [Candidatus Mycosynbacter amalyticus]	diamond	171	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
30186873	30186873	PRJNA414225_P_NODE_72092_length_164_cov_0.886957_g72005_i0	PRJNA414225	72092	164	0.886957	1.45460948	Bacillati	1783272	Bacteria	Bacteria	110	5.63e-30	NR	NCU38818.1	2026720	g72005	i0	90.7	1.97560975609756	54	5	98.8	0	162	1	28	81	NCU38818.1 DUF262 domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	324	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
30960301	30960301	PRJNA414225_P_NODE_65294_length_165_cov_0.879310_g65207_i0	PRJNA414225	65294	165	0.87931	1.4508615	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	80.9	7.18e-18	NR	WP_260763803.1	2665156	g65207	i0	77.8	0.981818181818182	54	12	98.2	0	164	3	21	74	WP_260763803.1 hypothetical protein [Candidatus Mycosynbacter amalyticus]	diamond	162	80.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
31117965	31117965	PRJNA414225_P_NODE_71835_length_164_cov_0.886957_g71748_i0	PRJNA414225	71835	164	0.886957	1.45460948	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	118	1.03e-30	NR	MBY0278355.1	2838779	g71748	i0	96.3	0.98780487804878	54	2	98.8	0	1	162	185	238	MBY0278355.1 alpha/beta hydrolase [Candidatus Binatia bacterium]	diamond	162	118	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32762203	32762203	PRJNA414225_P_NODE_72300_length_164_cov_0.886957_g72213_i0	PRJNA414225	72300	164	0.886957	1.45460948	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	71.2	2.79e-13	NR	NCO10808.1	2026720	g72213	i0	61.1	0.98780487804878	54	21	98.8	0	164	3	95	148	NCO10808.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	162	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
32887992	32887992	PRJNA414225_P_NODE_64860_length_165_cov_0.879310_g64773_i0	PRJNA414225	64860	165	0.87931	1.4508615	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	63.9	4.17e-10	NR	GMU19488.1	2803731	g64773	i0	78.4	0.672727272727273	37	8	67.3	0	164	54	389	425	GMU19488.1 MAG: hypothetical protein AMXMBFR12_06800 [Candidatus Babeliales bacterium]	diamond	111	63.9	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales		Candidatus Babeliales 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);;