metadata: contig_metadata: 7 rows where bioproject = "PRJNA414225", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA414225", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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_genus	tax_species
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
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
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
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

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