metadata: contig_metadata: 14 rows where bioproject = "PRJNA703759", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJNA703759", 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_class	tax_order	tax_family	tax_genus	tax_species
1184884	1184884	PRJNA703759_P_NODE_23261_length_292_cov_1.232877_g22785_i0	PRJNA703759	23261	292	1.232877	3.60000084	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	512	1.03e-140	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g22785	i0	98.288	3.1472602739726	292	5	100	0	1	292	538121	538412	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	919	512	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
10888434	10888434	PRJNA703759_P_NODE_29309_length_269_cov_1.540816_g28833_i0	PRJNA703759	29309	269	1.540816	4.14479504	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	166	2.9199999999999996e-45	NR	WP_164998006.1	1986206	g28833	i0	100	0.992565055762082	89	0	99.3	0	1	267	255	343	WP_164998006.1 DNA-directed RNA polymerase subunit beta' [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	267	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
21086961	21086961	PRJNA703759_P_NODE_37617_length_251_cov_0.876404_g37141_i0	PRJNA703759	37617	251	0.876404	2.19977404	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	145	3.65e-30	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g37141	i0	98.765	24.1195219123506	81	1	32	0	83	163	1087175	1087095	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	6054	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
23637625	23637625	PRJNA703759_P_NODE_46539_length_245_cov_0.906977_g46063_i0	PRJNA703759	46539	245	0.906977	2.22209365	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g46063	i0	97.959	2.00408163265306	245	5	100	0	1	245	19103	18859	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	491	425	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
28010122	28010122	PRJNA703759_P_NODE_34165_length_253_cov_1.694444_g33689_i0	PRJNA703759	34165	253	1.694444	4.28694332	Bacteria	2	Bacteria	Bacteria	134	1.23e-34	NR	MBC7943085.1	2026720	g33689	i0	78.6	6.9604743083004	84	18	99.6	0	252	1	330	413	MBC7943085.1 murein biosynthesis integral membrane protein MurJ [Candidatus Saccharibacteria bacterium]	diamond	1761	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28325532	28325532	PRJNA703759_P_NODE_48806_length_243_cov_0.917647_g48330_i0	PRJNA703759	48806	243	0.917647	2.22988221	Candidatus Microsaccharimonas	2959523	Bacteria	Bacteria	64.7	2.56e-10	NR	MBC7459325.1	2026720	g48330	i0	46.3	1.71604938271605	80	39	93.8	2	232	5	55	134	MBC7459325.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	417	65.1	0.993855606758833	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28503979	28503979	PRJNA703759_P_NODE_36747_length_252_cov_0.871508_g36271_i0	PRJNA703759	36747	252	0.871508	2.19620016	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	71.2	3.7e-12	NR	QQS21702.1	2026720	g36271	i0	71.2	0.619047619047619	52	15	61.9	0	95	250	350	401	QQS21702.1 MAG: hypothetical protein IPM09_04260 [Candidatus Saccharibacteria bacterium]	diamond	156	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28882753	28882753	PRJNA703759_P_NODE_42548_length_247_cov_1.793103_g42072_i0	PRJNA703759	42548	247	1.793103	4.42896441	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	139	2.44e-36	NR	HBO64458.1	2026720	g42072	i0	74.4	3.98380566801619	82	21	99.6	0	247	2	353	434	HBO64458.1 heavy metal translocating P-type ATPase [Candidatus Saccharibacteria bacterium]	diamond	984	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29230392	29230392	PRJNA703759_P_NODE_49729_length_243_cov_0.917647_g49253_i0	PRJNA703759	49729	243	0.917647	2.22988221	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	48.1	4.83e-4	NR	HZM03452.1	2973664	g49253	i0	63.2	0.469135802469136	38	12	44.4	1	237	130	579	616	HZM03452.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	114	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30304461	30304461	PRJNA703759_P_NODE_49992_length_243_cov_0.894118_g49516_i0	PRJNA703759	49992	243	0.894118	2.17270674	Candidatus Nanosyncoccus nanoralicus	2171996	Bacteria	Bacteria	166	2.7899999999999998e-46	NR	WP_129604022.1	2171996	g49516	i0	98.8	1	81	1	100	0	1	243	281	361	WP_129604022.1 DNA gyrase/topoisomerase IV subunit B [Candidatus Nanosyncoccus nanoralicus]	diamond	243	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanosyncoccales	Candidatus Nanosyncoccaceae	Candidatus Nanosyncoccus	Candidatus Nanosyncoccus nanoralicus
31599970	31599970	PRJNA703759_P_NODE_42976_length_247_cov_0.896552_g42500_i0	PRJNA703759	42976	247	0.896552	2.21448344	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	89	2.06e-18	NR	HET8884684.1	2973664	g42500	i0	62.8	3.54655870445344	86	26	98.4	2	246	4	137	221	HET8884684.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	876	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32042722	32042722	PRJNA703759_P_NODE_41638_length_248_cov_0.891429_g41162_i0	PRJNA703759	41638	248	0.891429	2.21074392	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	105	2.59e-24	NR	QQS69045.1	2026720	g41162	i0	60.5	1.93548387096774	81	31	98	1	6	248	445	524	QQS69045.1 MAG: M48 family metalloprotease [Candidatus Saccharibacteria bacterium]	diamond	480	105	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32200951	32200951	PRJNA703759_P_NODE_39358_length_250_cov_0.881356_g38882_i0	PRJNA703759	39358	250	0.881356	2.20339	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	72	1.47e-13	NR	HSI64804.1	2890869	g38882	i0	45.7	1.92	81	43	97.2	1	250	8	50	129	HSI64804.1 Imm26 family immunity protein [Candidatus Saccharimonadia bacterium]	diamond	480	72	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
32643171	32643171	PRJNA703759_P_NODE_34700_length_253_cov_0.866667_g34224_i0	PRJNA703759	34700	253	0.866667	2.19266751	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	110	4.81e-27	NR	MBL8159524.1	2026720	g34224	i0	71.4	0.99604743083004	84	24	99.6	0	252	1	39	122	MBL8159524.1 mechanosensitive ion channel family protein [Candidatus Saccharibacteria bacterium]	diamond	252	110	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);;