RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 12 ✖

bioproject 1

  • PRJNA773247 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
5852700 5852700 PRJNA773247_P_NODE_7165_length_622_cov_6.176685_g7082_i0 PRJNA773247 7165 622 6.176685 38.4189807 Halalkalicoccus subterraneus 2675002 Archaea Archaea 234 2.97e-72   NR WP_122088266.1 2675002 g7082 i0 83.3 0.665594855305466 138 23 66.6 0 434 21 1 138 WP_122088266.1 DUF7289 family protein [Halalkalicoccus subterraneus] diamond 414 234 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus subterraneus
7127421 7127421 PRJNA773247_P_NODE_12226_length_437_cov_3.230769_g12143_i0 PRJNA773247 12226 437 3.230769 14.11846053 Halalkalicoccus subterraneus 2675002 Archaea Archaea 234 3.08e-76   NR WP_122089653.1 2675002 g12143 i0 82.7 0.954233409610984 139 24 95.4 0 418 2 1 139 WP_122089653.1 hypothetical protein [Halalkalicoccus subterraneus] diamond 417 234 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus subterraneus
27021728 27021728 PRJNA773247_P_NODE_34142_length_242_cov_3.609467_g34058_i0 PRJNA773247 34142 242 3.609467 8.73491014 Methanohalobium sp. 2837493 Archaea Archaea 95.9 3.48e-22   NR WP_292487842.1 2837493 g34058 i0 53.8 0.991735537190083 80 36 99.2 1 2 241 140 218 WP_292487842.1 DNA-methyltransferase, partial [Methanohalobium sp.] diamond 240 95.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanohalobium Methanohalobium sp.
27116340 27116340 PRJNA773247_P_NODE_32782_length_245_cov_2.802326_g32698_i0 PRJNA773247 32782 245 2.802326 6.8656987 Methanosarcina sp. 2213 Archaea Archaea 117 4.079999999999999e-32   NR HET8689608.1 2213 g32698 i0 84.1 0.771428571428571 63 10 77.1 0 2 190 54 116 HET8689608.1 hypothetical protein [Methanosarcina sp.] diamond 189 117 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
28199656 28199656 PRJNA773247_P_NODE_18846_length_333_cov_2.430769_g18762_i0 PRJNA773247 18846 333 2.430769 8.09446077 root 1 Root_unresolved Root_unresolved 85.1 1.16e-18   NR HON37095.1 90426 g18762 i0 46.2 2.79279279279279 104 42 89.2 2 314 18 3 97 HON37095.1 HNH endonuclease [Methanothrix sp.] diamond 930 85.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28316716 28316716 PRJNA773247_P_NODE_30946_length_249_cov_3.857955_g30862_i0 PRJNA773247 30946 249 3.857955 9.60630795 Methanomicrobiales archaeon 2184052 Archaea Archaea 53.1 3.28e-6   NR NLZ31335.1 2184052 g30862 i0 48.9 0.566265060240964 47 21 56.6 1 98 238 1 44 NLZ31335.1 hypothetical protein [Methanomicrobiales archaeon] diamond 141 53.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
28821527 28821527 PRJNA773247_P_NODE_24248_length_285_cov_9.971698_g24164_i0 PRJNA773247 24248 285 9.971698 28.4193393 Methanoregula sp. 2052170 Archaea Archaea 57 5.94e-7   NR MCK9591864.1 2052170 g24164 i0 54.4 3.09473684210526 57 25 60 1 8 178 275 330 MCK9591864.1 collagen-like protein [Methanoregula sp.] diamond 882 57 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
29232411 29232411 PRJNA773247_P_NODE_36089_length_231_cov_2.272152_g36005_i0 PRJNA773247 36089 231 2.272152 5.24867112 Methanothrix sp. 90426 Archaea Archaea 58.2 1.76e-8   NR HOK59086.1 90426 g36005 i0 66.7 0.948051948051948 39 13 50.6 0 41 157 59 97 HOK59086.1 hypothetical protein [Methanothrix sp.] diamond 219 58.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
29516276 29516276 PRJNA773247_P_NODE_27730_length_264_cov_1.596859_g27646_i0 PRJNA773247 27730 264 1.596859 4.21570776 Halobacteria archaeon 2670410 Archaea Archaea 43.9 0.017   NR MEM2990173.1 2670410 g27646 i0 38.8 1.125 49 27 55.7 2 173 27 141 186 MEM2990173.1 metallophosphoesterase [Halobacteria archaeon] diamond 297 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria       Halobacteria archaeon
30347740 30347740 PRJNA773247_P_NODE_24872_length_281_cov_3.677885_g24788_i0 PRJNA773247 24872 281 3.677885 10.33485685 root 1 Root_unresolved Root_unresolved 60.1 3.56e-8   NR WP_006825677.1 160846 g24788 i0 39.1 2.85053380782918 87 51 92.9 1 21 281 97 181 WP_006825677.1 DNA adenine methylase [Natrialba taiwanensis] diamond 801 60.5 0.993388429752066 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrialba Natrialba taiwanensis
32654771 32654771 PRJNA773247_P_NODE_35240_length_239_cov_2.355422_g35156_i0 PRJNA773247 35240 239 2.355422 5.62945858 root 1 Root_unresolved Root_unresolved 67.4 1.19e-11   NR WP_148858122.1 2055836 g35156 i0 40 1.9581589958159 80 47 99.2 1 239 3 15 94 WP_148858122.1 flavodoxin domain-containing protein [Natronococcus pandeyae] diamond 468 67.8 0.994100294985251 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus pandeyae
32897317 32897317 PRJNA773247_P_NODE_26180_length_273_cov_1.415000_g26096_i0 PRJNA773247 26180 273 1.415 3.86295 Methanoculleus sp. UBA45 1915512 Archaea Archaea 43.9 0.0135   NR WP_343241183.1 1915512 g26096 i0 31.9 2.91208791208791 72 45 79.1 3 272 57 2 69 WP_343241183.1 hypothetical protein [Methanoculleus sp. UBA45] diamond 795 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp. UBA45

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);;