RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA561138" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA561138 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
544901 544901 PRJNA561138_P_NODE_10681_length_394_cov_0.919003_g10486_i0 PRJNA561138 10681 394 0.919003 3.62087182 root 1 Root_unresolved Root_unresolved 233 3.81e-72   NR MCL4131540.1 82763 g10486 i0 96.6 6.34263959390863 119 4 90.6 0 37 393 1 119 MCL4131540.1 hypothetical protein [Idotea baltica] diamond 2499 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
545088 545088 PRJNA561138_P_NODE_27821_length_245_cov_0.895349_g27626_i0 PRJNA561138 27821 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 150 3.81e-44   NR MCL4121763.1 82763 g27626 i0 92.6 2.97551020408163 81 6 99.2 0 2 244 79 159 MCL4121763.1 hypothetical protein [Idotea baltica] diamond 729 151 0.993377483443709 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
3095921 3095921 PRJNA561138_P_NODE_12943_length_363_cov_1.327586_g12748_i0 PRJNA561138 12943 363 1.327586 4.81913718 Idotea baltica 82763 Arthropoda Arthropoda 228 3.0799999999999996e-68   NR MCL4139914.1 82763 g12748 i0 87.5 2.97520661157025 120 15 99.2 0 361 2 209 328 MCL4139914.1 hypothetical protein [Idotea baltica] diamond 1080 228 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
4372412 4372412 PRJNA561138_P_NODE_12404_length_370_cov_1.016835_g12209_i0 PRJNA561138 12404 370 1.016835 3.7622895 Idotea baltica 82763 Arthropoda Arthropoda 197 7.9200000000000005e-59   NR MCL4146215.1 82763 g12209 i0 68 0.989189189189189 122 39 98.9 0 368 3 154 275 MCL4146215.1 hypothetical protein [Idotea baltica] diamond 366 197 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
4372616 4372616 PRJNA561138_P_NODE_5964_length_507_cov_1.241935_g5770_i0 PRJNA561138 5964 507 1.241935 6.29661045 Idotea baltica 82763 Arthropoda Arthropoda 254 1.24e-80   NR MCL4161034.1 82763 g5770 i0 69.6 0.994082840236686 168 51 99.4 0 505 2 47 214 MCL4161034.1 hypothetical protein [Idotea baltica] diamond 504 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
6922938 6922938 PRJNA561138_P_NODE_10346_length_399_cov_0.944785_g10151_i0 PRJNA561138 10346 399 0.944785 3.76969215 Idotea baltica 82763 Arthropoda Arthropoda 198 1.4699999999999997e-57   NR MCL4158526.1 82763 g10151 i0 77.3 1.98496240601504 132 29 99.2 1 2 397 45 175 MCL4158526.1 hypothetical protein [Idotea baltica] diamond 792 198 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
22222249 22222249 PRJNA561138_P_NODE_3618_length_650_cov_1.067591_g3430_i0 PRJNA561138 3618 650 1.067591 6.9393415 Idotea baltica 82763 Arthropoda Arthropoda 346 1.2099999999999998e-118   NR MCL4158655.1 82763 g3430 i0 81.5 0.996923076923077 216 40 99.7 0 648 1 6 221 MCL4158655.1 hypothetical protein [Idotea baltica] diamond 648 346 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
22807761 22807761 PRJNA561138_P_NODE_19158_length_297_cov_0.973214_g18963_i0 PRJNA561138 19158 297 0.973214 2.89044558 Idotea baltica 82763 Arthropoda Arthropoda 156 1.94e-46   NR MCL4144997.1 82763 g18963 i0 78.5 0.939393939393939 93 20 93.9 0 2 280 69 161 MCL4144997.1 hypothetical protein [Idotea baltica] diamond 279 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
24771451 24771451 PRJNA561138_P_NODE_6360_length_492_cov_1.102625_g6166_i0 PRJNA561138 6360 492 1.102625 5.424915 Idotea baltica 82763 Arthropoda Arthropoda 261 2.56e-81   NR MCL4148265.1 82763 g6166 i0 76.7 2 163 38 99.4 0 1 489 11 173 MCL4148265.1 hypothetical protein [Idotea baltica] diamond 984 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27552776 27552776 PRJNA561138_P_NODE_10824_length_392_cov_0.771160_g10629_i0 PRJNA561138 10824 392 0.77116 3.0229472 Aedes albopictus 7160 Arthropoda Arthropoda 62.4 2.78e-8   NR XP_062711314.1 7160 g10629 i0 41.3 0.704081632653061 92 48 66.6 3 131 391 1370 1460 XP_062711314.1 uncharacterized protein LOC134289471 [Aedes albopictus] diamond 276 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
27616282 27616282 PRJNA561138_P_NODE_15584_length_332_cov_1.996139_g15389_i0 PRJNA561138 15584 332 1.996139 6.62718148 Tribolium castaneum 7070 Arthropoda Arthropoda 44.3 0.0295   NR XP_008199173.3 7070 g15389 i0 34.6 0.731927710843373 81 50 71.4 3 74 310 470 549 XP_008199173.3 protein bride of sevenless [Tribolium castaneum] diamond 243 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
28798145 28798145 PRJNA561138_P_NODE_13987_length_350_cov_1.111913_g13792_i0 PRJNA561138 13987 350 1.111913 3.8916955 root 1 Root_unresolved Root_unresolved 154 3.13e-43   NR MCL4149166.1 82763 g13792 i0 73 1.92857142857143 111 30 95.1 0 335 3 41 151 MCL4149166.1 hypothetical protein [Idotea baltica] diamond 675 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29005841 29005841 PRJNA561138_P_NODE_18948_length_299_cov_1.022124_g18753_i0 PRJNA561138 18948 299 1.022124 3.05615076 Idotea baltica 82763 Arthropoda Arthropoda 106 1.6200000000000003e-27   NR MCL4136006.1 82763 g18753 i0 65.2 0.692307692307692 69 24 69.2 0 298 92 38 106 MCL4136006.1 hypothetical protein [Idotea baltica] diamond 207 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30268946 30268946 PRJNA561138_P_NODE_10952_length_390_cov_0.873817_g10757_i0 PRJNA561138 10952 390 0.873817 3.4078863 Idotea baltica 82763 Arthropoda Arthropoda 191 1.65e-56   NR MCL4137700.1 82763 g10757 i0 77.7 2 130 29 100 0 390 1 212 341 MCL4137700.1 hypothetical protein [Idotea baltica] diamond 780 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30395445 30395445 PRJNA561138_P_NODE_8873_length_423_cov_0.880000_g8678_i0 PRJNA561138 8873 423 0.88 3.7224 Idotea baltica 82763 Arthropoda Arthropoda 67.8 5.79e-11   NR MCL4147105.1 82763 g8678 i0 76.3 0.539007092198582 38 9 27 0 4 117 136 173 MCL4147105.1 hypothetical protein [Idotea baltica] diamond 228 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31216107 31216107 PRJNA561138_P_NODE_26235_length_248_cov_0.880000_g26040_i0 PRJNA561138 26235 248 0.88 2.1824 Araneus ventricosus 182803 Arthropoda Arthropoda 44.3 0.0101   NR GBM43256.1 182803 g26040 i0 42.9 0.592741935483871 49 28 59.3 0 48 194 10 58 GBM43256.1 hypothetical protein AVEN_154579-1 [Araneus ventricosus] diamond 147 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32102220 32102220 PRJNA561138_P_NODE_7678_length_450_cov_1.021220_g7483_i0 PRJNA561138 7678 450 1.02122 4.59549 Idotea baltica 82763 Arthropoda Arthropoda 125 5.14e-33   NR MCL4149742.1 82763 g7483 i0 75.3 0.513333333333333 77 19 51.3 0 1 231 115 191 MCL4149742.1 hypothetical protein [Idotea baltica] diamond 231 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32228985 32228985 PRJNA561138_P_NODE_8398_length_433_cov_0.977778_g8203_i0 PRJNA561138 8398 433 0.977778 4.23377874 Idotea baltica 82763 Arthropoda Arthropoda 176 1.02e-49   NR MCL4157801.1 82763 g8203 i0 63.9 0.997690531177829 144 52 99.8 0 433 2 342 485 MCL4157801.1 hypothetical protein [Idotea baltica] diamond 432 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32765625 32765625 PRJNA561138_P_NODE_8720_length_426_cov_1.090652_g8525_i0 PRJNA561138 8720 426 1.090652 4.64617752 Idotea baltica 82763 Arthropoda Arthropoda 121 8.27e-31   NR MCL4139262.1 82763 g8525 i0 66.7 2.27464788732394 81 27 57 0 3 245 193 273 MCL4139262.1 hypothetical protein [Idotea baltica] diamond 969 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica

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