RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA493244", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 12 ✖

tax_phylum 1

  • Thermoproteota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493244 · 12 ✖

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
28087036 28087036 PRJNA493244_P_NODE_1092025_length_368_cov_4.039088_g1068904_i0 PRJNA493244 1092025 368 4.039088 14.86384384 Thermoproteota archaeon 2056631 Archaea Archaea 221 4.729999999999999e-72   NR MDT7864681.1 2056631 g1068904 i0 91.5 0.96195652173913 118 10 96.2 0 3 356 1 118 MDT7864681.1 hypothetical protein [Thermoproteota archaeon] diamond 354 221 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28244847 28244847 PRJNA493244_P_NODE_1518626_length_238_cov_26.751412_g1495501_i0 PRJNA493244 1518626 238 26.751412 63.668360560000004 Staphylothermus marinus 2280 Archaea Archaea 43.5 0.017   NR WP_011839062.1 2280 g1495501 i0 41 0.491596638655462 39 23 49.2 0 54 170 183 221 WP_011839062.1 hypothetical protein [Staphylothermus marinus] diamond 117 43.5 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Staphylothermus Staphylothermus marinus
28339767 28339767 PRJNA493244_P_NODE_909766_length_449_cov_1.780928_g886794_i0 PRJNA493244 909766 449 1.780928 7.99636672 Thermoproteota archaeon 2056631 Archaea Archaea 151 3.47e-44   NR MEM3368602.1 2056631 g886794 i0 89.3 0.561247216035635 84 9 56.1 0 198 449 1 84 MEM3368602.1 hypothetical protein [Thermoproteota archaeon] diamond 252 151 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28655605 28655605 PRJNA493244_P_NODE_1684767_length_205_cov_6.777778_g1661642_i0 PRJNA493244 1684767 205 6.777778 13.8944449 Thermoproteota archaeon 2056631 Archaea Archaea 95.1 7.949999999999999e-23   NR MDT7864916.1 2056631 g1661642 i0 86 0.834146341463415 57 8 83.4 0 190 20 1 57 MDT7864916.1 dUTP diphosphatase [Thermoproteota archaeon] diamond 171 95.1 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29602375 29602375 PRJNA493244_P_NODE_1702750_length_203_cov_2.077465_g1679625_i0 PRJNA493244 1702750 203 2.077465 4.21725395 Thermoproteota archaeon 2056631 Archaea Archaea 115 1.02e-30   NR MDT7864916.1 2056631 g1679625 i0 88.1 0.990147783251232 67 8 99 0 201 1 3 69 MDT7864916.1 dUTP diphosphatase [Thermoproteota archaeon] diamond 201 115 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29633882 29633882 PRJNA493244_P_NODE_1334610_length_286_cov_7.120000_g1311486_i0 PRJNA493244 1334610 286 7.12 20.3632 Thermoproteota archaeon 2056631 Archaea Archaea 177 4.13e-53   NR MDT7864917.1 2056631 g1311486 i0 95.4 0.912587412587413 87 4 91.3 0 262 2 189 275 MDT7864917.1 DNA polymerase ligase N-terminal domain-containing protein [Thermoproteota archaeon] diamond 261 177 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30044717 30044717 PRJNA493244_P_NODE_1199371_length_329_cov_1.985075_g1176247_i0 PRJNA493244 1199371 329 1.985075 6.53089675 Thermoproteota archaeon 2056631 Archaea Archaea 210 5.0299999999999985e-68   NR MEM3368608.1 2056631 g1176247 i0 95.4 0.984802431610942 108 5 98.5 0 4 327 1 108 MEM3368608.1 hypothetical protein [Thermoproteota archaeon] diamond 324 210 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30739941 30739941 PRJNA493244_P_NODE_1258174_length_310_cov_1.028112_g1235050_i0 PRJNA493244 1258174 310 1.028112 3.1871472 Desulfurococcaceae archaeon 2184738 Archaea Archaea 50.4 1.49e-4   NR MEM0326648.1 2184738 g1235050 i0 43.1 0.987096774193548 102 50 97.7 3 3 305 260 354 MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 306 50.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
31181991 31181991 PRJNA493244_P_NODE_1644775_length_211_cov_1.666667_g1621650_i0 PRJNA493244 1644775 211 1.666667 3.51666737 Thermoproteota archaeon 2056631 Archaea Archaea 85.5 2.05e-17   NR MEM3368555.1 2056631 g1621650 i0 100 0.568720379146919 40 0 56.9 0 2 121 217 256 MEM3368555.1 hypothetical protein [Thermoproteota archaeon] diamond 120 85.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31277053 31277053 PRJNA493244_P_NODE_1709735_length_202_cov_11.368794_g1686610_i0 PRJNA493244 1709735 202 11.368794 22.96496388 Thermoproteota archaeon 2056631 Archaea Archaea 75.5 1.33e-14   NR MDT7864923.1 2056631 g1686610 i0 90 1.18811881188119 40 4 59.4 0 22 141 193 232 MDT7864923.1 hypothetical protein [Thermoproteota archaeon] diamond 240 75.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31435206 31435206 PRJNA493244_P_NODE_1496116_length_244_cov_1.218579_g1472991_i0 PRJNA493244 1496116 244 1.218579 2.97333276 Pyrobaculum arsenaticum 121277 Archaea Archaea 71.2 1.97e-13   NR WP_345803931.1 121277 g1472991 i0 97.1 0.430327868852459 35 1 43 0 9 113 114 148 WP_345803931.1 Na+/H+ antiporter subunit E [Pyrobaculum arsenaticum] diamond 105 71.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
32826143 32826143 PRJNA493244_P_NODE_1706220_length_203_cov_0.901408_g1683095_i0 PRJNA493244 1706220 203 0.901408 1.82985824 Thermoproteota archaeon 2056631 Archaea Archaea 131 5.6400000000000003e-36   NR MDT7864674.1 2056631 g1683095 i0 91 0.990147783251232 67 6 99 0 202 2 137 203 MDT7864674.1 7-cyano-7-deazaguanine synthase [Thermoproteota archaeon] diamond 201 131 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;