contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6516965 | 6516965 | PRJEB76780_P_NODE_9466_length_264_cov_1.376963_g9366_i0 | PRJEB76780 | 9466 | 264 | 1.376963 | 3.63518232 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 172 | 1.88e-50 | NR | WP_181692297.1 | 2750669 | g9366 | i0 | 95.4 | 1.97727272727273 | 87 | 4 | 98.9 | 0 | 263 | 3 | 104 | 190 | WP_181692297.1 7,8-didemethyl-8-hydroxy-5-deazariboflavin synthase subunit CofG [Natronomonas sp. LN261] | diamond | 522 | 172 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 15441189 | 15441189 | PRJEB76780_P_NODE_12293_length_246_cov_0.901734_g12193_i0 | PRJEB76780 | 12293 | 246 | 0.901734 | 2.21826564 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 110 | 2.63e-26 | NR | MFB6086179.1 | 1980530 | g12193 | i0 | 65.4 | 2.96341463414634 | 81 | 28 | 98.8 | 0 | 3 | 245 | 414 | 494 | MFB6086179.1 cobyric acid synthase [Halodesulfurarchaeum sp.] | diamond | 729 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 23090675 | 23090675 | PRJEB76780_P_NODE_12459_length_245_cov_0.906977_g12359_i0 | PRJEB76780 | 12459 | 245 | 0.906977 | 2.22209365 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 159 | 5.229999999999998e-43 | NR | WP_181691439.1 | 2750669 | g12359 | i0 | 96.3 | 0.991836734693878 | 81 | 3 | 99.2 | 0 | 2 | 244 | 141 | 221 | WP_181691439.1 DNA mismatch repair protein MutS [Natronomonas sp. LN261] | diamond | 243 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 26622629 | 26622629 | PRJEB76780_P_NODE_11761_length_248_cov_0.891429_g11661_i0 | PRJEB76780 | 11761 | 248 | 0.891429 | 2.21074392 | Haloferacaceae archaeon | 2080321 | Archaea | Archaea | 141 | 2.1199999999999996e-37 | NR | MFB6160220.1 | 2080321 | g11661 | i0 | 86.4 | 0.979838709677419 | 81 | 11 | 98 | 0 | 248 | 6 | 83 | 163 | MFB6160220.1 rhodanese-like domain-containing protein [Haloferacaceae archaeon] | diamond | 243 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon | ||
| 26773812 | 26773812 | PRJEB76780_P_NODE_8061_length_285_cov_1.471698_g7961_i0 | PRJEB76780 | 8061 | 285 | 1.471698 | 4.1943393 | Methanobacteriati | 3366610 | Archaea | Archaea | 90.5 | 6.93e-19 | NR | OFV67421.1 | 1838285 | g7961 | i0 | 52 | 1.57894736842105 | 75 | 35 | 78.9 | 1 | 285 | 61 | 91 | 164 | OFV67421.1 MAG: ATPase [Candidatus Syntrophoarchaeum caldarius] | diamond | 450 | 91.3 | 0.991237677984666 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Syntropharchaeum | Candidatus Syntropharchaeum caldarium | ||
| 26781153 | 26781153 | PRJEB76780_P_NODE_11661_length_248_cov_0.891429_g11561_i0 | PRJEB76780 | 11661 | 248 | 0.891429 | 2.21074392 | Haloarcula sp. K1 | 1622207 | Archaea | Archaea | 157 | 1.6799999999999994e-42 | NR | WP_064289137.1 | 1622207 | g11561 | i0 | 93.9 | 0.991935483870968 | 82 | 5 | 99.2 | 0 | 246 | 1 | 370 | 451 | WP_064289137.1 ATP-dependent DNA helicase [Haloarcula sp. K1] | diamond | 246 | 157 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula sp. K1 | |
| 26876317 | 26876317 | PRJEB76780_P_NODE_8421_length_279_cov_1.514563_g8321_i0 | PRJEB76780 | 8421 | 279 | 1.514563 | 4.22563077 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 121 | 6.079999999999999e-31 | NR | WP_181691015.1 | 2750669 | g8321 | i0 | 93.1 | 0.774193548387097 | 72 | 3 | 77.4 | 1 | 216 | 1 | 1 | 70 | WP_181691015.1 S1C family serine protease [Natronomonas sp. LN261] | diamond | 216 | 121 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27097377 | 27097377 | PRJEB76780_P_NODE_11342_length_249_cov_0.886364_g11242_i0 | PRJEB76780 | 11342 | 249 | 0.886364 | 2.20704636 | Halosimplex pelagicum | 869886 | Archaea | Archaea | 94.4 | 2.25e-20 | NR | WP_179922740.1 | 869886 | g11242 | i0 | 59.8 | 0.987951807228916 | 82 | 32 | 98.8 | 1 | 247 | 2 | 167 | 247 | WP_179922740.1 acyl-CoA/acyl-ACP dehydrogenase [Halosimplex pelagicum] | diamond | 246 | 94.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex pelagicum | |
| 28076448 | 28076448 | PRJEB76780_P_NODE_13405_length_242_cov_0.923077_g13305_i0 | PRJEB76780 | 13405 | 242 | 0.923077 | 2.23384634 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 161 | 4.43e-49 | NR | WP_370464959.1 | 2750669 | g13305 | i0 | 97.5 | 2.97520661157025 | 80 | 2 | 99.2 | 0 | 241 | 2 | 43 | 122 | WP_370464959.1 PH domain-containing protein [Natronomonas sp. LN261] | diamond | 720 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 28107971 | 28107971 | PRJEB76780_P_NODE_11405_length_249_cov_0.886364_g11305_i0 | PRJEB76780 | 11405 | 249 | 0.886364 | 2.20704636 | Halodesulfurarchaeum sp. HSR-GB | 3074077 | Archaea | Archaea | 112 | 1.32e-26 | NR | WP_310553595.1 | 3074077 | g11305 | i0 | 62.5 | 0.963855421686747 | 80 | 30 | 96.4 | 0 | 1 | 240 | 31 | 110 | WP_310553595.1 histidine kinase N-terminal 7TM domain-containing protein [Halodesulfurarchaeum sp. HSR-GB] | diamond | 240 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. HSR-GB | |
| 28202632 | 28202632 | PRJEB76780_P_NODE_12546_length_245_cov_0.906977_g12446_i0 | PRJEB76780 | 12546 | 245 | 0.906977 | 2.22209365 | Halorubrum laminariae | 1433523 | Archaea | Archaea | 61.6 | 8.1e-9 | NR | WP_256418948.1 | 1433523 | g12446 | i0 | 96.7 | 0.36734693877551 | 30 | 1 | 36.7 | 0 | 90 | 1 | 1 | 30 | WP_256418948.1 Cdc6/Cdc18 family protein [Halorubrum laminariae] | diamond | 90 | 61.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum laminariae | |
| 28234162 | 28234162 | PRJEB76780_P_NODE_12786_length_244_cov_0.912281_g12686_i0 | PRJEB76780 | 12786 | 244 | 0.912281 | 2.22596564 | Halobacterium yunchengense | 3108497 | Archaea | Archaea | 92.8 | 4.59e-21 | NR | WP_336035552.1 | 3108497 | g12686 | i0 | 66.7 | 1.52459016393443 | 63 | 21 | 77.5 | 0 | 1 | 189 | 164 | 226 | WP_336035552.1 HD domain-containing protein [Halobacterium yunchengense] | diamond | 372 | 92.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium yunchengense | |
| 28960889 | 28960889 | PRJEB76780_P_NODE_10968_length_251_cov_0.876404_g10868_i0 | PRJEB76780 | 10968 | 251 | 0.876404 | 2.19977404 | Halorubrum trueperi | 2004704 | Archaea | Archaea | 123 | 3.77e-31 | NR | WP_379766111.1 | 2004704 | g10868 | i0 | 75.6 | 1.9601593625498 | 82 | 20 | 98 | 0 | 247 | 2 | 11 | 92 | WP_379766111.1 hypothetical protein [Halorubrum trueperi] | diamond | 492 | 123 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trueperi | |
| 29244819 | 29244819 | PRJEB76780_P_NODE_11869_length_247_cov_0.896552_g11769_i0 | PRJEB76780 | 11869 | 247 | 0.896552 | 2.21448344 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 66.2 | 1.15e-10 | NR | WP_332320319.1 | 1980530 | g11769 | i0 | 61.7 | 0.57085020242915 | 47 | 18 | 57.1 | 0 | 245 | 105 | 229 | 275 | WP_332320319.1 DUF1109 domain-containing protein [Halodesulfurarchaeum sp.] | diamond | 141 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 29339618 | 29339618 | PRJEB76780_P_NODE_12209_length_246_cov_0.901734_g12109_i0 | PRJEB76780 | 12209 | 246 | 0.901734 | 2.21826564 | Halorientalis sp. | 1931229 | Archaea | Archaea | 89 | 1.28e-19 | NR | MFB6143051.1 | 1931229 | g12109 | i0 | 54.3 | 1.97560975609756 | 81 | 37 | 98.8 | 0 | 3 | 245 | 57 | 137 | MFB6143051.1 helix-turn-helix domain-containing protein [Halorientalis sp.] | diamond | 486 | 89 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis sp. | |
| 29939652 | 29939652 | PRJEB76780_P_NODE_8411_length_279_cov_1.514563_g8311_i0 | PRJEB76780 | 8411 | 279 | 1.514563 | 4.22563077 | Halodesulfurarchaeum sp. HSR-GB | 3074077 | Archaea | Archaea | 103 | 2.3499999999999994e-23 | NR | WP_310554221.1 | 3074077 | g8311 | i0 | 53.8 | 0.978494623655914 | 91 | 41 | 97.8 | 1 | 274 | 2 | 89 | 178 | WP_310554221.1 DEAD/DEAH box helicase [Halodesulfurarchaeum sp. HSR-GB] | diamond | 273 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. HSR-GB | |
| 31013657 | 31013657 | PRJEB76780_P_NODE_12535_length_245_cov_0.906977_g12435_i0 | PRJEB76780 | 12535 | 245 | 0.906977 | 2.22209365 | Haloarcula sebkhae | 932660 | Archaea | Archaea | 59.3 | 5.33e-8 | NR | WP_188979057.1 | 932660 | g12435 | i0 | 55.2 | 0.710204081632653 | 58 | 26 | 71 | 0 | 216 | 43 | 1 | 58 | WP_188979057.1 hypothetical protein [Haloarcula sebkhae] | diamond | 174 | 59.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula sebkhae | |
| 32247545 | 32247545 | PRJEB76780_P_NODE_9098_length_269_cov_1.418367_g8998_i0 | PRJEB76780 | 9098 | 269 | 1.418367 | 3.81540723 | unclassified Halalkaliarchaeum | 2678344 | Archaea | Archaea | 179 | 1.34e-53 | NR | WP_259534103.1 | 2678344 | g8998 | i0 | 96.6 | 0.992565055762082 | 89 | 3 | 99.3 | 0 | 1 | 267 | 122 | 210 | WP_259534103.1 MULTISPECIES: GDP-mannose 4,6-dehydratase [unclassified Halalkaliarchaeum] | diamond | 267 | 179 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halalkaliarchaeum | ||
| 32373894 | 32373894 | PRJEB76780_P_NODE_13019_length_243_cov_0.917647_g12919_i0 | PRJEB76780 | 13019 | 243 | 0.917647 | 2.22988221 | Haloarchaeobius litoreus | 755306 | Archaea | Archaea | 85.5 | 4.2e-19 | NR | WP_256398480.1 | 755306 | g12919 | i0 | 91.1 | 0.555555555555556 | 45 | 4 | 55.6 | 0 | 3 | 137 | 95 | 139 | WP_256398480.1 universal stress protein [Haloarchaeobius litoreus] | diamond | 135 | 85.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius litoreus | |
| 32405482 | 32405482 | PRJEB76780_P_NODE_3739_length_422_cov_1.306590_g3639_i0 | PRJEB76780 | 3739 | 422 | 1.30659 | 5.5138098 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 243 | 4.75e-78 | NR | WP_259517405.1 | 2866382 | g3639 | i0 | 86.4 | 0.995260663507109 | 140 | 19 | 99.5 | 0 | 1 | 420 | 56 | 195 | WP_259517405.1 tyrosine-type recombinase/integrase [Halanaeroarchaeum sp. HSR-CO] | diamond | 420 | 243 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 32468914 | 32468914 | PRJEB76780_P_NODE_13619_length_228_cov_2.012903_g13519_i0 | PRJEB76780 | 13619 | 228 | 2.012903 | 4.5894188400000004 | Halanaeroarchaeum sp. | 1963275 | Archaea | Archaea | 115 | 1.63e-28 | NR | MFB6124635.1 | 1963275 | g13519 | i0 | 70.7 | 1.97368421052632 | 75 | 22 | 98.7 | 0 | 227 | 3 | 34 | 108 | MFB6124635.1 glycerate kinase [Halanaeroarchaeum sp.] | diamond | 450 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 32500521 | 32500521 | PRJEB76780_P_NODE_10859_length_251_cov_0.876404_g10759_i0 | PRJEB76780 | 10859 | 251 | 0.876404 | 2.19977404 | Haloplanus sp. GCM1 | 1961696 | Archaea | Archaea | 111 | 2.56e-29 | NR | WP_379797224.1 | 3252679 | g10759 | i0 | 67.5 | 1.97211155378486 | 83 | 27 | 99.2 | 0 | 250 | 2 | 13 | 95 | WP_379797224.1 hypothetical protein [Haloplanus sp. GCM10025708] | diamond | 495 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GCM10025708 | |
| 32752550 | 32752550 | PRJEB76780_P_NODE_11740_length_248_cov_0.891429_g11640_i0 | PRJEB76780 | 11740 | 248 | 0.891429 | 2.21074392 | Natronococcus pandeyae | 2055836 | Archaea | Archaea | 163 | 2.49e-46 | NR | WP_148856307.1 | 2055836 | g11640 | i0 | 95.1 | 1.98387096774194 | 82 | 4 | 99.2 | 0 | 246 | 1 | 264 | 345 | WP_148856307.1 HD domain-containing protein [Natronococcus pandeyae] | diamond | 492 | 163 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus pandeyae |
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);;