RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
2575115 2575115 PRJEB28062_P_NODE_64723_length_431_cov_51.293296_g62362_i0 PRJEB28062 64723 431 51.293296 221.07410576 Fervidobacterium sp. 1871331 Bacteria Bacteria 144 3.27e-38   NR MDM7320286.1 1871331 g62362 i0 77.9 0.59860788863109 86 19 59.9 0 167 424 48 133 MDM7320286.1 hypothetical protein [Fervidobacterium sp.] diamond 258 144 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
6404085 6404085 PRJEB28062_P_NODE_97666_length_322_cov_1.694779_g95304_i0 PRJEB28062 97666 322 1.694779 5.45718838 Thermotogota bacterium 2053689 Bacteria Bacteria 55.5 3.34e-6   NR MDY6893948.1 2053689 g95304 i0 33.7 0.885093167701863 95 56 85.7 3 318 43 708 798 MDY6893948.1 DNA polymerase [Thermotogota bacterium] diamond 285 55.5 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
27279706 27279706 PRJEB28062_P_NODE_89223_length_347_cov_5.667883_g86861_i0 PRJEB28062 89223 347 5.667883 19.66755401 Bacteria 2 Bacteria Bacteria 138 6.14e-36   NR WP_121958441.1 1434328 g86861 i0 67.4 13.4005763688761 92 30 79.5 0 289 14 5 96 WP_121958441.1 type I restriction-modification system subunit M [Petrotoga sp. 9PWA.NaAc.5.4] diamond 4650 138 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Petrotoga Petrotoga sp. 9PWA.NaAc.5.4
27602086 27602086 PRJEB28062_P_NODE_125484_length_249_cov_0.875000_g123120_i0 PRJEB28062 125484 249 0.875 2.17875 Mesoaciditoga lauensis 1495039 Bacteria Bacteria 43.5 0.0209   NR WP_051962932.1 1495039 g123120 i0 47.6 0.506024096385542 42 22 50.6 0 104 229 325 366 WP_051962932.1 glutathione ABC transporter substrate-binding protein [Mesoaciditoga lauensis] diamond 126 43.5 1 Bacteria   Thermotogati Thermotogota Thermotogae Mesoaciditogales Mesoaciditogaceae Mesoaciditoga Mesoaciditoga lauensis
28264790 28264790 PRJEB28062_P_NODE_119306_length_262_cov_2.592593_g116943_i0 PRJEB28062 119306 262 2.592593 6.79259366 Fervidobacterium sp. 1871331 Bacteria Bacteria 125 2.2099999999999993e-34   NR MDM7320314.1 1871331 g116943 i0 88.3 0.687022900763359 60 7 68.7 0 11 190 118 177 MDM7320314.1 hypothetical protein [Fervidobacterium sp.] diamond 180 125 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28327956 28327956 PRJEB28062_P_NODE_115266_length_272_cov_2.914573_g112903_i0 PRJEB28062 115266 272 2.914573 7.92763856 Fervidobacterium sp. 1871331 Bacteria Bacteria 101 7.98e-24   NR MDM7321175.1 1871331 g112903 i0 77.4 0.683823529411765 62 14 68.4 0 16 201 202 263 MDM7321175.1 hypothetical protein [Fervidobacterium sp.] diamond 186 101 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28327991 28327991 PRJEB28062_P_NODE_62126_length_442_cov_52.395664_g59766_i0 PRJEB28062 62126 442 52.395664 231.58883488 Fervidobacterium sp. 1871331 Bacteria Bacteria 112 1.87e-26   NR MDM7321177.1 1871331 g59766 i0 85 0.407239819004525 60 9 40.7 0 240 61 271 330 MDM7321177.1 hypothetical protein [Fervidobacterium sp.] diamond 180 112 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28359518 28359518 PRJEB28062_P_NODE_106266_length_296_cov_11.542601_g103903_i0 PRJEB28062 106266 296 11.542601 34.16609896 Fervidobacterium sp. 1871331 Bacteria Bacteria 176 1.94e-51   NR MDM7320286.1 1871331 g103903 i0 86.6 1.91554054054054 97 13 98.3 0 1 291 204 300 MDM7320286.1 hypothetical protein [Fervidobacterium sp.] diamond 567 176 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28511117 28511117 PRJEB28062_P_NODE_8247_length_1366_cov_629.883217_g6787_i0 PRJEB28062 8247 1366 629.883217 8604.20474422 Bacteria 2 Bacteria Bacteria 279 9.619999999999998e-88   NR HRW92005.1 2053689 g6787 i0 54.2 1.10248901903367 251 115 55.1 0 163 915 1 251 HRW92005.1 glycosyltransferase family protein [Thermotogota bacterium] diamond 1506 279 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
29023105 29023105 PRJEB28062_P_NODE_50688_length_500_cov_16.166276_g48339_i0 PRJEB28062 50688 500 16.166276 80.83138 Fervidobacterium sp. 1871331 Bacteria Bacteria 138 5.78e-36   NR MDM7320283.1 1871331 g48339 i0 84.3 0.498 83 12 49.2 1 482 237 4 86 MDM7320283.1 hypothetical protein [Fervidobacterium sp.] diamond 249 138 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29180801 29180801 PRJEB28062_P_NODE_133109_length_232_cov_6.943396_g130745_i0 PRJEB28062 133109 232 6.943396 16.10867872 Fervidobacterium sp. 1871331 Bacteria Bacteria 124 4.21e-34   NR MDM7321174.1 1871331 g130745 i0 90 0.905172413793103 70 7 90.5 0 22 231 64 133 MDM7321174.1 hypothetical protein [Fervidobacterium sp.] diamond 210 124 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29275174 29275174 PRJEB28062_P_NODE_21649_length_804_cov_77.740082_g19514_i0 PRJEB28062 21649 804 77.740082 625.03025928 Fervidobacterium sp. 1871331 Bacteria Bacteria 379 7.6e-126   NR MDM7320289.1 1871331 g19514 i0 87.1 0.835820895522388 224 29 83.6 0 785 114 260 483 MDM7320289.1 hypothetical protein [Fervidobacterium sp.] diamond 672 379 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29401653 29401653 PRJEB28062_P_NODE_86209_length_357_cov_7.235915_g83847_i0 PRJEB28062 86209 357 7.235915 25.83221655 Fervidobacterium sp. 1871331 Bacteria Bacteria 154 1.42e-40   NR HUM44121.1 1871331 g83847 i0 69.1 0.92436974789916 110 33 91.6 1 341 15 93 202 HUM44121.1 N-6 DNA methylase [Fervidobacterium sp.] diamond 330 154 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29432875 29432875 PRJEB28062_P_NODE_112770_length_279_cov_1.587379_g110407_i0 PRJEB28062 112770 279 1.587379 4.42878741 Fervidobacterium sp. 1871331 Bacteria Bacteria 59.7 4.48e-9   NR MDM7320300.1 1871331 g110407 i0 63.2 0.408602150537634 38 14 40.9 0 140 27 3 40 MDM7320300.1 hypothetical protein [Fervidobacterium sp.] diamond 114 59.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29464376 29464376 PRJEB28062_P_NODE_20530_length_827_cov_56.075597_g18455_i0 PRJEB28062 20530 827 56.075597 463.74518719 Fervidobacterium sp. 1871331 Bacteria Bacteria 292 2.0399999999999993e-96   NR MDM7321176.1 1871331 g18455 i0 84.8 0.620314389359129 171 26 62 0 7 519 42 212 MDM7321176.1 hypothetical protein [Fervidobacterium sp.] diamond 513 292 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29685471 29685471 PRJEB28062_P_NODE_42310_length_556_cov_26.047619_g39974_i0 PRJEB28062 42310 556 26.047619 144.82476164 Fervidobacterium sp. 1871331 Bacteria Bacteria 244 1.31e-76   NR MDM7320283.1 1871331 g39974 i0 91.3 0.744604316546763 138 11 73.9 1 19 429 4 141 MDM7320283.1 hypothetical protein [Fervidobacterium sp.] diamond 414 244 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
30823081 30823081 PRJEB28062_P_NODE_137714_length_202_cov_4.674419_g135350_i0 PRJEB28062 137714 202 4.674419 9.44232638 Fervidobacterium sp. 1871331 Bacteria Bacteria 72.8 4.47e-14   NR MDM7321174.1 1871331 g135350 i0 82.5 0.594059405940594 40 7 59.4 0 179 60 69 108 MDM7321174.1 hypothetical protein [Fervidobacterium sp.] diamond 120 72.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
30854637 30854637 PRJEB28062_P_NODE_26394_length_723_cov_6.812308_g24149_i0 PRJEB28062 26394 723 6.812308 49.25298684 Fervidobacterium sp. 1871331 Bacteria Bacteria 260 1.99e-84   NR MDM7321178.1 1871331 g24149 i0 87.1 0.609958506224066 147 19 61 0 10 450 61 207 MDM7321178.1 hypothetical protein [Fervidobacterium sp.] diamond 441 260 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
31423633 31423633 PRJEB28062_P_NODE_50736_length_500_cov_4.946136_g48387_i0 PRJEB28062 50736 500 4.946136 24.73068 Fervidobacterium sp. 1871331 Bacteria Bacteria 128 5.4e-34   NR MDM7320314.1 1871331 g48387 i0 85.9 0.384 64 9 38.4 0 488 297 114 177 MDM7320314.1 hypothetical protein [Fervidobacterium sp.] diamond 192 128 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
31993036 31993036 PRJEB28062_P_NODE_87358_length_353_cov_7.028571_g84996_i0 PRJEB28062 87358 353 7.028571 24.81085563 Thermotogaceae bacterium 2268206 Bacteria Bacteria 130 1.5499999999999998e-32   NR HEW92371.1 2268206 g84996 i0 69.7 1.51274787535411 89 27 75.6 0 287 21 305 393 HEW92371.1 glycosyl hydrolase [Thermotogaceae bacterium] diamond 534 130 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
32562840 32562840 PRJEB28062_P_NODE_75499_length_392_cov_3.347962_g73137_i0 PRJEB28062 75499 392 3.347962 13.12401104 Fervidobacterium sp. 1871331 Bacteria Bacteria 116 9.88e-31   NR MDM7320310.1 1871331 g73137 i0 78.9 1.17857142857143 76 16 58.2 0 143 370 36 111 MDM7320310.1 hypothetical protein [Fervidobacterium sp.] diamond 462 116 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32782812 32782812 PRJEB28062_P_NODE_128620_length_244_cov_1.508772_g126256_i0 PRJEB28062 128620 244 1.508772 3.68140368 Fervidobacterium sp. 1871331 Bacteria Bacteria 133 2.25e-35   NR MDM7320303.1 1871331 g126256 i0 84.6 0.959016393442623 78 12 95.9 0 235 2 222 299 MDM7320303.1 DEAD/DEAH box helicase [Fervidobacterium sp.] diamond 234 133 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32845931 32845931 PRJEB28062_P_NODE_56300_length_469_cov_46.540404_g53946_i0 PRJEB28062 56300 469 46.540404 218.27449476 Fervidobacterium sp. 1871331 Bacteria Bacteria 201 9.04e-64   NR MDM7321179.1 1871331 g53946 i0 92.2 0.652452025586354 102 8 65.2 0 20 325 17 118 MDM7321179.1 hypothetical protein [Fervidobacterium sp.] diamond 306 201 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);;