RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1129273 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
2833902 2833902 PRJNA1129273_P_NODE_1063_length_836_cov_8.648755_g834_i0 PRJNA1129273 1063 836 8.648755 72.3035918 Diaphorina citri 121845 Arthropoda Arthropoda 264 1.51e-84   NR KAI5700884.1 121845 g834 i0 50 5.6555023923445 264 123 94.4 3 13 801 1 256 KAI5700884.1 hypothetical protein M8J75_003817 [Diaphorina citri] diamond 4728 264 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
2833923 2833923 PRJNA1129273_P_NODE_4343_length_345_cov_1.036765_g4063_i0 PRJNA1129273 4343 345 1.036765 3.57683925 Araneae 6893 Arthropoda Arthropoda 148 2.7499999999999993e-43   NR GBO40734.1 182803 g4063 i0 71.1 4.23478260869565 97 28 84.3 0 292 2 1 97 GBO40734.1 60S ribosomal protein L17, partial [Araneus ventricosus] diamond 1461 149 0.993288590604027 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
2833925 2833925 PRJNA1129273_P_NODE_4923_length_321_cov_2.487903_g4643_i0 PRJNA1129273 4923 321 2.487903 7.98616863 Arthropoda 6656 Arthropoda Arthropoda 88.6 6.31e-20   NR KAH9399477.1 59818 g4643 i0 46.5 5.58878504672897 99 49 88.8 2 36 320 12 110 KAH9399477.1 60S ribosomal protein L22 [Tyrophagus putrescentiae] diamond 1794 89 0.995505617977528 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
2833933 2833933 PRJNA1129273_P_NODE_5683_length_296_cov_1.721973_g5403_i0 PRJNA1129273 5683 296 1.721973 5.09704008 root 1 Root_unresolved Root_unresolved 142 2.91e-41   NR AIS93480.1 320202 g5403 i0 71.4 21.9425675675676 98 27 99.3 1 2 295 28 124 AIS93480.1 isocitrate dehydrogenase, partial [Mylothris agathina] diamond 6495 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Mylothris Mylothris agathina
6661129 6661129 PRJNA1129273_P_NODE_5906_length_290_cov_1.423963_g5626_i0 PRJNA1129273 5906 290 1.423963 4.1294927 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 159 1.3599999999999999e-46   NR XP_027200335.1 6956 g5626 i0 84.1 0.910344827586207 88 14 91 0 264 1 44 131 XP_027200335.1 peroxiredoxin 1-like [Dermatophagoides pteronyssinus] diamond 264 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
6661149 6661149 PRJNA1129273_P_NODE_7946_length_259_cov_1.677419_g7666_i0 PRJNA1129273 7946 259 1.677419 4.34451521 Condylostylus longicornis 2530218 Arthropoda Arthropoda 131 1.47e-33   NR XP_055388577.1 2530218 g7666 i0 72.1 3.98455598455598 86 24 99.6 0 2 259 12 97 XP_055388577.1 LOW QUALITY PROTEIN: T-complex protein 1 subunit eta-like [Condylostylus longicornis] diamond 1032 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
7936265 7936265 PRJNA1129273_P_NODE_1467_length_685_cov_4.642157_g1205_i0 PRJNA1129273 1467 685 4.642157 31.79877545 Arthropoda 6656 Arthropoda Arthropoda 269 7.629999999999999e-87   NR GLH16729.1 6999 g1205 i0 60.3 41.3474452554745 224 84 97.2 2 668 3 7 227 GLH16729.1 ADP,ATP carrier protein 1 [Gryllus bimaculatus] diamond 28323 271 0.992619926199262 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
10486741 10486741 PRJNA1129273_P_NODE_10449_length_242_cov_2.420118_g10169_i0 PRJNA1129273 10449 242 2.420118 5.85668556 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 67 1.04e-10   NR XP_054267049.1 74068 g10169 i0 55.8 1.28925619834711 52 23 64.5 0 17 172 713 764 XP_054267049.1 uncharacterized protein LOC128989202 [Macrosteles quadrilineatus] diamond 312 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
13036988 13036988 PRJNA1129273_P_NODE_7591_length_264_cov_1.617801_g7311_i0 PRJNA1129273 7591 264 1.617801 4.27099464 Vespidae 7438 Arthropoda Arthropoda 126 7.699999999999998e-35   NR KAF7384718.1 30212 g7311 i0 87.7 4.97727272727273 73 8 83 1 219 1 1 72 KAF7384718.1 hypothetical protein HZH68_014330 [Vespula germanica] diamond 1314 127 0.992125984251969 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula germanica
13036994 13036994 PRJNA1129273_P_NODE_8251_length_255_cov_1.703297_g7971_i0 PRJNA1129273 8251 255 1.703297 4.34340735 Tenebrio molitor 7067 Arthropoda Arthropoda 106 2.44e-25   NR KAH0817872.1 7067 g7971 i0 58.3 16.7647058823529 84 35 98.8 0 253 2 237 320 KAH0817872.1 hypothetical protein GEV33_004919 [Tenebrio molitor] diamond 4275 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
14312194 14312194 PRJNA1129273_P_NODE_4032_length_358_cov_4.771930_g3752_i0 PRJNA1129273 4032 358 4.77193 17.0835094 Cloeon dipterum 197152 Arthropoda Arthropoda 132 6e-36   NR CAB3363448.1 197152 g3752 i0 73.2 4.79329608938547 97 26 81.3 0 358 68 99 195 CAB3363448.1 Hypothetical predicted protein [Cloeon dipterum] diamond 1716 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
18883222 18883222 PRJNA1129273_P_NODE_2595_length_474_cov_3.531172_g2319_i0 PRJNA1129273 2595 474 3.531172 16.73775528 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 223 5.68e-72   NR XP_043240214.1 1232801 g2319 i0 73.1 8.2848101265822809 145 39 91.8 0 438 4 1 145 XP_043240214.1 60S ribosomal protein L12-like [Amphibalanus amphitrite] diamond 3927 223 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
27038677 27038677 PRJNA1129273_P_NODE_10402_length_243_cov_0.900000_g10122_i0 PRJNA1129273 10402 243 0.9 2.187 Bactrocera neohumeralis 98809 Arthropoda Arthropoda 48.5 3.34e-4   NR XP_050340390.1 98809 g10122 i0 41.5 0.802469135802469 65 33 76.5 2 17 202 486 548 XP_050340390.1 uncharacterized protein LOC126766701 [Bactrocera neohumeralis] diamond 195 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera neohumeralis
27260050 27260050 PRJNA1129273_P_NODE_9943_length_245_cov_0.889535_g9663_i0 PRJNA1129273 9943 245 0.889535 2.17936075 Trypoxylus dichotomus 273928 Arthropoda Arthropoda 64.7 7.06e-10   NR GJQ76743.1 273928 g9663 i0 40.4 4.44489795918367 89 40 93.1 2 14 241 939 1027 GJQ76743.1 hypothetical protein Trydic_g15586 [Trypoxylus dichotomus] diamond 1089 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Trypoxylus Trypoxylus dichotomus
27848936 27848936 PRJNA1129273_P_NODE_6484_length_280_cov_2.980676_g6204_i0 PRJNA1129273 6484 280 2.980676 8.3458928 Metazoa 33208 Arthropoda Arthropoda 109 4.14e-26   NR XP_038208238.1 33412 g6204 i0 58.4 9.27857142857143 89 36 95.4 1 8 274 50 137 XP_038208238.1 cystathionine gamma-lyase [Zerene cesonia] diamond 2598 110 0.990909090909091 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Zerene Zerene cesonia
27986316 27986316 PRJNA1129273_P_NODE_1805_length_602_cov_2.500945_g1536_i0 PRJNA1129273 1805 602 2.500945 15.0556889 Bemisia tabaci 7038 Arthropoda Arthropoda 214 1.05e-66   NR XP_018909113.1 7038 g1536 i0 58.9 3.69767441860465 185 75 91.7 1 557 6 3 187 XP_018909113.1 PREDICTED: 60S ribosomal protein L13 [Bemisia tabaci] diamond 2226 214 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
29017707 29017707 PRJNA1129273_P_NODE_10268_length_243_cov_1.358824_g9988_i0 PRJNA1129273 10268 243 1.358824 3.30194232 Ixodidae 6939 Arthropoda Arthropoda 137 7.67e-40   NR KAL3211724.1 6941 g9988 i0 82.5 8.88888888888889 80 14 98.8 0 2 241 13 92 KAL3211724.1 hypothetical protein MRX96_008424 [Rhipicephalus microplus] diamond 2160 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29249147 29249147 PRJNA1129273_P_NODE_9529_length_247_cov_0.885057_g9249_i0 PRJNA1129273 9529 247 0.885057 2.18609079 Trichonephila clavipes 2585209 Arthropoda Arthropoda 43.9 0.0106   NR GFX38633.1 2585209 g9249 i0 47.2 0.437246963562753 36 19 43.7 0 3 110 93 128 GFX38633.1 hypothetical protein TNCV_3476231 [Trichonephila clavipes] diamond 108 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29333120 29333120 PRJNA1129273_P_NODE_7309_length_268_cov_1.179487_g7029_i0 PRJNA1129273 7309 268 1.179487 3.16102516 Opisthokonta 33154 Arthropoda Arthropoda 146 5.6099999999999986e-43   NR KAH8020767.1 6941 g7029 i0 74.2 43.8246268656716 89 23 99.6 0 268 2 13 101 KAH8020767.1 hypothetical protein HPB51_003424 [Rhipicephalus microplus] diamond 11745 147 0.993197278911565 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29690965 29690965 PRJNA1129273_P_NODE_10170_length_244_cov_0.894737_g9890_i0 PRJNA1129273 10170 244 0.894737 2.18315828 Cinara cedri 506608 Arthropoda Arthropoda 89 2.07e-18   NR VVC41553.1 506608 g9890 i0 78.8 0.811475409836066 66 10 81.1 2 47 244 51 112 VVC41553.1 Chitin binding domain [Cinara cedri] diamond 198 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
30101784 30101784 PRJNA1129273_P_NODE_10512_length_242_cov_1.307692_g10232_i0 PRJNA1129273 10512 242 1.307692 3.16461464 Holotrichia oblita 644536 Arthropoda Arthropoda 149 7.68e-44   NR KAI4456566.1 644536 g10232 i0 98.6 0.892561983471074 72 1 89.3 0 216 1 1 72 KAI4456566.1 transposable element-related [Holotrichia oblita] diamond 216 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
30133163 30133163 PRJNA1129273_P_NODE_9672_length_246_cov_0.895954_g9392_i0 PRJNA1129273 9672 246 0.895954 2.20404684 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 58.2 7.63e-8   NR KAF2368018.1 1923959 g9392 i0 37.5 1.92682926829268 80 50 97.6 0 241 2 118 197 KAF2368018.1 Autophagy protein Atg8 ubiquitin-like [Trinorchestia longiramus] diamond 474 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
30375799 30375799 PRJNA1129273_P_NODE_8432_length_253_cov_0.805556_g8152_i0 PRJNA1129273 8432 253 0.805556 2.03805668 Malacostraca 6681 Arthropoda Arthropoda 43.1 0.0295   NR CAL4145337.1 48144 g8152 i0 36.7 2.84584980237154 60 30 64 2 242 81 327 384 CAL4145337.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 720 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
30512623 30512623 PRJNA1129273_P_NODE_5413_length_304_cov_1.320346_g5133_i0 PRJNA1129273 5413 304 1.320346 4.01385184 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 78.2 2.75e-14   NR CAL4166186.1 48144 g5133 i0 43.9 2.39802631578947 82 41 80.9 1 7 252 15 91 CAL4166186.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 729 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
30575598 30575598 PRJNA1129273_P_NODE_8693_length_251_cov_0.870787_g8413_i0 PRJNA1129273 8693 251 0.870787 2.18567537 Photinus pyralis 7054 Arthropoda Arthropoda 148 3.24e-42   NR KAB0801683.1 7054 g8413 i0 80.7 1.9840637450199201 83 16 99.2 0 250 2 82 164 KAB0801683.1 hypothetical protein PPYR_03869 [Photinus pyralis] diamond 498 148 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
31112779 31112779 PRJNA1129273_P_NODE_3675_length_381_cov_1.441558_g3395_i0 PRJNA1129273 3675 381 1.441558 5.49233598 Caligus rogercresseyi 217165 Arthropoda Arthropoda 57.4 1.23e-6   NR ACO11570.1 217165 g3395 i0 32.6 2.05511811023622 132 82 99.2 4 380 3 93 223 ACO11570.1 Xaa-Pro dipeptidase [Caligus rogercresseyi] diamond 783 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
31239273 31239273 PRJNA1129273_P_NODE_9115_length_249_cov_0.875000_g8835_i0 PRJNA1129273 9115 249 0.875 2.17875 Rhamnusium bicolor 1586634 Arthropoda Arthropoda 51.6 1.94e-5   NR KAJ8941421.1 1586634 g8835 i0 78.6 0.674698795180723 28 6 33.7 0 84 1 180 207 KAJ8941421.1 hypothetical protein NQ314_010395 [Rhamnusium bicolor] diamond 168 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Rhamnusium Rhamnusium bicolor
31429111 31429111 PRJNA1129273_P_NODE_1796_length_603_cov_9.333962_g1527_i0 PRJNA1129273 1796 603 9.333962 56.28379086 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 125 2.8199999999999996e-32   NR ADD38186.1 72036 g1527 i0 34.4 2.8955223880597 192 121 95.5 1 602 27 1 187 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 1746 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31461031 31461031 PRJNA1129273_P_NODE_2776_length_455_cov_1.492147_g2498_i0 PRJNA1129273 2776 455 1.492147 6.78926885 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 102 5.48e-24   NR ADD38186.1 72036 g2498 i0 38 0.989010989010989 150 88 98.9 1 451 2 8 152 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 450 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31576497 31576497 PRJNA1129273_P_NODE_10116_length_244_cov_0.906433_g9836_i0 PRJNA1129273 10116 244 0.906433 2.21169652 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.1 8.439999999999999e-23   NR XP_049849933.1 7010 g9836 i0 51.9 2.91393442622951 79 38 97.1 0 238 2 67 145 XP_049849933.1 uncharacterized protein LOC126320475 [Schistocerca gregaria] diamond 711 95.9 0.991657977059437 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31829234 31829234 PRJNA1129273_P_NODE_6037_length_288_cov_1.423256_g5757_i0 PRJNA1129273 6037 288 1.423256 4.09897728 Centruroides 6875 Arthropoda Arthropoda 136 5.25e-37   NR XP_067142813.1 120091 g5757 i0 56.1 2.75 132 21 99 1 4 288 66 197 XP_067142813.1 tigger transposable element-derived protein 4-like [Centruroides vittatus] diamond 792 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
32251986 32251986 PRJNA1129273_P_NODE_10638_length_242_cov_0.905325_g10358_i0 PRJNA1129273 10638 242 0.905325 2.1908865 Ranatra chinensis 642074 Arthropoda Arthropoda 47.8 6.17e-4   NR KAL1137597.1 642074 g10358 i0 40.7 1.67355371900826 59 32 69.4 1 45 212 75 133 KAL1137597.1 hypothetical protein AAG570_009293 [Ranatra chinensis] diamond 405 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Nepidae Ranatra Ranatra chinensis

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