RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA1253698" 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

  • PRJNA1253698 · 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
13113504 13113504 PRJNA1253698_S_NODE_14431_length_185_cov_1.345588_g14065_i0 PRJNA1253698 14431 185 1.345588 2.4893378 Papilio xuthus 66420 Arthropoda Arthropoda 75.5 2.57e-15   NR NP_001299478.1 66420 g14065 i0 89.1 0.891891891891892 55 4 85.9 2 184 26 66 120 NP_001299478.1 Repressor splicing factor 1 [Papilio xuthus] diamond 165 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
18211358 18211358 PRJNA1253698_S_NODE_15235_length_181_cov_1.098485_g14869_i0 PRJNA1253698 15235 181 1.098485 1.98825785 Parnassius mnemosyne 213953 Arthropoda Arthropoda 116 1.06e-29   NR CAK1591179.1 213953 g14869 i0 96.5 0.94475138121547 57 2 94.5 0 9 179 234 290 CAK1591179.1 unnamed protein product [Parnassius mnemosyne] diamond 171 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius mnemosyne
23311871 23311871 PRJNA1253698_S_NODE_19679_length_167_cov_0.872881_g19313_i0 PRJNA1253698 19679 167 0.872881 1.45771127 Papilio polytes 76194 Arthropoda Arthropoda 100 5.78e-24   NR NP_001298439.1 76194 g19313 i0 90.6 0.952095808383233 53 5 95.2 0 161 3 238 290 NP_001298439.1 probable chitinase 3 precursor [Papilio polytes] diamond 159 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
26757151 26757151 PRJNA1253698_S_NODE_21521_length_164_cov_1.147826_g21155_i0 PRJNA1253698 21521 164 1.147826 1.88243464 Papilio polytes 76194 Arthropoda Arthropoda 94.4 4.67e-22   NR NP_001298548.1 76194 g21155 i0 96.3 0.98780487804878 54 2 98.8 0 162 1 45 98 NP_001298548.1 uncharacterized LOC106106521 precursor [Papilio polytes] diamond 162 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
26838777 26838777 PRJNA1253698_S_NODE_22881_length_163_cov_0.903509_g22515_i0 PRJNA1253698 22881 163 0.903509 1.47271967 Papilio 7145 Arthropoda Arthropoda 109 3.08e-26   NR KPJ12596.1 76193 g22515 i0 96.2 2.92638036809816 53 2 97.5 0 161 3 489 541 KPJ12596.1 Gelsolin [Papilio machaon] diamond 477 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio machaon
26852550 26852550 PRJNA1253698_S_NODE_13901_length_188_cov_1.705036_g13535_i0 PRJNA1253698 13901 188 1.705036 3.20546768 Papilio xuthus 66420 Arthropoda Arthropoda 112 6.47e-29   NR XP_013173289.1 66420 g13535 i0 83.9 1.97872340425532 62 10 98.9 0 187 2 22 83 XP_013173289.1 PREDICTED: uncharacterized protein LOC106121993 [Papilio xuthus] diamond 372 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
27042213 27042213 PRJNA1253698_S_NODE_10622_length_212_cov_0.852761_g10256_i0 PRJNA1253698 10622 212 0.852761 1.80785332 Battus philenor 42288 Arthropoda Arthropoda 71.2 1.24e-12   NR XP_068632706.1 42288 g10256 i0 89.7 0.55188679245283 39 4 55.2 0 118 2 190 228 XP_068632706.1 G-box-binding factor-like [Battus philenor] diamond 117 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Battus Battus philenor
27136590 27136590 PRJNA1253698_S_NODE_14462_length_185_cov_1.132353_g14096_i0 PRJNA1253698 14462 185 1.132353 2.09485305 Battus philenor 42288 Arthropoda Arthropoda 90.1 3.98e-22   NR XP_068628011.1 42288 g14096 i0 95.6 2.18918918918919 45 2 73 0 183 49 21 65 XP_068628011.1 large ribosomal subunit protein bL33m [Battus philenor] diamond 405 90.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Battus Battus philenor
27516184 27516184 PRJNA1253698_S_NODE_18943_length_168_cov_0.865546_g18577_i0 PRJNA1253698 18943 168 0.865546 1.45411728 Papilio xuthus 66420 Arthropoda Arthropoda 62.8 2.26e-10   NR NP_001299504.1 66420 g18577 i0 73.8 0.75 42 11 75 0 163 38 69 110 NP_001299504.1 uncharacterized protein LOC106127043 precursor [Papilio xuthus] diamond 126 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
27831860 27831860 PRJNA1253698_S_NODE_10064_length_217_cov_1.464286_g9698_i0 PRJNA1253698 10064 217 1.464286 3.17750062 Papilio polytes 76194 Arthropoda Arthropoda 95.1 7.37e-22   NR XP_013137311.1 76194 g9698 i0 66.7 0.953917050691244 69 23 95.4 0 7 213 146 214 XP_013137311.1 PREDICTED: cuticle protein 19.8-like [Papilio polytes] diamond 207 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
29063424 29063424 PRJNA1253698_S_NODE_2308_length_486_cov_4.446224_g1950_i0 PRJNA1253698 2308 486 4.446224 21.60864864 Papilio polytes 76194 Arthropoda Arthropoda 187 1.1099999999999995e-55   NR XP_013140067.1 76194 g1950 i0 88.6 0.648148148148148 105 12 64.8 0 8 322 123 227 XP_013140067.1 PREDICTED: uncharacterized protein LOC106104536 [Papilio polytes] diamond 315 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
29126722 29126722 PRJNA1253698_S_NODE_1589_length_661_cov_3.674837_g1250_i0 PRJNA1253698 1589 661 3.674837 24.29067257 Papilio polytes 76194 Arthropoda Arthropoda 338 6.559999999999998e-116   NR XP_013135456.1 76194 g1250 i0 78.9 2.70953101361573 199 42 90.3 0 65 661 1 199 XP_013135456.1 PREDICTED: insecticyanin-B-like [Papilio polytes] diamond 1791 338 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
29694463 29694463 PRJNA1253698_S_NODE_12090_length_200_cov_1.350993_g11724_i0 PRJNA1253698 12090 200 1.350993 2.701986 Papilio xuthus 66420 Arthropoda Arthropoda 124 3.43e-32   NR KPI91676.1 66420 g11724 i0 90.9 1.98 66 6 99 0 199 2 114 179 KPI91676.1 Activating transcription factor of chaperone [Papilio xuthus] diamond 396 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
29694464 29694464 PRJNA1253698_S_NODE_23670_length_162_cov_0.911504_g23304_i0 PRJNA1253698 23670 162 0.911504 1.47663648 Papilio xuthus 66420 Arthropoda Arthropoda 74.3 7.75e-15   NR NP_001299683.1 66420 g23304 i0 71.2 1.92592592592593 52 14 96.3 1 3 158 12 62 NP_001299683.1 membrane-associated progesterone receptor component 1-like [Papilio xuthus] diamond 312 74.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
29789358 29789358 PRJNA1253698_S_NODE_6571_length_268_cov_5.662100_g6205_i0 PRJNA1253698 6571 268 5.6621 15.174428 Penaeus vannamei 6689 Arthropoda Arthropoda 43.5 0.0272   NR ROT78784.1 6689 g6205 i0 44.2 2.00373134328358 77 36 78.4 3 31 240 138 214 ROT78784.1 hypothetical protein C7M84_002500 [Penaeus vannamei] diamond 537 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29979028 29979028 PRJNA1253698_S_NODE_2551_length_452_cov_6.406948_g2188_i0 PRJNA1253698 2551 452 6.406948 28.95940496 Papilio xuthus 66420 Arthropoda Arthropoda 212 4.0899999999999994e-67   NR KPJ04152.1 66420 g2188 i0 69.4 0.975663716814159 147 40 94.9 2 429 1 1 146 KPJ04152.1 hypothetical protein RR46_07911 [Papilio xuthus] diamond 441 212 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
30136620 30136620 PRJNA1253698_S_NODE_10192_length_216_cov_1.065868_g9826_i0 PRJNA1253698 10192 216 1.065868 2.30227488 Papilio xuthus 66420 Arthropoda Arthropoda 149 4.659999999999998e-42   NR BAM19367.1 66420 g9826 i0 90.1 3.94444444444444 71 7 98.6 0 214 2 39 109 BAM19367.1 saposin, partial [Papilio xuthus] diamond 852 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
30136621 30136621 PRJNA1253698_S_NODE_24532_length_153_cov_2.471154_g24166_i0 PRJNA1253698 24532 153 2.471154 3.78086562 Phthorimaea operculella 192464 Arthropoda Arthropoda 95.1 2.96e-21   NR UFX33238.1 192464 g24166 i0 96 11.7647058823529 50 2 98 0 153 4 105 154 UFX33238.1 ribosomal protein L4, partial [Phthorimaea operculella] diamond 1800 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Phthorimaea Phthorimaea operculella
30565283 30565283 PRJNA1253698_S_NODE_22393_length_163_cov_0.912281_g22027_i0 PRJNA1253698 22393 163 0.912281 1.48701803 Papilio 7145 Arthropoda Arthropoda 102 4.26e-24   NR XP_013169858.1 66420 g22027 i0 88.7 3.90184049079755 53 6 97.5 0 159 1 203 255 XP_013169858.1 PREDICTED: serine protease snake-like [Papilio xuthus] diamond 636 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
30958586 30958586 PRJNA1253698_S_NODE_10554_length_212_cov_2.061350_g10188_i0 PRJNA1253698 10554 212 2.06135 4.370062 Papilio machaon 76193 Arthropoda Arthropoda 114 2.7199999999999997e-30   NR XP_014355955.2 76193 g10188 i0 85.5 0.976415094339623 69 7 97.6 1 2 208 5 70 XP_014355955.2 uncharacterized protein LOC106708882 [Papilio machaon] diamond 207 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio machaon
31053535 31053535 PRJNA1253698_S_NODE_13895_length_188_cov_1.848921_g13529_i0 PRJNA1253698 13895 188 1.848921 3.47597148 Papilio machaon 76193 Arthropoda Arthropoda 95.1 3.1e-21   NR XP_014363629.2 76193 g13529 i0 72.6 1.96276595744681 62 17 98.9 0 187 2 236 297 XP_014363629.2 antichymotrypsin-2 isoform X2 [Papilio machaon] diamond 369 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio machaon
31053538 31053538 PRJNA1253698_S_NODE_3735_length_360_cov_7.160772_g3369_i0 PRJNA1253698 3735 360 7.160772 25.7787792 Papilio xuthus 66420 Arthropoda Arthropoda 150 2.41e-43   NR KPJ04152.1 66420 g3369 i0 68.9 0.883333333333333 106 29 85 1 360 55 101 206 KPJ04152.1 hypothetical protein RR46_07911 [Papilio xuthus] diamond 318 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
31432604 31432604 PRJNA1253698_S_NODE_12776_length_195_cov_1.404110_g12410_i0 PRJNA1253698 12776 195 1.40411 2.7380145 Parnassius apollo 110799 Arthropoda Arthropoda 114 6.42e-28   NR CAG5001079.1 110799 g12410 i0 87.5 4.92307692307692 64 8 98.5 0 194 3 306 369 CAG5001079.1 unnamed protein product [Parnassius apollo] diamond 960 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo
31622333 31622333 PRJNA1253698_S_NODE_15556_length_179_cov_1.576923_g15190_i0 PRJNA1253698 15556 179 1.576923 2.82269217 Papilio xuthus 66420 Arthropoda Arthropoda 41.6 0.0127   NR NP_001299341.1 66420 g15190 i0 80 0.921787709497207 55 3 92.2 2 168 4 29 75 NP_001299341.1 keratin-associated protein 19-2-like precursor [Papilio xuthus] diamond 165 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
31685534 31685534 PRJNA1253698_S_NODE_18457_length_168_cov_1.075630_g18091_i0 PRJNA1253698 18457 168 1.07563 1.8070584 Papilio xuthus 66420 Arthropoda Arthropoda 75.1 5.16e-14   NR KPI94090.1 66420 g18091 i0 89.5 1.35714285714286 38 4 67.9 0 116 3 24 61 KPI94090.1 Transferrin [Papilio xuthus] diamond 228 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
31703580 31703580 PRJNA1253698_S_NODE_19697_length_167_cov_0.872881_g19331_i0 PRJNA1253698 19697 167 0.872881 1.45771127 Papilionidae 7143 Arthropoda Arthropoda 85.9 1.23e-18   NR XP_068624257.1 42288 g19331 i0 77.4 1.90419161676647 53 12 95.2 0 8 166 54 106 XP_068624257.1 attacin-like [Battus philenor] diamond 318 86.3 0.995365005793743 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Battus Battus philenor
32051577 32051577 PRJNA1253698_S_NODE_16298_length_175_cov_3.436508_g15932_i0 PRJNA1253698 16298 175 3.436508 6.013889 Lepidoptera 7088 Arthropoda Arthropoda 122 1.0699999999999999e-32   NR NP_001037141.1 7091 g15932 i0 96.6 9.94285714285714 58 2 99.4 0 174 1 64 121 NP_001037141.1 ribosomal protein L8 [Bombyx mori] diamond 1740 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
32368240 32368240 PRJNA1253698_S_NODE_13399_length_191_cov_1.809859_g13033_i0 PRJNA1253698 13399 191 1.809859 3.45683069 Papilionidae 7143 Arthropoda Arthropoda 73.6 2.47e-13   NR XP_013164713.1 66420 g13033 i0 84 2.56020942408377 50 8 78.5 0 151 2 213 262 XP_013164713.1 PREDICTED: fibrous sheath CABYR-binding protein [Papilio xuthus] diamond 489 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
32729015 32729015 PRJNA1253698_S_NODE_11060_length_208_cov_0.874214_g10694_i0 PRJNA1253698 11060 208 0.874214 1.81836512 Papilio xuthus 66420 Arthropoda Arthropoda 45.1 0.00276   NR NP_001299772.1 66420 g10694 i0 83.3 0.432692307692308 30 5 43.3 0 3 92 70 99 NP_001299772.1 uncharacterized protein LOC106122233 precursor [Papilio xuthus] diamond 90 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
32729016 32729016 PRJNA1253698_S_NODE_24440_length_154_cov_2.876190_g24074_i0 PRJNA1253698 24440 154 2.87619 4.4293326 Homalodisca vitripennis 197043 Arthropoda Arthropoda 40 0.0486   NR KAG8241529.1 197043 g24074 i0 53.1 0.623376623376623 32 15 62.3 0 111 16 89 120 KAG8241529.1 hypothetical protein J6590_085021 [Homalodisca vitripennis] diamond 96 40 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis

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