RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA993416 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
975758 975758 PRJNA993416_P_NODE_11901_length_255_cov_2.115385_g11796_i0 PRJNA993416 11901 255 2.115385 5.39423175 Thermoproteota archaeon 2056631 Archaea Archaea 103 1.0199999999999999e-23   NR RDJ35443.1 2056631 g11796 i0 57.6 2 85 35 100 1 255 1 98 181 RDJ35443.1 MAG: CTP synthase [Thermoproteota archaeon] diamond 510 103 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
13729449 13729449 PRJNA993416_P_NODE_3511_length_453_cov_2.068421_g3406_i0 PRJNA993416 3511 453 2.068421 9.36994713 Thermoproteota archaeon 2056631 Archaea Archaea 184 1.19e-52   NR RDJ35311.1 2056631 g3406 i0 66.9 0.801324503311258 121 40 80.1 0 89 451 2 122 RDJ35311.1 MAG: SpoVR family protein [Thermoproteota archaeon] diamond 363 184 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
20102371 20102371 PRJNA993416_P_NODE_1896_length_627_cov_1.638989_g1795_i0 PRJNA993416 1896 627 1.638989 10.27646103 Thermoproteota archaeon 2056631 Archaea Archaea 299 3.02e-94   NR RDJ35315.1 2056631 g1795 i0 68.1 0.990430622009569 207 64 98.1 1 1 615 285 491 RDJ35315.1 MAG: serine protein kinase [Thermoproteota archaeon] diamond 621 299 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27152444 27152444 PRJNA993416_P_NODE_5442_length_358_cov_2.477193_g5337_i0 PRJNA993416 5442 358 2.477193 8.86835094 Thermoproteota archaeon 2056631 Archaea Archaea 70.9 1.03e-11   NR RDJ35111.1 2056631 g5337 i0 41.9 0.620111731843575 74 43 62 0 227 6 51 124 RDJ35111.1 MAG: class I SAM-dependent methyltransferase [Thermoproteota archaeon] diamond 222 70.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27215907 27215907 PRJNA993416_P_NODE_16102_length_241_cov_0.916667_g15997_i0 PRJNA993416 16102 241 0.916667 2.20916747 Thermoproteota archaeon 2056631 Archaea Archaea 94 1.57e-20   NR RDJ35278.1 2056631 g15997 i0 55.3 1.92946058091286 76 33 94.6 1 230 3 45 119 RDJ35278.1 MAG: hypothetical protein DWQ19_10715 [Thermoproteota archaeon] diamond 465 94 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27311216 27311216 PRJNA993416_P_NODE_6643_length_323_cov_1.736000_g6538_i0 PRJNA993416 6643 323 1.736 5.60728 Thermoproteota archaeon 2056631 Archaea Archaea 90.5 2.94e-20   NR RDJ35644.1 2056631 g6538 i0 52.2 1.24458204334365 67 32 62.2 0 321 121 104 170 RDJ35644.1 MAG: hypothetical protein DWQ19_12565 [Thermoproteota archaeon] diamond 402 90.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27374490 27374490 PRJNA993416_P_NODE_383_length_1139_cov_2.314259_g330_i0 PRJNA993416 383 1139 2.314259 26.35941001 Thermoproteota archaeon 2056631 Archaea Archaea 130 9.73e-32   NR RDJ35513.1 2056631 g330 i0 37.3 0.508340649692713 193 117 49.8 2 568 2 26 218 RDJ35513.1 MAG: hypothetical protein DWQ19_11900 [Thermoproteota archaeon] diamond 579 130 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27500610 27500610 PRJNA993416_P_NODE_16583_length_229_cov_2.884615_g16478_i0 PRJNA993416 16583 229 2.884615 6.60576835 Thermoproteota archaeon 2056631 Archaea Archaea 57.4 9.59e-8   NR RDJ35613.1 2056631 g16478 i0 36.5 0.96943231441048 74 47 96.9 0 8 229 132 205 RDJ35613.1 MAG: hypothetical protein DWQ19_12410 [Thermoproteota archaeon] diamond 222 57.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27532046 27532046 PRJNA993416_P_NODE_1143_length_770_cov_1.355811_g1051_i0 PRJNA993416 1143 770 1.355811 10.4397447 Thermoproteota archaeon 2056631 Archaea Archaea 168 1.8999999999999997e-48   NR RDJ35263.1 2056631 g1051 i0 47.5 0.68961038961039 177 82 66.6 3 225 737 4 175 RDJ35263.1 MAG: cytidine deaminase [Thermoproteota archaeon] diamond 531 168 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27910685 27910685 PRJNA993416_P_NODE_3425_length_459_cov_1.500000_g3320_i0 PRJNA993416 3425 459 1.5 6.885 Thermoproteota archaeon 2056631 Archaea Archaea 139 1.52e-36   NR RDJ35457.1 2056631 g3320 i0 42.6 1.10457516339869 169 70 96.7 4 445 2 148 310 RDJ35457.1 MAG: hypothetical protein DWQ19_11620 [Thermoproteota archaeon] diamond 507 139 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27942605 27942605 PRJNA993416_P_NODE_1705_length_656_cov_1.852487_g1607_i0 PRJNA993416 1705 656 1.852487 12.15231472 Thermoproteota archaeon 2056631 Archaea Archaea 162 2.44e-45   NR RDJ35111.1 2056631 g1607 i0 40.4 0.882621951219512 193 99 86 4 2 565 116 297 RDJ35111.1 MAG: class I SAM-dependent methyltransferase [Thermoproteota archaeon] diamond 579 162 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28132099 28132099 PRJNA993416_P_NODE_3585_length_447_cov_1.855615_g3480_i0 PRJNA993416 3585 447 1.855615 8.29459905 Thermoproteota archaeon 2056631 Archaea Archaea 150 1.4599999999999996e-40   NR RDJ35470.1 2056631 g3480 i0 52 0.825503355704698 123 59 82.6 0 35 403 4 126 RDJ35470.1 MAG: hypothetical protein DWQ19_11685 [Thermoproteota archaeon] diamond 369 150 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28289647 28289647 PRJNA993416_P_NODE_2706_length_522_cov_2.280624_g2601_i0 PRJNA993416 2706 522 2.280624 11.90485728 Thermoproteota archaeon 2056631 Archaea Archaea 81.6 2.09e-15   NR RDJ35375.1 2056631 g2601 i0 24.7 1 174 123 99.4 4 3 521 51 217 RDJ35375.1 MAG: hypothetical protein DWQ19_11205 [Thermoproteota archaeon] diamond 522 81.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28321331 28321331 PRJNA993416_P_NODE_786_length_892_cov_1.610501_g704_i0 PRJNA993416 786 892 1.610501 14.36566892 Thermoproteota archaeon 2056631 Archaea Archaea 108 1.26e-23   NR RDJ35234.1 2056631 g704 i0 33.3 0.68609865470852 204 123 68.3 6 272 880 15 206 RDJ35234.1 MAG: hypothetical protein DWQ19_10495 [Thermoproteota archaeon] diamond 612 108 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28422187 28422187 PRJNA993416_P_NODE_1366_length_719_cov_2.294118_g1270_i0 PRJNA993416 1366 719 2.294118 16.49470842 root 1 Root_unresolved Root_unresolved 52 9.07e-5   NR RDJ35506.1 2056631 g1270 i0 35.3 1.32267037552156 119 69 49.2 3 428 75 1 112 RDJ35506.1 MAG: hypothetical protein DWQ19_11865 [Thermoproteota archaeon] diamond 951 52 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29047709 29047709 PRJNA993416_P_NODE_2148_length_588_cov_1.970874_g2044_i0 PRJNA993416 2148 588 1.970874 11.58873912 Thermoproteota archaeon 2056631 Archaea Archaea 110 3.09e-26   NR RDJ35360.1 2056631 g2044 i0 34.3 0.729591836734694 143 93 73 1 588 160 64 205 RDJ35360.1 MAG: hypothetical protein DWQ19_11130 [Thermoproteota archaeon] diamond 429 110 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29552553 29552553 PRJNA993416_P_NODE_1930_length_622_cov_1.429872_g1829_i0 PRJNA993416 1930 622 1.429872 8.89380384 Thermoproteota archaeon 2056631 Archaea Archaea 92.4 9.44e-18   NR RDJ34984.1 2056631 g1829 i0 37 0.781350482315113 162 85 71.4 6 529 86 153 311 RDJ34984.1 MAG: hypothetical protein DWQ19_09120 [Thermoproteota archaeon] diamond 486 92.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29552558 29552558 PRJNA993416_P_NODE_8830_length_284_cov_1.535545_g8725_i0 PRJNA993416 8830 284 1.535545 4.3609478 Thermoproteota archaeon 2056631 Archaea Archaea 71.2 5.71e-12   NR RDJ35651.1 2056631 g8725 i0 39.4 0.992957746478873 94 55 98.2 2 280 2 502 594 RDJ35651.1 MAG: hypothetical protein DWQ19_12600 [Thermoproteota archaeon] diamond 282 71.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29621324 29621324 PRJNA993416_P_NODE_1770_length_645_cov_1.935315_g1672_i0 PRJNA993416 1770 645 1.935315 12.48278175 root 1 Root_unresolved Root_unresolved 140 1.42e-38   NR WP_048058803.1 94694 g1672 i0 62.2 6.88837209302326 119 45 55.3 0 365 9 6 124 WP_048058803.1 5-(carboxyamino)imidazole ribonucleotide mutase [Desulfurococcus amylolyticus] diamond 4443 140 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Desulfurococcus Desulfurococcus amylolyticus
29741968 29741968 PRJNA993416_P_NODE_2450_length_549_cov_1.029412_g2346_i0 PRJNA993416 2450 549 1.029412 5.65147188 Thermoproteota archaeon 2056631 Archaea Archaea 75.5 3.17e-12   NR RDJ35652.1 2056631 g2346 i0 31 0.950819672131147 174 106 92.3 5 549 43 48 212 RDJ35652.1 MAG: hypothetical protein DWQ19_12605 [Thermoproteota archaeon] diamond 522 75.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29741969 29741969 PRJNA993416_P_NODE_3710_length_439_cov_1.743169_g3605_i0 PRJNA993416 3710 439 1.743169 7.65251191 Thermoproteota archaeon 2056631 Archaea Archaea 187 2.25e-57   NR RDJ35177.1 2056631 g3605 i0 73.5 0.772209567198178 113 30 77.2 0 32 370 77 189 RDJ35177.1 MAG: hypothetical protein DWQ19_10155 [Thermoproteota archaeon] diamond 339 187 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30658396 30658396 PRJNA993416_P_NODE_1653_length_665_cov_1.250000_g1555_i0 PRJNA993416 1653 665 1.25 8.3125 Thermoproteota archaeon 2056631 Archaea Archaea 305 6.729999999999999e-96   NR RDJ35440.1 2056631 g1555 i0 67 0.996992481203008 221 65 99.7 2 3 665 43 255 RDJ35440.1 MAG: hypothetical protein DWQ19_11535 [Thermoproteota archaeon] diamond 663 305 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30689896 30689896 PRJNA993416_P_NODE_153_length_1557_cov_1.648248_g114_i0 PRJNA993416 153 1557 1.648248 25.66322136 Thermoproteota archaeon 2056631 Archaea Archaea 111 1.13e-23   NR RDJ35511.1 2056631 g114 i0 37 0.595375722543353 154 90 29.5 3 1097 1555 1 148 RDJ35511.1 MAG: hypothetical protein DWQ19_11890 [Thermoproteota archaeon] diamond 927 111 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31195113 31195113 PRJNA993416_P_NODE_3475_length_455_cov_1.209424_g3370_i0 PRJNA993416 3475 455 1.209424 5.5028792 Thermoproteota archaeon 2056631 Archaea Archaea 116 7.960000000000001e-29   NR RDJ35646.1 2056631 g3370 i0 44.3 0.982417582417582 149 78 94.9 3 442 11 70 218 RDJ35646.1 MAG: hypothetical protein DWQ19_12575 [Thermoproteota archaeon] diamond 447 116 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31227005 31227005 PRJNA993416_P_NODE_6495_length_327_cov_1.212598_g6390_i0 PRJNA993416 6495 327 1.212598 3.96519546 Thermoproteota archaeon 2056631 Archaea Archaea 116 1.2e-27   NR RDJ35597.1 2056631 g6390 i0 48.2 1.02752293577982 112 55 100 1 327 1 261 372 RDJ35597.1 MAG: hypothetical protein DWQ19_12330 [Thermoproteota archaeon] diamond 336 116 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31385447 31385447 PRJNA993416_P_NODE_76_length_1991_cov_1.903545_g47_i0 PRJNA993416 76 1991 1.903545 37.89958095 Thermoproteota archaeon 2056631 Archaea Archaea 159 1.72e-41   NR RDJ35647.1 2056631 g47 i0 49.7 0.461074836765444 155 78 23.4 0 1214 1678 4 158 RDJ35647.1 MAG: hypothetical protein DWQ19_12580 [Thermoproteota archaeon] diamond 918 159 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31796261 31796261 PRJNA993416_P_NODE_3157_length_481_cov_1.360294_g3052_i0 PRJNA993416 3157 481 1.360294 6.54301414 Thermoproteota archaeon 2056631 Archaea Archaea 153 1.81e-42   NR RDJ35622.1 2056631 g3052 i0 48.5 1.05405405405405 169 76 99.2 4 1 477 66 233 RDJ35622.1 MAG: serine protease [Thermoproteota archaeon] diamond 507 153 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31859606 31859606 PRJNA993416_P_NODE_4577_length_392_cov_0.840125_g4472_i0 PRJNA993416 4577 392 0.840125 3.29329 Thermoproteota archaeon 2056631 Archaea Archaea 170 7.829999999999998e-48   NR RDJ35382.1 2056631 g4472 i0 65.4 0.994897959183674 130 45 99.5 0 1 390 179 308 RDJ35382.1 MAG: hypothetical protein DWQ19_11240 [Thermoproteota archaeon] diamond 390 170 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32049502 32049502 PRJNA993416_P_NODE_1358_length_723_cov_2.138462_g1262_i0 PRJNA993416 1358 723 2.138462 15.46108026 Thermoproteota archaeon 2056631 Archaea Archaea 51.2 6.03e-5   NR RDJ35319.1 2056631 g1262 i0 41.5 0.219917012448133 53 31 22 0 341 183 3 55 RDJ35319.1 MAG: hypothetical protein DWQ19_10925 [Thermoproteota archaeon] diamond 159 51.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32081147 32081147 PRJNA993416_P_NODE_12918_length_250_cov_0.870056_g12813_i0 PRJNA993416 12918 250 0.870056 2.17514 Thermoproteota archaeon 2056631 Archaea Archaea 96.3 2.73e-21   NR RDJ35470.1 2056631 g12813 i0 57.7 0.936 78 33 93.6 0 17 250 277 354 RDJ35470.1 MAG: hypothetical protein DWQ19_11685 [Thermoproteota archaeon] diamond 234 96.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32397772 32397772 PRJNA993416_P_NODE_5139_length_369_cov_1.300676_g5034_i0 PRJNA993416 5139 369 1.300676 4.79949444 Thermoproteota archaeon 2056631 Archaea Archaea 53.5 7.92e-6   NR RDJ35273.1 2056631 g5034 i0 26.1 0.967479674796748 119 78 88.6 2 362 36 7 125 RDJ35273.1 MAG: hypothetical protein DWQ19_10690 [Thermoproteota archaeon] diamond 357 53.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32492730 32492730 PRJNA993416_P_NODE_2319_length_567_cov_1.246964_g2215_i0 PRJNA993416 2319 567 1.246964 7.07028588 Thermoproteota archaeon 2056631 Archaea Archaea 74.3 1.03e-11   NR RDJ35640.1 2056631 g2215 i0 39.4 0.899470899470899 170 79 82 8 81 545 573 733 RDJ35640.1 MAG: hypothetical protein DWQ19_12545 [Thermoproteota archaeon] diamond 510 74.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32556136 32556136 PRJNA993416_P_NODE_6219_length_334_cov_1.314176_g6114_i0 PRJNA993416 6219 334 1.314176 4.38934784 Thermoproteota archaeon 2056631 Archaea Archaea 188 2.82e-53   NR RDJ35464.1 2056631 g6114 i0 79.3 1.9940119760479 111 23 99.7 0 2 334 631 741 RDJ35464.1 MAG: hypothetical protein DWQ19_11655 [Thermoproteota archaeon] diamond 666 188 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32650013 32650013 PRJNA993416_P_NODE_2960_length_497_cov_1.311321_g2855_i0 PRJNA993416 2960 497 1.311321 6.51726537 Thermoproteota archaeon 2056631 Archaea Archaea 155 1.3899999999999999e-40   NR RDJ35651.1 2056631 g2855 i0 46.7 1.08651911468813 180 71 97.8 4 497 12 322 494 RDJ35651.1 MAG: hypothetical protein DWQ19_12600 [Thermoproteota archaeon] diamond 540 155 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32902081 32902081 PRJNA993416_P_NODE_1160_length_767_cov_1.670029_g1068_i0 PRJNA993416 1160 767 1.670029 12.80912243 Thermoproteota archaeon 2056631 Archaea Archaea 141 8.859999999999998e-35   NR RDJ35368.1 2056631 g1068 i0 33.5 0.852672750977836 218 142 84.1 3 647 3 1 218 RDJ35368.1 MAG: hypothetical protein DWQ19_11170 [Thermoproteota archaeon] diamond 654 141 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon

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