contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_clade = "Bacteria candidate phyla"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2765693 | 2765693 | PRJNA1111077_P_NODE_38283_length_213_cov_4.871429_g38062_i0 | PRJNA1111077 | 38283 | 213 | 4.871429 | 10.37614377 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 357 | 3.55e-94 | NTclustered | gi|1958118994|gb|CP065013.1| | 2026720 | g38062 | i0 | 97.156 | 293.896713615023 | 211 | 6 | 99 | 0 | 1 | 211 | 209722 | 209512 | Candidatus Saccharibacteria bacterium isolate Ribe_18-Q3-R11-54_BATAC.540_fly chromosome, complete genome | blastn | 62600 | 357 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 4849088 | 4849088 | PRJNA1111077_P_NODE_17804_length_296_cov_3.179372_g17583_i0 | PRJNA1111077 | 17804 | 296 | 3.179372 | 9.41094112 | Bacteria | 2 | Bacteria | Bacteria | 442 | 1.4e-119 | NTclustered | gi|2874254031|emb|OY970356.1| | 179883 | g17583 | i0 | 93.581 | 243.334459459459 | 296 | 19 | 100 | 0 | 1 | 296 | 599035 | 598740 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1 | blastn | 72027 | 446 | 0.991031390134529 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 5317492 | 5317492 | PRJNA1111077_P_NODE_20985_length_283_cov_4.242857_g20764_i0 | PRJNA1111077 | 20985 | 283 | 4.242857 | 12.00728531 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 259 | 1.43e-64 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g20764 | i0 | 83.746 | 38.2120141342756 | 283 | 36 | 98 | 5 | 6 | 282 | 720162 | 720440 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 10814 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 6592561 | 6592561 | PRJNA1111077_P_NODE_15686_length_310_cov_2.822785_g15465_i0 | PRJNA1111077 | 15686 | 310 | 2.822785 | 8.7506335 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 139 | 2.16e-28 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g15465 | i0 | 92 | 35.1838709677419 | 100 | 7 | 32 | 1 | 199 | 297 | 189733 | 189832 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 10907 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 6593239 | 6593239 | PRJNA1111077_P_NODE_7266_length_430_cov_4.274510_g7045_i0 | PRJNA1111077 | 7266 | 430 | 4.27451 | 18.380393 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 645 | 1.4999999999999996e-180 | NTclustered | gi|2874253873|emb|OY969928.1| | 179883 | g7045 | i0 | 93.735 | 234.423255813953 | 431 | 26 | 100 | 1 | 1 | 430 | 597490 | 597060 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1 | blastn | 100802 | 645 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 7867444 | 7867444 | PRJNA1111077_P_NODE_23987_length_273_cov_2.925000_g23766_i0 | PRJNA1111077 | 23987 | 273 | 2.925 | 7.98525 | Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 | 2056494 | Bacteria | Bacteria | 363 | 1.02e-95 | NTclustered | gi|1340357306|gb|CP025011.1| | 2056494 | g23766 | i0 | 92.829 | 300.483516483516 | 251 | 16 | 92 | 2 | 24 | 273 | 1287858 | 1287609 | Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 chromosome, complete genome | blastn | 82032 | 363 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 | ||||||
| 10418226 | 10418226 | PRJNA1111077_P_NODE_27549_length_260_cov_4.390374_g27328_i0 | PRJNA1111077 | 27549 | 260 | 4.3903740000000004 | 11.4149724 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 453 | 5.5600000000000005e-123 | NTclustered | gi|630060131|gb|KJ191957.1| | 179883 | g27328 | i0 | 98.077 | 99.8153846153846 | 260 | 5 | 100 | 0 | 1 | 260 | 1427 | 1168 | Uncultured Candidatus Saccharibacteria bacterium clone CA62 16S ribosomal RNA gene, partial sequence | blastn | 25952 | 453 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 11693483 | 11693483 | PRJNA1111077_P_NODE_30470_length_250_cov_5.446328_g30249_i0 | PRJNA1111077 | 30470 | 250 | 5.446328 | 13.61582 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 219 | 2.11e-52 | NTclustered | gi|2546137839|emb|OY282432.1| | 3036252 | g30249 | i0 | 82.879 | 189.064 | 257 | 30 | 100 | 12 | 1 | 250 | 2262820 | 2262571 | MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 | blastn | 47266 | 219 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 16323605 | 16323605 | PRJNA1111077_P_NODE_2073_length_731_cov_3.562310_g1866_i0 | PRJNA1111077 | 2073 | 731 | 3.56231 | 26.0404861 | Candidatus Mycosynbacter | 2831665 | Bacteria | Bacteria | 1092 | 0 | NTclustered | gi|2874253873|emb|OY969928.1| | 179883 | g1866 | i0 | 93.522 | 131.708618331053 | 741 | 36 | 100 | 4 | 1 | 731 | 596997 | 597735 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1 | blastn | 96279 | 1101 | 0.991825613079019 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 21423253 | 21423253 | PRJNA1111077_P_NODE_4437_length_536_cov_8.600432_g4216_i0 | PRJNA1111077 | 4437 | 536 | 8.600432 | 46.09831552 | Bacteria | 2 | Bacteria | Bacteria | 684 | 0 | NTclustered | gi|2874253873|emb|OY969928.1| | 179883 | g4216 | i0 | 89.981 | 78.2350746268657 | 539 | 40 | 99 | 14 | 1 | 532 | 598431 | 597900 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1 | blastn | 41934 | 686 | 0.997084548104956 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 21891977 | 21891977 | PRJNA1111077_P_NODE_8058_length_411_cov_6.754438_g7837_i0 | PRJNA1111077 | 8058 | 411 | 6.754438 | 27.76074018 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 693 | 0 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g7837 | i0 | 97.08 | 315.520681265207 | 411 | 12 | 100 | 0 | 1 | 411 | 963976 | 963566 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 129679 | 693 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 24440644 | 24440644 | PRJNA1111077_P_NODE_26220_length_265_cov_2.666667_g25999_i0 | PRJNA1111077 | 26220 | 265 | 2.666667 | 7.06666755 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 311 | 3.62e-80 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g25999 | i0 | 88.015 | 265.683018867925 | 267 | 27 | 99 | 5 | 1 | 264 | 882517 | 882253 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 70406 | 311 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;