contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB9859" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 999006 | 999006 | PRJEB9859_P_NODE_1541_length_348_cov_2.485893_g1506_i0 | PRJEB9859 | 1541 | 348 | 2.485893 | 8.65090764 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 122 | 2.1399999999999998e-32 | NR | MDD5769591.1 | 2044595 | g1506 | i0 | 84 | 0.646551724137931 | 75 | 12 | 64.7 | 0 | 239 | 15 | 87 | 161 | MDD5769591.1 50S ribosomal protein L4 [Candidatus Altimarinota bacterium] | diamond | 225 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 1419626 | 1419626 | PRJEB9859_P_NODE_2822_length_288_cov_1.289575_g2787_i0 | PRJEB9859 | 2822 | 288 | 1.289575 | 3.713976 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 136 | 1.2e-35 | NR | MBW7954407.1 | 2044595 | g2787 | i0 | 68.4 | 7.86458333333333 | 95 | 30 | 99 | 0 | 2 | 286 | 171 | 265 | MBW7954407.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 2265 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 1419654 | 1419654 | PRJEB9859_P_NODE_422_length_509_cov_3.745833_g398_i0 | PRJEB9859 | 422 | 509 | 3.745833 | 19.06628997 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 273 | 1.3899999999999999e-89 | NR | MDD5769593.1 | 2044595 | g398 | i0 | 89.8 | 0.866404715127701 | 147 | 15 | 86.6 | 0 | 5 | 445 | 135 | 281 | MDD5769593.1 50S ribosomal protein L2 [Candidatus Altimarinota bacterium] | diamond | 441 | 273 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 15447628 | 15447628 | PRJEB9859_P_NODE_2073_length_316_cov_2.742160_g2038_i0 | PRJEB9859 | 2073 | 316 | 2.74216 | 8.6652256 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 138 | 8.48e-36 | NR | NUJ97920.1 | 2044595 | g2038 | i0 | 76.6 | 3.56012658227848 | 94 | 22 | 89.2 | 0 | 3 | 284 | 321 | 414 | NUJ97920.1 chaperonin GroEL [Candidatus Altimarinota bacterium] | diamond | 1125 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 16721777 | 16721777 | PRJEB9859_P_NODE_2954_length_283_cov_2.358268_g2919_i0 | PRJEB9859 | 2954 | 283 | 2.358268 | 6.67389844 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 164 | 1.26e-45 | NR | MDD5769354.1 | 2044595 | g2919 | i0 | 89.4 | 2.00353356890459 | 94 | 10 | 99.6 | 0 | 283 | 2 | 322 | 415 | MDD5769354.1 translational GTPase TypA [Candidatus Altimarinota bacterium] | diamond | 567 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 25225154 | 25225154 | PRJEB9859_P_NODE_740_length_428_cov_1.433584_g706_i0 | PRJEB9859 | 740 | 428 | 1.433584 | 6.13573952 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 210 | 8.19e-63 | NR | MDD4151041.1 | 2044595 | g706 | i0 | 88.2 | 0.89018691588785 | 127 | 15 | 89 | 0 | 388 | 8 | 362 | 488 | MDD4151041.1 F0F1 ATP synthase subunit alpha [Candidatus Altimarinota bacterium] | diamond | 381 | 210 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26654194 | 26654194 | PRJEB9859_P_NODE_21_length_1075_cov_7.482792_g19_i0 | PRJEB9859 | 21 | 1075 | 7.482792 | 80.440014 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 108 | 5.48e-22 | NR | MDD5769810.1 | 2044595 | g19 | i0 | 29.4 | 0.692093023255814 | 248 | 156 | 66.4 | 6 | 45 | 758 | 101 | 339 | MDD5769810.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 744 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26844723 | 26844723 | PRJEB9859_P_NODE_4301_length_250_cov_1.968326_g4266_i0 | PRJEB9859 | 4301 | 250 | 1.968326 | 4.920815 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 51.6 | 2.81e-5 | NR | MDD5769453.1 | 2044595 | g4266 | i0 | 54.2 | 0.576 | 48 | 22 | 57.6 | 0 | 157 | 14 | 261 | 308 | MDD5769453.1 LPXTG cell wall anchor domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 144 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27065864 | 27065864 | PRJEB9859_P_NODE_2862_length_286_cov_2.295720_g2827_i0 | PRJEB9859 | 2862 | 286 | 2.29572 | 6.5657592 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 109 | 1.68e-28 | NR | MDP5039214.1 | 2044595 | g2827 | i0 | 89.2 | 1.36363636363636 | 65 | 7 | 68.2 | 0 | 2 | 196 | 66 | 130 | MDP5039214.1 30S ribosomal protein S9 [Candidatus Altimarinota bacterium] | diamond | 390 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27571467 | 27571467 | PRJEB9859_P_NODE_6004_length_236_cov_2.111111_g5969_i0 | PRJEB9859 | 6004 | 236 | 2.111111 | 4.98222196 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 95.9 | 1.8000000000000001e-22 | NR | MDD5770375.1 | 2044595 | g5969 | i0 | 68.3 | 0.800847457627119 | 63 | 20 | 80.1 | 0 | 236 | 48 | 47 | 109 | MDD5770375.1 NAD(P)H-dependent oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 189 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28708291 | 28708291 | PRJEB9859_P_NODE_1287_length_366_cov_2.608309_g1253_i0 | PRJEB9859 | 1287 | 366 | 2.608309 | 9.54641094 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 142 | 9.66e-39 | NR | MDD5770058.1 | 2044595 | g1253 | i0 | 88.5 | 0.639344262295082 | 78 | 9 | 63.9 | 0 | 133 | 366 | 1 | 78 | MDD5770058.1 FAD-dependent oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 234 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29087172 | 29087172 | PRJEB9859_P_NODE_2748_length_290_cov_1.662835_g2713_i0 | PRJEB9859 | 2748 | 290 | 1.662835 | 4.8222215 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 101 | 4.709999999999999e-23 | NR | MBW7954519.1 | 2044595 | g2713 | i0 | 63 | 1.52068965517241 | 73 | 27 | 75.5 | 0 | 20 | 238 | 205 | 277 | MBW7954519.1 DnaJ domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 441 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29181945 | 29181945 | PRJEB9859_P_NODE_4829_length_246_cov_1.732719_g4794_i0 | PRJEB9859 | 4829 | 246 | 1.732719 | 4.26248874 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 131 | 2.73e-33 | NR | NUJ97439.1 | 2044595 | g4794 | i0 | 83.8 | 1.80487804878049 | 74 | 12 | 90.2 | 0 | 1 | 222 | 434 | 507 | NUJ97439.1 lysine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 444 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29276335 | 29276335 | PRJEB9859_P_NODE_269_length_593_cov_6.108156_g254_i0 | PRJEB9859 | 269 | 593 | 6.108156 | 36.22136508 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 284 | 6.579999999999999e-92 | NR | MDD2871145.1 | 2044595 | g254 | i0 | 69.6 | 0.981450252951096 | 194 | 59 | 98.1 | 0 | 591 | 10 | 106 | 299 | MDD2871145.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 582 | 284 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29781625 | 29781625 | PRJEB9859_P_NODE_4651_length_248_cov_1.013699_g4616_i0 | PRJEB9859 | 4651 | 248 | 1.013699 | 2.51397352 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 107 | 1.35e-27 | NR | MDD3645816.1 | 2044595 | g4616 | i0 | 67.1 | 0.955645161290323 | 79 | 26 | 95.6 | 0 | 247 | 11 | 50 | 128 | MDD3645816.1 SsrA-binding protein SmpB [Candidatus Altimarinota bacterium] | diamond | 237 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29971149 | 29971149 | PRJEB9859_P_NODE_2351_length_304_cov_2.956364_g2316_i0 | PRJEB9859 | 2351 | 304 | 2.956364 | 8.98734656 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 70.1 | 3.31e-12 | NR | MCP4522908.1 | 2044595 | g2316 | i0 | 47.1 | 2.49671052631579 | 87 | 41 | 81.9 | 2 | 304 | 56 | 10 | 95 | MCP4522908.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 759 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30002921 | 30002921 | PRJEB9859_P_NODE_1091_length_383_cov_3.118644_g1057_i0 | PRJEB9859 | 1091 | 383 | 3.118644 | 11.94440652 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 86.3 | 9.36e-17 | NR | MBW7954407.1 | 2044595 | g1057 | i0 | 51.9 | 0.634464751958224 | 81 | 38 | 62.7 | 1 | 383 | 144 | 71 | 151 | MBW7954407.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 243 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30476847 | 30476847 | PRJEB9859_P_NODE_1653_length_340_cov_1.327974_g1618_i0 | PRJEB9859 | 1653 | 340 | 1.327974 | 4.5151116 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 103 | 4.07e-25 | NR | MBW7954601.1 | 2044595 | g1618 | i0 | 75.4 | 0.573529411764706 | 65 | 16 | 57.4 | 0 | 340 | 146 | 109 | 173 | MBW7954601.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 195 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31171540 | 31171540 | PRJEB9859_P_NODE_5035_length_245_cov_1.027778_g5000_i0 | PRJEB9859 | 5035 | 245 | 1.027778 | 2.5180561 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 92 | 1.7e-19 | NR | MDD5770154.1 | 2044595 | g5000 | i0 | 59 | 0.955102040816327 | 78 | 32 | 95.5 | 0 | 244 | 11 | 148 | 225 | MDD5770154.1 penicillin-binding protein 2 [Candidatus Altimarinota bacterium] | diamond | 234 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32374013 | 32374013 | PRJEB9859_P_NODE_439_length_501_cov_1.752119_g415_i0 | PRJEB9859 | 439 | 501 | 1.752119 | 8.77811619 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 291 | 3.25e-97 | NR | MDD5769987.1 | 2044595 | g415 | i0 | 83.4 | 0.976047904191617 | 163 | 27 | 97.6 | 0 | 2 | 490 | 105 | 267 | MDD5769987.1 ATP-binding protein [Candidatus Altimarinota bacterium] | diamond | 489 | 291 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32500638 | 32500638 | PRJEB9859_P_NODE_2239_length_309_cov_4.225000_g2204_i0 | PRJEB9859 | 2239 | 309 | 4.225 | 13.05525 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 52 | 4e-5 | NR | MDD5770230.1 | 2044595 | g2204 | i0 | 69.7 | 0.320388349514563 | 33 | 10 | 32 | 0 | 307 | 209 | 35 | 67 | MDD5770230.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 99 | 52 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32752657 | 32752657 | PRJEB9859_P_NODE_1100_length_382_cov_4.150142_g1066_i0 | PRJEB9859 | 1100 | 382 | 4.150142 | 15.85354244 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 204 | 4.9e-61 | NR | MDD5769682.1 | 2044595 | g1066 | i0 | 86.8 | 1.90052356020942 | 121 | 15 | 95 | 1 | 381 | 19 | 290 | 409 | MDD5769682.1 chromosomal replication initiator protein DnaA [Candidatus Altimarinota bacterium] | diamond | 726 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32878545 | 32878545 | PRJEB9859_P_NODE_3740_length_261_cov_2.961207_g3705_i0 | PRJEB9859 | 3740 | 261 | 2.961207 | 7.72875027 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 100 | 3.09e-22 | NR | MDD5770057.1 | 2044595 | g3705 | i0 | 74 | 6.19540229885058 | 77 | 20 | 88.5 | 0 | 240 | 10 | 569 | 645 | MDD5770057.1 GTP-binding protein [Candidatus Altimarinota bacterium] | diamond | 1617 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;