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

6 rows where bioproject = "PRJEB81463" 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
20123916	20123916	PRJEB81463_P_NODE_24296_length_247_cov_0.896552_g24024_i0	PRJEB81463	24296	247	0.896552	2.21448344	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g24024	i0	99.19	2.96761133603239	247	2	100	0	1	247	574661	574907	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	733	446	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
26717314	26717314	PRJEB81463_P_NODE_27561_length_243_cov_0.917647_g27289_i0	PRJEB81463	27561	243	0.917647	2.22988221	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	129	1.18e-35	NR	HJM04322.1	2830836	g27289	i0	75	0.987654320987654	80	20	98.8	0	241	2	81	160	HJM04322.1 signal peptidase I [Candidatus Saccharimonadaceae bacterium]	diamond	240	129	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
26844656	26844656	PRJEB81463_P_NODE_27421_length_243_cov_0.917647_g27149_i0	PRJEB81463	27421	243	0.917647	2.22988221	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	142	6.43e-39	NR	MCA9343876.1	2026720	g27149	i0	81	0.975308641975309	79	15	97.5	0	242	6	304	382	MCA9343876.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	237	142	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26876364	26876364	PRJEB81463_P_NODE_24761_length_246_cov_2.676301_g24489_i0	PRJEB81463	24761	246	2.676301	6.58370046	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.5	2.97e-4	NR	MCA9324640.1	2026720	g24489	i0	45.3	0.780487804878049	64	29	74.4	3	59	241	56	116	MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	192	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27918643	27918643	PRJEB81463_P_NODE_18305_length_261_cov_1.521277_g18033_i0	PRJEB81463	18305	261	1.521277	3.97053297	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	92	2.08e-19	NR	HLA65068.1	2973664	g18033	i0	57.8	0.954022988505747	83	35	95.4	0	254	6	101	183	HLA65068.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	249	92	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30350778	30350778	PRJEB81463_P_NODE_18472_length_260_cov_1.652406_g18200_i0	PRJEB81463	18472	260	1.652406	4.2962556	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	43.9	0.0173	NR	MCA9328671.1	2026720	g18200	i0	39.2	0.588461538461538	51	31	58.8	0	72	224	126	176	MCA9328671.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	153	43.9	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);;