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

12 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
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
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
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
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
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);;