RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA436017" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA436017 · 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
26822822 26822822 PRJNA436017_P_NODE_15561_length_210_cov_1.127168_g15263_i0 PRJNA436017 15561 210 1.127168 2.3670528 Methanocaldococcus villosus 667126 Archaea Archaea 46.2 6.57e-4   NR WP_004592618.1 667126 g15263 i0 42.4 0.942857142857143 66 20 94.3 2 10 207 93 140 WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus] diamond 198 46.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus villosus
30107319 30107319 PRJNA436017_P_NODE_15512_length_210_cov_1.791908_g15214_i0 PRJNA436017 15512 210 1.791908 3.7630068 Methanobacteriota archaeon 2026739 Archaea Archaea 69.3 5.52e-13   NR MBU4535160.1 2026739 g15214 i0 47.9 5.02857142857143 71 35 98.6 1 209 3 34 104 MBU4535160.1 30S ribosomal protein S19 [Methanobacteriota archaeon] diamond 1056 69.3 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32368801 32368801 PRJNA436017_P_NODE_24719_length_164_cov_1.228346_g24421_i0 PRJNA436017 24719 164 1.228346 2.01448744 Methanobacteriati 3366610 Archaea Archaea 65.9 8.84e-11   NR MBB70555.1 2026739 g24421 i0 55.3 3.4390243902439 47 21 86 0 162 22 253 299 MBB70555.1 deoxyribodipyrimidine photolyase [Methanobacteriota archaeon] diamond 564 65.9 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32447263 32447263 PRJNA436017_P_NODE_14259_length_221_cov_0.804348_g13961_i0 PRJNA436017 14259 221 0.804348 1.77760908 Natronococcus sp. A-GB7 3037649 Archaea Archaea 84.7 3.28e-17   NR WP_278303070.1 3037649 g13961 i0 60.3 1.64253393665158 63 25 85.5 0 189 1 2 64 WP_278303070.1 agl cluster protein AglQ [Natronococcus sp. A-GB7] diamond 363 84.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus sp. A-GB7

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