metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

8 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
11013	11013	PRJDB9741_P_NODE_36721_length_162_cov_2.628319_g36404_i0	PRJDB9741	36721	162	2.628319	4.25787678	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g36404	i0	100	0.172839506172839	28	0	17	0	1	28	1046402	1046429	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
12764478	12764478	PRJDB9741_P_NODE_26451_length_168_cov_1.630252_g26134_i0	PRJDB9741	26451	168	1.630252	2.73882336	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g26134	i0	97.024	8.92857142857143	168	5	100	0	1	168	93239	93072	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1500	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
14038977	14038977	PRJDB9741_P_NODE_26432_length_168_cov_1.663866_g26115_i0	PRJDB9741	26432	168	1.663866	2.79529488	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26115	i0	90.533	11.1488095238095	169	15	100	1	1	168	221451	221619	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	1873	222	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
14039171	14039171	PRJDB9741_P_NODE_8772_length_213_cov_3.329268_g8455_i0	PRJDB9741	8772	213	3.329268	7.09134084	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.15e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8455	i0	94.811	77.4084507042254	212	11	99	0	1	212	221191	221402	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	16488	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
16284451	16284451	PRJDB9741_P_NODE_2233_length_500_cov_2.847007_g1920_i0	PRJDB9741	2233	500	2.847007	14.235035	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	763	0	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g1920	i0	94.223	216.902	502	25	100	4	1	500	146310	146809	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	108451	763	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
16587970	16587970	PRJDB9741_P_NODE_8954_length_211_cov_3.845679_g8637_i0	PRJDB9741	8954	211	3.845679	8.11438269	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	368	1.6200000000000002e-97	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8637	i0	98.104	64.0947867298578	211	4	100	0	1	211	222683	222473	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	13524	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17862810	17862810	PRJDB9741_P_NODE_35735_length_163_cov_0.894737_g35418_i0	PRJDB9741	35735	163	0.894737	1.45842131	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	113	6.14e-21	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g35418	i0	83.077	0.797546012269939	130	16	79	4	23	151	440664	440540	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	130	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23934321	23934321	PRJDB9741_P_NODE_5719_length_263_cov_1.471963_g5403_i0	PRJDB9741	5719	263	1.471963	3.87126269	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	363	9.769999999999999e-96	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g5403	i0	91.76	80.7490494296578	267	13	100	6	1	263	142474	142213	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	21237	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488

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