RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA608660 · 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
27996192 27996192 PRJNA608660_P_NODE_11345_length_442_cov_4.460560_g10998_i0 PRJNA608660 11345 442 4.46056 19.7156752 archaeon 1906665 Archaea Archaea 194 1.53e-54   NR MDP2438503.1 1906665 g10998 i0 93.1 0.68552036199095 101 7 68.6 0 137 439 166 266 MDP2438503.1 protein kinase [archaeon] diamond 303 194 1 Archaea               archaeon
28216864 28216864 PRJNA608660_P_NODE_6026_length_599_cov_4.132727_g5714_i0 PRJNA608660 6026 599 4.132727 24.75503473 Methanobacterium sp. 2164 Archaea Archaea 139 5.34e-34   NR HOI41037.1 2164 g5714 i0 48.2 0.831385642737897 166 70 75.1 4 455 6 630 795 HOI41037.1 pseudomurein-binding repeat-containing protein [Methanobacterium sp.] diamond 498 139 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
28943620 28943620 PRJNA608660_P_NODE_5288_length_634_cov_3.644444_g4987_i0 PRJNA608660 5288 634 3.644444 23.10577496 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 197 1.06e-60   NR HET7642787.1 2169593 g4987 i0 95.2 0.496845425867508 105 5 49.7 0 315 1 18 122 HET7642787.1 cupredoxin domain-containing protein [Nitrososphaeraceae archaeon] diamond 315 197 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31565708 31565708 PRJNA608660_P_NODE_37116_length_200_cov_1.026490_g36760_i0 PRJNA608660 37116 200 1.02649 2.05298 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 101 3.789999999999999e-23   NR HJT83590.1 2169593 g36760 i0 92.2 0.765 51 4 76.5 0 1 153 310 360 HJT83590.1 thioredoxin domain-containing protein [Nitrososphaeraceae archaeon] diamond 153 101 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32672176 32672176 PRJNA608660_P_NODE_10840_length_453_cov_3.170792_g10494_i0 PRJNA608660 10840 453 3.170792 14.36368776 archaeon 1906665 Archaea Archaea 182 2.04e-50   NR MDP2438503.1 1906665 g10494 i0 83.2 0.986754966887417 149 25 98.7 0 1 447 390 538 MDP2438503.1 protein kinase [archaeon] diamond 447 182 1 Archaea               archaeon
32861179 32861179 PRJNA608660_P_NODE_15200_length_375_cov_1.331288_g14847_i0 PRJNA608660 15200 375 1.331288 4.99233 archaeon 1906665 Archaea Archaea 56.2 2.86e-6   NR MDP2434168.1 1906665 g14847 i0 40.4 0.712 89 52 71.2 1 109 375 283 370 MDP2434168.1 hypothetical protein [archaeon] diamond 267 56.2 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);;