RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1262902" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

bioproject 1

  • PRJNA1262902 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27831947 27831947 PRJNA1262902_P_NODE_12164_length_241_cov_0.916667_g12122_i0 PRJNA1262902 12164 241 0.916667 2.20916747 Nitrososphaera sp. 1971748 Archaea Archaea 70.9 4.5e-12   NR HEY1248456.1 1971748 g12122 i0 43.8 0.995850622406639 80 43 97.1 1 241 8 383 462 HEY1248456.1 hypothetical protein [Nitrososphaera sp.] diamond 240 70.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30327163 30327163 PRJNA1262902_P_NODE_11272_length_243_cov_0.905882_g11230_i0 PRJNA1262902 11272 243 0.905882 2.20129326 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 76.3 2.07e-15   NR MEJ7642329.1 2109671 g11230 i0 75 0.592592592592593 48 11 58 1 240 100 94 141 MEJ7642329.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] diamond 144 76.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
30800462 30800462 PRJNA1262902_P_NODE_10014_length_245_cov_1.738372_g9972_i0 PRJNA1262902 10014 245 1.738372 4.2590114 Candidatus Heimdallarchaeota archaeon LC_3 1841598 Archaea Archaea 67 7.5e-11   NR OLS21962.1 1841598 g9972 i0 65.9 2.35102040816327 44 15 53.9 0 208 77 265 308 OLS21962.1 MAG: Ornithine carbamoyltransferase [Candidatus Heimdallarchaeota archaeon LC_3] diamond 576 67 1 Archaea   Promethearchaeati Candidatus Heimdallarchaeota         Candidatus Heimdallarchaeota archaeon LC_3
32540240 32540240 PRJNA1262902_P_NODE_2339_length_339_cov_1.157895_g2297_i0 PRJNA1262902 2339 339 1.157895 3.92526405 Candidatus Altiarchaeales archaeon 2250256 Archaea Archaea 44.3 0.0171   NR RLI93475.1 2250256 g2297 i0 34.8 0.814159292035398 92 47 69.9 4 57 293 82 173 RLI93475.1 MAG: hypothetical protein DRO94_05110, partial [Candidatus Altiarchaeales archaeon] diamond 276 44.3 1 Archaea   Nanobdellati Candidatus Altarchaeota Candidatus Altiarchaeia Candidatus Altarchaeales     Candidatus Altiarchaeales 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);;