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

10 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
1149916	1149916	PRJNA615351_P_NODE_113421_length_269_cov_1.820513_g99322_i0	PRJNA615351	113421	269	1.820513	4.89717997	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	440	4.4999999999999997e-119	NTclustered	gi\|1842053267\|gb\|CP039998.1\|	713059	g99322	i0	96.283	64.2156133828996	269	8	100	2	1	269	147119	146853	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome	blastn	17274	440	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4423009	4423009	PRJNA615351_P_NODE_106244_length_293_cov_2.174419_g92145_i0	PRJNA615351	106244	293	2.174419	6.37104767	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	470	6.33e-128	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g92145	i0	95.563	86.8907849829352	293	13	100	0	1	293	139232	138940	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	25459	470	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5699032	5699032	PRJNA615351_P_NODE_111405_length_275_cov_3.591667_g97306_i0	PRJNA615351	111405	275	3.591667	9.87708425	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	265	2.9799999999999995e-66	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g97306	i0	87.719	86.3054545454546	228	26	83	2	48	275	219935	220160	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	23734	265	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
5699228	5699228	PRJNA615351_P_NODE_169865_length_165_cov_2.800000_g155765_i0	PRJNA615351	169865	165	2.8	4.62	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2893358423\|emb\|OZ220715.1\|	2026781	g155765	i0	100	0.16969696969697	28	0	17	0	108	135	2006089	2006116	MAG: Candidatus Poribacteria bacterium isolate 2b6aad90-323b-4c4c-addb-b9b204c3c4e7 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
11353438	11353438	PRJNA615351_P_NODE_88709_length_372_cov_2.925816_g74632_i0	PRJNA615351	88709	372	2.925816	10.88403552	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	529	1.3399999999999997e-145	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g74632	i0	92.287	84.3494623655914	376	24	100	5	1	372	221584	221210	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	31378	529	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
14624327	14624327	PRJNA615351_P_NODE_100632_length_315_cov_2.178571_g86535_i0	PRJNA615351	100632	315	2.178571	6.86249865	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	494	4.08e-135	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g86535	i0	94.921	390.104761904762	315	16	100	0	1	315	110977	110663	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	122883	494	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
17173341	17173341	PRJNA615351_P_NODE_116934_length_259_cov_1.343750_g102835_i0	PRJNA615351	116934	259	1.34375	3.4803125	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	182	2.88e-41	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g102835	i0	89.041	169.6138996139	146	16	56	0	1	146	679401	679256	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	43930	182	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
17727850	17727850	PRJNA615351_P_NODE_177194_length_158_cov_2.016260_g163094_i0	PRJNA615351	177194	158	2.01626	3.1856908	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g163094	i0	95.57	119.886075949367	158	7	100	0	1	158	148142	147985	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	18942	254	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
17727893	17727893	PRJNA615351_P_NODE_46614_length_779_cov_48.459677_g35063_i0	PRJNA615351	46614	779	48.459677	377.50088383	Bacteria	2	Bacteria	Bacteria	907	0	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g35063	i0	87.706	158.278562259307	789	83	100	10	1	779	3396068	3395284	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	123299	907	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
23548426	23548426	PRJNA615351_P_NODE_70639_length_495_cov_8.269565_g56739_i0	PRJNA615351	70639	495	8.269565	40.93434675	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	525	2.369999999999999e-144	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g56739	i0	85.972	580.870707070707	499	61	100	9	1	495	2261555	2261062	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	287531	525	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia 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);;