RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA558770 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
26730329 26730329 PRJNA558770_P_NODE_272161_length_234_cov_1.869347_g270156_i0 PRJNA558770 272161 234 1.869347 4.37427198 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 67 9.23e-11   NR KAG9510425.1 1670756 g270156 i0 47.2 1.14102564102564 89 35 98.7 1 232 2 831 919 KAG9510425.1 ATP-binding cassette sub-family G member 1, partial [Fragariocoptes setiger] diamond 267 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
26730350 26730350 PRJNA558770_P_NODE_48881_length_307_cov_5.713235_g46879_i0 PRJNA558770 48881 307 5.713235 17.53963145 Penaeus vannamei 6689 Arthropoda Arthropoda 46.2 0.0045   NR ROT81006.1 6689 g46879 i0 40 1.02605863192182 105 47 87.9 7 270 1 188 291 ROT81006.1 hypothetical protein C7M84_000246 [Penaeus vannamei] diamond 315 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
26934728 26934728 PRJNA558770_P_NODE_211062_length_234_cov_3.376884_g209057_i0 PRJNA558770 211062 234 3.376884 7.90190856 Oppiidae 229795 Arthropoda Arthropoda 55.1 1.5e-6   NR XP_054164630.1 1686743 g209057 i0 100 0.641025641025641 25 0 32.1 0 233 159 291 315 XP_054164630.1 zinc finger protein Xfin-like [Oppia nitens] diamond 150 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
27173523 27173523 PRJNA558770_P_NODE_215142_length_234_cov_3.246231_g213137_i0 PRJNA558770 215142 234 3.246231 7.59618054 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 50.4 6.16e-5   NR KAF7277658.1 354439 g213137 i0 91.3 0.294871794871795 23 2 29.5 0 234 166 18 40 KAF7277658.1 hypothetical protein GWI33_000987, partial [Rhynchophorus ferrugineus] diamond 69 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
27661800 27661800 PRJNA558770_P_NODE_270404_length_234_cov_1.899497_g268399_i0 PRJNA558770 270404 234 1.899497 4.44482298 Insecta 50557 Arthropoda Arthropoda 46.6 0.00143   NR KAI8121965.1 7375 g268399 i0 73.9 1.79487179487179 23 6 29.5 0 166 234 16 38 KAI8121965.1 isoform B, Protein msta [Lucilia cuprina] diamond 420 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
28057980 28057980 PRJNA558770_P_NODE_235805_length_234_cov_2.648241_g233800_i0 PRJNA558770 235805 234 2.648241 6.19688394 Galendromus occidentalis 34638 Arthropoda Arthropoda 49.7 1.11e-4   NR XP_018497633.1 34638 g233800 i0 78.3 0.897435897435897 23 5 29.5 0 230 162 305 327 XP_018497633.1 ankyrin repeat and MYND domain-containing protein 2 [Galendromus occidentalis] diamond 210 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
28278811 28278811 PRJNA558770_P_NODE_121186_length_234_cov_9.065327_g119181_i0 PRJNA558770 121186 234 9.065327 21.21286518 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 46.6 0.00141   NR XP_055298589.1 263140 g119181 i0 88 0.320512820512821 25 3 32.1 0 232 158 328 352 XP_055298589.1 annexin B11 isoform X1 [Sitodiplosis mosellana] diamond 75 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
28278814 28278814 PRJNA558770_P_NODE_129586_length_234_cov_8.150754_g127581_i0 PRJNA558770 129586 234 8.150754 19.07276436 Ixodes hexagonus 34612 Arthropoda Arthropoda 47.8 5.77e-4   NR CAL6189993.1 34612 g127581 i0 79.2 0.307692307692308 24 5 30.8 0 74 3 2017 2040 CAL6189993.1 unnamed protein product [Ixodes hexagonus] diamond 72 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes hexagonus
28924403 28924403 PRJNA558770_P_NODE_189828_length_234_cov_4.190955_g187823_i0 PRJNA558770 189828 234 4.190955 9.8068347 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42.7 0.0338   NR KAG0429953.1 34615 g187823 i0 60.9 0.833333333333333 23 9 29.5 0 227 159 1519 1541 KAG0429953.1 hypothetical protein HPB47_023132 [Ixodes persulcatus] diamond 195 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus
29163359 29163359 PRJNA558770_P_NODE_196549_length_234_cov_3.919598_g194544_i0 PRJNA558770 196549 234 3.919598 9.17185932 Idotea baltica 82763 Arthropoda Arthropoda 63.2 1.92e-9   NR MCL4141331.1 82763 g194544 i0 44.2 0.987179487179487 77 43 98.7 0 2 232 38 114 MCL4141331.1 hypothetical protein [Idotea baltica] diamond 231 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29636385 29636385 PRJNA558770_P_NODE_329050_length_233_cov_6.484848_g327045_i0 PRJNA558770 329050 233 6.484848 15.10969584 Vollenhovia emeryi 411798 Arthropoda Arthropoda 54.3 2.68e-6   NR XP_011860581.1 411798 g327045 i0 37.6 4.41630901287554 93 42 99.1 1 232 2 148 240 XP_011860581.1 PREDICTED: queuine tRNA-ribosyltransferase-like [Vollenhovia emeryi] diamond 1029 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi
29808523 29808523 PRJNA558770_P_NODE_165831_length_234_cov_5.402010_g163826_i0 PRJNA558770 165831 234 5.40201 12.6407034 Insecta 50557 Arthropoda Arthropoda 42.7 0.0337   NR XP_058983670.1 7370 g163826 i0 78.3 0.602564102564103 23 5 29.5 0 71 3 257 279 XP_058983670.1 uncharacterized protein K02A2.6-like [Musca domestica] diamond 141 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica
29966651 29966651 PRJNA558770_P_NODE_29971_length_392_cov_3.773109_g28002_i0 PRJNA558770 29971 392 3.773109 14.79058728 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.4 7.25e-5   NR GBL88962.1 182803 g28002 i0 91.7 0.75765306122449 24 2 18.4 0 5 76 76 99 GBL88962.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Araneus ventricosus] diamond 297 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31437690 31437690 PRJNA558770_P_NODE_343016_length_233_cov_2.994949_g341011_i0 PRJNA558770 343016 233 2.994949 6.97823117 Drosophila ficusphila 30025 Arthropoda Arthropoda 43.5 0.0167   NR XP_017061640.2 30025 g341011 i0 77.8 0.811158798283262 18 4 23.2 0 213 160 258 275 XP_017061640.2 uncharacterized protein LOC108101712 [Drosophila ficusphila] diamond 189 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ficusphila
31690691 31690691 PRJNA558770_P_NODE_15697_length_488_cov_4.333333_g13924_i0 PRJNA558770 15697 488 4.333333 21.14666504 Eumeta japonica 151549 Arthropoda Arthropoda 56.6 1.7e-6   NR GBP70680.1 151549 g13924 i0 45.3 1.22950819672131 53 29 32.6 0 323 165 10 62 GBP70680.1 hypothetical protein EVAR_88855_1 [Eumeta japonica] diamond 600 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Psychidae Eumeta Eumeta japonica
31957851 31957851 PRJNA558770_P_NODE_288397_length_234_cov_1.597990_g286392_i0 PRJNA558770 288397 234 1.59799 3.7392966 Tetranychidae 32262 Arthropoda Arthropoda 54.3 2.73e-6   NR XP_015795541.1 32264 g286392 i0 91.7 0.923076923076923 24 2 30.8 0 3 74 61 84 XP_015795541.1 pikachurin isoform X2 [Tetranychus urticae] diamond 216 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
32007134 32007134 PRJNA558770_P_NODE_112998_length_234_cov_10.140704_g110993_i0 PRJNA558770 112998 234 10.140704 23.72924736 Tetranychus urticae 32264 Arthropoda Arthropoda 47.8 5.64e-4   NR XP_015795200.1 32264 g110993 i0 88.5 0.333333333333333 26 1 30.8 1 161 232 547 572 XP_015795200.1 probable serine/threonine-protein kinase DDB_G0282963 [Tetranychus urticae] diamond 78 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
32418559 32418559 PRJNA558770_P_NODE_235619_length_234_cov_2.653266_g233614_i0 PRJNA558770 235619 234 2.653266 6.20864244 Darwinula stevensoni 69355 Arthropoda Arthropoda 60.8 1.36e-8   NR CAD7250140.1 69355 g233614 i0 47.4 0.974358974358974 76 30 97.4 1 230 3 117 182 CAD7250140.1 unnamed protein product, partial [Darwinula stevensoni] diamond 228 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
32513715 32513715 PRJNA558770_P_NODE_320199_length_233_cov_8.838384_g318194_i0 PRJNA558770 320199 233 8.838384 20.59343472 Allacma fusca 39272 Arthropoda Arthropoda 50.4 6.24e-5   NR CAG7681524.1 39272 g318194 i0 91.7 0.309012875536481 24 2 30.9 0 161 232 252 275 CAG7681524.1 unnamed protein product [Allacma fusca] diamond 72 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca

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