contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192530 | 192530 | PRJNA1078753_P_NODE_28401_length_250_cov_1.525424_g28205_i0 | PRJNA1078753 | 28401 | 250 | 1.525424 | 3.81356 | Deinococcus | 1298 | Bacteria | Bacteria | 145 | 1.23e-39 | NR | WP_188964818.1 | 393059 | g28205 | i0 | 80.7 | 7.848 | 83 | 16 | 99.6 | 0 | 249 | 1 | 334 | 416 | WP_188964818.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Deinococcus aquiradiocola] | diamond | 1962 | 146 | 0.993150684931507 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquiradiocola | ||
| 1467080 | 1467080 | PRJNA1078753_P_NODE_1842_length_719_cov_1.325077_g1666_i0 | PRJNA1078753 | 1842 | 719 | 1.325077 | 9.52730363 | root | 1 | Root_unresolved | Root_unresolved | 229 | 4.2599999999999996e-67 | NR | MBI3963258.1 | 47478 | g1666 | i0 | 53.1 | 23.4242002781641 | 194 | 82 | 80.5 | 2 | 581 | 3 | 429 | 614 | MBI3963258.1 S9 family peptidase [Deinococcus sp.] | diamond | 16842 | 229 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 4019049 | 4019049 | PRJNA1078753_P_NODE_21104_length_274_cov_1.164179_g20908_i0 | PRJNA1078753 | 21104 | 274 | 1.164179 | 3.18985046 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 116 | 1.18e-28 | NR | WP_013178337.1 | 332249 | g20908 | i0 | 69.2 | 0.996350364963504 | 91 | 28 | 99.6 | 0 | 274 | 2 | 281 | 371 | WP_013178337.1 N-acetyl-alpha-D-glucosaminyl L-malate synthase BshA [Truepera radiovictrix] | diamond | 273 | 116 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 18044304 | 18044304 | PRJNA1078753_P_NODE_25595_length_256_cov_1.284153_g25399_i0 | PRJNA1078753 | 25595 | 256 | 1.284153 | 3.28743168 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 150 | 1.4e-40 | NR | WP_013177280.1 | 332249 | g25399 | i0 | 87.1 | 0.99609375 | 85 | 11 | 99.6 | 0 | 2 | 256 | 444 | 528 | WP_013177280.1 ABC transporter ATP-binding protein [Truepera radiovictrix] | diamond | 255 | 150 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 20593763 | 20593763 | PRJNA1078753_P_NODE_917_length_978_cov_1.689503_g775_i0 | PRJNA1078753 | 917 | 978 | 1.689503 | 16.52333934 | Deinococcus | 1298 | Bacteria | Bacteria | 288 | 1.77e-91 | NR | WP_013557461.1 | 309887 | g775 | i0 | 55.4 | 9.62269938650307 | 280 | 121 | 85.3 | 3 | 22 | 855 | 117 | 394 | WP_013557461.1 S8 family peptidase [Deinococcus maricopensis] | diamond | 9411 | 288 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus maricopensis | ||
| 24418389 | 24418389 | PRJNA1078753_P_NODE_19760_length_279_cov_1.747573_g19564_i0 | PRJNA1078753 | 19760 | 279 | 1.747573 | 4.87572867 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 190 | 3.389999999999999e-55 | NR | WP_331823848.1 | 3118910 | g19564 | i0 | 95.7 | 0.989247311827957 | 92 | 4 | 98.9 | 0 | 278 | 3 | 170 | 261 | WP_331823848.1 family 43 glycosylhydrolase [Deinococcus sp. YIM 134068] | diamond | 276 | 190 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 27099035 | 27099035 | PRJNA1078753_P_NODE_27142_length_251_cov_0.865169_g26946_i0 | PRJNA1078753 | 27142 | 251 | 0.865169 | 2.17157419 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 132 | 4.53e-36 | NR | CAA9586746.1 | 543023 | g26946 | i0 | 72.6 | 1.99601593625498 | 84 | 22 | 99.2 | 1 | 249 | 1 | 137 | 220 | CAA9586746.1 MAG: N-acetylmannosaminyltransferase [uncultured Truepera sp.] | diamond | 501 | 132 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 27193789 | 27193789 | PRJNA1078753_P_NODE_37542_length_245_cov_0.866279_g37346_i0 | PRJNA1078753 | 37542 | 245 | 0.866279 | 2.12238355 | Deinococcus terrestris | 2651870 | Bacteria | Bacteria | 155 | 2.19e-42 | NR | WP_152872434.1 | 2651870 | g37346 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 243 | 1 | 133 | 213 | WP_152872434.1 hypothetical protein [Deinococcus terrestris] | diamond | 243 | 155 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus terrestris | ||
| 27604752 | 27604752 | PRJNA1078753_P_NODE_38824_length_244_cov_0.900585_g38628_i0 | PRJNA1078753 | 38824 | 244 | 0.900585 | 2.1974274 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 55.1 | 5.48e-7 | NR | MDQ3459849.1 | 1913990 | g38628 | i0 | 58.3 | 0.590163934426229 | 48 | 20 | 59 | 0 | 144 | 1 | 15 | 62 | MDQ3459849.1 DUF3368 domain-containing protein [Deinococcota bacterium] | diamond | 144 | 55.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 27888615 | 27888615 | PRJNA1078753_P_NODE_13705_length_317_cov_1.262295_g13509_i0 | PRJNA1078753 | 13705 | 317 | 1.262295 | 4.00147515 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 44.7 | 0.0166 | NR | WP_295822443.1 | 158789 | g13509 | i0 | 26.6 | 0.889589905362776 | 94 | 69 | 89 | 0 | 313 | 32 | 214 | 307 | WP_295822443.1 biotin--[acetyl-CoA-carboxylase] ligase [uncultured Deinococcus sp.] | diamond | 282 | 44.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 27983421 | 27983421 | PRJNA1078753_P_NODE_23605_length_264_cov_1.366492_g23409_i0 | PRJNA1078753 | 23605 | 264 | 1.366492 | 3.60753888 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 114 | 3.1500000000000004e-27 | NR | CAA9587245.1 | 543023 | g23409 | i0 | 90.6 | 0.602272727272727 | 53 | 5 | 60.2 | 0 | 1 | 159 | 627 | 679 | CAA9587245.1 MAG: hypothetical protein AVDCRST_MAG86-3969 [uncultured Truepera sp.] | diamond | 159 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 28930749 | 28930749 | PRJNA1078753_P_NODE_38788_length_244_cov_0.900585_g38592_i0 | PRJNA1078753 | 38788 | 244 | 0.900585 | 2.1974274 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 141 | 4.029999999999999e-40 | NR | WP_013176562.1 | 332249 | g38592 | i0 | 80.2 | 0.995901639344262 | 81 | 16 | 99.6 | 0 | 2 | 244 | 92 | 172 | WP_013176562.1 rhomboid family intramembrane serine protease [Truepera radiovictrix] | diamond | 243 | 141 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 28962490 | 28962490 | PRJNA1078753_P_NODE_41908_length_242_cov_0.911243_g41712_i0 | PRJNA1078753 | 41908 | 242 | 0.911243 | 2.20520806 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 157 | 2.09e-44 | NR | WP_177183184.1 | 856736 | g41712 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 1 | 240 | 68 | 147 | WP_177183184.1 YihY/virulence factor BrkB family protein [Deinococcus reticulitermitis] | diamond | 240 | 157 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 29025738 | 29025738 | PRJNA1078753_P_NODE_43668_length_241_cov_0.916667_g43472_i0 | PRJNA1078753 | 43668 | 241 | 0.916667 | 2.20916747 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 129 | 1.6200000000000002e-36 | NR | CAA9564461.1 | 543023 | g43472 | i0 | 86.3 | 0.995850622406639 | 80 | 11 | 99.6 | 0 | 2 | 241 | 60 | 139 | CAA9564461.1 MAG: Alcohol dehydrogenase, partial [uncultured Truepera sp.] | diamond | 240 | 129 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 29080083 | 29080083 | PRJNA1078753_P_NODE_2548_length_623_cov_2.203636_g2357_i0 | PRJNA1078753 | 2548 | 623 | 2.203636 | 13.72865228 | Deinococcus | 1298 | Bacteria | Bacteria | 177 | 5.799999999999999e-49 | NR | WP_184136467.1 | 662880 | g2357 | i0 | 53.2 | 8.75922953451043 | 203 | 79 | 97.8 | 4 | 6 | 614 | 239 | 425 | WP_184136467.1 S8 family peptidase [Deinococcus humi] | diamond | 5457 | 178 | 0.99438202247191 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus humi | ||
| 30162014 | 30162014 | PRJNA1078753_P_NODE_26512_length_252_cov_1.720670_g26316_i0 | PRJNA1078753 | 26512 | 252 | 1.72067 | 4.3360884 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 50.1 | 5.11e-5 | NR | MDR2137471.1 | 2053624 | g26316 | i0 | 49 | 0.607142857142857 | 51 | 18 | 51.2 | 2 | 130 | 2 | 23 | 73 | MDR2137471.1 TerD family protein [Synergistaceae bacterium] | diamond | 153 | 50.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30446803 | 30446803 | PRJNA1078753_P_NODE_30233_length_249_cov_0.875000_g30037_i0 | PRJNA1078753 | 30233 | 249 | 0.875 | 2.17875 | Thermus scotoductus | 37636 | Bacteria | Bacteria | 93.6 | 2.89e-21 | NR | WP_126199729.1 | 37636 | g30037 | i0 | 56.1 | 2.96385542168675 | 82 | 35 | 98.8 | 1 | 248 | 3 | 124 | 204 | WP_126199729.1 hypothetical protein [Thermus scotoductus] | diamond | 738 | 93.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 30754059 | 30754059 | PRJNA1078753_P_NODE_42134_length_242_cov_0.911243_g41938_i0 | PRJNA1078753 | 42134 | 242 | 0.911243 | 2.20520806 | Deinococcus | 1298 | Bacteria | Bacteria | 106 | 5.43e-25 | NR | WP_092263638.1 | 856736 | g41938 | i0 | 67.1 | 2.34297520661157 | 85 | 23 | 99.2 | 2 | 2 | 241 | 73 | 157 | WP_092263638.1 DUF1963 domain-containing protein [Deinococcus reticulitermitis] | diamond | 567 | 106 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 31584631 | 31584631 | PRJNA1078753_P_NODE_19096_length_282_cov_1.473684_g18900_i0 | PRJNA1078753 | 19096 | 282 | 1.473684 | 4.15578888 | Deinococcus multiflagellatus | 1656887 | Bacteria | Bacteria | 89.4 | 2.54e-18 | NR | WP_224609810.1 | 1656887 | g18900 | i0 | 62.2 | 1.57446808510638 | 74 | 28 | 78.7 | 0 | 225 | 4 | 8 | 81 | WP_224609810.1 hypothetical protein [Deinococcus multiflagellatus] | diamond | 444 | 89.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus multiflagellatus | ||
| 32240516 | 32240516 | PRJNA1078753_P_NODE_8978_length_370_cov_1.037037_g8782_i0 | PRJNA1078753 | 8978 | 370 | 1.037037 | 3.8370369 | Petrotogaceae | 1643949 | Bacteria | Bacteria | 169 | 6.25e-49 | NR | WP_103067684.1 | 156203 | g8782 | i0 | 63.6 | 6.83513513513514 | 121 | 44 | 98.1 | 0 | 365 | 3 | 121 | 241 | WP_103067684.1 low-specificity L-threonine aldolase [Petrotoga olearia] | diamond | 2529 | 170 | 0.994117647058824 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotoga | Petrotoga olearia | ||
| 32754145 | 32754145 | PRJNA1078753_P_NODE_26300_length_253_cov_1.533333_g26104_i0 | PRJNA1078753 | 26300 | 253 | 1.533333 | 3.87933249 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 136 | 3.41e-36 | NR | WP_184026617.1 | 1665626 | g26104 | i0 | 90.1 | 0.960474308300395 | 81 | 6 | 93.7 | 1 | 252 | 16 | 309 | 389 | WP_184026617.1 SpoIID/LytB domain-containing protein [Deinococcus budaensis] | diamond | 243 | 136 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis | ||
| 32817104 | 32817104 | PRJNA1078753_P_NODE_33440_length_247_cov_0.885057_g33244_i0 | PRJNA1078753 | 33440 | 247 | 0.885057 | 2.18609079 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 135 | 4.4e-37 | NR | WP_184029958.1 | 1665626 | g33244 | i0 | 81.5 | 0.983805668016194 | 81 | 15 | 98.4 | 0 | 3 | 245 | 2 | 82 | WP_184029958.1 alpha/beta hydrolase [Deinococcus budaensis] | diamond | 243 | 135 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis |
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);;