contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5126340 | 5126340 | PRJEB28062_P_NODE_127525_length_246_cov_0.890173_g125161_i0 | PRJEB28062 | 127525 | 246 | 0.890173 | 2.18982558 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 143 | 7.55e-41 | NR | WP_181692859.1 | 2750669 | g125161 | i0 | 94.7 | 0.914634146341463 | 75 | 4 | 91.5 | 0 | 245 | 21 | 112 | 186 | WP_181692859.1 RNase P subunit p30 family protein [Natronomonas sp. LN261] | diamond | 225 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 14053775 | 14053775 | PRJEB28062_P_NODE_82752_length_368_cov_3.176271_g80390_i0 | PRJEB28062 | 82752 | 368 | 3.176271 | 11.68867728 | Halolamina sp. | 1940283 | Archaea | Archaea | 194 | 1.88e-56 | NR | MFB6126514.1 | 1940283 | g80390 | i0 | 85.6 | 0.904891304347826 | 111 | 16 | 90.5 | 0 | 358 | 26 | 1 | 111 | MFB6126514.1 aldehyde ferredoxin oxidoreductase C-terminal domain-containing protein [Halolamina sp.] | diamond | 333 | 194 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. | |
| 26875306 | 26875306 | PRJEB28062_P_NODE_34021_length_629_cov_7.404676_g31708_i0 | PRJEB28062 | 34021 | 629 | 7.404676 | 46.57541204 | Natronococcus pandeyae | 2055836 | Archaea | Archaea | 96.3 | 1.14e-21 | NR | WP_148857360.1 | 2055836 | g31708 | i0 | 44.1 | 0.529411764705882 | 111 | 60 | 52.9 | 1 | 197 | 529 | 8 | 116 | WP_148857360.1 DUF7344 domain-containing protein [Natronococcus pandeyae] | diamond | 333 | 96.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus pandeyae | |
| 27254363 | 27254363 | PRJEB28062_P_NODE_96783_length_324_cov_14.645418_g94421_i0 | PRJEB28062 | 96783 | 324 | 14.645418 | 47.45115432 | Salinigranum halophilum | 2565931 | Archaea | Archaea | 127 | 6.95e-33 | NR | WP_136592350.1 | 2565931 | g94421 | i0 | 58.2 | 0.907407407407407 | 98 | 41 | 90.7 | 0 | 16 | 309 | 136 | 233 | WP_136592350.1 glycosyltransferase family 4 protein [Salinigranum halophilum] | diamond | 294 | 127 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum halophilum | |
| 27317846 | 27317846 | PRJEB28062_P_NODE_21903_length_799_cov_36.716253_g19755_i0 | PRJEB28062 | 21903 | 799 | 36.716253 | 293.36286147 | Halovivax asiaticus | 332953 | Archaea | Archaea | 293 | 2.2599999999999992e-96 | NR | WP_152415784.1 | 332953 | g19755 | i0 | 63.8 | 0.788485607008761 | 210 | 74 | 78.8 | 1 | 652 | 23 | 12 | 219 | WP_152415784.1 hypothetical protein [Halovivax asiaticus] | diamond | 630 | 293 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax asiaticus | |
| 27444338 | 27444338 | PRJEB28062_P_NODE_104603_length_301_cov_3.105263_g102240_i0 | PRJEB28062 | 104603 | 301 | 3.105263 | 9.34684163 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 82 | 1.16e-15 | NR | HNI41187.1 | 2485498 | g102240 | i0 | 58.1 | 1.20598006644518 | 62 | 26 | 61.8 | 0 | 114 | 299 | 18 | 79 | HNI41187.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 363 | 82 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 27444374 | 27444374 | PRJEB28062_P_NODE_64203_length_434_cov_1.246537_g61842_i0 | PRJEB28062 | 64203 | 434 | 1.246537 | 5.40997058 | Haladaptatus pallidirubidus | 1008152 | Archaea | Archaea | 52.4 | 1.13e-4 | NR | WP_227775268.1 | 1008152 | g61842 | i0 | 25.9 | 0.933179723502304 | 135 | 85 | 90.6 | 5 | 416 | 24 | 324 | 447 | WP_227775268.1 phage portal protein [Haladaptatus pallidirubidus] | diamond | 405 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus pallidirubidus | |
| 27791460 | 27791460 | PRJEB28062_P_NODE_19224_length_858_cov_34.718471_g17206_i0 | PRJEB28062 | 19224 | 858 | 34.718471 | 297.88448118 | Halohasta litorea | 869891 | Archaea | Archaea | 255 | 2.64e-82 | NR | WP_256396967.1 | 869891 | g17206 | i0 | 90.5 | 0.513986013986014 | 147 | 14 | 51.4 | 0 | 465 | 25 | 2 | 148 | WP_256396967.1 DUF7332 family protein [Halohasta litorea] | diamond | 441 | 255 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litorea | |
| 28738605 | 28738605 | PRJEB28062_P_NODE_64047_length_434_cov_13.354571_g61686_i0 | PRJEB28062 | 64047 | 434 | 13.354571 | 57.95883814 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 70.5 | 9.53e-13 | NR | MFA5559544.1 | 2666341 | g61686 | i0 | 57.6 | 0.407834101382488 | 59 | 22 | 38.7 | 1 | 186 | 19 | 1 | 59 | MFA5559544.1 hypothetical protein [Methanofastidiosum sp.] | diamond | 177 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 28770098 | 28770098 | PRJEB28062_P_NODE_59067_length_456_cov_10.657963_g56708_i0 | PRJEB28062 | 59067 | 456 | 10.657963 | 48.60031128 | Haloarchaeobius iranensis | 996166 | Archaea | Archaea | 84 | 1.43e-15 | NR | WP_089734040.1 | 996166 | g56708 | i0 | 59 | 0.802631578947368 | 61 | 25 | 40.1 | 0 | 254 | 436 | 7 | 67 | WP_089734040.1 hypothetical protein [Haloarchaeobius iranensis] | diamond | 366 | 84 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius iranensis | |
| 28864807 | 28864807 | PRJEB28062_P_NODE_20828_length_821_cov_126.056150_g18734_i0 | PRJEB28062 | 20828 | 821 | 126.05615 | 1034.9209915 | Halomarina rubra | 2071873 | Archaea | Archaea | 164 | 6.529999999999998e-43 | NR | WP_250872430.1 | 2071873 | g18734 | i0 | 37.9 | 0.993909866017052 | 272 | 129 | 97.6 | 9 | 11 | 811 | 261 | 497 | WP_250872430.1 hypothetical protein [Halomarina rubra] | diamond | 816 | 164 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina rubra | |
| 29054483 | 29054483 | PRJEB28062_P_NODE_65808_length_427_cov_10.285311_g63447_i0 | PRJEB28062 | 65808 | 427 | 10.285311 | 43.91827797 | Candidatus Methanoxibalbensis ujae | 2977099 | Archaea | Archaea | 47 | 0.00351 | NR | MCW7078263.1 | 2977099 | g63447 | i0 | 41.8 | 0.814988290398126 | 55 | 32 | 38.6 | 0 | 410 | 246 | 41 | 95 | MCW7078263.1 hypothetical protein [Candidatus Methanoxibalbensis ujae] | diamond | 348 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanospirareceae | Candidatus Methanoxibalbensis | Candidatus Methanoxibalbensis ujae | |
| 29054486 | 29054486 | PRJEB28062_P_NODE_70048_length_411_cov_6.408284_g67687_i0 | PRJEB28062 | 70048 | 411 | 6.408284 | 26.33804724 | Halobellus clavatus | 660517 | Archaea | Archaea | 46.6 | 0.00409 | NR | WP_089768475.1 | 660517 | g67687 | i0 | 63.9 | 0.262773722627737 | 36 | 13 | 26.3 | 0 | 149 | 256 | 46 | 81 | WP_089768475.1 GNAT family N-acetyltransferase [Halobellus clavatus] | diamond | 108 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus clavatus | |
| 29685454 | 29685454 | PRJEB28062_P_NODE_107930_length_292_cov_2.009132_g105567_i0 | PRJEB28062 | 107930 | 292 | 2.009132 | 5.86666544 | Methanothrix sp. | 90426 | Archaea | Archaea | 95.5 | 1.52e-21 | NR | MDH7597985.1 | 90426 | g105567 | i0 | 73.1 | 0.688356164383562 | 67 | 18 | 68.8 | 0 | 91 | 291 | 93 | 159 | MDH7597985.1 serine protease [Methanothrix sp.] | diamond | 201 | 95.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30381144 | 30381144 | PRJEB28062_P_NODE_113513_length_277_cov_1.774510_g111150_i0 | PRJEB28062 | 113513 | 277 | 1.77451 | 4.9153927 | Methanosarcina baikalica | 3073890 | Archaea | Archaea | 129 | 3.27e-33 | NR | WP_310577132.1 | 3073890 | g111150 | i0 | 76.3 | 6.99638989169675 | 80 | 19 | 86.6 | 0 | 276 | 37 | 368 | 447 | WP_310577132.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Methanosarcina baikalica] | diamond | 1938 | 129 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina baikalica | |
| 31392170 | 31392170 | PRJEB28062_P_NODE_113356_length_277_cov_4.980392_g110993_i0 | PRJEB28062 | 113356 | 277 | 4.980392 | 13.79568584 | Methanimicrococcus stummii | 3028294 | Archaea | Archaea | 89.4 | 1.72e-21 | NR | WP_316559825.1 | 3028294 | g110993 | i0 | 91.1 | 0.487364620938628 | 45 | 4 | 48.7 | 0 | 109 | 243 | 1 | 45 | WP_316559825.1 DNA-directed RNA polymerase subunit P [Methanimicrococcus stummii] | diamond | 135 | 89.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanimicrococcus | Methanimicrococcus stummii | |
| 31701853 | 31701853 | PRJEB28062_P_NODE_124337_length_251_cov_0.865169_g121973_i0 | PRJEB28062 | 124337 | 251 | 0.865169 | 2.17157419 | Halomarina | 871740 | Archaea | Archaea | 112 | 5.800000000000001e-30 | NR | MFB6228173.1 | 1904752 | g121973 | i0 | 74.6 | 3.31075697211155 | 67 | 17 | 80.1 | 0 | 201 | 1 | 2 | 68 | MFB6228173.1 hypothetical protein [Halobacteriales archaeon] | diamond | 831 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 31708274 | 31708274 | PRJEB28062_P_NODE_117837_length_266_cov_1.347150_g115474_i0 | PRJEB28062 | 117837 | 266 | 1.34715 | 3.583419 | Halococcus sp. | 29286 | Archaea | Archaea | 87.4 | 2.29e-20 | NR | HET7325631.1 | 29286 | g115474 | i0 | 90.9 | 0.981203007518797 | 44 | 4 | 49.6 | 0 | 134 | 265 | 1 | 44 | HET7325631.1 DUF5785 family protein [Halococcus sp.] | diamond | 261 | 87.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 31803089 | 31803089 | PRJEB28062_P_NODE_87757_length_352_cov_4.272401_g85395_i0 | PRJEB28062 | 87757 | 352 | 4.272401 | 15.03885152 | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | 2013820 | Archaea | Archaea | 69.3 | 6.2e-11 | NR | PKL60891.1 | 2013820 | g85395 | i0 | 41.9 | 0.732954545454545 | 86 | 50 | 73.3 | 0 | 324 | 67 | 295 | 380 | PKL60891.1 MAG: hypothetical protein CVV33_00355 [Methanomicrobiales archaeon HGW-Methanomicrobiales-4] | diamond | 258 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | |||
| 32341278 | 32341278 | PRJEB28062_P_NODE_107559_length_293_cov_2.086364_g105196_i0 | PRJEB28062 | 107559 | 293 | 2.086364 | 6.11304652 | Halolamina sp. | 1940283 | Archaea | Archaea | 98.2 | 4.74e-22 | NR | WP_332324152.1 | 1940283 | g105196 | i0 | 79.7 | 1.96587030716724 | 64 | 13 | 65.5 | 0 | 286 | 95 | 272 | 335 | WP_332324152.1 sodium:calcium antiporter [Halolamina sp.] | diamond | 576 | 98.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. |
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);;