metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1123309" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
2304333	2304333	PRJNA1123309_P_NODE_44102_length_260_cov_1.561497_g43722_i0	PRJNA1123309	44102	260	1.561497	4.0598922	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	396	9.5e-106	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g43722	i0	97.034	276.223076923077	236	6	90	1	26	260	80941	80706	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	71818	396	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6131972	6131972	PRJNA1123309_P_NODE_63025_length_244_cov_0.912281_g62645_i0	PRJNA1123309	63025	244	0.912281	2.22596564	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	311	3.29e-80	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g62645	i0	91.228	8.44262295081967	228	20	93	0	3	230	22140	21913	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2060	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
10481965	10481965	PRJNA1123309_P_NODE_40849_length_268_cov_2.194872_g40469_i0	PRJNA1123309	40849	268	2.194872	5.88225696	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	370	5.96e-98	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g40469	i0	92.308	18.0932835820896	260	20	97	0	9	268	704155	703896	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	4849	370	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
11757079	11757079	PRJNA1123309_P_NODE_60610_length_245_cov_0.906977_g60230_i0	PRJNA1123309	60610	245	0.906977	2.22209365	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	388	1.48e-103	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g60230	i0	95.851	8.7877551020408209	241	8	98	2	1	239	280735	280495	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2153	388	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
11757129	11757129	PRJNA1123309_P_NODE_66170_length_242_cov_0.923077_g65790_i0	PRJNA1123309	66170	242	0.923077	2.23384634	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	385	1.89e-102	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g65790	i0	96.957	0.950413223140496	230	6	95	1	12	240	556316	556087	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	230	385	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14306987	14306987	PRJNA1123309_P_NODE_19752_length_355_cov_2.400709_g19373_i0	PRJNA1123309	19752	355	2.400709	8.52251695	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	231	4.02e-56	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g19373	i0	80.122	345.850704225352	327	51	90	13	27	346	160502	160821	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	122777	231	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
19404408	19404408	PRJNA1123309_P_NODE_57316_length_247_cov_0.896552_g56936_i0	PRJNA1123309	57316	247	0.896552	2.21448344	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	436	5.279999999999999e-118	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g56936	i0	100	7.68016194331984	236	0	96	0	1	236	169906	170141	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1897	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
21954837	21954837	PRJNA1123309_P_NODE_15838_length_389_cov_2.781646_g15459_i0	PRJNA1123309	15838	389	2.781646	10.82060294	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	265	4.39e-66	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g15459	i0	79.841	183.172236503856	377	65	95	10	9	379	160823	160452	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	71254	265	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
21955277	21955277	PRJNA1123309_P_NODE_51998_length_250_cov_0.966102_g51618_i0	PRJNA1123309	51998	250	0.966102	2.415255	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	265	2.67e-66	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g51618	i0	87.234	330.752	235	26	93	4	10	241	125385	125618	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	82688	265	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_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);;