RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA631119", tax_clade = "Methanomada group" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Methanomada group · 4 ✖

bioproject 1

  • PRJNA631119 · 4 ✖

analysis 1

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
27630694 27630694 PRJNA631119_P_NODE_28944_length_257_cov_1.940217_g28826_i0 PRJNA631119 28944 257 1.940217 4.98635769 root 1 Root_unresolved Root_unresolved 63.9 1.51e-9   NR WP_406533356.1 66852 g28826 i0 39.1 9.45525291828794 69 42 80.5 0 244 38 572 640 WP_406533356.1 IGHMBP2 family helicase [Methanobrevibacter sp.] diamond 2430 64.3 0.993779160186625 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
29828072 29828072 PRJNA631119_P_NODE_39791_length_238_cov_3.696970_g39673_i0 PRJNA631119 39791 238 3.69697 8.7987886 Methanobrevibacter sp. 87.7 387957 Archaea Archaea 57.4 2.48e-7   NR WP_143744798.1 387957 g39673 i0 56.5 1.27310924369748 46 20 58 0 177 40 252 297 WP_143744798.1 hypothetical protein, partial [Methanobrevibacter sp. 87.7] diamond 303 57.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. 87.7
29954540 29954540 PRJNA631119_P_NODE_22671_length_283_cov_2.690476_g22553_i0 PRJNA631119 22671 283 2.690476 7.61404708 Methanobrevibacter sp. 66852 Archaea Archaea 51.6 4.38e-5   NR MBP3226884.1 66852 g22553 i0 39.3 0.593639575971731 56 34 59.4 0 87 254 105 160 MBP3226884.1 hypothetical protein [Methanobrevibacter sp.] diamond 168 51.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
30586225 30586225 PRJNA631119_P_NODE_13333_length_344_cov_1.697417_g13215_i0 PRJNA631119 13333 344 1.697417 5.83911448 Methanocaldococcus jannaschii 2190 Archaea Archaea 68.2 1.46e-10   NR WP_010870556.1 2190 g13215 i0 33.6 2.07558139534884 119 69 99.4 3 342 1 154 267 WP_010870556.1 DNA-directed RNA polymerase subunit A'' [Methanocaldococcus jannaschii] diamond 714 68.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus jannaschii

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