RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA615351", tax_phylum = "Promethearchaeota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 11 ✖

tax_phylum 1

  • Promethearchaeota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615351 · 11 ✖

analysis 1

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
27111815 27111815 PRJNA615351_P_NODE_109622_length_281_cov_3.024390_g95523_i0 PRJNA615351 109622 281 3.02439 8.4985359 Promethearchaeota archaeon 2053489 Archaea Archaea 73.9 6.18e-13   NR MBD3226901.1 2053489 g95523 i0 48.6 4.644128113879 70 36 74.7 0 7 216 88 157 MBD3226901.1 GTP-binding protein [Promethearchaeota archaeon] diamond 1305 73.9 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
27775539 27775539 PRJNA615351_P_NODE_177844_length_158_cov_1.138211_g163744_i0 PRJNA615351 177844 158 1.138211 1.79837338 Promethearchaeota archaeon 2053489 Archaea Archaea 70.1 2.6e-12   NR MBY8990497.1 2053489 g163744 i0 57.7 12.8354430379747 52 22 98.7 0 1 156 73 124 MBY8990497.1 preprotein translocase subunit SecY [Promethearchaeota archaeon] diamond 2028 70.1 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
28546366 28546366 PRJNA615351_P_NODE_96267_length_334_cov_2.772575_g82172_i0 PRJNA615351 96267 334 2.772575 9.2604005 root 1 Root_unresolved Root_unresolved 62 1.76e-8   NR MBY9015406.1 2053489 g82172 i0 42.4 2.79341317365269 66 38 59.3 0 200 3 15 80 MBY9015406.1 sodium-translocating pyrophosphatase [Promethearchaeota archaeon] diamond 933 62.4 0.993589743589744 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
28577677 28577677 PRJNA615351_P_NODE_40107_length_898_cov_2.898030_g29782_i0 PRJNA615351 40107 898 2.89803 26.0243094 Archaea 2157 Archaea Archaea 105 1.38e-21   NR OLS14679.1 1849166 g29782 i0 35.4 3.94877505567929 246 137 77.8 6 54 752 219 455 OLS14679.1 MAG: arsenite efflux membrane protein ArsB [Promethearchaeota archaeon CR_4] diamond 3546 106 0.990566037735849 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon CR_4
28848756 28848756 PRJNA615351_P_NODE_48568_length_748_cov_3.110799_g36687_i0 PRJNA615351 48568 748 3.110799 23.26877652 Promethearchaeota archaeon 2053489 Archaea Archaea 118 3.28e-29   NR NHJ23470.1 2053489 g36687 i0 41.6 0.617647058823529 154 87 60.6 2 285 737 3 156 NHJ23470.1 ATP-binding protein [Promethearchaeota archaeon] diamond 462 118 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
29007169 29007169 PRJNA615351_P_NODE_44648_length_815_cov_3.828205_g32778_i1 PRJNA615351 44648 815 3.828205 31.19987075 Promethearchaeia archaeon 3067280 Archaea Archaea 82.8 5.98e-14   NR MFO8018952.1 3067280 g32778 i1 35.7 0.898159509202454 126 52 46.4 2 524 147 326 422 MFO8018952.1 trehalase family glycosidase [Promethearchaeia archaeon] diamond 732 82.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
29272033 29272033 PRJNA615351_P_NODE_126469_length_234_cov_1.497487_g112369_i0 PRJNA615351 126469 234 1.497487 3.50411958 Promethearchaeati 1935183 Archaea Archaea 66.2 1.1e-10   NR MBD3159731.1 2053489 g112369 i0 41 2 78 45 98.7 1 3 233 18 95 MBD3159731.1 elongation factor 1-alpha [Promethearchaeota archaeon] diamond 468 66.2 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
30965211 30965211 PRJNA615351_P_NODE_169274_length_166_cov_1.526718_g155174_i0 PRJNA615351 169274 166 1.526718 2.53435188 Promethearchaeota archaeon 2053489 Archaea Archaea 45.8 6.76e-4   NR TFG10099.1 2053489 g155174 i0 38.5 0.939759036144578 52 27 84.9 1 1 141 102 153 TFG10099.1 MAG: GTP-binding protein [Promethearchaeota archaeon] diamond 156 45.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
31755607 31755607 PRJNA615351_P_NODE_58297_length_617_cov_3.109966_g32778_i2 PRJNA615351 58297 617 3.109966 19.18849022 Promethearchaeia archaeon 3067280 Archaea Archaea 71.2 1.48e-10   NR MFO8018952.1 3067280 g32778 i2 36.1 0.525121555915721 108 40 52.5 2 326 3 326 404 MFO8018952.1 trehalase family glycosidase [Promethearchaeia archaeon] diamond 324 71.2 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
32166956 32166956 PRJNA615351_P_NODE_107118_length_290_cov_1.721569_g93019_i0 PRJNA615351 107118 290 1.721569 4.9925501 Promethearchaeia archaeon 3067280 Archaea Archaea 85.9 3.43e-17   NR HME52168.1 3067280 g93019 i0 45.3 1.9448275862069 95 49 98.3 3 5 289 137 228 HME52168.1 trehalase family glycosidase [Promethearchaeia archaeon] diamond 564 85.9 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
32905806 32905806 PRJNA615351_P_NODE_86480_length_385_cov_2.734286_g72409_i0 PRJNA615351 86480 385 2.734286 10.5270011 Archaea 2157 Archaea Archaea 53.9 9.25e-6   NR UCD00409.1 2053489 g72409 i0 33.8 0.896103896103896 65 43 50.6 0 196 2 7 71 UCD00409.1 MAG: GTP-binding protein [Promethearchaeota archaeon] diamond 345 53.9 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota 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);;