metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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
2767141	2767141	PRJNA1111146_P_NODE_343803_length_183_cov_0.861538_g342665_i0	PRJNA1111146	343803	183	0.861538	1.57661454	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g342665	i0	97.814	1	183	4	100	0	1	183	136143	135961	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	183	316	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
4043471	4043471	PRJNA1111146_P_NODE_382824_length_180_cov_0.897638_g381686_i0	PRJNA1111146	382824	180	0.897638	1.6157484	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	213	6.62e-51	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g381686	i0	88.398	3.39444444444444	181	16	98	4	1	177	310410	310589	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	611	213	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6594007	6594007	PRJNA1111146_P_NODE_204066_length_205_cov_2.105263_g202928_i0	PRJNA1111146	204066	205	2.105263	4.31578915	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	344	2.64e-90	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g202928	i0	97.059	165.6	204	6	99	0	1	204	110552	110755	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	33948	344	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
7868835	7868835	PRJNA1111146_P_NODE_243927_length_197_cov_2.076389_g242789_i0	PRJNA1111146	243927	197	2.076389	4.09048633	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g242789	i0	89.231	0.989847715736041	195	21	99	0	1	195	3047	2853	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	195	244	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
7869265	7869265	PRJNA1111146_P_NODE_340987_length_183_cov_0.869231_g339849_i0	PRJNA1111146	340987	183	0.869231	1.59069273	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	327	2.31e-85	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g339849	i0	98.907	2	183	2	100	0	1	183	455053	455235	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	366	327	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
8675046	8675046	PRJNA1111146_P_NODE_288607_length_189_cov_1.264706_g287469_i0	PRJNA1111146	288607	189	1.264706	2.39029434	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	254	4.14e-63	NTclustered	gi\|1805661181\|gb\|CP047921.1\|	713059	g287469	i0	94.545	60.4761904761905	165	8	87	1	1	164	148798	148634	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS05P-B chromosome, complete genome	blastn	11430	254	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9144200	9144200	PRJNA1111146_P_NODE_352388_length_182_cov_0.883721_g351250_i0	PRJNA1111146	352388	182	0.883721	1.60837222	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	320	3.84e-83	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g351250	i0	98.352	1	182	3	100	0	1	182	801368	801187	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	182	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
10419234	10419234	PRJNA1111146_P_NODE_173589_length_212_cov_2.345912_g172451_i0	PRJNA1111146	173589	212	2.345912	4.97333344	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g172451	i0	100	300.216981132075	212	0	100	0	1	212	265531	265742	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	63646	392	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
10419548	10419548	PRJNA1111146_P_NODE_245029_length_197_cov_1.583333_g243891_i0	PRJNA1111146	245029	197	1.583333	3.11916601	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g243891	i0	94.416	8.81725888324873	197	11	100	0	1	197	503446	503642	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	1737	303	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
10419647	10419647	PRJNA1111146_P_NODE_270869_length_192_cov_1.633094_g269731_i0	PRJNA1111146	270869	192	1.633094	3.13554048	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	285	1.5e-72	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g269731	i0	98.16	6.95833333333333	163	3	85	0	1	163	587204	587366	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	1336	285	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
11694244	11694244	PRJNA1111146_P_NODE_121270_length_233_cov_0.950000_g120132_i0	PRJNA1111146	121270	233	0.95	2.2135	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	69.4	2.07e-7	NTclustered	gi\|2621705954\|emb\|OY764016.1\|	2026781	g120132	i0	86.567	3.58798283261803	67	4	27	4	49	111	660259	660194	MAG: Candidatus Poribacteria bacterium isolate 9fae2ea3-c9b7-404b-9456-b4c0b6541956 genome assembly, chromosome: 1	blastn	836	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
13775182	13775182	PRJNA1111146_P_NODE_331451_length_183_cov_1.738462_g330313_i0	PRJNA1111146	331451	183	1.738462	3.18138546	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	195	2.45e-45	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g330313	i0	86.188	1.97814207650273	181	24	98	1	3	182	549006	549186	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	362	195	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
14244560	14244560	PRJNA1111146_P_NODE_150972_length_220_cov_1.718563_g149834_i0	PRJNA1111146	150972	220	1.718563	3.7808386	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	324	3.7399999999999997e-84	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g149834	i0	93.182	72.5454545454545	220	15	100	0	1	220	127356	127137	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	15960	324	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
14245490	14245490	PRJNA1111146_P_NODE_357352_length_182_cov_0.875969_g356214_i0	PRJNA1111146	357352	182	0.875969	1.59426358	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	263	6.57e-66	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g356214	i0	92.818	2.98901098901099	181	13	99	0	2	182	84931	85111	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	544	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
16793514	16793514	PRJNA1111146_P_NODE_315914_length_185_cov_0.863636_g314776_i0	PRJNA1111146	315914	185	0.863636	1.5977266	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	263	6.7e-66	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g314776	i0	92.818	1.95675675675676	181	13	98	0	1	181	653364	653544	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	362	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
18873904	18873904	PRJNA1111146_P_NODE_76175_length_259_cov_2.815534_g75037_i0	PRJNA1111146	76175	259	2.815534	7.29223306	Bacteria	2	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|402243569\|gb\|JX294355.1\|	1226341	g75037	i0	100	92.3938223938224	259	0	100	0	1	259	1383	1125	SR1 bacterium oral taxon 874 clone 4Y03 16S ribosomal RNA gene, partial sequence	blastn	23930	479	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					SR1 bacterium oral taxon 874
21423821	21423821	PRJNA1111146_P_NODE_282937_length_190_cov_1.357664_g281799_i0	PRJNA1111146	282937	190	1.357664	2.5795616	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g281799	i0	97.368	11	190	5	100	0	1	190	41238	41427	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2090	324	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
23167908	23167908	PRJNA1111146_P_NODE_12059_length_450_cov_1.428212_g10930_i0	PRJNA1111146	12059	450	1.428212	6.426954	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	824	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g10930	i0	99.777	118.988888888889	449	1	99	0	1	449	111202	111650	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	53545	824	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23168529	23168529	PRJNA1111146_P_NODE_277159_length_191_cov_1.528986_g276021_i0	PRJNA1111146	277159	191	1.528986	2.92036326	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	320	4.08e-83	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g276021	i0	96.859	1	191	6	100	0	1	191	1059492	1059302	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	191	320	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
23169180	23169180	PRJNA1111146_P_NODE_417539_length_178_cov_0.912000_g416401_i0	PRJNA1111146	417539	178	0.912	1.62336	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	296	6.3e-76	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g416401	i0	96.629	8	178	6	100	0	1	178	419393	419570	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1424	296	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
23169270	23169270	PRJNA1111146_P_NODE_438299_length_177_cov_0.903226_g437161_i0	PRJNA1111146	438299	177	0.903226	1.59871002	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	283	4.87e-72	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g437161	i0	95.48	3	177	8	100	0	1	177	185630	185454	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	531	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
23974390	23974390	PRJNA1111146_P_NODE_419059_length_178_cov_0.904000_g417921_i0	PRJNA1111146	419059	178	0.904	1.60912	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g417921	i0	98.315	8	178	3	100	0	1	178	73684	73861	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1424	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae

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