metadata: contig_metadata: 5 rows where bioproject = "PRJNA795663" and tax

5 rows where bioproject = "PRJNA795663" 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_species
27663364	27663364	PRJNA795663_S_NODE_8224_length_210_cov_1.121387_g8119_i0	PRJNA795663	8224	210	1.121387	2.3549127	Bacteria	2	Bacteria	Bacteria	75.9	4.92e-14	NR	MCA9332118.1	2026720	g8119	i0	56.3	2.7	64	28	91.4	0	17	208	310	373	MCA9332118.1 PAS domain-containing sensor histidine kinase [Candidatus Saccharibacteria bacterium]	diamond	567	76.6	0.990861618798956	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
28317172	28317172	PRJNA795663_S_NODE_3846_length_295_cov_2.492248_g3741_i0	PRJNA795663	3846	295	2.492248	7.3521316	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	149	3.849999999999999e-40	NR	MBX6334820.1	2026720	g3741	i0	70.4	0.996610169491525	98	29	99.7	0	295	2	171	268	MBX6334820.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	294	149	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
29264138	29264138	PRJNA795663_S_NODE_2429_length_363_cov_2.374233_g2324_i0	PRJNA795663	2429	363	2.374233	8.61846579	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94.4	1.26e-19	NR	MBX6334148.1	2026720	g2324	i0	72.6	0.512396694214876	62	17	51.2	0	187	2	1450	1511	MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	186	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30338634	30338634	PRJNA795663_S_NODE_12012_length_179_cov_2.176056_g11907_i0	PRJNA795663	12012	179	2.176056	3.89514024	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.6	1.09e-18	NR	MBX6334820.1	2026720	g11907	i0	69.5	1.9608938547486	59	18	98.9	0	1	177	266	324	MBX6334820.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	351	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
31697305	31697305	PRJNA795663_S_NODE_2797_length_341_cov_2.243421_g2692_i0	PRJNA795663	2797	341	2.243421	7.65006561	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	115	3.66e-27	NR	MBX6334148.1	2026720	g2692	i0	56.1	1.00293255131965	114	47	99.4	2	340	2	1035	1146	MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	342	115	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);;