RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640143 · 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
27270611 27270611 PRJNA640143_S_NODE_12603_length_244_cov_6.758454_g12393_i0 PRJNA640143 12603 244 6.758454 16.49062776 Thermus albus 2908146 Bacteria Bacteria 66.2 1.74e-11   NR WP_279232354.1 2908146 g12393 i0 48.7 1.81967213114754 78 34 95.9 1 243 10 34 105 WP_279232354.1 Rad52/Rad22 family DNA repair protein [Thermus albus] diamond 444 66.2 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus albus
28280963 28280963 PRJNA640143_S_NODE_23006_length_184_cov_1.061224_g22796_i0 PRJNA640143 23006 184 1.061224 1.95265216 uncultured Truepera sp. 543023 Bacteria Bacteria 80.9 5.97e-16   NR CAA9576448.1 543023 g22796 i0 67.8 0.96195652173913 59 19 96.2 0 182 6 237 295 CAA9576448.1 MAG: hypothetical protein AVDCRST_MAG86-2240 [uncultured Truepera sp.] diamond 177 80.9 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
28975904 28975904 PRJNA640143_S_NODE_4788_length_374_cov_177.860534_g4579_i0 PRJNA640143 4788 374 177.860534 665.19839716 Thermus brevis 2862456 Bacteria Bacteria 107 3.34e-27   NR MBW6395802.1 2862456 g4579 i0 57.4 0.754010695187166 94 38 73.8 1 58 333 16 109 MBW6395802.1 PDZ domain-containing protein [Thermus brevis] diamond 282 107 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brevis
30472722 30472722 PRJNA640143_S_NODE_1393_length_617_cov_5.608621_g1274_i0 PRJNA640143 1393 617 5.608621 34.60519157 Deinococci 188787 Bacteria Bacteria 75.9 2.09e-12   NR WP_189092165.1 1848197 g1274 i0 61.5 1.20583468395462 65 22 30.1 1 594 409 251 315 WP_189092165.1 ferritin-like domain-containing protein [Deinococcus ruber] diamond 744 75.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ruber
30776231 30776231 PRJNA640143_S_NODE_3834_length_413_cov_11.265957_g3635_i0 PRJNA640143 3834 413 11.265957 46.52840241 Thermus scotoductus 37636 Bacteria Bacteria 165 3.9e-44   NR WP_019551367.1 37636 g3635 i0 96.6 0.631961259079903 87 3 63.2 0 16 276 1233 1319 WP_019551367.1 hypothetical protein [Thermus scotoductus] diamond 261 165 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
31819333 31819333 PRJNA640143_S_NODE_14777_length_226_cov_47.656085_g14567_i0 PRJNA640143 14777 226 47.656085 107.7027521 Thermus tenuipuniceus 2078690 Bacteria Bacteria 52.8 8.29e-6   NR WP_244187454.1 2078690 g14567 i0 92 1.46017699115044 25 2 33.2 0 134 60 187 211 WP_244187454.1 RNA-guided endonuclease InsQ/TnpB family protein [Thermus tenuipuniceus] diamond 330 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus tenuipuniceus
32798946 32798946 PRJNA640143_S_NODE_18880_length_202_cov_1.351515_g18670_i0 PRJNA640143 18880 202 1.351515 2.7300603 Deinococcota bacterium 1913990 Bacteria Bacteria 109 2.74e-29   NR MDQ3397724.1 1913990 g18670 i0 77.3 1.94554455445545 66 15 98 0 3 200 8 73 MDQ3397724.1 metalloregulator ArsR/SmtB family transcription factor [Deinococcota bacterium] diamond 393 109 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium

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