RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 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
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.
28407522 28407522 PRJNA640143_S_NODE_26466_length_171_cov_2.059701_g26256_i0 PRJNA640143 26466 171 2.059701 3.52208871 Fervidobacterium sp. 1871331 Bacteria Bacteria 95.1 2.4300000000000003e-21   NR MCX7654715.1 1871331 g26256 i0 83 0.929824561403509 53 9 93 0 161 3 1 53 MCX7654715.1 M50 family metallopeptidase [Fervidobacterium sp.] diamond 159 95.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28880959 28880959 PRJNA640143_S_NODE_6868_length_320_cov_10.671378_g6658_i0 PRJNA640143 6868 320 10.671378 34.1484096 Kosmotoga 651456 Bacteria Bacteria 136 6.35e-36   NR WP_015868967.1 651456 g6658 i0 71 0.871875 93 27 87.2 0 33 311 271 363 WP_015868967.1 MULTISPECIES: glycosyltransferase [Kosmotoga] diamond 279 136 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Kosmotoga  
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
29872383 29872383 PRJNA640143_S_NODE_21671_length_189_cov_2.111842_g21461_i0 PRJNA640143 21671 189 2.111842 3.99138138 root 1 Root_unresolved Root_unresolved 90.1 3.83e-19   NR MBO8140221.1 1968895 g21461 i0 73.2 7.11111111111111 56 15 88.9 0 22 189 304 359 MBO8140221.1 HsdR family type I site-specific deoxyribonuclease [Thermosipho sp. (in: thermotogales)] diamond 1344 90.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)
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
31345058 31345058 PRJNA640143_S_NODE_12156_length_248_cov_246.824645_g11946_i0 PRJNA640143 12156 248 246.824645 612.1251196 Fervidobacterium sp. 1871331 Bacteria Bacteria 61.6 8.39e-9   NR MDM7320286.1 1871331 g11946 i0 87.9 0.399193548387097 33 4 39.9 0 2 100 206 238 MDM7320286.1 hypothetical protein [Fervidobacterium sp.] diamond 99 61.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
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
32167667 32167667 PRJNA640143_S_NODE_22318_length_186_cov_5.281879_g22108_i0 PRJNA640143 22318 186 5.281879 9.82429494 Fervidobacterium sp. 1871331 Bacteria Bacteria 56.2 2.89e-7   NR MFN3692050.1 1871331 g22108 i0 81.8 0.532258064516129 33 6 53.2 0 179 81 323 355 MFN3692050.1 hypothetical protein [Fervidobacterium sp.] diamond 99 56.2 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
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);;