contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9358051 | 9358051 | PRJNA432257_S_NODE_62008_length_213_cov_7.590909_g61627_i0 | PRJNA432257 | 62008 | 213 | 7.590909 | 16.16863617 | Deinococcus radiotolerans | 1309407 | Bacteria | Bacteria | 99.4 | 3.04e-22 | NR | WP_189070402.1 | 1309407 | g61627 | i0 | 85.2 | 3.43661971830986 | 61 | 9 | 85.9 | 0 | 31 | 213 | 455 | 515 | WP_189070402.1 heavy metal translocating P-type ATPase [Deinococcus radiotolerans] | diamond | 732 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiotolerans | ||
| 24656136 | 24656136 | PRJNA432257_S_NODE_52420_length_227_cov_2.436842_g52039_i0 | PRJNA432257 | 52420 | 227 | 2.436842 | 5.53163134 | Deinococcus sp. YIM 77859 | 1540221 | Bacteria | Bacteria | 96.7 | 1.5199999999999995e-23 | NR | WP_369699468.1 | 1540221 | g52039 | i0 | 100 | 0.647577092511013 | 49 | 0 | 64.8 | 0 | 3 | 149 | 94 | 142 | WP_369699468.1 zinc ribbon domain-containing protein [Deinococcus sp. YIM 77859] | diamond | 147 | 96.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. YIM 77859 | ||
| 27360467 | 27360467 | PRJNA432257_S_NODE_93683_length_181_cov_5.506944_g93302_i0 | PRJNA432257 | 93683 | 181 | 5.506944 | 9.96756864 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 71.6 | 9.35e-13 | NR | MDM7320286.1 | 1871331 | g93302 | i0 | 85 | 0.662983425414365 | 40 | 6 | 66.3 | 0 | 21 | 140 | 206 | 245 | MDM7320286.1 hypothetical protein [Fervidobacterium sp.] | diamond | 120 | 71.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27708060 | 27708060 | PRJNA432257_S_NODE_125284_length_152_cov_2.365217_g124903_i0 | PRJNA432257 | 125284 | 152 | 2.365217 | 3.59512984 | Synergistales bacterium | 2268201 | Bacteria | Bacteria | 45.1 | 0.00117 | NR | NCB17331.1 | 2268201 | g124903 | i0 | 74.1 | 0.532894736842105 | 27 | 7 | 53.3 | 0 | 100 | 20 | 57 | 83 | NCB17331.1 M20/M25/M40 family metallo-hydrolase [Synergistales bacterium] | diamond | 81 | 45.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium | ||||
| 27708084 | 27708084 | PRJNA432257_S_NODE_65564_length_208_cov_314.269006_g65183_i0 | PRJNA432257 | 65564 | 208 | 314.269006 | 653.67953248 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 100 | 6.05e-23 | NR | MDM7320286.1 | 1871331 | g65183 | i0 | 90.4 | 0.75 | 52 | 5 | 75 | 0 | 21 | 176 | 206 | 257 | MDM7320286.1 hypothetical protein [Fervidobacterium sp.] | diamond | 156 | 100 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27991929 | 27991929 | PRJNA432257_S_NODE_71485_length_202_cov_1.345455_g71104_i0 | PRJNA432257 | 71485 | 202 | 1.345455 | 2.7178191 | Thermus scotoductus | 37636 | Bacteria | Bacteria | 72.8 | 2.01e-13 | NR | WP_126208857.1 | 37636 | g71104 | i0 | 92.5 | 0.594059405940594 | 40 | 3 | 59.4 | 0 | 200 | 81 | 218 | 257 | WP_126208857.1 class II fructose-bisphosphate aldolase [Thermus scotoductus] | diamond | 120 | 72.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 28023448 | 28023448 | PRJNA432257_S_NODE_79005_length_194_cov_1.617834_g78624_i0 | PRJNA432257 | 79005 | 194 | 1.617834 | 3.13859796 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 107 | 1.14e-27 | NR | MDM7321174.1 | 1871331 | g78624 | i0 | 88.1 | 0.912371134020619 | 59 | 7 | 91.2 | 0 | 17 | 193 | 33 | 91 | MDM7321174.1 hypothetical protein [Fervidobacterium sp.] | diamond | 177 | 107 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28355437 | 28355437 | PRJNA432257_S_NODE_102626_length_174_cov_1.970803_g102245_i0 | PRJNA432257 | 102626 | 174 | 1.970803 | 3.42919722 | Thermaceae | 188786 | Bacteria | Bacteria | 54.3 | 1.05e-7 | NR | WP_027894486.1 | 52023 | g102245 | i0 | 60.5 | 1.51724137931034 | 43 | 17 | 74.1 | 0 | 130 | 2 | 9 | 51 | WP_027894486.1 hypothetical protein [Calidithermus chliarophilus] | diamond | 264 | 54.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus chliarophilus | ||
| 28402262 | 28402262 | PRJNA432257_S_NODE_82366_length_190_cov_1602.738562_g81985_i0 | PRJNA432257 | 82366 | 190 | 1602.738562 | 3045.2032678 | Thermus sp. | 275 | Bacteria | Bacteria | 90.1 | 2.07e-21 | NR | MDM7324598.1 | 275 | g81985 | i0 | 80 | 0.868421052631579 | 55 | 11 | 86.8 | 0 | 188 | 24 | 55 | 109 | MDM7324598.1 hypothetical protein [Thermus sp.] | diamond | 165 | 90.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 28623439 | 28623439 | PRJNA432257_S_NODE_91327_length_183_cov_2.246575_g90946_i0 | PRJNA432257 | 91327 | 183 | 2.246575 | 4.11123225 | Meiothermus rufus | 604332 | Bacteria | Bacteria | 87.4 | 1.77e-18 | NR | WP_027883494.1 | 604332 | g90946 | i0 | 71.2 | 1.9344262295082 | 59 | 17 | 96.7 | 0 | 181 | 5 | 302 | 360 | WP_027883494.1 AAA family ATPase [Meiothermus rufus] | diamond | 354 | 87.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus rufus | ||
| 29191698 | 29191698 | PRJNA432257_S_NODE_39689_length_252_cov_2.283721_g39308_i0 | PRJNA432257 | 39689 | 252 | 2.283721 | 5.75497692 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 136 | 9.75e-38 | NR | MBP8633447.1 | 2053624 | g39308 | i0 | 92.3 | 0.928571428571429 | 78 | 6 | 92.9 | 0 | 17 | 250 | 1 | 78 | MBP8633447.1 AzlC family ABC transporter permease [Synergistaceae bacterium] | diamond | 234 | 136 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 29191729 | 29191729 | PRJNA432257_S_NODE_9149_length_422_cov_5.831169_g8804_i0 | PRJNA432257 | 9149 | 422 | 5.831169 | 24.60753318 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 192 | 1.8499999999999998e-60 | NR | MFN6991807.1 | 1871331 | g8804 | i0 | 88.5 | 0.803317535545024 | 113 | 13 | 80.3 | 0 | 422 | 84 | 6 | 118 | MFN6991807.1 hypothetical protein [Fervidobacterium sp.] | diamond | 339 | 192 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 29412492 | 29412492 | PRJNA432257_S_NODE_48029_length_234_cov_73.436548_g47648_i0 | PRJNA432257 | 48029 | 234 | 73.436548 | 171.84152232 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 71.2 | 2.64e-12 | NR | WP_386845826.1 | 536443 | g47648 | i0 | 100 | 0.461538461538462 | 36 | 0 | 46.2 | 0 | 95 | 202 | 1 | 36 | WP_386845826.1 hypothetical protein [Deinococcus taklimakanensis] | diamond | 108 | 71.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 29570349 | 29570349 | PRJNA432257_S_NODE_47170_length_236_cov_2.798995_g46789_i0 | PRJNA432257 | 47170 | 236 | 2.798995 | 6.6056282 | Aminivibrio sp. | 1872489 | Bacteria | Bacteria | 152 | 2.66e-42 | NR | WP_367337247.1 | 1872489 | g46789 | i0 | 90.8 | 0.966101694915254 | 76 | 7 | 96.6 | 0 | 7 | 234 | 341 | 416 | WP_367337247.1 hypothetical protein [Aminivibrio sp.] | diamond | 228 | 152 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 29696413 | 29696413 | PRJNA432257_S_NODE_49330_length_232_cov_11.594872_g48949_i0 | PRJNA432257 | 49330 | 232 | 11.594872 | 26.90010304 | Thermus thalpophilus | 2908147 | Bacteria | Bacteria | 99.4 | 1.04e-22 | NR | WP_243094757.1 | 2908147 | g48949 | i0 | 86.7 | 0.775862068965517 | 60 | 8 | 77.6 | 0 | 52 | 231 | 223 | 282 | WP_243094757.1 phosphate ABC transporter substrate-binding protein PstS [Thermus thalpophilus] | diamond | 180 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thalpophilus | ||
| 29981078 | 29981078 | PRJNA432257_S_NODE_7811_length_446_cov_1.970660_g7490_i0 | PRJNA432257 | 7811 | 446 | 1.97066 | 8.7891436 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 111 | 9.63e-26 | NR | MDR3255266.1 | 2053624 | g7490 | i0 | 71.1 | 1.02242152466368 | 76 | 22 | 51.1 | 0 | 446 | 219 | 209 | 284 | MDR3255266.1 phosphomannomutase/phosphoglucomutase [Synergistaceae bacterium] | diamond | 456 | 111 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30313947 | 30313947 | PRJNA432257_S_NODE_68412_length_205_cov_7.589286_g68031_i0 | PRJNA432257 | 68412 | 205 | 7.589286 | 15.5580363 | Bacteria | 2 | Bacteria | Bacteria | 46.2 | 0.00133 | NR | WP_045087478.1 | 1006576 | g68031 | i0 | 54.8 | 1.88780487804878 | 42 | 19 | 61.5 | 0 | 64 | 189 | 9 | 50 | WP_045087478.1 HD-GYP domain-containing protein [Defluviitoga tunisiensis] | diamond | 387 | 46.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 30329122 | 30329122 | PRJNA432257_S_NODE_86252_length_187_cov_4.593333_g85871_i0 | PRJNA432257 | 86252 | 187 | 4.593333 | 8.58953271 | Allomeiothermus silvanus | 52022 | Bacteria | Bacteria | 68.2 | 1.77e-11 | NR | WP_276957989.1 | 52022 | g85871 | i0 | 62.5 | 0.770053475935829 | 48 | 17 | 75.4 | 1 | 187 | 47 | 76 | 123 | WP_276957989.1 hypothetical protein [Allomeiothermus silvanus] | diamond | 144 | 68.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 30739254 | 30739254 | PRJNA432257_S_NODE_52534_length_227_cov_1.615789_g52153_i0 | PRJNA432257 | 52534 | 227 | 1.615789 | 3.66784103 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 60.1 | 1.58e-8 | NR | MDM7321175.1 | 1871331 | g52153 | i0 | 75.7 | 0.488986784140969 | 37 | 9 | 48.9 | 0 | 153 | 43 | 225 | 261 | MDM7321175.1 hypothetical protein [Fervidobacterium sp.] | diamond | 111 | 60.1 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30771087 | 30771087 | PRJNA432257_S_NODE_62474_length_212_cov_272.314286_g62093_i0 | PRJNA432257 | 62474 | 212 | 272.314286 | 577.30628632 | Thermus | 270 | Bacteria | Bacteria | 41.6 | 0.0324 | NR | WP_018461505.1 | 270 | g62093 | i0 | 67.9 | 0.39622641509434 | 28 | 9 | 39.6 | 0 | 93 | 10 | 105 | 132 | WP_018461505.1 MULTISPECIES: hypothetical protein [Thermus] | diamond | 84 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | |||
| 31308047 | 31308047 | PRJNA432257_S_NODE_88315_length_185_cov_152.682432_g87934_i0 | PRJNA432257 | 88315 | 185 | 152.682432 | 282.4624992 | Allomeiothermus silvanus | 52022 | Bacteria | Bacteria | 109 | 6.48e-28 | NR | MCL6569888.1 | 52022 | g87934 | i0 | 91.2 | 0.924324324324324 | 57 | 5 | 92.4 | 0 | 184 | 14 | 115 | 171 | MCL6569888.1 hypothetical protein [Allomeiothermus silvanus] | diamond | 171 | 109 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 31592980 | 31592980 | PRJNA432257_S_NODE_15576_length_350_cov_48.607029_g15195_i0 | PRJNA432257 | 15576 | 350 | 48.607029 | 170.1246015 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 133 | 1.4299999999999998e-37 | NR | MFN6991807.1 | 1871331 | g15195 | i0 | 81.5 | 0.694285714285714 | 81 | 15 | 69.4 | 0 | 326 | 84 | 38 | 118 | MFN6991807.1 hypothetical protein [Fervidobacterium sp.] | diamond | 243 | 133 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 32210390 | 32210390 | PRJNA432257_S_NODE_66898_length_207_cov_2.023529_g66517_i0 | PRJNA432257 | 66898 | 207 | 2.023529 | 4.18870503 | Thermovirga | 336260 | Bacteria | Bacteria | 106 | 1.23e-25 | NR | AER65906.1 | 580340 | g66517 | i0 | 85.9 | 3.69565217391304 | 64 | 9 | 92.8 | 0 | 16 | 207 | 143 | 206 | AER65906.1 Alcohol dehydrogenase zinc-binding domain protein [Thermovirga lienii DSM 17291] | diamond | 765 | 106 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Thermovirgaceae | Thermovirga | Thermovirga lienii | ||
| 32888270 | 32888270 | PRJNA432257_S_NODE_75160_length_198_cov_1.453416_g74779_i0 | PRJNA432257 | 75160 | 198 | 1.453416 | 2.87776368 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 120 | 2.29e-30 | NR | WP_245556435.1 | 519440 | g74779 | i0 | 98.4 | 0.954545454545455 | 63 | 1 | 95.5 | 0 | 190 | 2 | 324 | 386 | WP_245556435.1 polysaccharide biosynthesis tyrosine autokinase [Deinococcus aquatilis] | diamond | 189 | 120 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis |
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);;