contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5873035 | 5873035 | PRJNA788929_P_NODE_39325_length_248_cov_0.880000_g38664_i0 | PRJNA788929 | 39325 | 248 | 0.88 | 2.1824 | Deinococcus apachensis | 309886 | Bacteria | Bacteria | 142 | 3.65e-37 | NR | WP_019586137.1 | 309886 | g38664 | i0 | 82.9 | 1.98387096774194 | 82 | 14 | 99.2 | 0 | 246 | 1 | 506 | 587 | WP_019586137.1 alpha-mannosidase [Deinococcus apachensis] | diamond | 492 | 142 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus apachensis | ||
| 8422475 | 8422475 | PRJNA788929_P_NODE_27627_length_302_cov_8.659389_g26966_i0 | PRJNA788929 | 27627 | 302 | 8.659389 | 26.15135478 | Deinococcus | 1298 | Bacteria | Bacteria | 128 | 1.33e-34 | NR | WP_135230093.1 | 1298 | g26966 | i0 | 98.5 | 0.665562913907285 | 67 | 1 | 66.6 | 0 | 10 | 210 | 154 | 220 | WP_135230093.1 MULTISPECIES: DsbA family protein [Deinococcus] | diamond | 201 | 128 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 12248806 | 12248806 | PRJNA788929_P_NODE_24470_length_324_cov_27.637450_g23809_i0 | PRJNA788929 | 24470 | 324 | 27.63745 | 89.545338 | Deinococcus sp. 6GRE | 47478 | Bacteria | Bacteria | 188 | 2.41e-54 | NR | WP_230294492.1 | 2745873 | g23809 | i0 | 98.9 | 0.87037037037037 | 94 | 1 | 87 | 0 | 306 | 25 | 220 | 313 | WP_230294492.1 DUF262 domain-containing protein [Deinococcus sp. 6GRE01] | diamond | 282 | 188 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. 6GRE01 | ||
| 16072002 | 16072002 | PRJNA788929_P_NODE_39713_length_247_cov_0.885057_g39052_i0 | PRJNA788929 | 39713 | 247 | 0.885057 | 2.18609079 | Deinococcus carri | 1211323 | Bacteria | Bacteria | 134 | 1.22e-35 | NR | WP_345466943.1 | 1211323 | g39052 | i0 | 82.9 | 0.995951417004049 | 82 | 14 | 99.6 | 0 | 1 | 246 | 102 | 183 | WP_345466943.1 serine hydrolase [Deinococcus carri] | diamond | 246 | 134 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus carri | ||
| 24166064 | 24166064 | PRJNA788929_P_NODE_7019_length_715_cov_17.771028_g6388_i0 | PRJNA788929 | 7019 | 715 | 17.771028 | 127.0628502 | Deinococcus fonticola | 2528713 | Bacteria | Bacteria | 317 | 2.909999999999999e-106 | NR | WP_135228003.1 | 2528713 | g6388 | i0 | 88.2 | 0.713286713286713 | 170 | 20 | 71.3 | 0 | 697 | 188 | 76 | 245 | WP_135228003.1 PIG-L deacetylase family protein [Deinococcus fonticola] | diamond | 510 | 317 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus fonticola | ||
| 26841647 | 26841647 | PRJNA788929_P_NODE_22321_length_343_cov_22.185185_g21660_i0 | PRJNA788929 | 22321 | 343 | 22.185185 | 76.09518455 | Bacteria | 2 | Bacteria | Bacteria | 165 | 1.18e-46 | NR | WP_012694160.1 | 310783 | g21660 | i0 | 75.5 | 3.70845481049563 | 106 | 26 | 92.7 | 0 | 320 | 3 | 280 | 385 | WP_012694160.1 nucleotide sugar dehydrogenase [Deinococcus deserti] | diamond | 1272 | 166 | 0.993975903614458 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus deserti | ||
| 27148095 | 27148095 | PRJNA788929_P_NODE_38482_length_250_cov_0.870056_g37821_i0 | PRJNA788929 | 38482 | 250 | 0.870056 | 2.17514 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 99.8 | 1.96e-22 | NR | WP_119761202.1 | 2320857 | g37821 | i0 | 57.3 | 1.068 | 89 | 32 | 99.6 | 2 | 1 | 249 | 59 | 147 | WP_119761202.1 McrC family protein [Deinococcus cavernae] | diamond | 267 | 99.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 27306694 | 27306694 | PRJNA788929_P_NODE_26103_length_312_cov_13.723849_g25442_i0 | PRJNA788929 | 26103 | 312 | 13.723849 | 42.81840888 | Thermovirga sp. | 2699834 | Bacteria | Bacteria | 43.5 | 0.016 | NR | WP_296867975.1 | 2699834 | g25442 | i0 | 45.5 | 0.423076923076923 | 44 | 24 | 42.3 | 0 | 244 | 113 | 1 | 44 | WP_296867975.1 hypothetical protein [Thermovirga sp.] | diamond | 132 | 43.5 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Thermovirgaceae | Thermovirga | Thermovirga sp. | ||
| 27433183 | 27433183 | PRJNA788929_P_NODE_14703_length_441_cov_5.105978_g14044_i0 | PRJNA788929 | 14703 | 441 | 5.105978 | 22.51736298 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 236 | 9.54e-69 | NR | WP_119761417.1 | 2320857 | g14044 | i0 | 95.5 | 0.904761904761905 | 133 | 6 | 90.5 | 0 | 421 | 23 | 74 | 206 | WP_119761417.1 phage tail tape measure protein [Deinococcus cavernae] | diamond | 399 | 236 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 28096003 | 28096003 | PRJNA788929_P_NODE_44685_length_230_cov_16.617834_g44024_i0 | PRJNA788929 | 44685 | 230 | 16.617834 | 38.2210182 | Deinococcus proteolyticus | 55148 | Bacteria | Bacteria | 135 | 7.109999999999999e-37 | NR | WP_013616000.1 | 55148 | g44024 | i0 | 83.1 | 0.847826086956522 | 65 | 11 | 84.8 | 0 | 205 | 11 | 114 | 178 | WP_013616000.1 DUF2268 domain-containing protein [Deinococcus proteolyticus] | diamond | 195 | 135 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 29390677 | 29390677 | PRJNA788929_P_NODE_46409_length_221_cov_7.283784_g45748_i0 | PRJNA788929 | 46409 | 221 | 7.283784 | 16.09716264 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 49.7 | 9.92e-5 | NR | MDQ3398072.1 | 1913990 | g45748 | i0 | 49.1 | 0.746606334841629 | 55 | 28 | 74.7 | 0 | 189 | 25 | 112 | 166 | MDQ3398072.1 hypothetical protein [Deinococcota bacterium] | diamond | 165 | 49.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 29484975 | 29484975 | PRJNA788929_P_NODE_41250_length_244_cov_0.900585_g40589_i0 | PRJNA788929 | 41250 | 244 | 0.900585 | 2.1974274 | Deinococcus aerius | 200253 | Bacteria | Bacteria | 81.3 | 9.29e-16 | NR | WP_235610270.1 | 200253 | g40589 | i0 | 62.5 | 0.983606557377049 | 80 | 27 | 98.4 | 1 | 4 | 243 | 14 | 90 | WP_235610270.1 HD-GYP domain-containing protein [Deinococcus aerius] | diamond | 240 | 81.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aerius | ||
| 30053545 | 30053545 | PRJNA788929_P_NODE_33371_length_271_cov_1.186869_g32710_i0 | PRJNA788929 | 33371 | 271 | 1.186869 | 3.21641499 | Deinococcus metallilatus | 1211322 | Bacteria | Bacteria | 58.9 | 1.04e-7 | NR | WP_164973304.1 | 1211322 | g32710 | i0 | 66.7 | 0.996309963099631 | 45 | 15 | 49.8 | 0 | 192 | 58 | 399 | 443 | WP_164973304.1 PQQ-dependent sugar dehydrogenase [Deinococcus metallilatus] | diamond | 270 | 58.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus metallilatus | ||
| 30085194 | 30085194 | PRJNA788929_P_NODE_38352_length_250_cov_0.870056_g37691_i0 | PRJNA788929 | 38352 | 250 | 0.870056 | 2.17514 | Deinococcus sp. 6GRE | 47478 | Bacteria | Bacteria | 130 | 1.96e-33 | NR | WP_230294415.1 | 2745873 | g37691 | i0 | 81.9 | 2.988 | 83 | 15 | 99.6 | 0 | 1 | 249 | 399 | 481 | WP_230294415.1 hypothetical protein [Deinococcus sp. 6GRE01] | diamond | 747 | 130 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. 6GRE01 | ||
| 30906998 | 30906998 | PRJNA788929_P_NODE_38754_length_249_cov_0.875000_g38093_i0 | PRJNA788929 | 38754 | 249 | 0.875 | 2.17875 | Deinococcus apachensis | 309886 | Bacteria | Bacteria | 125 | 1.0699999999999999e-31 | NR | WP_019586757.1 | 309886 | g38093 | i0 | 84.1 | 2.96385542168675 | 82 | 13 | 98.8 | 0 | 247 | 2 | 157 | 238 | WP_019586757.1 tetratricopeptide repeat protein [Deinococcus apachensis] | diamond | 738 | 125 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus apachensis | ||
| 30938533 | 30938533 | PRJNA788929_P_NODE_40654_length_245_cov_0.895349_g39993_i0 | PRJNA788929 | 40654 | 245 | 0.895349 | 2.19360505 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 77 | 1.68e-15 | NR | WP_331823588.1 | 3118910 | g39993 | i0 | 90.2 | 0.502040816326531 | 41 | 4 | 50.2 | 0 | 122 | 244 | 1 | 41 | WP_331823588.1 vitamin K epoxide reductase family protein [Deinococcus sp. YIM 134068] | diamond | 123 | 77 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 31033446 | 31033446 | PRJNA788929_P_NODE_38455_length_250_cov_0.870056_g37794_i0 | PRJNA788929 | 38455 | 250 | 0.870056 | 2.17514 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 124 | 5.75e-33 | NR | WP_295823201.1 | 158789 | g37794 | i0 | 75.3 | 0.876 | 73 | 18 | 87.6 | 0 | 249 | 31 | 172 | 244 | WP_295823201.1 BRO family protein [uncultured Deinococcus sp.] | diamond | 219 | 124 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 31065018 | 31065018 | PRJNA788929_P_NODE_20675_length_359_cov_4.856643_g20015_i0 | PRJNA788929 | 20675 | 359 | 4.856643 | 17.43534837 | Deinococcus arcticus | 2136176 | Bacteria | Bacteria | 143 | 2.34e-38 | NR | WP_107136179.1 | 2136176 | g20015 | i0 | 96.1 | 0.643454038997215 | 77 | 3 | 64.3 | 0 | 14 | 244 | 322 | 398 | WP_107136179.1 imidazolonepropionase [Deinococcus arcticus] | diamond | 231 | 143 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus arcticus | ||
| 31412561 | 31412561 | PRJNA788929_P_NODE_42516_length_241_cov_0.916667_g41855_i0 | PRJNA788929 | 42516 | 241 | 0.916667 | 2.20916747 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 117 | 1.33e-31 | NR | WP_380080924.1 | 1298767 | g41855 | i0 | 98.4 | 0.784232365145228 | 63 | 1 | 78.4 | 0 | 1 | 189 | 84 | 146 | WP_380080924.1 type II secretion system protein [Deinococcus antarcticus] | diamond | 189 | 117 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 31580066 | 31580066 | PRJNA788929_P_NODE_35676_length_260_cov_1.668449_g35015_i0 | PRJNA788929 | 35676 | 260 | 1.668449 | 4.3379674 | Deinococcus | 1298 | Bacteria | Bacteria | 166 | 3.68e-48 | NR | WP_409743516.1 | 47478 | g35015 | i0 | 98.8 | 1.98461538461538 | 86 | 1 | 99.2 | 0 | 258 | 1 | 74 | 159 | WP_409743516.1 replication initiator protein A, partial [Deinococcus sp.] | diamond | 516 | 166 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 31665481 | 31665481 | PRJNA788929_P_NODE_22737_length_340_cov_1.134831_g22076_i0 | PRJNA788929 | 22737 | 340 | 1.134831 | 3.8584254 | Deinococcus sp. JMULE3 | 2518341 | Bacteria | Bacteria | 91.7 | 9.98e-20 | NR | WP_174367978.1 | 2518341 | g22076 | i0 | 47.7 | 0.979411764705882 | 111 | 57 | 97.9 | 1 | 337 | 5 | 91 | 200 | WP_174367978.1 hypothetical protein [Deinococcus sp. JMULE3] | diamond | 333 | 91.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. JMULE3 | ||
| 31886928 | 31886928 | PRJNA788929_P_NODE_30617_length_285_cov_1.089623_g29956_i0 | PRJNA788929 | 30617 | 285 | 1.089623 | 3.10542555 | Deinococcus malanensis | 1706855 | Bacteria | Bacteria | 89 | 3.42e-18 | NR | WP_189010448.1 | 1706855 | g29956 | i0 | 88.2 | 1.07368421052632 | 51 | 6 | 53.7 | 0 | 133 | 285 | 1 | 51 | WP_189010448.1 sensor histidine kinase [Deinococcus malanensis] | diamond | 306 | 89 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus malanensis | ||
| 32108464 | 32108464 | PRJNA788929_P_NODE_30598_length_285_cov_1.452830_g29937_i0 | PRJNA788929 | 30598 | 285 | 1.45283 | 4.1405655 | Deinococcus indicus | 223556 | Bacteria | Bacteria | 54.7 | 4.81e-7 | NR | GHG38721.1 | 223556 | g29937 | i0 | 44.4 | 0.663157894736842 | 63 | 31 | 66.3 | 1 | 28 | 216 | 58 | 116 | GHG38721.1 hypothetical protein GCM10017784_36780 [Deinococcus indicus] | diamond | 189 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus indicus | ||
| 32235360 | 32235360 | PRJNA788929_P_NODE_14738_length_440_cov_29.313351_g14079_i0 | PRJNA788929 | 14738 | 440 | 29.313351 | 128.9787444 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 158 | 3.08e-44 | NR | WP_380080433.1 | 1298767 | g14079 | i0 | 94.9 | 0.538636363636364 | 79 | 4 | 53.9 | 0 | 25 | 261 | 107 | 185 | WP_380080433.1 DsbA family protein [Deinococcus antarcticus] | diamond | 237 | 158 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus |
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);;