RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1061474" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1061474 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
6556825 6556825 PRJNA1061474_P_NODE_48846_length_248_cov_0.880000_g48600_i0 PRJNA1061474 48846 248 0.88 2.1824 Planococcus citri 170843 Arthropoda Arthropoda 103 2.69e-26   NR XP_065205371.1 170843 g48600 i0 69.3 0.907258064516129 75 21 90.7 1 225 1 1 73 XP_065205371.1 endocuticle structural glycoprotein SgAbd-4-like [Planococcus citri] diamond 225 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Planococcus Planococcus citri
26592014 26592014 PRJNA1061474_P_NODE_56341_length_242_cov_0.911243_g56095_i0 PRJNA1061474 56341 242 0.911243 2.20520806 Trichonephila inaurata madagascariensis 2747483 Arthropoda Arthropoda 81.6 1.17e-16   NR GFS51856.1 2747483 g56095 i0 63.8 2.56611570247934 69 19 78.1 1 189 1 72 140 GFS51856.1 putative DD41D transposase [Trichonephila inaurata madagascariensis] diamond 621 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila inaurata
26908933 26908933 PRJNA1061474_P_NODE_57482_length_241_cov_0.916667_g57236_i0 PRJNA1061474 57482 241 0.916667 2.20916747 Spodoptera litura 69820 Arthropoda Arthropoda 63.9 1.2e-9   NR XP_022816623.1 69820 g57236 i0 45.5 1.80497925311203 66 35 82.2 1 206 9 403 467 XP_022816623.1 uncharacterized protein LOC111349653 [Spodoptera litura] diamond 435 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera litura
26940401 26940401 PRJNA1061474_P_NODE_20802_length_428_cov_1.081690_g20556_i0 PRJNA1061474 20802 428 1.08169 4.6296332 Coptotermes formosanus 36987 Arthropoda Arthropoda 64.7 1.69e-9   NR AEW67351.1 36987 g20556 i0 48.5 0.462616822429907 66 32 46.3 2 5 202 89 152 AEW67351.1 carbohydrate binding module, partial [Coptotermes formosanus] diamond 198 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
27098654 27098654 PRJNA1061474_P_NODE_39182_length_284_cov_1.369668_g38936_i0 PRJNA1061474 39182 284 1.369668 3.88985712 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 43.1 0.0432   NR KAF7268851.1 354439 g38936 i0 32.8 0.644366197183099 61 40 64.4 1 220 38 297 356 KAF7268851.1 hypothetical protein GWI33_018049 [Rhynchophorus ferrugineus] diamond 183 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
27193383 27193383 PRJNA1061474_P_NODE_50862_length_247_cov_0.885057_g50616_i0 PRJNA1061474 50862 247 0.885057 2.18609079 Spodoptera frugiperda 7108 Arthropoda Arthropoda 46.2 0.00241   NR KAF9803950.1 7108 g50616 i0 59.5 1.37246963562753 37 14 43.7 1 25 132 496 532 KAF9803950.1 hypothetical protein SFRURICE_000488 [Spodoptera frugiperda] diamond 339 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
27635897 27635897 PRJNA1061474_P_NODE_54164_length_244_cov_0.900585_g53918_i0 PRJNA1061474 54164 244 0.900585 2.1974274 Folsomia candida 158441 Arthropoda Arthropoda 87.8 5.07e-18   NR OXA63992.1 158441 g53918 i0 48.7 4.80737704918033 76 39 93.4 0 12 239 133 208 OXA63992.1 Transposable element Tcb1 transposase [Folsomia candida] diamond 1173 87.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
27722667 27722667 PRJNA1061474_P_NODE_27464_length_359_cov_1.346154_g27218_i0 PRJNA1061474 27464 359 1.346154 4.83269286 Arthropoda 6656 Arthropoda Arthropoda 84 5.38e-16   NR XP_063236956.1 93214 g27218 i0 73.6 4.06128133704735 53 14 44.3 0 1 159 2086 2138 XP_063236956.1 phospholipid-transporting ATPase ABCA7-like isoform X2 [Bacillus rossius redtenbacheri] diamond 1458 84.3 0.99644128113879 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
27762314 27762314 PRJNA1061474_P_NODE_9204_length_707_cov_1.853312_g8979_i0 PRJNA1061474 9204 707 1.853312 13.10291584 Limulus polyphemus 6850 Arthropoda Arthropoda 102 3.21e-21   NR XP_013792674.1 6850 g8979 i0 41.2 0.628005657708628 148 76 60.3 5 127 552 16 158 XP_013792674.1 sequestosome-1-like [Limulus polyphemus] diamond 444 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
27856678 27856678 PRJNA1061474_P_NODE_45945_length_251_cov_0.865169_g45699_i0 PRJNA1061474 45945 251 0.865169 2.17157419 Dalotia coriaria 877792 Arthropoda Arthropoda 63.2 2.65e-9   NR XP_065159298.1 877792 g45699 i0 46.7 2.59362549800797 75 39 89.6 1 236 12 802 875 XP_065159298.1 ankyrin repeat domain-containing protein 27-like isoform X2 [Dalotia coriaria] diamond 651 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
27951569 27951569 PRJNA1061474_P_NODE_52145_length_246_cov_0.861272_g51899_i0 PRJNA1061474 52145 246 0.861272 2.11872912 Idotea baltica 82763 Arthropoda Arthropoda 158 9.209999999999999e-48   NR MCL4118167.1 82763 g51899 i0 93.8 0.98780487804878 81 5 98.8 0 2 244 56 136 MCL4118167.1 hypothetical protein [Idotea baltica] diamond 243 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28203869 28203869 PRJNA1061474_P_NODE_41166_length_273_cov_1.540000_g40920_i0 PRJNA1061474 41166 273 1.54 4.2042 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 80.9 1.49e-16   NR ADD38186.1 72036 g40920 i0 44.9 0.857142857142857 78 43 85.7 0 249 16 59 136 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 234 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
28267024 28267024 PRJNA1061474_P_NODE_50066_length_247_cov_0.885057_g49820_i0 PRJNA1061474 50066 247 0.885057 2.18609079 Maconellicoccus hirsutus 177089 Arthropoda Arthropoda 161 2.27e-49   NR ABM55607.1 177089 g49820 i0 95.1 0.995951417004049 82 4 99.6 0 246 1 23 104 ABM55607.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit DAD1-like protein [Maconellicoccus hirsutus] diamond 246 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Maconellicoccus Maconellicoccus hirsutus
29206428 29206428 PRJNA1061474_P_NODE_39349_length_283_cov_1.466667_g39103_i0 PRJNA1061474 39349 283 1.466667 4.15066761 Metazoa 33208 Arthropoda Arthropoda 191 1.44e-58   NR XP_042220636.1 6706 g39103 i0 100 95.6395759717314 94 0 99.6 0 282 1 38 131 XP_042220636.1 26S proteasome regulatory subunit 7 [Homarus americanus] diamond 27066 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
29246023 29246023 PRJNA1061474_P_NODE_55349_length_243_cov_0.905882_g55103_i0 PRJNA1061474 55349 243 0.905882 2.20129326 Trichonephila clavipes 2585209 Arthropoda Arthropoda 45.1 8.78e-4   NR GFY00891.1 2585209 g55103 i0 43.4 0.654320987654321 53 30 65.4 0 26 184 1 53 GFY00891.1 hypothetical protein TNCV_4529101 [Trichonephila clavipes] diamond 159 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29521910 29521910 PRJNA1061474_P_NODE_24590_length_386_cov_0.977636_g24344_i0 PRJNA1061474 24590 386 0.977636 3.77367496 Opisthokonta 33154 Arthropoda Arthropoda 50.1 1.89e-4   NR CAL4073750.1 48144 g24344 i0 67.9 1.27461139896373 28 9 21.8 0 384 301 2 29 CAL4073750.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 492 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
29719355 29719355 PRJNA1061474_P_NODE_26950_length_363_cov_1.858621_g26704_i0 PRJNA1061474 26950 363 1.858621 6.74679423 Idotea baltica 82763 Arthropoda Arthropoda 188 5.99e-58   NR MCL4121308.1 82763 g26704 i0 69.4 3 121 37 100 0 1 363 10 130 MCL4121308.1 hypothetical protein [Idotea baltica] diamond 1089 188 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30438230 30438230 PRJNA1061474_P_NODE_4953_length_989_cov_1.792576_g4778_i0 PRJNA1061474 4953 989 1.792576 17.72857664 Metazoa 33208 Arthropoda Arthropoda 64.3 4.53e-9   NR XP_037784063.1 6687 g4778 i0 47.5 2.23862487360971 61 32 18.5 0 105 287 13 73 XP_037784063.1 selenoprotein W-like isoform X1 [Penaeus monodon] diamond 2214 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
30572370 30572370 PRJNA1061474_P_NODE_47593_length_249_cov_1.267045_g47347_i0 PRJNA1061474 47593 249 1.267045 3.15494205 Scylla paramamosain 85552 Arthropoda Arthropoda 120 1.35e-29   NR KAK8374182.1 85552 g47347 i0 98.3 28.5180722891566 58 1 69.9 0 175 2 74 131 KAK8374182.1 hypothetical protein O3P69_018917 [Scylla paramamosain] diamond 7101 121 0.991735537190083 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31457680 31457680 PRJNA1061474_P_NODE_50736_length_247_cov_0.885057_g50490_i0 PRJNA1061474 50736 247 0.885057 2.18609079 Dryococelus australis 614101 Arthropoda Arthropoda 46.6 0.00169   NR KAJ8886800.1 614101 g50490 i0 36.8 1.54251012145749 68 35 82.6 1 25 228 330 389 KAJ8886800.1 hypothetical protein PR048_013012 [Dryococelus australis] diamond 381 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Phasmatidae Dryococelus Dryococelus australis
31805417 31805417 PRJNA1061474_P_NODE_28317_length_352_cov_2.792115_g28071_i0 PRJNA1061474 28317 352 2.792115 9.8282448 Acromyrmex charruanus 2715315 Arthropoda Arthropoda 187 6.319999999999999e-55   NR KAG5344077.1 2715315 g28071 i0 100 58.9005681818182 91 0 77.6 0 78 350 290 380 KAG5344077.1 ARF1 factor, partial [Acromyrmex charruanus] diamond 20733 188 0.99468085106383 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Acromyrmex Acromyrmex charruanus
32145326 32145326 PRJNA1061474_P_NODE_51558_length_246_cov_0.890173_g51312_i0 PRJNA1061474 51558 246 0.890173 2.18982558 Metazoa 33208 Arthropoda Arthropoda 160 1.62e-43   NR XP_059090445.1 6832 g51312 i0 98.8 149.146341463415 81 1 98.8 0 244 2 1203 1283 XP_059090445.1 pre-mRNA-processing-splicing factor 8-like [Tigriopus californicus] diamond 36690 161 0.993788819875776 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
32398504 32398504 PRJNA1061474_P_NODE_25319_length_379_cov_0.928105_g25073_i0 PRJNA1061474 25319 379 0.928105 3.51751795 Drosophila 7215 Arthropoda Arthropoda 195 7.35e-58   NR NP_001260276.1 7227 g25073 i0 95.9 116.667546174142 97 4 76.8 0 377 87 222 318 NP_001260276.1 alien, isoform D [Drosophila melanogaster] diamond 44217 196 0.994897959183674 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
32430107 32430107 PRJNA1061474_P_NODE_27879_length_356_cov_1.084806_g27633_i0 PRJNA1061474 27879 356 1.084806 3.86190936 Metazoa 33208 Arthropoda Arthropoda 174 1.54e-50   NR PSN51752.1 6973 g27633 i0 98.9 40.3230337078652 87 1 73.3 0 356 96 297 383 PSN51752.1 26S protease regulatory subunit 7 [Blattella germanica] diamond 14355 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica

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