RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA485080" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA485080 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
19575136 19575136 PRJNA485080_P_NODE_4896_length_431_cov_2.150838_g4802_i0 PRJNA485080 4896 431 2.150838 9.27011178 Metazoa 33208 Arthropoda Arthropoda 163 1.6699999999999999e-43   NR CAD7223890.1 163714 g4802 i0 65.9 7.30858468677494 129 43 89.1 1 384 1 418 546 CAD7223890.1 unnamed protein product [Cyprideis torosa] diamond 3150 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
26791572 26791572 PRJNA485080_P_NODE_37981_length_243_cov_1.400000_g37887_i0 PRJNA485080 37981 243 1.4 3.402 Ignelater luminosus 2038154 Arthropoda Arthropoda 61.2 1.11e-8   NR KAF2897022.1 2038154 g37887 i0 49.2 0.753086419753086 61 31 75.3 0 199 17 60 120 KAF2897022.1 hypothetical protein ILUMI_09153 [Ignelater luminosus] diamond 183 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Elateridae Ignelater Ignelater luminosus
27170933 27170933 PRJNA485080_P_NODE_10422_length_331_cov_1.193798_g10328_i0 PRJNA485080 10422 331 1.193798 3.95147138 Anoplophora glabripennis 217634 Arthropoda Arthropoda 45.8 0.00857   NR XP_023310484.1 217634 g10328 i0 48.9 1.97583081570997 45 19 37.2 1 200 322 55 99 XP_023310484.1 uncharacterized protein DDB_G0290685-like [Anoplophora glabripennis] diamond 654 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
27297560 27297560 PRJNA485080_P_NODE_32123_length_246_cov_0.890173_g32029_i0 PRJNA485080 32123 246 0.890173 2.18982558 Araneus ventricosus 182803 Arthropoda Arthropoda 42.7 0.0127   NR GBO04574.1 182803 g32029 i0 37.1 0.75609756097561 62 37 75.6 1 222 37 38 97 GBO04574.1 hypothetical protein AVEN_269660-1, partial [Araneus ventricosus] diamond 186 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
27913467 27913467 PRJNA485080_P_NODE_29105_length_248_cov_0.880000_g29011_i0 PRJNA485080 29105 248 0.88 2.1824 Metazoa 33208 Arthropoda Arthropoda 139 1.02e-39   NR XP_027207784.1 6689 g29011 i0 72 8.92741935483871 82 23 99.2 0 2 247 23 104 XP_027207784.1 riboflavin kinase isoform X2 [Penaeus vannamei] diamond 2214 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
28055295 28055295 PRJNA485080_P_NODE_3545_length_495_cov_1.220379_g3451_i0 PRJNA485080 3545 495 1.220379 6.04087605 Musca vetustissima 27455 Arthropoda Arthropoda 97.1 1.13e-20   NR XP_061401018.1 27455 g3451 i0 38.3 1.80606060606061 149 75 85.5 7 494 72 171 310 XP_061401018.1 trypsin-1 [Musca vetustissima] diamond 894 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
28939630 28939630 PRJNA485080_P_NODE_22188_length_251_cov_0.865169_g22094_i0 PRJNA485080 22188 251 0.865169 2.17157419 Araneus ventricosus 182803 Arthropoda Arthropoda 42.7 0.0239   NR GBN91997.1 182803 g22094 i0 34.6 0.621513944223108 52 32 59.8 1 160 11 18 69 GBN91997.1 hypothetical protein AVEN_73025-1 [Araneus ventricosus] diamond 156 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
29192215 29192215 PRJNA485080_P_NODE_15349_length_290_cov_1.322581_g15255_i0 PRJNA485080 15349 290 1.322581 3.8354849 Schistocerca nitens 7011 Arthropoda Arthropoda 63.5 3.48e-10   NR XP_049799802.1 7011 g15255 i0 72.5 0.413793103448276 40 11 41.4 0 169 50 42 81 XP_049799802.1 uncharacterized protein LOC126235110 [Schistocerca nitens] diamond 120 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca nitens
29475969 29475969 PRJNA485080_P_NODE_18770_length_268_cov_1.184615_g18676_i0 PRJNA485080 18770 268 1.184615 3.1747682 Ephemera danica 1049336 Arthropoda Arthropoda 41.6 0.0232   NR KAF4530669.1 1049336 g18676 i0 44.4 0.503731343283582 45 24 49.3 1 249 118 5 49 KAF4530669.1 hypothetical protein B566_EDAN004908 [Ephemera danica] diamond 135 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Ephemeridae Ephemera Ephemera danica
29507745 29507745 PRJNA485080_P_NODE_10250_length_333_cov_1.038462_g10156_i0 PRJNA485080 10250 333 1.038462 3.45807846 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 45.4 0.0115   NR XP_042897067.2 114398 g10156 i0 44.9 4.42342342342342 49 27 44.1 0 185 39 539 587 XP_042897067.2 SCAN domain-containing protein 3-like [Parasteatoda tepidariorum] diamond 1473 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
29949968 29949968 PRJNA485080_P_NODE_26071_length_249_cov_0.875000_g25977_i0 PRJNA485080 26071 249 0.875 2.17875 Panulirus ornatus 150431 Arthropoda Arthropoda 100 1.99e-22   NR XP_071514707.1 150431 g25977 i0 58.3 8.09638554216867 84 34 100 1 249 1 91 174 XP_071514707.1 serine/threonine-protein kinase PLK4-like [Panulirus ornatus] diamond 2016 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus ornatus
30107814 30107814 PRJNA485080_P_NODE_19752_length_261_cov_1.638298_g19658_i0 PRJNA485080 19752 261 1.638298 4.27595778 Anabrus simplex 316456 Arthropoda Arthropoda 72.8 8.37e-13   NR XP_067004458.2 316456 g19658 i0 43.5 0.977011494252874 85 48 97.7 0 2 256 2 86 XP_067004458.2 cathepsin L [Anabrus simplex] diamond 255 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
30297953 30297953 PRJNA485080_P_NODE_32852_length_246_cov_0.890173_g32758_i0 PRJNA485080 32852 246 0.890173 2.18982558 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 42.7 0.0384   NR XP_066975025.1 79674 g32758 i0 36.7 0.731707317073171 60 31 64.6 1 51 209 408 467 XP_066975025.1 uncharacterized protein [Macrobrachium rosenbergii] diamond 180 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
30392696 30392696 PRJNA485080_P_NODE_1393_length_736_cov_1.760181_g1307_i0 PRJNA485080 1393 736 1.760181 12.95493216 Uranotaenia lowii 190385 Arthropoda Arthropoda 177 3.59e-50   NR XP_055595454.1 190385 g1307 i0 39.3 1.98913043478261 247 135 98.2 6 726 4 4 241 XP_055595454.1 cathepsin L [Uranotaenia lowii] diamond 1464 177 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
30581618 30581618 PRJNA485080_P_NODE_31753_length_247_cov_0.873563_g31659_i0 PRJNA485080 31753 247 0.873563 2.15770061 Polyplax serrata 468196 Arthropoda Arthropoda 48.9 2.57e-4   NR KAK6619754.1 468196 g31659 i0 40.2 0.995951417004049 82 48 98.4 1 3 245 453 534 KAK6619754.1 hypothetical protein RUM43_012518 [Polyplax serrata] diamond 246 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
30613307 30613307 PRJNA485080_P_NODE_37193_length_244_cov_0.900585_g37099_i0 PRJNA485080 37193 244 0.900585 2.1974274 Halocaridina rubra 373956 Arthropoda Arthropoda 42.7 0.0393   NR KAK7067325.1 373956 g37099 i0 47.5 0.491803278688525 40 20 49.2 1 73 192 1243 1281 KAK7067325.1 hypothetical protein SK128_006359 [Halocaridina rubra] diamond 120 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
30739789 30739789 PRJNA485080_P_NODE_20434_length_257_cov_1.255435_g20340_i0 PRJNA485080 20434 257 1.255435 3.22646795 Bemisia tabaci 7038 Arthropoda Arthropoda 43.1 0.0304   NR CAH0395633.1 7038 g20340 i0 56.8 0.431906614785992 37 14 40.9 1 70 174 91 127 CAH0395633.1 unnamed protein product [Bemisia tabaci] diamond 111 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
30866120 30866120 PRJNA485080_P_NODE_31854_length_246_cov_1.335260_g31760_i0 PRJNA485080 31854 246 1.33526 3.2847396 Halyomorpha halys 286706 Arthropoda Arthropoda 47 0.00122   NR XP_014282105.2 286706 g31760 i0 59.5 1.34146341463415 37 14 45.1 1 244 134 298 333 XP_014282105.2 uncharacterized protein [Halyomorpha halys] diamond 330 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
30929384 30929384 PRJNA485080_P_NODE_18914_length_267_cov_1.190722_g18820_i0 PRJNA485080 18914 267 1.190722 3.17922774 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 42.7 0.0493   NR CAB4061005.1 72036 g18820 i0 35 0.674157303370786 60 38 66.3 1 257 81 119 178 CAB4061005.1 ARMC8 [Lepeophtheirus salmonis] diamond 180 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31719813 31719813 PRJNA485080_P_NODE_17737_length_274_cov_1.532338_g17643_i0 PRJNA485080 17737 274 1.532338 4.19860612 Condylostylus longicornis 2530218 Arthropoda Arthropoda 50.4 1.03e-4   NR XP_055388942.1 2530218 g17643 i0 33 0.963503649635037 88 53 96.4 1 10 273 318 399 XP_055388942.1 diacylglycerol kinase A-like [Condylostylus longicornis] diamond 264 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
32289709 32289709 PRJNA485080_P_NODE_33659_length_246_cov_0.890173_g33565_i0 PRJNA485080 33659 246 0.890173 2.18982558 Hyposmocoma kahamanoa 1477025 Arthropoda Arthropoda 42.7 0.0391   NR XP_026319458.1 1477025 g33565 i0 36.4 0.670731707317073 55 29 67.1 1 75 239 591 639 XP_026319458.1 uncharacterized protein LOC113229971 [Hyposmocoma kahamanoa] diamond 165 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Cosmopterigidae Hyposmocoma Hyposmocoma kahamanoa
32542659 32542659 PRJNA485080_P_NODE_28439_length_248_cov_0.880000_g28345_i0 PRJNA485080 28439 248 0.88 2.1824 Manduca sexta 7130 Arthropoda Arthropoda 43.1 0.0294   NR XP_037292848.1 7130 g28345 i0 40 0.544354838709677 45 27 54.4 0 84 218 627 671 XP_037292848.1 Fanconi anemia group J protein isoform X2 [Manduca sexta] diamond 135 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta

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