contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA839281" and tax_phylum = "Deinococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5058256 | 5058256 | PRJNA839281_S_NODE_12624_length_225_cov_1.073864_g12355_i0 | PRJNA839281 | 12624 | 225 | 1.073864 | 2.416194 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 136 | 8.23e-39 | NR | WP_092264396.1 | 856736 | g12355 | i0 | 93.1 | 0.96 | 72 | 5 | 96 | 0 | 8 | 223 | 1 | 72 | WP_092264396.1 DUF4388 domain-containing protein [Deinococcus reticulitermitis] | diamond | 216 | 136 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 5932997 | 5932997 | PRJNA839281_S_NODE_34465_length_163_cov_0.877193_g34196_i0 | PRJNA839281 | 34465 | 163 | 0.877193 | 1.42982459 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 99 | 1.32e-24 | NR | WP_380079676.1 | 1298767 | g34196 | i0 | 100 | 0.993865030674847 | 54 | 0 | 99.4 | 0 | 162 | 1 | 57 | 110 | WP_380079676.1 OmpH family outer membrane protein [Deinococcus antarcticus] | diamond | 162 | 99 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 11434221 | 11434221 | PRJNA839281_S_NODE_4889_length_407_cov_1.737430_g4620_i0 | PRJNA839281 | 4889 | 407 | 1.73743 | 7.0713401 | Thermus caliditerrae | 1330700 | Bacteria | Bacteria | 189 | 1.62e-58 | NR | WP_038045255.1 | 1330700 | g4620 | i0 | 92.9 | 0.722358722358722 | 98 | 7 | 72.2 | 0 | 407 | 114 | 79 | 176 | WP_038045255.1 GTP-binding protein [Thermus caliditerrae] | diamond | 294 | 189 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus caliditerrae | ||
| 26674499 | 26674499 | PRJNA839281_S_NODE_36301_length_162_cov_0.858407_g36032_i0 | PRJNA839281 | 36301 | 162 | 0.858407 | 1.39061934 | Thermus oshimai | 56957 | Bacteria | Bacteria | 55.5 | 2.38e-8 | NR | GAA6741988.1 | 56957 | g36032 | i0 | 58.7 | 0.851851851851852 | 46 | 19 | 85.2 | 0 | 2 | 139 | 38 | 83 | GAA6741988.1 hypothetical protein Thermus77359_21750 [Thermus oshimai] | diamond | 138 | 55.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus oshimai | ||
| 27465638 | 27465638 | PRJNA839281_S_NODE_29203_length_166_cov_0.871795_g28934_i0 | PRJNA839281 | 29203 | 166 | 0.871795 | 1.4471797 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 76.3 | 2.03e-14 | NR | WP_143068344.1 | 856736 | g28934 | i0 | 83 | 0.849397590361446 | 47 | 8 | 84.9 | 0 | 162 | 22 | 277 | 323 | WP_143068344.1 AfsR/SARP family transcriptional regulator [Deinococcus reticulitermitis] | diamond | 141 | 76.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 27465642 | 27465642 | PRJNA839281_S_NODE_9623_length_256_cov_1.202899_g9354_i0 | PRJNA839281 | 9623 | 256 | 1.202899 | 3.07942144 | Thermus sp. LT1-2-5 | 3026935 | Bacteria | Bacteria | 99.4 | 8.26e-24 | NR | WP_353513207.1 | 3026935 | g9354 | i0 | 62.4 | 0.99609375 | 85 | 32 | 99.6 | 0 | 255 | 1 | 34 | 118 | WP_353513207.1 protoglobin domain-containing protein [Thermus sp. LT1-2-5] | diamond | 255 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. LT1-2-5 | ||
| 28065413 | 28065413 | PRJNA839281_S_NODE_36865_length_161_cov_0.910714_g36596_i0 | PRJNA839281 | 36865 | 161 | 0.910714 | 1.46624954 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 102 | 4.52e-24 | NR | WP_092265235.1 | 856736 | g36596 | i0 | 92.3 | 0.968944099378882 | 52 | 4 | 96.9 | 0 | 160 | 5 | 4 | 55 | WP_092265235.1 glycogen synthase [Deinococcus reticulitermitis] | diamond | 156 | 102 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 28096955 | 28096955 | PRJNA839281_S_NODE_33685_length_163_cov_0.894737_g33416_i0 | PRJNA839281 | 33685 | 163 | 0.894737 | 1.45842131 | Thermus aquaticus | 271 | Bacteria | Bacteria | 92.4 | 2.5399999999999994e-23 | NR | KOX88990.1 | 271 | g33416 | i0 | 100 | 2.70552147239264 | 49 | 0 | 90.2 | 0 | 163 | 17 | 3 | 51 | KOX88990.1 hypothetical protein BVI061214_00133 [Thermus aquaticus] | diamond | 441 | 92.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 28421397 | 28421397 | PRJNA839281_S_NODE_28826_length_166_cov_0.871795_g28557_i0 | PRJNA839281 | 28826 | 166 | 0.871795 | 1.4471797 | Deinococcus | 1298 | Bacteria | Bacteria | 81.3 | 3.36e-16 | NR | WP_103127746.1 | 200253 | g28557 | i0 | 77.8 | 3.90361445783133 | 54 | 12 | 97.6 | 0 | 3 | 164 | 526 | 579 | WP_103127746.1 vWA domain-containing protein [Deinococcus aerius] | diamond | 648 | 81.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aerius | ||
| 28475897 | 28475897 | PRJNA839281_S_NODE_33086_length_163_cov_1.228070_g32817_i0 | PRJNA839281 | 33086 | 163 | 1.22807 | 2.0017541 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 65.1 | 1.51e-10 | NR | WP_278913702.1 | 980427 | g32817 | i0 | 55.8 | 0.957055214723926 | 52 | 23 | 95.7 | 0 | 6 | 161 | 90 | 141 | WP_278913702.1 hypothetical protein [Deinococcus wulumuqiensis] | diamond | 156 | 65.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 28705457 | 28705457 | PRJNA839281_S_NODE_21947_length_179_cov_1.915385_g21678_i0 | PRJNA839281 | 21947 | 179 | 1.915385 | 3.42853915 | Thermus | 270 | Bacteria | Bacteria | 74.3 | 1.5e-14 | NR | WP_071678125.1 | 56956 | g21678 | i0 | 67.8 | 1.97765363128492 | 59 | 19 | 98.9 | 0 | 177 | 1 | 138 | 196 | WP_071678125.1 protoglobin domain-containing protein [Thermus brockianus] | diamond | 354 | 74.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 28791458 | 28791458 | PRJNA839281_S_NODE_27527_length_167_cov_0.864407_g27258_i0 | PRJNA839281 | 27527 | 167 | 0.864407 | 1.44355969 | Deinococcus malanensis | 1706855 | Bacteria | Bacteria | 71.2 | 9.57e-13 | NR | WP_189004468.1 | 1706855 | g27258 | i0 | 72.2 | 2.91017964071856 | 54 | 15 | 97 | 0 | 162 | 1 | 72 | 125 | WP_189004468.1 sensor histidine kinase [Deinococcus malanensis] | diamond | 486 | 71.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus malanensis | ||
| 28822900 | 28822900 | PRJNA839281_S_NODE_36088_length_162_cov_0.902655_g35819_i0 | PRJNA839281 | 36088 | 162 | 0.902655 | 1.4623011 | Deinococcus fonticola | 2528713 | Bacteria | Bacteria | 106 | 1.05e-26 | NR | WP_135230630.1 | 2528713 | g35819 | i0 | 98.1 | 0.981481481481482 | 53 | 1 | 98.1 | 0 | 3 | 161 | 80 | 132 | WP_135230630.1 hypothetical protein [Deinococcus fonticola] | diamond | 159 | 106 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus fonticola | ||
| 29044346 | 29044346 | PRJNA839281_S_NODE_36008_length_162_cov_0.902655_g35739_i0 | PRJNA839281 | 36008 | 162 | 0.902655 | 1.4623011 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 68.9 | 2.12e-12 | NR | BDP42480.1 | 200252 | g35739 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 162 | 4 | 99 | 151 | BDP42480.1 hypothetical protein DAETH_24490 [Deinococcus aetherius] | diamond | 159 | 68.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 29422855 | 29422855 | PRJNA839281_S_NODE_28129_length_166_cov_0.871795_g27860_i0 | PRJNA839281 | 28129 | 166 | 0.871795 | 1.4471797 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 45.1 | 0.00204 | NR | WP_414658003.1 | 3385567 | g27860 | i0 | 40.7 | 0.975903614457831 | 54 | 32 | 97.6 | 0 | 2 | 163 | 296 | 349 | WP_414658003.1 hypothetical protein [Deinococcus sp. VB343] | diamond | 162 | 45.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 29517698 | 29517698 | PRJNA839281_S_NODE_37290_length_161_cov_0.910714_g37021_i0 | PRJNA839281 | 37290 | 161 | 0.910714 | 1.46624954 | Deinococcus knuensis | 1837380 | Bacteria | Bacteria | 97.1 | 3.07e-22 | NR | WP_189100654.1 | 1837380 | g37021 | i0 | 98.1 | 0.987577639751553 | 53 | 1 | 98.8 | 0 | 2 | 160 | 61 | 113 | WP_189100654.1 sensor domain-containing diguanylate cyclase [Deinococcus knuensis] | diamond | 159 | 97.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus knuensis | ||
| 30023286 | 30023286 | PRJNA839281_S_NODE_18391_length_192_cov_1.531469_g18122_i0 | PRJNA839281 | 18391 | 192 | 1.531469 | 2.94042048 | Thermus aquaticus | 271 | Bacteria | Bacteria | 126 | 6.129999999999999e-32 | NR | WP_082333148.1 | 271 | g18122 | i0 | 98.4 | 0.984375 | 63 | 1 | 98.4 | 0 | 191 | 3 | 216 | 278 | WP_082333148.1 DNA primase [Thermus aquaticus] | diamond | 189 | 126 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 30276143 | 30276143 | PRJNA839281_S_NODE_16232_length_202_cov_1.875817_g15963_i0 | PRJNA839281 | 16232 | 202 | 1.875817 | 3.78915034 | Thermus caliditerrae | 1330700 | Bacteria | Bacteria | 87 | 2.2e-19 | NR | WP_038045256.1 | 1330700 | g15963 | i0 | 58.6 | 2.07920792079208 | 70 | 26 | 99.5 | 1 | 2 | 202 | 78 | 147 | WP_038045256.1 protoglobin domain-containing protein [Thermus caliditerrae] | diamond | 420 | 87 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus caliditerrae | ||
| 30781356 | 30781356 | PRJNA839281_S_NODE_11894_length_231_cov_1.296703_g11625_i0 | PRJNA839281 | 11894 | 231 | 1.296703 | 2.99538393 | Thermus sp. | 275 | Bacteria | Bacteria | 107 | 4.5e-25 | NR | WP_314134006.1 | 275 | g11625 | i0 | 83.9 | 0.727272727272727 | 56 | 9 | 72.7 | 0 | 3 | 170 | 269 | 324 | WP_314134006.1 hypothetical protein [Thermus sp.] | diamond | 168 | 107 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 31191784 | 31191784 | PRJNA839281_S_NODE_14755_length_210_cov_1.677019_g14486_i0 | PRJNA839281 | 14755 | 210 | 1.677019 | 3.5217399 | Thermus sp. | 275 | Bacteria | Bacteria | 140 | 9.77e-38 | NR | WP_314134006.1 | 275 | g14486 | i0 | 100 | 1 | 70 | 0 | 100 | 0 | 210 | 1 | 346 | 415 | WP_314134006.1 hypothetical protein [Thermus sp.] | diamond | 210 | 140 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 31286859 | 31286859 | PRJNA839281_S_NODE_35235_length_162_cov_0.902655_g34966_i0 | PRJNA839281 | 35235 | 162 | 0.902655 | 1.4623011 | Deinococcus sp. KNUC121 | 47478 | Bacteria | Bacteria | 52.8 | 3.7e-6 | NR | WP_239052284.1 | 2917691 | g34966 | i0 | 48.1 | 1 | 54 | 28 | 100 | 0 | 162 | 1 | 97 | 150 | WP_239052284.1 type II secretion system protein GspD [Deinococcus sp. KNUC1210] | diamond | 162 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. KNUC1210 | ||
| 31476946 | 31476946 | PRJNA839281_S_NODE_31616_length_164_cov_0.886957_g31347_i0 | PRJNA839281 | 31616 | 164 | 0.886957 | 1.45460948 | Thermus aquaticus | 271 | Bacteria | Bacteria | 107 | 1.61e-28 | NR | WP_248841738.1 | 271 | g31347 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 163 | 2 | 9 | 62 | WP_248841738.1 DUF86 domain-containing protein [Thermus aquaticus] | diamond | 162 | 107 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 31706663 | 31706663 | PRJNA839281_S_NODE_28577_length_166_cov_0.871795_g28308_i0 | PRJNA839281 | 28577 | 166 | 0.871795 | 1.4471797 | Deinococcus | 1298 | Bacteria | Bacteria | 82 | 1.38e-17 | NR | MXV20827.1 | 1507289 | g28308 | i0 | 70.4 | 6.77710843373494 | 54 | 16 | 97.6 | 0 | 164 | 3 | 22 | 75 | MXV20827.1 methyltransferase domain-containing protein [Deinococcus xianganensis] | diamond | 1125 | 82.8 | 0.990338164251208 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xianganensis | ||
| 32014508 | 32014508 | PRJNA839281_S_NODE_23418_length_175_cov_1.214286_g23149_i0 | PRJNA839281 | 23418 | 175 | 1.214286 | 2.1250005 | Thermus sp. | 275 | Bacteria | Bacteria | 67.4 | 2.83e-11 | NR | MDM7325172.1 | 275 | g23149 | i0 | 58.3 | 2.05714285714286 | 60 | 23 | 99.4 | 2 | 174 | 1 | 118 | 177 | MDM7325172.1 hypothetical protein [Thermus sp.] | diamond | 360 | 67.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 32204397 | 32204397 | PRJNA839281_S_NODE_21438_length_181_cov_1.159091_g21169_i0 | PRJNA839281 | 21438 | 181 | 1.159091 | 2.09795471 | Thermus aquaticus | 271 | Bacteria | Bacteria | 105 | 5.4e-26 | NR | WP_082333091.1 | 271 | g21169 | i0 | 100 | 0.878453038674033 | 53 | 0 | 87.8 | 0 | 1 | 159 | 90 | 142 | WP_082333091.1 DNA-processing protein DprA [Thermus aquaticus] | diamond | 159 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 32299649 | 32299649 | PRJNA839281_S_NODE_15519_length_206_cov_0.974522_g15250_i0 | PRJNA839281 | 15519 | 206 | 0.974522 | 2.00751532 | Thermus | 270 | Bacteria | Bacteria | 105 | 2.7200000000000003e-26 | NR | WP_018461859.1 | 270 | g15250 | i0 | 75 | 0.990291262135922 | 68 | 17 | 99 | 0 | 206 | 3 | 99 | 166 | WP_018461859.1 MULTISPECIES: bifunctional 4-hydroxy-2-oxoglutarate aldolase/2-dehydro-3-deoxy-phosphogluconate aldolase [Thermus] | diamond | 204 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus |
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);;