metadata: contig_metadata: 6 rows where bioproject = "PRJNA495917" and tax

6 rows where bioproject = "PRJNA495917" 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
477488	477488	PRJNA495917_S_NODE_13181_length_160_cov_2.752000_g12987_i0	PRJNA495917	13181	160	2.752	4.4032	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g12987	i0	99.375	62.55	160	1	100	0	1	160	884388	884229	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	10008	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
477566	477566	PRJNA495917_S_NODE_4881_length_227_cov_2.578125_g4687_i0	PRJNA495917	4881	227	2.578125	5.85234375	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	357	3.83e-94	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g4687	i0	95.154	107.20704845815	227	9	99	2	1	226	885427	885202	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	24336	357	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
477609	477609	PRJNA495917_S_NODE_8101_length_187_cov_3.118421_g7907_i0	PRJNA495917	8101	187	3.118421	5.83144727	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	335	1.4199999999999996e-87	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g7907	i0	98.93	65.1604278074866	187	2	100	0	1	187	882674	882860	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	12185	335	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
28624666	28624666	PRJNA495917_S_NODE_2487_length_310_cov_1.934545_g2293_i0	PRJNA495917	2487	310	1.934545	5.9970895	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	135	2.11e-35	NR	MDE2097525.1	2052139	g2293	i0	63.5	1.00645161290323	104	35	99.7	2	2	310	194	295	MDE2097525.1 hypothetical protein [Patescibacteria group bacterium]	diamond	312	135	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
32147400	32147400	PRJNA495917_S_NODE_12138_length_164_cov_2.023256_g11944_i0	PRJNA495917	12138	164	2.023256	3.31813984	Bacteria	2	Bacteria	Bacteria	97.8	3.94e-22	NR	MDE2097560.1	2052139	g11944	i0	81.5	3.95121951219512	54	10	98.8	0	3	164	141	194	MDE2097560.1 hypothetical protein [Patescibacteria group bacterium]	diamond	648	97.8	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
32747628	32747628	PRJNA495917_S_NODE_14640_length_156_cov_0.991736_g14446_i0	PRJNA495917	14640	156	0.991736	1.54710816	Pseudomonadati	3379134	Bacteria	Bacteria	95.9	6.94e-22	NR	KRT70958.1	1640516	g14446	i0	86.5	3	52	7	100	0	156	1	103	154	KRT70958.1 MAG: hypothetical protein XU15_C0002G0111 [candidate division NC10 bacterium CSP1-5]	diamond	468	95.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	candidate division NC10 bacterium CSP1-5

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);;