RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA986547 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
4801991 4801991 PRJNA986547_P_NODE_12184_length_241_cov_0.916667_g12102_i0 PRJNA986547 12184 241 0.916667 2.20916747 Arthropoda 6656 Arthropoda Arthropoda 89.7 1.03e-18   NR XP_055902943.1 290404 g12102 i0 53.2 5.52697095435685 77 36 95.9 0 239 9 185 261 XP_055902943.1 probable phospholipid-transporting ATPase IIA isoform X2 [Eupeodes corollae] diamond 1332 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
8627070 8627070 PRJNA986547_P_NODE_10007_length_247_cov_0.885057_g9925_i0 PRJNA986547 10007 247 0.885057 2.18609079 Malaya genurostris 325434 Arthropoda Arthropoda 155 9.52e-43   NR XP_058467016.1 325434 g9925 i0 90.1 9.8502024291498 81 8 98.4 0 246 4 319 399 XP_058467016.1 inositol-3-phosphate synthase [Malaya genurostris] diamond 2433 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Malaya Malaya genurostris
21376329 21376329 PRJNA986547_P_NODE_2197_length_325_cov_3.531746_g2115_i0 PRJNA986547 2197 325 3.531746 11.4781745 Zophobas morio 2755281 Arthropoda Arthropoda 143 6.07e-41   NR XP_063932177.1 2755281 g2115 i0 77.8 14.6492307692308 90 20 83.1 0 320 51 97 186 XP_063932177.1 uncharacterized protein LOC135144110 [Zophobas morio] diamond 4761 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
26868440 26868440 PRJNA986547_P_NODE_12281_length_240_cov_3.347305_g12199_i0 PRJNA986547 12281 240 3.347305 8.033532 Orchesella dallaii 48710 Arthropoda Arthropoda 62 7.27e-10   NR CAL8072803.1 48710 g12199 i0 53.7 0.675 54 25 67.5 0 6 167 94 147 CAL8072803.1 unnamed protein product [Orchesella dallaii] diamond 162 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
26899971 26899971 PRJNA986547_P_NODE_4441_length_285_cov_4.009434_g4359_i0 PRJNA986547 4441 285 4.009434 11.4268869 Schistocerca gregaria 7010 Arthropoda Arthropoda 77 5.4e-14   NR XP_049852190.1 7010 g4359 i0 42.6 1.97894736842105 94 53 98.9 1 1 282 340 432 XP_049852190.1 FYVE, RhoGEF and PH domain-containing protein 6-like isoform X2 [Schistocerca gregaria] diamond 564 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27058058 27058058 PRJNA986547_P_NODE_10902_length_244_cov_1.660819_g10820_i0 PRJNA986547 10902 244 1.660819 4.05239836 Zaprionus bogoriensis 309927 Arthropoda Arthropoda 44.7 0.00822   NR KAH8413794.1 309927 g10820 i0 31 1.06967213114754 87 51 95.9 3 11 244 547 633 KAH8413794.1 hypothetical protein KR222_008371, partial [Zaprionus bogoriensis] diamond 261 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Zaprionus Zaprionus bogoriensis
28106129 28106129 PRJNA986547_P_NODE_12985_length_235_cov_3.728395_g12903_i0 PRJNA986547 12985 235 3.728395 8.76172825 Phlebotomus 13203 Arthropoda Arthropoda 42.4 0.0398   NR XP_055705254.1 29031 g12903 i0 46.7 1.14893617021277 45 17 57.4 1 202 68 148 185 XP_055705254.1 uncharacterized protein LOC129802972 [Phlebotomus papatasi] diamond 270 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
28132046 28132046 PRJNA986547_P_NODE_10805_length_244_cov_3.789474_g10723_i0 PRJNA986547 10805 244 3.789474 9.24631656 Frankliniella occidentalis 133901 Arthropoda Arthropoda 73.9 1.82e-14   NR KAE8743480.1 133901 g10723 i0 45.5 4.73360655737705 77 42 94.7 0 244 14 53 129 KAE8743480.1 hypothetical protein FOCC_FOCC010932 [Frankliniella occidentalis] diamond 1155 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
28327114 28327114 PRJNA986547_P_NODE_13106_length_234_cov_6.422360_g13024_i0 PRJNA986547 13106 234 6.42236 15.0283224 root 1 Root_unresolved Root_unresolved 44.3 0.00948   NR XP_042859309.1 27405 g13024 i0 34 2.76923076923077 47 31 60.3 0 7 147 345 391 XP_042859309.1 baculoviral IAP repeat-containing protein 2-like [Penaeus japonicus] diamond 648 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus japonicus
28384461 28384461 PRJNA986547_P_NODE_15666_length_212_cov_5.489209_g15584_i0 PRJNA986547 15666 212 5.489209 11.63712308 Ixodes pacificus 29930 Arthropoda Arthropoda 41.2 0.0131   NR CAL6263729.1 29930 g15584 i0 44.8 0.820754716981132 58 18 76.4 3 163 2 4 51 CAL6263729.1 unnamed protein product [Ixodes pacificus] diamond 174 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes pacificus
28384465 28384465 PRJNA986547_P_NODE_5306_length_276_cov_1.438424_g5224_i0 PRJNA986547 5306 276 1.438424 3.97005024 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 77 5.09e-14   NR UYV61328.1 51811 g5224 i0 45.7 3.52173913043478 81 38 81.5 1 52 276 221 301 UYV61328.1 hypothetical protein LAZ67_1004381 [Cordylochernes scorpioides] diamond 972 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
28700363 28700363 PRJNA986547_P_NODE_15947_length_209_cov_9.661765_g15865_i0 PRJNA986547 15947 209 9.661765 20.19308885 Ischnura elegans 197161 Arthropoda Arthropoda 74.3 6.5e-15   NR XP_046388297.1 197161 g15865 i0 53.6 0.990430622009569 69 32 99 0 2 208 15 83 XP_046388297.1 60S ribosomal protein L22-like isoform X2 [Ischnura elegans] diamond 207 74.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Coenagrionidae Ischnura Ischnura elegans
28895482 28895482 PRJNA986547_P_NODE_7068_length_261_cov_1.255319_g6986_i0 PRJNA986547 7068 261 1.255319 3.27638259 Arthropoda 6656 Arthropoda Arthropoda 133 1.32e-34   NR KAH9642703.1 7107 g6986 i0 78.2 8.13793103448276 78 17 89.7 0 28 261 1 78 KAH9642703.1 hypothetical protein HF086_002973 [Spodoptera exigua] diamond 2124 133 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
29022251 29022251 PRJNA986547_P_NODE_11128_length_243_cov_11.088235_g11046_i0 PRJNA986547 11128 243 11.088235 26.94441105 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 45.1 0.00567   NR XP_064477610.1 34597 g11046 i0 81 0.518518518518518 21 4 25.9 0 238 176 144 164 XP_064477610.1 probable ATP-dependent RNA helicase vasa-like isoform X3 [Ornithodoros turicata] diamond 126 45.4 0.993392070484582 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
29079239 29079239 PRJNA986547_P_NODE_17048_length_200_cov_4.692913_g16966_i0 PRJNA986547 17048 200 4.692913 9.385826 Polyplax serrata 468196 Arthropoda Arthropoda 61.2 3.48e-9   NR KAK6638650.1 468196 g16966 i0 50.9 1.41 55 24 78 1 37 192 36 90 KAK6638650.1 hypothetical protein RUM43_006917 [Polyplax serrata] diamond 282 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
29237093 29237093 PRJNA986547_P_NODE_2069_length_332_cov_2.108108_g1987_i0 PRJNA986547 2069 332 2.108108 6.99891856 Thrips palmi 161013 Arthropoda Arthropoda 63.2 4.55e-9   NR XP_034243892.1 161013 g1987 i0 36.6 0.912650602409639 101 60 91.3 3 306 4 182 278 XP_034243892.1 voltage-dependent anion-selective channel-like [Thrips palmi] diamond 303 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
29558545 29558545 PRJNA986547_P_NODE_15550_length_213_cov_5.421429_g15468_i0 PRJNA986547 15550 213 5.421429 11.54764377 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 7.35e-6   NR XP_046913041.1 6954 g15468 i0 49 6.1830985915493 51 25 71.8 1 38 190 954 1003 XP_046913041.1 ras guanine nucleotide exchange factor P-like isoform X2 [Dermatophagoides farinae] diamond 1317 53.1 0.994350282485876 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
30026576 30026576 PRJNA986547_P_NODE_4011_length_290_cov_3.972350_g3929_i0 PRJNA986547 4011 290 3.97235 11.519815 Halotydeus destructor 2874060 Arthropoda Arthropoda 94.7 2.26e-20   NR KAI1289741.1 2874060 g3929 i0 62.3 0.631034482758621 61 23 63.1 0 243 61 1 61 KAI1289741.1 LIM and SH3 domain protein Lasp [Halotydeus destructor] diamond 183 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30057900 30057900 PRJNA986547_P_NODE_9651_length_248_cov_0.880000_g9569_i0 PRJNA986547 9651 248 0.88 2.1824 Homalodisca vitripennis 197043 Arthropoda Arthropoda 136 9.35e-39   NR KAG8315438.1 197043 g9569 i0 75.6 19.8387096774194 82 20 99.2 0 2 247 46 127 KAG8315438.1 Actin- protein 2/3 complex subunit 4 [Homalodisca vitripennis] diamond 4920 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
30215853 30215853 PRJNA986547_P_NODE_3032_length_310_cov_3.054852_g2950_i0 PRJNA986547 3032 310 3.054852 9.4700412 Schistocerca gregaria 7010 Arthropoda Arthropoda 84.7 1.55e-16   NR XP_049850318.1 7010 g2950 i0 42 3.83225806451613 100 39 79.4 3 247 2 345 443 XP_049850318.1 uncharacterized protein LOC126322426 [Schistocerca gregaria] diamond 1188 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30247854 30247854 PRJNA986547_P_NODE_7292_length_259_cov_2.451613_g7210_i0 PRJNA986547 7292 259 2.451613 6.34967767 Coptotermes formosanus 36987 Arthropoda Arthropoda 81.3 1.24e-16   NR AEW67351.1 36987 g7210 i0 57.8 0.741312741312741 64 27 74.1 0 224 33 89 152 AEW67351.1 carbohydrate binding module, partial [Coptotermes formosanus] diamond 192 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30253808 30253808 PRJNA986547_P_NODE_8252_length_252_cov_4.016760_g8170_i0 PRJNA986547 8252 252 4.01676 10.1222352 Insecta 50557 Arthropoda Arthropoda 43.5 0.0221   NR XP_018377809.1 471704 g8170 i0 42.1 2.04761904761905 38 22 45.2 0 72 185 352 389 XP_018377809.1 PREDICTED: uncharacterized protein LOC108770622 [Trachymyrmex cornetzi] diamond 516 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Trachymyrmex Trachymyrmex cornetzi
30374430 30374430 PRJNA986547_P_NODE_6472_length_265_cov_3.619792_g6390_i0 PRJNA986547 6472 265 3.619792 9.5924488 Ctenocephalides felis 7515 Arthropoda Arthropoda 50.8 6.84e-5   NR XP_026475639.1 7515 g6390 i0 43.6 0.622641509433962 55 31 62.3 0 12 176 272 326 XP_026475639.1 uncharacterized protein LOC113380719 [Ctenocephalides felis] diamond 165 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
30500402 30500402 PRJNA986547_P_NODE_13693_length_230_cov_5.082803_g13611_i0 PRJNA986547 13693 230 5.082803 11.6904469 Plodia interpunctella 58824 Arthropoda Arthropoda 48.1 4.01e-4   NR XP_053612629.2 58824 g13611 i0 62.2 0.978260869565217 37 14 48.3 0 34 144 632 668 XP_053612629.2 uncharacterized protein LOC128676517 [Plodia interpunctella] diamond 225 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Plodia Plodia interpunctella
31764774 31764774 PRJNA986547_P_NODE_6437_length_265_cov_7.322917_g6355_i0 PRJNA986547 6437 265 7.322917 19.40573005 Tribolium castaneum 7070 Arthropoda Arthropoda 54.7 3.04e-6   NR EFA12120.1 7070 g6355 i0 61 3.62264150943396 41 16 46.4 0 142 264 517 557 EFA12120.1 Retrovirus-related Pol polyprotein from transposon 17.6-like Protein [Tribolium castaneum] diamond 960 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
31833810 31833810 PRJNA986547_P_NODE_4757_length_282_cov_1.473684_g4675_i0 PRJNA986547 4757 282 1.473684 4.15578888 root 1 Root_unresolved Root_unresolved 144 4.81e-40   NR KAG8182524.1 931172 g4675 i0 67.7 20.7446808510638 93 30 98.9 0 280 2 178 270 KAG8182524.1 hypothetical protein JTE90_002062 [Oedothorax gibbosus] diamond 5850 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
31928835 31928835 PRJNA986547_P_NODE_10517_length_245_cov_2.389535_g10435_i0 PRJNA986547 10517 245 2.389535 5.85436075 Ixodidae 6939 Arthropoda Arthropoda 70.9 4.56e-12   NR KAH7944279.1 34632 g10435 i0 48.6 6.23265306122449 70 36 85.7 0 217 8 397 466 KAH7944279.1 hypothetical protein HPB52_017882 [Rhipicephalus sanguineus] diamond 1527 71.6 0.990223463687151 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus
32087122 32087122 PRJNA986547_P_NODE_11918_length_241_cov_3.250000_g11836_i0 PRJNA986547 11918 241 3.25 7.8325 Opisthokonta 33154 Arthropoda Arthropoda 68.9 1.96e-11   NR PBC29260.1 94128 g11836 i0 67.4 2.66390041493776 43 14 53.5 0 12 140 166 208 PBC29260.1 Guanine nucleotide-binding protein G(I)/G(S)/G(T) subunit beta-1 [Apis cerana cerana] diamond 642 69.3 0.994227994227994 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis cerana
32460988 32460988 PRJNA986547_P_NODE_6039_length_269_cov_2.377551_g5957_i0 PRJNA986547 6039 269 2.377551 6.39561219 Schistocerca gregaria 7010 Arthropoda Arthropoda 49.7 7.5e-5   NR XP_049849111.1 7010 g5957 i0 73 0.412639405204461 37 10 41.3 0 258 148 30 66 XP_049849111.1 uncharacterized protein LOC126317486 isoform X2 [Schistocerca gregaria] diamond 111 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32681502 32681502 PRJNA986547_P_NODE_10400_length_246_cov_0.890173_g10318_i0 PRJNA986547 10400 246 0.890173 2.18982558 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 67 1.12e-10   NR XP_055301856.1 263140 g10318 i0 45.3 5.14634146341463 86 39 96.3 2 10 246 362 446 XP_055301856.1 carnitine O-palmitoyltransferase 1, liver isoform-like isoform X1 [Sitodiplosis mosellana] diamond 1266 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
32870687 32870687 PRJNA986547_P_NODE_13760_length_230_cov_2.617834_g13678_i0 PRJNA986547 13760 230 2.617834 6.0210182 Anthonomus grandis grandis 2921223 Arthropoda Arthropoda 51.6 2.33e-5   NR XP_050311838.1 2921223 g13678 i0 50 0.756521739130435 58 27 73 1 225 58 212 269 XP_050311838.1 uncharacterized protein LOC126747328 [Anthonomus grandis grandis] diamond 174 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis

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