contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA760904" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018293 | 2018293 | PRJNA760904_P_NODE_6982_length_333_cov_0.896154_g6925_i0 | PRJNA760904 | 6982 | 333 | 0.896154 | 2.98419282 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 203 | 1.92e-64 | NR | WP_331823095.1 | 3118910 | g6925 | i0 | 90 | 0.990990990990991 | 110 | 11 | 99.1 | 0 | 2 | 331 | 67 | 176 | WP_331823095.1 TetR/AcrR family transcriptional regulator [Deinococcus sp. YIM 134068] | diamond | 330 | 203 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 16044891 | 16044891 | PRJNA760904_P_NODE_16693_length_248_cov_0.880000_g16636_i0 | PRJNA760904 | 16693 | 248 | 0.88 | 2.1824 | Deinococcus | 1298 | Bacteria | Bacteria | 133 | 6.31e-34 | NR | WP_264776210.1 | 200252 | g16636 | i0 | 90.2 | 2.9758064516129 | 82 | 8 | 99.2 | 0 | 248 | 3 | 838 | 919 | WP_264776210.1 alanine--tRNA ligase [Deinococcus aetherius] | diamond | 738 | 134 | 0.992537313432836 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 18593924 | 18593924 | PRJNA760904_P_NODE_17055_length_247_cov_0.885057_g16998_i0 | PRJNA760904 | 17055 | 247 | 0.885057 | 2.18609079 | Deinococcus arcticus | 2136176 | Bacteria | Bacteria | 127 | 1.71e-33 | NR | WP_107139617.1 | 2136176 | g16998 | i0 | 76.3 | 1.87044534412955 | 76 | 18 | 92.3 | 0 | 245 | 18 | 203 | 278 | WP_107139617.1 IS630 family transposase [Deinococcus arcticus] | diamond | 462 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus arcticus | ||
| 19056725 | 19056725 | PRJNA760904_P_NODE_16115_length_249_cov_0.875000_g16058_i0 | PRJNA760904 | 16115 | 249 | 0.875 | 2.17875 | Deinococcus hopiensis | 309885 | Bacteria | Bacteria | 77 | 3.27e-14 | NR | WP_170928356.1 | 309885 | g16058 | i0 | 64.9 | 0.686746987951807 | 57 | 20 | 68.7 | 0 | 1 | 171 | 302 | 358 | WP_170928356.1 replication initiator protein A [Deinococcus hopiensis] | diamond | 171 | 77 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus hopiensis | ||
| 20331385 | 20331385 | PRJNA760904_P_NODE_20616_length_241_cov_0.916667_g20559_i0 | PRJNA760904 | 20616 | 241 | 0.916667 | 2.20916747 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 162 | 1.51e-44 | NR | WP_331824954.1 | 3118910 | g20559 | i0 | 95 | 0.995850622406639 | 80 | 4 | 99.6 | 0 | 1 | 240 | 474 | 553 | WP_331824954.1 NPCBM/NEW2 domain-containing protein [Deinococcus sp. YIM 134068] | diamond | 240 | 162 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 27189080 | 27189080 | PRJNA760904_P_NODE_11722_length_273_cov_1.395000_g11665_i0 | PRJNA760904 | 11722 | 273 | 1.395 | 3.80835 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 93.2 | 1e-19 | NR | WP_013704729.1 | 186192 | g11665 | i0 | 62.9 | 6.34065934065934 | 62 | 23 | 68.1 | 0 | 88 | 273 | 251 | 312 | WP_013704729.1 penicillin acylase family protein [Marinithermus hydrothermalis] | diamond | 1731 | 94 | 0.991489361702128 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Marinithermus | Marinithermus hydrothermalis | ||
| 27527022 | 27527022 | PRJNA760904_P_NODE_14143_length_254_cov_2.127072_g14086_i0 | PRJNA760904 | 14143 | 254 | 2.127072 | 5.40276288 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 138 | 1.4699999999999998e-37 | NR | WP_331824308.1 | 3118910 | g14086 | i0 | 84.5 | 0.992125984251969 | 84 | 13 | 99.2 | 0 | 3 | 254 | 169 | 252 | WP_331824308.1 NAD(P)/FAD-dependent oxidoreductase [Deinococcus sp. YIM 134068] | diamond | 252 | 138 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 27685247 | 27685247 | PRJNA760904_P_NODE_12404_length_268_cov_1.358974_g12347_i0 | PRJNA760904 | 12404 | 268 | 1.358974 | 3.64205032 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 55.8 | 5.45e-8 | NR | WP_216329372.1 | 2774531 | g12347 | i0 | 100 | 0.279850746268657 | 25 | 0 | 28 | 0 | 2 | 76 | 52 | 76 | WP_216329372.1 hypothetical protein [Deinococcus aestuarii] | diamond | 75 | 55.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 27779794 | 27779794 | PRJNA760904_P_NODE_20124_length_242_cov_0.911243_g20067_i0 | PRJNA760904 | 20124 | 242 | 0.911243 | 2.20520806 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 58.2 | 1.33e-7 | NR | WP_264778231.1 | 200252 | g20067 | i0 | 74.4 | 0.483471074380165 | 39 | 9 | 48.3 | 1 | 242 | 126 | 465 | 502 | WP_264778231.1 hypothetical protein [Deinococcus aetherius] | diamond | 117 | 58.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 28063762 | 28063762 | PRJNA760904_P_NODE_15205_length_250_cov_0.870056_g15148_i0 | PRJNA760904 | 15205 | 250 | 0.870056 | 2.17514 | Deinococcus multiflagellatus | 1656887 | Bacteria | Bacteria | 136 | 8.92e-39 | NR | WP_224612338.1 | 1656887 | g15148 | i0 | 73.5 | 0.996 | 83 | 22 | 99.6 | 0 | 249 | 1 | 29 | 111 | WP_224612338.1 DUF2227 family putative metal-binding protein [Deinococcus multiflagellatus] | diamond | 249 | 136 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus multiflagellatus | ||
| 28316488 | 28316488 | PRJNA760904_P_NODE_9186_length_296_cov_1.381166_g9129_i0 | PRJNA760904 | 9186 | 296 | 1.381166 | 4.08825136 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 152 | 1.24e-44 | NR | WP_343216657.1 | 2774531 | g9129 | i0 | 75.9 | 6.06081081081081 | 87 | 21 | 88.2 | 0 | 263 | 3 | 1 | 87 | WP_343216657.1 NUDIX hydrolase [Deinococcus aestuarii] | diamond | 1794 | 152 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 28726883 | 28726883 | PRJNA760904_P_NODE_12847_length_265_cov_1.098958_g12790_i0 | PRJNA760904 | 12847 | 265 | 1.098958 | 2.9122387 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 133 | 4.22e-36 | NR | WP_331824444.1 | 3118910 | g12790 | i0 | 82.9 | 0.928301886792453 | 82 | 14 | 92.8 | 0 | 265 | 20 | 215 | 296 | WP_331824444.1 ribokinase [Deinococcus sp. YIM 134068] | diamond | 246 | 133 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 28789904 | 28789904 | PRJNA760904_P_NODE_17007_length_247_cov_0.885057_g16950_i0 | PRJNA760904 | 17007 | 247 | 0.885057 | 2.18609079 | Deinococcus sp. 6GRE | 47478 | Bacteria | Bacteria | 108 | 2.02e-25 | NR | WP_230294200.1 | 2745873 | g16950 | i0 | 75.7 | 1.68825910931174 | 70 | 16 | 83.8 | 1 | 213 | 7 | 364 | 433 | WP_230294200.1 HelD family protein [Deinococcus sp. 6GRE01] | diamond | 417 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. 6GRE01 | ||
| 29263438 | 29263438 | PRJNA760904_P_NODE_16849_length_247_cov_1.689655_g16792_i0 | PRJNA760904 | 16849 | 247 | 1.689655 | 4.17344785 | Deinococcus oregonensis | 1805970 | Bacteria | Bacteria | 108 | 3.89e-27 | NR | WP_380005331.1 | 1805970 | g16792 | i0 | 76.5 | 0.983805668016194 | 81 | 19 | 98.4 | 0 | 1 | 243 | 133 | 213 | WP_380005331.1 hypothetical protein [Deinococcus oregonensis] | diamond | 243 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus oregonensis | ||
| 30052980 | 30052980 | PRJNA760904_P_NODE_13651_length_258_cov_1.648649_g13594_i0 | PRJNA760904 | 13651 | 258 | 1.648649 | 4.25351442 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 144 | 7.61e-39 | NR | WP_092265424.1 | 856736 | g13594 | i0 | 82.4 | 0.988372093023256 | 85 | 15 | 98.8 | 0 | 255 | 1 | 1 | 85 | WP_092265424.1 McrC family protein [Deinococcus reticulitermitis] | diamond | 255 | 144 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 30306360 | 30306360 | PRJNA760904_P_NODE_16992_length_247_cov_0.885057_g16935_i0 | PRJNA760904 | 16992 | 247 | 0.885057 | 2.18609079 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 164 | 9.45e-45 | NR | WP_331823131.1 | 3118910 | g16935 | i0 | 97.6 | 1.9919028340081 | 82 | 2 | 99.6 | 0 | 247 | 2 | 650 | 731 | WP_331823131.1 pitrilysin family protein [Deinococcus sp. YIM 134068] | diamond | 492 | 164 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 30464259 | 30464259 | PRJNA760904_P_NODE_13753_length_257_cov_2.217391_g13696_i0 | PRJNA760904 | 13753 | 257 | 2.217391 | 5.69869487 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 84.7 | 2.63e-18 | NR | HRV01955.1 | 2053577 | g13696 | i0 | 51.9 | 0.898832684824903 | 77 | 34 | 89.9 | 1 | 232 | 2 | 2 | 75 | HRV01955.1 C39 family peptidase [Mesotoga sp.] | diamond | 231 | 84.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 30916072 | 30916072 | PRJNA760904_P_NODE_12894_length_264_cov_1.947644_g12837_i0 | PRJNA760904 | 12894 | 264 | 1.947644 | 5.14178016 | Bacteria | 2 | Bacteria | Bacteria | 53.1 | 5.56e-7 | NR | WP_008522703.1 | 428711 | g12837 | i0 | 38.9 | 4.46590909090909 | 72 | 42 | 79.5 | 1 | 262 | 53 | 2 | 73 | WP_008522703.1 MULTISPECIES: 50S ribosomal protein L32 [Jonquetella] | diamond | 1179 | 53.5 | 0.992523364485981 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | |||
| 31064391 | 31064391 | PRJNA760904_P_NODE_17855_length_246_cov_0.890173_g17798_i0 | PRJNA760904 | 17855 | 246 | 0.890173 | 2.18982558 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 128 | 2.07e-33 | NR | WP_331826038.1 | 3118910 | g17798 | i0 | 95.2 | 0.768292682926829 | 63 | 3 | 76.8 | 0 | 190 | 2 | 188 | 250 | WP_331826038.1 DUF3500 domain-containing protein [Deinococcus sp. YIM 134068] | diamond | 189 | 128 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 31633277 | 31633277 | PRJNA760904_P_NODE_20356_length_241_cov_1.833333_g20299_i0 | PRJNA760904 | 20356 | 241 | 1.833333 | 4.41833253 | Deinococcus alpinitundrae | 468913 | Bacteria | Bacteria | 88.2 | 3.57e-18 | NR | WP_161883678.1 | 468913 | g20299 | i0 | 61.5 | 0.970954356846473 | 78 | 26 | 97.1 | 1 | 6 | 239 | 215 | 288 | WP_161883678.1 bifunctional cytochrome P450/NADPH--P450 reductase [Deinococcus alpinitundrae] | diamond | 234 | 88.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus alpinitundrae | ||
| 32234758 | 32234758 | PRJNA760904_P_NODE_15558_length_250_cov_0.870056_g15501_i0 | PRJNA760904 | 15558 | 250 | 0.870056 | 2.17514 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 117 | 4.64e-29 | NR | WP_331824040.1 | 3118910 | g15501 | i0 | 85.1 | 0.804 | 67 | 10 | 80.4 | 0 | 48 | 248 | 1 | 67 | WP_331824040.1 acyl-CoA dehydrogenase family protein [Deinococcus sp. YIM 134068] | diamond | 201 | 117 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 32329701 | 32329701 | PRJNA760904_P_NODE_17359_length_247_cov_0.885057_g17302_i0 | PRJNA760904 | 17359 | 247 | 0.885057 | 2.18609079 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 134 | 2.24e-36 | NR | WP_331825138.1 | 3118910 | g17302 | i0 | 86.6 | 0.995951417004049 | 82 | 11 | 99.6 | 0 | 246 | 1 | 215 | 296 | WP_331825138.1 ABC transporter ATP-binding protein [Deinococcus sp. YIM 134068] | diamond | 246 | 134 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 32456125 | 32456125 | PRJNA760904_P_NODE_1139_length_719_cov_32.992260_g1086_i0 | PRJNA760904 | 1139 | 719 | 32.99226 | 237.2143494 | Thermotogaceae bacterium | 2268206 | Bacteria | Bacteria | 72.4 | 2.84e-12 | NR | MCD6449480.1 | 2268206 | g1086 | i0 | 40.6 | 0.442280945757997 | 106 | 58 | 43.8 | 3 | 542 | 228 | 14 | 115 | MCD6449480.1 Hsp20/alpha crystallin family protein [Thermotogaceae bacterium] | diamond | 318 | 72.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotogaceae bacterium | |||
| 32739982 | 32739982 | PRJNA760904_P_NODE_18460_length_245_cov_0.895349_g18403_i0 | PRJNA760904 | 18460 | 245 | 0.895349 | 2.19360505 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 145 | 1.65e-40 | NR | WP_331824474.1 | 3118910 | g18403 | i0 | 91.4 | 0.991836734693878 | 81 | 7 | 99.2 | 0 | 244 | 2 | 26 | 106 | WP_331824474.1 type 2 isopentenyl-diphosphate Delta-isomerase [Deinococcus sp. YIM 134068] | diamond | 243 | 145 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 32802752 | 32802752 | PRJNA760904_P_NODE_8260_length_311_cov_1.147059_g8203_i0 | PRJNA760904 | 8260 | 311 | 1.147059 | 3.56735349 | Marinithermus hydrothermalis | 186192 | Bacteria | Bacteria | 136 | 8.28e-36 | NR | WP_013704011.1 | 186192 | g8203 | i0 | 81 | 9.15434083601286 | 79 | 14 | 76.2 | 1 | 3 | 239 | 229 | 306 | WP_013704011.1 isocitrate lyase [Marinithermus hydrothermalis] | diamond | 2847 | 136 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Marinithermus | Marinithermus hydrothermalis |
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);;