metadata: contig_metadata: 4 rows where bioproject = "PRJNA1139127", tax_clade = "Bacteria candidate phyla" and tax

4 rows where bioproject = "PRJNA1139127", 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
1559782	1559782	PRJNA1139127_P_NODE_31042_length_312_cov_8.682008_g30550_i0	PRJNA1139127	31042	312	8.682008	27.08786496	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	540	5.11e-149	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g30550	i0	100	67.3653846153846	292	0	94	0	21	312	111338	111629	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	21018	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
11763989	11763989	PRJNA1139127_P_NODE_5830_length_936_cov_3.454229_g5472_i0	PRJNA1139127	5830	936	3.454229	32.33158344	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	872	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g5472	i0	83.917	9.97863247863248	914	145	98	2	1	913	335967	336879	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	9340	872	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
16334746	16334746	PRJNA1139127_P_NODE_50013_length_227_cov_7.129870_g49520_i0	PRJNA1139127	50013	227	7.12987	16.1848049	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	381	2.2699999999999995e-101	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g49520	i0	100	187.202643171806	206	0	91	0	22	227	115255	115460	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	42495	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
27670821	27670821	PRJNA1139127_P_NODE_11564_length_619_cov_1.708791_g11097_i0	PRJNA1139127	11564	619	1.708791	10.57741629	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	256	4.8799999999999985e-81	NR	HSX07579.1	2973664	g11097	i0	74.7	1.64781906300485	170	43	82.4	0	3	512	212	381	HSX07579.1 cysteine desulfurase family protein [Candidatus Saccharimonadales bacterium]	diamond	1020	256	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;