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

16 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Candidatus Saccharimonadota"

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_genus	tax_species
924737	924737	PRJNA944406_P_NODE_59881_length_254_cov_1.403315_g58922_i0	PRJNA944406	59881	254	1.403315	3.5644201	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	191	4.68e-44	NTclustered	gi\|1958071672\|gb\|CP064992.1\|	2026720	g58922	i0	80.709	1.61417322834646	254	41	99	7	2	254	527261	527507	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BATAC.98_uni chromosome, complete genome	blastn	410	191	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
4753514	4753514	PRJNA944406_P_NODE_96464_length_244_cov_0.900585_g95505_i0	PRJNA944406	96464	244	0.900585	2.1974274	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	279	9.27e-71	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g95505	i0	87.55	55.4631147540984	249	21	99	9	1	243	598072	597828	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	13533	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
5087698	5087698	PRJNA944406_P_NODE_30404_length_281_cov_2.567308_g29445_i0	PRJNA944406	30404	281	2.567308	7.21413548	Bacteria	2	Bacteria	Bacteria	418	2.22e-112	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g29445	i0	96.8	77.2669039145907	250	8	89	0	2	251	851425	851176	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	21712	418	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
7302178	7302178	PRJNA944406_P_NODE_105646_length_242_cov_0.911243_g104687_i0	PRJNA944406	105646	242	0.911243	2.20520806	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	267	7.15e-67	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g104687	i0	86.585	55.5867768595041	246	27	100	5	1	242	597827	598070	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	13452	267	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
8577175	8577175	PRJNA944406_P_NODE_16047_length_322_cov_1.052209_g15088_i0	PRJNA944406	16047	322	1.052209	3.38811298	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	486	6.989999999999999e-133	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g15088	i0	94.586	202.33850931677	314	17	98	0	2	315	883971	884284	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	65153	486	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
13677855	13677855	PRJNA944406_P_NODE_11211_length_373_cov_1.723333_g10252_i0	PRJNA944406	11211	373	1.723333	6.42803209	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	436	8.38e-118	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g10252	i0	90.909	232.56836461126	330	22	87	7	1	326	219919	220244	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	86748	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
13677983	13677983	PRJNA944406_P_NODE_2151_length_950_cov_4.106043_g1451_i0	PRJNA944406	2151	950	4.106043	39.0074085	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	1546	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g1451	i0	96.013	396.154736842105	953	34	100	4	1	950	800025	800976	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	376347	1546	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
14952305	14952305	PRJNA944406_P_NODE_26232_length_285_cov_2.523585_g25273_i0	PRJNA944406	26232	285	2.523585	7.19221725	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	442	1.3399999999999994e-119	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g25273	i0	94.737	139.852631578947	285	13	99	2	2	285	597327	597610	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	39858	442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
16227371	16227371	PRJNA944406_P_NODE_3273_length_749_cov_2.674556_g2423_i0	PRJNA944406	3273	749	2.674556	20.03242444	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	1007	0	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g2423	i0	90.981	321.767690253672	754	59	100	9	1	749	884142	884891	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	241004	1007	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
20051194	20051194	PRJNA944406_P_NODE_43656_length_269_cov_1.540816_g42697_i0	PRJNA944406	43656	269	1.540816	4.14479504	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	309	1.32e-79	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g42697	i0	95.812	0.71003717472119	191	8	71	0	1	191	742661	742851	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	191	309	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
21326464	21326464	PRJNA944406_P_NODE_24957_length_287_cov_1.224299_g23998_i0	PRJNA944406	24957	287	1.224299	3.51373813	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	158	5.47e-34	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g23998	i0	77.407	7.8815331010453	270	57	93	4	6	273	830787	831054	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	2262	158	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
21326630	21326630	PRJNA944406_P_NODE_38297_length_274_cov_1.487562_g37338_i0	PRJNA944406	38297	274	1.487562	4.07591988	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	141	5.22e-29	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g37338	i0	90	135.06204379562	110	10	40	1	4	113	883958	883850	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	37007	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
21326855	21326855	PRJNA944406_P_NODE_57197_length_256_cov_1.683060_g56238_i0	PRJNA944406	57197	256	1.68306	4.3086336	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	130	1.05e-25	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g56238	i0	78.607	0.78515625	201	39	78	4	1	199	789378	789576	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	201	130	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
25150667	25150667	PRJNA944406_P_NODE_35220_length_277_cov_1.411765_g34261_i0	PRJNA944406	35220	277	1.411765	3.91058905	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	115	3.2e-21	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g34261	i0	100	10.5884476534296	62	0	22	0	216	277	419295	419356	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	2933	115	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
25151293	25151293	PRJNA944406_P_NODE_94380_length_244_cov_0.900585_g93421_i0	PRJNA944406	94380	244	0.900585	2.1974274	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	326	1.17e-84	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g93421	i0	90.947	135.213114754098	243	21	99	1	1	243	656417	656176	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	32992	326	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
25486053	25486053	PRJNA944406_P_NODE_44120_length_269_cov_0.882653_g43161_i0	PRJNA944406	44120	269	0.882653	2.37433657	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	399	7.639999999999999e-107	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g43161	i0	93.633	96.8810408921933	267	17	99	0	3	269	153093	153359	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	26061	399	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium oral taxon 488

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