RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 26 ✖

bioproject 1

  • PRJEB14175 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
26322571 26322571 PRJEB14175_P_NODE_218535_length_214_cov_7.228758_g216267_i0 PRJEB14175 218535 214 7.228758 15.46954212 Methanospirillum sp. 45200 Archaea Archaea 60.1 7.54e-9   NR HWQ67963.1 45200 g216267 i0 79.4 0.953271028037383 34 7 47.7 0 115 14 1 34 HWQ67963.1 hypothetical protein [Methanospirillum sp.] diamond 204 60.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
32909264 32909264 PRJEB14175_P_NODE_224425_length_210_cov_11.704698_g222157_i0 PRJEB14175 224425 210 11.704698 24.5798658 Methanoculleus sp. 90427 Archaea Archaea 120 1.77e-30   NR WP_214019259.1 90427 g222157 i0 96.8 1.8 63 2 90 0 189 1 134 196 WP_214019259.1 SLC13 family permease [Methanoculleus sp.] diamond 378 120 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
32925795 32925795 PRJEB14175_P_NODE_159177_length_266_cov_1.609756_g156910_i0 PRJEB14175 159177 266 1.609756 4.28195096 Methanolobus bombayensis 38023 Archaea Archaea 60.1 3.74e-8   NR WP_209622673.1 38023 g156910 i0 43.8 1.43233082706767 64 30 67.7 2 235 56 358 419 WP_209622673.1 RNA-guided endonuclease InsQ/TnpB family protein [Methanolobus bombayensis] diamond 381 60.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus bombayensis
32926821 32926821 PRJEB14175_P_NODE_274697_length_181_cov_5.308333_g272429_i0 PRJEB14175 274697 181 5.308333 9.60808273 Haloquadratum walsbyi J 293091 Archaea Archaea 41.6 0.0415   NR ERG92225.1 1238424 g272429 i0 32.7 0.812154696132597 49 33 81.2 0 18 164 13 61 ERG92225.1 MAG: PAS sensor histidine kinase [Haloquadratum walsbyi J07HQW1] diamond 147 41.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloquadratum Haloquadratum walsbyi
32960009 32960009 PRJEB14175_P_NODE_142570_length_286_cov_2.391111_g140303_i0 PRJEB14175 142570 286 2.391111 6.83857746 Methanoculleus sp. 90427 Archaea Archaea 124 3.38e-33   NR WP_214041105.1 90427 g140303 i0 90.9 2.07692307692308 66 6 69.2 0 79 276 1 66 WP_214041105.1 hypothetical protein [Methanoculleus sp.] diamond 594 124 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
32960935 32960935 PRJEB14175_P_NODE_240514_length_206_cov_0.882759_g238246_i0 PRJEB14175 240514 206 0.882759 1.81848354 Halomicroarcula sp. GCM1 44098 Archaea Archaea 40.8 0.0488   NR WP_379774535.1 3252669 g238246 i0 44.3 0.888349514563107 61 26 88.8 2 15 197 53 105 WP_379774535.1 hypothetical protein [Halomicroarcula sp. GCM10025709] diamond 183 40.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Halomicroarcula sp. GCM10025709
32961425 32961425 PRJEB14175_P_NODE_51018_length_522_cov_2.225597_g48779_i0 PRJEB14175 51018 522 2.225597 11.61761634 Methanothrix 2222 Archaea Archaea 123 5.94e-29   NR WP_273278129.1 2222 g48779 i0 67.5 0.477011494252874 83 27 47.7 0 274 522 166 248 WP_273278129.1 MULTISPECIES: helicase HerA domain-containing protein [Methanothrix] diamond 249 123 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix  
32978975 32978975 PRJEB14175_P_NODE_98947_length_360_cov_2.668896_g96681_i0 PRJEB14175 98947 360 2.668896 9.6080256 Halalkalicoccus paucihalophilus 1008153 Archaea Archaea 168 1.1599999999999998e-48   NR WP_066380845.1 1008153 g96681 i0 93.1 1.45 87 6 72.5 0 358 98 233 319 WP_066380845.1 TatD family hydrolase [Halalkalicoccus paucihalophilus] diamond 522 168 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus paucihalophilus
32994218 32994218 PRJEB14175_P_NODE_159683_length_265_cov_5.127451_g157416_i0 PRJEB14175 159683 265 5.127451 13.58774515 Methanoculleus nereidis 2735141 Archaea Archaea 142 1.14e-39   NR WP_317295318.1 2735141 g157416 i0 97.3 0.826415094339623 73 2 82.6 0 25 243 50 122 WP_317295318.1 MerR family transcriptional regulator [Methanoculleus nereidis] diamond 219 142 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus nereidis
32995153 32995153 PRJEB14175_P_NODE_267507_length_193_cov_2.424242_g265239_i0 PRJEB14175 267507 193 2.424242 4.67878706 Methanospirillum sp. 45200 Archaea Archaea 84 3.34e-18   NR HWQ67434.1 45200 g265239 i0 63.8 1.80310880829016 58 21 90.2 0 186 13 51 108 HWQ67434.1 uridylate kinase [Methanospirillum sp.] diamond 348 84 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
33029701 33029701 PRJEB14175_P_NODE_63228_length_465_cov_76.641089_g60972_i0 PRJEB14175 63228 465 76.641089 356.38106385 Methanomicrobiales archaeon 2184052 Archaea Archaea 56.2 6.89e-6   NR MEI6841853.1 2184052 g60972 i0 57.5 0.780645161290323 40 17 25.8 0 20 139 83 122 MEI6841853.1 PQQ-binding-like beta-propeller repeat protein [Methanomicrobiales archaeon] diamond 363 56.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
33045778 33045778 PRJEB14175_P_NODE_203517_length_225_cov_6.439024_g201250_i0 PRJEB14175 203517 225 6.439024 14.487804 Candidatus Methanofastidiosum methylothiophilum 1705564 Archaea Archaea 139 1.19e-38   NR KYC45998.1 1705564 g201250 i0 98.6 0.946666666666667 71 1 94.7 0 11 223 192 262 KYC45998.1 MAG: Modification methylase MjaV [Candidatus Methanofastidiosum methylothiophilum] diamond 213 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Candidatus Methanofastidiosum methylothiophilum
33046231 33046231 PRJEB14175_P_NODE_252813_length_203_cov_0.901408_g250545_i0 PRJEB14175 252813 203 0.901408 1.82985824 Natronococcus roseus 1052014 Archaea Archaea 42 0.041   NR WP_394742789.1 1052014 g250545 i0 42.3 0.768472906403941 52 28 73.9 1 13 162 86 137 WP_394742789.1 amidohydrolase [Natronococcus roseus] diamond 156 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus roseus
33058982 33058982 PRJEB14175_P_NODE_134797_length_297_cov_1.529661_g132530_i0 PRJEB14175 134797 297 1.529661 4.54309317 root 1 Root_unresolved Root_unresolved 61.2 2.59e-9   NR ERJ07814.1 1033806 g132530 i0 55.8 2.96969696969697 43 19 43.4 0 287 159 1 43 ERJ07814.1 alcohol dehydrogenase cytochrome c protein [Halorhabdus tiamatea SARL4B] diamond 882 61.6 0.993506493506494 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halorhabdus Halorhabdus tiamatea
33063959 33063959 PRJEB14175_P_NODE_90093_length_381_cov_5.321875_g87827_i0 PRJEB14175 90093 381 5.321875 20.27634375 Methanoregula sp. 2052170 Archaea Archaea 89.7 6.44e-18   NR WP_299965604.1 2052170 g87827 i0 38.9 1.03149606299213 131 68 96.1 3 368 3 253 380 WP_299965604.1 DUF2341 domain-containing protein, partial [Methanoregula sp.] diamond 393 89.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
33079470 33079470 PRJEB14175_P_NODE_153118_length_273_cov_2.216981_g150851_i0 PRJEB14175 153118 273 2.216981 6.05235813 Methanoculleus sp. 90427 Archaea Archaea 146 7.189999999999999e-40   NR HOI12936.1 90427 g150851 i0 84.3 0.912087912087912 83 13 91.2 0 251 3 98 180 HOI12936.1 protein kinase [Methanoculleus sp.] diamond 249 146 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
33096142 33096142 PRJEB14175_P_NODE_109950_length_337_cov_17.804348_g107684_i0 PRJEB14175 109950 337 17.804348 60.00065276 Methanothrix soehngenii 2223 Archaea Archaea 91.3 3.8e-21   NR WP_324308047.1 2223 g107684 i0 72.1 2.60830860534125 61 17 54.3 0 202 20 14 74 WP_324308047.1 DUF6948 domain-containing protein [Methanothrix soehngenii] diamond 879 91.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
33096342 33096342 PRJEB14175_P_NODE_13302_length_980_cov_1.969532_g11737_i0 PRJEB14175 13302 980 1.969532 19.3014136 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 172 4.31e-44   NR MCX9026424.1 2032688 g11737 i0 36.4 1.82448979591837 302 187 91.5 5 969 73 110 409 MCX9026424.1 hypothetical protein [Candidatus Methanoperedens sp.] diamond 1788 172 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens sp.
33110423 33110423 PRJEB14175_P_NODE_259374_length_201_cov_0.914286_g257106_i0 PRJEB14175 259374 201 0.914286 1.83771486 root 1 Root_unresolved Root_unresolved 50.4 3.99e-5   NR MDD2473722.1 90427 g257106 i0 56.1 2.37313432835821 41 18 61.2 0 78 200 451 491 MDD2473722.1 catalase [Methanoculleus sp.] diamond 477 50.8 0.992125984251969 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
33114321 33114321 PRJEB14175_P_NODE_245759_length_204_cov_1.790210_g243491_i0 PRJEB14175 245759 204 1.79021 3.6520284 unclassified Methanoculleus 2619537 Archaea Archaea 108 7.030000000000001e-27   NR WP_292364841.1 2619537 g243491 i0 98.2 0.838235294117647 57 1 83.8 0 10 180 30 86 WP_292364841.1 MULTISPECIES: DUF488 family protein [unclassified Methanoculleus] diamond 171 108 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus  
33130593 33130593 PRJEB14175_P_NODE_147767_length_279_cov_8.068807_g145500_i0 PRJEB14175 147767 279 8.068807 22.51197153 Candidatus Methanofastidiosia archaeon 2099674 Archaea Archaea 90.1 6.35e-19   NR MFQ5891454.1 2099674 g145500 i0 58.1 0.795698924731183 74 31 79.6 0 23 244 178 251 MFQ5891454.1 SNF2-related protein [Candidatus Methanofastidiosia archaeon] diamond 222 90.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia       Candidatus Methanofastidiosia archaeon
33131546 33131546 PRJEB14175_P_NODE_250639_length_203_cov_0.901408_g248371_i0 PRJEB14175 250639 203 0.901408 1.82985824 Methanospirillaceae archaeon 2813030 Archaea Archaea 47 4.38e-4   NR MBN1167662.1 2813030 g248371 i0 38.8 1.78817733990148 67 38 94.6 1 203 12 88 154 MBN1167662.1 tetratricopeptide repeat protein [Methanospirillaceae archaeon] diamond 363 47 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae   Methanospirillaceae archaeon
33144330 33144330 PRJEB14175_P_NODE_149663_length_277_cov_3.583333_g147396_i0 PRJEB14175 149663 277 3.583333 9.92583241 Halorubrum 56688 Archaea Archaea 44.3 0.0137   NR WP_193308851.1 413816 g147396 i0 36 3.19494584837545 75 44 76.9 1 260 48 43 117 WP_193308851.1 isopentenyl phosphate kinase [Halorubrum halophilum] diamond 885 44.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum halophilum
33147509 33147509 PRJEB14175_P_NODE_134784_length_297_cov_1.597458_g132517_i0 PRJEB14175 134784 297 1.597458 4.74445026 Methanosarcina acetivorans C2A 188937 Archaea Archaea 42.7 0.0237   NR AAM05032.1 188937 g132517 i0 35.2 0.717171717171717 71 43 68.7 1 259 56 2 72 AAM05032.1 predicted protein [Methanosarcina acetivorans C2A] diamond 213 42.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina acetivorans
33149216 33149216 PRJEB14175_P_NODE_83048_length_399_cov_21.923077_g80784_i0 PRJEB14175 83048 399 21.923077 87.47307723 Methanolobus sp. 1874737 Archaea Archaea 122 3.01e-30   NR MDY0386670.1 1874737 g80784 i0 80.3 0.533834586466165 71 14 53.4 0 214 2 1 71 MDY0386670.1 IS200/IS605 family element RNA-guided endonuclease TnpB [Methanolobus sp.] diamond 213 122 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus sp.
33161365 33161365 PRJEB14175_P_NODE_176776_length_248_cov_1.368984_g174509_i0 PRJEB14175 176776 248 1.368984 3.39508032 Haloferacaceae 1644056 Archaea Archaea 99.4 9.27e-24   NR WP_101296858.1 1985678 g174509 i0 55.6 1.95967741935484 81 36 98 0 3 245 106 186 WP_101296858.1 IS607 family transposase [Halegenticoccus soli] diamond 486 99.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halegenticoccus Halegenticoccus soli

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;