RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJEB673" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 35 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJEB673 · 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
2684984 2684984 PRJEB673_P_NODE_2503_length_622_cov_2.425894_g2211_i0 PRJEB673 2503 622 2.425894 15.08906068 archaeon 1906665 Archaea Archaea 238 5.8300000000000004e-77   NR RYH06910.1 1906665 g2211 i0 83.1 0.655948553054662 136 23 65.6 0 409 2 23 158 RYH06910.1 MAG: hypothetical protein EON65_42320 [archaeon] diamond 408 238 1 Archaea               archaeon
11613386 11613386 PRJEB673_P_NODE_1570_length_763_cov_2.343407_g1334_i0 PRJEB673 1570 763 2.343407 17.88019541 archaeon 1906665 Archaea Archaea 397 3.809999999999998e-138   NR RYH25290.1 1906665 g1334 i0 92.7 0.809960681520315 206 15 81 0 682 65 1 206 RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] diamond 618 397 1 Archaea               archaeon
17986516 17986516 PRJEB673_P_NODE_5755_length_368_cov_1.771772_g5406_i0 PRJEB673 5755 368 1.771772 6.52012096 archaeon 1906665 Archaea Archaea 159 4.42e-48   NR RYG67591.1 1906665 g5406 i0 77.4 0.864130434782609 106 24 86.4 0 319 2 2 107 RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon] diamond 318 159 1 Archaea               archaeon
17986520 17986520 PRJEB673_P_NODE_6015_length_358_cov_1.551084_g5666_i0 PRJEB673 6015 358 1.551084 5.55288072 archaeon 1906665 Archaea Archaea 108 7.99e-28   NR RYG63904.1 1906665 g5666 i0 83.6 0.56145251396648 67 11 56.1 0 201 1 47 113 RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] diamond 201 108 1 Archaea               archaeon
19260539 19260539 PRJEB673_P_NODE_6936_length_329_cov_1.367347_g6587_i0 PRJEB673 6936 329 1.367347 4.49857163 archaeon 1906665 Archaea Archaea 95.1 2.91e-22   NR RYH30694.1 1906665 g6587 i0 93.9 0.893617021276596 49 3 44.7 0 181 327 53 101 RYH30694.1 MAG: 30S ribosomal protein S15 [archaeon] diamond 294 95.1 1 Archaea               archaeon
20535829 20535829 PRJEB673_P_NODE_4537_length_441_cov_2.152709_g4191_i0 PRJEB673 4537 441 2.152709 9.49344669 archaeon 1906665 Archaea Archaea 182 1.4999999999999997e-56   NR RYH29492.1 1906665 g4191 i0 81.4 0.768707482993197 113 20 76.2 1 47 382 6 118 RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] diamond 339 182 1 Archaea               archaeon
21397421 21397421 PRJEB673_P_NODE_737_length_1061_cov_2.673489_g574_i0 PRJEB673 737 1061 2.673489 28.36571829 archaeon 1906665 Archaea Archaea 474 2.2699999999999995e-165   NR RYH04926.1 1906665 g574 i0 80.1 0.907634307257304 321 62 90.2 2 967 11 1 321 RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] diamond 963 474 1 Archaea               archaeon
26590618 26590618 PRJEB673_P_NODE_5981_length_359_cov_1.858025_g5632_i0 PRJEB673 5981 359 1.858025 6.67030975 archaeon 1906665 Archaea Archaea 78.6 1.61e-16   NR RYG97170.1 1906665 g5632 i0 66.1 0.518105849582173 62 18 50.1 2 257 78 12 72 RYG97170.1 MAG: hypothetical protein EON65_53280, partial [archaeon] diamond 186 78.6 1 Archaea               archaeon
26653974 26653974 PRJEB673_P_NODE_11581_length_160_cov_1.280000_g11232_i0 PRJEB673 11581 160 1.28 2.048 archaeon 1906665 Archaea Archaea 87 6.26e-20   NR RYH06910.1 1906665 g11232 i0 75.5 1.9875 53 13 99.4 0 2 160 22 74 RYH06910.1 MAG: hypothetical protein EON65_42320 [archaeon] diamond 318 87 1 Archaea               archaeon
26685803 26685803 PRJEB673_P_NODE_5261_length_391_cov_2.449438_g4912_i0 PRJEB673 5261 391 2.449438 9.57730258 archaeon 1906665 Archaea Archaea 116 4.76e-31   NR RYG99347.1 1906665 g4912 i0 81.1 1.21227621483376 74 14 56.8 0 223 2 1 74 RYG99347.1 MAG: hypothetical protein EON65_50365 [archaeon] diamond 474 116 1 Archaea               archaeon
26717139 26717139 PRJEB673_P_NODE_8641_length_251_cov_1.291667_g8292_i0 PRJEB673 8641 251 1.291667 3.24208417 archaeon 1906665 Archaea Archaea 107 2.56e-26   NR RYH20954.1 1906665 g8292 i0 57.8 0.99203187250996006 83 35 99.2 0 2 250 110 192 RYH20954.1 MAG: hypothetical protein EON65_21955 [archaeon] diamond 249 107 1 Archaea               archaeon
27097256 27097256 PRJEB673_P_NODE_4822_length_419_cov_1.250000_g4474_i0 PRJEB673 4822 419 1.25 5.2375 archaeon 1906665 Archaea Archaea 162 2.5899999999999993e-46   NR RYG65852.1 1906665 g4474 i0 59.1 0.909307875894988 127 51 90.9 1 38 418 157 282 RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon] diamond 381 162 1 Archaea               archaeon
27128503 27128503 PRJEB673_P_NODE_7782_length_307_cov_1.643382_g7433_i0 PRJEB673 7782 307 1.643382 5.0451827400000004 archaeon 1906665 Archaea Archaea 72.8 6.58e-14   NR RYY88097.1 1906665 g7433 i0 68 0.957654723127036 50 13 45.9 1 165 305 49 98 RYY88097.1 MAG: hypothetical protein EON63_03030 [archaeon] diamond 294 72.8 1 Archaea               archaeon
27571204 27571204 PRJEB673_P_NODE_3724_length_516_cov_2.166320_g3397_i0 PRJEB673 3724 516 2.16632 11.1782112 archaeon 1906665 Archaea Archaea 145 6.569999999999998e-42   NR RYG59363.1 1906665 g3397 i0 82.2 0.523255813953488 90 15 51.7 1 66 332 1 90 RYG59363.1 MAG: hypothetical protein EON64_20310, partial [archaeon] diamond 270 145 1 Archaea               archaeon
27697916 27697916 PRJEB673_P_NODE_4124_length_480_cov_4.910112_g3788_i0 PRJEB673 4124 480 4.910112 23.5685376 archaeon 1906665 Archaea Archaea 113 3e-29   NR RYH00022.1 1906665 g3788 i0 67.7 0.61875 99 31 61.9 1 353 57 1 98 RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] diamond 297 113 1 Archaea               archaeon
27950224 27950224 PRJEB673_P_NODE_8785_length_237_cov_1.282178_g8436_i0 PRJEB673 8785 237 1.282178 3.03876186 archaeon 1906665 Archaea Archaea 138 5.49e-37   NR RYH21651.1 1906665 g8436 i0 87.3 2 79 10 100 0 1 237 93 171 RYH21651.1 MAG: ATP-binding cassette domain-containing protein [archaeon] diamond 474 138 1 Archaea               archaeon
28392170 28392170 PRJEB673_P_NODE_10166_length_179_cov_1.666667_g9817_i0 PRJEB673 10166 179 1.666667 2.98333393 archaeon 1906665 Archaea Archaea 88.6 3.36e-21   NR RYH30520.1 1906665 g9817 i0 72.9 0.988826815642458 59 16 98.9 0 177 1 22 80 RYH30520.1 MAG: ribosomal L7Ae/L30e/S12e/Gadd45 family protein [archaeon] diamond 177 88.6 1 Archaea               archaeon
28581769 28581769 PRJEB673_P_NODE_9347_length_200_cov_1.921212_g8998_i0 PRJEB673 9347 200 1.921212 3.842424 archaeon 1906665 Archaea Archaea 94.7 2.3699999999999998e-23   NR RYH18874.1 1906665 g8998 i0 67.7 0.975 65 19 97.5 1 3 197 40 102 RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] diamond 195 94.7 1 Archaea               archaeon
28644885 28644885 PRJEB673_P_NODE_12807_length_151_cov_1.663793_g12458_i0 PRJEB673 12807 151 1.663793 2.51232743 archaeon 1906665 Archaea Archaea 97.4 8.49e-25   NR RYY71007.1 1906665 g12458 i0 90 0.993377483443709 50 5 99.3 0 2 151 36 85 RYY71007.1 MAG: hypothetical protein EON63_22080 [archaeon] diamond 150 97.4 1 Archaea               archaeon
28676468 28676468 PRJEB673_P_NODE_5827_length_365_cov_1.121212_g5478_i0 PRJEB673 5827 365 1.121212 4.0924238 archaeon 1906665 Archaea Archaea 86.3 1.55e-18   NR RYH03712.1 1906665 g5478 i0 78.8 0.427397260273973 52 11 42.7 0 209 364 53 104 RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon] diamond 156 86.3 1 Archaea               archaeon
28771011 28771011 PRJEB673_P_NODE_9207_length_206_cov_2.058480_g8858_i0 PRJEB673 9207 206 2.05848 4.2404688 archaeon 1906665 Archaea Archaea 122 6.0299999999999986e-34   NR RYH28872.1 1906665 g8858 i0 89.7 0.990291262135922 68 7 99 0 1 204 15 82 RYH28872.1 MAG: hypothetical protein EON65_10545 [archaeon] diamond 204 122 1 Archaea               archaeon
28960782 28960782 PRJEB673_P_NODE_2348_length_639_cov_2.258278_g2067_i0 PRJEB673 2348 639 2.258278 14.43039642 archaeon 1906665 Archaea Archaea 261 6.71e-86   NR RYG68742.1 1906665 g2067 i0 80.6 0.751173708920188 160 31 75.1 0 8 487 1 160 RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] diamond 480 261 1 Archaea               archaeon
29024042 29024042 PRJEB673_P_NODE_9548_length_194_cov_1.251572_g9199_i0 PRJEB673 9548 194 1.251572 2.42804968 archaeon 1906665 Archaea Archaea 88.2 1.44e-20   NR RYY86005.1 1906665 g9199 i0 69.8 0.974226804123711 63 19 97.4 0 193 5 47 109 RYY86005.1 MAG: hypothetical protein EON63_06515 [archaeon] diamond 189 88.2 1 Archaea               archaeon
29402515 29402515 PRJEB673_P_NODE_8929_length_224_cov_1.052910_g8580_i0 PRJEB673 8929 224 1.05291 2.3585184 archaeon 1906665 Archaea Archaea 58.2 7.83e-8   NR RYG66691.1 1906665 g8580 i0 41.9 0.991071428571429 74 38 99.1 1 224 3 149 217 RYG66691.1 MAG: hypothetical protein EON64_09195 [archaeon] diamond 222 58.2 1 Archaea               archaeon
29465293 29465293 PRJEB673_P_NODE_11730_length_159_cov_0.967742_g11381_i0 PRJEB673 11730 159 0.967742 1.53870978 archaeon 1906665 Archaea Archaea 87 2.68e-20   NR RYG69932.1 1906665 g11381 i0 73.1 0.981132075471698 52 14 98.1 0 2 157 23 74 RYG69932.1 MAG: hypothetical protein EON64_01515, partial [archaeon] diamond 156 87 1 Archaea               archaeon
29528944 29528944 PRJEB673_P_NODE_11790_length_158_cov_1.626016_g11441_i0 PRJEB673 11790 158 1.626016 2.56910528 archaeon 1906665 Archaea Archaea 59.7 1.17e-8   NR RYH20254.1 1906665 g11441 i0 62 0.949367088607595 50 19 94.9 0 2 151 216 265 RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] diamond 150 59.7 1 Archaea               archaeon
29781393 29781393 PRJEB673_P_NODE_10411_length_174_cov_2.035971_g10062_i0 PRJEB673 10411 174 2.035971 3.54258954 archaeon 1906665 Archaea Archaea 96.3 1.17e-22   NR RYH18875.1 1906665 g10062 i0 86 0.982758620689655 57 6 98.3 1 173 3 160 214 RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] diamond 171 96.3 1 Archaea               archaeon
29907919 29907919 PRJEB673_P_NODE_9871_length_185_cov_1.860000_g9522_i0 PRJEB673 9871 185 1.86 3.441 archaeon 1906665 Archaea Archaea 43.1 0.0125   NR RYH20254.1 1906665 g9522 i0 48.9 0.72972972972973 45 23 73 0 180 46 305 349 RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] diamond 135 43.1 1 Archaea               archaeon
29970930 29970930 PRJEB673_P_NODE_10611_length_171_cov_1.455882_g10262_i0 PRJEB673 10611 171 1.455882 2.48955822 archaeon 1906665 Archaea Archaea 111 5.49e-29   NR RYH25290.1 1906665 g10262 i0 92.9 0.982456140350877 56 4 98.2 0 2 169 32 87 RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] diamond 168 111 1 Archaea               archaeon
30413557 30413557 PRJEB673_P_NODE_5953_length_360_cov_1.720000_g5604_i0 PRJEB673 5953 360 1.72 6.192 archaeon 1906665 Archaea Archaea 102 2.27e-25   NR RYH29492.1 1906665 g5604 i0 58.1 1.74166666666667 105 39 83.3 1 319 20 13 117 RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] diamond 627 102 1 Archaea               archaeon
31076899 31076899 PRJEB673_P_NODE_6475_length_342_cov_1.661238_g6126_i0 PRJEB673 6475 342 1.661238 5.68143396 archaeon 1906665 Archaea Archaea 67.4 6.29e-12   NR RYG96209.1 1906665 g6126 i0 69 0.368421052631579 42 13 36.8 0 175 300 56 97 RYG96209.1 MAG: hypothetical protein EON65_54770, partial [archaeon] diamond 126 67.4 1 Archaea               archaeon
31227441 31227441 PRJEB673_P_NODE_2735_length_598_cov_7.152753_g2433_i0 PRJEB673 2735 598 7.152753 42.77346294 root 1 Root_unresolved Root_unresolved 61.6 9.24e-9   NR MFP3130669.1 2268198 g2433 i0 71.1 0.998327759197324 38 11 19.1 0 7 120 54 91 MFP3130669.1 4a-hydroxytetrahydrobiopterin dehydratase [Nitrososphaeria archaeon] diamond 597 61.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
32088832 32088832 PRJEB673_P_NODE_8498_length_268_cov_1.678112_g8149_i0 PRJEB673 8498 268 1.678112 4.49734016 archaeon 1906665 Archaea Archaea 167 3.53e-51   NR RYG68742.1 1906665 g8149 i0 84.3 0.996268656716418 89 14 99.6 0 1 267 24 112 RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] diamond 267 167 1 Archaea               archaeon
32437186 32437186 PRJEB673_P_NODE_10499_length_173_cov_1.152174_g10150_i0 PRJEB673 10499 173 1.152174 1.99326102 archaeon 1906665 Archaea Archaea 45.1 4.61e-4   NR RYH00022.1 1906665 g10150 i0 75.6 0.710982658959538 41 10 71.1 0 170 48 58 98 RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] diamond 123 45.1 1 Archaea               archaeon
32468787 32468787 PRJEB673_P_NODE_11779_length_158_cov_1.951220_g11430_i0 PRJEB673 11779 158 1.95122 3.0829276 archaeon 1906665 Archaea Archaea 42 0.013   NR MDP2436403.1 1906665 g11430 i0 37.3 0.968354430379747 51 27 87.3 1 18 155 2 52 MDP2436403.1 hypothetical protein [archaeon] diamond 153 42 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);;