contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA399711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25699384 | 25699384 | PRJNA399711_S_NODE_36762_length_222_cov_4.772973_g36620_i0 | PRJNA399711 | 36762 | 222 | 4.772973 | 10.59600006 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 129 | 4.62e-33 | NR | HEX7021565.1 | 2026798 | g36620 | i0 | 84.9 | 0.986486486486487 | 73 | 10 | 98.6 | 1 | 3 | 221 | 140 | 211 | HEX7021565.1 biosynthetic-type acetolactate synthase large subunit [Trueperaceae bacterium] | diamond | 219 | 129 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 25834602 | 25834602 | PRJNA399711_S_NODE_17939_length_286_cov_5.465863_g17797_i0 | PRJNA399711 | 17939 | 286 | 5.465863 | 15.63236818 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 114 | 9.36e-31 | NR | MCA9838640.1 | 2026798 | g17797 | i0 | 74.3 | 0.776223776223776 | 74 | 19 | 77.6 | 0 | 223 | 2 | 3 | 76 | MCA9838640.1 PadR family transcriptional regulator [Trueperaceae bacterium] | diamond | 222 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 25896660 | 25896660 | PRJNA399711_S_NODE_43899_length_209_cov_1.540698_g43757_i0 | PRJNA399711 | 43899 | 209 | 1.540698 | 3.22005882 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 76.6 | 6.1e-15 | NR | WP_295817398.1 | 158789 | g43757 | i0 | 54.4 | 1.95215311004785 | 68 | 31 | 97.6 | 0 | 6 | 209 | 42 | 109 | WP_295817398.1 SDR family oxidoreductase [uncultured Deinococcus sp.] | diamond | 408 | 76.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 25971965 | 25971965 | PRJNA399711_S_NODE_41812_length_212_cov_5.280000_g41670_i0 | PRJNA399711 | 41812 | 212 | 5.28 | 11.1936 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 127 | 3.4499999999999995e-32 | NR | WP_013178083.1 | 332249 | g41670 | i0 | 91.3 | 0.976415094339623 | 69 | 6 | 97.6 | 0 | 5 | 211 | 301 | 369 | WP_013178083.1 NAD-dependent DNA ligase LigA [Truepera radiovictrix] | diamond | 207 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 26242905 | 26242905 | PRJNA399711_S_NODE_16398_length_295_cov_2.914729_g16256_i0 | PRJNA399711 | 16398 | 295 | 2.914729 | 8.59845055 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 166 | 1.28e-48 | NR | WP_013179236.1 | 332249 | g16256 | i0 | 83.3 | 1.95254237288136 | 96 | 16 | 97.6 | 0 | 290 | 3 | 33 | 128 | WP_013179236.1 SDR family oxidoreductase [Truepera radiovictrix] | diamond | 576 | 166 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 26380603 | 26380603 | PRJNA399711_S_NODE_59607_length_187_cov_1.893333_g59465_i0 | PRJNA399711 | 59607 | 187 | 1.893333 | 3.54053271 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 75.5 | 5.09e-14 | NR | WP_013176772.1 | 332249 | g59465 | i0 | 90 | 0.641711229946524 | 40 | 4 | 64.2 | 0 | 2 | 121 | 607 | 646 | WP_013176772.1 acetate--CoA ligase [Truepera radiovictrix] | diamond | 120 | 75.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 26381835 | 26381835 | PRJNA399711_S_NODE_96375_length_157_cov_2.500000_g96233_i0 | PRJNA399711 | 96375 | 157 | 2.5 | 3.925 | Allomeiothermus silvanus | 52022 | Bacteria | Bacteria | 101 | 4.87e-24 | NR | WP_276955146.1 | 52022 | g96233 | i0 | 100 | 0.993630573248408 | 52 | 0 | 99.4 | 0 | 1 | 156 | 245 | 296 | WP_276955146.1 ROK family protein [Allomeiothermus silvanus] | diamond | 156 | 101 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 32917335 | 32917335 | PRJNA399711_S_NODE_101017_length_154_cov_4.649573_g100875_i0 | PRJNA399711 | 101017 | 154 | 4.649573 | 7.16034242 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 86.3 | 3.44e-18 | NR | WP_013178762.1 | 332249 | g100875 | i0 | 83.7 | 0.954545454545455 | 49 | 8 | 95.5 | 0 | 3 | 149 | 254 | 302 | WP_013178762.1 ABC transporter permease [Truepera radiovictrix] | diamond | 147 | 86.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 32917799 | 32917799 | PRJNA399711_S_NODE_69057_length_177_cov_2.764286_g68915_i0 | PRJNA399711 | 69057 | 177 | 2.764286 | 4.89278622 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 105 | 9.21e-25 | NR | WP_013176600.1 | 332249 | g68915 | i0 | 86.4 | 1 | 59 | 8 | 100 | 0 | 177 | 1 | 790 | 848 | WP_013176600.1 intein-containing adenosylcobalamin-dependent ribonucleoside-diphosphate reductase [Truepera radiovictrix] | diamond | 177 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 32934576 | 32934576 | PRJNA399711_S_NODE_13537_length_314_cov_3.620939_g13395_i0 | PRJNA399711 | 13537 | 314 | 3.620939 | 11.36974846 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 57 | 4.66e-8 | NR | HEX7023052.1 | 2026798 | g13395 | i0 | 76.5 | 0.955414012738854 | 34 | 8 | 32.5 | 0 | 211 | 312 | 1 | 34 | HEX7023052.1 FmdB family transcriptional regulator [Trueperaceae bacterium] | diamond | 300 | 57 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 32934911 | 32934911 | PRJNA399711_S_NODE_61977_length_184_cov_3.687075_g61835_i0 | PRJNA399711 | 61977 | 184 | 3.687075 | 6.784218 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 114 | 2.37e-28 | NR | WP_013179336.1 | 332249 | g61835 | i0 | 88.3 | 0.978260869565217 | 60 | 7 | 97.8 | 0 | 182 | 3 | 68 | 127 | WP_013179336.1 extracellular solute-binding protein [Truepera radiovictrix] | diamond | 180 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 32934991 | 32934991 | PRJNA399711_S_NODE_75577_length_171_cov_4.917910_g75435_i0 | PRJNA399711 | 75577 | 171 | 4.91791 | 8.4096261 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 69.7 | 7.53e-13 | NR | WP_216326522.1 | 2774531 | g75435 | i0 | 76.1 | 0.807017543859649 | 46 | 10 | 78.9 | 1 | 169 | 35 | 149 | 194 | WP_216326522.1 DUF421 domain-containing protein [Deinococcus aestuarii] | diamond | 138 | 69.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 32941272 | 32941272 | PRJNA399711_S_NODE_31849_length_233_cov_36.198980_g31707_i0 | PRJNA399711 | 31849 | 233 | 36.19898 | 84.3436234 | Bacteria | 2 | Bacteria | Bacteria | 97.8 | 6.779999999999998e-24 | NR | MEY4531883.1 | 1913990 | g31707 | i0 | 53.3 | 5.81974248927039 | 75 | 35 | 96.6 | 0 | 8 | 232 | 42 | 116 | MEY4531883.1 hypothetical protein [Deinococcota bacterium] | diamond | 1356 | 98.2 | 0.995926680244399 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 32958375 | 32958375 | PRJNA399711_S_NODE_103882_length_153_cov_1.603448_g103740_i0 | PRJNA399711 | 103882 | 153 | 1.603448 | 2.45327544 | Bacteria | 2 | Bacteria | Bacteria | 113 | 1.68e-27 | NR | 1TAQ_A | 271 | g103740 | i0 | 98 | 4.90196078431373 | 50 | 1 | 98 | 0 | 152 | 3 | 147 | 196 | 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] | diamond | 750 | 113 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 33043630 | 33043630 | PRJNA399711_S_NODE_11556_length_330_cov_5.986348_g11414_i0 | PRJNA399711 | 11556 | 330 | 5.986348 | 19.7549484 | Bacteria | 2 | Bacteria | Bacteria | 164 | 4.7199999999999997e-48 | NR | UCH26029.1 | 2026798 | g11414 | i0 | 72.4 | 2.86363636363636 | 105 | 28 | 94.5 | 1 | 328 | 17 | 165 | 269 | UCH26029.1 MAG: ABC-2 family transporter protein [Trueperaceae bacterium] | diamond | 945 | 164 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 33054383 | 33054383 | PRJNA399711_S_NODE_56013_length_191_cov_2.792208_g55871_i0 | PRJNA399711 | 56013 | 191 | 2.792208 | 5.33311728 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 61.6 | 1.53e-9 | NR | MDQ3459793.1 | 1913990 | g55871 | i0 | 79.4 | 0.534031413612565 | 34 | 7 | 53.4 | 0 | 1 | 102 | 172 | 205 | MDQ3459793.1 HD domain-containing protein [Deinococcota bacterium] | diamond | 102 | 61.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 33054397 | 33054397 | PRJNA399711_S_NODE_58293_length_188_cov_4.390728_g58151_i0 | PRJNA399711 | 58293 | 188 | 4.390728 | 8.25456864 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 125 | 1.02e-31 | NR | WP_019008563.1 | 519440 | g58151 | i0 | 96.8 | 0.98936170212766 | 62 | 2 | 98.9 | 0 | 2 | 187 | 510 | 571 | WP_019008563.1 hypothetical protein [Deinococcus aquatilis] | diamond | 186 | 125 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis | ||
| 33105442 | 33105442 | PRJNA399711_S_NODE_31278_length_235_cov_6.616162_g31136_i0 | PRJNA399711 | 31278 | 235 | 6.616162 | 15.5479807 | Truepera sp. | 2478917 | Bacteria | Bacteria | 54.7 | 4.15e-7 | NR | MBS3967573.1 | 2478917 | g31136 | i0 | 50 | 0.638297872340426 | 50 | 25 | 63.8 | 0 | 153 | 4 | 31 | 80 | MBS3967573.1 helix-turn-helix domain-containing protein [Truepera sp.] | diamond | 150 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera sp. | ||
| 33105506 | 33105506 | PRJNA399711_S_NODE_39710_length_216_cov_6.977654_g39568_i0 | PRJNA399711 | 39710 | 216 | 6.977654 | 15.07173264 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 112 | 2.84e-28 | NR | WP_013177333.1 | 332249 | g39568 | i0 | 76.1 | 0.986111111111111 | 71 | 17 | 98.6 | 0 | 214 | 2 | 40 | 110 | WP_013177333.1 transglutaminase family protein [Truepera radiovictrix] | diamond | 213 | 112 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 33105719 | 33105719 | PRJNA399711_S_NODE_74910_length_172_cov_1.977778_g74768_i0 | PRJNA399711 | 74910 | 172 | 1.977778 | 3.40177816 | Deinococcus cellulosilyticus | 401558 | Bacteria | Bacteria | 43.9 | 0.00566 | NR | WP_146882752.1 | 401558 | g74768 | i0 | 42.6 | 0.819767441860465 | 47 | 24 | 82 | 1 | 147 | 7 | 51 | 94 | WP_146882752.1 ABC transporter permease [Deinococcus cellulosilyticus] | diamond | 141 | 43.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cellulosilyticus | ||
| 33139779 | 33139779 | PRJNA399711_S_NODE_69183_length_177_cov_2.228571_g69041_i0 | PRJNA399711 | 69183 | 177 | 2.228571 | 3.94457067 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 42.7 | 0.0152 | NR | MEM7738740.1 | 1913990 | g69041 | i0 | 62.1 | 1.25423728813559 | 29 | 11 | 49.2 | 0 | 44 | 130 | 431 | 459 | MEM7738740.1 hypothetical protein [Deinococcota bacterium] | diamond | 222 | 42.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 33156341 | 33156341 | PRJNA399711_S_NODE_109088_length_150_cov_3.327434_g108946_i0 | PRJNA399711 | 109088 | 150 | 3.327434 | 4.991151 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 53.9 | 8.36e-7 | NR | CAA9568480.1 | 543023 | g108946 | i0 | 73 | 0.74 | 37 | 10 | 74 | 0 | 38 | 148 | 1 | 37 | CAA9568480.1 MAG: Uridine monophosphate kinase [uncultured Truepera sp.] | diamond | 111 | 53.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 33173793 | 33173793 | PRJNA399711_S_NODE_35728_length_224_cov_5.593583_g35586_i0 | PRJNA399711 | 35728 | 224 | 5.593583 | 12.52962592 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 134 | 1.43e-36 | NR | WP_041947334.1 | 332249 | g35586 | i0 | 93.2 | 0.991071428571429 | 74 | 5 | 99.1 | 0 | 2 | 223 | 184 | 257 | WP_041947334.1 carbohydrate ABC transporter permease [Truepera radiovictrix] | diamond | 222 | 134 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 33174008 | 33174008 | PRJNA399711_S_NODE_68520_length_177_cov_8.685714_g68378_i0 | PRJNA399711 | 68520 | 177 | 8.685714 | 15.37371378 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 41.6 | 0.0147 | NR | HPR96506.1 | 2053689 | g68378 | i0 | 51.5 | 0.559322033898305 | 33 | 15 | 55.9 | 1 | 31 | 129 | 52 | 83 | HPR96506.1 hypothetical protein [Thermotogota bacterium] | diamond | 99 | 41.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota 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);;