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

10 rows where analysis = "blastn", bioproject = "PRJEB14803" 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
21484	21484	PRJEB14803_P_NODE_28701_length_203_cov_3.089286_g28235_i0	PRJEB14803	28701	203	3.089286	6.27125058	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	248	2.1e-61	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g28235	i0	88.725	89.0147783251231	204	22	100	1	1	203	667307	667104	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	18070	248	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
3536390	3536390	PRJEB14803_P_NODE_20703_length_253_cov_1.600917_g20237_i0	PRJEB14803	20703	253	1.600917	4.05032001	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	394	3.309999999999999e-105	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g20237	i0	95.528	74.4822134387352	246	11	97	0	7	252	124365	124610	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	18844	394	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
3536396	3536396	PRJEB14803_P_NODE_23143_length_234_cov_3.045226_g22677_i0	PRJEB14803	23143	234	3.045226	7.12582884	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g22677	i0	100	95.8632478632479	234	0	100	0	1	234	152416	152183	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	22432	433	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
6399515	6399515	PRJEB14803_P_NODE_16146_length_298_cov_2.722433_g15680_i0	PRJEB14803	16146	298	2.722433	8.11285034	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	379	1.12e-100	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g15680	i0	90.345	111.03355704698	290	26	97	2	3	291	112104	112392	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	33088	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
9913966	9913966	PRJEB14803_P_NODE_24428_length_226_cov_2.115183_g23962_i0	PRJEB14803	24428	226	2.115183	4.78031358	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	385	1.75e-102	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g23962	i0	100	160.336283185841	208	0	92	0	1	208	80225	80432	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	36236	385	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
11189136	11189136	PRJEB14803_P_NODE_15209_length_310_cov_2.032727_g14743_i0	PRJEB14803	15209	310	2.032727	6.3014537	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	497	3.0899999999999993e-136	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g14743	i0	95.779	158.574193548387	308	13	99	0	1	308	81982	81675	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	49158	497	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12775103	12775103	PRJEB14803_P_NODE_43651_length_157_cov_1.614754_g43185_i0	PRJEB14803	43651	157	1.614754	2.53516378	Candidatus Saccharibacteria bacterium UB2523	1516129	Bacteria	Bacteria	268	1.1799999999999998e-67	NTclustered	gi\|669104289\|gb\|KM067151.1\|	1516129	g43185	i0	97.468	100.292993630573	158	3	100	1	1	157	857	700	Candidatus Saccharibacteria bacterium UB2523 16S ribosomal RNA gene, partial sequence	blastn	15746	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium UB2523
14049575	14049575	PRJEB14803_P_NODE_28632_length_204_cov_1.242604_g28166_i0	PRJEB14803	28632	204	1.242604	2.53491216	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	60.2	1.06e-4	NTclustered	gi\|2518550926\|emb\|OX638322.1\|	2838779	g28166	i0	100	0.299019607843137	32	0	16	0	163	194	141491	141522	MAG: Candidatus Binatia bacterium isolate fc306077-a6e0-4751-8727-9b45b52cfb09 genome assembly, chromosome: 1	blastn	61	60.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
16288489	16288489	PRJEB14803_P_NODE_30553_length_195_cov_3.475000_g30087_i0	PRJEB14803	30553	195	3.475	6.77625	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g30087	i0	100	96.3076923076923	195	0	100	0	1	195	79648	79842	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	18780	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
25211892	25211892	PRJEB14803_P_NODE_45520_length_153_cov_2.762712_g45054_i0	PRJEB14803	45520	153	2.762712	4.22694936	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1842053267\|gb\|CP039998.1\|	713059	g45054	i0	100	69.7320261437908	153	0	100	0	1	153	146967	147119	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome	blastn	10669	283	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);;