RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA797655 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
18633486 18633486 PRJNA797655_S_NODE_112675_length_234_cov_2.382199_g112070_i0 PRJNA797655 112675 234 2.382199 5.57434566 Allacma fusca 39272 Arthropoda Arthropoda 139 1.53e-39   NR CAG7717009.1 39272 g112070 i0 83.8 0.948717948717949 74 12 94.9 0 3 224 122 195 CAG7717009.1 unnamed protein product [Allacma fusca] diamond 222 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
26832434 26832434 PRJNA797655_S_NODE_109061_length_237_cov_3.046392_g108456_i0 PRJNA797655 109061 237 3.046392 7.21994904 Centruroides vittatus 120091 Arthropoda Arthropoda 42.7 0.034   NR XP_067131710.1 120091 g108456 i0 32.4 0.860759493670886 68 41 86.1 2 16 219 142 204 XP_067131710.1 uncharacterized protein [Centruroides vittatus] diamond 204 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
26958806 26958806 PRJNA797655_S_NODE_92822_length_253_cov_2.700000_g92217_i0 PRJNA797655 92822 253 2.7 6.831 Cryptotermes secundus 105785 Arthropoda Arthropoda 48.5 2.9e-4   NR XP_033611214.1 105785 g92217 i0 47.3 5.21739130434783 55 26 65.2 1 50 214 87 138 XP_033611214.1 general transcription factor II-I repeat domain-containing protein 2-like [Cryptotermes secundus] diamond 1320 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
27022306 27022306 PRJNA797655_S_NODE_128822_length_221_cov_1.617978_g128217_i0 PRJNA797655 128822 221 1.617978 3.57573138 Timema tahoe 61484 Arthropoda Arthropoda 42.4 0.0317   NR CAD7459497.1 61484 g128217 i0 50 0.461538461538462 34 17 46.2 0 103 2 163 196 CAD7459497.1 unnamed protein product [Timema tahoe] diamond 102 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
27022316 27022316 PRJNA797655_S_NODE_35202_length_350_cov_4.214984_g34597_i0 PRJNA797655 35202 350 4.214984 14.752444 Polistes dominula 743375 Arthropoda Arthropoda 44.7 0.0176   NR XP_015189888.1 743375 g34597 i0 36.7 0.84 49 29 42 1 129 275 82 128 XP_015189888.1 PREDICTED: uncharacterized protein LOC107073707 [Polistes dominula] diamond 294 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes dominula
27211764 27211764 PRJNA797655_S_NODE_63222_length_291_cov_2.709677_g62617_i0 PRJNA797655 63222 291 2.709677 7.88516007 Brenthis ino 405034 Arthropoda Arthropoda 43.9 0.0232   NR CAH0718132.1 405034 g62617 i0 34.6 0.536082474226804 52 33 53.6 1 221 66 204 254 CAH0718132.1 unnamed protein product, partial [Brenthis ino] diamond 156 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Brenthis Brenthis ino
27211765 27211765 PRJNA797655_S_NODE_71802_length_278_cov_4.685106_g71197_i0 PRJNA797655 71802 278 4.685106 13.02459468 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 50.1 3.18e-5   NR KDR22370.1 136037 g71197 i0 52 0.539568345323741 50 18 54 1 272 123 15 58 KDR22370.1 hypothetical protein L798_01081 [Zootermopsis nevadensis] diamond 150 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
27284286 27284286 PRJNA797655_S_NODE_249983_length_158_cov_1.669565_g249378_i0 PRJNA797655 249983 158 1.669565 2.6379127000000002 Diptera 7147 Arthropoda Arthropoda 102 8.159999999999999e-24   NR XP_037034774.1 38358 g249378 i0 98.1 4.93670886075949 52 1 98.7 0 158 3 100 151 XP_037034774.1 talin-2 isoform X3 [Bradysia coprophila] diamond 780 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28254005 28254005 PRJNA797655_S_NODE_153326_length_204_cov_1.490683_g152721_i0 PRJNA797655 153326 204 1.490683 3.04099332 Leptotrombidium deliense 299467 Arthropoda Arthropoda 89.7 6.16e-19   NR RWS28314.1 299467 g152721 i0 82.6 1.35294117647059 46 8 67.6 0 3 140 393 438 RWS28314.1 solute carrier organic anion transporter family member 5A1-like protein, partial [Leptotrombidium deliense] diamond 276 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
28538464 28538464 PRJNA797655_S_NODE_180247_length_188_cov_2.648276_g179642_i0 PRJNA797655 180247 188 2.648276 4.97875888 Sipha flava 143950 Arthropoda Arthropoda 44.3 0.00523   NR XP_025416800.1 143950 g179642 i0 54.8 0.49468085106383 31 14 49.5 0 3 95 1191 1221 XP_025416800.1 uncharacterized protein LOC112688008 [Sipha flava] diamond 93 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
28822097 28822097 PRJNA797655_S_NODE_235928_length_163_cov_2.783333_g235323_i0 PRJNA797655 235928 163 2.783333 4.53683279 Bradysia coprophila 38358 Arthropoda Arthropoda 89.4 4.84e-19   NR XP_037038024.1 38358 g235323 i0 79.2 0.883435582822086 48 10 88.3 0 160 17 1965 2012 XP_037038024.1 vitellogenin-A1-like [Bradysia coprophila] diamond 144 89.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28853782 28853782 PRJNA797655_S_NODE_228728_length_166_cov_2.252033_g228123_i0 PRJNA797655 228728 166 2.252033 3.73837478 Rhipicephalus microplus 6941 Arthropoda Arthropoda 45.1 2.36e-4   NR KAL3209959.1 6941 g228123 i0 56.3 1.82530120481928 48 21 86.7 0 17 160 8 55 KAL3209959.1 hypothetical protein MRX96_037597 [Rhipicephalus microplus] diamond 303 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
28916899 28916899 PRJNA797655_S_NODE_216068_length_171_cov_3.750000_g215463_i0 PRJNA797655 216068 171 3.75 6.4125 Cherax quadricarinatus 27406 Arthropoda Arthropoda 41.6 0.0234   NR KAK8719410.1 27406 g215463 i0 60.9 0.807017543859649 46 16 80.7 1 26 163 5 48 KAK8719410.1 hypothetical protein OTU49_014055, partial [Cherax quadricarinatus] diamond 138 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
28916911 28916911 PRJNA797655_S_NODE_73268_length_276_cov_3.673820_g72663_i0 PRJNA797655 73268 276 3.67382 10.1397432 Chionoecetes opilio 41210 Arthropoda Arthropoda 43.1 0.039   NR KAG0719988.1 41210 g72663 i0 39.5 0.467391304347826 43 26 46.7 0 90 218 402 444 KAG0719988.1 putative inorganic phosphate cotransporter [Chionoecetes opilio] diamond 129 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Majidae Chionoecetes Chionoecetes opilio
29012176 29012176 PRJNA797655_S_NODE_260028_length_154_cov_3.027027_g259423_i0 PRJNA797655 260028 154 3.027027 4.66162158 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 39.7 0.0291   NR CAI6359776.1 13131 g259423 i0 57.1 0.545454545454545 28 12 54.5 0 119 36 7 34 CAI6359776.1 unnamed protein product [Macrosiphum euphorbiae] diamond 84 39.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
29233017 29233017 PRJNA797655_S_NODE_87949_length_258_cov_4.516279_g87344_i0 PRJNA797655 87949 258 4.516279 11.65199982 Ampulex compressa 860918 Arthropoda Arthropoda 42.7 0.045   NR KAG7211330.1 860918 g87344 i0 36.2 1.34883720930233 58 37 67.4 0 241 68 893 950 KAG7211330.1 hypothetical protein KM043_010625 [Ampulex compressa] diamond 348 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ampulicidae Ampulex Ampulex compressa
29485190 29485190 PRJNA797655_S_NODE_186850_length_185_cov_1.690141_g186245_i0 PRJNA797655 186850 185 1.690141 3.12676085 Palaemon carinicauda 392227 Arthropoda Arthropoda 67 3.88e-11   NR XP_068224628.1 392227 g186245 i0 62.1 1.78378378378378 58 19 89.2 1 169 5 268 325 XP_068224628.1 uncharacterized protein [Palaemon carinicauda] diamond 330 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
29801085 29801085 PRJNA797655_S_NODE_63611_length_290_cov_4.437247_g63006_i0 PRJNA797655 63611 290 4.437247 12.8680163 Polyplax serrata 468196 Arthropoda Arthropoda 43.9 0.0179   NR KAK6622308.1 468196 g63006 i0 41.2 0.527586206896552 51 29 52.8 1 163 11 58 107 KAK6622308.1 hypothetical protein RUM44_002119 [Polyplax serrata] diamond 153 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
29832777 29832777 PRJNA797655_S_NODE_92651_length_253_cov_3.433333_g92046_i0 PRJNA797655 92651 253 3.433333 8.68633249 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 41.6 0.0358   NR KAK9869118.1 420089 g92046 i0 32.4 0.877470355731225 74 47 87.7 1 30 251 22 92 KAK9869118.1 hypothetical protein WA026_002876 [Henosepilachna vigintioctopunctata] diamond 222 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
29841866 29841866 PRJNA797655_S_NODE_279471_length_150_cov_1.345794_g278866_i0 PRJNA797655 279471 150 1.345794 2.018691 Arthropoda 6656 Arthropoda Arthropoda 52.4 5.49e-7   NR KAH8020685.1 6941 g278866 i0 100 22.08 24 0 48 0 149 78 84 107 KAH8020685.1 hypothetical protein HPB51_002634 [Rhipicephalus microplus] diamond 3312 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29936710 29936710 PRJNA797655_S_NODE_176531_length_190_cov_2.714286_g175926_i0 PRJNA797655 176531 190 2.714286 5.1571434 Arthropoda 6656 Arthropoda Arthropoda 44.3 0.00426   NR XP_042218008.1 6706 g175926 i0 57.5 6.36315789473684 40 16 61.6 1 34 150 157 196 XP_042218008.1 tigger transposable element-derived protein 1-like [Homarus americanus] diamond 1209 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
30180194 30180194 PRJNA797655_S_NODE_107852_length_238_cov_3.692308_g107247_i0 PRJNA797655 107852 238 3.692308 8.78769304 Maniola jurtina 191418 Arthropoda Arthropoda 42.4 0.0457   NR XP_045767451.1 191418 g107247 i0 40 1.13445378151261 45 25 56.7 1 21 155 136 178 XP_045767451.1 uncharacterized protein LOC123868853 isoform X1 [Maniola jurtina] diamond 270 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Maniola Maniola jurtina
30307190 30307190 PRJNA797655_S_NODE_246532_length_159_cov_2.310345_g245927_i0 PRJNA797655 246532 159 2.310345 3.67344855 Panonychus citri 50023 Arthropoda Arthropoda 42.7 0.0118   NR XP_053202417.1 50023 g245927 i0 45.2 0.792452830188679 42 23 79.2 0 145 20 2 43 XP_053202417.1 kelch-like protein 3 [Panonychus citri] diamond 126 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
30875391 30875391 PRJNA797655_S_NODE_240254_length_162_cov_1.210084_g239649_i0 PRJNA797655 240254 162 1.210084 1.96033608 Neodiprion pinetum 441929 Arthropoda Arthropoda 42 0.0245   NR XP_046488670.1 441929 g239649 i0 39.5 0.703703703703704 38 23 70.4 0 153 40 307 344 XP_046488670.1 uncharacterized protein [Neodiprion pinetum] diamond 114 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Neodiprion Neodiprion pinetum
31412778 31412778 PRJNA797655_S_NODE_71916_length_278_cov_3.314894_g71311_i0 PRJNA797655 71916 278 3.314894 9.21540532 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 49.7 2.01e-4   NR KAK9885449.1 420089 g71311 i0 34.1 0.949640287769784 88 52 91.7 3 11 265 45 129 KAK9885449.1 hypothetical protein WA026_010945 [Henosepilachna vigintioctopunctata] diamond 264 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
31444352 31444352 PRJNA797655_S_NODE_258036_length_155_cov_1.714286_g257431_i0 PRJNA797655 258036 155 1.714286 2.6571433 Eumeta japonica 151549 Arthropoda Arthropoda 40 0.0486   NR GBP31354.1 151549 g257431 i0 54.8 0.6 31 14 60 0 43 135 91 121 GBP31354.1 hypothetical protein EVAR_13473_1 [Eumeta japonica] diamond 93 40 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Psychidae Eumeta Eumeta japonica
31444361 31444361 PRJNA797655_S_NODE_58496_length_299_cov_1.500000_g57891_i0 PRJNA797655 58496 299 1.5 4.485 Dufourea novaeangliae 178035 Arthropoda Arthropoda 44.3 0.0213   NR XP_015430132.1 178035 g57891 i0 32.3 2.02675585284281 99 51 89.3 4 24 290 126 218 XP_015430132.1 PREDICTED: chaoptin [Dufourea novaeangliae] diamond 606 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Dufourea Dufourea novaeangliae
31507810 31507810 PRJNA797655_S_NODE_201276_length_178_cov_1.777778_g200671_i0 PRJNA797655 201276 178 1.777778 3.16444484 Eufriesea mexicana 516756 Arthropoda Arthropoda 42.4 0.021   NR XP_017767501.1 516756 g200671 i0 39.2 1.71910112359551 51 31 86 0 167 15 117 167 XP_017767501.1 PREDICTED: DNA mismatch repair protein MutL-like [Eufriesea mexicana] diamond 306 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Eufriesea Eufriesea mexicana
31507811 31507811 PRJNA797655_S_NODE_206856_length_175_cov_4.856061_g206251_i0 PRJNA797655 206856 175 4.856061 8.49810675 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 94 1.37e-20   NR KAJ6633698.1 35572 g206251 i0 81 0.994285714285714 58 11 99.4 0 1 174 461 518 KAJ6633698.1 Vitellogenin, partial [Pseudolycoriella hygida] diamond 174 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
32434461 32434461 PRJNA797655_S_NODE_231779_length_165_cov_1.573770_g231174_i0 PRJNA797655 231779 165 1.57377 2.5967205 Bradysia 35571 Arthropoda Arthropoda 114 5.76e-28   NR XP_037034774.1 38358 g231174 i0 100 2.94545454545455 54 0 98.2 0 164 3 44 97 XP_037034774.1 talin-2 isoform X3 [Bradysia coprophila] diamond 486 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
32614712 32614712 PRJNA797655_S_NODE_142360_length_211_cov_1.952381_g141755_i0 PRJNA797655 142360 211 1.952381 4.11952391 Uroleucon formosanum 796250 Arthropoda Arthropoda 45.8 0.002   NR KAL4101280.1 796250 g141755 i0 44.7 1.08056872037915 38 21 54 0 80 193 308 345 KAL4101280.1 hypothetical protein QTP88_021300 [Uroleucon formosanum] diamond 228 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
32645861 32645861 PRJNA797655_S_NODE_228400_length_166_cov_2.731707_g227795_i0 PRJNA797655 228400 166 2.731707 4.53463362 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 47.8 2.26e-4   NR XP_066969100.1 79674 g227795 i0 42.9 0.885542168674699 49 28 88.6 0 1 147 24 72 XP_066969100.1 uncharacterized protein [Macrobrachium rosenbergii] diamond 147 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii

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