RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA615175" 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

  • PRJNA615175 · 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
6973473 6973473 PRJNA615175_P_NODE_29986_length_248_cov_0.880000_g29818_i0 PRJNA615175 29986 248 0.88 2.1824 Truepera radiovictrix 332249 Bacteria Bacteria 99.8 3.1499999999999995e-23   NR WP_013179187.1 332249 g29818 i0 84 0.604838709677419 50 8 60.5 0 151 2 3 52 WP_013179187.1 sulfotransferase family protein [Truepera radiovictrix] diamond 150 99.8 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
18446762 18446762 PRJNA615175_P_NODE_13795_length_383_cov_1.096774_g13627_i0 PRJNA615175 13795 383 1.096774 4.20064442 unclassified Deinococcus 2623546 Bacteria Bacteria 246 3.7400000000000005e-80   NR WP_221590529.1 2623546 g13627 i0 99.2 0.994778067885117 127 1 99.5 0 381 1 15 141 WP_221590529.1 MULTISPECIES: hypothetical protein [unclassified Deinococcus] diamond 381 246 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
20997146 20997146 PRJNA615175_P_NODE_20277_length_308_cov_1.931915_g20109_i0 PRJNA615175 20277 308 1.931915 5.9502982 Bacteria 2 Bacteria Bacteria 140 3.01e-37   NR HEX7022706.1 2026798 g20109 i0 67 4.63636363636364 94 31 91.6 0 26 307 337 430 HEX7022706.1 GH1 family beta-glucosidase [Trueperaceae bacterium] diamond 1428 141 0.99290780141844 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
22272342 22272342 PRJNA615175_P_NODE_3858_length_792_cov_2.753825_g3707_i0 PRJNA615175 3858 792 2.753825 21.810294 Deinococcus sp. 23YEL 47478 Bacteria Bacteria 520 1.2499999999999995e-176   NR WP_370638516.1 2745871 g3707 i0 99.2 0.996212121212121 263 2 99.6 0 791 3 359 621 WP_370638516.1 DNA helicase RecQ [Deinococcus sp. 23YEL01] diamond 789 520 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 23YEL01
24821247 24821247 PRJNA615175_P_NODE_29100_length_249_cov_2.142045_g28932_i0 PRJNA615175 29100 249 2.142045 5.33369205 Deinococcus aestuarii 2774531 Bacteria Bacteria 94.4 2.3100000000000003e-21   NR WP_216318350.1 2774531 g28932 i0 100 0.602409638554217 50 0 60.2 0 247 98 210 259 WP_216318350.1 hypothetical protein [Deinococcus aestuarii] diamond 150 94.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
27174931 27174931 PRJNA615175_P_NODE_27122_length_255_cov_1.692308_g26954_i0 PRJNA615175 27122 255 1.692308 4.3153854 Deinococcus taeanensis 2737050 Bacteria Bacteria 60.5 2.32e-8   NR WP_225476018.1 2737050 g26954 i0 45.7 0.823529411764706 70 38 82.4 0 251 42 332 401 WP_225476018.1 exodeoxyribonuclease VII large subunit [Deinococcus taeanensis] diamond 210 60.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taeanensis
28343584 28343584 PRJNA615175_P_NODE_13706_length_384_cov_2.135048_g13538_i0 PRJNA615175 13706 384 2.135048 8.19858432 Deinococcus sp. JMULE3 2518341 Bacteria Bacteria 230 2.7199999999999997e-72   NR WP_174369295.1 2518341 g13538 i0 93 1 128 9 100 0 384 1 82 209 WP_174369295.1 flagellar assembly protein T N-terminal domain-containing protein [Deinococcus sp. JMULE3] diamond 384 230 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. JMULE3
29398495 29398495 PRJNA615175_P_NODE_27229_length_254_cov_2.624309_g27061_i0 PRJNA615175 27229 254 2.624309 6.66574486 Deinococcus 1298 Bacteria Bacteria 171 1.57e-48   NR WP_230283940.1 2745871 g27061 i0 95.2 1.98425196850394 84 4 99.2 0 3 254 62 145 WP_230283940.1 HD domain-containing phosphohydrolase, partial [Deinococcus sp. 23YEL01] diamond 504 171 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 23YEL01
29543325 29543325 PRJNA615175_P_NODE_9630_length_474_cov_4.371571_g9462_i0 PRJNA615175 9630 474 4.371571 20.72124654 uncultured Truepera sp. 543023 Bacteria Bacteria 239 4.98e-74   NR CAA9563948.1 543023 g9462 i0 81.5 0.993670886075949 157 29 99.4 0 3 473 184 340 CAA9563948.1 MAG: Proposed peptidoglycan lipid II flippase MurJ [uncultured Truepera sp.] diamond 471 239 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
32388214 32388214 PRJNA615175_P_NODE_21539_length_297_cov_2.433036_g21371_i0 PRJNA615175 21539 297 2.433036 7.22611692 Deinococcus sp. 6GRE 47478 Bacteria Bacteria 194 6.239999999999999e-60   NR WP_230296019.1 2745873 g21371 i0 100 0.98989898989899 98 0 99 0 296 3 134 231 WP_230296019.1 hypothetical protein [Deinococcus sp. 6GRE01] diamond 294 194 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 6GRE01
32515080 32515080 PRJNA615175_P_NODE_7319_length_558_cov_3.245361_g7154_i0 PRJNA615175 7319 558 3.245361 18.10911438 Deinococcus cavernae 2320857 Bacteria Bacteria 278 2.31e-85   NR WP_119760015.1 2320857 g7154 i0 75 0.989247311827957 184 46 98.9 0 554 3 544 727 WP_119760015.1 ATP-dependent helicase [Deinococcus cavernae] diamond 552 278 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
32578182 32578182 PRJNA615175_P_NODE_23499_length_282_cov_2.784689_g23331_i0 PRJNA615175 23499 282 2.784689 7.85282298 Thermosipho sp. (in: thermotogales) 1968895 Bacteria Bacteria 44.7 0.0102   NR MBO8140151.1 1968895 g23331 i0 34 1.03191489361702 97 52 91.5 3 263 6 123 218 MBO8140151.1 ribonuclease III [Thermosipho sp. (in: thermotogales)] diamond 291 44.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)

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