RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

39 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 39 ✖

bioproject 1

  • PRJEB43370 · 39 ✖

analysis 1

  • diamond · 39 ✖
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
5162524 5162524 PRJEB43370_P_NODE_4445_length_212_cov_1.595092_g4402_i0 PRJEB43370 4445 212 1.595092 3.38159504 archaeon 1906665 Archaea Archaea 130 1.35e-36   NR MDP2436660.1 1906665 g4402 i0 91.4 0.990566037735849 70 6 99.1 0 210 1 82 151 MDP2436660.1 30S ribosomal protein S4 [archaeon] diamond 210 130 1 Archaea               archaeon
11538404 11538404 PRJEB43370_P_NODE_3710_length_229_cov_0.916667_g3667_i0 PRJEB43370 3710 229 0.916667 2.09916743 archaeon 1906665 Archaea Archaea 104 1.08e-25   NR MDP2436279.1 1906665 g3667 i0 91.1 0.733624454148472 56 5 73.4 0 229 62 165 220 MDP2436279.1 hypothetical protein [archaeon] diamond 168 104 1 Archaea               archaeon
24285974 24285974 PRJEB43370_P_NODE_10740_length_162_cov_0.920354_g10697_i0 PRJEB43370 10740 162 0.920354 1.49097348 archaeon 1906665 Archaea Archaea 109 2.26e-28   NR MDP2435473.1 1906665 g10697 i0 100 5 54 0 100 0 1 162 13 66 MDP2435473.1 Ras-like protein [archaeon] diamond 810 109 1 Archaea               archaeon
26653328 26653328 PRJEB43370_P_NODE_6221_length_184_cov_1.259259_g6178_i0 PRJEB43370 6221 184 1.259259 2.31703656 Halonotius sp. J 2218529 Archaea Archaea 43.9 0.00667   NR ERH05107.1 1070774 g6178 i0 40.4 3.60326086956522 52 27 84.8 1 5 160 87 134 ERH05107.1 MAG: ABC-type transport system, periplasmic component/surface lipoprotein [Halonotius sp. J07HN4] diamond 663 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halonotius Halonotius sp. J07HN4
26716529 26716529 PRJEB43370_P_NODE_7601_length_169_cov_0.866667_g7558_i0 PRJEB43370 7601 169 0.866667 1.46466723 archaeon 1906665 Archaea Archaea 49.3 6.77e-5   NR MDP2439218.1 1906665 g7558 i0 56.1 0.727810650887574 41 18 72.8 0 165 43 303 343 MDP2439218.1 hypothetical protein [archaeon] diamond 123 49.3 1 Archaea               archaeon
26780382 26780382 PRJEB43370_P_NODE_2001_length_308_cov_1.204633_g1958_i0 PRJEB43370 2001 308 1.204633 3.71026964 archaeon 1906665 Archaea Archaea 79 1.55e-14   NR MDP2435572.1 1906665 g1958 i0 41.5 2.82467532467532 94 55 91.6 0 298 17 372 465 MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon] diamond 870 79 1 Archaea               archaeon
26938388 26938388 PRJEB43370_P_NODE_8102_length_168_cov_0.873950_g8059_i0 PRJEB43370 8102 168 0.87395 1.468236 archaeon 1906665 Archaea Archaea 93.6 3.25e-22   NR MDP2436660.1 1906665 g8059 i0 85.7 0.875 49 7 87.5 0 20 166 1 49 MDP2436660.1 30S ribosomal protein S4 [archaeon] diamond 147 93.6 1 Archaea               archaeon
26994884 26994884 PRJEB43370_P_NODE_5462_length_194_cov_1.434483_g5419_i0 PRJEB43370 5462 194 1.434483 2.78289702 Methanobacteriati 3366610 Archaea Archaea 105 7.26e-26   NR MBH33411.1 2026739 g5419 i0 76.6 3.94329896907217 64 15 99 0 1 192 223 286 MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] diamond 765 105 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27191388 27191388 PRJEB43370_P_NODE_5622_length_192_cov_1.090909_g5579_i0 PRJEB43370 5622 192 1.090909 2.09454528 Thermoplasmata archaeon 1906666 Archaea Archaea 45.4 0.00213   NR HKZ49298.1 1906666 g5579 i0 60.9 3.03125 46 16 71.9 2 53 190 1059 1102 HKZ49298.1 PKD domain-containing protein [Thermoplasmata archaeon] diamond 582 45.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
27286324 27286324 PRJEB43370_P_NODE_9283_length_165_cov_0.896552_g9240_i0 PRJEB43370 9283 165 0.896552 1.4793108 archaeon 1906665 Archaea Archaea 88.6 1.36e-20   NR MDP2436861.1 1906665 g9240 i0 74.5 0.927272727272727 51 13 92.7 0 13 165 70 120 MDP2436861.1 hypothetical protein [archaeon] diamond 153 88.6 1 Archaea               archaeon
27412968 27412968 PRJEB43370_P_NODE_4223_length_217_cov_0.928571_g4180_i0 PRJEB43370 4223 217 0.928571 2.01499907 archaeon 1906665 Archaea Archaea 96.3 2.4799999999999994e-23   NR MDP2438451.1 1906665 g4180 i0 73.8 0.84331797235023 61 16 84.3 0 184 2 64 124 MDP2438451.1 hypothetical protein [archaeon] diamond 183 96.3 1 Archaea               archaeon
27697275 27697275 PRJEB43370_P_NODE_8724_length_166_cov_1.435897_g8681_i0 PRJEB43370 8724 166 1.435897 2.38358902 archaeon 1906665 Archaea Archaea 38.9 0.0444   NR MCP8304388.1 1906665 g8681 i0 56.1 0.740963855421687 41 15 74.1 1 9 131 4 41 MCP8304388.1 30S ribosomal protein S30e [archaeon] diamond 123 38.9 1 Archaea               archaeon
27823387 27823387 PRJEB43370_P_NODE_8364_length_167_cov_0.881356_g8321_i0 PRJEB43370 8364 167 0.881356 1.47186452 archaeon 1906665 Archaea Archaea 104 5.9e-25   NR MDP2437063.1 1906665 g8321 i0 81.8 0.988023952095808 55 10 98.8 0 165 1 213 267 MDP2437063.1 hypothetical protein [archaeon] diamond 165 104 1 Archaea               archaeon
27886298 27886298 PRJEB43370_P_NODE_9045_length_166_cov_0.888889_g9002_i0 PRJEB43370 9045 166 0.888889 1.47555574 archaeon 1906665 Archaea Archaea 48.1 1.65e-4   NR MCQ2818383.1 1906665 g9002 i0 40.9 0.795180722891566 44 26 79.5 0 2 133 481 524 MCQ2818383.1 hypothetical protein [archaeon] diamond 132 48.1 1 Archaea               archaeon
27917799 27917799 PRJEB43370_P_NODE_10385_length_163_cov_0.912281_g10342_i0 PRJEB43370 10385 163 0.912281 1.48701803 archaeon 1906665 Archaea Archaea 50.1 3.29e-5   NR MCQ2821452.1 1906665 g10342 i0 44.2 0.957055214723926 52 28 95.7 1 159 4 139 189 MCQ2821452.1 hypothetical protein [archaeon] diamond 156 50.1 1 Archaea               archaeon
27949539 27949539 PRJEB43370_P_NODE_4525_length_210_cov_6.267081_g4482_i0 PRJEB43370 4525 210 6.267081 13.1608701 Methanomassiliicoccales archaeon LGM-RCC1 3018355 Archaea Archaea 41.2 0.00996   NR WII08072.1 3018355 g4482 i0 73.1 0.371428571428571 26 7 37.1 0 190 113 24 49 WII08072.1 hypothetical protein PED39_02425 [Methanomassiliicoccales archaeon LGM-RCC1] diamond 78 41.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon LGM-RCC1
28201870 28201870 PRJEB43370_P_NODE_4366_length_214_cov_1.260606_g4323_i0 PRJEB43370 4366 214 1.260606 2.69769684 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 41.2 0.0485   NR WP_148687328.1 1826872 g4323 i0 57.1 0.392523364485981 28 12 39.3 0 86 3 88 115 WP_148687328.1 universal stress protein [Candidatus Nitrosocosmicus hydrocola] diamond 84 41.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
28201875 28201875 PRJEB43370_P_NODE_8166_length_168_cov_0.873950_g8123_i0 PRJEB43370 8166 168 0.87395 1.468236 Thermoplasmatota archaeon 2806419 Archaea Archaea 61.6 1.47e-9   NR MEE2759763.1 2806419 g8123 i0 68.3 1.46428571428571 41 13 73.2 0 44 166 1 41 MEE2759763.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Thermoplasmatota archaeon] diamond 246 61.6 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
28928262 28928262 PRJEB43370_P_NODE_10988_length_162_cov_0.920354_g10945_i0 PRJEB43370 10988 162 0.920354 1.49097348 archaeon 1906665 Archaea Archaea 83.6 4.94e-17   NR MDP2437566.1 1906665 g10945 i0 72.5 0.944444444444444 51 14 94.4 0 154 2 343 393 MDP2437566.1 SH2 domain-containing protein [archaeon] diamond 153 83.6 1 Archaea               archaeon
28928268 28928268 PRJEB43370_P_NODE_5468_length_194_cov_1.434483_g5425_i0 PRJEB43370 5468 194 1.434483 2.78289702 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 41.6 0.017   NR MFT4307818.1 2026803 g5425 i0 40 0.618556701030928 40 24 61.9 0 59 178 1 40 MFT4307818.1 transcription factor S [Candidatus Woesearchaeota archaeon] diamond 120 41.6 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28960101 28960101 PRJEB43370_P_NODE_9888_length_164_cov_0.904348_g9845_i0 PRJEB43370 9888 164 0.904348 1.48313072 archaeon 1906665 Archaea Archaea 53.5 1.98e-6   NR MDP2437818.1 1906665 g9845 i0 62.5 0.731707317073171 40 12 73.2 1 163 44 661 697 MDP2437818.1 hypothetical protein [archaeon] diamond 120 53.5 1 Archaea               archaeon
29307103 29307103 PRJEB43370_P_NODE_2869_length_256_cov_1.483092_g2826_i0 PRJEB43370 2869 256 1.483092 3.79671552 Candidatus Micrarchaeota archaeon 2250274 Archaea Archaea 52 2.49e-5   NR MCX6767915.1 2250274 g2826 i0 44.4 0.84375 72 38 82 1 214 5 1150 1221 MCX6767915.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Micrarchaeota archaeon] diamond 216 52 1 Archaea   Nanobdellati Candidatus Micrarchaeota         Candidatus Micrarchaeota archaeon
29433156 29433156 PRJEB43370_P_NODE_7590_length_169_cov_0.866667_g7547_i0 PRJEB43370 7590 169 0.866667 1.46466723 Promethearchaeum syntrophicum 2594042 Archaea Archaea 51.2 1.38e-5   NR WP_147664470.1 2594042 g7547 i0 43.6 3.71005917159763 55 31 97.6 0 168 4 169 223 WP_147664470.1 hypothetical protein [Promethearchaeum syntrophicum] diamond 627 51.2 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
29622448 29622448 PRJEB43370_P_NODE_7710_length_169_cov_0.866667_g7667_i0 PRJEB43370 7710 169 0.866667 1.46466723 archaeon 1906665 Archaea Archaea 86.3 5.65e-20   NR MDP2437082.1 1906665 g7667 i0 73.2 0.994082840236686 56 14 97.6 1 167 3 51 106 MDP2437082.1 hypothetical protein [archaeon] diamond 168 86.3 1 Archaea               archaeon
29773993 29773993 PRJEB43370_P_NODE_6031_length_186_cov_1.518248_g5988_i0 PRJEB43370 6031 186 1.518248 2.82394128 root 1 Root_unresolved Root_unresolved 56.6 1.52e-7   NR UCE38141.1 1906666 g5988 i0 42.4 3.85483870967742 59 34 95.2 0 5 181 106 164 UCE38141.1 MAG: MTAP family purine nucleoside phosphorylase [Thermoplasmata archaeon] diamond 717 56.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30127982 30127982 PRJEB43370_P_NODE_9032_length_166_cov_0.888889_g8989_i0 PRJEB43370 9032 166 0.888889 1.47555574 archaeon 1906665 Archaea Archaea 84.7 1.69e-18   NR MDP2436999.1 1906665 g8989 i0 81.3 0.867469879518072 48 9 86.7 0 22 165 1 48 MDP2436999.1 60S ribosomal protein L13 [archaeon] diamond 144 84.7 1 Archaea               archaeon
30696854 30696854 PRJEB43370_P_NODE_514_length_604_cov_3.576577_g472_i0 PRJEB43370 514 604 3.576577 21.60252508 archaeon 1906665 Archaea Archaea 279 1.3199999999999997e-92   NR MCQ2821492.1 1906665 g472 i0 71.5 2.98013245033113 200 57 99.3 0 602 3 1 200 MCQ2821492.1 50S ribosomal protein L15e [archaeon] diamond 1800 279 1 Archaea               archaeon
30760243 30760243 PRJEB43370_P_NODE_5914_length_188_cov_1.251799_g5871_i0 PRJEB43370 5914 188 1.251799 2.35338212 archaeon 1906665 Archaea Archaea 80.1 1.22e-15   NR MDP2438259.1 1906665 g5871 i0 64.5 0.98936170212766 62 22 98.9 0 187 2 1234 1295 MDP2438259.1 ABC transporter permease [archaeon] diamond 186 80.1 1 Archaea               archaeon
30823342 30823342 PRJEB43370_P_NODE_3154_length_246_cov_0.923858_g3111_i0 PRJEB43370 3154 246 0.923858 2.27269068 archaeon 1906665 Archaea Archaea 80.9 1.29e-16   NR MDP2438732.1 1906665 g3111 i0 53.2 0.963414634146341 79 36 95.1 1 11 244 75 153 MDP2438732.1 hypothetical protein [archaeon] diamond 237 80.9 1 Archaea               archaeon
30949885 30949885 PRJEB43370_P_NODE_11054_length_160_cov_4.297297_g11011_i0 PRJEB43370 11054 160 4.297297 6.8756752 archaeon 1906665 Archaea Archaea 64.7 2.72e-11   NR MCQ2821012.1 1906665 g11011 i0 54.7 0.99375 53 23 97.5 1 158 3 38 90 MCQ2821012.1 GTP-binding protein [archaeon] diamond 159 64.7 1 Archaea               archaeon
31297356 31297356 PRJEB43370_P_NODE_6115_length_185_cov_1.529412_g6072_i0 PRJEB43370 6115 185 1.529412 2.8294122 archaeon 1906665 Archaea Archaea 73.2 3.140000000000001e-13   NR MDP2437702.1 1906665 g6072 i0 62.1 0.940540540540541 58 22 94.1 0 7 180 385 442 MDP2437702.1 adenylyl cyclase-associated domain-containing protein [archaeon] diamond 174 73.2 1 Archaea               archaeon
31455608 31455608 PRJEB43370_P_NODE_3236_length_242_cov_1.886010_g3193_i0 PRJEB43370 3236 242 1.88601 4.5641442 Methanocaldococcus villosus 667126 Archaea Archaea 56.2 1.41e-7   NR WP_004592618.1 667126 g3193 i0 40 0.991735537190083 80 31 99.2 2 242 3 78 140 WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus] diamond 240 56.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus villosus
31518926 31518926 PRJEB43370_P_NODE_2516_length_273_cov_0.915179_g2473_i0 PRJEB43370 2516 273 0.915179 2.49843867 archaeon 1906665 Archaea Archaea 95.1 2.19e-20   NR MDP2435053.1 1906665 g2473 i0 54.7 1.04395604395604 95 38 98.9 3 270 1 1326 1420 MDP2435053.1 hypothetical protein [archaeon] diamond 285 95.1 1 Archaea               archaeon
31645163 31645163 PRJEB43370_P_NODE_5037_length_201_cov_1.710526_g4994_i0 PRJEB43370 5037 201 1.710526 3.43815726 Candidatus Iainarchaeum archaeon 3101447 Archaea Archaea 59.3 2.61e-8   NR HIH10428.1 2026736 g4994 i0 51.9 1.59701492537313 52 25 77.6 0 45 200 38 89 HIH10428.1 UMP kinase [Candidatus Iainarchaeum archaeon] diamond 321 59.3 1 Archaea   Nanobdellati Candidatus Iainarchaeota       Candidatus Iainarchaeum Candidatus Iainarchaeum archaeon
31740032 31740032 PRJEB43370_P_NODE_2397_length_279_cov_0.904348_g2354_i0 PRJEB43370 2397 279 0.904348 2.52313092 archaeon 1906665 Archaea Archaea 141 7.79e-41   NR MDP2438488.1 1906665 g2354 i0 76.7 0.924731182795699 86 20 92.5 0 258 1 1 86 MDP2438488.1 KOW motif-containing protein [archaeon] diamond 258 141 1 Archaea               archaeon
31740044 31740044 PRJEB43370_P_NODE_9377_length_165_cov_0.896552_g9334_i0 PRJEB43370 9377 165 0.896552 1.4793108 archaeon 1906665 Archaea Archaea 93.6 1.32e-20   NR MDP2437160.1 1906665 g9334 i0 72.7 1 55 15 100 0 1 165 418 472 MDP2437160.1 hypothetical protein [archaeon] diamond 165 93.6 1 Archaea               archaeon
32151520 32151520 PRJEB43370_P_NODE_10418_length_163_cov_0.912281_g10375_i0 PRJEB43370 10418 163 0.912281 1.48701803 archaeon 1906665 Archaea Archaea 57.4 7.2e-8   NR MDP2434765.1 1906665 g10375 i0 58.5 0.975460122699387 53 22 97.5 0 3 161 216 268 MDP2434765.1 hypothetical protein [archaeon] diamond 159 57.4 1 Archaea               archaeon
32531368 32531368 PRJEB43370_P_NODE_7339_length_169_cov_1.733333_g7296_i0 PRJEB43370 7339 169 1.733333 2.92933277 archaeon 1906665 Archaea Archaea 45.4 0.00156   NR MDP2434761.1 1906665 g7296 i0 43.5 0.816568047337278 46 25 81.7 1 2 139 671 715 MDP2434761.1 hypothetical protein [archaeon] diamond 138 45.4 1 Archaea               archaeon
32783068 32783068 PRJEB43370_P_NODE_4240_length_216_cov_1.628743_g4197_i0 PRJEB43370 4240 216 1.628743 3.51808488 archaeon 1906665 Archaea Archaea 88.6 2.05e-20   NR MDP2437923.1 1906665 g4197 i0 54.9 0.986111111111111 71 32 98.6 0 2 214 69 139 MDP2437923.1 40S ribosomal protein S19 [archaeon] diamond 213 88.6 1 Archaea               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);;