RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA980839" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA980839 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
2232428 2232428 PRJNA980839_P_NODE_132702_length_306_cov_2.072961_g128918_i0 PRJNA980839 132702 306 2.072961 6.34326066 Eufriesea mexicana 516756 Arthropoda Arthropoda 79.3 1.13e-14   NR XP_017755570.1 516756 g128918 i0 50.5 2.29411764705882 91 40 89.2 3 273 1 139 224 XP_017755570.1 PREDICTED: lymphoid-specific helicase-like [Eufriesea mexicana] diamond 702 79.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Eufriesea Eufriesea mexicana
4786098 4786098 PRJNA980839_P_NODE_172544_length_268_cov_1.958974_g168760_i0 PRJNA980839 172544 268 1.958974 5.25005032 Timema genevievae 629358 Arthropoda Arthropoda 143 4.799999999999998e-41   NR CAD7601923.1 629358 g168760 i0 86.6 12.5932835820896 82 11 91.8 0 247 2 71 152 CAD7601923.1 unnamed protein product [Timema genevievae] diamond 3375 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
12437126 12437126 PRJNA980839_P_NODE_176650_length_265_cov_1.604167_g172866_i0 PRJNA980839 176650 265 1.604167 4.25104255 Metazoa 33208 Arthropoda Arthropoda 136 3.72e-39   NR OTF82201.1 6958 g172866 i0 71.6 37.8566037735849 88 25 99.6 0 265 2 17 104 OTF82201.1 40S ribosomal protein S18-like protein [Euroglyphus maynei] diamond 10032 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Euroglyphus Euroglyphus maynei
20086624 20086624 PRJNA980839_P_NODE_69096_length_469_cov_7.181818_g65314_i0 PRJNA980839 69096 469 7.181818 33.68272642 Artemia franciscana 6661 Arthropoda Arthropoda 152 2.08e-44   NR XP_065560387.1 6661 g65314 i0 65.6 0.818763326226013 128 41 81.2 2 439 59 1 126 XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana] diamond 384 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
26842632 26842632 PRJNA980839_P_NODE_170461_length_270_cov_1.406091_g166677_i0 PRJNA980839 170461 270 1.406091 3.7964457 Diptera 7147 Arthropoda Arthropoda 56.6 6.26e-7   NR XP_017844236.1 30019 g166677 i0 75.8 1.62222222222222 33 8 36.7 0 103 5 179 211 XP_017844236.1 selenide, water dikinase 2 [Drosophila busckii] diamond 438 57 0.992982456140351 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
26868241 26868241 PRJNA980839_P_NODE_173081_length_268_cov_1.400000_g169297_i0 PRJNA980839 173081 268 1.4 3.752 Schistocerca gregaria 7010 Arthropoda Arthropoda 82.4 4.29e-16   NR XP_049849447.1 7010 g169297 i0 57.4 0.761194029850746 68 29 76.1 0 266 63 89 156 XP_049849447.1 uncharacterized protein LOC126318684 [Schistocerca gregaria] diamond 204 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
26962777 26962777 PRJNA980839_P_NODE_195442_length_252_cov_1.424581_g191658_i0 PRJNA980839 195442 252 1.424581 3.58994412 Schistocerca gregaria 7010 Arthropoda Arthropoda 51.2 4.18e-5   NR XP_049849583.1 7010 g191658 i0 40.8 0.845238095238095 71 40 84.5 2 39 251 391 459 XP_049849583.1 DNA-directed RNA polymerase III subunit rpc3-like [Schistocerca gregaria] diamond 213 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27089599 27089599 PRJNA980839_P_NODE_245262_length_229_cov_2.025641_g241478_i0 PRJNA980839 245262 229 2.025641 4.63871789 Penaeus vannamei 6689 Arthropoda Arthropoda 43.5 0.0169   NR ROT62074.1 6689 g241478 i0 51.3 0.995633187772926 76 33 98.3 4 226 2 191 263 ROT62074.1 hypothetical protein C7M84_020095 [Penaeus vannamei] diamond 228 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27405702 27405702 PRJNA980839_P_NODE_170503_length_270_cov_1.345178_g166719_i0 PRJNA980839 170503 270 1.345178 3.6319806 Artemia franciscana 6661 Arthropoda Arthropoda 43.9 0.0191   NR KAK2713566.1 6661 g166719 i0 78.6 0.311111111111111 28 6 31.1 0 185 268 68 95 KAK2713566.1 hypothetical protein QYM36_009445, partial [Artemia franciscana] diamond 84 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27500369 27500369 PRJNA980839_P_NODE_203243_length_250_cov_0.870056_g199459_i0 PRJNA980839 203243 250 0.870056 2.17514 Orchesella cincta 48709 Arthropoda Arthropoda 64.7 7.18e-10   NR ODN03474.1 48709 g199459 i0 46.8 0.924 77 38 92.4 1 20 250 96 169 ODN03474.1 Fatty acid desaturase 2 [Orchesella cincta] diamond 231 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
27563099 27563099 PRJNA980839_P_NODE_161504_length_277_cov_1.568627_g157720_i0 PRJNA980839 161504 277 1.568627 4.34509679 Artemia franciscana 6661 Arthropoda Arthropoda 130 1.67e-37   NR KAK2713070.1 6661 g157720 i0 100 0.649819494584838 60 0 65 0 3 182 27 86 KAK2713070.1 hypothetical protein QYM36_011681 [Artemia franciscana] diamond 180 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27563116 27563116 PRJNA980839_P_NODE_213584_length_247_cov_0.885057_g209800_i0 PRJNA980839 213584 247 0.885057 2.18609079 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 105 1.82e-24   NR KAH9409942.1 59818 g209800 i0 100 0.546558704453441 45 0 54.7 0 245 111 356 400 KAH9409942.1 hypothetical protein TYRP_009689 [Tyrophagus putrescentiae] diamond 135 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27727672 27727672 PRJNA980839_P_NODE_126424_length_315_cov_1.214876_g122640_i0 PRJNA980839 126424 315 1.214876 3.8268594 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.9 0.0345   NR KAH0809322.1 7067 g122640 i0 48.8 4.51428571428571 43 20 41 1 313 185 252 292 KAH0809322.1 hypothetical protein GEV33_013468 [Tenebrio molitor] diamond 1422 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
28200723 28200723 PRJNA980839_P_NODE_67826_length_476_cov_1.746898_g64044_i0 PRJNA980839 67826 476 1.746898 8.31523448 root 1 Root_unresolved Root_unresolved 52.8 9.31e-5   NR KAJ8715132.1 667449 g64044 i0 50 0.78781512605042 68 33 42.2 1 66 266 91 158 KAJ8715132.1 hypothetical protein PYW08_005113 [Mythimna loreyi] diamond 375 53.1 0.994350282485876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna loreyi
28358667 28358667 PRJNA980839_P_NODE_237886_length_241_cov_0.916667_g234102_i0 PRJNA980839 237886 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 60.5 1.51e-8   NR KAJ9580882.1 6984 g234102 i0 43.2 2.90041493775934 74 38 92.1 2 241 20 82 151 KAJ9580882.1 hypothetical protein L9F63_023943, partial [Diploptera punctata] diamond 699 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
28447635 28447635 PRJNA980839_P_NODE_212526_length_247_cov_1.454023_g208742_i0 PRJNA980839 212526 247 1.454023 3.59143681 Condylostylus longicornis 2530218 Arthropoda Arthropoda 96.3 5.7e-21   NR XP_055378688.1 2530218 g208742 i0 80 0.668016194331984 55 11 66.8 0 4 168 77 131 XP_055378688.1 solute carrier family 22 member 13-like isoform X2 [Condylostylus longicornis] diamond 165 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
28573679 28573679 PRJNA980839_P_NODE_217867_length_246_cov_0.890173_g214083_i0 PRJNA980839 217867 246 0.890173 2.18982558 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 55.1 1.68e-6   NR XP_066964700.1 79674 g214083 i0 56.4 0.853658536585366 39 17 47.6 0 9 125 412 450 XP_066964700.1 protein tramtrack, beta isoform-like isoform X9 [Macrobrachium rosenbergii] diamond 210 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
28668628 28668628 PRJNA980839_P_NODE_230367_length_243_cov_0.905882_g226583_i0 PRJNA980839 230367 243 0.905882 2.20129326 Cloeon dipterum 197152 Arthropoda Arthropoda 47 0.0012   NR CAB3377207.1 197152 g226583 i0 41.4 0.716049382716049 58 31 71.6 1 241 68 571 625 CAB3377207.1 Hypothetical predicted protein [Cloeon dipterum] diamond 174 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
28700205 28700205 PRJNA980839_P_NODE_195947_length_251_cov_4.348315_g192163_i0 PRJNA980839 195947 251 4.348315 10.91427065 Artemia franciscana 6661 Arthropoda Arthropoda 69.7 2.7e-12   NR KAK2701725.1 6661 g192163 i0 48.8 0.956175298804781 80 39 95.6 1 240 1 88 165 KAK2701725.1 hypothetical protein QYM36_019634, partial [Artemia franciscana] diamond 240 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28706244 28706244 PRJNA980839_P_NODE_153667_length_284_cov_1.137441_g149883_i0 PRJNA980839 153667 284 1.137441 3.23033244 Arthropoda 6656 Arthropoda Arthropoda 47 0.00181   NR KMQ82595.1 67767 g149883 i0 82.6 2.8943661971831 23 4 24.3 0 252 184 162 184 KMQ82595.1 transposable element tcb1 transposase [Lasius niger] diamond 822 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
29773424 29773424 PRJNA980839_P_NODE_176651_length_265_cov_1.604167_g172867_i0 PRJNA980839 176651 265 1.604167 4.25104255 Ladona fulva 123851 Arthropoda Arthropoda 46.2 0.00258   NR KAG8229635.1 123851 g172867 i0 66.7 0.588679245283019 27 9 30.6 0 184 264 14 40 KAG8229635.1 hypothetical protein J437_LFUL015586 [Ladona fulva] diamond 156 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
29836669 29836669 PRJNA980839_P_NODE_221571_length_245_cov_0.895349_g217787_i0 PRJNA980839 221571 245 0.895349 2.19360505 Galendromus occidentalis 34638 Arthropoda Arthropoda 47.8 6.25e-4   NR XP_003742040.2 34638 g217787 i0 77.8 0.330612244897959 27 6 33.1 0 243 163 174 200 XP_003742040.2 uncharacterized protein LOC100904030 [Galendromus occidentalis] diamond 81 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
30537831 30537831 PRJNA980839_P_NODE_222573_length_245_cov_0.895349_g218789_i0 PRJNA980839 222573 245 0.895349 2.19360505 Diptera 7147 Arthropoda Arthropoda 99 6.36e-22   NR XP_037036997.1 38358 g218789 i0 62.5 4.99591836734694 72 27 88.2 0 29 244 488 559 XP_037036997.1 atrial natriuretic peptide receptor 1-like isoform X2 [Bradysia coprophila] diamond 1224 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
30626412 30626412 PRJNA980839_P_NODE_233193_length_242_cov_0.911243_g229409_i0 PRJNA980839 233193 242 0.911243 2.20520806 Artemia franciscana 6661 Arthropoda Arthropoda 128 1.37e-32   NR KAK2705541.1 6661 g229409 i0 100 0.793388429752066 64 0 79.3 0 192 1 57 120 KAK2705541.1 hypothetical protein QYM36_015806 [Artemia franciscana] diamond 192 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30847738 30847738 PRJNA980839_P_NODE_146814_length_290_cov_1.345622_g143030_i0 PRJNA980839 146814 290 1.345622 3.9023038 Vespula maculifrons 7453 Arthropoda Arthropoda 43.9 0.00775   NR KAL2745201.1 7453 g143030 i0 61.5 0.403448275862069 39 13 40.3 1 283 167 22 58 KAL2745201.1 hypothetical protein V1477_006618 [Vespula maculifrons] diamond 117 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula maculifrons
31194884 31194884 PRJNA980839_P_NODE_190655_length_255_cov_1.692308_g186871_i0 PRJNA980839 190655 255 1.692308 4.3153854 Frankliniella fusca 407009 Arthropoda Arthropoda 48.1 5.4e-4   NR KAK3926464.1 407009 g186871 i0 29.5 1.90588235294118 78 53 89.4 1 251 24 436 513 KAK3926464.1 putative RNA-directed DNA polymerase from transposon BS [Frankliniella fusca] diamond 486 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella fusca
31226787 31226787 PRJNA980839_P_NODE_203175_length_250_cov_0.870056_g199391_i0 PRJNA980839 203175 250 0.870056 2.17514 Trichonephila clavipes 2585209 Arthropoda Arthropoda 49.3 5.88e-5   NR GFX37588.1 2585209 g199391 i0 69 3.888 29 9 34.8 0 135 49 34 62 GFX37588.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 972 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
31575002 31575002 PRJNA980839_P_NODE_177416_length_265_cov_0.802083_g173632_i0 PRJNA980839 177416 265 0.802083 2.12551995 Hyalella azteca 294128 Arthropoda Arthropoda 43.1 0.0371   NR XP_018012339.1 294128 g173632 i0 44 0.566037735849057 50 27 55.5 1 174 28 152 201 XP_018012339.1 serine protease nudel [Hyalella azteca] diamond 150 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
31827723 31827723 PRJNA980839_P_NODE_35357_length_817_cov_2.956989_g31891_i0 PRJNA980839 35357 817 2.956989 24.15860013 Artemia franciscana 6661 Arthropoda Arthropoda 314 1.4799999999999996e-101   NR KAK2707618.1 6661 g31891 i0 99.6 0.906976744186046 247 1 90.7 0 741 1 211 457 KAK2707618.1 hypothetical protein QYM36_015356 [Artemia franciscana] diamond 741 314 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31985915 31985915 PRJNA980839_P_NODE_141958_length_295_cov_1.387387_g138174_i0 PRJNA980839 141958 295 1.387387 4.09279165 Penaeus vannamei 6689 Arthropoda Arthropoda 61.2 9.03e-10   NR XP_069980498.1 6689 g138174 i0 41.6 6.28474576271186 77 39 77.3 2 53 280 1 72 XP_069980498.1 migration and invasion enhancer 1 [Penaeus vannamei] diamond 1854 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32334401 32334401 PRJNA980839_P_NODE_189199_length_256_cov_1.683060_g185415_i0 PRJNA980839 189199 256 1.68306 4.3086336 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 50.4 8.31e-5   NR XP_055319987.1 263140 g185415 i0 50 0.703125 60 26 65.6 2 168 1 239 298 XP_055319987.1 solute carrier family 2, facilitated glucose transporter member 1-like isoform X2 [Sitodiplosis mosellana] diamond 180 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
32750639 32750639 PRJNA980839_P_NODE_187740_length_257_cov_1.673913_g183956_i0 PRJNA980839 187740 257 1.673913 4.30195641 root 1 Root_unresolved Root_unresolved 47.8 7.02e-4   NR KAJ3637863.1 7067 g183956 i0 77.8 5.18287937743191 27 6 31.5 0 256 176 48 74 KAJ3637863.1 hypothetical protein MTP99_001285 [Tenebrio molitor] diamond 1332 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
32838950 32838950 PRJNA980839_P_NODE_226000_length_244_cov_0.900585_g222216_i0 PRJNA980839 226000 244 0.900585 2.1974274 Clunio marinus 568069 Arthropoda Arthropoda 109 1.05e-25   NR CRL01308.1 568069 g222216 i0 68.3 1.00819672131148 82 24 99.6 2 243 1 337 417 CRL01308.1 CLUMA_CG014232, isoform B [Clunio marinus] diamond 246 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus

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