metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
474611	474611	PRJNA493828_P_NODE_19881_length_288_cov_1.418605_g19462_i0	PRJNA493828	19881	288	1.418605	4.0855824	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	115	3.35e-21	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g19462	i0	97.059	45.5451388888889	68	2	24	0	1	68	4744490	4744423	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	13117	115	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
474980	474980	PRJNA493828_P_NODE_44521_length_223_cov_4.973333_g44102_i0	PRJNA493828	44521	223	4.973333	11.09053259	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	311	2.9600000000000003e-80	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g44102	i0	92.593	67.5605381165919	216	16	97	0	8	223	678170	678385	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	15066	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
1106386	1106386	PRJNA493828_P_NODE_23441_length_275_cov_7.430693_g23022_i0	PRJNA493828	23441	275	7.430693	20.43440575	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g23022	i0	95.62	82.9454545454546	274	9	99	3	1	272	694966	694694	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	22810	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
5578321	5578321	PRJNA493828_P_NODE_31485_length_252_cov_1.720670_g31066_i0	PRJNA493828	31485	252	1.72067	4.3360884	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g31066	i0	92.5	85.2738095238095	240	17	95	1	9	248	599309	599547	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	21489	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6852535	6852535	PRJNA493828_P_NODE_41226_length_236_cov_3.049080_g40807_i0	PRJNA493828	41226	236	3.04908	7.1958288	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	348	2.41e-91	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g40807	i0	93.562	330.733050847458	233	15	99	0	4	236	150746	150978	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	78053	348	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
8759697	8759697	PRJNA493828_P_NODE_48227_length_198_cov_6.656000_g47808_i0	PRJNA493828	48227	198	6.656	13.17888	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	324	3.29e-84	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g47808	i0	98.895	327.166666666667	181	2	91	0	4	184	144166	144346	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	64779	324	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
8759708	8759708	PRJNA493828_P_NODE_5347_length_475_cov_6.952736_g4957_i0	PRJNA493828	5347	475	6.952736	33.025496	Bacteria	2	Bacteria	Bacteria	579	1.7099999999999994e-160	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g4957	i0	88.795	67.3873684210526	473	52	99	1	1	472	1249660	1250132	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	32009	579	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
9402398	9402398	PRJNA493828_P_NODE_10488_length_353_cov_5.235714_g10069_i0	PRJNA493828	10488	353	5.235714	18.48207042	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	226	1.86e-54	NTclustered	gi\|2314743697\|dbj\|AP026679.1\|	2099670	g10069	i0	78.841	33.1983002832861	345	65	96	5	1	339	394537	394195	MAG: Candidatus Dojkabacteria bacterium KatS3mg084 DNA, complete genome	blastn	11719	226	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
10034908	10034908	PRJNA493828_P_NODE_19408_length_289_cov_6.435185_g18989_i0	PRJNA493828	19408	289	6.435185	18.59768465	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	490	4.78e-134	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g18989	i0	97.232	137.017301038062	289	8	100	0	1	289	140124	139836	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	39598	490	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
11953395	11953395	PRJNA493828_P_NODE_26830_length_265_cov_1.463542_g26411_i0	PRJNA493828	26830	265	1.463542	3.8783863	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	372	1.64e-98	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g26411	i0	92.636	61.411320754717	258	19	97	0	5	262	799583	799840	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	16274	372	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13228729	13228729	PRJNA493828_P_NODE_4251_length_527_cov_3.792952_g3865_i0	PRJNA493828	4251	527	3.792952	19.98885704	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	832	0	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g3865	i0	96.614	76.753320683112	502	16	95	1	25	525	693970	693469	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	40449	832	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14503596	14503596	PRJNA493828_P_NODE_41052_length_237_cov_2.298780_g40633_i0	PRJNA493828	41052	237	2.29878	5.4481086	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	243	1.1800000000000001e-59	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g40633	i0	85.294	106.894514767932	238	32	100	3	1	237	125850	125615	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	25334	243	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
17052240	17052240	PRJNA493828_P_NODE_44174_length_226_cov_2.411765_g43755_i0	PRJNA493828	44174	226	2.411765	5.4505889	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	230	8.659999999999999e-56	NTclustered	gi\|2258829869\|gb\|CP060224.1\|	2053688	g43755	i0	85.022	82.0663716814159	227	32	100	2	1	226	786392	786617	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-8 chromosome	blastn	18547	230	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
17052282	17052282	PRJNA493828_P_NODE_46914_length_205_cov_5.227273_g46495_i0	PRJNA493828	46914	205	5.227273	10.71590965	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	233	5.96e-57	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g46495	i0	89.418	81.8390243902439	189	15	91	5	6	191	850728	850542	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	16777	233	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
18326578	18326578	PRJNA493828_P_NODE_45455_length_215_cov_4.809859_g45036_i0	PRJNA493828	45455	215	4.809859	10.34119685	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	329	7.82e-86	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g45036	i0	94.393	83.5162790697674	214	12	99	0	2	215	961872	961659	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	17956	329	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
23427309	23427309	PRJNA493828_P_NODE_40499_length_239_cov_2.120482_g40080_i0	PRJNA493828	40499	239	2.120482	5.06795198	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	298	2.5e-76	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g40080	i0	91.031	5.60251046025105	223	17	92	2	2	221	798406	798184	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	1339	298	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
23427347	23427347	PRJNA493828_P_NODE_43439_length_228_cov_3.187097_g43020_i0	PRJNA493828	43439	228	3.187097	7.26658116	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	326	1.08e-84	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g43020	i0	92.544	96.5087719298246	228	15	100	2	1	228	175258	175483	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	22004	326	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
23427358	23427358	PRJNA493828_P_NODE_44119_length_226_cov_2.836601_g43700_i0	PRJNA493828	44119	226	2.836601	6.41071826	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	110	1.18e-19	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g43700	i0	76.415	4.16814159292035	212	44	92	4	1	209	450589	450797	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	942	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
24058510	24058510	PRJNA493828_P_NODE_3859_length_550_cov_3.813417_g3481_i0	PRJNA493828	3859	550	3.813417	20.9737935	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	881	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g3481	i0	95.956	98.6454545454545	544	21	99	1	8	550	692525	691982	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	54255	881	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis

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