RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA825466" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA825466 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
5923688 5923688 PRJNA825466_P_NODE_28045_length_241_cov_2.291667_g27944_i0 PRJNA825466 28045 241 2.291667 5.52291747 Opisthokonta 33154 Arthropoda Arthropoda 144 4.14e-41   NR ACY43264.1 88015 g27944 i0 78.8 22.8423236514523 80 17 99.6 0 2 241 2 81 ACY43264.1 ala-tRNA synthetase, partial [Eurytemora affinis] diamond 5505 145 0.993103448275862 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora affinis
8881221 8881221 PRJNA825466_P_NODE_5587_length_341_cov_1.149254_g5486_i0 PRJNA825466 5587 341 1.149254 3.91895614 Diptera 7147 Arthropoda Arthropoda 124 1.13e-32   NR KAI8116405.1 7375 g5486 i0 60 9.21994134897361 105 42 92.4 0 316 2 141 245 KAI8116405.1 Histone H2B.3 [Lucilia cuprina] diamond 3144 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
19946941 19946941 PRJNA825466_P_NODE_1156_length_640_cov_1.962963_g1060_i0 PRJNA825466 1156 640 1.962963 12.5629632 Metazoa 33208 Arthropoda Arthropoda 276 1.22e-89   NR CAD7282694.1 399045 g1060 i0 62.2 18.7171875 222 75 99.8 4 2 640 76 297 CAD7282694.1 unnamed protein product [Notodromas monacha] diamond 11979 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
22497162 22497162 PRJNA825466_P_NODE_19318_length_249_cov_0.875000_g19217_i0 PRJNA825466 19318 249 0.875 2.17875 Diptera 7147 Arthropoda Arthropoda 120 3.46e-32   NR XP_031637508.1 265458 g19217 i0 73.2 2.95180722891566 82 22 98.8 0 2 247 8 89 XP_031637508.1 40S ribosomal protein S8 [Contarinia nasturtii] diamond 735 121 0.991735537190083 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
23772879 23772879 PRJNA825466_P_NODE_5479_length_343_cov_1.566667_g5378_i0 PRJNA825466 5479 343 1.566667 5.37366781 Schistocerca gregaria 7010 Arthropoda Arthropoda 175 2.92e-53   NR XP_049847781.1 7010 g5378 i0 77.4 1.00583090379009 115 25 99.7 1 342 1 72 186 XP_049847781.1 rho-related protein racB-like [Schistocerca gregaria] diamond 345 175 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27148826 27148826 PRJNA825466_P_NODE_23242_length_245_cov_2.244186_g23141_i0 PRJNA825466 23242 245 2.244186 5.4982557 Penaeus monodon 6687 Arthropoda Arthropoda 44.7 0.00776   NR XP_037772454.1 6687 g23141 i0 47.7 0.538775510204082 44 23 53.9 0 193 62 76 119 XP_037772454.1 uncharacterized protein LOC119568130 [Penaeus monodon] diamond 132 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
27339055 27339055 PRJNA825466_P_NODE_10163_length_287_cov_1.439252_g10062_i0 PRJNA825466 10163 287 1.439252 4.13065324 Sergentomyia squamirostris 2283857 Arthropoda Arthropoda 72 3.27e-12   NR GAB0099134.1 2283857 g10062 i0 46.7 0.961672473867596 92 49 96.2 0 10 285 459 550 GAB0099134.1 hypothetical protein DMENIID0001_149740 [Sergentomyia squamirostris] diamond 276 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Sergentomyia Sergentomyia squamirostris
27843987 27843987 PRJNA825466_P_NODE_13544_length_266_cov_1.528497_g13443_i0 PRJNA825466 13544 266 1.528497 4.06580202 Cloeon dipterum 197152 Arthropoda Arthropoda 55.1 1.17e-6   NR CAB3387651.1 197152 g13443 i0 51.9 1.17293233082707 52 25 58.6 0 203 48 111 162 CAB3387651.1 Hypothetical predicted protein [Cloeon dipterum] diamond 312 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
27875646 27875646 PRJNA825466_P_NODE_27625_length_242_cov_0.911243_g27524_i0 PRJNA825466 27625 242 0.911243 2.20520806 Chironomus riparius 315576 Arthropoda Arthropoda 47.8 6.45e-4   NR CAG9800001.1 315576 g27524 i0 52.4 2.08264462809917 42 20 52.1 0 241 116 212 253 CAG9800001.1 unnamed protein product [Chironomus riparius] diamond 504 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
28285975 28285975 PRJNA825466_P_NODE_1446_length_573_cov_2.214000_g1349_i0 PRJNA825466 1446 573 2.214 12.68622 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 122 3.2299999999999993e-31   NR ADD38186.1 72036 g1349 i0 36.2 1.91623036649215 185 116 95.8 1 3 551 6 190 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 1098 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
28380884 28380884 PRJNA825466_P_NODE_12506_length_272_cov_1.427136_g12405_i0 PRJNA825466 12506 272 1.427136 3.88180992 Ladona fulva 123851 Arthropoda Arthropoda 53.9 4.82e-6   NR KAG8222287.1 123851 g12405 i0 36.1 1.86397058823529 83 46 87.1 2 2 238 63 142 KAG8222287.1 hypothetical protein J437_LFUL003268 [Ladona fulva] diamond 507 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
29075717 29075717 PRJNA825466_P_NODE_13148_length_268_cov_2.246154_g13047_i0 PRJNA825466 13148 268 2.246154 6.01969272 Condylostylus longicornis 2530218 Arthropoda Arthropoda 56.6 6.7e-7   NR XP_055382601.1 2530218 g13047 i0 52.5 0.66044776119403 59 26 64.9 2 19 192 203 260 XP_055382601.1 protein KRI1 homolog [Condylostylus longicornis] diamond 177 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
29075719 29075719 PRJNA825466_P_NODE_24768_length_244_cov_0.900585_g24667_i0 PRJNA825466 24768 244 0.900585 2.1974274 Periplaneta americana 6978 Arthropoda Arthropoda 62.4 4.67e-9   NR KAJ4436339.1 6978 g24667 i0 43.2 0.995901639344262 81 35 99.6 2 1 243 945 1014 KAJ4436339.1 hypothetical protein ANN_18970 [Periplaneta americana] diamond 243 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
29084312 29084312 PRJNA825466_P_NODE_12168_length_274_cov_1.462687_g12067_i0 PRJNA825466 12168 274 1.462687 4.00776238 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.9 6.63e-19   NR KAG7153915.1 6706 g12067 i0 47.4 6.27372262773723 95 46 99.6 1 1 273 1089 1183 KAG7153915.1 Digestive cysteine proteinase 1-like 2 [Homarus americanus] diamond 1719 91.7 0.991275899672846 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
29138971 29138971 PRJNA825466_P_NODE_9849_length_289_cov_2.074074_g9748_i0 PRJNA825466 9849 289 2.074074 5.99407386 Zophobas morio 2755281 Arthropoda Arthropoda 124 6.15e-32   NR XP_063934469.1 2755281 g9748 i0 61.1 0.986159169550173 95 35 98.6 1 289 5 165 257 XP_063934469.1 uncharacterized protein LOC135146237 [Zophobas morio] diamond 285 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
29328067 29328067 PRJNA825466_P_NODE_15489_length_255_cov_1.516484_g15388_i0 PRJNA825466 15489 255 1.516484 3.8670342 Manduca sexta 7130 Arthropoda Arthropoda 96.3 6.28e-21   NR KAG6447515.1 7130 g15388 i0 48.2 3.90588235294118 83 43 97.6 0 254 6 582 664 KAG6447515.1 hypothetical protein O3G_MSEX005001 [Manduca sexta] diamond 996 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
30852976 30852976 PRJNA825466_P_NODE_28074_length_241_cov_1.833333_g27973_i0 PRJNA825466 28074 241 1.833333 4.41833253 Opisthokonta 33154 Arthropoda Arthropoda 80.9 5.92e-16   NR XP_065215377.1 170843 g27973 i0 52.6 23.9626556016598 78 37 97.1 0 235 2 232 309 XP_065215377.1 large ribosomal subunit protein uL23 [Planococcus citri] diamond 5775 81.3 0.995079950799508 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Planococcus Planococcus citri
31002410 31002410 PRJNA825466_P_NODE_10774_length_283_cov_1.100000_g10673_i0 PRJNA825466 10774 283 1.1 3.113 Oedothorax gibbosus 931172 Arthropoda Arthropoda 52 3.5e-5   NR KAG8182466.1 931172 g10673 i0 32.5 0.879858657243816 83 52 84.8 2 14 253 670 751 KAG8182466.1 hypothetical protein JTE90_020385 [Oedothorax gibbosus] diamond 249 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
31326994 31326994 PRJNA825466_P_NODE_20115_length_248_cov_0.880000_g20014_i0 PRJNA825466 20115 248 0.88 2.1824 Arthropoda 6656 Arthropoda Arthropoda 71.6 2.71e-12   NR KAI2798347.1 40697 g20014 i0 47.2 2.61290322580645 72 38 87.1 0 30 245 1915 1986 KAI2798347.1 hypothetical protein BLOT_015007 [Blomia tropicalis] diamond 648 72 0.994444444444444 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Echimyopodidae Blomia Blomia tropicalis
31539936 31539936 PRJNA825466_P_NODE_15936_length_252_cov_2.681564_g15835_i0 PRJNA825466 15936 252 2.681564 6.75754128 Ornithodoros turicata 34597 Arthropoda Arthropoda 61.2 1.32e-8   NR XP_064488644.1 34597 g15835 i0 46.5 7.14285714285714 71 38 84.5 0 40 252 775 845 XP_064488644.1 importin-9-like [Ornithodoros turicata] diamond 1800 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
31580247 31580247 PRJNA825466_P_NODE_9796_length_290_cov_1.096774_g9695_i0 PRJNA825466 9796 290 1.096774 3.1806446 Hymenoptera 7399 Arthropoda Arthropoda 156 1.7399999999999999e-43   NR XP_024867577.1 300111 g9695 i0 70.8 24.7448275862069 96 28 99.3 0 290 3 229 324 XP_024867577.1 LOW QUALITY PROTEIN: ubiquitin-conjugating enzyme E2 J1-like [Temnothorax curvispinosus] diamond 7176 157 0.993630573248408 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Temnothorax Temnothorax curvispinosus
31697951 31697951 PRJNA825466_P_NODE_29717_length_228_cov_2.451613_g29616_i0 PRJNA825466 29717 228 2.451613 5.58967764 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 110 1.88e-28   NR ACO13139.1 72036 g29616 i0 72 3.93421052631579 75 21 98.7 0 226 2 68 142 ACO13139.1 60S ribosomal protein L17 [Lepeophtheirus salmonis] diamond 897 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
32086240 32086240 PRJNA825466_P_NODE_27738_length_242_cov_0.911243_g27637_i0 PRJNA825466 27738 242 0.911243 2.20520806 Trombidiformes 83136 Arthropoda Arthropoda 130 4.04e-35   NR RWS31909.1 299467 g27637 i0 73.8 1.98347107438017 80 21 99.2 0 240 1 39 118 RWS31909.1 splicing factor U2af 38 kDa subunit-like protein [Leptotrombidium deliense] diamond 480 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
32362609 32362609 PRJNA825466_S_NODE_1579_length_248_cov_0.880000_g1573_i0 PRJNA825466 1579 248 0.88 2.1824 Artemia franciscana 6661 Arthropoda Arthropoda 47.4 8.83e-4   NR KAK2723369.1 6661 g1573 i0 30.9 0.979838709677419 81 56 98 0 247 5 96 176 KAK2723369.1 hypothetical protein QYM36_001885 [Artemia franciscana] diamond 243 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32489135 32489135 PRJNA825466_P_NODE_3799_length_388_cov_0.974603_g3698_i0 PRJNA825466 3799 388 0.974603 3.78145964 Allacma fusca 39272 Arthropoda Arthropoda 164 7.55e-45   NR CAG7726709.1 39272 g3698 i0 69.7 4.36855670103093 119 36 92 0 30 386 2 120 CAG7726709.1 unnamed protein product [Allacma fusca] diamond 1695 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
32592481 32592481 PRJNA825466_P_NODE_18539_length_249_cov_1.465909_g18438_i0 PRJNA825466 18539 249 1.465909 3.65011341 Coleoptera 7041 Arthropoda Arthropoda 106 2.04e-25   NR XP_045462066.1 115357 g18438 i0 54.9 6.91566265060241 82 37 98.8 0 2 247 244 325 XP_045462066.1 m7GpppX diphosphatase [Harmonia axyridis] diamond 1722 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
32772555 32772555 PRJNA825466_P_NODE_11420_length_278_cov_1.873171_g11319_i0 PRJNA825466 11420 278 1.873171 5.20741538 Anopheles funestus 62324 Arthropoda Arthropoda 46.6 0.0025   NR DAA79946.1 62324 g11319 i0 45.5 0.474820143884892 44 24 47.5 0 5 136 584 627 DAA79946.1 TPA_inf: signal transducer and activator of transcription B [Anopheles funestus] diamond 132 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles funestus
32844194 32844194 PRJNA825466_P_NODE_5800_length_337_cov_1.742424_g5699_i0 PRJNA825466 5800 337 1.742424 5.87196888 Insecta 50557 Arthropoda Arthropoda 122 3.0099999999999997e-31   NR KAF6207366.1 248454 g5699 i0 71.8 13.593471810089 85 24 75.7 0 335 81 119 203 KAF6207366.1 hypothetical protein GE061_018607 [Apolygus lucorum] diamond 4581 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum

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