metadata: contig_metadata: 21 rows where bioproject = "PRJNA758088" and tax

21 rows where bioproject = "PRJNA758088" 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
4565663	4565663	PRJNA758088_P_NODE_314564_length_247_cov_0.885057_g307593_i0	PRJNA758088	314564	247	0.885057	2.18609079	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	8.89e-111	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g307593	i0	96.761	97.7813765182186	247	8	100	0	1	247	798196	798442	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	24152	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
4566061	4566061	PRJNA758088_P_NODE_340724_length_244_cov_0.900585_g333753_i0	PRJNA758088	340724	244	0.900585	2.1974274	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g333753	i0	97.951	2	244	5	100	0	1	244	119105	119348	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	488	424	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
8391154	8391154	PRJNA758088_P_NODE_355247_length_242_cov_0.911243_g348276_i0	PRJNA758088	355247	242	0.911243	2.20520806	Candidatus Bipolaricaulis anaerobius	2026885	Bacteria	Bacteria	67.6	7.78e-7	NTclustered	gi\|1403730514\|emb\|LS483254.1\|	2026885	g348276	i0	91.837	2.70247933884298	49	2	20	2	60	108	30041	29995	Candidatus Acetothermia bacterium Ran1 isolate BARAN1 MAG genome assembly, chromosome: BARAN1	blastn	654	67.6	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulia	Candidatus Bipolaricaulales	Candidatus Bipolaricaulaceae	Candidatus Bipolaricaulis	Candidatus Bipolaricaulis anaerobius
13491184	13491184	PRJNA758088_P_NODE_321571_length_246_cov_0.890173_g314600_i0	PRJNA758088	321571	246	0.890173	2.18982558	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	62.1	3.69e-5	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g314600	i0	87.5	0.227642276422764	56	4	23	2	62	117	1077566	1077618	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	56	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
23687117	23687117	PRJNA758088_P_NODE_104979_length_409_cov_1.660714_g98009_i0	PRJNA758088	104979	409	1.660714	6.79232026	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	756	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g98009	i0	100	228.936430317848	409	0	100	0	1	409	502266	501858	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	93635	756	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
26926441	26926441	PRJNA758088_P_NODE_313822_length_247_cov_0.885057_g306851_i0	PRJNA758088	313822	247	0.885057	2.18609079	TM7 phylum sp. oral taxon 35	713052	Bacteria	Bacteria	160	6.55e-47	NR	TWP08780.1	713052	g306851	i0	100	0.995951417004049	82	0	99.6	0	246	1	174	255	TWP08780.1 triose-phosphate isomerase [TM7 phylum sp. oral taxon 350]	diamond	246	160	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 350
27147390	27147390	PRJNA758088_P_NODE_353962_length_242_cov_0.911243_g346991_i0	PRJNA758088	353962	242	0.911243	2.20520806	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	100	2.14e-22	NR	HET6746543.1	2973664	g346991	i0	59.3	4.01652892561984	81	32	99.2	1	3	242	70	150	HET6746543.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	972	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27179216	27179216	PRJNA758088_P_NODE_281602_length_251_cov_0.865169_g274631_i0	PRJNA758088	281602	251	0.865169	2.17157419	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	82	5.54e-18	NR	HTK84385.1	2052139	g274631	i0	42.2	0.99203187250996006	83	48	99.2	0	1	249	7	89	HTK84385.1 hypothetical protein [Patescibacteria group bacterium]	diamond	249	82	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27685153	27685153	PRJNA758088_P_NODE_94524_length_432_cov_2.924791_g87554_i0	PRJNA758088	94524	432	2.924791	12.63509712	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	79.7	8.17e-15	NR	RTL06913.1	2030827	g87554	i0	34	1	144	90	97.9	2	5	427	61	202	RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium]	diamond	432	79.7	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
28126943	28126943	PRJNA758088_P_NODE_254145_length_266_cov_1.290155_g247174_i0	PRJNA758088	254145	266	1.290155	3.4318123	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	70.1	1.21e-11	NR	XLQ20013.1	2045217	g247174	i0	41.5	1.83834586466165	82	36	92.5	3	248	3	514	583	XLQ20013.1 MAG: tail fiber protein [Candidatus Moraniibacteriota bacterium]	diamond	489	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
28632263	28632263	PRJNA758088_P_NODE_340947_length_244_cov_0.900585_g333976_i0	PRJNA758088	340947	244	0.900585	2.1974274	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	145	1.4e-39	NR	MBR3204498.1	2026720	g333976	i0	95	1.9672131147541	80	4	98.4	0	242	3	236	315	MBR3204498.1 GIY-YIG nuclease family protein [Candidatus Saccharibacteria bacterium]	diamond	480	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29863397	29863397	PRJNA758088_P_NODE_340131_length_244_cov_0.900585_g333160_i0	PRJNA758088	340131	244	0.900585	2.1974274	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	91.3	3.19e-19	NR	MBP6975082.1	2053589	g333160	i0	61.1	2.90163934426229	72	28	88.5	0	28	243	483	554	MBP6975082.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	708	91.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30031252	30031252	PRJNA758088_P_NODE_324531_length_246_cov_0.890173_g317560_i0	PRJNA758088	324531	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	86.7	8.16e-19	NR	MBM3230698.1	2030811	g317560	i0	61.3	1.58536585365854	62	24	75.6	0	206	21	1	62	MBM3230698.1 DNA repair protein RecO [Candidatus Peregrinibacteria bacterium]	diamond	390	87.4	0.991990846681922	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
30274427	30274427	PRJNA758088_P_NODE_349272_length_243_cov_0.905882_g342301_i0	PRJNA758088	349272	243	0.905882	2.20129326	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	53.1	2.26e-6	NR	MBP9717439.1	2053589	g342301	i0	67.6	0.827160493827161	34	11	42	0	213	112	119	152	MBP9717439.1 HNH endonuclease [Candidatus Paceibacterota bacterium]	diamond	201	53.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30495475	30495475	PRJNA758088_P_NODE_31473_length_849_cov_2.266753_g25707_i0	PRJNA758088	31473	849	2.266753	19.24473297	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	50.4	0.00542	NR	MDQ1327540.1	2026781	g25707	i0	26.2	1.21554770318021	172	105	56.2	5	268	744	137	299	MDQ1327540.1 dehydrogenase [Candidatus Poribacteria bacterium]	diamond	1032	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
30684755	30684755	PRJNA758088_P_NODE_274113_length_254_cov_1.569061_g267142_i0	PRJNA758088	274113	254	1.569061	3.98541494	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	92.4	9.31e-22	NR	UPA22478.1	2053688	g267142	i0	56	0.885826771653543	75	31	88.6	1	253	29	57	129	UPA22478.1 MAG: FdtA/QdtA family cupin domain-containing protein [Candidatus Peribacteria bacterium]	diamond	225	92.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
30779686	30779686	PRJNA758088_P_NODE_283434_length_251_cov_0.865169_g276463_i0	PRJNA758088	283434	251	0.865169	2.17157419	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	43.9	0.0162	NR	MCX7997273.1	2052139	g276463	i0	43.1	1.56573705179283	72	38	84.9	3	20	232	365	434	MCX7997273.1 trypsin-like serine protease [Patescibacteria group bacterium]	diamond	393	43.9	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31295060	31295060	PRJNA758088_P_NODE_365795_length_241_cov_0.916667_g358824_i0	PRJNA758088	365795	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	57.4	2.34e-7	NR	MFA6095644.1	2053589	g358824	i0	54.8	4.99170124481328	62	23	77.2	1	239	54	236	292	MFA6095644.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	1203	57.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31538530	31538530	PRJNA758088_P_NODE_350536_length_243_cov_0.905882_g343565_i0	PRJNA758088	350536	243	0.905882	2.20129326	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	99	4.4e-22	NR	MBM3210273.1	2026720	g343565	i0	62	0.975308641975309	79	30	97.5	0	4	240	112	190	MBM3210273.1 ABC transporter permease [Candidatus Saccharibacteria bacterium]	diamond	237	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31759725	31759725	PRJNA758088_P_NODE_323817_length_246_cov_0.890173_g316846_i0	PRJNA758088	323817	246	0.890173	2.18982558	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	85.1	4.56e-17	NR	MCL4419431.1	2052139	g316846	i0	78.4	0.621951219512195	51	10	61	1	152	3	529	579	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	153	85.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32718033	32718033	PRJNA758088_P_NODE_315000_length_247_cov_0.885057_g308029_i0	PRJNA758088	315000	247	0.885057	2.18609079	Stagnihabitans	2939640	Bacteria	Bacteria	108	3.62e-25	NR	MFA9229475.1	2461418	g308029	i0	73.5	1.63967611336032	68	18	82.6	0	245	42	936	1003	MFA9229475.1 sarcosine oxidase subunit alpha family protein [Microgenomates group bacterium]	diamond	405	109	0.990825688073395	Bacteria	Bacteria candidate phyla						Microgenomates group 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);;