metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA1126661" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA1126661" 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_class	tax_order	tax_family	tax_genus	tax_species
4109500	4109500	PRJNA1126661_P_NODE_44144_length_300_cov_3.876652_g43615_i0	PRJNA1126661	44144	300	3.876652	11.629956	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	171	1.3900000000000001e-49	NR	QWB91149.2	1917697	g43615	i0	74.3	2.26	113	14	98	1	299	6	203	315	QWB91149.2 MAG: hypothetical protein HXL38_001060 [Candidatus Saccharimonas sp.]	diamond	678	171	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
26880643	26880643	PRJNA1126661_P_NODE_30941_length_325_cov_5.718254_g30412_i0	PRJNA1126661	30941	325	5.718254	18.5843255	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94	6.28e-21	NR	MBB1562157.1	2026720	g30412	i0	96	0.461538461538462	50	2	46.2	0	150	1	105	154	MBB1562157.1 basic amino acid ABC transporter substrate-binding protein [Candidatus Saccharibacteria bacterium]	diamond	150	94	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26943655	26943655	PRJNA1126661_P_NODE_41442_length_301_cov_2.956140_g40913_i0	PRJNA1126661	41442	301	2.95614	8.8979814	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	96.7	1.08e-21	NR	MBB1567284.1	2026720	g40913	i0	100	0.498338870431894	50	0	49.8	0	151	300	34	83	MBB1567284.1 DNA-protecting protein DprA [Candidatus Saccharibacteria bacterium]	diamond	150	96.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27354959	27354959	PRJNA1126661_P_NODE_39623_length_301_cov_3.557018_g39094_i0	PRJNA1126661	39623	301	3.557018	10.70662418	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.6	4.57e-18	NR	MBB1567161.1	2026720	g39094	i0	98	0.508305647840532	51	1	50.8	0	301	149	319	369	MBB1567161.1 ABC transporter permease [Candidatus Saccharibacteria bacterium]	diamond	153	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27670738	27670738	PRJNA1126661_P_NODE_10684_length_326_cov_6.845850_g10155_i0	PRJNA1126661	10684	326	6.84585	22.317471	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	75.9	2.12e-13	NR	MBB1562754.1	2026720	g10155	i0	100	0.377300613496933	41	0	37.7	0	2	124	413	453	MBB1562754.1 ABC transporter permease [Candidatus Saccharibacteria bacterium]	diamond	123	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27797023	27797023	PRJNA1126661_P_NODE_23784_length_326_cov_3.371542_g23255_i0	PRJNA1126661	23784	326	3.371542	10.99122692	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94	5.75e-20	NR	MBB1557814.1	2026720	g23255	i0	98	0.920245398773006	50	1	46	0	325	176	154	203	MBB1557814.1 S41 family peptidase [Candidatus Saccharibacteria bacterium]	diamond	300	94	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28017984	28017984	PRJNA1126661_P_NODE_8285_length_326_cov_9.387352_g7756_i0	PRJNA1126661	8285	326	9.387352	30.60276752	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	77	4.32e-14	NR	HVX57347.1	2973664	g7756	i0	70.8	1.33435582822086	48	14	44.2	0	146	3	71	118	HVX57347.1 lysylphosphatidylglycerol synthase transmembrane domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	435	77	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29249132	29249132	PRJNA1126661_P_NODE_44389_length_300_cov_3.651982_g43860_i0	PRJNA1126661	44389	300	3.651982	10.955946	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	155	7.73e-43	NR	RKW02907.1	1917697	g43860	i0	53.7	1.77	177	4	99	1	2	298	120	296	RKW02907.1 MAG: single-stranded-DNA-specific exonuclease RecJ, partial [Candidatus Saccharimonas sp.]	diamond	531	155	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29344072	29344072	PRJNA1126661_P_NODE_80189_length_224_cov_8.390728_g79659_i0	PRJNA1126661	80189	224	8.390728	18.79523072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	79	3.54e-15	NR	MBB1562739.1	2026720	g79659	i0	97.5	0.535714285714286	40	1	53.6	0	224	105	328	367	MBB1562739.1 molecular chaperone DnaJ [Candidatus Saccharibacteria bacterium]	diamond	120	79	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29817423	29817423	PRJNA1126661_P_NODE_43631_length_300_cov_4.559471_g43102_i0	PRJNA1126661	43631	300	4.559471	13.678413	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	93.2	8.42e-20	NR	MCD1275667.1	2725942	g43102	i0	100	1	50	0	50	0	2	151	329	378	MCD1275667.1 hypothetical protein [Candidatus Nanogingivalaceae bacterium]	diamond	300	93.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
29975535	29975535	PRJNA1126661_P_NODE_70131_length_252_cov_9.296089_g69601_i0	PRJNA1126661	70131	252	9.296089	23.42614428	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	151	3.0099999999999993e-40	NR	HEY4160575.1	2973664	g69601	i0	87.8	2.92857142857143	82	10	97.6	0	2	247	912	993	HEY4160575.1 UvrD-helicase domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	738	151	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30533288	30533288	PRJNA1126661_P_NODE_16953_length_326_cov_4.541502_g16424_i0	PRJNA1126661	16953	326	4.541502	14.80529652	Bacillati	1783272	Bacteria	Bacteria	159	1.53e-43	NR	MDB5165736.1	2026720	g16424	i0	65.7	7.57361963190184	137	17	98.5	1	3	323	135	271	MDB5165736.1 rane protein of unknown function [Candidatus Saccharibacteria bacterium]	diamond	2469	160	0.99375	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31334147	31334147	PRJNA1126661_P_NODE_61476_length_274_cov_4.283582_g60946_i0	PRJNA1126661	61476	274	4.283582	11.73701468	TM7 phylum sp. oral taxon 348	671231	Bacteria	Bacteria	155	3.07e-42	NR	TWP28630.1	671231	g60946	i0	83.5	0.996350364963504	91	15	99.6	0	2	274	151	241	TWP28630.1 ABC transporter ATP-binding protein [TM7 phylum sp. oral taxon 348]	diamond	273	155	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 348
31734341	31734341	PRJNA1126661_P_NODE_52557_length_293_cov_3.263636_g52028_i0	PRJNA1126661	52557	293	3.263636	9.56245348	Candidatus Nanosynsacchari	2789662	Bacteria	Bacteria	140	9.03e-38	NR	WP_129693372.1	1986206	g52028	i0	50.9	3.46075085324232	169	10	98.3	1	3	290	155	323	WP_129693372.1 glycosyltransferase [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	1014	140	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
32568301	32568301	PRJNA1126661_P_NODE_31379_length_325_cov_2.543651_g30850_i0	PRJNA1126661	31379	325	2.543651	8.26686575	Candidatus Nanosynbacter sp. BB	2725945	Bacteria	Bacteria	138	1.86e-37	NR	WP_338521163.1	3393757	g30850	i0	50	1.64307692307692	178	19	99.7	1	2	325	1	178	WP_338521163.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Candidatus Nanosynbacter sp. BB002]	diamond	534	138	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
32840460	32840460	PRJNA1126661_P_NODE_9520_length_326_cov_7.664032_g8991_i0	PRJNA1126661	9520	326	7.664032	24.98474432	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	75.9	3.12e-14	NR	MBP7775207.1	1917697	g8991	i0	69.4	1.81288343558282	49	15	45.1	0	151	5	141	189	MBP7775207.1 LemA family protein [Candidatus Saccharimonas sp.]	diamond	591	76.3	0.99475753604194	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.

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