RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA879221 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
26611943 26611943 PRJNA879221_P_NODE_36281_length_291_cov_1.243119_g36141_i0 PRJNA879221 36281 291 1.243119 3.61747629 Cherax quadricarinatus 27406 Arthropoda Arthropoda 53.5 9.61e-6   NR KAK8735547.1 27406 g36141 i0 37.8 1.22680412371134 119 47 94.8 3 278 3 27 145 KAK8735547.1 hypothetical protein OTU49_005432 [Cherax quadricarinatus] diamond 357 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
26706810 26706810 PRJNA879221_P_NODE_45961_length_251_cov_0.865169_g45821_i0 PRJNA879221 45961 251 0.865169 2.17157419 Scylla paramamosain 85552 Arthropoda Arthropoda 130 4.13e-33   NR KAK8379955.1 85552 g45821 i0 94 0.99203187250996006 83 5 99.2 0 2 250 589 671 KAK8379955.1 hypothetical protein O3P69_019772 [Scylla paramamosain] diamond 249 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
26833860 26833860 PRJNA879221_P_NODE_64781_length_241_cov_0.916667_g64641_i0 PRJNA879221 64781 241 0.916667 2.20916747 Portunus trituberculatus 210409 Arthropoda Arthropoda 56.2 2.51e-8   NR MPC15165.1 210409 g64641 i0 47.3 0.921161825726141 74 23 92.1 2 18 239 3 60 MPC15165.1 hypothetical protein [Portunus trituberculatus] diamond 222 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
27403058 27403058 PRJNA879221_P_NODE_42463_length_264_cov_2.120419_g42323_i0 PRJNA879221 42463 264 2.120419 5.59790616 Scylla paramamosain 85552 Arthropoda Arthropoda 174 1.23e-54   NR KAK8389853.1 85552 g42323 i0 100 0.897727272727273 79 0 89.8 0 238 2 1 79 KAK8389853.1 hypothetical protein O3P69_009092 [Scylla paramamosain] diamond 237 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
27907838 27907838 PRJNA879221_P_NODE_16545_length_439_cov_1.945355_g16406_i0 PRJNA879221 16545 439 1.945355 8.54010845 Cinara cedri 506608 Arthropoda Arthropoda 67.4 8.52e-11   NR VVC42816.1 506608 g16406 i0 59.6 0.389521640091116 57 23 39 0 177 7 25 81 VVC42816.1 Hypothetical protein CINCED_3A015187 [Cinara cedri] diamond 171 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
27971249 27971249 PRJNA879221_P_NODE_46045_length_251_cov_0.865169_g45905_i0 PRJNA879221 46045 251 0.865169 2.17157419 Portunus trituberculatus 210409 Arthropoda Arthropoda 137 1.59e-35   NR XP_045119389.1 210409 g45905 i0 79.3 1.0996015936255 92 9 99.2 2 251 3 258 348 XP_045119389.1 dystrophin-like [Portunus trituberculatus] diamond 276 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
28350152 28350152 PRJNA879221_P_NODE_9406_length_600_cov_1.637571_g9268_i0 PRJNA879221 9406 600 1.637571 9.825426 Scylla paramamosain 85552 Arthropoda Arthropoda 223 2.9e-70   NR KAK8386090.1 85552 g9268 i0 100 0.615 123 0 61.5 0 50 418 104 226 KAK8386090.1 hypothetical protein O3P69_010668 [Scylla paramamosain] diamond 369 223 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28358019 28358019 PRJNA879221_P_NODE_47626_length_250_cov_0.870056_g47486_i0 PRJNA879221 47626 250 0.870056 2.17514 Petrolisthes 84661 Arthropoda Arthropoda 48.9 2.79e-4   NR KAK3884842.1 88211 g47486 i0 39.7 5.04 68 40 80.4 1 47 247 792 859 KAK3884842.1 hypothetical protein Pcinc_010905 [Petrolisthes cinctipes] diamond 1260 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
28413406 28413406 PRJNA879221_P_NODE_46746_length_251_cov_0.865169_g46606_i0 PRJNA879221 46746 251 0.865169 2.17157419 Blattella germanica 6973 Arthropoda Arthropoda 64.3 2.68e-11   NR PSN50905.1 6973 g46606 i0 63.6 0.657370517928287 55 11 65.7 2 180 16 42 87 PSN50905.1 hypothetical protein C0J52_05353 [Blattella germanica] diamond 165 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28445056 28445056 PRJNA879221_P_NODE_28306_length_331_cov_3.259690_g28166_i0 PRJNA879221 28306 331 3.25969 10.7895739 Portunus trituberculatus 210409 Arthropoda Arthropoda 126 1.67e-35   NR XP_045116330.1 210409 g28166 i0 66.3 0.806646525679758 89 27 79.8 2 272 9 1 87 XP_045116330.1 waprin-Phi1-like [Portunus trituberculatus] diamond 267 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
28445062 28445062 PRJNA879221_P_NODE_5326_length_817_cov_3.348118_g5205_i0 PRJNA879221 5326 817 3.348118 27.35412406 Scylla paramamosain 85552 Arthropoda Arthropoda 58.5 1.38e-6   NR KAK8386557.1 85552 g5205 i0 100 0.106487148102815 29 0 10.6 0 310 396 130 158 KAK8386557.1 hypothetical protein O3P69_010887 [Scylla paramamosain] diamond 87 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28476474 28476474 PRJNA879221_P_NODE_27966_length_333_cov_1.653846_g27826_i0 PRJNA879221 27966 333 1.653846 5.50730718 Scylla paramamosain 85552 Arthropoda Arthropoda 99 5.759999999999999e-23   NR KAK8384221.1 85552 g27826 i0 100 0.45045045045045 50 0 45 0 150 1 64 113 KAK8384221.1 hypothetical protein O3P69_009159 [Scylla paramamosain] diamond 150 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28855173 28855173 PRJNA879221_P_NODE_58188_length_244_cov_0.900585_g58048_i0 PRJNA879221 58188 244 0.900585 2.1974274 Scylla paramamosain 85552 Arthropoda Arthropoda 118 5.8399999999999995e-30   NR KAK8386711.1 85552 g58048 i0 81.3 2.95081967213115 80 15 98.4 0 4 243 129 208 KAK8386711.1 hypothetical protein O3P69_017875 [Scylla paramamosain] diamond 720 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
29392210 29392210 PRJNA879221_P_NODE_54029_length_247_cov_0.885057_g53889_i0 PRJNA879221 54029 247 0.885057 2.18609079 Eriocheir sinensis 95602 Arthropoda Arthropoda 65.5 3.7e-10   NR XP_050706890.1 95602 g53889 i0 65.9 0.534412955465587 44 15 53.4 0 245 114 252 295 XP_050706890.1 E3 SUMO-protein ligase ZBED1-like [Eriocheir sinensis] diamond 132 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
29644291 29644291 PRJNA879221_P_NODE_12630_length_509_cov_4.357798_g12491_i0 PRJNA879221 12630 509 4.357798 22.18119182 Scylla paramamosain 85552 Arthropoda Arthropoda 75.5 1.04e-13   NR KAK8386557.1 85552 g12491 i0 87.2 0.229862475442043 39 5 23 0 242 126 89 127 KAK8386557.1 hypothetical protein O3P69_010887 [Scylla paramamosain] diamond 117 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
29739143 29739143 PRJNA879221_P_NODE_38190_length_283_cov_0.871429_g38050_i0 PRJNA879221 38190 283 0.871429 2.46614407 Oppiella nova 334625 Arthropoda Arthropoda 58.5 6.7e-8   NR CAD7643510.1 334625 g38050 i0 70 5.04593639575972 60 18 63.6 0 102 281 94 153 CAD7643510.1 unnamed protein product [Oppiella nova] diamond 1428 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
29865735 29865735 PRJNA879221_P_NODE_56851_length_245_cov_0.895349_g56711_i0 PRJNA879221 56851 245 0.895349 2.19360505 Scylla paramamosain 85552 Arthropoda Arthropoda 97.1 1.89e-22   NR KAK8371899.1 85552 g56711 i0 80 0.673469387755102 55 11 67.3 0 166 2 78 132 KAK8371899.1 hypothetical protein O3P69_013457, partial [Scylla paramamosain] diamond 165 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
30149858 30149858 PRJNA879221_P_NODE_54212_length_247_cov_0.885057_g54072_i0 PRJNA879221 54212 247 0.885057 2.18609079 Chionoecetes opilio 41210 Arthropoda Arthropoda 81.3 1.08e-15   NR KAG0716607.1 41210 g54072 i0 60 1.73684210526316 80 32 97.2 0 247 8 298 377 KAG0716607.1 hypothetical protein GWK47_009244 [Chionoecetes opilio] diamond 429 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Majidae Chionoecetes Chionoecetes opilio
30308545 30308545 PRJNA879221_P_NODE_58412_length_244_cov_0.900585_g58272_i0 PRJNA879221 58412 244 0.900585 2.1974274 Periplaneta americana 6978 Arthropoda Arthropoda 45.8 0.00242   NR KAJ4450456.1 6978 g58272 i0 72 1.06967213114754 25 7 30.7 0 22 96 42 66 KAJ4450456.1 hypothetical protein ANN_01881 [Periplaneta americana] diamond 261 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30340195 30340195 PRJNA879221_P_NODE_49572_length_249_cov_0.875000_g49432_i0 PRJNA879221 49572 249 0.875 2.17875 Portunus trituberculatus 210409 Arthropoda Arthropoda 61.2 1.41e-9   NR MPC23103.1 210409 g49432 i0 84.4 0.385542168674699 32 5 38.6 0 134 39 65 96 MPC23103.1 hypothetical protein [Portunus trituberculatus] diamond 96 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
30908517 30908517 PRJNA879221_P_NODE_59214_length_244_cov_0.900585_g59074_i0 PRJNA879221 59214 244 0.900585 2.1974274 Scylla paramamosain 85552 Arthropoda Arthropoda 54.3 1.64e-6   NR KAK8379298.1 85552 g59074 i0 100 0.295081967213115 24 0 29.5 0 242 171 186 209 KAK8379298.1 hypothetical protein O3P69_019284 [Scylla paramamosain] diamond 72 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31192350 31192350 PRJNA879221_P_NODE_60915_length_243_cov_0.905882_g60775_i0 PRJNA879221 60915 243 0.905882 2.20129326 Panulirus ornatus 150431 Arthropoda Arthropoda 85.9 2.48e-17   NR XP_071519277.1 150431 g60775 i0 51.9 0.975308641975309 79 38 97.5 0 4 240 507 585 XP_071519277.1 transposable element P transposase isoform X4 [Panulirus ornatus] diamond 237 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus ornatus
31445766 31445766 PRJNA879221_P_NODE_59696_length_243_cov_1.358824_g59556_i0 PRJNA879221 59696 243 1.358824 3.30194232 Scylla paramamosain 85552 Arthropoda Arthropoda 67.4 7.5e-12   NR KAK8389942.1 85552 g59556 i0 64.2 0.827160493827161 67 24 82.7 0 242 42 91 157 KAK8389942.1 hypothetical protein O3P69_012867 [Scylla paramamosain] diamond 201 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31477526 31477526 PRJNA879221_P_NODE_60016_length_243_cov_0.905882_g59876_i0 PRJNA879221 60016 243 0.905882 2.20129326 Fopius arisanus 64838 Arthropoda Arthropoda 77.8 1.37e-14   NR XP_011303723.1 64838 g59876 i0 69.6 1.1358024691358 46 14 56.8 0 3 140 265 310 XP_011303723.1 protein farnesyltransferase subunit beta [Fopius arisanus] diamond 276 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Fopius Fopius arisanus
32015129 32015129 PRJNA879221_P_NODE_43958_length_258_cov_1.659459_g43818_i0 PRJNA879221 43958 258 1.659459 4.28140422 Portunus trituberculatus 210409 Arthropoda Arthropoda 138 1.25e-39   NR MPC33137.1 210409 g43818 i0 77.6 0.988372093023256 85 19 98.8 0 256 2 34 118 MPC33137.1 hypothetical protein [Portunus trituberculatus] diamond 255 138 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
32173545 32173545 PRJNA879221_P_NODE_57518_length_245_cov_0.895349_g57378_i0 PRJNA879221 57518 245 0.895349 2.19360505 Blattella germanica 6973 Arthropoda Arthropoda 75.9 6.07e-16   NR PSN43314.1 6973 g57378 i0 88.4 0.52653061224489806 43 5 52.7 0 243 115 40 82 PSN43314.1 hypothetical protein C0J52_17722 [Blattella germanica] diamond 129 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
32237006 32237006 PRJNA879221_P_NODE_37738_length_284_cov_3.649289_g37598_i0 PRJNA879221 37738 284 3.649289 10.36398076 Cinara cedri 506608 Arthropoda Arthropoda 71.2 5.2e-13   NR VVC42816.1 506608 g37598 i0 53.8 0.686619718309859 65 30 68.7 0 203 9 99 163 VVC42816.1 Hypothetical protein CINCED_3A015187 [Cinara cedri] diamond 195 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
32426523 32426523 PRJNA879221_P_NODE_43899_length_258_cov_2.459459_g43759_i0 PRJNA879221 43899 258 2.459459 6.34540422 Cinara cedri 506608 Arthropoda Arthropoda 61.2 3.7e-9   NR VVC42815.1 506608 g43759 i0 58.3 0.837209302325581 72 30 83.7 0 43 258 56 127 VVC42815.1 Hypothetical protein CINCED_3A007329 [Cinara cedri] diamond 216 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
32489928 32489928 PRJNA879221_P_NODE_3179_length_1058_cov_1.573604_g3083_i0 PRJNA879221 3179 1058 1.573604 16.64873032 Scylla paramamosain 85552 Arthropoda Arthropoda 52.4 0.00171   NR XP_063841124.1 85552 g3083 i0 64.1 0.110586011342155 39 13 10.8 1 5 118 43 81 XP_063841124.1 uncharacterized protein LOC135089473 [Scylla paramamosain] diamond 117 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
32678794 32678794 PRJNA879221_P_NODE_47860_length_250_cov_0.870056_g47720_i0 PRJNA879221 47860 250 0.870056 2.17514 Scylla paramamosain 85552 Arthropoda Arthropoda 68.2 4.33e-11   NR KAK8379567.1 85552 g47720 i0 91.2 0.408 34 3 40.8 0 148 249 369 402 KAK8379567.1 hypothetical protein O3P69_019481 [Scylla paramamosain] diamond 102 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain

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