RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA670521 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
9566653 9566653 PRJNA670521_P_NODE_28768_length_366_cov_1.245734_g28023_i0 PRJNA670521 28768 366 1.245734 4.55938644 Methanosarcinales archaeon 2250255 Archaea Archaea 189 2.02e-58   NR RYE84306.1 2250255 g28023 i0 73.6 0.991803278688525 121 32 99.2 0 2 364 70 190 RYE84306.1 MAG: 50S ribosomal protein L3 [Methanosarcinales archaeon] diamond 363 189 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
26828680 26828680 PRJNA670521_P_NODE_69021_length_253_cov_1.283333_g68276_i0 PRJNA670521 69021 253 1.283333 3.24683249 Methanosarcinales archaeon 2250255 Archaea Archaea 104 1.45e-24   NR RYE85249.1 2250255 g68276 i0 56.6 0.984189723320158 83 36 98.4 0 253 5 3 85 RYE85249.1 MAG: hypothetical protein EOO65_00785 [Methanosarcinales archaeon] diamond 249 104 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
26986637 26986637 PRJNA670521_P_NODE_47542_length_302_cov_1.344978_g46797_i0 PRJNA670521 47542 302 1.344978 4.06183356 Methanosarcinales archaeon 2250255 Archaea Archaea 121 6.72e-31   NR RYE82365.1 2250255 g46797 i0 58 0.993377483443709 100 42 99.3 0 2 301 152 251 RYE82365.1 MAG: fatty acid desaturase, partial [Methanosarcinales archaeon] diamond 300 121 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
29102863 29102863 PRJNA670521_P_NODE_12088_length_519_cov_2.500000_g11353_i0 PRJNA670521 12088 519 2.5 12.975 Halorubellus sp. PRR65 3098148 Archaea Archaea 46.2 0.0311   NR WP_323675499.1 3098148 g11353 i0 35 0.578034682080925 100 54 57.2 4 24 320 607 696 WP_323675499.1 S8 family serine peptidase [Halorubellus sp. PRR65] diamond 300 46.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halorubellaceae Halorubellus Halorubellus sp. PRR65
31314008 31314008 PRJNA670521_P_NODE_66155_length_259_cov_1.645161_g65410_i0 PRJNA670521 66155 259 1.645161 4.26096699 Methanolacinia paynteri 230356 Archaea Archaea 79.7 3.84e-15   NR WP_052418800.1 230356 g65410 i0 51.8 2.82625482625483 83 39 96.1 1 250 2 48 129 WP_052418800.1 lamin tail domain-containing protein [Methanolacinia paynteri] diamond 732 79.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanolacinia Methanolacinia paynteri
31535672 31535672 PRJNA670521_P_NODE_66696_length_258_cov_1.443243_g65951_i0 PRJNA670521 66696 258 1.443243 3.72356694 Methanosarcinales archaeon 2250255 Archaea Archaea 64.7 7.35e-10   NR RYE85335.1 2250255 g65951 i0 53.6 0.651162790697674 56 26 65.1 0 29 196 270 325 RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon] diamond 168 64.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon

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