contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156195 | 156195 | PRJNA1011844_P_NODE_142501_length_254_cov_3.767956_g133923_i0 | PRJNA1011844 | 142501 | 254 | 3.767956 | 9.57060824 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 65.1 | 9.44e-11 | NR | HZJ10074.1 | 2026798 | g133923 | i0 | 50 | 0.755905511811024 | 64 | 32 | 75.6 | 0 | 199 | 8 | 8 | 71 | HZJ10074.1 CoA pyrophosphatase [Trueperaceae bacterium] | diamond | 192 | 65.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 2707482 | 2707482 | PRJNA1011844_P_NODE_44703_length_692_cov_3.840065_g36653_i0 | PRJNA1011844 | 44703 | 692 | 3.840065 | 26.5732498 | Bacteria | 2 | Bacteria | Bacteria | 81.3 | 9.67e-14 | NR | WP_189002407.1 | 392414 | g36653 | i0 | 31.5 | 2.92196531791908 | 168 | 95 | 72.8 | 2 | 538 | 35 | 11 | 158 | WP_189002407.1 FAD-binding oxidoreductase [Deinococcus roseus] | diamond | 2022 | 81.6 | 0.996323529411765 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 3983204 | 3983204 | PRJNA1011844_P_NODE_22784_length_1157_cov_51.684502_g16938_i1 | PRJNA1011844 | 22784 | 1157 | 51.684502 | 597.98968814 | PVC group | 1783257 | Bacteria | Bacteria | 102 | 1.36e-21 | NR | WP_367339533.1 | 1872489 | g16938 | i1 | 39.8 | 3.00518582541054 | 123 | 74 | 31.9 | 0 | 327 | 695 | 28 | 150 | WP_367339533.1 peptide deformylase [Aminivibrio sp.] | diamond | 3477 | 103 | 0.990291262135922 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 16734014 | 16734014 | PRJNA1011844_P_NODE_37014_length_814_cov_273.136302_g29509_i0 | PRJNA1011844 | 37014 | 814 | 273.136302 | 2223.32949828 | root | 1 | Root_unresolved | Root_unresolved | 105 | 1.6099999999999997e-24 | NR | WP_128080917.1 | 2335 | g29509 | i0 | 46.4 | 4.78746928746929 | 125 | 59 | 45.3 | 4 | 660 | 292 | 6 | 124 | WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga] | diamond | 3897 | 106 | 0.990566037735849 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | |||
| 16734271 | 16734271 | PRJNA1011844_P_NODE_51314_length_611_cov_29.592937_g43038_i0 | PRJNA1011844 | 51314 | 611 | 29.592937 | 180.81284507 | Bacteria | 2 | Bacteria | Bacteria | 106 | 1.3399999999999999e-25 | NR | WP_128080917.1 | 2335 | g43038 | i0 | 41.6 | 3.66284779050737 | 125 | 67 | 61.4 | 3 | 446 | 72 | 4 | 122 | WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga] | diamond | 2238 | 106 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | |||
| 20557679 | 20557679 | PRJNA1011844_P_NODE_169817_length_229_cov_2.294872_g161236_i0 | PRJNA1011844 | 169817 | 229 | 2.294872 | 5.25525688 | Deinococcus murrayi | 68910 | Bacteria | Bacteria | 132 | 8.82e-34 | NR | WP_084542979.1 | 68910 | g161236 | i0 | 86.7 | 1.93886462882096 | 75 | 10 | 98.3 | 0 | 227 | 3 | 329 | 403 | WP_084542979.1 RecQ family ATP-dependent DNA helicase [Deinococcus murrayi] | diamond | 444 | 132 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus murrayi | ||
| 26623140 | 26623140 | PRJNA1011844_P_NODE_33301_length_886_cov_8.247232_g26183_i0 | PRJNA1011844 | 33301 | 886 | 8.247232 | 73.07047552 | Deinococcus betulae | 2873312 | Bacteria | Bacteria | 142 | 1.1099999999999998e-37 | NR | WP_224573102.1 | 2873312 | g26183 | i0 | 44.4 | 0.663656884875847 | 196 | 88 | 66.4 | 5 | 844 | 257 | 2 | 176 | WP_224573102.1 YdeI/OmpD-associated family protein [Deinococcus betulae] | diamond | 588 | 142 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus betulae | ||
| 26813229 | 26813229 | PRJNA1011844_P_NODE_135781_length_262_cov_2.682540_g127203_i0 | PRJNA1011844 | 135781 | 262 | 2.68254 | 7.0282548 | Deinococcus phoenicis | 1476583 | Bacteria | Bacteria | 91.7 | 2.36e-19 | NR | WP_051517117.1 | 1476583 | g127203 | i0 | 59.7 | 0.824427480916031 | 72 | 25 | 82.4 | 1 | 228 | 13 | 242 | 309 | WP_051517117.1 recombinase family protein [Deinococcus phoenicis] | diamond | 216 | 91.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus phoenicis | ||
| 27066235 | 27066235 | PRJNA1011844_P_NODE_153482_length_246_cov_0.890173_g144902_i0 | PRJNA1011844 | 153482 | 246 | 0.890173 | 2.18982558 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 121 | 3.3199999999999996e-31 | NR | WP_291432287.1 | 47478 | g144902 | i0 | 87.3 | 0.768292682926829 | 63 | 8 | 76.8 | 0 | 195 | 7 | 145 | 207 | WP_291432287.1 metallophosphoesterase family protein [Deinococcus sp.] | diamond | 189 | 121 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 27477106 | 27477106 | PRJNA1011844_P_NODE_13523_length_1554_cov_17.315327_g9799_i0 | PRJNA1011844 | 13523 | 1554 | 17.315327 | 269.08018158 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 67 | 6.05e-8 | NR | MBQ7578640.1 | 2053624 | g9799 | i0 | 23.1 | 1.18725868725869 | 294 | 208 | 55.4 | 5 | 127 | 987 | 34 | 316 | MBQ7578640.1 PQQ-binding-like beta-propeller repeat protein [Synergistaceae bacterium] | diamond | 1845 | 67 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 27761691 | 27761691 | PRJNA1011844_P_NODE_73584_length_432_cov_12.740947_g65094_i0 | PRJNA1011844 | 73584 | 432 | 12.740947 | 55.04089104 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 60.8 | 1.29e-7 | NR | NPB03030.1 | 2053689 | g65094 | i0 | 49.1 | 0.395833333333333 | 57 | 29 | 39.6 | 0 | 421 | 251 | 518 | 574 | NPB03030.1 ankyrin repeat domain-containing protein [Thermotogota bacterium] | diamond | 171 | 60.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 28519279 | 28519279 | PRJNA1011844_P_NODE_46887_length_663_cov_7.832203_g38725_i0 | PRJNA1011844 | 46887 | 663 | 7.832203 | 51.92750589 | Deinococcus hopiensis | 309885 | Bacteria | Bacteria | 81.6 | 2.95e-16 | NR | WP_084047938.1 | 309885 | g38725 | i0 | 52.6 | 0.705882352941177 | 78 | 36 | 35.3 | 1 | 309 | 542 | 15 | 91 | WP_084047938.1 30S ribosomal protein S15 [Deinococcus hopiensis] | diamond | 468 | 81.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus hopiensis | ||
| 28669422 | 28669422 | PRJNA1011844_P_NODE_124487_length_277_cov_1.725490_g115910_i0 | PRJNA1011844 | 124487 | 277 | 1.72549 | 4.7796073 | Bacteria | 2 | Bacteria | Bacteria | 185 | 8.210000000000001e-59 | NR | WP_164973606.1 | 1211322 | g115910 | i0 | 97.8 | 2.89169675090253 | 89 | 2 | 96.4 | 0 | 8 | 274 | 16 | 104 | WP_164973606.1 tryptophan 7-halogenase, partial [Deinococcus metallilatus] | diamond | 801 | 185 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus metallilatus | ||
| 28708710 | 28708710 | PRJNA1011844_P_NODE_152187_length_247_cov_0.885057_g143608_i0 | PRJNA1011844 | 152187 | 247 | 0.885057 | 2.18609079 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 53.5 | 5.95e-6 | NR | MDQ3398419.1 | 1913990 | g143608 | i0 | 36.7 | 0.959514170040486 | 79 | 48 | 93.5 | 1 | 6 | 236 | 183 | 261 | MDQ3398419.1 diguanylate cyclase [Deinococcota bacterium] | diamond | 237 | 53.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 29403262 | 29403262 | PRJNA1011844_P_NODE_7049_length_2077_cov_17.880240_g1394_i3 | PRJNA1011844 | 7049 | 2077 | 17.88024 | 371.3725848 | Deinococcus altitudinis | 468914 | Bacteria | Bacteria | 65.5 | 8.83e-7 | NR | WP_407569595.1 | 468914 | g1394 | i3 | 29.3 | 0.756860857005296 | 242 | 167 | 34.5 | 3 | 981 | 1697 | 29 | 269 | WP_407569595.1 tetratricopeptide repeat protein [Deinococcus altitudinis] | diamond | 1572 | 65.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus altitudinis | ||
| 29403289 | 29403289 | PRJNA1011844_P_NODE_93869_length_346_cov_1.384615_g85308_i0 | PRJNA1011844 | 93869 | 346 | 1.384615 | 4.7907679 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 134 | 5.43e-36 | NR | WP_297561565.1 | 1955249 | g85308 | i0 | 83.8 | 1.36994219653179 | 80 | 13 | 69.4 | 0 | 5 | 244 | 211 | 290 | WP_297561565.1 toprim domain-containing protein [Meiothermus sp.] | diamond | 474 | 134 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 29687036 | 29687036 | PRJNA1011844_P_NODE_2130_length_3225_cov_21.680203_g1394_i0 | PRJNA1011844 | 2130 | 3225 | 21.680203 | 699.18654675 | Deinococcus altitudinis | 468914 | Bacteria | Bacteria | 65.5 | 1.68e-6 | NR | WP_407569595.1 | 468914 | g1394 | i0 | 29.3 | 0.487441860465116 | 242 | 167 | 22.2 | 3 | 2230 | 2946 | 29 | 269 | WP_407569595.1 tetratricopeptide repeat protein [Deinococcus altitudinis] | diamond | 1572 | 65.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus altitudinis | ||
| 29845220 | 29845220 | PRJNA1011844_P_NODE_2131_length_3225_cov_21.669734_g1394_i1 | PRJNA1011844 | 2131 | 3225 | 21.669734 | 698.8489215 | Deinococcus altitudinis | 468914 | Bacteria | Bacteria | 65.5 | 1.68e-6 | NR | WP_407569595.1 | 468914 | g1394 | i1 | 29.3 | 0.487441860465116 | 242 | 167 | 22.2 | 3 | 996 | 280 | 29 | 269 | WP_407569595.1 tetratricopeptide repeat protein [Deinococcus altitudinis] | diamond | 1572 | 65.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus altitudinis | ||
| 29876895 | 29876895 | PRJNA1011844_P_NODE_135691_length_262_cov_3.306878_g127113_i0 | PRJNA1011844 | 135691 | 262 | 3.306878 | 8.66402036 | Deinococcus marmoris | 249408 | Bacteria | Bacteria | 42.7 | 0.0431 | NR | WP_029482847.1 | 249408 | g127113 | i0 | 34.3 | 0.801526717557252 | 70 | 45 | 80.2 | 1 | 258 | 49 | 1 | 69 | WP_029482847.1 M12 family metallopeptidase [Deinococcus marmoris] | diamond | 210 | 42.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus marmoris | ||
| 30160885 | 30160885 | PRJNA1011844_P_NODE_147572_length_250_cov_0.870056_g138993_i0 | PRJNA1011844 | 147572 | 250 | 0.870056 | 2.17514 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 125 | 9.3e-32 | NR | WP_278912112.1 | 980427 | g138993 | i0 | 100 | 0.708 | 59 | 0 | 70.8 | 0 | 185 | 9 | 216 | 274 | WP_278912112.1 terminase large subunit domain-containing protein [Deinococcus wulumuqiensis] | diamond | 177 | 125 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 30192723 | 30192723 | PRJNA1011844_P_NODE_5832_length_2240_cov_18.191970_g1394_i2 | PRJNA1011844 | 5832 | 2240 | 18.19197 | 407.500128 | Deinococcus altitudinis | 468914 | Bacteria | Bacteria | 65.5 | 9.97e-7 | NR | WP_407569595.1 | 468914 | g1394 | i2 | 29.3 | 0.701785714285714 | 242 | 167 | 32 | 3 | 996 | 280 | 29 | 269 | WP_407569595.1 tetratricopeptide repeat protein [Deinococcus altitudinis] | diamond | 1572 | 65.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus altitudinis | ||
| 31069923 | 31069923 | PRJNA1011844_P_NODE_131575_length_267_cov_5.417526_g122997_i0 | PRJNA1011844 | 131575 | 267 | 5.417526 | 14.46479442 | Bacteria | 2 | Bacteria | Bacteria | 57.8 | 2.72e-8 | NR | TYB95644.1 | 1955248 | g122997 | i0 | 45.6 | 2.06741573033708 | 57 | 30 | 64 | 1 | 12 | 182 | 67 | 122 | TYB95644.1 MAG: glycine cleavage system protein GcvH [Kosmotoga sp.] | diamond | 552 | 58.2 | 0.993127147766323 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Kosmotoga | Kosmotoga sp. | ||
| 31330244 | 31330244 | PRJNA1011844_P_NODE_158216_length_243_cov_0.905882_g149636_i0 | PRJNA1011844 | 158216 | 243 | 0.905882 | 2.20129326 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 48.5 | 2.5e-4 | NR | MFN4251181.1 | 47478 | g149636 | i0 | 92 | 0.308641975308642 | 25 | 2 | 30.9 | 0 | 112 | 186 | 48 | 72 | MFN4251181.1 hypothetical protein [Deinococcus sp.] | diamond | 75 | 48.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 31678111 | 31678111 | PRJNA1011844_P_NODE_150757_length_248_cov_0.880000_g142178_i0 | PRJNA1011844 | 150757 | 248 | 0.88 | 2.1824 | Jonquetella anthropi | 428712 | Bacteria | Bacteria | 146 | 1.08e-42 | NR | WP_008519523.1 | 428712 | g142178 | i0 | 97.4 | 0.919354838709677 | 76 | 2 | 91.9 | 0 | 15 | 242 | 1 | 76 | WP_008519523.1 hypothetical protein [Jonquetella anthropi] | diamond | 228 | 146 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi | ||
| 32121344 | 32121344 | PRJNA1011844_P_NODE_19798_length_1262_cov_8.572750_g14756_i0 | PRJNA1011844 | 19798 | 1262 | 8.57275 | 108.188105 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 176 | 2.45e-49 | NR | WP_092263815.1 | 856736 | g14756 | i0 | 49.7 | 2.76703645007924 | 199 | 90 | 47.3 | 4 | 698 | 102 | 3 | 191 | WP_092263815.1 GNAT family N-acetyltransferase [Deinococcus reticulitermitis] | diamond | 3492 | 176 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 32532687 | 32532687 | PRJNA1011844_P_NODE_129559_length_270_cov_1.939086_g120981_i0 | PRJNA1011844 | 129559 | 270 | 1.939086 | 5.2355322 | Marinithermus hydrothermalis | 186192 | Bacteria | Bacteria | 119 | 4.38e-29 | NR | WP_013704729.1 | 186192 | g120981 | i0 | 61.9 | 1.87777777777778 | 84 | 32 | 93.3 | 0 | 256 | 5 | 440 | 523 | WP_013704729.1 penicillin acylase family protein [Marinithermus hydrothermalis] | diamond | 507 | 119 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Marinithermus | Marinithermus hydrothermalis | ||
| 32713844 | 32713844 | PRJNA1011844_P_NODE_158600_length_243_cov_0.905882_g150020_i0 | PRJNA1011844 | 158600 | 243 | 0.905882 | 2.20129326 | Jonquetella | 428711 | Bacteria | Bacteria | 129 | 1.7e-34 | NR | WP_035786679.1 | 428712 | g150020 | i0 | 100 | 2.22222222222222 | 60 | 0 | 74.1 | 0 | 12 | 191 | 206 | 265 | WP_035786679.1 ABC transporter substrate-binding protein [Jonquetella anthropi] | diamond | 540 | 129 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi |
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);;