RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 12 ✖

bioproject 1

  • PRJNA640143 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26732482 26732482 PRJNA640143_S_NODE_9781_length_275_cov_3.088235_g9571_i0 PRJNA640143 9781 275 3.088235 8.49264625 Sulfolobus sp. E5 2200884 Archaea Archaea 141 3.78e-41   NR TRM73768.1 2200884 g9571 i0 98.6 0.796363636363636 73 1 79.6 0 274 56 18 90 TRM73768.1 hypothetical protein DJ523_06495 [Sulfolobus sp. E5] diamond 219 141 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp. E5
27460372 27460372 PRJNA640143_S_NODE_11603_length_254_cov_2.640553_g11393_i0 PRJNA640143 11603 254 2.640553 6.70700462 Thermoproteota archaeon 2056631 Archaea Archaea 112 8.01e-27   NR MEM3368555.1 2056631 g11393 i0 98.3 0.68503937007874 58 1 68.5 0 254 81 229 286 MEM3368555.1 hypothetical protein [Thermoproteota archaeon] diamond 174 112 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27618260 27618260 PRJNA640143_S_NODE_8844_length_286_cov_23.361446_g8634_i0 PRJNA640143 8844 286 23.361446 66.81373556 Thermoproteota archaeon 2056631 Archaea Archaea 160 1.1999999999999999e-46   NR MDT7864917.1 2056631 g8634 i0 96.3 0.86013986013986 82 3 86 0 248 3 204 285 MDT7864917.1 DNA polymerase ligase N-terminal domain-containing protein [Thermoproteota archaeon] diamond 246 160 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28135865 28135865 PRJNA640143_S_NODE_5565_length_351_cov_8.585987_g5355_i0 PRJNA640143 5565 351 8.585987 30.13681437 root 1 Root_unresolved Root_unresolved 70.9 1.58e-12   NR NSL74800.1 2026795 g5355 i0 34.4 5.1025641025641 93 56 76.1 2 3 269 3 94 NSL74800.1 nicotinamide-nucleotide adenylyltransferase [Nitrososphaerota archaeon] diamond 1791 71.2 0.995786516853933 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28375814 28375814 PRJNA640143_S_NODE_5946_length_341_cov_2.207237_g5736_i0 PRJNA640143 5946 341 2.207237 7.52667817 Pyrobaculum arsenaticum 121277 Archaea Archaea 118 3.35e-32   NR WP_345803932.1 121277 g5736 i0 98.4 0.563049853372434 64 1 56.3 0 193 2 1 64 WP_345803932.1 pH regulation protein F [Pyrobaculum arsenaticum] diamond 192 118 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
28786159 28786159 PRJNA640143_S_NODE_11467_length_255_cov_14.165138_g11257_i0 PRJNA640143 11467 255 14.165138 36.1211019 Thermoproteota archaeon 2056631 Archaea Archaea 137 8.17e-39   NR MDT7864673.1 2056631 g11257 i0 89 0.858823529411765 73 8 85.9 0 221 3 35 107 MDT7864673.1 hypothetical protein [Thermoproteota archaeon] diamond 219 137 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28880958 28880958 PRJNA640143_S_NODE_6648_length_325_cov_2.006944_g6438_i0 PRJNA640143 6648 325 2.006944 6.522568 Thermoproteota archaeon 2056631 Archaea Archaea 179 4.55e-54   NR MEM3368512.1 2056631 g6438 i0 98 0.932307692307692 101 2 93.2 0 305 3 121 221 MEM3368512.1 hypothetical protein [Thermoproteota archaeon] diamond 303 179 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29228607 29228607 PRJNA640143_S_NODE_30909_length_155_cov_1.898305_g30699_i0 PRJNA640143 30909 155 1.898305 2.94237275 Thermoproteota archaeon 2056631 Archaea Archaea 71.6 1.7e-13   NR MEM3368514.1 2056631 g30699 i0 80 0.870967741935484 45 9 87.1 0 135 1 144 188 MEM3368514.1 hypothetical protein [Thermoproteota archaeon] diamond 135 71.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30175710 30175710 PRJNA640143_S_NODE_7592_length_306_cov_189.631970_g7382_i0 PRJNA640143 7592 306 189.63197 580.2738282 Thermoproteota archaeon 2056631 Archaea Archaea 152 3.34e-41   NR MEM3368555.1 2056631 g7382 i0 95.5 0.872549019607843 89 4 87.3 0 40 306 90 178 MEM3368555.1 hypothetical protein [Thermoproteota archaeon] diamond 267 152 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31281633 31281633 PRJNA640143_S_NODE_8455_length_292_cov_4.952941_g8245_i0 PRJNA640143 8455 292 4.952941 14.46258772 Thermoproteota archaeon 2056631 Archaea Archaea 102 1.17e-24   NR MEM3368577.1 2056631 g8245 i0 94.9 0.606164383561644 59 2 60.6 1 21 197 1 58 MEM3368577.1 hypothetical protein [Thermoproteota archaeon] diamond 177 102 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31345066 31345066 PRJNA640143_S_NODE_3236_length_442_cov_22.335802_g3042_i0 PRJNA640143 3236 442 22.335802 98.72424484 Thermoproteota archaeon 2056631 Archaea Archaea 227 9.89e-74   NR MDT7864916.1 2056631 g3042 i0 93.4 0.821266968325792 121 8 82.1 0 395 33 1 121 MDT7864916.1 dUTP diphosphatase [Thermoproteota archaeon] diamond 363 227 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31598230 31598230 PRJNA640143_S_NODE_18176_length_205_cov_7.446429_g17966_i0 PRJNA640143 18176 205 7.446429 15.26517945 Thermoproteota archaeon 2056631 Archaea Archaea 65.5 3.62e-12   NR MDT7864682.1 2056631 g17966 i0 96.9 0.468292682926829 32 1 46.8 0 110 205 1 32 MDT7864682.1 hypothetical protein [Thermoproteota archaeon] diamond 96 65.5 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);;