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

23 rows where analysis = "blastn", bioproject = "PRJNA529241" 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_class	tax_order	tax_family	tax_genus	tax_species
3050886	3050886	PRJNA529241_P_NODE_302243_length_173_cov_3.507353_g299921_i0	PRJNA529241	302243	173	3.507353	6.06772069	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	130	6.53e-26	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g299921	i0	97.368	0.878612716763006	76	2	88	0	98	173	753729	753654	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	152	130	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
4327277	4327277	PRJNA529241_P_NODE_376204_length_173_cov_2.617647_g373882_i0	PRJNA529241	376204	173	2.617647	4.52852931	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	113	6.5700000000000005e-21	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g373882	i0	97.015	39.4335260115607	67	2	39	0	1	67	104407	104341	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	6822	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
4327430	4327430	PRJNA529241_P_NODE_393784_length_173_cov_2.323529_g391462_i0	PRJNA529241	393784	173	2.323529	4.01970517	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	135	1.4e-27	NTclustered	gi\|2890901196\|gb\|CP128407.1\|	713059	g391462	i0	98.684	3.07514450867052	76	1	88	0	98	173	539219	539144	Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome	blastn	532	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4328306	4328306	PRJNA529241_P_NODE_486824_length_151_cov_6.087719_g484502_i0	PRJNA529241	486824	151	6.087719	9.19245569	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	135	1.19e-27	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g484502	i0	97.468	1.43708609271523	79	2	52	0	73	151	259713	259635	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	217	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
4328464	4328464	PRJNA529241_P_NODE_508164_length_151_cov_4.517544_g505842_i0	PRJNA529241	508164	151	4.517544	6.82149144	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	104	3.35e-18	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g505842	i0	92.958	2.29139072847682	71	5	47	0	5	75	977955	978025	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	346	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5603215	5603215	PRJNA529241_P_NODE_241485_length_173_cov_4.639706_g239163_i0	PRJNA529241	241485	173	4.639706	8.02669138	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	222	1.05e-53	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g239163	i0	85.795	2.03468208092486	176	22	100	1	1	173	169482	169657	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	352	222	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
5603736	5603736	PRJNA529241_P_NODE_314205_length_173_cov_3.330882_g311883_i0	PRJNA529241	314205	173	3.330882	5.76242586	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	139	1.08e-28	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g311883	i0	100	5.15028901734104	75	0	84	0	99	173	402715	402641	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	891	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
5603769	5603769	PRJNA529241_P_NODE_319045_length_173_cov_3.264706_g316723_i0	PRJNA529241	319045	173	3.264706	5.64794138	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	135	1.4e-27	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g316723	i0	98.684	0.439306358381503	76	1	44	0	1	76	446060	446135	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	76	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
6876736	6876736	PRJNA529241_P_NODE_189966_length_173_cov_7.007353_g187644_i0	PRJNA529241	189966	173	7.007353	12.12272069	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	119	1.4100000000000001e-22	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g187644	i0	94.737	5.16763005780347	76	4	44	0	98	173	692400	692475	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	894	119	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
8152723	8152723	PRJNA529241_P_NODE_279427_length_173_cov_3.852941_g277105_i0	PRJNA529241	279427	173	3.852941	6.66558793	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	135	1.4e-27	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g277105	i0	98.684	0.872832369942196	76	1	87	0	1	76	755179	755104	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	151	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
8768875	8768875	PRJNA529241_P_NODE_401287_length_172_cov_5.059259_g398965_i0	PRJNA529241	401287	172	5.059259	8.70192548	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	152	1.38e-32	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g398965	i0	80.233	5.34302325581395	172	29	100	1	1	172	539179	539345	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	919	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
11978522	11978522	PRJNA529241_P_NODE_283950_length_173_cov_3.779412_g281628_i0	PRJNA529241	283950	173	3.779412	6.53838276	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	206	1.05e-48	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g281628	i0	84.795	0.988439306358382	171	24	99	1	1	171	329989	329821	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	171	206	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
13870443	13870443	PRJNA529241_P_NODE_583271_length_150_cov_3.247788_g580949_i0	PRJNA529241	583271	150	3.247788	4.871682	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	135	1.18e-27	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g580949	i0	98.684	5.56666666666667	76	1	100	0	1	76	699406	699481	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	835	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
15801669	15801669	PRJNA529241_P_NODE_184533_length_173_cov_7.661765_g182211_i0	PRJNA529241	184533	173	7.661765	13.25485345	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	132	1.81e-26	NTclustered	gi\|2218409810\|gb\|CP089289.1\|	2899133	g182211	i0	98.649	0.84971098265896	74	1	85	0	1	74	730238	730165	Candidatus Nanosynbacter sp. HMT-352 strain TM7-072 chromosome	blastn	147	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
15804009	15804009	PRJNA529241_P_NODE_473073_length_151_cov_8.561404_g470751_i0	PRJNA529241	473073	151	8.561404	12.92772004	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g470751	i0	100	0.503311258278146	76	0	50	0	76	151	565247	565172	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	76	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
17077411	17077411	PRJNA529241_P_NODE_338454_length_173_cov_3.044118_g336132_i0	PRJNA529241	338454	173	3.044118	5.26632414	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	119	1.4100000000000001e-22	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g336132	i0	94.737	2.9364161849711	76	4	44	0	98	173	696690	696765	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	508	119	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
19626537	19626537	PRJNA529241_P_NODE_391056_length_173_cov_2.397059_g388734_i0	PRJNA529241	391056	173	2.397059	4.14691207	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	135	1.4e-27	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g388734	i0	98.684	1.75722543352601	76	1	88	0	98	173	711878	711803	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	304	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
20243108	20243108	PRJNA529241_P_NODE_67056_length_257_cov_1.577273_g64734_i0	PRJNA529241	67056	257	1.577273	4.05359161	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	433	7.15e-117	NTclustered	gi\|2890901196\|gb\|CP128407.1\|	713059	g64734	i0	97.255	81.272373540856	255	7	99	0	3	257	151028	150774	Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome	blastn	20887	433	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
21518441	21518441	PRJNA529241_P_NODE_536457_length_151_cov_3.315789_g534135_i0	PRJNA529241	536457	151	3.315789	5.00684139	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	132	1.54e-26	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g534135	i0	97.403	7.3046357615894	77	2	100	0	1	77	646392	646468	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1103	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
22792674	22792674	PRJNA529241_P_NODE_32598_length_361_cov_1.114198_g30283_i0	PRJNA529241	32598	361	1.114198	4.02225478	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	582	9.81e-162	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g30283	i0	96.359	80.7174515235457	357	7	98	6	7	361	143829	143477	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	29139	582	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
22793291	22793291	PRJNA529241_P_NODE_474518_length_151_cov_8.122807_g472196_i0	PRJNA529241	474518	151	8.122807	12.26543857	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	132	1.54e-26	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g472196	i0	97.403	46.1258278145695	77	2	100	0	1	77	713309	713233	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	6965	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
23453586	23453586	PRJNA529241_P_NODE_478659_length_151_cov_7.236842_g476337_i0	PRJNA529241	478659	151	7.236842	10.92763142	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	86.1	1.21e-12	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g476337	i0	82.979	0.622516556291391	94	16	62	0	1	94	46378	46285	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	94	86.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
24725406	24725406	PRJNA529241_P_NODE_239080_length_173_cov_4.705882_g236758_i0	PRJNA529241	239080	173	4.705882	8.14117586	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	135	1.4e-27	NTclustered	gi\|1805654977\|gb\|CP047916.1\|	2572087	g236758	i0	98.684	1.75722543352601	76	1	88	0	98	173	654056	654131	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS17P chromosome, complete genome	blastn	304	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955

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