metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
388312	388312	PRJNA316313_P_NODE_501921_length_150_cov_3.353982_g500535_i0	PRJNA316313	501921	150	3.353982	5.030973	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	198	1.48e-46	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g500535	i0	89.759	2.21333333333333	166	1	100	1	1	150	578580	578415	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	332	198	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
1068315	1068315	PRJNA316313_P_NODE_409661_length_151_cov_5.982456_g408275_i0	PRJNA316313	409661	151	5.982456	9.03350856	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	143	7.11e-30	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g408275	i0	100	10.1390728476821	77	0	100	0	1	77	2662	2586	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	1531	143	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
1662686	1662686	PRJNA316313_P_NODE_449162_length_151_cov_3.622807_g447776_i0	PRJNA316313	449162	151	3.622807	5.47043857	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	76.8	7.31e-10	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g447776	i0	95.745	0.311258278145695	47	2	31	0	26	72	105988	106034	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	47	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
2937374	2937374	PRJNA316313_P_NODE_250323_length_187_cov_2.846667_g248937_i0	PRJNA316313	250323	187	2.846667	5.32326729	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	110	9.36e-20	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g248937	i0	94.366	0.379679144385027	71	4	38	0	114	184	658601	658671	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	71	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
2937683	2937683	PRJNA316313_P_NODE_302583_length_187_cov_2.413333_g301197_i0	PRJNA316313	302583	187	2.413333	4.51293271	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	124	3.34e-24	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g301197	i0	96.053	0.786096256684492	76	3	79	0	112	187	434719	434644	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	147	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
4214582	4214582	PRJNA316313_P_NODE_334204_length_186_cov_2.879195_g332818_i0	PRJNA316313	334204	186	2.879195	5.3553027	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	141	3.299999999999999e-29	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g332818	i0	100	0.833333333333333	76	0	82	0	111	186	605746	605671	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	155	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
4215299	4215299	PRJNA316313_P_NODE_450804_length_151_cov_3.526316_g449418_i0	PRJNA316313	450804	151	3.526316	5.32473716	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	202	1.1599999999999999e-47	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g449418	i0	90.184	1.0794701986755	163	4	100	1	1	151	175453	175615	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	163	202	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
6764016	6764016	PRJNA316313_P_NODE_173306_length_187_cov_3.940000_g171920_i0	PRJNA316313	173306	187	3.94	7.3678	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	128	2.59e-25	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g171920	i0	97.333	0.401069518716578	75	2	40	0	1	75	318613	318539	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	75	128	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
8041178	8041178	PRJNA316313_P_NODE_433727_length_151_cov_4.131579_g432341_i0	PRJNA316313	433727	151	4.131579	6.23868429	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g432341	i0	100	0.185430463576159	28	0	19	0	105	132	307881	307908	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
9316310	9316310	PRJNA316313_P_NODE_501888_length_150_cov_3.353982_g500502_i0	PRJNA316313	501888	150	3.353982	5.030973	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	250	4.04e-62	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g500502	i0	96.667	5.85333333333333	150	5	100	0	1	150	345644	345793	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	878	250	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
10592122	10592122	PRJNA316313_P_NODE_60829_length_244_cov_3.434783_g59443_i0	PRJNA316313	60829	244	3.434783	8.38087052	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	106	1.67e-18	NTclustered	gi\|2874253778\|emb\|OY969762.1\|	2052149	g59443	i0	95.455	0.631147540983607	66	3	27	0	3	68	2631513	2631578	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.c.1 genome assembly, chromosome: 1	blastn	154	106	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
11864852	11864852	PRJNA316313_P_NODE_139070_length_187_cov_5.353333_g137684_i0	PRJNA316313	139070	187	5.353333	10.01073271	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	137	4.3e-28	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g137684	i0	100	0.802139037433155	74	0	80	0	1	74	540393	540320	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	150	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
13821983	13821983	PRJNA316313_P_NODE_490971_length_150_cov_4.274336_g489585_i0	PRJNA316313	490971	150	4.274336	6.411504	Pseudomonadati	3379134	Bacteria	Bacteria	121	3.3e-23	NTclustered	gi\|2621705999\|emb\|OY764061.1\|	2026781	g489585	i0	88.235	17.5666666666667	102	10	67	2	12	112	2391155	2391255	MAG: Candidatus Poribacteria bacterium isolate 89293177-375a-4259-af6b-6508537173d0 genome assembly, chromosome: 1	blastn	2635	121	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
15689755	15689755	PRJNA316313_P_NODE_303993_length_187_cov_2.400000_g302607_i0	PRJNA316313	303993	187	2.4	4.488	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g302607	i0	100	0.812834224598931	76	0	81	0	112	187	491499	491424	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	152	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
18238489	18238489	PRJNA316313_P_NODE_260735_length_187_cov_2.720000_g259349_i0	PRJNA316313	260735	187	2.72	5.0864	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874254095\|emb\|OY970178.1\|	2212470	g259349	i0	96.875	0.171122994652406	32	1	17	0	151	182	2779945	2779976	MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
18239496	18239496	PRJNA316313_P_NODE_426375_length_151_cov_4.561404_g424989_i0	PRJNA316313	426375	151	4.561404	6.88772004	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	137	3.31e-28	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g424989	i0	98.718	0.516556291390728	78	0	51	1	1	77	547760	547837	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	78	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
18919416	18919416	PRJNA316313_P_NODE_314835_length_187_cov_2.320000_g313449_i0	PRJNA316313	314835	187	2.32	4.3384	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g313449	i0	98.684	5.2192513368984	76	1	80	0	1	76	163565	163490	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	976	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
19512593	19512593	PRJNA316313_P_NODE_223096_length_187_cov_3.120000_g221710_i0	PRJNA316313	223096	187	3.12	5.8344	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	121	4.3299999999999996e-23	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g221710	i0	98.529	0.363636363636364	68	1	36	0	9	76	595263	595196	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	68	121	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
19513043	19513043	PRJNA316313_P_NODE_306936_length_187_cov_2.380000_g305550_i0	PRJNA316313	306936	187	2.38	4.4506	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g305550	i0	100	0.807486631016043	76	0	81	0	1	76	91804	91879	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	151	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23339960	23339960	PRJNA316313_P_NODE_464819_length_151_cov_3.210526_g463433_i0	PRJNA316313	464819	151	3.210526	4.84789426	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	122	9.26e-24	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g463433	i0	96	1	75	3	99	0	76	150	506438	506512	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	151	122	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
23340113	23340113	PRJNA316313_P_NODE_491799_length_150_cov_4.141593_g490413_i0	PRJNA316313	491799	150	4.141593	6.2123895	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g490413	i0	95.333	2	150	7	100	0	1	150	421537	421686	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	300	239	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1

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