RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 28 ✖

bioproject 1

  • PRJNA773247 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
5852700 5852700 PRJNA773247_P_NODE_7165_length_622_cov_6.176685_g7082_i0 PRJNA773247 7165 622 6.176685 38.4189807 Halalkalicoccus subterraneus 2675002 Archaea Archaea 234 2.97e-72   NR WP_122088266.1 2675002 g7082 i0 83.3 0.665594855305466 138 23 66.6 0 434 21 1 138 WP_122088266.1 DUF7289 family protein [Halalkalicoccus subterraneus] diamond 414 234 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus subterraneus
7127421 7127421 PRJNA773247_P_NODE_12226_length_437_cov_3.230769_g12143_i0 PRJNA773247 12226 437 3.230769 14.11846053 Halalkalicoccus subterraneus 2675002 Archaea Archaea 234 3.08e-76   NR WP_122089653.1 2675002 g12143 i0 82.7 0.954233409610984 139 24 95.4 0 418 2 1 139 WP_122089653.1 hypothetical protein [Halalkalicoccus subterraneus] diamond 417 234 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus subterraneus
26745957 26745957 PRJNA773247_P_NODE_35141_length_240_cov_2.467066_g35057_i0 PRJNA773247 35141 240 2.467066 5.9209584 root 1 Root_unresolved Root_unresolved 86.3 2.01e-19   NR WP_415953032.1 190976 g35057 i0 57.7 3.725 71 30 88.8 0 27 239 51 121 WP_415953032.1 NADAR family protein [Methanobrevibacter woesei] diamond 894 87 0.991954022988506 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter woesei
27021728 27021728 PRJNA773247_P_NODE_34142_length_242_cov_3.609467_g34058_i0 PRJNA773247 34142 242 3.609467 8.73491014 Methanohalobium sp. 2837493 Archaea Archaea 95.9 3.48e-22   NR WP_292487842.1 2837493 g34058 i0 53.8 0.991735537190083 80 36 99.2 1 2 241 140 218 WP_292487842.1 DNA-methyltransferase, partial [Methanohalobium sp.] diamond 240 95.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanohalobium Methanohalobium sp.
27116340 27116340 PRJNA773247_P_NODE_32782_length_245_cov_2.802326_g32698_i0 PRJNA773247 32782 245 2.802326 6.8656987 Methanosarcina sp. 2213 Archaea Archaea 117 4.079999999999999e-32   NR HET8689608.1 2213 g32698 i0 84.1 0.771428571428571 63 10 77.1 0 2 190 54 116 HET8689608.1 hypothetical protein [Methanosarcina sp.] diamond 189 117 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
27315899 27315899 PRJNA773247_P_NODE_16723_length_358_cov_1.726316_g16639_i0 PRJNA773247 16723 358 1.726316 6.18021128 root 1 Root_unresolved Root_unresolved 46.6 0.00264   NR MEK9695784.1 2163009 g16639 i0 38.5 1.24022346368715 52 32 43.6 0 49 204 2 53 MEK9695784.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 444 47 0.991489361702128 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
27622130 27622130 PRJNA773247_P_NODE_17104_length_353_cov_3.767857_g17020_i0 PRJNA773247 17104 353 3.767857 13.30053521 Methanobacteriota archaeon 2026739 Archaea Archaea 85.1 5.82e-18   NR MDE1821165.1 2026739 g17020 i0 47.7 0.730878186968839 86 42 71.4 2 83 334 16 100 MDE1821165.1 hypothetical protein [Methanobacteriota archaeon] diamond 258 85.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28199656 28199656 PRJNA773247_P_NODE_18846_length_333_cov_2.430769_g18762_i0 PRJNA773247 18846 333 2.430769 8.09446077 root 1 Root_unresolved Root_unresolved 85.1 1.16e-18   NR HON37095.1 90426 g18762 i0 46.2 2.79279279279279 104 42 89.2 2 314 18 3 97 HON37095.1 HNH endonuclease [Methanothrix sp.] diamond 930 85.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28316716 28316716 PRJNA773247_P_NODE_30946_length_249_cov_3.857955_g30862_i0 PRJNA773247 30946 249 3.857955 9.60630795 Methanomicrobiales archaeon 2184052 Archaea Archaea 53.1 3.28e-6   NR NLZ31335.1 2184052 g30862 i0 48.9 0.566265060240964 47 21 56.6 1 98 238 1 44 NLZ31335.1 hypothetical protein [Methanomicrobiales archaeon] diamond 141 53.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
28695691 28695691 PRJNA773247_P_NODE_17487_length_348_cov_35.120000_g17403_i0 PRJNA773247 17487 348 35.12 122.2176 Thermoplasmata archaeon 1906666 Archaea Archaea 72 6.6e-12   NR MCK4718607.1 1906666 g17403 i0 51.6 0.53448275862069 62 30 53.4 0 186 1 3 64 MCK4718607.1 phage terminase large subunit [Thermoplasmata archaeon] diamond 186 72 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28790118 28790118 PRJNA773247_P_NODE_17627_length_347_cov_2.697080_g17543_i0 PRJNA773247 17627 347 2.69708 9.3588676 Methanobacteriota archaeon 2026739 Archaea Archaea 50.4 2.78e-5   NR NDB94277.1 2026739 g17543 i0 59.5 0.319884726224784 37 14 32 1 116 6 4 39 NDB94277.1 hypothetical protein [Methanobacteriota archaeon] diamond 111 50.4 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28821527 28821527 PRJNA773247_P_NODE_24248_length_285_cov_9.971698_g24164_i0 PRJNA773247 24248 285 9.971698 28.4193393 Methanoregula sp. 2052170 Archaea Archaea 57 5.94e-7   NR MCK9591864.1 2052170 g24164 i0 54.4 3.09473684210526 57 25 60 1 8 178 275 330 MCK9591864.1 collagen-like protein [Methanoregula sp.] diamond 882 57 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
28884892 28884892 PRJNA773247_P_NODE_28388_length_260_cov_3.491979_g28304_i0 PRJNA773247 28388 260 3.491979 9.0791454 Thermoplasmatota archaeon 2806419 Archaea Archaea 50.8 6.72e-5   NR MFA5943196.1 2806419 g28304 i0 40.3 0.888461538461538 77 43 86.5 2 2 226 839 914 MFA5943196.1 hypothetical protein [Thermoplasmatota archaeon] diamond 231 50.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
28884894 28884894 PRJNA773247_P_NODE_31548_length_248_cov_1.382857_g31464_i0 PRJNA773247 31548 248 1.382857 3.42948536 Methanobacteriota archaeon 2026739 Archaea Archaea 50.1 1.03e-4   NR MAH29997.1 2026739 g31464 i0 50.9 0.665322580645161 55 27 66.5 0 12 176 199 253 MAH29997.1 hypothetical protein [Methanobacteriota archaeon] diamond 165 50.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29232411 29232411 PRJNA773247_P_NODE_36089_length_231_cov_2.272152_g36005_i0 PRJNA773247 36089 231 2.272152 5.24867112 Methanothrix sp. 90426 Archaea Archaea 58.2 1.76e-8   NR HOK59086.1 90426 g36005 i0 66.7 0.948051948051948 39 13 50.6 0 41 157 59 97 HOK59086.1 hypothetical protein [Methanothrix sp.] diamond 219 58.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
29295394 29295394 PRJNA773247_P_NODE_14809_length_387_cov_2.987261_g14725_i0 PRJNA773247 14809 387 2.987261 11.56070007 Thermoplasmatales archaeon 2268204 Archaea Archaea 216 3.83e-68   NR MEM4379678.1 2268204 g14725 i0 75 0.992248062015504 128 32 99.2 0 385 2 10 137 MEM4379678.1 hypothetical protein [Thermoplasmatales archaeon] diamond 384 216 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
29358644 29358644 PRJNA773247_P_NODE_25129_length_279_cov_6.558252_g25045_i0 PRJNA773247 25129 279 6.558252 18.29752308 Thermoplasmata archaeon 1906666 Archaea Archaea 62.8 1.32e-10   NR MCK5548792.1 1906666 g25045 i0 62.2 0.483870967741935 45 16 48.4 1 148 14 4 47 MCK5548792.1 hypothetical protein [Thermoplasmata archaeon] diamond 135 62.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29358653 29358653 PRJNA773247_P_NODE_35749_length_234_cov_2.503106_g35665_i0 PRJNA773247 35749 234 2.503106 5.85726804 Thermoplasmata archaeon 1906666 Archaea Archaea 66.2 6.85e-12   NR MCK4718806.1 1906666 g35665 i0 43.6 1 78 44 100 0 234 1 20 97 MCK4718806.1 hypothetical protein [Thermoplasmata archaeon] diamond 234 66.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29516276 29516276 PRJNA773247_P_NODE_27730_length_264_cov_1.596859_g27646_i0 PRJNA773247 27730 264 1.596859 4.21570776 Halobacteria archaeon 2670410 Archaea Archaea 43.9 0.017   NR MEM2990173.1 2670410 g27646 i0 38.8 1.125 49 27 55.7 2 173 27 141 186 MEM2990173.1 metallophosphoesterase [Halobacteria archaeon] diamond 297 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria       Halobacteria archaeon
29547843 29547843 PRJNA773247_P_NODE_8930_length_536_cov_3.226782_g8847_i0 PRJNA773247 8930 536 3.226782 17.29555152 Archaeoglobaceae archaeon 2511821 Archaea Archaea 70.1 1.5e-10   NR MEM3145985.1 2511821 g8847 i0 50 0.470149253731343 84 41 47 1 530 279 260 342 MEM3145985.1 hypothetical protein [Archaeoglobaceae archaeon] diamond 252 70.1 1 Archaea   Methanobacteriati Methanobacteriota Archaeoglobi Archaeoglobales Archaeoglobaceae   Archaeoglobaceae archaeon
29683503 29683503 PRJNA773247_P_NODE_14110_length_399_cov_2.883436_g14026_i0 PRJNA773247 14110 399 2.883436 11.50490964 root 1 Root_unresolved Root_unresolved 52.8 6.03e-5   NR MCK4718606.1 1906666 g14026 i0 35.8 2.02255639097744 95 60 70.7 1 80 361 4 98 MCK4718606.1 DUF1073 domain-containing protein [Thermoplasmata archaeon] diamond 807 53.1 0.994350282485876 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29968122 29968122 PRJNA773247_P_NODE_14571_length_391_cov_3.814465_g14487_i0 PRJNA773247 14571 391 3.814465 14.91455815 Methanomada group 2283794 Archaea Archaea 72 2.66e-13   NR WP_011019965.1 2320 g14487 i0 50 1.08951406649616 72 36 55.2 0 342 127 43 114 WP_011019965.1 peptidyl-tRNA hydrolase Pth2 [Methanopyrus kandleri] diamond 426 72 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanopyri Methanopyrales Methanopyraceae Methanopyrus Methanopyrus kandleri
29990158 29990158 PRJNA773247_P_NODE_19631_length_324_cov_6.661355_g19547_i0 PRJNA773247 19631 324 6.661355 21.5827902 Thermoplasmata archaeon 1906666 Archaea Archaea 74.7 3.85e-14   NR MCI4354553.1 1906666 g19547 i0 61 0.546296296296296 59 22 53.7 1 3 176 112 170 MCI4354553.1 hypothetical protein [Thermoplasmata archaeon] diamond 177 74.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30347740 30347740 PRJNA773247_P_NODE_24872_length_281_cov_3.677885_g24788_i0 PRJNA773247 24872 281 3.677885 10.33485685 root 1 Root_unresolved Root_unresolved 60.1 3.56e-8   NR WP_006825677.1 160846 g24788 i0 39.1 2.85053380782918 87 51 92.9 1 21 281 97 181 WP_006825677.1 DNA adenine methylase [Natrialba taiwanensis] diamond 801 60.5 0.993388429752066 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrialba Natrialba taiwanensis
32392884 32392884 PRJNA773247_P_NODE_32039_length_247_cov_0.885057_g31955_i0 PRJNA773247 32039 247 0.885057 2.18609079 Thermoplasmatota archaeon 2806419 Archaea Archaea 45.8 0.00309   NR MEA3558600.1 2806419 g31955 i0 44.3 0.850202429149798 70 33 85 1 247 38 135 198 MEA3558600.1 hypothetical protein [Thermoplasmatota archaeon] diamond 210 45.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
32654771 32654771 PRJNA773247_P_NODE_35240_length_239_cov_2.355422_g35156_i0 PRJNA773247 35240 239 2.355422 5.62945858 root 1 Root_unresolved Root_unresolved 67.4 1.19e-11   NR WP_148858122.1 2055836 g35156 i0 40 1.9581589958159 80 47 99.2 1 239 3 15 94 WP_148858122.1 flavodoxin domain-containing protein [Natronococcus pandeyae] diamond 468 67.8 0.994100294985251 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus pandeyae
32771418 32771418 PRJNA773247_P_NODE_15440_length_377_cov_2.786184_g15356_i0 PRJNA773247 15440 377 2.786184 10.50391368 Methanobacteriota archaeon 2026739 Archaea Archaea 72.8 4.7e-12   NR MAN22097.1 2026739 g15356 i0 39.6 0.843501326259947 106 58 84.4 3 362 45 359 458 MAN22097.1 hypothetical protein [Methanobacteriota archaeon] diamond 318 72.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32897317 32897317 PRJNA773247_P_NODE_26180_length_273_cov_1.415000_g26096_i0 PRJNA773247 26180 273 1.415 3.86295 Methanoculleus sp. UBA45 1915512 Archaea Archaea 43.9 0.0135   NR WP_343241183.1 1915512 g26096 i0 31.9 2.91208791208791 72 45 79.1 3 272 57 2 69 WP_343241183.1 hypothetical protein [Methanoculleus sp. UBA45] diamond 795 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp. UBA45

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