RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1002570 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
16729202 16729202 PRJNA1002570_P_NODE_2454_length_692_cov_2.815832_g2269_i0 PRJNA1002570 2454 692 2.815832 19.48555744 Thermoproteota archaeon 2056631 Archaea Archaea 181 3.51e-51   NR RDJ35219.1 2056631 g2269 i0 54.8 1.45231213872832 166 66 68.5 2 5 478 91 255 RDJ35219.1 MAG: L-lysine 6-transaminase [Thermoproteota archaeon] diamond 1005 181 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
18004256 18004256 PRJNA1002570_P_NODE_3895_length_545_cov_1.625000_g3703_i0 PRJNA1002570 3895 545 1.625 8.85625 Thermoproteota archaeon 2056631 Archaea Archaea 244 9.98e-74   NR RDJ35315.1 2056631 g3703 i0 63.7 1.00183486238532 182 64 99.1 1 1 540 320 501 RDJ35315.1 MAG: serine protein kinase [Thermoproteota archaeon] diamond 546 244 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
18004291 18004291 PRJNA1002570_P_NODE_4155_length_529_cov_2.732456_g3961_i0 PRJNA1002570 4155 529 2.732456 14.45469224 Thermoproteota archaeon 2056631 Archaea Archaea 166 4.61e-46   NR RDJ35306.1 2056631 g3961 i0 60.9 0.754253308128544 133 52 75.4 0 529 131 295 427 RDJ35306.1 MAG: PHP domain-containing protein [Thermoproteota archaeon] diamond 399 166 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
26907857 26907857 PRJNA1002570_P_NODE_5122_length_481_cov_0.963235_g4928_i0 PRJNA1002570 5122 481 0.963235 4.63316035 Thermoproteota archaeon 2056631 Archaea Archaea 137 5.54e-36   NR RDJ35354.1 2056631 g4928 i0 42.9 1.004158004158 161 82 99.8 4 2 481 137 288 RDJ35354.1 MAG: hypothetical protein DWQ19_11100 [Thermoproteota archaeon] diamond 483 137 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27034348 27034348 PRJNA1002570_P_NODE_11262_length_352_cov_2.584229_g11067_i0 PRJNA1002570 11262 352 2.584229 9.09648608 Thermoproteota archaeon 2056631 Archaea Archaea 91.3 7.030000000000001e-21   NR RDJ35201.1 2056631 g11067 i0 42.9 0.894886363636364 105 55 89.5 2 23 337 4 103 RDJ35201.1 MAG: hypothetical protein DWQ19_10295 [Thermoproteota archaeon] diamond 315 91.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27097574 27097574 PRJNA1002570_P_NODE_3562_length_568_cov_3.947475_g3370_i0 PRJNA1002570 3562 568 3.947475 22.421658 Thermoproteota archaeon 2056631 Archaea Archaea 104 3.4099999999999995e-24   NR RDJ35460.1 2056631 g3370 i0 62.3 0.40669014084507 77 22 40.7 1 20 250 117 186 RDJ35460.1 MAG: hypothetical protein DWQ19_11635 [Thermoproteota archaeon] diamond 231 104 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27824320 27824320 PRJNA1002570_P_NODE_4884_length_491_cov_1.856459_g4690_i0 PRJNA1002570 4884 491 1.856459 9.11521369 Thermoproteota archaeon 2056631 Archaea Archaea 72 7.05e-12   NR RDJ35643.1 2056631 g4690 i0 42.9 2.04684317718941 84 48 51.3 0 484 233 112 195 RDJ35643.1 MAG: hypothetical protein DWQ19_12560 [Thermoproteota archaeon] diamond 1005 72 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28013791 28013791 PRJNA1002570_P_NODE_4845_length_493_cov_1.809524_g4651_i0 PRJNA1002570 4845 493 1.809524 8.92095332 Thermoproteota archaeon 2056631 Archaea Archaea 47.4 0.00119   NR RDJ35491.1 2056631 g4651 i0 35.9 0.559837728194726 92 48 49.3 3 200 442 6 97 RDJ35491.1 MAG: hypothetical protein DWQ19_11790 [Thermoproteota archaeon] diamond 276 47.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28171434 28171434 PRJNA1002570_P_NODE_6666_length_431_cov_2.941341_g6472_i0 PRJNA1002570 6666 431 2.941341 12.67717971 Thermoproteota archaeon 2056631 Archaea Archaea 68.2 1.36e-10   NR RDJ35246.1 2056631 g6472 i0 57.8 0.31322505800464 45 19 31.3 0 427 293 197 241 RDJ35246.1 MAG: glycosyltransferase [Thermoproteota archaeon] diamond 135 68.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29182037 29182037 PRJNA1002570_P_NODE_869_length_1761_cov_2.021327_g733_i0 PRJNA1002570 869 1761 2.021327 35.59556847 Thermoproteota archaeon 2056631 Archaea Archaea 389 8.05e-129   NR RDJ35480.1 2056631 g733 i0 63.6 1.41737649063032 283 101 47.9 1 292 1134 6 288 RDJ35480.1 MAG: hypothetical protein DWQ19_11735 [Thermoproteota archaeon] diamond 2496 389 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29308048 29308048 PRJNA1002570_P_NODE_3929_length_543_cov_2.417021_g3737_i0 PRJNA1002570 3929 543 2.417021 13.12442403 Thermoproteota archaeon 2056631 Archaea Archaea 90.9 1.61e-17   NR RDJ35648.1 2056631 g3737 i0 33 1.12154696132597 203 89 91.2 8 543 49 798 991 RDJ35648.1 MAG: hypothetical protein DWQ19_12585 [Thermoproteota archaeon] diamond 609 90.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29876556 29876556 PRJNA1002570_P_NODE_1851_length_816_cov_1.920592_g1674_i0 PRJNA1002570 1851 816 1.920592 15.67203072 Thermoproteota archaeon 2056631 Archaea Archaea 60.8 8.15e-8   NR RDJ35269.1 2056631 g1674 i0 38.5 0.904411764705882 91 48 33.5 2 543 815 4 86 RDJ35269.1 MAG: hypothetical protein DWQ19_10670 [Thermoproteota archaeon] diamond 738 60.8 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29908191 29908191 PRJNA1002570_P_NODE_17951_length_299_cov_2.646018_g17756_i0 PRJNA1002570 17951 299 2.646018 7.91159382 Thermoproteota archaeon 2056631 Archaea Archaea 65.1 9.96e-10   NR RDJ35597.1 2056631 g17756 i0 34.3 1.02341137123746 102 56 91.3 1 296 24 18 119 RDJ35597.1 MAG: hypothetical protein DWQ19_12330 [Thermoproteota archaeon] diamond 306 65.1 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30413863 30413863 PRJNA1002570_P_NODE_4853_length_492_cov_3.386635_g4659_i0 PRJNA1002570 4853 492 3.386635 16.6622442 Thermoproteota archaeon 2056631 Archaea Archaea 52.8 1.16e-4   NR RDJ35088.1 2056631 g4659 i0 33.8 0.396341463414634 65 42 39.6 1 48 242 79 142 RDJ35088.1 MAG: hypothetical protein DWQ19_09645 [Thermoproteota archaeon] diamond 195 52.8 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30571326 30571326 PRJNA1002570_P_NODE_5433_length_468_cov_1.268354_g5239_i0 PRJNA1002570 5433 468 1.268354 5.93589672 Thermoproteota archaeon 2056631 Archaea Archaea 161 1.84e-45   NR RDJ35634.1 2056631 g5239 i0 52.9 0.993589743589744 155 72 99.4 1 468 4 40 193 RDJ35634.1 MAG: hypothetical protein DWQ19_12515 [Thermoproteota archaeon] diamond 465 161 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30666289 30666289 PRJNA1002570_P_NODE_8713_length_388_cov_0.977778_g8518_i0 PRJNA1002570 8713 388 0.977778 3.79377864 Thermoproteota archaeon 2056631 Archaea Archaea 44.3 0.0423   NR RDJ35618.1 2056631 g8518 i0 36.9 0.649484536082474 84 49 62.6 4 1 243 143 225 RDJ35618.1 MAG: hypothetical protein DWQ19_12435 [Thermoproteota archaeon] diamond 252 44.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31077187 31077187 PRJNA1002570_P_NODE_12555_length_337_cov_2.106061_g12360_i0 PRJNA1002570 12555 337 2.106061 7.09742557 Thermoproteota archaeon 2056631 Archaea Archaea 137 1.77e-35   NR RDJ35443.1 2056631 g12360 i0 57.1 0.997032640949555 112 46 99.7 2 336 1 161 270 RDJ35443.1 MAG: CTP synthase [Thermoproteota archaeon] diamond 336 137 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31234923 31234923 PRJNA1002570_P_NODE_3875_length_546_cov_2.845666_g3683_i0 PRJNA1002570 3875 546 2.845666 15.53733636 Thermoproteota archaeon 2056631 Archaea Archaea 84 4.66e-17   NR RDJ35507.1 2056631 g3683 i0 44.1 0.60989010989011 111 54 56.6 3 456 148 25 135 RDJ35507.1 MAG: hypothetical protein DWQ19_11870 [Thermoproteota archaeon] diamond 333 84 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31361731 31361731 PRJNA1002570_P_NODE_2176_length_741_cov_1.886228_g1995_i0 PRJNA1002570 2176 741 1.886228 13.97694948 Thermoproteota archaeon 2056631 Archaea Archaea 246 6.010000000000001e-73   NR RDJ35440.1 2056631 g1995 i0 60.5 0.769230769230769 190 68 76.9 1 572 3 1 183 RDJ35440.1 MAG: hypothetical protein DWQ19_11535 [Thermoproteota archaeon] diamond 570 246 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31456597 31456597 PRJNA1002570_P_NODE_2536_length_679_cov_2.036304_g2351_i0 PRJNA1002570 2536 679 2.036304 13.82650416 Thermoproteota archaeon 2056631 Archaea Archaea 245 2.25e-73   NR RDJ35651.1 2056631 g2351 i0 51.1 1.96170839469809 223 106 97.6 2 13 675 11 232 RDJ35651.1 MAG: hypothetical protein DWQ19_12600 [Thermoproteota archaeon] diamond 1332 245 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31551616 31551616 PRJNA1002570_P_NODE_2096_length_755_cov_1.932551_g1916_i0 PRJNA1002570 2096 755 1.932551 14.59076005 Thermoproteota archaeon 2056631 Archaea Archaea 159 5.98e-44   NR RDJ35646.1 2056631 g1916 i0 40.6 0.949668874172185 239 129 93 5 5 706 6 236 RDJ35646.1 MAG: hypothetical protein DWQ19_12575 [Thermoproteota archaeon] diamond 717 159 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31583185 31583185 PRJNA1002570_P_NODE_39556_length_247_cov_0.885057_g39361_i0 PRJNA1002570 39556 247 0.885057 2.18609079 Thermoproteota archaeon 2056631 Archaea Archaea 96.3 2.39e-21   NR RDJ35278.1 2056631 g39361 i0 54.4 1.94331983805668 79 35 96 1 245 9 56 133 RDJ35278.1 MAG: hypothetical protein DWQ19_10715 [Thermoproteota archaeon] diamond 480 96.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32120919 32120919 PRJNA1002570_P_NODE_10058_length_367_cov_2.387755_g9863_i0 PRJNA1002570 10058 367 2.387755 8.76306085 Thermoproteota archaeon 2056631 Archaea Archaea 112 5.050000000000001e-27   NR RDJ35357.1 2056631 g9863 i0 46.3 0.989100817438692 121 63 98.9 2 1 363 97 215 RDJ35357.1 MAG: hypothetical protein DWQ19_11115 [Thermoproteota archaeon] diamond 363 112 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32120976 32120976 PRJNA1002570_P_NODE_7558_length_409_cov_3.461310_g7364_i0 PRJNA1002570 7558 409 3.46131 14.1567579 Thermoproteota archaeon 2056631 Archaea Archaea 69.7 1.33e-11   NR RDJ35543.1 2056631 g7364 i0 34.5 1.06356968215159 84 55 61.6 0 255 4 81 164 RDJ35543.1 MAG: thioredoxin [Thermoproteota archaeon] diamond 435 69.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32184192 32184192 PRJNA1002570_P_NODE_9618_length_374_cov_1.458472_g9423_i0 PRJNA1002570 9618 374 1.458472 5.45468528 Thermoproteota archaeon 2056631 Archaea Archaea 71.6 1.17e-12   NR RDJ35263.1 2056631 g9423 i0 41.4 0.697860962566845 87 42 65 2 124 366 68 151 RDJ35263.1 MAG: cytidine deaminase [Thermoproteota archaeon] diamond 261 71.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32342555 32342555 PRJNA1002570_P_NODE_4399_length_514_cov_4.950113_g4205_i0 PRJNA1002570 4399 514 4.950113 25.44358082 Thermoproteota archaeon 2056631 Archaea Archaea 101 1.84e-21   NR RDJ35605.1 2056631 g4205 i0 40.4 0.82295719844358 141 82 81.7 2 14 433 479 618 RDJ35605.1 MAG: hypothetical protein DWQ19_12370 [Thermoproteota archaeon] diamond 423 101 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32721218 32721218 PRJNA1002570_P_NODE_10840_length_357_cov_3.183099_g10645_i0 PRJNA1002570 10840 357 3.183099 11.36366343 Thermoproteota archaeon 2056631 Archaea Archaea 65.1 1.92e-9   NR RDJ35368.1 2056631 g10645 i0 29 1.57142857142857 93 66 78.2 0 66 344 1 93 RDJ35368.1 MAG: hypothetical protein DWQ19_11170 [Thermoproteota archaeon] diamond 561 65.1 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);;