RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
2574913 2574913 PRJEB28062_P_NODE_54523_length_479_cov_1.623153_g52170_i0 PRJEB28062 54523 479 1.623153 7.77490287 Thermoproteota archaeon 2056631 Archaea Archaea 75.1 2.4e-12   NR NLB77256.1 2056631 g52170 i0 36.7 1.05845511482255 169 90 99.6 6 1 477 201 362 NLB77256.1 hypothetical protein [Thermoproteota archaeon] diamond 507 75.1 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
20425260 20425260 PRJEB28062_P_NODE_33337_length_636_cov_13.451155_g31026_i0 PRJEB28062 33337 636 13.451155 85.5493458 Thermoproteota archaeon 2056631 Archaea Archaea 220 1.02e-65   NR MEM3368575.1 2056631 g31026 i0 92 0.528301886792453 112 9 52.8 0 618 283 384 495 MEM3368575.1 hypothetical protein [Thermoproteota archaeon] diamond 336 220 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27127610 27127610 PRJEB28062_P_NODE_131622_length_238_cov_3.854545_g129258_i0 PRJEB28062 131622 238 3.854545 9.1738171 Thermoproteota archaeon 2056631 Archaea Archaea 135 1.1599999999999999e-34   NR MEM3368522.1 2056631 g129258 i0 97.2 0.907563025210084 72 2 90.8 0 216 1 284 355 MEM3368522.1 hypothetical protein [Thermoproteota archaeon] diamond 216 135 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27475601 27475601 PRJEB28062_P_NODE_14163_length_1017_cov_121.291314_g12328_i0 PRJEB28062 14163 1017 121.291314 1233.53266338 Thermoproteota archaeon 2056631 Archaea Archaea 353 3.349999999999999e-107   NR MEM3368556.1 2056631 g12328 i0 90.7 0.601769911504425 204 19 60.2 0 633 22 550 753 MEM3368556.1 hypothetical protein [Thermoproteota archaeon] diamond 612 353 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27854477 27854477 PRJEB28062_P_NODE_53005_length_487_cov_4.541063_g50652_i0 PRJEB28062 53005 487 4.541063 22.11497681 Thermoproteota archaeon 2056631 Archaea Archaea 197 1.4299999999999995e-55   NR MEM3368578.1 2056631 g50652 i0 87.5 0.739219712525667 120 15 73.9 0 3 362 53 172 MEM3368578.1 hypothetical protein [Thermoproteota archaeon] diamond 360 197 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28296429 28296429 PRJEB28062_P_NODE_18286_length_882_cov_20.192831_g16301_i0 PRJEB28062 18286 882 20.192831 178.10076942 Thermoproteota archaeon 2056631 Archaea Archaea 406 4.47e-141   NR MEM3368571.1 2056631 g16301 i0 95.9 0.738095238095238 217 9 73.8 0 68 718 1 217 MEM3368571.1 hypothetical protein [Thermoproteota archaeon] diamond 651 406 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28327988 28327988 PRJEB28062_P_NODE_59686_length_453_cov_33.228947_g57327_i0 PRJEB28062 59686 453 33.228947 150.52712991 Thermoproteota archaeon 2056631 Archaea Archaea 268 1.78e-85   NR MEM3368575.1 2056631 g57327 i0 93 0.940397350993378 142 10 94 0 6 431 33 174 MEM3368575.1 hypothetical protein [Thermoproteota archaeon] diamond 426 268 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28707110 28707110 PRJEB28062_P_NODE_42587_length_554_cov_13.650728_g40251_i0 PRJEB28062 42587 554 13.650728 75.62503312 Thermoproteota archaeon 2056631 Archaea Archaea 144 5.349999999999999e-37   NR MEM3369231.1 2056631 g40251 i0 91 0.422382671480144 78 7 42.2 0 24 257 457 534 MEM3369231.1 hypothetical protein [Thermoproteota archaeon] diamond 234 144 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28826595 28826595 PRJEB28062_P_NODE_37848_length_593_cov_20.159615_g35521_i0 PRJEB28062 37848 593 20.159615 119.54651695 Archaea 2157 Archaea Archaea 119 4.49e-28   NR MEM0326648.1 2184738 g35521 i0 59.4 0.971332209106239 96 39 48.6 0 85 372 331 426 MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 576 119 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
29023087 29023087 PRJEB28062_P_NODE_125828_length_248_cov_3.034286_g123464_i0 PRJEB28062 125828 248 3.034286 7.52502928 Desulfurococcaceae archaeon 2184738 Archaea Archaea 57.8 1.96e-7   NR MEM4620693.1 2184738 g123464 i0 43.8 2.49193548387097 64 29 75 2 16 201 191 249 MEM4620693.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 618 57.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
30222731 30222731 PRJEB28062_P_NODE_75732_length_391_cov_7.273585_g73370_i0 PRJEB28062 75732 391 7.273585 28.43971735 Thermoproteota archaeon 2056631 Archaea Archaea 166 1.27e-44   NR MEM3368578.1 2056631 g73370 i0 90.6 0.736572890025575 96 9 73.7 0 309 22 707 802 MEM3368578.1 hypothetical protein [Thermoproteota archaeon] diamond 288 166 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30311611 30311611 PRJEB28062_P_NODE_72172_length_403_cov_32.854545_g69811_i0 PRJEB28062 72172 403 32.854545 132.40381635 Archaea 2157 Archaea Archaea 107 2.6999999999999993e-24   NR MEM0326648.1 2184738 g69811 i0 44.2 1.92059553349876 129 63 90.8 4 26 391 19 145 MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 774 108 0.990740740740741 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
30343222 30343222 PRJEB28062_P_NODE_135872_length_218_cov_4.027586_g133508_i0 PRJEB28062 135872 218 4.027586 8.78013748 root 1 Root_unresolved Root_unresolved 117 4.58e-29   NR WP_345803937.1 121277 g133508 i0 94.2 1.89908256880734 69 4 95 0 10 216 29 97 WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] diamond 414 117 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
30381170 30381170 PRJEB28062_P_NODE_40173_length_573_cov_44.824000_g37840_i0 PRJEB28062 40173 573 44.824 256.84152 Thermoproteota archaeon 2056631 Archaea Archaea 212 2.69e-65   NR MEM3368500.1 2056631 g37840 i0 93.6 0.570680628272251 109 7 57.1 0 18 344 85 193 MEM3368500.1 M23 family metallopeptidase [Thermoproteota archaeon] diamond 327 212 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30823076 30823076 PRJEB28062_P_NODE_126954_length_246_cov_76.410405_g124590_i0 PRJEB28062 126954 246 76.410405 187.9695963 Pyrobaculum arsenaticum 121277 Archaea Archaea 140 2.4e-37   NR WP_345803937.1 121277 g124590 i0 97.3 0.902439024390244 74 2 90.2 0 2 223 92 165 WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] diamond 222 140 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
31297106 31297106 PRJEB28062_P_NODE_56515_length_468_cov_36.443038_g54161_i0 PRJEB28062 56515 468 36.443038 170.55341784 Thermoproteota archaeon 2056631 Archaea Archaea 242 7.71e-77   NR MEM3368593.1 2056631 g54161 i0 87.3 0.91025641025641 142 18 91 0 458 33 203 344 MEM3368593.1 hypothetical protein [Thermoproteota archaeon] diamond 426 242 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31328713 31328713 PRJEB28062_P_NODE_107456_length_293_cov_3.731818_g105093_i0 PRJEB28062 107456 293 3.731818 10.93422674 Thermoproteota archaeon 2056631 Archaea Archaea 61.2 4.96e-10   NR MEM3368535.1 2056631 g105093 i0 96.3 0.276450511945392 27 1 27.6 0 93 13 13 39 MEM3368535.1 hypothetical protein [Thermoproteota archaeon] diamond 81 61.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31423646 31423646 PRJEB28062_P_NODE_80016_length_377_cov_2.720395_g77654_i0 PRJEB28062 80016 377 2.720395 10.25588915 Pyrobaculum arsenaticum 121277 Archaea Archaea 224 3.62e-71   NR WP_345803934.1 121277 g77654 i0 97.6 0.994694960212202 125 3 99.5 0 3 377 137 261 WP_345803934.1 hydrogenase subunit MbhD domain-containing protein [Pyrobaculum arsenaticum] diamond 375 224 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
31581941 31581941 PRJEB28062_P_NODE_135276_length_223_cov_4.506667_g132912_i0 PRJEB28062 135276 223 4.506667 10.04986741 Thermoproteota archaeon 2056631 Archaea Archaea 69.3 1.58e-13   NR MEM3368791.1 2056631 g132912 i0 78 0.551569506726457 41 9 55.2 0 131 9 1 41 MEM3368791.1 hypothetical protein [Thermoproteota archaeon] diamond 123 69.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31613437 31613437 PRJEB28062_P_NODE_69996_length_411_cov_12.840237_g67635_i0 PRJEB28062 69996 411 12.840237 52.77337407 Fervidicoccaceae archaeon 2614264 Archaea Archaea 71.2 5.82e-13   NR MEM4709340.1 2614264 g67635 i0 55.6 0.905109489051095 63 28 46 0 1 189 43 105 MEM4709340.1 DUF1874 domain-containing protein [Fervidicoccaceae archaeon] diamond 372 71.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Fervidicoccales Fervidicoccaceae   Fervidicoccaceae archaeon
31670159 31670159 PRJEB28062_P_NODE_117797_length_266_cov_1.595855_g115434_i0 PRJEB28062 117797 266 1.595855 4.2449743 root 1 Root_unresolved Root_unresolved 114 5.21e-29   NR WP_345803883.1 121277 g115434 i0 84.8 1.48872180451128 66 8 72.2 1 73 264 192 257 WP_345803883.1 hypothetical protein [Pyrobaculum arsenaticum] diamond 396 114 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
32303281 32303281 PRJEB28062_P_NODE_89479_length_346_cov_11.424908_g87117_i0 PRJEB28062 89479 346 11.424908 39.53018168 root 1 Root_unresolved Root_unresolved 195 1.6300000000000002e-58   NR WP_345803936.1 121277 g87117 i0 96.4 1.92485549132948 111 4 96.2 0 337 5 22 132 WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] diamond 666 195 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
32751485 32751485 PRJEB28062_P_NODE_37540_length_596_cov_12.464627_g35213_i0 PRJEB28062 37540 596 12.464627 74.28917692 Thermoproteota archaeon 2056631 Archaea Archaea 156 9.97e-44   NR MEM3368592.1 2056631 g35213 i0 75.5 0.493288590604027 98 24 49.3 0 408 115 17 114 MEM3368592.1 hypothetical protein [Thermoproteota archaeon] diamond 294 156 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32751495 32751495 PRJEB28062_P_NODE_53680_length_483_cov_18.073171_g51327_i0 PRJEB28062 53680 483 18.073171 87.29341593 Pyrobaculum arsenaticum 121277 Archaea Archaea 267 1.04e-84   NR WP_345803937.1 121277 g51327 i0 95.2 0.906832298136646 146 6 90.7 1 45 482 103 247 WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] diamond 438 267 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum

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