RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA385396 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
4233923 4233923 PRJNA385396_P_NODE_1484_length_600_cov_1.203036_g1392_i0 PRJNA385396 1484 600 1.203036 7.218216 Culicidae 7157 Arthropoda Arthropoda 158 4.62e-43   NR XP_053691561.1 53552 g1392 i0 52.2 2.725 182 80 91 3 600 55 60 234 XP_053691561.1 40S ribosomal protein S6 [Sabethes cyaneus] diamond 1635 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Sabethes Sabethes cyaneus
4904551 4904551 PRJNA385396_P_NODE_4584_length_375_cov_1.529801_g4492_i0 PRJNA385396 4584 375 1.529801 5.73675375 Lepidoptera 7088 Arthropoda Arthropoda 162 1.8899999999999998e-46   NR CAG9575604.1 151541 g4492 i0 68.4 16.672 114 36 91.2 0 343 2 13 126 CAG9575604.1 unnamed protein product [Danaus chrysippus] diamond 6252 163 0.993865030674847 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Danaus Danaus chrysippus
9334941 9334941 PRJNA385396_P_NODE_1468_length_601_cov_2.373106_g1376_i0 PRJNA385396 1468 601 2.373106 14.26236706 Sarcoptiformes 83137 Arthropoda Arthropoda 154 1.52e-42   NR XP_027202755.1 6956 g1376 i0 49.2 2.68053244592346 181 85 88.9 3 542 9 47 223 XP_027202755.1 60S ribosomal protein L7-like [Dermatophagoides pteronyssinus] diamond 1611 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
10610969 10610969 PRJNA385396_P_NODE_7809_length_313_cov_1.262500_g7717_i0 PRJNA385396 7809 313 1.2625 3.951625 Opisthokonta 33154 Arthropoda Arthropoda 132 2.13e-33   NR XP_045623812.2 6728 g7717 i0 66.3 9.90095846645367 101 28 96.8 1 313 11 571 665 XP_045623812.2 trifunctional purine biosynthetic protein adenosine-3 [Procambarus clarkii] diamond 3099 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
11885677 11885677 PRJNA385396_P_NODE_21170_length_241_cov_0.916667_g21078_i0 PRJNA385396 21170 241 0.916667 2.20916747 Opisthokonta 33154 Arthropoda Arthropoda 112 2.25e-28   NR KAH0810461.1 7067 g21078 i0 68.4 24.4356846473029 79 25 98.3 0 239 3 7 85 KAH0810461.1 hypothetical protein GEV33_012331 [Tenebrio molitor] diamond 5889 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
26758601 26758601 PRJNA385396_P_NODE_20841_length_242_cov_0.911243_g20749_i0 PRJNA385396 20841 242 0.911243 2.20520806 Parnassius mnemosyne 213953 Arthropoda Arthropoda 114 2.07e-28   NR CAK1584745.1 213953 g20749 i0 65.4 3.89256198347107 78 27 96.7 0 241 8 54 131 CAK1584745.1 unnamed protein product [Parnassius mnemosyne] diamond 942 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius mnemosyne
27281819 27281819 PRJNA385396_P_NODE_18343_length_245_cov_0.895349_g18251_i0 PRJNA385396 18343 245 0.895349 2.19360505 Apidae 7458 Arthropoda Arthropoda 62.4 4.61e-9   NR XP_017892960.1 156304 g18251 i0 43.5 4.22448979591837 69 39 84.5 0 209 3 988 1056 XP_017892960.1 uncharacterized protein LOC108632725 isoform X1 [Ceratina calcarata] diamond 1035 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Ceratina Ceratina calcarata
27296470 27296470 PRJNA385396_P_NODE_13723_length_251_cov_0.865169_g13631_i0 PRJNA385396 13723 251 0.865169 2.17157419 Orchesella dallaii 48710 Arthropoda Arthropoda 89 2.24e-18   NR CAL8139601.1 48710 g13631 i0 43.8 1.93625498007968 80 42 92 1 3 233 202 281 CAL8139601.1 unnamed protein product [Orchesella dallaii] diamond 486 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
28591197 28591197 PRJNA385396_P_NODE_17827_length_245_cov_1.790698_g17735_i0 PRJNA385396 17827 245 1.790698 4.3872101 Anthonomus grandis grandis 2921223 Arthropoda Arthropoda 86.3 1.02e-17   NR XP_050308051.1 2921223 g17735 i0 50.6 1.99591836734694 81 37 99.2 1 243 1 136 213 XP_050308051.1 nucleosome assembly protein 1-like 1 [Anthonomus grandis grandis] diamond 489 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis
29506658 29506658 PRJNA385396_P_NODE_16990_length_247_cov_0.885057_g16898_i0 PRJNA385396 16990 247 0.885057 2.18609079 Schistocerca gregaria 7010 Arthropoda Arthropoda 80.9 7.5e-16   NR XP_049849742.1 7010 g16898 i0 52.8 0.874493927125506 72 33 87.4 1 29 244 37 107 XP_049849742.1 myosin light chain kinase A-like isoform X2 [Schistocerca gregaria] diamond 216 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30028988 30028988 PRJNA385396_P_NODE_14991_length_249_cov_0.875000_g14899_i0 PRJNA385396 14991 249 0.875 2.17875 Metazoa 33208 Arthropoda Arthropoda 80.1 2.5e-15   NR XP_030745757.1 7048 g14899 i0 53.1 63.0963855421687 81 32 97.6 1 3 245 248 322 XP_030745757.1 tubulin alpha-3 chain-like [Sitophilus oryzae] diamond 15711 80.5 0.995031055900621 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
30123510 30123510 PRJNA385396_P_NODE_6792_length_328_cov_1.207843_g6700_i0 PRJNA385396 6792 328 1.207843 3.96172504 Metazoa 33208 Arthropoda Arthropoda 135 4.27e-38   NR XP_046822813.1 7445 g6700 i0 65.4 65.625 107 36 97.9 1 326 6 23 128 XP_046822813.1 40S ribosomal protein S15 [Vespa crabro] diamond 21525 136 0.992647058823529 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespa Vespa crabro
30186737 30186737 PRJNA385396_P_NODE_11632_length_267_cov_1.443299_g11540_i0 PRJNA385396 11632 267 1.443299 3.85360833 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 118 8.4e-32   NR NP_001286410.1 7227 g11540 i0 76.7 122.921348314607 73 17 82 0 18 236 70 142 NP_001286410.1 ribosomal protein S23, isoform B [Drosophila melanogaster] diamond 32820 119 0.991596638655462 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
30580524 30580524 PRJNA385396_P_NODE_5913_length_343_cov_3.670370_g5821_i0 PRJNA385396 5913 343 3.67037 12.5893691 Artemia franciscana 6661 Arthropoda Arthropoda 50.4 2.15e-4   NR XP_065584265.1 6661 g5821 i0 37.7 3.01749271137026 69 39 57.7 3 127 324 282 349 XP_065584265.1 CUB and sushi domain-containing protein 3-like, partial [Artemia franciscana] diamond 1035 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30707054 30707054 PRJNA385396_P_NODE_6294_length_337_cov_0.905303_g6202_i0 PRJNA385396 6294 337 0.905303 3.05087111 Hermetia illucens 343691 Arthropoda Arthropoda 102 3.509999999999999e-23   NR XP_037921752.1 343691 g6202 i0 48.1 0.961424332344214 108 54 94.4 1 323 6 197 304 XP_037921752.1 zinc metalloproteinase nas-4 [Hermetia illucens] diamond 324 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
31560786 31560786 PRJNA385396_P_NODE_1096_length_675_cov_2.822259_g1006_i0 PRJNA385396 1096 675 2.822259 19.05024825 Trichonephila inaurata madagascariensis 2747483 Arthropoda Arthropoda 118 8.57e-30   NR GFY53213.1 2747483 g1006 i0 61.8 2.81777777777778 102 35 45.3 1 331 26 35 132 GFY53213.1 histone H3.3a [Trichonephila inaurata madagascariensis] diamond 1902 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila inaurata
31609120 31609120 PRJNA385396_P_NODE_9576_length_289_cov_1.425926_g9484_i0 PRJNA385396 9576 289 1.425926 4.12092614 Metazoa 33208 Arthropoda Arthropoda 129 1.11e-36   NR XP_018915631.1 7038 g9484 i0 73.1 104.792387543253 78 21 81 0 5 238 6 83 XP_018915631.1 PREDICTED: 40S ribosomal protein S27-like [Bemisia tabaci] diamond 30285 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
31750211 31750211 PRJNA385396_P_NODE_3697_length_405_cov_1.156627_g3605_i0 PRJNA385396 3697 405 1.156627 4.68433935 Uranotaenia lowii 190385 Arthropoda Arthropoda 97.4 1.82e-20   NR XP_055604917.1 190385 g3605 i0 44 0.925925925925926 125 68 92.6 2 402 28 590 712 XP_055604917.1 uncharacterized protein K02A2.6-like [Uranotaenia lowii] diamond 375 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii

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