metadata: contig_metadata: 15 rows where bioproject = "PRJNA680334", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA680334", 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
650501	650501	PRJNA680334_S_NODE_89441_length_159_cov_3.222222_g88955_i0	PRJNA680334	89441	159	3.222222	5.12333298	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	217	4.41e-52	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g88955	i0	91.25	57.1572327044025	160	12	100	2	1	159	668229	668071	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	9088	217	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
22327548	22327548	PRJNA680334_S_NODE_65838_length_176_cov_1.342657_g65352_i0	PRJNA680334	65838	176	1.342657	2.36307632	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	87.8	1.34e-19	NR	HSW79751.1	2973664	g65352	i0	91.3	1.55113636363636	46	4	78.4	0	139	2	28	73	HSW79751.1 50S ribosomal protein L4 [Candidatus Saccharimonadales bacterium]	diamond	273	87.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
22846801	22846801	PRJNA680334_S_NODE_76978_length_167_cov_2.753731_g76492_i0	PRJNA680334	76978	167	2.753731	4.59873077	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	276	7.64e-70	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g76492	i0	96.407	3	167	6	100	0	1	167	291096	291262	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	501	276	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
27018696	27018696	PRJNA680334_S_NODE_95382_length_156_cov_1.959350_g94896_i0	PRJNA680334	95382	156	1.95935	3.056586	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	86.3	3.59e-18	NR	MAU33628.1	2026720	g94896	i0	80.4	1.96153846153846	51	10	98.1	0	155	3	279	329	MAU33628.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	306	86.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27682525	27682525	PRJNA680334_S_NODE_106984_length_150_cov_2.982906_g106498_i0	PRJNA680334	106984	150	2.982906	4.474359	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	42	0.0192	NR	TAH34118.1	2026720	g106498	i0	59.3	1.16	27	11	54	0	6	86	203	229	TAH34118.1 MAG: hypothetical protein EYC59_03925 [Candidatus Saccharibacteria bacterium]	diamond	174	42	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28281893	28281893	PRJNA680334_S_NODE_99486_length_154_cov_1.462810_g99000_i0	PRJNA680334	99486	154	1.46281	2.2527274	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	94	5.4300000000000006e-21	NR	HEY5267639.1	2973664	g99000	i0	84	0.974025974025974	50	8	97.4	0	3	152	117	166	HEY5267639.1 RNA ligase [Candidatus Saccharimonadales bacterium]	diamond	150	94	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28313745	28313745	PRJNA680334_S_NODE_64266_length_177_cov_2.881944_g63780_i0	PRJNA680334	64266	177	2.881944	5.10104088	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	110	3e-28	NR	MBF1034820.1	2725945	g63780	i0	94.7	2.89830508474576	57	3	96.6	0	2	172	79	135	MBF1034820.1 ATP-binding cassette domain-containing protein [Candidatus Nanosynbacter sp.]	diamond	513	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
28471667	28471667	PRJNA680334_S_NODE_44446_length_199_cov_2.825301_g43960_i0	PRJNA680334	44446	199	2.825301	5.62234899	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	117	7.7e-29	NR	HSX05875.1	2973664	g43960	i0	87.3	2.87939698492462	63	8	95	0	191	3	473	535	HSX05875.1 DUF2309 domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	573	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29892581	29892581	PRJNA680334_S_NODE_107031_length_150_cov_2.854701_g106545_i0	PRJNA680334	107031	150	2.854701	4.2820515	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	63.2	1.62e-10	NR	HET8884279.1	2973664	g106545	i0	61.2	0.98	49	19	98	0	2	148	110	158	HET8884279.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	147	63.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31124243	31124243	PRJNA680334_S_NODE_16115_length_271_cov_11.886555_g15629_i0	PRJNA680334	16115	271	11.886555	32.21256405	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	166	2.99e-46	NR	MCG5105727.1	2026720	g15629	i0	94.3	0.96309963099631	87	5	96.3	0	9	269	447	533	MCG5105727.1 DNA primase [Candidatus Saccharibacteria bacterium]	diamond	261	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31155841	31155841	PRJNA680334_S_NODE_49235_length_193_cov_1.662500_g48749_i0	PRJNA680334	49235	193	1.6625	3.208625	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	41.2	0.0465	NR	HRJ06219.1	2026720	g48749	i0	55.6	0.419689119170984	27	12	42	0	131	51	145	171	HRJ06219.1 PH domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	81	41.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31377698	31377698	PRJNA680334_S_NODE_89156_length_159_cov_4.293651_g88670_i0	PRJNA680334	89156	159	4.293651	6.82690509	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	90.5	1.07e-19	NR	MAU33628.1	2026720	g88670	i0	84.6	0.981132075471698	52	8	98.1	0	2	157	232	283	MAU33628.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	156	90.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32010218	32010218	PRJNA680334_S_NODE_54238_length_187_cov_2.454545_g53752_i0	PRJNA680334	54238	187	2.454545	4.58999915	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	90.1	5.25e-20	NR	HSX06511.1	2890869	g53752	i0	74.2	0.994652406417112	62	16	99.5	0	1	186	91	152	HSX06511.1 inositol monophosphatase [Candidatus Saccharimonadia bacterium]	diamond	186	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
32453455	32453455	PRJNA680334_S_NODE_31619_length_221_cov_3.542553_g31133_i0	PRJNA680334	31619	221	3.542553	7.82904213	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	83.2	7.92e-17	NR	MEX2014871.1	2973664	g31133	i0	80	2.93212669683258	55	11	74.7	0	167	3	1	55	MEX2014871.1 sigma factor-like helix-turn-helix DNA-binding protein [Candidatus Saccharimonadales bacterium]	diamond	648	83.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32579868	32579868	PRJNA680334_S_NODE_96719_length_155_cov_2.975410_g96233_i0	PRJNA680334	96719	155	2.97541	4.6118855	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	78.2	3.41e-15	NR	HMS31985.1	2026720	g96233	i0	77.6	3.89032258064516	49	11	94.8	0	147	1	84	132	HMS31985.1 aldehyde dehydrogenase family protein [Candidatus Saccharibacteria bacterium]	diamond	603	78.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);;