RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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

bioproject 1

  • PRJNA1245487 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
9279358 9279358 PRJNA1245487_P_NODE_20588_length_247_cov_1.586207_g20250_i0 PRJNA1245487 20588 247 1.586207 3.91793129 archaeon 1906665 Archaea Archaea 131 1.66e-37   NR RYG67591.1 1906665 g20250 i0 79.3 0.995951417004049 82 17 99.6 0 2 247 13 94 RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon] diamond 246 131 1 Archaea               archaeon
26598464 26598464 PRJNA1245487_P_NODE_12581_length_327_cov_2.696850_g12243_i0 PRJNA1245487 12581 327 2.69685 8.8186995 Methanoregula sp. 2052170 Archaea Archaea 62.8 8.99e-9   NR MDD4136764.1 2052170 g12243 i0 40 4.19266055045872 100 40 91.7 3 22 321 162 241 MDD4136764.1 sialidase family protein [Methanoregula sp.] diamond 1371 62.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
29649117 29649117 PRJNA1245487_P_NODE_10790_length_360_cov_1.853659_g10452_i0 PRJNA1245487 10790 360 1.853659 6.6731724 root 1 Root_unresolved Root_unresolved 129 9.63e-35   NR RYH12636.1 1906665 g10452 i0 58.3 5.74166666666667 115 42 94.2 3 11 349 3 113 RYH12636.1 MAG: glutathione transferase GstA [archaeon] diamond 2067 129 1 Archaea               archaeon
31748600 31748600 PRJNA1245487_P_NODE_18057_length_262_cov_0.862434_g17719_i0 PRJNA1245487 18057 262 0.862434 2.25957708 Methanobacteriota archaeon 2026739 Archaea Archaea 70.1 7.65e-12   NR RYE99319.1 2026739 g17719 i0 43.2 0.847328244274809 74 42 84.7 0 2 223 144 217 RYE99319.1 MAG: hypothetical protein EOO41_01215 [Methanobacteriota archaeon] diamond 222 70.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota 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);;