metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

23 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
24018	24018	PRJEB28062_P_NODE_131661_length_238_cov_3.018182_g129297_i0	PRJEB28062	131661	238	3.018182	7.18327316	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	279	9.01e-71	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g129297	i0	90.278	94.827731092437	216	18	91	2	23	238	219894	220106	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	22569	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
24023	24023	PRJEB28062_P_NODE_131801_length_237_cov_10.274390_g129437_i0	PRJEB28062	131801	237	10.27439	24.3503043	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	307	4.1100000000000005e-79	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g129437	i0	92.593	62.2320675105485	216	12	90	4	24	237	219894	220107	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	14749	307	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
24381	24381	PRJEB28062_P_NODE_24921_length_745_cov_6.671131_g22702_i0	PRJEB28062	24921	745	6.671131	49.69992595	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	75	1.59e-8	NTclustered	gi\|2893358430\|emb\|OZ220722.1\|	2026781	g22702	i0	72.093	0.404026845637584	301	67	40	7	31	326	1789905	1790193	MAG: Candidatus Poribacteria bacterium isolate 09e4b887-e8cc-4912-b364-6afc626817b5 genome assembly, chromosome: 1	blastn	301	75	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
24402	24402	PRJEB28062_P_NODE_25961_length_729_cov_26.733232_g23724_i0	PRJEB28062	25961	729	26.733232	194.88526128	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	538	4.589999999999999e-148	NTclustered	gi\|1842052453\|gb\|CP040010.1\|	2572087	g23724	i0	86.965	17.7777777777778	491	48	90	14	24	506	264058	264540	Candidatus Saccharibacteria bacterium oral taxon 955 strain CM003 chromosome, complete genome	blastn	12960	538	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
1300109	1300109	PRJEB28062_P_NODE_96402_length_325_cov_23.051587_g94040_i0	PRJEB28062	96402	325	23.051587	74.91765775	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	553	6.869999999999998e-153	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g94040	i0	99.669	66.8246153846154	302	1	93	0	24	325	111344	111645	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	21718	553	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
2573367	2573367	PRJEB28062_P_NODE_100223_length_314_cov_3.377593_g97860_i0	PRJEB28062	100223	314	3.377593	10.60564202	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	139	2.19e-28	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g97860	i0	96.471	24.5859872611465	85	2	27	1	105	188	109820	109736	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	7720	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
2574414	2574414	PRJEB28062_P_NODE_30743_length_664_cov_19.390863_g28453_i0	PRJEB28062	30743	664	19.390863	128.75533032	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	185	6.25e-42	NTclustered	gi\|2877945256\|gb\|CP127222.1\|	2572087	g28453	i0	74.654	31.4759036144578	434	102	65	8	108	537	617008	616579	Candidatus Saccharibacteria bacterium oral taxon 955 strain 103.1.1 chromosome, complete genome	blastn	20900	185	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
3852040	3852040	PRJEB28062_P_NODE_97644_length_322_cov_1.871486_g95282_i0	PRJEB28062	97644	322	1.871486	6.02618492	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	302	2.72e-77	NTclustered	gi\|2556891515\|gb\|CP129478.1\|	2099670	g95282	i0	84.59	984.931677018634	305	45	94	2	8	311	373412	373109	MAG: Candidatus Dojkabacteria bacterium isolate cMAG.18 chromosome, complete genome	blastn	317148	302	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
5127689	5127689	PRJEB28062_P_NODE_69085_length_415_cov_1.406433_g66724_i0	PRJEB28062	69085	415	1.406433	5.83669695	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	313	1.66e-80	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g66724	i0	80.964	2.85060240963855	394	75	95	0	1	394	1638065	1637672	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	1183	313	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
7676176	7676176	PRJEB28062_P_NODE_125047_length_250_cov_0.864407_g122683_i0	PRJEB28062	125047	250	0.864407	2.1610175	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	381	2.5399999999999996e-101	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g122683	i0	96.537	91.756	231	6	92	1	1	229	2306522	2306292	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	22939	381	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
7677569	7677569	PRJEB28062_P_NODE_69527_length_413_cov_4.800000_g67166_i0	PRJEB28062	69527	413	4.8	19.824	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	122	2.98e-23	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g67166	i0	91.954	18.6900726392252	87	7	21	0	170	256	647085	646999	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	7719	122	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
9916030	9916030	PRJEB28062_P_NODE_82008_length_370_cov_12.478114_g79646_i0	PRJEB28062	82008	370	12.478114	46.1690218	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	141	7.3e-29	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g79646	i0	100	18.5648648648649	76	0	21	0	204	279	682928	683003	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	6869	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
10228405	10228405	PRJEB28062_P_NODE_85949_length_358_cov_3.982456_g83587_i0	PRJEB28062	85949	358	3.982456	14.25719248	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	551	2.739999999999999e-152	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g83587	i0	97.239	1.82122905027933	326	8	91	1	24	349	407278	406954	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	652	551	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
11502841	11502841	PRJEB28062_P_NODE_45150_length_535_cov_24.350649_g42811_i0	PRJEB28062	45150	535	24.350649	130.27597215	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	187	1.38e-42	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g42811	i0	74.554	0.988785046728972	448	105	83	8	24	466	566384	566827	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	529	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
16600681	16600681	PRJEB28062_P_NODE_121774_length_256_cov_3.153005_g119410_i0	PRJEB28062	121774	256	3.153005	8.0716928	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	339	1.5999999999999998e-88	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g119410	i0	92.735	82.86328125	234	17	91	0	1	234	962529	962762	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	21213	339	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
17876441	17876441	PRJEB28062_P_NODE_44475_length_540_cov_10.663812_g42136_i0	PRJEB28062	44475	540	10.663812	57.5845848	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	582	1.5199999999999996e-161	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g42136	i0	87.952	1.84444444444444	498	55	91	4	26	519	739516	740012	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	996	582	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17876544	17876544	PRJEB28062_P_NODE_49415_length_508_cov_4.926437_g47067_i0	PRJEB28062	49415	508	4.926437	25.02629996	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	830	0	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g47067	i0	98.113	1.87795275590551	477	8	94	1	10	486	640332	639857	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	954	830	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
20113596	20113596	PRJEB28062_P_NODE_128956_length_243_cov_17.611765_g126592_i0	PRJEB28062	128956	243	17.611765	42.79658895	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	337	5.399999999999998e-88	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g126592	i0	94.884	124.522633744856	215	11	88	0	6	220	142417	142203	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	30259	337	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
20425558	20425558	PRJEB28062_P_NODE_46277_length_528_cov_5.261538_g43934_i0	PRJEB28062	46277	528	5.261538	27.78092064	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	508	2.56e-139	NTclustered	gi\|2556891515\|gb\|CP129478.1\|	2099670	g43934	i0	85.859	52.8541666666667	495	51	92	13	42	528	372359	371876	MAG: Candidatus Dojkabacteria bacterium isolate cMAG.18 chromosome, complete genome	blastn	27907	508	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
21702257	21702257	PRJEB28062_P_NODE_78798_length_381_cov_2.110390_g76436_i0	PRJEB28062	78798	381	2.11039	8.0405859	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	226	2.02e-54	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g76436	i0	78.613	1.12860892388451	346	70	90	4	16	358	798411	798067	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	430	226	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
21702552	21702552	PRJEB28062_P_NODE_94658_length_331_cov_1.193798_g92296_i0	PRJEB28062	94658	331	1.193798	3.95147138	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	590	5.3399999999999985e-164	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g92296	i0	99.69	1.94864048338369	323	0	98	1	9	331	68720	68399	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	645	590	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
22977720	22977720	PRJEB28062_P_NODE_90619_length_343_cov_3.359259_g88257_i0	PRJEB28062	90619	343	3.359259	11.52225837	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2518596601\|emb\|OX639973.1\|	265321	g88257	i0	100	0.247813411078717	29	0	8	0	271	299	6604343	6604371	MAG: uncultured Poribacteria bacterium isolate a51c2dcd-0bc8-4832-ac43-f95c9d639ad7 genome assembly, chromosome: 1	blastn	85	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					uncultured Poribacteria bacterium
24250239	24250239	PRJEB28062_P_NODE_25860_length_731_cov_4.448328_g23625_i0	PRJEB28062	25860	731	4.448328	32.51727768	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	1007	0	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g23625	i0	93.648	305.084815321477	677	37	92	5	31	702	667411	666736	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	223017	1007	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i

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