metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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
315771	315771	PRJNA1174207_P_NODE_32161_length_255_cov_3.472527_g31632_i0	PRJNA1174207	32161	255	3.472527	8.85494385	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	455	1.51e-123	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g31632	i0	98.824	218.450980392157	255	3	100	0	1	255	138767	139021	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	55705	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
3591189	3591189	PRJNA1174207_P_NODE_38343_length_245_cov_0.895349_g37814_i0	PRJNA1174207	38343	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	182	2.7e-41	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g37814	i0	85.965	4.92244897959184	171	23	70	1	1	171	125886	126055	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1206	183	0.994535519125683	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
4868650	4868650	PRJNA1174207_P_NODE_26244_length_280_cov_2.019324_g25715_i0	PRJNA1174207	26244	280	2.019324	5.6541072	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g25715	i0	98.929	108.967857142857	280	3	100	0	1	280	146809	146530	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	30511	501	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
5418901	5418901	PRJNA1174207_P_NODE_37765_length_246_cov_0.890173_g37236_i0	PRJNA1174207	37765	246	0.890173	2.18982558	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g37236	i0	100	1	246	0	100	0	1	246	66746	66501	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	246	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5418932	5418932	PRJNA1174207_P_NODE_39545_length_243_cov_1.670588_g39016_i0	PRJNA1174207	39545	243	1.670588	4.05952884	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	71.3	6.05e-8	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g39016	i0	82.558	1.90534979423868	86	10	35	5	158	241	628318	628400	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	463	71.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9243360	9243360	PRJNA1174207_P_NODE_19428_length_322_cov_1.116466_g18899_i0	PRJNA1174207	19428	322	1.116466	3.59502052	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	420	7.19e-113	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g18899	i0	90.373	137.965838509317	322	27	99	4	1	320	3738050	3737731	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	44425	420	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
11243908	11243908	PRJNA1174207_P_NODE_28549_length_270_cov_2.766497_g28020_i0	PRJNA1174207	28549	270	2.766497	7.4695419	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	451	2.09e-122	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g28020	i0	97.026	201.644444444444	269	6	99	2	1	268	146227	146494	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	54444	451	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
14344419	14344419	PRJNA1174207_P_NODE_17352_length_342_cov_3.055762_g16823_i0	PRJNA1174207	17352	342	3.055762	10.45070604	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	532	9.47e-147	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g16823	i0	94.737	66.6169590643275	342	18	100	0	1	342	111393	111734	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	22783	532	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
14344680	14344680	PRJNA1174207_P_NODE_31552_length_258_cov_1.664865_g31023_i0	PRJNA1174207	31552	258	1.664865	4.2953517	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g31023	i0	100	115.616279069767	258	0	100	0	1	258	138980	139237	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	29829	477	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14344963	14344963	PRJNA1174207_P_NODE_7412_length_593_cov_3.013462_g6891_i0	PRJNA1174207	7412	593	3.013462	17.86982966	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	1046	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g6891	i0	98.482	151.939291736931	593	9	100	0	1	593	138132	138724	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	90100	1046	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
15618151	15618151	PRJNA1174207_P_NODE_14173_length_386_cov_4.031949_g13644_i0	PRJNA1174207	14173	386	4.031949	15.56332314	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	462	1.44e-125	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g13644	i0	88.342	82.8031088082902	386	44	100	1	1	386	891915	892299	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	31962	462	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
15618562	15618562	PRJNA1174207_P_NODE_36693_length_247_cov_0.885057_g36164_i0	PRJNA1174207	36693	247	0.885057	2.18609079	Candidatus Nanosynbacter lyticus	2093824	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2516688763\|gb\|CP124549.1\|	2093824	g36164	i0	97.166	9.97165991902834	247	7	100	0	1	247	802199	802445	Candidatus Nanosynbacter lyticus strain ML1 chromosome, complete genome	blastn	2463	418	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
15618593	15618593	PRJNA1174207_P_NODE_38293_length_245_cov_0.895349_g37764_i0	PRJNA1174207	38293	245	0.895349	2.19360505	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g37764	i0	98.776	2	245	3	100	0	1	245	170638	170882	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	490	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
18167634	18167634	PRJNA1174207_P_NODE_9615_length_495_cov_2.661137_g9089_i0	PRJNA1174207	9615	495	2.661137	13.17262815	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	387	1.17e-102	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g9089	i0	81.151	106.993939393939	504	75	100	18	1	495	814917	814425	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	52962	387	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
20717287	20717287	PRJNA1174207_P_NODE_42957_length_229_cov_2.397436_g42428_i0	PRJNA1174207	42957	229	2.397436	5.49012844	Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9	1618663	Bacteria	Bacteria	307	3.95e-79	NTclustered	gi\|1118703468\|gb\|KX123381.1\|	1618663	g42428	i0	90.909	101.170305676856	231	18	100	2	1	229	2334	2105	Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9 16S ribosomal RNA gene, partial sequence	blastn	23168	307	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota					Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9
24541976	24541976	PRJNA1174207_P_NODE_8080_length_558_cov_2.600000_g7556_i0	PRJNA1174207	8080	558	2.6	14.508	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	926	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g7556	i0	96.768	82.7544802867384	557	15	99	3	1	556	137407	137961	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	46177	926	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB

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