RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA493827", tax_clade = "Stenosarchaea group" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 19 ✖

tax_clade 1

  • Stenosarchaea group · 19 ✖

bioproject 1

  • PRJNA493827 · 19 ✖
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
1747766 1747766 PRJNA493827_P_NODE_37922_length_595_cov_2009.312261_g35753_i0 PRJNA493827 37922 595 2009.312261 11955.40795295 uncultured Methanoregula sp. 1005933 Archaea Archaea 1011 0   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g35753 i0 97.623 278.505882352941 589 14 99 0 7 595 3117883 3117295 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 165711 1011 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
3023221 3023221 PRJNA493827_P_NODE_234663_length_241_cov_0.916667_g232465_i0 PRJNA493827 234663 241 0.916667 2.20916747 Halobacterium noricense 223182 Archaea Archaea 52.8 0.022   NTclustered gi|2168244610|gb|CP089468.1| 223182 g232465 i0 100 0.116182572614108 28 0 12 0 22 49 919412 919385 Halobacterium noricense strain JCM 15102 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium noricense
11948686 11948686 PRJNA493827_P_NODE_123870_length_307_cov_1.324786_g121672_i0 PRJNA493827 123870 307 1.324786 4.06709302 Methanosarcinales archaeon 2250255 Archaea Archaea 139 9.31e-39   NR RYE84306.1 2250255 g121672 i0 80.5 0.801302931596091 82 16 80.1 0 2 247 140 221 RYE84306.1 MAG: 50S ribosomal protein L3 [Methanosarcinales archaeon] diamond 246 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
11950825 11950825 PRJNA493827_P_NODE_222750_length_243_cov_0.905882_g220552_i0 PRJNA493827 222750 243 0.905882 2.20129326 root 1 Root_unresolved Root_unresolved 118 4.34e-29   NR WP_214046385.1 45200 g220552 i0 70.1 17.3333333333333 77 23 95.1 0 233 3 191 267 WP_214046385.1 catalase [Methanospirillum sp.] diamond 4212 118 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
13225877 13225877 PRJNA493827_P_NODE_219451_length_244_cov_0.900585_g217253_i0 PRJNA493827 219451 244 0.900585 2.1974274 uncultured Methanoregula sp. 1005933 Archaea Archaea 318 1.9699999999999998e-82   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g217253 i0 90.164 49.7745901639344 244 24 100 0 1 244 3096585 3096342 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 12145 318 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
15133379 15133379 PRJNA493827_P_NODE_203472_length_247_cov_0.885057_g201274_i0 PRJNA493827 203472 247 0.885057 2.18609079 Haloterrigena 121871 Archaea Archaea 52.8 0.022   NTclustered gi|284012950|gb|CP001860.1| 543526 g201274 i0 100 0.226720647773279 28 0 11 0 12 39 3071345 3071318 Haloterrigena turkmenica DSM 5511, complete genome blastn 56 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Haloterrigena Haloterrigena turkmenica
15773903 15773903 PRJNA493827_P_NODE_183333_length_251_cov_1.730337_g181135_i0 PRJNA493827 183333 251 1.730337 4.34314587 uncultured Methanoregula sp. 1005933 Archaea Archaea 111 3.7e-20   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g181135 i0 91.358 0.322709163346614 81 7 32 0 1 81 3092663 3092743 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 81 111 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
17682996 17682996 PRJNA493827_P_NODE_189614_length_250_cov_0.870056_g187416_i0 PRJNA493827 189614 250 0.870056 2.17514 Halorubrum 56688 Archaea Archaea 52.8 0.023   NTclustered gi|1041620700|dbj|AP017569.1| 29284 g187416 i0 94.118 0.272 34 2 14 0 136 169 1743150 1743183 Halorubrum trapanicum DNA, complete genome, strain: CBA1232 blastn 68 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum trapanicum
20231783 20231783 PRJNA493827_P_NODE_212596_length_245_cov_0.895349_g210398_i0 PRJNA493827 212596 245 0.895349 2.19360505 Halogeometricum 60846 Archaea Archaea 80.5 1.01e-10   NTclustered gi|1810666233|gb|CP048739.1| 60847 g210398 i0 89.062 1.7469387755102 64 7 26 0 27 90 3768555 3768492 Halogeometricum borinquense strain wsp4 chromosome, complete genome blastn 428 80.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halogeometricum Halogeometricum borinquense
23425563 23425563 PRJNA493827_P_NODE_50819_length_500_cov_1.086651_g48629_i0 PRJNA493827 50819 500 1.086651 5.433255 uncultured Methanoregula sp. 1005933 Archaea Archaea 645 1.7599999999999993e-180   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g48629 i0 94.313 76.464 422 23 84 1 1 422 3123813 3124233 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 38232 645 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
24697072 24697072 PRJNA493827_P_NODE_172440_length_260_cov_1.700535_g170242_i0 PRJNA493827 172440 260 1.700535 4.421391 Halorubrum ezzemoulense 337243 Archaea Archaea 76.8 1.41e-9   NTclustered gi|1565814486|gb|CP034940.1| 337243 g170242 i0 84.706 22.1115384615385 85 4 33 7 122 206 595253 595178 Halorubrum ezzemoulense strain Fb21 chromosome, complete genome blastn 5749 76.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum ezzemoulense
24699909 24699909 PRJNA493827_P_NODE_80120_length_385_cov_0.987179_g77922_i0 PRJNA493827 80120 385 0.987179 3.80063915 Halococcus dombrowskii 179637 Archaea Archaea 52.8 0.037   NTclustered gi|2221489803|gb|CP095005.1| 179637 g77922 i0 100 0.0727272727272727 28 0 7 0 183 210 496501 496528 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
27155291 27155291 PRJNA493827_P_NODE_96442_length_349_cov_1.391304_g94244_i0 PRJNA493827 96442 349 1.391304 4.85565096 root 1 Root_unresolved Root_unresolved 164 4.609999999999999e-48   NR MDD4249870.1 2213 g94244 i0 72.6 3.73065902578797 106 29 91.1 0 348 31 146 251 MDD4249870.1 glycosyl amidation-associated protein WbuZ [Methanosarcina sp.] diamond 1302 165 0.993939393939394 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
28087347 28087347 PRJNA493827_P_NODE_159865_length_271_cov_1.303030_g157667_i0 PRJNA493827 159865 271 1.30303 3.5312113 Natronococcus sp. JC468 1961921 Archaea Archaea 54.7 3.24e-6   NR NKE35440.1 1961921 g157667 i0 47.9 4.8929889298893 48 17 53.1 1 125 268 40 79 NKE35440.1 multicopper oxidase domain-containing protein [Natronococcus sp. JC468] diamond 1326 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus sp. JC468
30772008 30772008 PRJNA493827_P_NODE_120794_length_311_cov_1.294118_g118596_i0 PRJNA493827 120794 311 1.294118 4.02470698 Haloferax sp. S1W 3377110 Archaea Archaea 48.1 3.51e-4   NR WP_396612920.1 3377110 g118596 i0 30.1 0.80064308681672 83 54 76.2 1 47 283 5 87 WP_396612920.1 ester cyclase [Haloferax sp. S1W] diamond 249 48.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax sp. S1W
31166398 31166398 PRJNA493827_P_NODE_150555_length_279_cov_1.427184_g148357_i0 PRJNA493827 150555 279 1.427184 3.98184336 Haladaptatus 367188 Archaea Archaea 45.8 0.00447   NR WP_069453129.1 1897478 g148357 i0 33.8 2.09677419354839 65 42 69.9 1 197 3 289 352 WP_069453129.1 ABC transporter substrate-binding protein [Haladaptatus sp. W1] diamond 585 46.2 0.991341991341991 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus sp. W1
31166410 31166410 PRJNA493827_P_NODE_23035_length_802_cov_3.766804_g21180_i0 PRJNA493827 23035 802 3.766804 30.20976808 Haladaptatus 367188 Archaea Archaea 108 1.3e-23   NR WP_244895571.1 367189 g21180 i0 35.7 2.92518703241895 196 120 71.4 4 57 629 20 214 WP_244895571.1 DUF4397 domain-containing protein [Haladaptatus paucihalophilus] diamond 2346 108 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus paucihalophilus
31182298 31182298 PRJNA493827_P_NODE_156695_length_274_cov_1.034826_g154497_i0 PRJNA493827 156695 274 1.034826 2.83542324 Halobaculum sp. MBLA 1891221 Archaea Archaea 43.1 0.0381   NR WP_370900125.1 3079933 g154497 i0 45.8 0.525547445255474 48 23 49.3 1 151 17 66 113 WP_370900125.1 hypothetical protein [Halobaculum sp. MBLA0143] diamond 144 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobaculum Halobaculum sp. MBLA0143
32873455 32873455 PRJNA493827_P_NODE_220620_length_243_cov_2.023529_g218422_i0 PRJNA493827 220620 243 2.023529 4.91717547 Methanothrix 2222 Archaea Archaea 85.5 3.28e-17   NR MDD1738293.1 90426 g218422 i0 62.9 1.51851851851852 62 23 76.5 0 56 241 604 665 MDD1738293.1 cation-transporting P-type ATPase [Methanothrix sp.] diamond 369 86.3 0.990730011587486 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.

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