metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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
5387923	5387923	PRJNA1137393_P_NODE_37545_length_171_cov_1.344262_g37029_i0	PRJNA1137393	37545	171	1.344262	2.29868802	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	255	1.02e-63	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g37029	i0	93.567	5.62573099415205	171	11	100	0	1	171	849915	850085	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	962	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5388013	5388013	PRJNA1137393_P_NODE_60705_length_164_cov_1.504348_g60189_i0	PRJNA1137393	60705	164	1.504348	2.46713072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g60189	i0	96.341	37.859756097561	164	6	100	0	1	164	636081	636244	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	6209	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6134925	6134925	PRJNA1137393_P_NODE_38705_length_170_cov_0.809917_g38189_i0	PRJNA1137393	38705	170	0.809917	1.3768589	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g38189	i0	95.679	61.6764705882353	162	6	95	1	1	161	694875	694714	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	10485	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
8685114	8685114	PRJNA1137393_P_NODE_12367_length_238_cov_3.079365_g11851_i0	PRJNA1137393	12367	238	3.079365	7.3288887	Bacteria	2	Bacteria	Bacteria	401	1.8399999999999994e-107	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g11851	i0	97.083	283.457983193277	240	3	100	3	1	238	800134	800371	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	67463	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
9960271	9960271	PRJNA1137393_P_NODE_8988_length_277_cov_1.592105_g8472_i0	PRJNA1137393	8988	277	1.592105	4.41013085	Bacteria	2	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g8472	i0	94.245	124.184115523466	278	14	99	2	2	277	963926	964203	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	34399	424	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
13038570	13038570	PRJNA1137393_P_NODE_72651_length_162_cov_0.920354_g72135_i0	PRJNA1137393	72651	162	0.920354	1.49097348	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	137	3.6199999999999997e-28	NTclustered	gi\|2874254063\|emb\|OY970122.1\|	2052149	g72135	i0	85.496	49.5925925925926	131	19	81	0	1	131	1387023	1387153	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.13 genome assembly, chromosome: 1	blastn	8034	137	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
14313579	14313579	PRJNA1137393_P_NODE_11012_length_250_cov_2.965174_g10496_i0	PRJNA1137393	11012	250	2.965174	7.412935	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	246	9.679999999999999e-61	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10496	i0	84.646	242.216	254	32	100	7	1	250	161936	162186	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	60554	246	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
14313631	14313631	PRJNA1137393_P_NODE_28732_length_183_cov_2.373134_g28216_i0	PRJNA1137393	28732	183	2.373134	4.34283522	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.949999999999999e-68	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g28216	i0	93.443	60.4590163934426	183	10	99	2	2	183	799953	800134	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11064	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22708900	22708900	PRJNA1137393_P_NODE_12658_length_236_cov_1.358289_g12142_i0	PRJNA1137393	12658	236	1.358289	3.20556204	Bacteria	2	Bacteria	Bacteria	387	5.11e-103	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g12142	i0	96.186	187.525423728814	236	9	100	0	1	236	850590	850825	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	44256	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23237004	23237004	PRJNA1137393_P_NODE_34159_length_175_cov_1.706349_g33643_i0	PRJNA1137393	34159	175	1.706349	2.98611075	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g33643	i0	99.419	272.811428571429	172	1	98	0	4	175	599004	598833	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	47742	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
23237165	23237165	PRJNA1137393_P_NODE_8419_length_287_cov_2.731092_g7903_i0	PRJNA1137393	8419	287	2.731092	7.83823404	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	398	2.9599999999999997e-106	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g7903	i0	91.667	274.672473867596	288	22	100	2	1	287	161101	161387	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	78831	398	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans

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