RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1123686" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123686 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
26710905 26710905 PRJNA1123686_S_NODE_721_length_358_cov_54.197568_g690_i0 PRJNA1123686 721 358 54.197568 194.02729344 Metazoa 33208 Arthropoda Arthropoda 47 0.00162   NR XP_049835493.1 7010 g690 i0 57.1 2.87430167597765 49 21 41.1 0 242 96 101 149 XP_049835493.1 ubiquitin-60S ribosomal protein L40-like isoform X1 [Schistocerca gregaria] diamond 1029 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27564721 27564721 PRJNA1123686_S_NODE_5924_length_219_cov_167.721053_g5892_i0 PRJNA1123686 5924 219 167.721053 367.30910607 Metazoa 33208 Arthropoda Arthropoda 71.6 6.73e-14   NR XP_064478750.1 34597 g5892 i0 56.9 68.9178082191781 72 31 98.6 0 2 217 25 96 XP_064478750.1 small ribosomal subunit protein uS8 [Ornithodoros turicata] diamond 15093 71.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
28259362 28259362 PRJNA1123686_S_NODE_1486_length_306_cov_96.036101_g1454_i0 PRJNA1123686 1486 306 96.036101 293.87046906 Insecta 50557 Arthropoda Arthropoda 50.1 1.56e-5   NR KAG8297162.1 197043 g1454 i0 71.8 2.29411764705882 39 11 38.2 0 174 58 39 77 KAG8297162.1 ribosomal 40S subunit protein S13 [Homalodisca vitripennis] diamond 702 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
28744039 28744039 PRJNA1123686_S_NODE_6727_length_211_cov_54.087912_g6695_i0 PRJNA1123686 6727 211 54.087912 114.12549432 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 51.6 1.67e-5   NR UYV71554.1 51811 g6695 i0 84 5.33175355450237 25 4 35.5 0 1 75 245 269 UYV71554.1 hypothetical protein LAZ67_8003678 [Cordylochernes scorpioides] diamond 1125 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
28954433 28954433 PRJNA1123686_S_NODE_1328_length_313_cov_82.376761_g1296_i0 PRJNA1123686 1328 313 82.376761 257.83926193 Insecta 50557 Arthropoda Arthropoda 50.8 6.2e-5   NR CAH0382841.1 7038 g1296 i0 66.7 10.9169329073482 39 13 37.4 0 2 118 103 141 CAH0382841.1 unnamed protein product [Bemisia tabaci] diamond 3417 51.2 0.9921875 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28986012 28986012 PRJNA1123686_S_NODE_21068_length_151_cov_23.540984_g21036_i0 PRJNA1123686 21068 151 23.540984 35.54688584 Metazoa 33208 Arthropoda Arthropoda 47 3.39e-4   NR XP_021936028.1 136037 g21036 i0 81 0.913907284768212 21 4 41.7 0 2 64 331 351 XP_021936028.1 translation initiation factor eIF-2B subunit beta [Zootermopsis nevadensis] diamond 138 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
29522490 29522490 PRJNA1123686_S_NODE_3850_length_244_cov_122.097674_g3818_i0 PRJNA1123686 3850 244 122.097674 297.91832456 Metazoa 33208 Arthropoda Arthropoda 58.5 2.89e-8   NR CAB4057746.1 72036 g3818 i0 65.1 14.5696721311475 43 15 52.9 0 6 134 69 111 CAB4057746.1 RP-S18e [Lepeophtheirus salmonis] diamond 3555 58.9 0.99320882852292 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29754246 29754246 PRJNA1123686_S_NODE_2671_length_267_cov_14.016807_g2639_i0 PRJNA1123686 2671 267 14.016807 37.42487469 Ceratitis capitata 7213 Arthropoda Arthropoda 63.9 4.98e-10   NR CAD7015487.1 7213 g2639 i0 62.3 0.685393258426966 61 16 60.7 3 208 47 15 75 CAD7015487.1 unnamed protein product [Ceratitis capitata] diamond 183 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
29880890 29880890 PRJNA1123686_S_NODE_9271_length_193_cov_10.664634_g9239_i0 PRJNA1123686 9271 193 10.664634 20.58274362 Timema tahoe 61484 Arthropoda Arthropoda 46.6 8.17e-4   NR CAD7461464.1 61484 g9239 i0 64.7 1.86528497409326 34 12 52.8 0 190 89 261 294 CAD7461464.1 unnamed protein product [Timema tahoe] diamond 360 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
29901558 29901558 PRJNA1123686_S_NODE_21711_length_150_cov_7.462810_g21679_i0 PRJNA1123686 21711 150 7.46281 11.194215 Araneae 6893 Arthropoda Arthropoda 47.4 2.15e-4   NR XP_035220683.1 202533 g21679 i0 71.8 3.12 39 11 78 0 1 117 192 230 XP_035220683.1 LOW QUALITY PROTEIN: F-actin-capping protein subunit alpha-like, partial [Stegodyphus dumicola] diamond 468 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
29964717 29964717 PRJNA1123686_S_NODE_16311_length_163_cov_38.798507_g16279_i0 PRJNA1123686 16311 163 38.798507 63.24156641 Mesostigmata 34634 Arthropoda Arthropoda 46.2 5.52e-4   NR XP_003740654.1 34638 g16279 i0 57.4 3.4601226993865 47 20 86.5 0 1 141 107 153 XP_003740654.1 60S ribosomal protein L11 [Galendromus occidentalis] diamond 564 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
29996377 29996377 PRJNA1123686_S_NODE_16111_length_164_cov_8.081481_g16079_i0 PRJNA1123686 16111 164 8.081481 13.25362884 Aphididae 27482 Arthropoda Arthropoda 41.6 0.0333   NR XP_022163951.1 13164 g16079 i0 55.6 1.3719512195122 36 16 65.9 0 118 11 543 578 XP_022163951.1 uncharacterized protein LOC111029296 [Myzus persicae] diamond 225 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
30386612 30386612 PRJNA1123686_S_NODE_15513_length_166_cov_7.795620_g15481_i0 PRJNA1123686 15513 166 7.79562 12.9407292 Cotesia chilonis 89804 Arthropoda Arthropoda 57.8 4.21e-9   NR UDP69256.1 89804 g15481 i0 75 2.15060240963855 40 10 72.3 0 2 121 42 81 UDP69256.1 egg surface protein ES-389, partial [Cotesia chilonis] diamond 357 58.2 0.993127147766323 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia chilonis
31007276 31007276 PRJNA1123686_S_NODE_17374_length_160_cov_50.694656_g17342_i0 PRJNA1123686 17374 160 50.694656 81.1114496 Metazoa 33208 Arthropoda Arthropoda 43.5 0.00107   NR BAJ23425.1 29057 g17342 i0 71.4 1.40625 28 8 52.5 0 18 101 27 54 BAJ23425.1 ribosomal protein S7, partial [Ostrinia nubilalis] diamond 225 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia nubilalis
31112709 31112709 PRJNA1123686_S_NODE_7175_length_207_cov_346.792135_g7143_i0 PRJNA1123686 7175 207 346.792135 717.85971944999994 Panulirus ornatus 150431 Arthropoda Arthropoda 66.6 1.37e-11   NR XP_071517445.1 150431 g7143 i0 63.2 69.6376811594203 68 25 98.6 0 206 3 76 143 XP_071517445.1 small ribosomal subunit protein uS8A isoform X1 [Panulirus ornatus] diamond 14415 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus ornatus
31207221 31207221 PRJNA1123686_S_NODE_10975_length_184_cov_9.516129_g10943_i0 PRJNA1123686 10975 184 9.516129 17.50967736 Nephila pilipes 299642 Arthropoda Arthropoda 47.8 7.93e-5   NR GFU08569.1 299642 g10943 i0 55.6 1.5 45 20 73.4 0 152 18 2 46 GFU08569.1 hypothetical protein NPIL_549991 [Nephila pilipes] diamond 276 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
31239182 31239182 PRJNA1123686_S_NODE_4495_length_235_cov_47.859223_g4463_i0 PRJNA1123686 4495 235 47.859223 112.46917405 Lucilia cuprina 7375 Arthropoda Arthropoda 48.5 8.39e-5   NR KNC21481.1 7375 g4463 i0 45 1.53191489361702 60 33 76.6 0 182 3 8 67 KNC21481.1 hypothetical protein FF38_00577 [Lucilia cuprina] diamond 360 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
31302564 31302564 PRJNA1123686_S_NODE_9735_length_190_cov_15.944099_g9703_i0 PRJNA1123686 9735 190 15.944099 30.2937881 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 49.3 8.76e-5   NR KAF0297219.1 1232801 g9703 i0 82.6 30.5052631578947 23 4 36.3 0 4 72 301 323 KAF0297219.1 Ubiquitin-conjugating enzyme E2 [Amphibalanus amphitrite] diamond 5796 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
31397597 31397597 PRJNA1123686_S_NODE_12876_length_175_cov_36.226027_g12844_i0 PRJNA1123686 12876 175 36.226027 63.39554725 Timema tahoe 61484 Arthropoda Arthropoda 43.9 0.00581   NR CAD7461464.1 61484 g12844 i0 54.8 0.72 42 19 72 0 171 46 254 295 CAD7461464.1 unnamed protein product [Timema tahoe] diamond 126 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
31998505 31998505 PRJNA1123686_S_NODE_2558_length_269_cov_79.800000_g2526_i0 PRJNA1123686 2558 269 79.8 214.662 Notodromas monacha 399045 Arthropoda Arthropoda 48.5 4.34e-4   NR CAD7275513.1 399045 g2526 i0 55.8 2.42007434944238 43 19 48 0 2 130 59 101 CAD7275513.1 unnamed protein product [Notodromas monacha] diamond 651 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
31998506 31998506 PRJNA1123686_S_NODE_5498_length_224_cov_11.882051_g5466_i0 PRJNA1123686 5498 224 11.882051 26.61579424 Toxorhynchites rutilus septentrionalis 329112 Arthropoda Arthropoda 53.9 3.31e-6   NR XP_055645338.1 329112 g5466 i0 54.7 4.13839285714286 64 29 85.7 0 213 22 46 109 XP_055645338.1 uncharacterized protein LOC129781783 [Toxorhynchites rutilus septentrionalis] diamond 927 54.3 0.992633517495396 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Toxorhynchites Toxorhynchites rutilus
32019254 32019254 PRJNA1123686_S_NODE_7178_length_207_cov_265.578652_g7146_i0 PRJNA1123686 7178 207 265.578652 549.74780964 Metazoa 33208 Arthropoda Arthropoda 55.5 1.19e-7   NR XP_064478750.1 34597 g7146 i0 57.4 5.82608695652174 68 29 98.6 0 206 3 29 96 XP_064478750.1 small ribosomal subunit protein uS8 [Ornithodoros turicata] diamond 1206 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
32050874 32050874 PRJNA1123686_S_NODE_14638_length_169_cov_7.392857_g14606_i0 PRJNA1123686 14638 169 7.392857 12.49392833 Arthropoda 6656 Arthropoda Arthropoda 45.8 2.74e-4   NR GFT43257.1 299642 g14606 i0 59.6 2.75147928994083 52 21 92.3 0 10 165 46 97 GFT43257.1 hypothetical protein NPIL_679531 [Nephila pilipes] diamond 465 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
32568245 32568245 PRJNA1123686_S_NODE_5559_length_223_cov_24.752577_g5527_i0 PRJNA1123686 5559 223 24.752577 55.19824671 Ixodes pacificus 29930 Arthropoda Arthropoda 58.5 4.33e-8   NR CAL6219675.1 29930 g5527 i0 45.9 1.62780269058296 61 33 82.1 0 222 40 57 117 CAL6219675.1 unnamed protein product [Ixodes pacificus] diamond 363 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes pacificus
32851334 32851334 PRJNA1123686_S_NODE_7720_length_203_cov_22.155172_g7688_i0 PRJNA1123686 7720 203 22.155172 44.97499916 Notodromas monacha 399045 Arthropoda Arthropoda 63.5 8.26e-10   NR CAD7275513.1 399045 g7688 i0 60.7 0.827586206896552 56 22 82.8 0 2 169 65 120 CAD7275513.1 unnamed protein product [Notodromas monacha] diamond 168 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha

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