RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA782551" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA782551 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
7142075 7142075 PRJNA782551_P_NODE_10886_length_288_cov_1.074419_g10764_i0 PRJNA782551 10886 288 1.074419 3.09432672 Arthropoda 6656 Arthropoda Arthropoda 154 5.72e-41   NR TMW48144.1 7385 g10764 i0 83.2 277.083333333333 95 16 99 0 287 3 1482 1576 TMW48144.1 hypothetical protein DOY81_006777 [Sarcophaga bullata] diamond 79800 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sarcophagidae Sarcophaga Sarcophaga bullata
8416846 8416846 PRJNA782551_P_NODE_4987_length_418_cov_1.017391_g4865_i0 PRJNA782551 4987 418 1.017391 4.25269438 Insecta 50557 Arthropoda Arthropoda 205 1.3e-61   NR XP_049832595.1 7010 g4865 i0 67.6 15.9545454545455 139 45 99.8 0 2 418 236 374 XP_049832595.1 adenosylhomocysteinase-like [Schistocerca gregaria] diamond 6669 207 0.990338164251208 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
12243166 12243166 PRJNA782551_P_NODE_11770_length_280_cov_2.937198_g11648_i0 PRJNA782551 11770 280 2.937198 8.2241544 Arthropoda 6656 Arthropoda Arthropoda 149 8.02e-40   NR KPM03631.1 52283 g11648 i0 74.2 23.9892857142857 89 23 95.4 0 2 268 479 567 KPM03631.1 lysine-tRNA ligase-like protein [Sarcoptes scabiei] diamond 6717 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
13517401 13517401 PRJNA782551_P_NODE_15271_length_253_cov_3.511111_g15149_i0 PRJNA782551 15271 253 3.511111 8.88311083 Hexanauplia 72037 Arthropoda Arthropoda 134 7.09e-35   NR TRY72174.1 6832 g15149 i0 81.9 10.8260869565217 83 15 98.4 0 1 249 335 417 TRY72174.1 hypothetical protein TCAL_17397 [Tigriopus californicus] diamond 2739 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
14792419 14792419 PRJNA782551_P_NODE_9452_length_306_cov_0.991416_g9330_i0 PRJNA782551 9452 306 0.991416 3.03373296 Arthropoda 6656 Arthropoda Arthropoda 194 4.89e-61   NR NP_001245762.1 7227 g9330 i0 90.1 111.892156862745 101 10 99 0 2 304 46 146 NP_001245762.1 cell division cycle 42, isoform C [Drosophila melanogaster] diamond 34239 194 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
17341981 17341981 PRJNA782551_P_NODE_24754_length_241_cov_0.916667_g24632_i0 PRJNA782551 24754 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 108 1.81e-25   NR XP_015788986.1 32264 g24632 i0 63 17.2780082987552 73 27 90.9 0 219 1 1 73 XP_015788986.1 40S ribosomal protein S6 [Tetranychus urticae] diamond 4164 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
19890534 19890534 PRJNA782551_P_NODE_21476_length_245_cov_0.895349_g21354_i0 PRJNA782551 21476 245 0.895349 2.19360505 Arthropoda 6656 Arthropoda Arthropoda 114 2.05e-28   NR RXG56978.1 13347 g21354 i0 66.3 18.734693877551 80 26 96.7 1 243 7 131 210 RXG56978.1 Cathepsin L [Armadillidium vulgare] diamond 4590 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
26642039 26642039 PRJNA782551_P_NODE_7821_length_334_cov_1.869732_g7699_i0 PRJNA782551 7821 334 1.869732 6.24490488 Cotesia glomerata 32391 Arthropoda Arthropoda 119 1.59e-29   NR XP_044582688.1 32391 g7699 i0 52.3 2.92814371257485 107 50 96.1 1 333 13 196 301 XP_044582688.1 L-threonine 3-dehydrogenase, mitochondrial [Cotesia glomerata] diamond 978 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
26927052 26927052 PRJNA782551_P_NODE_16662_length_250_cov_0.870056_g16540_i0 PRJNA782551 16662 250 0.870056 2.17514 Linepithema humile 83485 Arthropoda Arthropoda 55.1 1.75e-6   NR XP_067216507.1 83485 g16540 i0 65.9 0.972 41 13 49.2 1 123 1 281 320 XP_067216507.1 nose resistant to fluoxetine protein 6-like [Linepithema humile] diamond 243 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Linepithema Linepithema humile
27179790 27179790 PRJNA782551_P_NODE_4342_length_451_cov_1.833333_g4220_i0 PRJNA782551 4342 451 1.833333 8.26833183 Cinara cedri 506608 Arthropoda Arthropoda 84.7 6.54e-16   NR VVC37549.1 506608 g4220 i0 37 0.665188470066519 100 62 66.5 1 3 302 361 459 VVC37549.1 Major facilitator superfamily,Major facilitator superfamily domain [Cinara cedri] diamond 300 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
27211435 27211435 PRJNA782551_P_NODE_9142_length_311_cov_1.222689_g9020_i0 PRJNA782551 9142 311 1.222689 3.80256279 Phymastichus coffea 108790 Arthropoda Arthropoda 53.5 8.24e-6   NR XP_058807600.1 108790 g9020 i0 46.9 3.03858520900322 64 32 59.8 1 286 101 143 206 XP_058807600.1 large ribosomal subunit protein eL13-like isoform X1 [Phymastichus coffea] diamond 945 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea
27338194 27338194 PRJNA782551_P_NODE_1943_length_700_cov_10.996810_g1828_i0 PRJNA782551 1943 700 10.99681 76.97767 Euwallacea similis 1736056 Arthropoda Arthropoda 122 1.16e-30   NR XP_066254759.1 1736056 g1828 i0 42.9 2.23714285714286 168 92 72 4 30 533 4 167 XP_066254759.1 glutathione S-transferase-like [Euwallacea similis] diamond 1566 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea similis
27536908 27536908 PRJNA782551_P_NODE_24683_length_241_cov_0.916667_g24561_i0 PRJNA782551 24683 241 0.916667 2.20916747 Arthropoda 6656 Arthropoda Arthropoda 49.7 1.25e-4   NR XP_053200475.1 50023 g24561 i0 30.8 3.84647302904564 78 51 93.4 2 239 15 362 439 XP_053200475.1 beta-hexosaminidase subunit alpha-like [Panonychus citri] diamond 927 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
27821212 27821212 PRJNA782551_P_NODE_23744_length_242_cov_0.911243_g23622_i0 PRJNA782551 23744 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 112 9.35e-29   NR XP_065570894.1 6661 g23622 i0 66.3 1.97107438016529 80 27 99.2 0 240 1 10 89 XP_065570894.1 large ribosomal subunit protein eL13-like [Artemia franciscana] diamond 477 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27843137 27843137 PRJNA782551_P_NODE_24784_length_241_cov_0.916667_g24662_i0 PRJNA782551 24784 241 0.916667 2.20916747 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 134 1.05e-35   NR KAH9404627.1 59818 g24662 i0 100 0.983402489626556 79 0 98.3 0 3 239 202 280 KAH9404627.1 putative palmitoyltransferase zdhhc1 [Tyrophagus putrescentiae] diamond 237 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28452683 28452683 PRJNA782551_P_NODE_14946_length_256_cov_1.377049_g14824_i0 PRJNA782551 14946 256 1.377049 3.52524544 Bradysia 35571 Arthropoda Arthropoda 145 4.56e-38   NR XP_037047749.1 38358 g14824 i0 85.5 1.9453125 83 12 97.3 0 254 6 1803 1885 XP_037047749.1 DNA polymerase theta isoform X1 [Bradysia coprophila] diamond 498 146 0.993150684931507 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28506373 28506373 PRJNA782551_P_NODE_12387_length_276_cov_1.137931_g12265_i0 PRJNA782551 12387 276 1.137931 3.14068956 Sarcophaga bullata 7385 Arthropoda Arthropoda 68.6 1.02e-12   NR TMW54478.1 7385 g12265 i0 47.5 0.641304347826087 59 31 64.1 0 274 98 38 96 TMW54478.1 hypothetical protein DOY81_000470 [Sarcophaga bullata] diamond 177 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sarcophagidae Sarcophaga Sarcophaga bullata
28506377 28506377 PRJNA782551_P_NODE_23867_length_242_cov_0.911243_g23745_i0 PRJNA782551 23867 242 0.911243 2.20520806 Caerostris darwini 1538125 Arthropoda Arthropoda 50.4 4.15e-5   NR GIY68935.1 1538125 g23745 i0 77.3 0.272727272727273 22 5 27.3 0 1 66 171 192 GIY68935.1 uncharacterized protein CDAR_294091 [Caerostris darwini] diamond 66 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
28948637 28948637 PRJNA782551_P_NODE_11708_length_281_cov_1.403846_g11586_i0 PRJNA782551 11708 281 1.403846 3.94480726 Dermatophagoides farinae 6954 Arthropoda Arthropoda 81.3 1.36e-17   NR KAH9520465.1 6954 g11586 i0 100 0.448398576512456 42 0 44.8 0 2 127 39 80 KAH9520465.1 hypothetical protein DERF_004174 [Dermatophagoides farinae] diamond 126 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
29201145 29201145 PRJNA782551_P_NODE_22049_length_244_cov_0.900585_g21927_i0 PRJNA782551 22049 244 0.900585 2.1974274 Oppia nitens 1686743 Arthropoda Arthropoda 144 4.5e-39   NR XP_054156405.1 1686743 g21927 i0 76.5 2.97540983606557 81 19 99.6 0 244 2 107 187 XP_054156405.1 epoxide hydrolase 1-like [Oppia nitens] diamond 726 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
29390570 29390570 PRJNA782551_P_NODE_24629_length_241_cov_0.916667_g24507_i0 PRJNA782551 24629 241 0.916667 2.20916747 Lasius platythorax 488582 Arthropoda Arthropoda 63.2 1.06e-9   NR CAL1677325.1 488582 g24507 i0 62.8 0.535269709543568 43 16 53.5 0 106 234 44 86 CAL1677325.1 unnamed protein product [Lasius platythorax] diamond 129 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius platythorax
29642691 29642691 PRJNA782551_P_NODE_13770_length_265_cov_1.197917_g13648_i0 PRJNA782551 13770 265 1.197917 3.17448005 Rhopalosiphum padi 40932 Arthropoda Arthropoda 47.8 8.37e-4   NR XP_060846261.1 40932 g13648 i0 43.1 0.656603773584906 58 33 65.7 0 181 8 516 573 XP_060846261.1 uncharacterized protein LOC132925921 [Rhopalosiphum padi] diamond 174 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
30379248 30379248 PRJNA782551_P_NODE_23392_length_242_cov_1.360947_g23270_i0 PRJNA782551 23392 242 1.360947 3.29349174 Metazoa 33208 Arthropoda Arthropoda 89.7 1.05e-18   NR XP_003747939.1 34638 g23270 i0 59 10.6611570247934 78 32 96.7 0 8 241 372 449 XP_003747939.1 transmembrane 9 superfamily member 2 [Galendromus occidentalis] diamond 2580 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
30631474 30631474 PRJNA782551_P_NODE_9013_length_313_cov_1.283333_g8891_i0 PRJNA782551 9013 313 1.283333 4.01683229 Metazoa 33208 Arthropoda Arthropoda 65.1 1.13e-9   NR XP_064484956.1 34597 g8891 i0 34.6 6.9776357827476 104 68 99.7 0 313 2 211 314 XP_064484956.1 sorting nexin-6-like isoform X1 [Ornithodoros turicata] diamond 2184 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
31358606 31358606 PRJNA782551_P_NODE_25076_length_241_cov_0.904762_g24954_i0 PRJNA782551 25076 241 0.904762 2.18047642 Metazoa 33208 Arthropoda Arthropoda 124 3.0299999999999996e-32   NR EEC13357.1 6945 g24954 i0 71.3 15.9336099585062 80 23 99.6 0 241 2 244 323 EEC13357.1 tRNA-dihydrouridine synthase, putative [Ixodes scapularis] diamond 3840 125 0.992 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
31539097 31539097 PRJNA782551_P_NODE_16316_length_251_cov_0.865169_g16194_i0 PRJNA782551 16316 251 0.865169 2.17157419 Chelonus insularis 460826 Arthropoda Arthropoda 80.9 1.57e-15   NR XP_034936134.1 460826 g16194 i0 52.5 3.52589641434263 59 28 70.5 0 251 75 1154 1212 XP_034936134.1 LOW QUALITY PROTEIN: coatomer subunit alpha-like [Chelonus insularis] diamond 885 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
32834740 32834740 PRJNA782551_P_NODE_13960_length_263_cov_1.621053_g13838_i0 PRJNA782551 13960 263 1.621053 4.26336939 Eretmocerus hayati 131215 Arthropoda Arthropoda 55.1 2.99e-7   NR KAJ8685207.1 131215 g13838 i0 36.3 0.91254752851711 80 44 91.3 1 3 242 17 89 KAJ8685207.1 hypothetical protein QAD02_021000 [Eretmocerus hayati] diamond 240 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Aphelinidae Eretmocerus Eretmocerus hayati

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