metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA432257" 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_species
430045	430045	PRJNA432257_S_NODE_68701_length_205_cov_1.839286_g68320_i0	PRJNA432257	68701	205	1.839286	3.7705363	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	213	7.76e-51	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g68320	i0	88.202	1.73658536585366	178	21	87	0	13	190	659097	658920	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	356	213	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
1088728	1088728	PRJNA432257_S_NODE_42561_length_245_cov_14.370192_g42180_i0	PRJNA432257	42561	245	14.370192	35.2069704	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g42180	i0	91.628	177.077551020408	215	10	87	5	1	212	150019	149810	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	43384	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 488
1704454	1704454	PRJNA432257_S_NODE_36642_length_259_cov_116.189189_g36261_i0	PRJNA432257	36642	259	116.189189	300.92999951	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	207	4.76e-49	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g36261	i0	83.71	0.853281853281853	221	35	85	1	38	258	398197	397978	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	221	207	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota				Candidatus Campbellbacteria bacterium
2979693	2979693	PRJNA432257_S_NODE_110963_length_165_cov_2.445312_g110582_i0	PRJNA432257	110963	165	2.445312	4.0347648	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g110582	i0	100	2	165	0	100	0	1	165	95263	95427	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	330	305	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
3639806	3639806	PRJNA432257_S_NODE_46583_length_237_cov_9.080000_g46202_i0	PRJNA432257	46583	237	9.08	21.5196	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	361	3.1099999999999996e-95	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g46202	i0	98.529	83.8354430379747	204	3	86	0	1	204	79799	79596	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	19869	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
5532658	5532658	PRJNA432257_S_NODE_103865_length_173_cov_1.551471_g103484_i0	PRJNA432257	103865	173	1.551471	2.68404483	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	307	2.81e-79	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g103484	i0	98.844	2.95375722543353	173	1	100	1	1	173	157396	157567	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	511	307	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
13183873	13183873	PRJNA432257_S_NODE_81631_length_191_cov_31.909091_g81250_i0	PRJNA432257	81631	191	31.909091	60.94636381	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	97.1	7.48e-16	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g81250	i0	89.474	1.6282722513089	76	8	40	0	38	113	344966	344891	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	311	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota				Candidatus Nomurabacteria bacterium
14458859	14458859	PRJNA432257_S_NODE_67592_length_206_cov_4.698225_g67211_i0	PRJNA432257	67592	206	4.698225	9.6783435	Candidatus Giovannonibacteria bacterium	2053557	Bacteria	Bacteria	119	1.75e-22	NTclustered	gi\|1950811264\|gb\|CP066687.1\|	2053557	g67211	i0	79.29	0.820388349514563	169	35	82	0	34	202	172783	172615	MAG: Candidatus Giovannonibacteria bacterium isolate NC_groundwater_467_Ag_B-0.1um_47_26 chromosome	blastn	169	119	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota				Candidatus Giovannonibacteria bacterium
14459128	14459128	PRJNA432257_S_NODE_89852_length_184_cov_7.802721_g89471_i0	PRJNA432257	89852	184	7.802721	14.35700664	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	200	5.3e-47	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g89471	i0	91.275	15.8423913043478	149	9	82	4	5	151	212902	212756	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	2915	200	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				TM7 phylum sp. oral taxon 349
14459146	14459146	PRJNA432257_S_NODE_91792_length_182_cov_362.213793_g91411_i0	PRJNA432257	91792	182	362.213793	659.22910326	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	257	3.06e-64	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g91411	i0	98.621	1.59340659340659	145	2	80	0	38	182	388502	388358	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	290	257	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
15732632	15732632	PRJNA432257_S_NODE_67793_length_206_cov_1.934911_g67412_i0	PRJNA432257	67793	206	1.934911	3.98591666	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1876390488\|gb\|CP058602.1\|	2026804	g67412	i0	100	1	206	0	100	0	1	206	655200	654995	MAG: Candidatus Woesebacteria bacterium isolate Ch104c chromosome, complete genome	blastn	206	381	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota				Candidatus Woesebacteria bacterium
15732971	15732971	PRJNA432257_S_NODE_94753_length_180_cov_27.230769_g94372_i0	PRJNA432257	94753	180	27.230769	49.0153842	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g94372	i0	98.63	1.62222222222222	146	2	81	0	1	146	536899	536754	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	292	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
19554997	19554997	PRJNA432257_S_NODE_117016_length_159_cov_2.549180_g116635_i0	PRJNA432257	117016	159	2.54918	4.0531962	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	117	4.600000000000001e-22	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g116635	i0	83.871	1.55974842767296	124	18	77	2	1	123	394741	394863	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	248	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium

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