contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_kingdom = "Thermotogati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7963901 | 7963901 | PRJNA1160211_S_NODE_64747_length_535_cov_2.794372_g63550_i0 | PRJNA1160211 | 64747 | 535 | 2.794372 | 14.9498902 | Deinococcus arcticus | 2136176 | Bacteria | Bacteria | 167 | 1.87e-44 | NR | WP_107137678.1 | 2136176 | g63550 | i0 | 95.7 | 0.527102803738318 | 94 | 4 | 52.7 | 0 | 10 | 291 | 796 | 889 | WP_107137678.1 malto-oligosyltrehalose synthase [Deinococcus arcticus] | diamond | 282 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus arcticus | ||
| 26616461 | 26616461 | PRJNA1160211_S_NODE_189621_length_323_cov_1.436000_g188388_i0 | PRJNA1160211 | 189621 | 323 | 1.436 | 4.63828 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 96.7 | 2.74e-23 | NR | RIH82683.1 | 1644118 | g188388 | i0 | 57.9 | 11.2941176470588 | 76 | 27 | 70.6 | 1 | 22 | 249 | 38 | 108 | RIH82683.1 30S ribosomal protein S12 [Calidithermus roseus] | diamond | 3648 | 97.4 | 0.992813141683778 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus roseus | ||
| 26628844 | 26628844 | PRJNA1160211_S_NODE_79461_length_499_cov_22.737089_g78244_i0 | PRJNA1160211 | 79461 | 499 | 22.737089 | 113.45807411 | Deinococcus | 1298 | Bacteria | Bacteria | 167 | 3.1e-45 | NR | WP_013614104.1 | 1298 | g78244 | i0 | 58 | 0.901803607214429 | 150 | 62 | 90.2 | 1 | 494 | 45 | 459 | 607 | WP_013614104.1 MULTISPECIES: cation:proton antiporter [Deinococcus] | diamond | 450 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 28271976 | 28271976 | PRJNA1160211_S_NODE_58146_length_552_cov_17.398747_g56964_i0 | PRJNA1160211 | 58146 | 552 | 17.398747 | 96.04108344 | Deinococcus sp. Marseille-Q64 | 47478 | Bacteria | Bacteria | 58.9 | 1.25e-6 | NR | WP_261664853.1 | 2969223 | g56964 | i0 | 52.9 | 0.869565217391304 | 70 | 32 | 37.5 | 1 | 271 | 477 | 1 | 70 | WP_261664853.1 hypothetical protein [Deinococcus sp. Marseille-Q6407] | diamond | 480 | 58.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. Marseille-Q6407 | ||
| 28651116 | 28651116 | PRJNA1160211_S_NODE_297847_length_211_cov_6.652174_g296614_i0 | PRJNA1160211 | 297847 | 211 | 6.652174 | 14.03608714 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 70.5 | 1.44e-12 | NR | MDO4262643.1 | 47478 | g296614 | i0 | 52.4 | 1.89099526066351 | 63 | 30 | 89.6 | 0 | 17 | 205 | 118 | 180 | MDO4262643.1 CAP domain-containing protein [Deinococcus sp.] | diamond | 399 | 70.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 28745785 | 28745785 | PRJNA1160211_S_NODE_287707_length_235_cov_2.604938_g286474_i0 | PRJNA1160211 | 287707 | 235 | 2.604938 | 6.1216043000000004 | Deinococcus proteolyticus | 55148 | Bacteria | Bacteria | 126 | 2.54e-33 | NR | WP_013615759.1 | 55148 | g286474 | i0 | 92.9 | 0.893617021276596 | 70 | 5 | 89.4 | 0 | 24 | 233 | 195 | 264 | WP_013615759.1 class II fructose-1,6-bisphosphate aldolase [Deinococcus proteolyticus] | diamond | 210 | 126 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 28966944 | 28966944 | PRJNA1160211_S_NODE_174808_length_341_cov_2.951493_g173575_i0 | PRJNA1160211 | 174808 | 341 | 2.951493 | 10.06459113 | Deinococcus | 1298 | Bacteria | Bacteria | 155 | 8.369999999999999e-47 | NR | WP_041221897.1 | 1298 | g173575 | i0 | 96.3 | 1.43401759530792 | 80 | 3 | 70.4 | 0 | 11 | 250 | 1 | 80 | WP_041221897.1 MULTISPECIES: translation initiation factor IF-1 [Deinococcus] | diamond | 489 | 155 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 30229970 | 30229970 | PRJNA1160211_S_NODE_105632_length_446_cov_18.600536_g104404_i0 | PRJNA1160211 | 105632 | 446 | 18.600536 | 82.95839056 | Marinitoga | 160798 | Bacteria | Bacteria | 63.2 | 2.48e-8 | NR | WP_014296473.1 | 160798 | g104404 | i0 | 36.5 | 0.92152466367713 | 137 | 77 | 86.8 | 5 | 406 | 20 | 9 | 143 | WP_014296473.1 MULTISPECIES: ATP-dependent Clp protease ATP-binding subunit [Marinitoga] | diamond | 411 | 63.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Marinitoga | |||
| 30577294 | 30577294 | PRJNA1160211_S_NODE_231513_length_278_cov_2.629268_g230280_i0 | PRJNA1160211 | 231513 | 278 | 2.629268 | 7.30936504 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 99 | 2.31e-24 | NR | WP_291427077.1 | 47478 | g230280 | i0 | 92.6 | 0.58273381294964 | 54 | 4 | 58.3 | 0 | 23 | 184 | 72 | 125 | WP_291427077.1 roadblock/LC7 domain-containing protein [Deinococcus sp.] | diamond | 162 | 99 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 30861899 | 30861899 | PRJNA1160211_S_NODE_244634_length_266_cov_3.404145_g243401_i0 | PRJNA1160211 | 244634 | 266 | 3.404145 | 9.0550257 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 128 | 4.41e-32 | NR | WP_353543091.1 | 457454 | g243401 | i0 | 88.9 | 0.913533834586466 | 81 | 9 | 91.4 | 0 | 261 | 19 | 320 | 400 | WP_353543091.1 hypothetical protein [Deinococcus xinjiangensis] | diamond | 243 | 128 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 30944511 | 30944511 | PRJNA1160211_S_NODE_134914_length_397_cov_4.398148_g133682_i0 | PRJNA1160211 | 134914 | 397 | 4.398148 | 17.46064756 | Deinococcus | 1298 | Bacteria | Bacteria | 128 | 1.11e-35 | NR | WP_326493040.1 | 1298 | g133682 | i0 | 80 | 1.63979848866499 | 70 | 14 | 52.9 | 0 | 32 | 241 | 18 | 87 | WP_326493040.1 MULTISPECIES: hypothetical protein [Deinococcus] | diamond | 651 | 128 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 31734674 | 31734674 | PRJNA1160211_S_NODE_12477_length_780_cov_3.949081_g11627_i0 | PRJNA1160211 | 12477 | 780 | 3.949081 | 30.8028318 | FCB group | 1783270 | Bacteria | Bacteria | 60.1 | 1.09e-6 | NR | MBQ4431893.1 | 2053624 | g11627 | i0 | 54.5 | 0.423076923076923 | 55 | 25 | 21.2 | 0 | 779 | 615 | 37 | 91 | MBQ4431893.1 sel1 repeat family protein [Synergistaceae bacterium] | diamond | 330 | 60.5 | 0.993388429752066 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 32380029 | 32380029 | PRJNA1160211_S_NODE_105299_length_447_cov_4.663102_g104071_i0 | PRJNA1160211 | 105299 | 447 | 4.663102 | 20.84406594 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 228 | 8.380000000000001e-73 | NR | WP_143068321.1 | 856736 | g104071 | i0 | 95.8 | 0.959731543624161 | 143 | 6 | 96 | 0 | 1 | 429 | 115 | 257 | WP_143068321.1 phage holin family protein [Deinococcus reticulitermitis] | diamond | 429 | 228 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis |
Advanced export
JSON shape: default, array, newline-delimited
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);;