RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJEB2925" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 17 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJEB2925 · 17 ✖

analysis 1

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
2263357 2263357 PRJEB2925_P_NODE_10742_length_345_cov_1.748387_g9469_i0 PRJEB2925 10742 345 1.748387 6.03193515 archaeon 1906665 Archaea Archaea 109 2.42e-28   NR MDP2439821.1 1906665 g9469 i0 89.2 0.565217391304348 65 7 56.5 0 318 124 33 97 MDP2439821.1 eS25 family ribosomal protein [archaeon] diamond 195 109 1 Archaea               archaeon
2575941 2575941 PRJEB2925_P_NODE_14803_length_264_cov_1.445415_g13525_i0 PRJEB2925 14803 264 1.445415 3.8158956 archaeon 1906665 Archaea Archaea 69.7 4.19e-13   NR RYG67591.1 1906665 g13525 i0 43.8 1.19318181818182 105 30 86.4 1 229 2 3 107 RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon] diamond 315 69.7 1 Archaea               archaeon
2576046 2576046 PRJEB2925_P_NODE_8703_length_412_cov_2.647215_g7450_i0 PRJEB2925 8703 412 2.647215 10.9065258 archaeon 1906665 Archaea Archaea 187 5.499999999999999e-58   NR MDP2434214.1 1906665 g7450 i0 89.5 0.830097087378641 114 12 83 0 411 70 6 119 MDP2434214.1 50S ribosomal protein L19e [archaeon] diamond 342 187 1 Archaea               archaeon
4816003 4816003 PRJEB2925_P_NODE_9884_length_370_cov_2.614925_g8612_i0 PRJEB2925 9884 370 2.614925 9.6752225 archaeon 1906665 Archaea Archaea 176 1.78e-53   NR MDP2437167.1 1906665 g8612 i0 82.8 0.802702702702703 99 17 80.3 0 368 72 85 183 MDP2437167.1 50S ribosomal protein L5 [archaeon] diamond 297 176 1 Archaea               archaeon
6091191 6091191 PRJEB2925_P_NODE_15905_length_249_cov_2.210280_g14627_i0 PRJEB2925 15905 249 2.21028 5.5035972 archaeon 1906665 Archaea Archaea 146 2.5399999999999998e-42   NR MDP2436545.1 1906665 g14627 i0 86.7 1 83 2 89.2 1 23 244 1 83 MDP2436545.1 50S ribosomal protein L16 [archaeon] diamond 249 146 1 Archaea               archaeon
6404251 6404251 PRJEB2925_P_NODE_11566_length_323_cov_2.381944_g10291_i0 PRJEB2925 11566 323 2.381944 7.69367912 archaeon 1906665 Archaea Archaea 146 5.6699999999999984e-43   NR MDP2436333.1 1906665 g10291 i0 80.7 0.81733746130031 88 17 81.7 0 58 321 1 88 MDP2436333.1 30S ribosomal protein S10 [archaeon] diamond 264 146 1 Archaea               archaeon
9916228 9916228 PRJEB2925_P_NODE_11288_length_330_cov_1.491525_g10014_i0 PRJEB2925 11288 330 1.491525 4.9220325 archaeon 1906665 Archaea Archaea 190 1.9300000000000002e-59   NR MDP2436660.1 1906665 g10014 i0 92.2 0.936363636363636 103 8 93.6 0 20 328 1 103 MDP2436660.1 30S ribosomal protein S4 [archaeon] diamond 309 190 1 Archaea               archaeon
10228925 10228925 PRJEB2925_P_NODE_5389_length_578_cov_1.808471_g4353_i0 PRJEB2925 5389 578 1.808471 10.45296238 archaeon 1906665 Archaea Archaea 251 4.87e-81   NR MDP2436818.1 1906665 g4353 i0 75 0.85121107266436 164 41 85.1 0 87 578 30 193 MDP2436818.1 50S ribosomal protein L2 [archaeon] diamond 492 251 1 Archaea               archaeon
17565940 17565940 PRJEB2925_P_NODE_14014_length_275_cov_1.495833_g12736_i0 PRJEB2925 14014 275 1.495833 4.11354075 archaeon 1906665 Archaea Archaea 169 4.2e-51   NR MDP2436279.1 1906665 g12736 i0 92.3 0.992727272727273 91 7 99.3 0 3 275 3 93 MDP2436279.1 hypothetical protein [archaeon] diamond 273 169 1 Archaea               archaeon
18839790 18839790 PRJEB2925_P_NODE_15395_length_256_cov_2.000000_g14117_i0 PRJEB2925 15395 256 2 5.12 archaeon 1906665 Archaea Archaea 134 1.88e-36   NR MDP2437415.1 1906665 g14117 i0 84.4 3.6328125 77 12 90.2 0 24 254 1 77 MDP2437415.1 hypothetical protein [archaeon] diamond 930 134 1 Archaea               archaeon
19151583 19151583 PRJEB2925_P_NODE_11236_length_331_cov_1.750000_g9962_i0 PRJEB2925 11236 331 1.75 5.7925 archaeon 1906665 Archaea Archaea 131 4.59e-37   NR RYH29492.1 1906665 g9962 i0 82.4 0.670694864048338 74 13 67.1 0 330 109 45 118 RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] diamond 222 131 1 Archaea               archaeon
27570318 27570318 PRJEB2925_P_NODE_13624_length_281_cov_2.138211_g12346_i0 PRJEB2925 13624 281 2.138211 6.00837291 archaeon 1906665 Archaea Archaea 104 3.42e-27   NR MDP2438437.1 1906665 g12346 i0 81.3 0.683274021352313 64 12 68.3 0 23 214 1 64 MDP2438437.1 60S ribosomal protein L38 [archaeon] diamond 192 104 1 Archaea               archaeon
27823161 27823161 PRJEB2925_P_NODE_4464_length_652_cov_6.854133_g3518_i0 PRJEB2925 4464 652 6.854133 44.68894716 archaeon 1906665 Archaea Archaea 281 3.13e-93   NR MCQ2821492.1 1906665 g3518 i0 70.9 7.47239263803681 203 59 93.4 0 652 44 2 204 MCQ2821492.1 50S ribosomal protein L15e [archaeon] diamond 4872 281 1 Archaea               archaeon
28170298 28170298 PRJEB2925_P_NODE_14546_length_267_cov_2.288793_g13268_i0 PRJEB2925 14546 267 2.288793 6.11107731 archaeon 1906665 Archaea Archaea 57.8 1.14e-7   NR NCQ51534.1 1906665 g13268 i0 49.3 0.775280898876405 69 25 73 2 202 8 23 85 NCQ51534.1 hypothetical protein [archaeon] diamond 207 57.8 1 Archaea               archaeon
29843723 29843723 PRJEB2925_P_NODE_10931_length_339_cov_2.236842_g9657_i0 PRJEB2925 10931 339 2.236842 7.58289438 archaeon 1906665 Archaea Archaea 71.6 8.56e-12   NR NCQ52301.1 1906665 g9657 i0 64.3 0.495575221238938 56 20 49.6 0 172 339 727 782 NCQ52301.1 TraM recognition domain-containing protein [archaeon] diamond 168 71.6 1 Archaea               archaeon
30001820 30001820 PRJEB2925_P_NODE_13751_length_279_cov_1.827869_g12473_i0 PRJEB2925 13751 279 1.827869 5.09975451 archaeon 1906665 Archaea Archaea 142 3.71e-41   NR MDP2438488.1 1906665 g12473 i0 74.4 0.967741935483871 90 19 92.5 1 21 278 1 90 MDP2438488.1 KOW motif-containing protein [archaeon] diamond 270 142 1 Archaea               archaeon
31803107 31803107 PRJEB2925_P_NODE_11017_length_337_cov_1.937086_g9743_i0 PRJEB2925 11017 337 1.937086 6.52797982 Nanobdellota archaeon 2026764 Archaea Archaea 48.9 7.68e-4   NR MBR9679100.1 2026764 g9743 i0 33.3 0.587537091988131 66 44 58.8 0 2 199 739 804 MBR9679100.1 alanine--tRNA ligase [Nanoarchaeota archaeon] diamond 198 48.9 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota 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);;