RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA993416 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27126740 27126740 PRJNA993416_P_NODE_9662_length_277_cov_1.436275_g9557_i0 PRJNA993416 9662 277 1.436275 3.97848175 Thermus 270 Bacteria Bacteria 73.6 1.87e-13   NR WP_124105776.1 274 g9557 i0 49.5 1.97111913357401 91 36 98.6 2 273 1 13 93 WP_124105776.1 hypothetical protein [Thermus thermophilus] diamond 546 73.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
27317018 27317018 PRJNA993416_P_NODE_13343_length_248_cov_2.268571_g13238_i0 PRJNA993416 13343 248 2.268571 5.62605608 Deinococcus 1298 Bacteria Bacteria 65.9 5.47e-11   NR WP_013556341.1 309887 g13238 i0 68.3 1.01612903225806 41 13 49.6 0 110 232 3 43 WP_013556341.1 RNA 2'-phosphotransferase [Deinococcus maricopensis] diamond 252 65.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus maricopensis
28037325 28037325 PRJNA993416_P_NODE_15125_length_244_cov_0.900585_g15020_i0 PRJNA993416 15125 244 0.900585 2.1974274 Deinococcus antarcticus 1298767 Bacteria Bacteria 116 2.16e-31   NR WP_380076348.1 1298767 g15020 i0 100 0.725409836065574 59 0 72.5 0 67 243 1 59 WP_380076348.1 hypothetical protein [Deinococcus antarcticus] diamond 177 116 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
28542625 28542625 PRJNA993416_P_NODE_13707_length_247_cov_2.367816_g13602_i0 PRJNA993416 13707 247 2.367816 5.84850552 Truepera radiovictrix 332249 Bacteria Bacteria 48.9 1.92e-4   NR WP_013176761.1 332249 g13602 i0 71.4 0.340080971659919 28 8 34 0 1 84 194 221 WP_013176761.1 potassium channel family protein [Truepera radiovictrix] diamond 84 48.9 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
32397776 32397776 PRJNA993416_P_NODE_8799_length_284_cov_2.014218_g8694_i0 PRJNA993416 8799 284 2.014218 5.72037912 Deinococcus hopiensis 309885 Bacteria Bacteria 119 9.25e-29   NR WP_139806401.1 309885 g8694 i0 71.4 2.88380281690141 91 26 96.1 0 284 12 420 510 WP_139806401.1 ATP-binding protein [Deinococcus hopiensis] diamond 819 119 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
32681544 32681544 PRJNA993416_P_NODE_1980_length_614_cov_1.319778_g1879_i0 PRJNA993416 1980 614 1.319778 8.10343692 Synergistetes bacterium ADurb.BinA166 1852916 Bacteria Bacteria 136 1.36e-33   NR OPZ34500.1 1852916 g1879 i0 45.3 0.884364820846905 181 82 85.5 7 551 27 111 280 OPZ34500.1 MAG: hypothetical protein BWY99_02508 [Synergistetes bacterium ADurb.BinA166] diamond 543 136 1 Bacteria   Thermotogati Synergistota         Synergistetes bacterium ADurb.BinA166
32807713 32807713 PRJNA993416_P_NODE_14600_length_245_cov_0.895349_g14495_i0 PRJNA993416 14600 245 0.895349 2.19360505 Deinococcus antarcticus 1298767 Bacteria Bacteria 160 8.73e-48   NR WP_380075921.1 1298767 g14495 i0 100 0.991836734693878 81 0 99.2 0 245 3 79 159 WP_380075921.1 (d)CMP kinase [Deinococcus antarcticus] diamond 243 160 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus

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