RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA498309 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
15782974 15782974 PRJNA498309_P_NODE_18073_length_687_cov_8.861538_g16321_i0 PRJNA498309 18073 687 8.861538 60.87876606 Fervidobacterium sp. 1871331 Bacteria Bacteria 129 1.08e-31   NR MDM7321177.1 1871331 g16321 i0 86.8 0.296943231441048 68 9 29.7 0 453 250 1 68 MDM7321177.1 hypothetical protein [Fervidobacterium sp.] diamond 204 129 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
18332378 18332378 PRJNA498309_P_NODE_40575_length_433_cov_2.828283_g38468_i0 PRJNA498309 40575 433 2.828283 12.24646539 Thermosipho sp. (in: thermotogales) 1968895 Bacteria Bacteria 109 3.7900000000000005e-27   NR WP_287568906.1 1968895 g38468 i0 45.2 0.859122401847575 124 68 85.9 0 39 410 55 178 WP_287568906.1 hypothetical protein [Thermosipho sp. (in: thermotogales)] diamond 372 109 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)
26934327 26934327 PRJNA498309_P_NODE_89122_length_222_cov_3.502703_g86973_i0 PRJNA498309 89122 222 3.502703 7.77600066 Bacteria 2 Bacteria Bacteria 45.8 0.00225   NR HUM41546.1 1871331 g86973 i0 40.7 2.52702702702703 54 32 73 0 60 221 12 65 HUM41546.1 RNA ligase family protein [Fervidobacterium sp.] diamond 561 46.2 0.991341991341991 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
27266713 27266713 PRJNA498309_P_NODE_57383_length_339_cov_6.529801_g55235_i0 PRJNA498309 57383 339 6.529801 22.13602539 Fervidobacterium sp. 1871331 Bacteria Bacteria 156 5.23e-47   NR MDM7320310.1 1871331 g55235 i0 84.8 0.814159292035398 92 14 81.4 0 44 319 1 92 MDM7320310.1 hypothetical protein [Fervidobacterium sp.] diamond 276 156 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
27614271 27614271 PRJNA498309_P_NODE_123464_length_150_cov_1.380531_g121315_i0 PRJNA498309 123464 150 1.380531 2.0707965 Fervidobacterium sp. 1871331 Bacteria Bacteria 56.2 1.1e-7   NR MDM7320302.1 1871331 g121315 i0 64.6 0.96 48 14 96 2 148 5 14 58 MDM7320302.1 hypothetical protein [Fervidobacterium sp.] diamond 144 56.2 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28151072 28151072 PRJNA498309_P_NODE_37685_length_453_cov_20.459135_g35615_i0 PRJNA498309 37685 453 20.459135 92.67988155 Fervidobacterium sp. 1871331 Bacteria Bacteria 213 2.12e-68   NR MDM7320281.1 1871331 g35615 i0 85.5 0.821192052980132 124 18 82.1 0 444 73 1 124 MDM7320281.1 hypothetical protein [Fervidobacterium sp.] diamond 372 213 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28151098 28151098 PRJNA498309_P_NODE_96885_length_201_cov_27.256098_g94736_i0 PRJNA498309 96885 201 27.256098 54.78475698 Fervidobacterium sp. 1871331 Bacteria Bacteria 105 5.2e-27   NR MDM7321174.1 1871331 g94736 i0 90.3 0.925373134328358 62 6 92.5 0 16 201 74 135 MDM7321174.1 hypothetical protein [Fervidobacterium sp.] diamond 186 105 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28245370 28245370 PRJNA498309_P_NODE_34346_length_480_cov_3.821670_g32305_i0 PRJNA498309 34346 480 3.82167 18.344016 Fervidobacterium sp. 1871331 Bacteria Bacteria 92.4 2.04e-18   NR MDM7320289.1 1871331 g32305 i0 91.7 0.59375 48 4 30 0 320 463 1 48 MDM7320289.1 hypothetical protein [Fervidobacterium sp.] diamond 285 92.4 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28403474 28403474 PRJNA498309_P_NODE_37306_length_456_cov_10.844869_g35241_i0 PRJNA498309 37306 456 10.844869 49.45260264 Fervidobacterium sp. 1871331 Bacteria Bacteria 212 8.120000000000001e-65   NR MDM7320283.1 1871331 g35241 i0 90.7 0.776315789473684 118 10 77 1 19 369 4 121 MDM7320283.1 hypothetical protein [Fervidobacterium sp.] diamond 354 212 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28624705 28624705 PRJNA498309_P_NODE_63847_length_310_cov_4.135531_g61699_i0 PRJNA498309 63847 310 4.135531 12.8201461 Fervidobacterium sp. 1871331 Bacteria Bacteria 84 2.92e-17   NR MDM7320302.1 1871331 g61699 i0 71.2 0.570967741935484 59 17 57.1 0 288 112 133 191 MDM7320302.1 hypothetical protein [Fervidobacterium sp.] diamond 177 84 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29098208 29098208 PRJNA498309_P_NODE_69068_length_289_cov_2.619048_g66919_i0 PRJNA498309 69068 289 2.619048 7.56904872 Fervidobacterium sp. 1871331 Bacteria Bacteria 157 2.05e-46   NR MDM7321176.1 1871331 g66919 i0 86.4 0.913494809688581 88 12 91.3 0 283 20 42 129 MDM7321176.1 hypothetical protein [Fervidobacterium sp.] diamond 264 157 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29224657 29224657 PRJNA498309_P_NODE_35409_length_471_cov_7.640553_g33358_i0 PRJNA498309 35409 471 7.640553 35.98700463 Fervidobacterium sp. 1871331 Bacteria Bacteria 122 9.41e-33   NR MDM7320310.1 1871331 g33358 i0 76.3 0.484076433121019 76 18 48.4 0 428 201 1 76 MDM7320310.1 hypothetical protein [Fervidobacterium sp.] diamond 228 122 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
30298673 30298673 PRJNA498309_P_NODE_91992_length_214_cov_2.502825_g89843_i0 PRJNA498309 91992 214 2.502825 5.3560455 Fervidobacterium sp. 1871331 Bacteria Bacteria 43.9 0.00589   NR MDM7321174.1 1871331 g89843 i0 73.1 0.364485981308411 26 7 36.4 0 135 212 8 33 MDM7321174.1 hypothetical protein [Fervidobacterium sp.] diamond 78 43.9 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
30803675 30803675 PRJNA498309_P_NODE_100914_length_192_cov_1.496774_g98765_i0 PRJNA498309 100914 192 1.496774 2.87380608 Fervidobacterium sp. 1871331 Bacteria Bacteria 105 6.45e-25   NR MDM7320303.1 1871331 g98765 i0 81.4 0.921875 59 11 92.2 0 1 177 104 162 MDM7320303.1 DEAD/DEAH box helicase [Fervidobacterium sp.] diamond 177 105 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32100157 32100157 PRJNA498309_P_NODE_46178_length_398_cov_3.936288_g44044_i0 PRJNA498309 46178 398 3.936288 15.66642624 Fervidobacterium sp. 1871331 Bacteria Bacteria 229 5.27e-75   NR MDM7321179.1 1871331 g44044 i0 91.5 0.889447236180904 118 10 88.9 0 384 31 17 134 MDM7321179.1 hypothetical protein [Fervidobacterium sp.] diamond 354 229 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32511830 32511830 PRJNA498309_P_NODE_51539_length_368_cov_12.809668_g49392_i0 PRJNA498309 51539 368 12.809668 47.13957824 Fervidobacterium sp. 1871331 Bacteria Bacteria 64.3 1.91e-10   NR MDM7320300.1 1871331 g49392 i0 71.1 0.309782608695652 38 11 31 0 154 267 3 40 MDM7320300.1 hypothetical protein [Fervidobacterium sp.] diamond 114 64.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32606236 32606236 PRJNA498309_P_NODE_58020_length_336_cov_9.816054_g55872_i0 PRJNA498309 58020 336 9.816054 32.98194144 Fervidobacterium sp. 1871331 Bacteria Bacteria 116 1.4199999999999998e-31   NR MDM7320288.1 1871331 g55872 i0 87.3 0.633928571428571 71 9 63.4 0 335 123 12 82 MDM7320288.1 hypothetical protein [Fervidobacterium sp.] diamond 213 116 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.

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