RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA641991 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 0

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
4445477 4445477 PRJNA641991_S_NODE_5604_length_229_cov_1.416667_g5485_i0 PRJNA641991 5604 229 1.416667 3.24416743 archaeon 1906665 Archaea Archaea 144 3.1e-39   NR MDP2436508.1 1906665 g5485 i0 89.5 0.995633187772926 76 8 99.6 0 229 2 170 245 MDP2436508.1 translation elongation factor EF-1 subunit alpha [archaeon] diamond 228 144 1 Archaea               archaeon
31629890 31629890 PRJNA641991_P_NODE_2216_length_205_cov_0.993590_g2175_i0 PRJNA641991 2216 205 0.99359 2.0368595 Nanobdellota archaeon 2026764 Archaea Archaea 40 0.0384   NR MBU0953204.1 2026764 g2175 i0 37.2 0.629268292682927 43 27 62.9 0 52 180 9 51 MBU0953204.1 30S ribosomal protein S14 [Nanoarchaeota archaeon] diamond 129 40 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
31693081 31693081 PRJNA641991_P_NODE_3937_length_163_cov_0.894737_g3896_i0 PRJNA641991 3937 163 0.894737 1.45842131 archaeon 1906665 Archaea Archaea 89.7 2e-19   NR MDP2437711.1 1906665 g3896 i0 77.4 0.975460122699387 53 12 97.5 0 162 4 321 373 MDP2437711.1 phosphatase PAP2 family protein [archaeon] diamond 159 89.7 1 Archaea               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);;