RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 7 ✖

bioproject 1

  • PRJNA1174207 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26723465 26723465 PRJNA1174207_P_NODE_21661_length_306_cov_2.278970_g21132_i0 PRJNA1174207 21661 306 2.27897 6.9736482 archaeon 1906665 Archaea Archaea 124 2.77e-33   NR MDP2434978.1 1906665 g21132 i0 59.4 0.990196078431373 101 40 99 1 2 304 109 208 MDP2434978.1 glycoside hydrolase family 25 protein [archaeon] diamond 303 124 1 Archaea               archaeon
26977173 26977173 PRJNA1174207_P_NODE_39662_length_243_cov_0.905882_g39133_i0 PRJNA1174207 39662 243 0.905882 2.20129326 Nitrosarchaeum sp. 2026886 Archaea Archaea 89.7 1.11e-18   NR MEX2192498.1 2026886 g39133 i0 57.3 1.01234567901235 82 34 100 1 1 243 826 907 MEX2192498.1 N-6 DNA methylase [Nitrosarchaeum sp.] diamond 246 89.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
27577652 27577652 PRJNA1174207_P_NODE_9364_length_504_cov_2.238979_g8838_i0 PRJNA1174207 9364 504 2.238979 11.28445416 archaeon 1906665 Archaea Archaea 43.5 0.0423   NR MCQ2816078.1 1906665 g8838 i0 30.6 0.369047619047619 62 43 36.9 0 187 2 32 93 MCQ2816078.1 EF-hand domain-containing protein [archaeon] diamond 186 43.5 1 Archaea               archaeon
31525989 31525989 PRJNA1174207_P_NODE_32976_length_252_cov_1.636872_g32447_i0 PRJNA1174207 32976 252 1.636872 4.12491744 Nanobdellota archaeon 2026764 Archaea Archaea 75.1 1.6e-13   NR MCK5629034.1 2026764 g32447 i0 50.7 1.5952380952381 67 33 79.8 0 1 201 175 241 MCK5629034.1 diaminopimelate decarboxylase [Nanoarchaeota archaeon] diamond 402 75.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
32253791 32253791 PRJNA1174207_P_NODE_26338_length_280_cov_1.386473_g25809_i0 PRJNA1174207 26338 280 1.386473 3.8821244 Methanobacteriota archaeon 2026739 Archaea Archaea 43.1 0.0272   NR MAV06623.1 2026739 g25809 i0 31 0.9 84 52 86.8 3 266 24 101 181 MAV06623.1 hypothetical protein [Methanobacteriota archaeon] diamond 252 43.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32664161 32664161 PRJNA1174207_P_NODE_29340_length_267_cov_1.912371_g28811_i0 PRJNA1174207 29340 267 1.912371 5.10603057 archaeon 1906665 Archaea Archaea 117 7.879999999999999e-31   NR RYG50181.1 1906665 g28811 i0 65.9 2.01123595505618 88 30 98.9 0 3 266 32 119 RYG50181.1 MAG: hypothetical protein EON67_05740, partial [archaeon] diamond 537 117 1 Archaea               archaeon
32884611 32884611 PRJNA1174207_P_NODE_36460_length_247_cov_1.327586_g35931_i0 PRJNA1174207 36460 247 1.327586 3.27913742 archaeon 1906665 Archaea Archaea 92 1.33e-19   NR MCQ2821526.1 1906665 g35931 i0 75.5 3.88663967611336 53 13 64.4 0 167 9 183 235 MCQ2821526.1 protein kinase [archaeon] diamond 960 92 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);;