RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 18 ✖

bioproject 1

  • PRJNA1059246 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
4003781 4003781 PRJNA1059246_P_NODE_61504_length_251_cov_1.235955_g60878_i0 PRJNA1059246 61504 251 1.235955 3.10224705 Haloferacaceae archaeon 2080321 Archaea Archaea 109 3.82e-28   NR MFB6154400.1 2080321 g60878 i0 62.7 1.9840637450199201 83 30 99.2 1 249 1 52 133 MFB6154400.1 peptide-methionine (S)-S-oxide reductase MsrA [Haloferacaceae archaeon] diamond 498 109 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon
27311917 27311917 PRJNA1059246_P_NODE_40223_length_335_cov_2.030534_g39597_i0 PRJNA1059246 40223 335 2.030534 6.8022889 root 1 Root_unresolved Root_unresolved 45.8 0.00826   NR WP_286475720.1 2584467 g39597 i0 44.8 1.44179104477612 58 30 51.9 1 276 103 111 166 WP_286475720.1 CDC27 family protein [Methanobacterium aridiramus] diamond 483 46.2 0.991341991341991 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium aridiramus
27446474 27446474 PRJNA1059246_P_NODE_39903_length_337_cov_1.458333_g39277_i0 PRJNA1059246 39903 337 1.458333 4.91458221 Thermoplasmatota archaeon 2806419 Archaea Archaea 73.2 2.05e-12   NR MCU0798948.1 2806419 g39277 i0 72.3 1.25519287833828 47 13 41.8 0 141 1 15 61 MCU0798948.1 ATPase [Thermoplasmatota archaeon] diamond 423 73.2 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27477728 27477728 PRJNA1059246_P_NODE_19383_length_519_cov_1.659193_g18765_i0 PRJNA1059246 19383 519 1.659193 8.61121167 Methanobacteriota archaeon 2026739 Archaea Archaea 219 5.12e-65   NR RMG34081.1 2026739 g18765 i0 66.7 1.90173410404624 165 53 94.2 2 519 31 403 567 RMG34081.1 MAG: S9 family peptidase [Methanobacteriota archaeon] diamond 987 219 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27825248 27825248 PRJNA1059246_P_NODE_48764_length_294_cov_1.533937_g48138_i0 PRJNA1059246 48764 294 1.533937 4.50977478 Methanothrix sp. 90426 Archaea Archaea 52 2.87e-5   NR NMB86174.1 90426 g48138 i0 49.1 0.561224489795918 55 28 56.1 0 2 166 48 102 NMB86174.1 tetratricopeptide repeat protein [Methanothrix sp.] diamond 165 52 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28077581 28077581 PRJNA1059246_P_NODE_37305_length_351_cov_2.093525_g36679_i0 PRJNA1059246 37305 351 2.093525 7.34827275 Methanosarcinales archaeon 2250255 Archaea Archaea 84.3 3.16e-16   NR RYE85578.1 2250255 g36679 i0 44.4 0.923076923076923 108 54 88.9 3 349 38 404 509 RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] diamond 324 84.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
28330265 28330265 PRJNA1059246_P_NODE_67546_length_246_cov_0.890173_g66920_i0 PRJNA1059246 67546 246 0.890173 2.18982558 Natronoarchaeum rubrum 755311 Archaea Archaea 60.1 1.46e-8   NR WP_256393113.1 755311 g66920 i0 54.8 1.51219512195122 62 25 74.4 2 61 243 4 63 WP_256393113.1 histidine phosphatase family protein [Natronoarchaeum rubrum] diamond 372 60.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Natronoarchaeum Natronoarchaeum rubrum
28930202 28930202 PRJNA1059246_P_NODE_18568_length_533_cov_1.330435_g17951_i0 PRJNA1059246 18568 533 1.330435 7.09121855 Methanobacteriota archaeon 2026739 Archaea Archaea 90.1 3.54e-18   NR MAV59833.1 2026739 g17951 i0 40.7 4.4577861163227 113 66 63 1 376 41 164 276 MAV59833.1 hypothetical protein [Methanobacteriota archaeon] diamond 2376 90.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29151612 29151612 PRJNA1059246_P_NODE_54649_length_275_cov_1.252475_g54023_i0 PRJNA1059246 54649 275 1.252475 3.44430625 Methanosarcinales archaeon 2250255 Archaea Archaea 67 9.09e-12   NR RYE81919.1 2250255 g54023 i0 42.1 0.829090909090909 76 42 81.8 2 2 226 34 108 RYE81919.1 MAG: hypothetical protein EOO65_06165 [Methanosarcinales archaeon] diamond 228 67 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
29372238 29372238 PRJNA1059246_P_NODE_15529_length_593_cov_1.184615_g14929_i0 PRJNA1059246 15529 593 1.184615 7.02476695 Methanoregula sp. 2052170 Archaea Archaea 77.8 8.44e-13   NR MDD1698370.1 2052170 g14929 i0 29.7 1.02192242833052 202 109 97.1 7 591 16 336 514 MDD1698370.1 GPI anchored serine-threonine rich family protein [Methanoregula sp.] diamond 606 77.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
29490224 29490224 PRJNA1059246_P_NODE_37150_length_352_cov_1.655914_g36524_i0 PRJNA1059246 37150 352 1.655914 5.82881728 Methanomada group 2283794 Archaea Archaea 58.2 3.48e-7   NR KYK25085.1 1803821 g36524 i0 40.6 2.96590909090909 69 38 56.3 2 346 149 202 270 KYK25085.1 MAG: hypothetical protein AYK26_02730 [Euryarchaeota archaeon SM23-78] diamond 1044 58.5 0.994871794871795 Archaea   Methanobacteriati Methanobacteriota         Euryarchaeota archaeon SM23-78
29972212 29972212 PRJNA1059246_P_NODE_45051_length_312_cov_0.966527_g44425_i0 PRJNA1059246 45051 312 0.966527 3.01556424 Methanothermus fervidus DSM 2 2180 Archaea Archaea 58.5 2.28e-7   NR ADP76834.1 523846 g44425 i0 38.7 0.721153846153846 75 45 72.1 1 87 311 4 77 ADP76834.1 AMP-dependent synthetase and ligase [Methanothermus fervidus DSM 2088] diamond 225 58.5 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanothermaceae Methanothermus Methanothermus fervidus
30027365 30027365 PRJNA1059246_P_NODE_72251_length_241_cov_0.916667_g71625_i0 PRJNA1059246 72251 241 0.916667 2.20916747 Archaea 2157 Archaea Archaea 50.1 8.26e-5   NR KYK25085.1 1803821 g71625 i0 37.9 4.49377593360996 66 38 78.4 2 189 1 202 267 KYK25085.1 MAG: hypothetical protein AYK26_02730 [Euryarchaeota archaeon SM23-78] diamond 1083 50.4 0.994047619047619 Archaea   Methanobacteriati Methanobacteriota         Euryarchaeota archaeon SM23-78
30730489 30730489 PRJNA1059246_P_NODE_47394_length_301_cov_1.013158_g46768_i0 PRJNA1059246 47394 301 1.013158 3.04960558 Candidatus Methanophagaceae archaeon 3386247 Archaea Archaea 72.4 2.63e-12   NR KAF5437882.1 3386247 g46768 i0 48.6 0.737541528239203 74 30 73.8 2 48 269 137 202 KAF5437882.1 Kazal-type serine protease inhibitor domain-containing protein [Candidatus Methanophagaceae archaeon] diamond 222 72.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Candidatus Methanophagales Candidatus Methanophagaceae   Candidatus Methanophagaceae archaeon
31014877 31014877 PRJNA1059246_P_NODE_58375_length_262_cov_1.539683_g57749_i0 PRJNA1059246 58375 262 1.539683 4.03396946 Methanomicrobiales archaeon 2184052 Archaea Archaea 56.2 9.2e-8   NR NYT06209.1 2184052 g57749 i0 38.2 1.54580152671756 68 42 77.9 0 204 1 1 68 NYT06209.1 hypothetical protein [Methanomicrobiales archaeon] diamond 405 56.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
31868527 31868527 PRJNA1059246_P_NODE_42437_length_324_cov_1.533865_g41811_i0 PRJNA1059246 42437 324 1.533865 4.9697226 Candidatus Hadarchaeales archaeon 3058034 Archaea Archaea 62.4 1.01e-8   NR MFN4133173.1 3058034 g41811 i0 31.4 0.972222222222222 105 64 95.4 2 14 322 159 257 MFN4133173.1 hypothetical protein [Candidatus Hadarchaeales archaeon] diamond 315 62.4 1 Archaea   Methanobacteriati Candidatus Hadarchaeota Candidatus Hadarchaeia Candidatus Hadarchaeales     Candidatus Hadarchaeales archaeon
32058462 32058462 PRJNA1059246_P_NODE_46438_length_305_cov_1.793103_g45812_i0 PRJNA1059246 46438 305 1.793103 5.46896415 Methanogenium marinum 348610 Archaea Archaea 40.8 0.0489   NR WP_274923711.1 348610 g45812 i0 43.9 0.40327868852459 41 23 40.3 0 162 40 7 47 WP_274923711.1 hypothetical protein [Methanogenium marinum] diamond 123 40.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium marinum
32848131 32848131 PRJNA1059246_P_NODE_57840_length_264_cov_1.481675_g57214_i0 PRJNA1059246 57840 264 1.481675 3.911622 Methanobacterium arcticum 386456 Archaea Archaea 48.9 2.98e-4   NR WP_052379777.1 386456 g57214 i0 64.5 0.727272727272727 31 11 35.2 0 260 168 214 244 WP_052379777.1 tetratricopeptide repeat protein, partial [Methanobacterium arcticum] diamond 192 48.9 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium arcticum

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