RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA743294" 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 · 15 ✖

bioproject 1

  • PRJNA743294 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
27663106 27663106 PRJNA743294_P_NODE_53144_length_245_cov_1.779070_g52688_i0 PRJNA743294 53144 245 1.77907 4.3587215 root 1 Root_unresolved Root_unresolved 44.7 0.00777   NR WP_052725692.1 2208 g52688 i0 40 7.67755102040816 60 35 73.5 1 192 13 82 140 WP_052725692.1 PKD domain-containing protein [Methanosarcina barkeri] diamond 1881 44.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina barkeri
28252724 28252724 PRJNA743294_P_NODE_45306_length_255_cov_1.510989_g44850_i0 PRJNA743294 45306 255 1.510989 3.85302195 Natronolimnohabitans sp. A-GB9 3069757 Archaea Archaea 67.4 8.81e-11   NR WP_306759904.1 3069757 g44850 i0 54.1 0.870588235294118 74 29 87.1 3 2 223 316 384 WP_306759904.1 GH32 C-terminal domain-containing protein [Natronolimnohabitans sp. A-GB9] diamond 222 67.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronolimnohabitans Natronolimnohabitans sp. A-GB9
28347477 28347477 PRJNA743294_P_NODE_2766_length_893_cov_2.665854_g2425_i0 PRJNA743294 2766 893 2.665854 23.80607622 Methanoregulaceae archaeon 2485498 Archaea Archaea 69.3 4.58e-9   NR HNJ81026.1 2485498 g2425 i0 53.3 0.201567749160134 60 26 20.2 1 788 609 603 660 HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] diamond 180 69.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon
28452455 28452455 PRJNA743294_P_NODE_5166_length_673_cov_2.315000_g4723_i0 PRJNA743294 5166 673 2.315 15.57995 root 1 Root_unresolved Root_unresolved 166 3.02e-43   NR OPX78749.1 1811685 g4723 i0 45 1.97473997028232 222 108 97.6 7 11 667 1539 1749 OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039] diamond 1329 166 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanosaeta sp. PtaB.Bin039
28515497 28515497 PRJNA743294_P_NODE_23867_length_336_cov_1.650190_g23411_i0 PRJNA743294 23867 336 1.65019 5.5446384 root 1 Root_unresolved Root_unresolved 104 5.11e-25   NR RLG24560.1 2250255 g23411 i0 52.3 2.91964285714286 109 52 97.3 0 9 335 14 122 RLG24560.1 MAG: pyrroline-5-carboxylate reductase, partial [Methanosarcinales archaeon] diamond 981 105 0.990476190476191 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
28631890 28631890 PRJNA743294_P_NODE_40367_length_268_cov_1.133333_g39911_i0 PRJNA743294 40367 268 1.133333 3.03733244 Halobacteriales archaeon 1904752 Archaea Archaea 45.4 0.00543   NR MDX1748068.1 1904752 g39911 i0 75.9 0.626865671641791 29 7 32.5 0 1 87 3 31 MDX1748068.1 LamG-like jellyroll fold domain-containing protein [Halobacteriales archaeon] diamond 168 45.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     Halobacteriales archaeon
28979124 28979124 PRJNA743294_P_NODE_34168_length_287_cov_2.186916_g33712_i0 PRJNA743294 34168 287 2.186916 6.27644892 Methanomicrobiales archaeon 2184052 Archaea Archaea 82.8 6.24e-17   NR MDD1679754.1 2184052 g33712 i0 43.6 0.982578397212544 94 53 98.3 0 4 285 5 98 MDD1679754.1 cation transporting ATPase C-terminal domain-containing protein [Methanomicrobiales archaeon] diamond 282 82.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
29168600 29168600 PRJNA743294_P_NODE_29429_length_306_cov_2.635193_g28973_i0 PRJNA743294 29429 306 2.635193 8.06369058 Methanospirillum sp. 45200 Archaea Archaea 45.4 0.00699   NR MEN6519097.1 45200 g28973 i0 41.1 0.901960784313726 56 32 53.9 1 37 201 168 223 MEN6519097.1 hypothetical protein [Methanospirillum sp.] diamond 276 45.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
29904856 29904856 PRJNA743294_P_NODE_41451_length_265_cov_0.869792_g40995_i0 PRJNA743294 41451 265 0.869792 2.3049488 Halovivax 332951 Archaea Archaea 50.1 9.95e-5   NR WP_007699857.1 332953 g40995 i0 34.2 2.54716981132075 79 51 88.3 1 30 263 90 168 WP_007699857.1 CHRD domain-containing protein [Halovivax asiaticus] diamond 675 50.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovivax Halovivax asiaticus
30495044 30495044 PRJNA743294_P_NODE_11133_length_475_cov_3.228856_g10677_i0 PRJNA743294 11133 475 3.228856 15.337066 Methanospirillum sp. 45200 Archaea Archaea 47 0.00743   NR MDD1723749.1 45200 g10677 i0 73.3 0.397894736842105 30 8 18.9 0 402 313 24 53 MDD1723749.1 C39 family peptidase [Methanospirillum sp.] diamond 189 47 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
31253296 31253296 PRJNA743294_P_NODE_38235_length_274_cov_1.487562_g37779_i0 PRJNA743294 38235 274 1.487562 4.07591988 Methanolacinia paynteri 230356 Archaea Archaea 48.9 4.75e-5   NR WP_157199044.1 230356 g37779 i0 45.9 0.405109489051095 37 20 40.5 0 70 180 35 71 WP_157199044.1 tetratricopeptide repeat protein, partial [Methanolacinia paynteri] diamond 111 48.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanolacinia Methanolacinia paynteri
31294954 31294954 PRJNA743294_P_NODE_22615_length_344_cov_1.151292_g22159_i0 PRJNA743294 22615 344 1.151292 3.96044448 Methanoregula 395331 Archaea Archaea 146 1.48e-38   NR WP_015286036.1 882104 g22159 i0 60.4 7.3953488372093 106 41 92.4 1 343 26 455 559 WP_015286036.1 AMP-binding protein [Methanoregula formicica] diamond 2544 147 0.993197278911565 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula formicica
31800860 31800860 PRJNA743294_P_NODE_12117_length_457_cov_3.026042_g11661_i0 PRJNA743294 12117 457 3.026042 13.82901194 root 1 Root_unresolved Root_unresolved 46.2 0.0155   NR OPX68170.1 1811720 g11661 i0 57.1 0.557986870897155 35 15 23 0 443 339 187 221 OPX68170.1 MAG: lipoprotein NlpI [Methanoregulaceae archaeon PtaB.Bin009] diamond 255 46.6 0.991416309012876 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon PtaB.Bin009
32613356 32613356 PRJNA743294_P_NODE_18720_length_374_cov_1.521595_g18264_i0 PRJNA743294 18720 374 1.521595 5.6907653 Methanosarcinales archaeon 2250255 Archaea Archaea 49.7 8.16e-5   NR NYT02140.1 2250255 g18264 i0 45.7 0.368983957219251 46 25 36.9 0 17 154 62 107 NYT02140.1 hypothetical protein [Methanosarcinales archaeon] diamond 138 49.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
32906718 32906718 PRJNA743294_P_NODE_37960_length_275_cov_1.321782_g37504_i0 PRJNA743294 37960 275 1.321782 3.6349005 Methanoculleus 45989 Archaea Archaea 43.1 0.028   NR MDD3071884.1 528314 g37504 i0 37.2 0.938181818181818 43 27 46.9 0 228 100 131 173 MDD3071884.1 flavodoxin family protein [Methanoculleus horonobensis] diamond 258 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus horonobensis

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