RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1041773 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
7385997 7385997 PRJNA1041773_P_NODE_13666_length_560_cov_1.708419_g13339_i0 PRJNA1041773 13666 560 1.708419 9.5671464 Pseudothermotoga hypogea 57487 Bacteria Bacteria 324 2.2699999999999994e-105   NR WP_031502628.1 57487 g13339 i0 84.9 0.889285714285714 166 25 88.9 0 560 63 437 602 WP_031502628.1 ABC transporter substrate-binding protein [Pseudothermotoga hypogea] diamond 498 324 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga hypogea
7823759 7823759 PRJNA1041773_P_NODE_95507_length_243_cov_1.029412_g95174_i0 PRJNA1041773 95507 243 1.029412 2.50147116 Pseudothermotoga 1643951 Bacteria Bacteria 111 6.78e-27   NR WP_031503612.1 57487 g95174 i0 91.7 1.48148148148148 60 5 74.1 0 185 6 57 116 WP_031503612.1 sensor histidine kinase [Pseudothermotoga hypogea] diamond 360 111 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga hypogea
26591755 26591755 PRJNA1041773_P_NODE_43361_length_323_cov_1.048000_g43028_i0 PRJNA1041773 43361 323 1.048 3.38504 Pseudothermotoga sp. 2033661 Bacteria Bacteria 153 2.1e-45   NR WP_346309874.1 2033661 g43028 i0 92.6 0.752321981424149 81 5 75.2 1 2 244 12 91 WP_346309874.1 flavodoxin family protein [Pseudothermotoga sp.] diamond 243 153 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
26623584 26623584 PRJNA1041773_P_NODE_53681_length_293_cov_1.050000_g53348_i0 PRJNA1041773 53681 293 1.05 3.0765 Pseudothermotoga sp. 2033661 Bacteria Bacteria 160 2.57e-45   NR HBT39427.1 2033661 g53348 i0 100 1.57679180887372 77 0 78.8 0 291 61 315 391 HBT39427.1 hypothetical protein [Pseudothermotoga sp.] diamond 462 160 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
27129602 27129602 PRJNA1041773_P_NODE_74102_length_255_cov_2.467033_g73769_i0 PRJNA1041773 74102 255 2.467033 6.29093415 Pseudothermotoga sp. 2033661 Bacteria Bacteria 180 8.3e-52   NR WP_346310456.1 2033661 g73769 i0 100 1.97647058823529 84 0 98.8 0 254 3 478 561 WP_346310456.1 ABC transporter substrate-binding protein [Pseudothermotoga sp.] diamond 504 180 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
27540853 27540853 PRJNA1041773_P_NODE_30824_length_377_cov_1.013158_g30492_i0 PRJNA1041773 30824 377 1.013158 3.81960566 Thermotoga petrophila 93929 Bacteria Bacteria 221 3.880000000000001e-71   NR KUK22528.1 93929 g30492 i0 96 0.994694960212202 125 5 99.5 0 1 375 21 145 KUK22528.1 MAG: Polysaccharide biosynthesis protein [Thermotoga petrophila] diamond 375 221 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
27564051 27564051 PRJNA1041773_P_NODE_23584_length_428_cov_1.301408_g23253_i0 PRJNA1041773 23584 428 1.301408 5.57002624 Thermotogaceae 188709 Bacteria Bacteria 256 4.92e-82   NR WP_041082286.1 1508420 g23253 i0 87 2.9018691588785 138 18 96.7 0 3 416 102 239 WP_041082286.1 pyridoxal-phosphate-dependent aminotransferase family protein [Thermotoga profunda] diamond 1242 258 0.992248062015504 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga profunda
27564053 27564053 PRJNA1041773_P_NODE_86264_length_247_cov_1.149425_g85931_i0 PRJNA1041773 86264 247 1.149425 2.83907975 Pseudothermotoga 1643951 Bacteria Bacteria 159 2.99e-43   NR WP_031505200.1 57487 g85931 i0 93.8 1.96761133603239 81 5 98.4 0 3 245 1174 1254 WP_031505200.1 PolC-type DNA polymerase III [Pseudothermotoga hypogea] diamond 486 159 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga hypogea
27793473 27793473 PRJNA1041773_P_NODE_88244_length_246_cov_1.699422_g87911_i0 PRJNA1041773 88244 246 1.699422 4.18057812 Pseudothermotoga sp. 2033661 Bacteria Bacteria 166 9.75e-49   NR WP_346310565.1 2033661 g87911 i0 100 0.98780487804878 81 0 98.8 0 2 244 15 95 WP_346310565.1 D-alanine--D-alanine ligase family protein [Pseudothermotoga sp.] diamond 243 166 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
28014548 28014548 PRJNA1041773_P_NODE_100145_length_241_cov_1.375000_g99812_i0 PRJNA1041773 100145 241 1.375 3.31375 Pseudothermotoga sp. 2033661 Bacteria Bacteria 150 1.7499999999999998e-42   NR MBC7123198.1 2033661 g99812 i0 100 0.995850622406639 80 0 99.6 0 1 240 81 160 MBC7123198.1 SIS domain-containing protein [Pseudothermotoga sp.] diamond 240 150 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
28045911 28045911 PRJNA1041773_P_NODE_84085_length_248_cov_0.897143_g83752_i0 PRJNA1041773 84085 248 0.897143 2.22491464 Pseudothermotoga sp. 2033661 Bacteria Bacteria 81.6 6.66e-16   NR WP_346311009.1 2033661 g83752 i0 43.9 0.991935483870968 82 46 99.2 0 248 3 99 180 WP_346311009.1 hypothetical protein [Pseudothermotoga sp.] diamond 246 81.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
28424969 28424969 PRJNA1041773_P_NODE_39186_length_338_cov_1.143396_g38853_i0 PRJNA1041773 39186 338 1.143396 3.86467848 Pseudothermotoga sp. 2033661 Bacteria Bacteria 207 5.11e-64   NR MBC7123198.1 2033661 g38853 i0 100 0.931952662721893 105 0 93.2 0 1 315 226 330 MBC7123198.1 SIS domain-containing protein [Pseudothermotoga sp.] diamond 315 207 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
28456547 28456547 PRJNA1041773_P_NODE_11186_length_617_cov_1.194853_g10861_i0 PRJNA1041773 11186 617 1.194853 7.37224301 Pseudothermotoga sp. 2033661 Bacteria Bacteria 179 9.71e-52   NR WP_346311029.1 2033661 g10861 i0 98.9 0.437601296596434 90 1 43.8 0 271 2 1 90 WP_346311029.1 alpha/beta hydrolase family protein [Pseudothermotoga sp.] diamond 270 179 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
29214455 29214455 PRJNA1041773_P_NODE_99089_length_242_cov_0.911243_g98756_i0 PRJNA1041773 99089 242 0.911243 2.20520806 Pseudothermotoga sp. 2033661 Bacteria Bacteria 63.9 1.25e-9   NR WP_346310649.1 2033661 g98756 i0 83.8 0.991735537190083 80 13 99.2 0 242 3 184 263 WP_346310649.1 flagellar hook-length control protein FliK [Pseudothermotoga sp.] diamond 240 63.9 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
29245783 29245783 PRJNA1041773_P_NODE_19069_length_476_cov_1.146402_g18739_i0 PRJNA1041773 19069 476 1.146402 5.45687352 Pseudothermotoga sp. 2033661 Bacteria Bacteria 291 1.909999999999999e-96   NR WP_346311005.1 2033661 g18739 i0 100 0.945378151260504 150 0 94.5 0 452 3 81 230 WP_346311005.1 hypothetical protein [Pseudothermotoga sp.] diamond 450 291 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
30256755 30256755 PRJNA1041773_P_NODE_82292_length_249_cov_0.875000_g81959_i0 PRJNA1041773 82292 249 0.875 2.17875 Pseudothermotoga 1643951 Bacteria Bacteria 150 2.61e-41   NR WP_031503439.1 1643951 g81959 i0 91.6 1 83 7 100 0 249 1 89 171 WP_031503439.1 MULTISPECIES: TldD/PmbA family protein [Pseudothermotoga] diamond 249 150 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga  
30320146 30320146 PRJNA1041773_P_NODE_26592_length_404_cov_0.930514_g26261_i0 PRJNA1041773 26592 404 0.930514 3.75927656 Pseudothermotoga sp. 2033661 Bacteria Bacteria 219 2.09e-66   NR WP_346310159.1 2033661 g26261 i0 100 0.891089108910891 120 0 89.1 0 43 402 152 271 WP_346310159.1 LytS/YhcK type 5TM receptor domain-containing protein [Pseudothermotoga sp.] diamond 360 219 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
30698644 30698644 PRJNA1041773_P_NODE_43554_length_322_cov_1.522088_g43221_i0 PRJNA1041773 43554 322 1.522088 4.90112336 Pseudothermotoga sp. 2033661 Bacteria Bacteria 191 4.6699999999999995e-57   NR WP_346310587.1 2033661 g43221 i0 100 0.885093167701863 95 0 88.5 0 286 2 7 101 WP_346310587.1 ABC transporter substrate-binding protein [Pseudothermotoga sp.] diamond 285 191 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
30951673 30951673 PRJNA1041773_P_NODE_80474_length_250_cov_0.870056_g80141_i0 PRJNA1041773 80474 250 0.870056 2.17514 Pseudothermotoga sp. 2033661 Bacteria Bacteria 85.1 5e-17   NR WP_346310121.1 2033661 g80141 i0 95.7 2.208 46 2 55.2 0 138 1 7 52 WP_346310121.1 translation initiation factor IF-2 [Pseudothermotoga sp.] diamond 552 85.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
31109305 31109305 PRJNA1041773_P_NODE_13075_length_572_cov_2.981964_g12748_i0 PRJNA1041773 13075 572 2.981964 17.05683408 Pseudothermotoga sp. 2033661 Bacteria Bacteria 318 1.09e-102   NR WP_346310833.1 2033661 g12748 i0 91.8 0.954545454545455 182 12 93.9 1 538 2 316 497 WP_346310833.1 PEGA domain-containing protein [Pseudothermotoga sp.] diamond 546 318 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
31584005 31584005 PRJNA1041773_P_NODE_65536_length_270_cov_0.781726_g65203_i0 PRJNA1041773 65536 270 0.781726 2.1106602 Pseudothermotoga hypogea 57487 Bacteria Bacteria 139 1.98e-38   NR WP_031502776.1 57487 g65203 i0 94.3 0.777777777777778 70 4 77.8 0 211 2 58 127 WP_031502776.1 hypothetical protein [Pseudothermotoga hypogea] diamond 210 139 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga hypogea
31646886 31646886 PRJNA1041773_P_NODE_29637_length_384_cov_1.070740_g29305_i0 PRJNA1041773 29637 384 1.07074 4.1116416 Pseudothermotoga sp. 2033661 Bacteria Bacteria 188 1.52e-56   NR WP_346310486.1 2033661 g29305 i0 100 0.7265625 93 0 72.7 0 327 49 234 326 WP_346310486.1 ExsB family protein [Pseudothermotoga sp.] diamond 279 188 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
31741810 31741810 PRJNA1041773_P_NODE_45097_length_317_cov_1.262295_g44764_i0 PRJNA1041773 45097 317 1.262295 4.00147515 Pseudothermotoga sp. 2033661 Bacteria Bacteria 186 6.96e-53   NR WP_346310649.1 2033661 g44764 i0 98.1 0.993690851735016 105 2 99.4 0 316 2 28 132 WP_346310649.1 flagellar hook-length control protein FliK [Pseudothermotoga sp.] diamond 315 186 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
31741811 31741811 PRJNA1041773_P_NODE_55237_length_289_cov_1.851852_g54904_i0 PRJNA1041773 55237 289 1.851852 5.35185228 Pseudothermotoga 1643951 Bacteria Bacteria 131 4.9900000000000003e-36   NR WP_031502885.1 1643951 g54904 i0 72 0.965397923875433 93 20 96.5 1 11 289 33 119 WP_031502885.1 MULTISPECIES: thioredoxin family protein [Pseudothermotoga] diamond 279 131 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga  
32184960 32184960 PRJNA1041773_P_NODE_106478_length_213_cov_2.907143_g106145_i0 PRJNA1041773 106478 213 2.907143 6.19221459 Pseudothermotoga sp. 2033661 Bacteria Bacteria 91.3 2.01e-19   NR HBT39694.1 2033661 g106145 i0 100 3.09859154929577 44 0 62 0 152 21 1 44 HBT39694.1 flagellar hook-associated protein FlgK [Pseudothermotoga sp.] diamond 660 91.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
32280030 32280030 PRJNA1041773_P_NODE_71999_length_259_cov_1.225806_g71666_i0 PRJNA1041773 71999 259 1.225806 3.17483754 Pseudothermotoga sp. 2033661 Bacteria Bacteria 174 7.91e-51   NR WP_346311009.1 2033661 g71666 i0 96.5 0.996138996138996 86 3 99.6 0 1 258 304 389 WP_346311009.1 hypothetical protein [Pseudothermotoga sp.] diamond 258 174 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga 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);;