metadata: contig_metadata: 15 rows where bioproject = "PRJNA326068" and tax

15 rows where bioproject = "PRJNA326068" 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
389426	389426	PRJNA326068_P_NODE_14401_length_227_cov_105.055556_g13438_i0	PRJNA326068	14401	227	105.055556	238.47611212	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	394	2.92e-105	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g13438	i0	98.23	94	226	3	99	1	2	227	852625	852401	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	21338	394	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
1664125	1664125	PRJNA326068_P_NODE_12422_length_262_cov_6.909871_g11459_i0	PRJNA326068	12422	262	6.909871	18.10386202	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	374	4.49e-99	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g11459	i0	92.453	193.553435114504	265	15	100	5	1	262	453355	453093	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	50711	374	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
3619872	3619872	PRJNA326068_P_NODE_3623_length_582_cov_60.220615_g2910_i0	PRJNA326068	3623	582	60.220615	350.4839793	Bacteria	2	Bacteria	Bacteria	918	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2910	i0	95.205	150.285223367698	584	23	100	5	1	582	852625	852045	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	87466	922	0.995661605206074	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6172078	6172078	PRJNA326068_P_NODE_19205_length_161_cov_8.053030_g18242_i0	PRJNA326068	19205	161	8.05303	12.9653783	Candidatus Southlakia	3350975	Bacteria	Bacteria	252	1.23e-62	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g18242	i0	95	81.9813664596273	160	8	99	0	1	160	451721	451562	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	13199	252	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
6767017	6767017	PRJNA326068_P_NODE_12366_length_263_cov_5.816239_g11403_i0	PRJNA326068	12366	263	5.816239	15.29670857	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	390	4.479999999999999e-104	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g11403	i0	93.536	80.8593155893536	263	16	99	1	1	262	140697	140959	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	21266	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
8721758	8721758	PRJNA326068_P_NODE_6487_length_426_cov_65.528967_g5579_i0	PRJNA326068	6487	426	65.528967	279.15339942	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	542	2e-149	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g5579	i0	94.366	106.302816901408	355	16	95	3	1	354	153421	153070	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	45285	542	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
11868013	11868013	PRJNA326068_P_NODE_12470_length_261_cov_4.301724_g11507_i0	PRJNA326068	12470	261	4.301724	11.22749964	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	346	9.749999999999999e-91	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g11507	i0	91.373	206.758620689655	255	19	97	3	8	261	849865	850117	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	53964	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
16371754	16371754	PRJNA326068_P_NODE_14813_length_222_cov_4.538860_g13850_i0	PRJNA326068	14813	222	4.53886	10.0762692	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	289	1.3799999999999998e-73	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g13850	i0	90.498	257.085585585586	221	17	99	4	3	222	451031	450814	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	57073	289	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
20195262	20195262	PRJNA326068_P_NODE_3336_length_605_cov_74.116319_g2645_i0	PRJNA326068	3336	605	74.116319	448.40372995	Bacteria	2	Bacteria	Bacteria	953	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g2645	i0	95.074	241.373553719008	609	25	100	5	1	605	799872	800479	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	146031	953	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
20195277	20195277	PRJNA326068_P_NODE_8536_length_355_cov_2.748466_g7586_i0	PRJNA326068	8536	355	2.748466	9.7570543	Bacteria	2	Bacteria	Bacteria	219	3.13e-52	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g7586	i0	95.588	15.1521126760563	136	6	100	0	67	202	884086	883951	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	5379	220	0.995454545454545	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22065870	22065870	PRJNA326068_P_NODE_1638_length_838_cov_46.529048_g1216_i0	PRJNA326068	1638	838	46.529048	389.91342224	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	568	6.769999999999999e-157	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g1216	i0	83.71	242.756563245823	620	82	73	15	227	838	799871	800479	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	203430	568	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22746070	22746070	PRJNA326068_P_NODE_10418_length_306_cov_8.935018_g9458_i0	PRJNA326068	10418	306	8.935018	27.34115508	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	381	3.2e-101	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g9458	i0	89.474	63.718954248366	304	28	99	4	4	306	696519	696219	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	19498	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
22746097	22746097	PRJNA326068_P_NODE_6898_length_409_cov_67.215789_g5974_i0	PRJNA326068	6898	409	67.215789	274.91257701	Bacteria	2	Bacteria	Bacteria	479	1.5199999999999996e-130	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g5974	i0	91.884	93.5965770171149	345	25	84	2	7	350	597046	597388	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	38281	481	0.995841995841996	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
24020966	24020966	PRJNA326068_P_NODE_10419_length_306_cov_8.054152_g9459_i0	PRJNA326068	10419	306	8.054152	24.64570512	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	486	6.599999999999999e-133	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g9459	i0	95.425	64.1013071895425	306	12	100	2	1	306	696522	696219	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	19615	486	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
24615540	24615540	PRJNA326068_P_NODE_3080_length_628_cov_86.978297_g2430_i0	PRJNA326068	3080	628	86.978297	546.22370516	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	896	0	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g2430	i0	93.677	91.0732484076433	601	34	95	3	31	628	601339	601938	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	57194	896	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium

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