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

12 rows where analysis = "blastn", bioproject = "PRJDB9741" 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_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
1285092	1285092	PRJDB9741_P_NODE_1042_length_842_cov_3.702396_g802_i0	PRJDB9741	1042	842	3.702396	31.17417432	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	922	0	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g802	i0	86.518	117.897862232779	853	98	100	16	1	842	161513	162359	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	99270	922	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
2257133	2257133	PRJDB9741_P_NODE_4502_length_304_cov_4.529412_g4186_i0	PRJDB9741	4502	304	4.529412	13.76941248	Bacteria	2	Bacteria	Bacteria	496	1.09e-135	NTclustered	gi\|1118703743\|gb\|KX123656.1\|	1618923	g4186	i0	96.066	86.5921052631579	305	10	100	2	1	304	739	1042	Parcubacteria group bacterium GW2011_GWC2_40_10 16S ribosomal RNA gene, partial sequence	blastn	26324	496	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWC2_40_10
8938027	8938027	PRJDB9741_P_NODE_648_length_1099_cov_3.271429_g474_i0	PRJDB9741	648	1099	3.271429	35.95300471	Parcubacteria group bacterium GW2011_GWE1_40_20	1618946	Bacteria	Bacteria	1552	0	NTclustered	gi\|1118703522\|gb\|KX123435.1\|	1618946	g474	i0	93.84	88.8644222020018	1039	44	94	13	2	1037	1238	217	Parcubacteria group bacterium GW2011_GWE1_40_20 16S ribosomal RNA gene, partial sequence	blastn	97662	1552	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWE1_40_20
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
21687408	21687408	PRJDB9741_P_NODE_16978_length_183_cov_1.522388_g16661_i0	PRJDB9741	16978	183	1.522388	2.78597004	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	163	6.899999999999999e-36	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g16661	i0	83.243	63.8251366120219	185	23	98	6	1	180	720568	720387	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	11680	163	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
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);;