RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA603943" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA603943 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
576431 576431 PRJNA603943_P_NODE_1281_length_1188_cov_2.084305_g1160_i0 PRJNA603943 1281 1188 2.084305 24.7615434 Arthropoda 6656 Arthropoda Arthropoda 399 7.599999999999999e-134   NR KAG8230017.1 123851 g1160 i0 62.6 3.32575757575758 329 89 82.1 4 3 977 86 384 KAG8230017.1 hypothetical protein J437_LFUL008458 [Ladona fulva] diamond 3951 400 0.9975 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
26966620 26966620 PRJNA603943_P_NODE_51182_length_255_cov_1.675824_g50990_i0 PRJNA603943 51182 255 1.675824 4.2733512 Timema 61471 Arthropoda Arthropoda 55.8 1.05e-6   NR CAD7569983.1 61474 g50990 i0 43.1 5.91764705882353 72 35 77.6 2 24 221 894 965 CAD7569983.1 unnamed protein product, partial [Timema californicum] diamond 1509 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
27016625 27016625 PRJNA603943_P_NODE_53942_length_251_cov_0.865169_g53750_i0 PRJNA603943 53942 251 0.865169 2.17157419 Cryptotermes secundus 105785 Arthropoda Arthropoda 50.4 7.34e-5   NR PNF42432.1 105785 g53750 i0 64.7 1.62549800796813 34 12 40.6 0 197 96 254 287 PNF42432.1 hypothetical protein B7P43_G10116 [Cryptotermes secundus] diamond 408 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
27946094 27946094 PRJNA603943_P_NODE_59905_length_247_cov_0.885057_g59713_i0 PRJNA603943 59905 247 0.885057 2.18609079 Metazoa 33208 Arthropoda Arthropoda 67 1.13e-10   NR KAH8042682.1 6941 g59713 i0 44.6 9.98380566801619 83 44 99.6 2 246 1 540 621 KAH8042682.1 hypothetical protein HPB51_025314 [Rhipicephalus microplus] diamond 2466 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
28343253 28343253 PRJNA603943_P_NODE_51406_length_255_cov_0.796703_g51214_i0 PRJNA603943 51406 255 0.796703 2.03159265 Diaphorina citri 121845 Arthropoda Arthropoda 44.3 0.0124   NR KAI5734539.1 121845 g51214 i0 44 0.588235294117647 50 26 58.8 1 223 74 448 495 KAI5734539.1 hypothetical protein M8J77_007690 [Diaphorina citri] diamond 150 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
28451413 28451413 PRJNA603943_P_NODE_33966_length_313_cov_1.616667_g33774_i0 PRJNA603943 33966 313 1.616667 5.06016771 Delphacidae 33362 Arthropoda Arthropoda 112 9.19e-29   NR XP_022204224.2 108931 g33774 i0 60 5.3482428115016 90 35 85.3 1 5 271 101 190 XP_022204224.2 peroxiredoxin-5, mitochondrial [Nilaparvata lugens] diamond 1674 113 0.991150442477876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
28879923 28879923 PRJNA603943_P_NODE_55208_length_250_cov_0.870056_g55016_i0 PRJNA603943 55208 250 0.870056 2.17514 Nephila pilipes 299642 Arthropoda Arthropoda 64.3 2.92e-11   NR GFT69195.1 299642 g55016 i0 58.5 1.968 41 17 49.2 0 248 126 52 92 GFT69195.1 endothelin-converting enzyme 1 [Nephila pilipes] diamond 492 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
29038137 29038137 PRJNA603943_P_NODE_66628_length_243_cov_0.905882_g66436_i0 PRJNA603943 66628 243 0.905882 2.20129326 Polistes dominula 743375 Arthropoda Arthropoda 88.2 3.7e-18   NR XP_015176334.1 743375 g66436 i0 58.5 0.802469135802469 65 27 80.2 0 196 2 195 259 XP_015176334.1 PREDICTED: LOW QUALITY PROTEIN: protein Red-like [Polistes dominula] diamond 195 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes dominula
29132765 29132765 PRJNA603943_P_NODE_53029_length_251_cov_0.865169_g52837_i0 PRJNA603943 53029 251 0.865169 2.17157419 Agrilus planipennis 224129 Arthropoda Arthropoda 50.4 7.83e-5   NR XP_018329103.1 224129 g52837 i0 63.9 0.860557768924303 36 13 43 0 111 4 26 61 XP_018329103.1 peptidylprolyl isomerase domain and WD repeat-containing protein 1 [Agrilus planipennis] diamond 216 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
29574415 29574415 PRJNA603943_P_NODE_62190_length_246_cov_0.890173_g61998_i0 PRJNA603943 62190 246 0.890173 2.18982558 Cryptotermes secundus 105785 Arthropoda Arthropoda 51.6 4.38e-6   NR PNF26846.1 105785 g61998 i0 47.9 2.28048780487805 48 25 58.5 0 99 242 50 97 PNF26846.1 hypothetical protein B7P43_G16843, partial [Cryptotermes secundus] diamond 561 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
29605867 29605867 PRJNA603943_P_NODE_59470_length_247_cov_0.885057_g59278_i0 PRJNA603943 59470 247 0.885057 2.18609079 Rhipicephalus appendiculatus 34631 Arthropoda Arthropoda 47.8 2.07e-4   NR KAL1441675.1 34631 g59278 i0 50 1.48178137651822 28 14 34 0 3 86 87 114 KAL1441675.1 hypothetical protein MTO96_008397 [Rhipicephalus appendiculatus] diamond 366 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
29637417 29637417 PRJNA603943_P_NODE_62230_length_246_cov_0.890173_g62038_i0 PRJNA603943 62230 246 0.890173 2.18982558 Orchesella dallaii 48710 Arthropoda Arthropoda 107 9.34e-27   NR CAL8145240.1 48710 g62038 i0 63 2.96341463414634 81 27 98.8 2 3 245 65 142 CAL8145240.1 unnamed protein product [Orchesella dallaii] diamond 729 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
29872140 29872140 PRJNA603943_P_NODE_60531_length_247_cov_0.885057_g60339_i0 PRJNA603943 60531 247 0.885057 2.18609079 Metazoa 33208 Arthropoda Arthropoda 117 6.329999999999999e-31   NR NP_001155561.1 7029 g60339 i0 64.1 9.582995951417 78 28 94.7 0 3 236 29 106 NP_001155561.1 ribosomal protein L9 [Acyrthosiphon pisum] diamond 2367 118 0.991525423728814 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
29903793 29903793 PRJNA603943_P_NODE_53991_length_251_cov_0.865169_g53799_i0 PRJNA603943 53991 251 0.865169 2.17157419 Opisthokonta 33154 Arthropoda Arthropoda 68.2 4.5e-11   NR XP_022254238.1 6850 g53799 i0 64.4 8.66533864541833 45 15 53.8 1 4 138 570 613 XP_022254238.1 ribosome biogenesis protein bop1-like [Limulus polyphemus] diamond 2175 68.6 0.994169096209913 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30427942 30427942 PRJNA603943_P_NODE_13053_length_453_cov_1.673684_g12861_i0 PRJNA603943 13053 453 1.673684 7.58178852 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 93.6 6.52e-19   NR XP_023345711.1 1294199 g12861 i0 39.9 3.11920529801325 158 83 99.3 4 4 453 382 535 XP_023345711.1 uncharacterized protein LOC111714758 isoform X1 [Eurytemora carolleeae] diamond 1413 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
30616975 30616975 PRJNA603943_P_NODE_1653_length_1063_cov_1.814141_g1524_i0 PRJNA603943 1653 1063 1.814141 19.28431883 Limulus polyphemus 6850 Arthropoda Arthropoda 100 2.61e-19   NR XP_013792674.1 6850 g1524 i0 41.9 0.38381937911571 136 70 36.7 4 19 408 26 158 XP_013792674.1 sequestosome-1-like [Limulus polyphemus] diamond 408 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30996303 30996303 PRJNA603943_P_NODE_62254_length_246_cov_0.890173_g62062_i0 PRJNA603943 62254 246 0.890173 2.18982558 Phlebotomus argentipes 94469 Arthropoda Arthropoda 60.8 1.23e-8   NR XP_059607846.1 94469 g62062 i0 39.2 3.57317073170732 74 41 90.2 1 233 12 78 147 XP_059607846.1 uncharacterized protein LOC132255728 isoform X3 [Phlebotomus argentipes] diamond 879 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus argentipes
31185525 31185525 PRJNA603943_P_NODE_44795_length_276_cov_1.517241_g44603_i0 PRJNA603943 44795 276 1.517241 4.18758516 Panonychus citri 50023 Arthropoda Arthropoda 92.8 3.6e-20   NR XP_053202221.1 50023 g44603 i0 72.7 3.6195652173913 55 15 59.8 0 272 108 273 327 XP_053202221.1 procathepsin L-like [Panonychus citri] diamond 999 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
31185537 31185537 PRJNA603943_P_NODE_62255_length_246_cov_0.890173_g62063_i0 PRJNA603943 62255 246 0.890173 2.18982558 Penaeus vannamei 6689 Arthropoda Arthropoda 63.9 2.97e-10   NR ROT60748.1 6689 g62063 i0 40.3 1.74390243902439 72 42 86.6 1 244 32 81 152 ROT60748.1 ubiquitin carboxyl-terminal esterase L3 [Penaeus vannamei] diamond 429 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32008250 32008250 PRJNA603943_P_NODE_54978_length_250_cov_0.870056_g54786_i0 PRJNA603943 54978 250 0.870056 2.17514 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 55.5 1.33e-6   NR XP_023327886.1 1294199 g54786 i0 39.7 2.136 58 35 69.6 0 3 176 1124 1181 XP_023327886.1 calmodulin-regulated spectrin-associated protein 3 [Eurytemora carolleeae] diamond 534 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
32261646 32261646 PRJNA603943_P_NODE_36358_length_304_cov_4.004329_g36166_i0 PRJNA603943 36358 304 4.004329 12.17316016 Lamprigera yunnana 370605 Arthropoda Arthropoda 91.3 7.1e-19   NR KAF5282990.1 370605 g36166 i0 56.4 0.927631578947368 94 41 92.8 0 22 303 612 705 KAF5282990.1 hypothetical protein FQA39_LY04861 [Lamprigera yunnana] diamond 282 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Lamprigera Lamprigera yunnana

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