contig_metadata
16 rows where bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 846440 | 846440 | PRJNA861969_P_NODE_33121_length_249_cov_0.875000_g32890_i0 | PRJNA861969 | 33121 | 249 | 0.875 | 2.17875 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 147 | 6.85e-41 | NR | WP_119765991.1 | 2320857 | g32890 | i0 | 90.2 | 0.987951807228916 | 82 | 8 | 98.8 | 0 | 2 | 247 | 2 | 83 | WP_119765991.1 alanine dehydrogenase [Deinococcus cavernae] | diamond | 246 | 147 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 2121778 | 2121778 | PRJNA861969_P_NODE_29782_length_254_cov_1.574586_g29551_i0 | PRJNA861969 | 29782 | 254 | 1.574586 | 3.99944844 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 159 | 1.32e-34 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g29551 | i0 | 84.81 | 0.622047244094488 | 158 | 24 | 62 | 0 | 1 | 158 | 298355 | 298512 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 158 | 159 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 2511938 | 2511938 | PRJNA861969_P_NODE_26842_length_267_cov_1.376289_g26611_i0 | PRJNA861969 | 26842 | 267 | 1.376289 | 3.67469163 | Thermaceae | 188786 | Bacteria | Bacteria | 244 | 3.76e-60 | NTclustered | gi|2440484278|gb|CP046617.1| | 88190 | g26611 | i0 | 99.259 | 14.8464419475655 | 135 | 1 | 76 | 0 | 1 | 135 | 2038041 | 2037907 | Thermus antranikianii strain JCM 19900 chromosome, complete genome | blastn | 3964 | 246 | 0.991869918699187 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus antranikianii | ||
| 3397002 | 3397002 | PRJNA861969_P_NODE_22823_length_285_cov_2.000000_g22592_i0 | PRJNA861969 | 22823 | 285 | 2 | 5.7 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 363 | 1.07e-95 | NTclustered | gi|2108366028|gb|CP070651.1| | 2026798 | g22592 | i0 | 90.036 | 231.642105263158 | 281 | 27 | 98 | 1 | 1 | 280 | 6807 | 6527 | MAG: Trueperaceae bacterium isolate bin86 chromosome | blastn | 66018 | 363 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 4674840 | 4674840 | PRJNA861969_P_NODE_28984_length_257_cov_2.244565_g28753_i0 | PRJNA861969 | 28984 | 257 | 2.244565 | 5.76853205 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 475 | 1.1699999999999999e-129 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g28753 | i0 | 100 | 3.90661478599222 | 257 | 0 | 100 | 0 | 1 | 257 | 1731008 | 1731264 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 1004 | 475 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 5949929 | 5949929 | PRJNA861969_P_NODE_41345_length_241_cov_0.916667_g41114_i0 | PRJNA861969 | 41345 | 241 | 0.916667 | 2.20916747 | Calidithermus terrae | 1408545 | Bacteria | Bacteria | 139 | 9.389999999999999e-40 | NR | WP_119314407.1 | 1408545 | g41114 | i0 | 90.8 | 0.946058091286307 | 76 | 7 | 94.6 | 0 | 1 | 228 | 9 | 84 | WP_119314407.1 DNA polymerase ligase N-terminal domain-containing protein [Calidithermus terrae] | diamond | 228 | 139 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus terrae | ||
| 13599991 | 13599991 | PRJNA861969_P_NODE_24471_length_278_cov_1.297561_g24240_i0 | PRJNA861969 | 24471 | 278 | 1.297561 | 3.60721958 | Thermus brockianus | 56956 | Bacteria | Bacteria | 185 | 2.4199999999999998e-42 | NTclustered | gi|1102955210|gb|CP016312.1| | 56956 | g24240 | i0 | 81.092 | 31.2769784172662 | 238 | 39 | 97 | 6 | 44 | 278 | 1534272 | 1534038 | Thermus brockianus strain GE-1 chromosome, complete genome | blastn | 8695 | 185 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 13599999 | 13599999 | PRJNA861969_P_NODE_24851_length_276_cov_1.517241_g24620_i0 | PRJNA861969 | 24851 | 276 | 1.517241 | 4.18758516 | Deinococcus sp. AB2017081 | 3093660 | Bacteria | Bacteria | 350 | 8.04e-92 | NTclustered | gi|2636768990|gb|CP140098.1| | 3093660 | g24620 | i0 | 89.568 | 31.0579710144928 | 278 | 25 | 100 | 4 | 1 | 276 | 795798 | 796073 | Deinococcus sp. AB2017081 chromosome, complete genome | blastn | 8572 | 350 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. AB2017081 | ||
| 14874565 | 14874565 | PRJNA861969_P_NODE_38612_length_244_cov_0.900585_g38381_i0 | PRJNA861969 | 38612 | 244 | 0.900585 | 2.1974274 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 237 | 5.6600000000000005e-58 | NTclustered | gi|1819263924|gb|CP049359.1| | 1288484 | g38381 | i0 | 92.262 | 0.688524590163934 | 168 | 12 | 68 | 1 | 76 | 242 | 118116 | 118283 | Deinococcus wulumuqiensis R12 plasmid unnamed2, complete sequence | blastn | 168 | 237 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 15264426 | 15264426 | PRJNA861969_P_NODE_38292_length_244_cov_0.900585_g38061_i0 | PRJNA861969 | 38292 | 244 | 0.900585 | 2.1974274 | Thermus | 270 | Bacteria | Bacteria | 446 | 8.639999999999999e-121 | NTclustered | gi|2440484278|gb|CP046617.1| | 88190 | g38061 | i0 | 99.59 | 11.4672131147541 | 244 | 1 | 100 | 0 | 1 | 244 | 241254 | 241497 | Thermus antranikianii strain JCM 19900 chromosome, complete genome | blastn | 2798 | 446 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus antranikianii | ||
| 19972883 | 19972883 | PRJNA861969_P_NODE_24396_length_278_cov_1.502439_g24165_i0 | PRJNA861969 | 24396 | 278 | 1.502439 | 4.17678042 | Thermus brockianus | 56956 | Bacteria | Bacteria | 298 | 2.98e-76 | NTclustered | gi|1102955210|gb|CP016312.1| | 56956 | g24165 | i0 | 85.971 | 2.88129496402878 | 278 | 39 | 100 | 0 | 1 | 278 | 453747 | 454024 | Thermus brockianus strain GE-1 chromosome, complete genome | blastn | 801 | 298 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 27308155 | 27308155 | PRJNA861969_P_NODE_39423_length_243_cov_0.905882_g39192_i0 | PRJNA861969 | 39423 | 243 | 0.905882 | 2.20129326 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 110 | 8.54e-27 | NR | WP_119761192.1 | 2320857 | g39192 | i0 | 63.8 | 0.987654320987654 | 80 | 29 | 98.8 | 0 | 242 | 3 | 111 | 190 | WP_119761192.1 3'-5' exonuclease [Deinococcus cavernae] | diamond | 240 | 110 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 28507910 | 28507910 | PRJNA861969_P_NODE_33367_length_249_cov_0.875000_g33136_i0 | PRJNA861969 | 33367 | 249 | 0.875 | 2.17875 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 102 | 3.31e-24 | NR | WP_013177751.1 | 332249 | g33136 | i0 | 89.3 | 0.674698795180723 | 56 | 6 | 67.5 | 0 | 170 | 3 | 1 | 56 | WP_013177751.1 succinate--CoA ligase subunit alpha [Truepera radiovictrix] | diamond | 168 | 102 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 30466141 | 30466141 | PRJNA861969_P_NODE_25753_length_272_cov_1.402010_g25522_i0 | PRJNA861969 | 25753 | 272 | 1.40201 | 3.8134672 | Meiothermus sp. QL-1 | 2058095 | Bacteria | Bacteria | 62.4 | 6.22e-9 | NR | WP_114799723.1 | 2058095 | g25522 | i0 | 59.7 | 0.794117647058823 | 72 | 26 | 79.4 | 2 | 258 | 43 | 400 | 468 | WP_114799723.1 xylulokinase [Meiothermus sp. QL-1] | diamond | 216 | 62.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. QL-1 | ||
| 32014957 | 32014957 | PRJNA861969_P_NODE_23158_length_284_cov_1.203791_g22927_i0 | PRJNA861969 | 23158 | 284 | 1.203791 | 3.41876644 | Calidithermus timidus | 307124 | Bacteria | Bacteria | 105 | 3.2299999999999997e-24 | NR | WP_018465780.1 | 307124 | g22927 | i0 | 100 | 0.517605633802817 | 49 | 0 | 51.8 | 0 | 6 | 152 | 14 | 62 | WP_018465780.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Calidithermus timidus] | diamond | 147 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus timidus | ||
| 32300085 | 32300085 | PRJNA861969_P_NODE_31079_length_251_cov_0.865169_g30848_i0 | PRJNA861969 | 31079 | 251 | 0.865169 | 2.17157419 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 76.6 | 4.71e-14 | NR | WP_386842130.1 | 536443 | g30848 | i0 | 100 | 0.430278884462151 | 36 | 0 | 43 | 0 | 143 | 250 | 1 | 36 | WP_386842130.1 NAD-dependent malic enzyme [Deinococcus taklimakanensis] | diamond | 108 | 76.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis |
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);;