metadata: contig_metadata: 8 rows where bioproject = "PRJNA1005695" and tax

8 rows where bioproject = "PRJNA1005695" 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_species
10356575	10356575	PRJNA1005695_P_NODE_16369_length_374_cov_3.900332_g15517_i0	PRJNA1005695	16369	374	3.900332	14.58724168	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	545	1.34e-150	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g15517	i0	93.496	117.066844919786	369	21	99	3	1	369	543545	543910	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	43783	545	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria genomosp. TM7-H1
10356766	10356766	PRJNA1005695_P_NODE_38589_length_245_cov_0.906977_g37737_i0	PRJNA1005695	38589	245	0.906977	2.22209365	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	363	8.989999999999999e-96	NTclustered	gi\|2874253985\|emb\|OY970310.1\|	2803731	g37737	i0	94.492	7.0734693877551	236	12	96	1	10	245	336998	336764	MAG: Candidatus Babeliales bacterium isolate MFD05512.bin.c.16 genome assembly, chromosome: 1	blastn	1733	363	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliales bacterium
20554829	20554829	PRJNA1005695_P_NODE_39797_length_242_cov_2.106509_g38945_i0	PRJNA1005695	39797	242	2.106509	5.09775178	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g38945	i0	82.645	211.954545454545	242	32	98	7	1	237	2262802	2262566	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	51293	206	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		uncultured Candidatus Binatia bacterium
28266024	28266024	PRJNA1005695_P_NODE_33806_length_256_cov_1.442623_g32954_i0	PRJNA1005695	33806	256	1.442623	3.69311488	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	43.9	0.00548	NR	MCL4418468.1	2052139	g32954	i0	34.9	0.73828125	63	41	73.8	0	19	207	58	120	MCL4418468.1 hypothetical protein [Patescibacteria group bacterium]	diamond	189	43.9	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
28929315	28929315	PRJNA1005695_P_NODE_31288_length_267_cov_1.206186_g30436_i0	PRJNA1005695	31288	267	1.206186	3.22051662	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	72.8	1.38e-12	NR	HWZ45011.1	2973664	g30436	i0	60	4.84269662921348	60	23	67.4	1	4	183	909	967	HWZ45011.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Saccharimonadales bacterium]	diamond	1293	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
29024407	29024407	PRJNA1005695_P_NODE_39428_length_243_cov_1.411765_g38576_i0	PRJNA1005695	39428	243	1.411765	3.43058895	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	67.4	7.2e-11	NR	MCL4419903.1	2052139	g38576	i0	50	1.8641975308642	74	34	87.7	1	214	2	43	116	MCL4419903.1 WD40 repeat domain-containing protein [Patescibacteria group bacterium]	diamond	453	67.4	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
29623429	29623429	PRJNA1005695_P_NODE_42030_length_222_cov_4.214765_g41178_i0	PRJNA1005695	42030	222	4.214765	9.3567783	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	71.6	2.89e-14	NR	HRN86952.1	2099670	g41178	i0	54.1	1	74	31	100	1	1	222	20	90	HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	222	71.6	1	Bacteria	Bacteria candidate phyla				Candidatus Dojkabacteria bacterium
31860095	31860095	PRJNA1005695_P_NODE_21217_length_327_cov_1.228346_g20365_i0	PRJNA1005695	21217	327	1.228346	4.01669142	Pseudomonadati	3379134	Bacteria	Bacteria	111	1.13e-28	NR	MBN2345804.1	2052149	g20365	i0	61.2	3.59633027522936	98	38	89.9	0	323	30	63	160	MBN2345804.1 3-phosphoglycerate dehydrogenase [Candidatus Aminicenantes bacterium]	diamond	1176	111	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota			Candidatus Aminicenantes 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);;