metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA591127" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA591127" 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
565102	565102	PRJNA591127_P_NODE_23641_length_177_cov_1.557143_g23472_i0	PRJNA591127	23641	177	1.557143	2.75614311	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	106	1.13e-18	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g23472	i0	77.717	24.9887005649718	184	34	100	5	1	177	626664	626481	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	4423	106	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6943172	6943172	PRJNA591127_P_NODE_1506_length_553_cov_2.416667_g1356_i0	PRJNA591127	1506	553	2.416667	13.36416851	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	773	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g1356	i0	92.21	103.101265822785	552	34	99	7	5	552	906727	906181	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	57015	773	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
8218289	8218289	PRJNA591127_P_NODE_27707_length_155_cov_2.093220_g27538_i0	PRJNA591127	27707	155	2.09322	3.244491	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	159	7.3e-35	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g27538	i0	85.161	98.5677419354839	155	23	100	0	1	155	162397	162551	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	15278	159	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
9493474	9493474	PRJNA591127_P_NODE_23668_length_177_cov_1.064286_g23499_i0	PRJNA591127	23668	177	1.064286	1.88378622	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	195	2.35e-45	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g23499	i0	87.574	522.988700564972	169	19	94	2	6	172	637822	637990	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	92569	195	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14594032	14594032	PRJNA591127_P_NODE_9812_length_235_cov_2.222222_g9644_i0	PRJNA591127	9812	235	2.222222	5.2222217	Candidatus Gottesmanbacteria bacterium	2282145	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2874253905\|emb\|OY970230.1\|	2282145	g9644	i0	89.412	36.6468085106383	85	7	36	2	151	235	753343	753425	MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1	blastn	8612	106	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota					Candidatus Gottesmanbacteria bacterium
15867639	15867639	PRJNA591127_P_NODE_11053_length_221_cov_3.603261_g10884_i0	PRJNA591127	11053	221	3.603261	7.96320681	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	309	1.05e-79	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10884	i0	91.855	402.93665158371	221	18	100	0	1	221	161401	161181	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	89049	309	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
15867751	15867751	PRJNA591127_P_NODE_22573_length_184_cov_1.428571_g22404_i0	PRJNA591127	22573	184	1.428571	2.62857064	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	117	5.49e-22	NTclustered	gi\|2874253743\|emb\|OY969586.1\|	2052149	g22404	i0	92.593	110.961956521739	81	6	44	0	103	183	2018845	2018765	MAG: Candidatus Aminicenantes bacterium isolate MFD10007.bin.c.2 genome assembly, chromosome: 1	blastn	20417	117	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
17716775	17716775	PRJNA591127_P_NODE_4214_length_353_cov_42.791139_g4046_i0	PRJNA591127	4214	353	42.791139	151.05272067	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	542	1.6199999999999999e-149	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4046	i0	94.366	253.28045325779	355	16	100	4	1	353	907040	907392	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	89408	542	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
18417033	18417033	PRJNA591127_P_NODE_5795_length_304_cov_4.033708_g5627_i0	PRJNA591127	5795	304	4.033708	12.26247232	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	507	5.03e-139	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g5627	i0	96.721	145.717105263158	305	9	100	1	1	304	511365	511669	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	44298	507	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22242298	22242298	PRJNA591127_P_NODE_7218_length_273_cov_27.292373_g7050_i0	PRJNA591127	7218	273	27.292373	74.50817829	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	435	2.13e-117	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g7050	i0	96.226	292.886446886447	265	10	97	0	4	268	451317	451053	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	79958	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1

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