RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where analysis = "diamond", bioproject = "PRJNA692200" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 36 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA692200 · 36 ✖

analysis 1

  • diamond · 36 ✖
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
8325675 8325675 PRJNA692200_S_NODE_12207_length_205_cov_1.198718_g12150_i0 PRJNA692200 12207 205 1.198718 2.4573719 Oppiella nova 334625 Arthropoda Arthropoda 103 1.26e-26   NR CAD7637226.1 334625 g12150 i0 93 0.834146341463415 57 4 83.4 0 3 173 69 125 CAD7637226.1 unnamed protein product [Oppiella nova] diamond 171 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
14701959 14701959 PRJNA692200_S_NODE_712_length_473_cov_10.514151_g674_i0 PRJNA692200 712 473 10.514151 49.73193423 root 1 Root_unresolved Root_unresolved 96.3 2.64e-21   NR KAG5679050.1 319348 g674 i0 71.7 3.4122621564482 60 17 38.1 0 472 293 157 216 KAG5679050.1 hypothetical protein PVAND_008647 [Polypedilum vanderplanki] diamond 1614 96.7 0.995863495346432 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
15975633 15975633 PRJNA692200_S_NODE_473_length_510_cov_19.247289_g440_i0 PRJNA692200 473 510 19.247289 98.1611739 Nymphon striatum 424472 Arthropoda Arthropoda 128 5.34e-32   NR KAG1695766.1 424472 g440 i0 72.3 5.54117647058824 83 23 48.8 0 508 260 298 380 KAG1695766.1 60S ribosomal protein L3 [Nymphon striatum] diamond 2826 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
18524842 18524842 PRJNA692200_S_NODE_3755_length_317_cov_24.600746_g3698_i0 PRJNA692200 3755 317 24.600746 77.98436482 Arthropoda 6656 Arthropoda Arthropoda 132 4.7399999999999994e-37   NR XP_065346663.1 197152 g3698 i0 75.6 27.0567823343849 82 20 77.6 0 12 257 68 149 XP_065346663.1 nucleoside diphosphate kinase-like [Cloeon dipterum] diamond 8577 133 0.992481203007519 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
22349892 22349892 PRJNA692200_S_NODE_11658_length_209_cov_2.862500_g11601_i0 PRJNA692200 11658 209 2.8625 5.982625 Zophobas morio 2755281 Arthropoda Arthropoda 108 7.73e-28   NR XP_063932177.1 2755281 g11601 i0 79.1 0.961722488038278 67 14 96.2 0 1 201 87 153 XP_063932177.1 uncharacterized protein LOC135144110 [Zophobas morio] diamond 201 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
22349939 22349939 PRJNA692200_S_NODE_1358_length_415_cov_938.704918_g1307_i0 PRJNA692200 1358 415 938.704918 3895.6254097 Idotea baltica 82763 Arthropoda Arthropoda 97.1 2.83e-23   NR MCL4170146.1 82763 g1307 i0 52.7 0.657831325301205 91 43 65.8 0 412 140 1 91 MCL4170146.1 hypothetical protein [Idotea baltica] diamond 273 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
23625746 23625746 PRJNA692200_S_NODE_9119_length_232_cov_5.273224_g9062_i0 PRJNA692200 9119 232 5.273224 12.23387968 root 1 Root_unresolved Root_unresolved 124 6.53e-31   NR CAG4636794.1 302197 g9062 i0 93.9 3.49137931034483 66 4 85.3 0 1 198 923 988 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 810 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
26670769 26670769 PRJNA692200_S_NODE_21201_length_164_cov_0.904348_g21144_i0 PRJNA692200 21201 164 0.904348 1.48313072 Ceutorhynchus assimilis 467358 Arthropoda Arthropoda 41.2 0.0455   NR CAG9773046.1 467358 g21144 i0 34.6 0.951219512195122 52 34 95.1 0 7 162 626 677 CAG9773046.1 unnamed protein product [Ceutorhynchus assimilis] diamond 156 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus assimilis
26777588 26777588 PRJNA692200_S_NODE_1161_length_428_cov_23.464380_g1113_i0 PRJNA692200 1161 428 23.46438 100.4275464 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 57.8 4.37e-8   NR MCL4117871.1 82763 g1113 i0 47.1 4.03738317757009 70 37 49.1 0 414 205 1 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 1728 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26955874 26955874 PRJNA692200_S_NODE_19982_length_167_cov_1.042373_g19925_i0 PRJNA692200 19982 167 1.042373 1.74076291 Rhagoletis zephyria 28612 Arthropoda Arthropoda 43.5 0.00723   NR XP_017474557.1 28612 g19925 i0 37.3 3.17964071856287 59 31 95.2 1 163 5 893 951 XP_017474557.1 PREDICTED: vacuolar protein sorting-associated protein 11 homolog [Rhagoletis zephyria] diamond 531 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
27093846 27093846 PRJNA692200_S_NODE_14322_length_191_cov_4.197183_g14265_i0 PRJNA692200 14322 191 4.197183 8.01661953 Amphipoda 6821 Arthropoda Arthropoda 57 1.27e-7   NR XP_018026009.1 294128 g14265 i0 74.4 2.52879581151832 39 10 61.3 0 2 118 222 260 XP_018026009.1 40S ribosomal protein S4 [Hyalella azteca] diamond 483 57.4 0.993031358885017 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
27493428 27493428 PRJNA692200_S_NODE_6103_length_269_cov_10.577273_g6046_i0 PRJNA692200 6103 269 10.577273 28.45286437 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 78.2 1.72e-14   NR KAG5673705.1 319348 g6046 i0 43 12.4795539033457 86 45 91.4 2 267 22 496 581 KAG5673705.1 putative protein phosphatase 2C 61 [Polypedilum vanderplanki] diamond 3357 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
28578252 28578252 PRJNA692200_S_NODE_21387_length_163_cov_2.429825_g21330_i0 PRJNA692200 21387 163 2.429825 3.96061475 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.9 7.98e-18   NR TRY75082.1 6832 g21330 i0 77.4 3.92024539877301 53 12 97.5 0 162 4 688 740 TRY75082.1 hypothetical protein TCAL_10807, partial [Tigriopus californicus] diamond 639 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
28661725 28661725 PRJNA692200_S_NODE_22127_length_162_cov_0.893805_g22070_i0 PRJNA692200 22127 162 0.893805 1.4479641 Liposcelis entomophila 550478 Arthropoda Arthropoda 53.1 2.6e-6   NR QWV54006.1 550478 g22070 i0 84 0.462962962962963 25 4 46.3 0 158 84 1908 1932 QWV54006.1 vitellogenin [Liposcelis entomophila] diamond 75 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis entomophila
28693379 28693379 PRJNA692200_S_NODE_2507_length_358_cov_3.378641_g2450_i0 PRJNA692200 2507 358 3.378641 12.09553478 Stegodyphus dumicola 202533 Arthropoda Arthropoda 61.2 4.75e-8   NR XP_035212509.1 202533 g2450 i0 50 0.50279329608938494 60 26 50.3 2 334 155 587 642 XP_035212509.1 ADAMTS-like protein 1 [Stegodyphus dumicola] diamond 180 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
28756288 28756288 PRJNA692200_S_NODE_7627_length_248_cov_5.723618_g7570_i0 PRJNA692200 7627 248 5.723618 14.19457264 Idotea baltica 82763 Arthropoda Arthropoda 124 1.22e-33   NR MCL4121308.1 82763 g7570 i0 67.1 2.89112903225806 82 27 99.2 0 3 248 44 125 MCL4121308.1 hypothetical protein [Idotea baltica] diamond 717 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29083484 29083484 PRJNA692200_S_NODE_1168_length_428_cov_4.664908_g1120_i0 PRJNA692200 1168 428 4.664908 19.96580624 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 65.9 2.37e-9   NR TGZ54275.1 300112 g1120 i0 52.8 13.6051401869159 53 25 37.1 0 3 161 698 750 TGZ54275.1 hypothetical protein DBV15_06248 [Temnothorax longispinosus] diamond 5823 65.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Temnothorax Temnothorax longispinosus
29304354 29304354 PRJNA692200_S_NODE_9869_length_225_cov_1.687500_g9812_i0 PRJNA692200 9869 225 1.6875 3.796875 Ixodidae 6939 Arthropoda Arthropoda 63.9 9.93e-10   NR KAK8768679.1 6943 g9812 i0 48.5 6.25333333333333 68 23 76 2 12 182 1024 1090 KAK8768679.1 hypothetical protein V5799_014858 [Amblyomma americanum] diamond 1407 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma americanum
29336020 29336020 PRJNA692200_S_NODE_11989_length_206_cov_4.942675_g11932_i0 PRJNA692200 11989 206 4.942675 10.1819105 Arthropoda 6656 Arthropoda Arthropoda 58.9 4.36e-8   NR KAK4020280.1 35525 g11932 i0 69.4 3.11650485436893 36 11 52.4 0 2 109 383 418 KAK4020280.1 hypothetical protein OUZ56_002272 [Daphnia magna] diamond 642 59.3 0.993254637436762 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
29367644 29367644 PRJNA692200_S_NODE_3149_length_335_cov_2.269231_g3092_i0 PRJNA692200 3149 335 2.269231 7.60192385 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 94 1.16e-19   NR XP_011200219.2 27457 g3092 i0 58.1 9.04477611940299 74 30 65.4 1 335 117 600 673 XP_011200219.2 glycine--tRNA ligase isoform X2 [Bactrocera dorsalis] diamond 3030 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
29798136 29798136 PRJNA692200_S_NODE_8991_length_233_cov_9.266304_g8934_i0 PRJNA692200 8991 233 9.266304 21.59048832 Allacma fusca 39272 Arthropoda Arthropoda 47.4 7.49e-4   NR CAG7729580.1 39272 g8934 i0 63 0.695278969957081 27 10 34.8 0 2 82 121 147 CAG7729580.1 unnamed protein product [Allacma fusca] diamond 162 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
29872807 29872807 PRJNA692200_S_NODE_6151_length_269_cov_1.400000_g6094_i0 PRJNA692200 6151 269 1.4 3.766 Opisthokonta 33154 Arthropoda Arthropoda 44.7 0.00828   NR CAB3363448.1 197152 g6094 i0 39 3.45724907063197 82 48 91.4 1 12 257 134 213 CAB3363448.1 Hypothetical predicted protein [Cloeon dipterum] diamond 930 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
29904462 29904462 PRJNA692200_S_NODE_14711_length_189_cov_2.514286_g14654_i0 PRJNA692200 14711 189 2.514286 4.75200054 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 78.2 4.82e-16   NR MCL4120794.1 82763 g14654 i0 62.7 3.84126984126984 59 22 93.7 0 187 11 57 115 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 726 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29924725 29924725 PRJNA692200_S_NODE_10891_length_215_cov_4.234940_g10834_i0 PRJNA692200 10891 215 4.23494 9.105121 Polistes canadensis 91411 Arthropoda Arthropoda 45.4 0.0029   NR XP_014600392.1 91411 g10834 i0 38 0.697674418604651 50 31 69.8 0 2 151 630 679 XP_014600392.1 PREDICTED: peroxisomal acyl-coenzyme A oxidase 3-like [Polistes canadensis] diamond 150 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes canadensis
29999271 29999271 PRJNA692200_S_NODE_17811_length_174_cov_2.392000_g17754_i0 PRJNA692200 17811 174 2.392 4.16208 Hymenoptera 7399 Arthropoda Arthropoda 58.5 3.29e-8   NR XP_011685213.1 64793 g17754 i0 78.8 11.9137931034483 33 7 56.9 0 2 100 267 299 XP_011685213.1 PREDICTED: xaa-Pro dipeptidase [Wasmannia auropunctata] diamond 2073 58.9 0.99320882852292 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Wasmannia Wasmannia auropunctata
30567511 30567511 PRJNA692200_S_NODE_6153_length_269_cov_1.331818_g6096_i0 PRJNA692200 6153 269 1.331818 3.58259042 Culicidae 7157 Arthropoda Arthropoda 63.2 2.07e-9   NR XP_035780979.1 7167 g6096 i0 59.6 2.62081784386617 47 19 52.4 0 3 143 228 274 XP_035780979.1 60S ribosomal protein L7-like [Anopheles albimanus] diamond 705 63.5 0.995275590551181 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
30809271 30809271 PRJNA692200_S_NODE_16534_length_180_cov_2.709924_g16477_i0 PRJNA692200 16534 180 2.709924 4.8778632 Leptopilina heterotoma 63436 Arthropoda Arthropoda 57.4 1.05e-7   NR XP_043469398.1 63436 g16477 i0 54.8 0.7 42 19 70 0 1 126 297 338 XP_043469398.1 fructose-1,6-bisphosphatase 1 [Leptopilina heterotoma] diamond 126 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Leptopilina Leptopilina heterotoma
31136231 31136231 PRJNA692200_S_NODE_3235_length_332_cov_18.098940_g3178_i0 PRJNA692200 3235 332 18.09894 60.0884808 Diptera 7147 Arthropoda Arthropoda 72 2.45e-13   NR XP_055701935.1 29031 g3178 i0 48.6 5.15060240963855 72 35 65.1 2 316 101 66 135 XP_055701935.1 40S ribosomal protein S12 [Phlebotomus papatasi] diamond 1710 72.4 0.994475138121547 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
31294565 31294565 PRJNA692200_S_NODE_4675_length_295_cov_5.170732_g4618_i0 PRJNA692200 4675 295 5.170732 15.2536594 Metazoa 33208 Arthropoda Arthropoda 141 1.6e-38   NR KAB7494322.1 96803 g4618 i0 77.8 4.90169491525424 81 18 82.4 0 294 52 252 332 KAB7494322.1 Cathepsin B [Armadillidium nasatum] diamond 1446 142 0.992957746478873 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium nasatum
31579416 31579416 PRJNA692200_S_NODE_7496_length_250_cov_3.238806_g7439_i0 PRJNA692200 7496 250 3.238806 8.097015 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52 1.95e-5   NR XP_053993160.1 313075 g7439 i0 58.3 8.124 36 15 43.2 0 7 114 243 278 XP_053993160.1 uncharacterized protein LOC128884106 [Hylaeus volcanicus] diamond 2031 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Colletidae Hylaeus Hylaeus volcanicus
31662673 31662673 PRJNA692200_S_NODE_2597_length_355_cov_10.950980_g2540_i0 PRJNA692200 2597 355 10.95098 38.875979 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 72.8 5.07e-13   NR ADD38186.1 72036 g2540 i0 43 0.726760563380282 86 49 72.7 0 351 94 102 187 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 258 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31694407 31694407 PRJNA692200_S_NODE_4217_length_306_cov_3.961089_g4160_i0 PRJNA692200 4217 306 3.961089 12.12093234 Cherax cainii 223846 Arthropoda Arthropoda 57.4 5.75e-7   NR AKB96205.1 223846 g4160 i0 65.3 5.46078431372549 49 12 43.1 2 1 132 693 741 AKB96205.1 heat shock protein [Cherax cainii] diamond 1671 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax cainii
32074128 32074128 PRJNA692200_S_NODE_4458_length_300_cov_9.183267_g4401_i0 PRJNA692200 4458 300 9.183267 27.549801 Condylostylus longicornis 2530218 Arthropoda Arthropoda 46.2 9.29e-4   NR XP_055388520.1 2530218 g4401 i0 36.8 0.57 57 35 57 1 62 232 47 102 XP_055388520.1 dynein light chain 1, cytoplasmic-like [Condylostylus longicornis] diamond 171 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
32275479 32275479 PRJNA692200_S_NODE_22378_length_160_cov_6.486486_g22321_i0 PRJNA692200 22378 160 6.486486 10.3783776 Formicidae 36668 Arthropoda Arthropoda 66.6 4.29e-11   NR KMQ93032.1 67767 g22321 i0 97 6.35625 33 1 61.9 0 158 60 406 438 KMQ93032.1 glutaryl- mitochondrial [Lasius niger] diamond 1017 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
32465284 32465284 PRJNA692200_S_NODE_12839_length_201_cov_0.980263_g12782_i0 PRJNA692200 12839 201 0.980263 1.97032863 Ixodidae 6939 Arthropoda Arthropoda 50.8 2.87e-5   NR KAH8042081.1 6941 g12782 i0 64.7 3.22388059701493 34 12 50.7 0 200 99 323 356 KAH8042081.1 hypothetical protein HPB51_021165 [Rhipicephalus microplus] diamond 648 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
32843341 32843341 PRJNA692200_S_NODE_2300_length_366_cov_15.662461_g2243_i0 PRJNA692200 2300 366 15.662461 57.32460726 Arthropoda 6656 Arthropoda Arthropoda 114 8.46e-28   NR CAD7228280.1 163714 g2243 i0 58.6 2.4672131147541 99 38 79.5 2 363 73 208 305 CAD7228280.1 unnamed protein product [Cyprideis torosa] diamond 903 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa

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