RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA930380 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
4737841 4737841 PRJNA930380_P_NODE_6324_length_290_cov_1.225806_g6271_i0 PRJNA930380 6324 290 1.225806 3.5548374 Mythimna separata 271217 Arthropoda Arthropoda 76.6 7.84e-14   NR KAJ8718917.1 271217 g6271 i0 89.2 0.382758620689655 37 4 38.3 0 288 178 595 631 KAJ8718917.1 hypothetical protein PYW07_016473 [Mythimna separata] diamond 111 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna separata
27024929 27024929 PRJNA930380_P_NODE_13942_length_242_cov_0.946746_g13889_i0 PRJNA930380 13942 242 0.946746 2.29112532 Dryococelus australis 614101 Arthropoda Arthropoda 45.1 0.00568   NR KAJ8871040.1 614101 g13889 i0 79.2 0.297520661157025 24 5 29.8 0 170 241 85 108 KAJ8871040.1 hypothetical protein PR048_027344 [Dryococelus australis] diamond 72 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Phasmatidae Dryococelus Dryococelus australis
27688787 27688787 PRJNA930380_P_NODE_5164_length_296_cov_2.502242_g5111_i0 PRJNA930380 5164 296 2.502242 7.40663632 Choristoneura fumiferana 7141 Arthropoda Arthropoda 76.6 8.65e-14   NR KAI8422947.1 7141 g5111 i0 37.1 0.902027027027027 89 56 90.2 0 295 29 412 500 KAI8422947.1 hypothetical protein MSG28_014050 [Choristoneura fumiferana] diamond 267 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Choristoneura Choristoneura fumiferana
27727395 27727395 PRJNA930380_P_NODE_10284_length_268_cov_1.579487_g10231_i0 PRJNA930380 10284 268 1.579487 4.23302516 Metazoa 33208 Arthropoda Arthropoda 52.8 1.57e-5   NR XP_065557782.1 6661 g10231 i0 43.3 1.99253731343284 60 31 67.2 1 83 262 635 691 XP_065557782.1 uncharacterized protein LOC136025725 [Artemia franciscana] diamond 534 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27846126 27846126 PRJNA930380_P_NODE_6304_length_290_cov_1.350230_g6251_i0 PRJNA930380 6304 290 1.35023 3.915667 Trachymyrmex septentrionalis 34720 Arthropoda Arthropoda 50.4 1.31e-4   NR XP_018338314.1 34720 g6251 i0 47.1 1.0551724137931 51 23 52.8 1 53 205 495 541 XP_018338314.1 PREDICTED: trichohyalin-like [Trachymyrmex septentrionalis] diamond 306 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Trachymyrmex Trachymyrmex septentrionalis
27972541 27972541 PRJNA930380_P_NODE_6465_length_289_cov_1.810185_g6412_i0 PRJNA930380 6465 289 1.810185 5.23143465 Microplitis demolitor 69319 Arthropoda Arthropoda 91.3 6.02e-19   NR XP_014299180.2 69319 g6412 i0 48.4 0.986159169550173 95 46 97.6 2 288 7 1558 1650 XP_014299180.2 uncharacterized protein LOC103578710 [Microplitis demolitor] diamond 285 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
28042766 28042766 PRJNA930380_P_NODE_4805_length_301_cov_3.811404_g4752_i0 PRJNA930380 4805 301 3.811404 11.47232604 Metazoa 33208 Arthropoda Arthropoda 110 1.19e-25   NR XP_046452735.1 6669 g4752 i0 58.6 11.671096345515 99 41 98.7 0 300 4 443 541 XP_046452735.1 uncharacterized protein LOC124200509 [Daphnia pulex] diamond 3513 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
28231902 28231902 PRJNA930380_P_NODE_7786_length_283_cov_2.071429_g7733_i0 PRJNA930380 7786 283 2.071429 5.86214407 Metazoa 33208 Arthropoda Arthropoda 45.4 0.00694   NR KAL3388671.1 54128 g7733 i0 66.7 1.71731448763251 33 11 35 0 151 53 513 545 KAL3388671.1 hypothetical protein TKK_016104 [Trichogramma kaykai] diamond 486 45.8 0.991266375545852 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
28541109 28541109 PRJNA930380_P_NODE_5227_length_296_cov_1.318386_g5174_i0 PRJNA930380 5227 296 1.318386 3.90242256 Trichonephila clavipes 2585209 Arthropoda Arthropoda 48.9 4.45e-4   NR GFX93555.1 2585209 g5174 i0 27.6 1.37837837837838 76 55 77 0 293 66 18 93 GFX93555.1 transposon Ty3-I Gag-Pol polyprotein [Trichonephila clavipes] diamond 408 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
28541110 28541110 PRJNA930380_P_NODE_5427_length_294_cov_2.040724_g5374_i0 PRJNA930380 5427 294 2.040724 5.99972856 Dermacentor silvarum 543639 Arthropoda Arthropoda 51.6 2.68e-5   NR KAH7932927.1 543639 g5374 i0 32.3 1.97959183673469 99 62 95.9 1 4 285 36 134 KAH7932927.1 hypothetical protein HPB49_005060 [Dermacentor silvarum] diamond 582 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
28824762 28824762 PRJNA930380_P_NODE_14508_length_227_cov_8.123377_g14455_i0 PRJNA930380 14508 227 8.123377 18.44006579 Ixodes scapularis 6945 Arthropoda Arthropoda 44.7 0.00614   NR EEC04061.1 6945 g14455 i0 39 1.49339207048458 59 36 78 0 47 223 30 88 EEC04061.1 hypothetical protein IscW_ISCW002319 [Ixodes scapularis] diamond 339 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
29645537 29645537 PRJNA930380_P_NODE_11150_length_254_cov_1.469613_g11097_i0 PRJNA930380 11150 254 1.469613 3.73281702 Daphnia pulex 6669 Arthropoda Arthropoda 50.4 7.61e-5   NR EFX73393.1 6669 g11097 i0 36.3 0.94488188976378 80 49 93.3 2 1 237 115 193 EFX73393.1 hypothetical protein DAPPUDRAFT_253296 [Daphnia pulex] diamond 240 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
29652660 29652660 PRJNA930380_P_NODE_8030_length_282_cov_1.885167_g7977_i0 PRJNA930380 8030 282 1.885167 5.31617094 Metazoa 33208 Arthropoda Arthropoda 130 8.190000000000001e-33   NR KAG0723068.1 41210 g7977 i0 66.3 1.95744680851064 92 31 97.9 0 3 278 355 446 KAG0723068.1 hypothetical protein GWK47_043326 [Chionoecetes opilio] diamond 552 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Majidae Chionoecetes Chionoecetes opilio
29772088 29772088 PRJNA930380_P_NODE_13451_length_244_cov_0.900585_g13398_i0 PRJNA930380 13451 244 0.900585 2.1974274 Helicoverpa armigera 29058 Arthropoda Arthropoda 143 3.41e-38   NR XP_063897483.1 29058 g13398 i0 87.7 0.995901639344262 81 10 99.6 0 243 1 254 334 XP_063897483.1 digestive cysteine proteinase 2 [Helicoverpa armigera] diamond 243 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
29772090 29772090 PRJNA930380_P_NODE_6291_length_290_cov_1.419355_g6238_i0 PRJNA930380 6291 290 1.419355 4.1161295 Choristoneura fumiferana 7141 Arthropoda Arthropoda 53.1 1.45e-5   NR KAI8422947.1 7141 g6238 i0 46.2 0.537931034482759 52 28 53.8 0 289 134 412 463 KAI8422947.1 hypothetical protein MSG28_014050 [Choristoneura fumiferana] diamond 156 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Choristoneura Choristoneura fumiferana
30182909 30182909 PRJNA930380_P_NODE_9192_length_276_cov_1.517241_g9139_i0 PRJNA930380 9192 276 1.517241 4.18758516 Palaemon carinicauda 392227 Arthropoda Arthropoda 43.5 0.0308   NR XP_068230459.1 392227 g9139 i0 40.5 0.456521739130435 42 25 45.7 0 108 233 83 124 XP_068230459.1 extracellular matrix organizing protein FRAS1-like isoform X1 [Palaemon carinicauda] diamond 126 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
30309812 30309812 PRJNA930380_P_NODE_5532_length_293_cov_3.500000_g5479_i0 PRJNA930380 5532 293 3.5 10.255 Choristoneura fumiferana 7141 Arthropoda Arthropoda 50.4 1.33e-4   NR KAI8422947.1 7141 g5479 i0 42.9 0.501706484641638 49 28 50.2 0 292 146 412 460 KAI8422947.1 hypothetical protein MSG28_014050 [Choristoneura fumiferana] diamond 147 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Choristoneura Choristoneura fumiferana
30435997 30435997 PRJNA930380_P_NODE_9753_length_272_cov_2.321608_g9700_i0 PRJNA930380 9753 272 2.321608 6.31477376 Rhopalosiphum padi 40932 Arthropoda Arthropoda 44.7 0.0111   NR XP_060842122.1 40932 g9700 i0 35.4 1.43382352941176 65 37 71.7 1 219 25 365 424 XP_060842122.1 LOW QUALITY PROTEIN: modular serine protease-like, partial [Rhopalosiphum padi] diamond 390 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
30688327 30688327 PRJNA930380_P_NODE_14353_length_241_cov_0.916667_g14300_i0 PRJNA930380 14353 241 0.916667 2.20916747 Bombyx mori 7091 Arthropoda Arthropoda 107 2.8499999999999997e-25   NR XP_004929657.1 7091 g14300 i0 66.2 1.76763485477178 71 24 88.4 0 2 214 235 305 XP_004929657.1 leucine-rich repeat protein 1 isoform X1 [Bombyx mori] diamond 426 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
31137554 31137554 PRJNA930380_P_NODE_9255_length_275_cov_5.301980_g9202_i0 PRJNA930380 9255 275 5.30198 14.580445 Arthropoda 6656 Arthropoda Arthropoda 48.5 4.77e-4   NR CAG7787090.1 39272 g9202 i0 37.7 3.57818181818182 61 38 66.5 0 20 202 260 320 CAG7787090.1 unnamed protein product, partial [Allacma fusca] diamond 984 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
31826410 31826410 PRJNA930380_P_NODE_7637_length_284_cov_1.459716_g7584_i0 PRJNA930380 7637 284 1.459716 4.14559344 Trichonephila clavipes 2585209 Arthropoda Arthropoda 48.1 7.43e-4   NR GFS99584.1 2585209 g7584 i0 25.7 0.78169014084507 74 55 78.2 0 282 61 225 298 GFS99584.1 uncharacterized protein TNCV_167131 [Trichonephila clavipes] diamond 222 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
31984679 31984679 PRJNA930380_P_NODE_10098_length_270_cov_1.324873_g10045_i0 PRJNA930380 10098 270 1.324873 3.5771571 Rhipicephalus sanguineus 34632 Arthropoda Arthropoda 50.4 9.82e-5   NR XP_037508982.1 34632 g10045 i0 59.1 1.01111111111111 44 17 47.8 1 131 3 85 128 XP_037508982.1 uncharacterized protein LOC119385652 [Rhipicephalus sanguineus] diamond 273 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus
31984684 31984684 PRJNA930380_P_NODE_7358_length_285_cov_1.900943_g7305_i0 PRJNA930380 7358 285 1.900943 5.41768755 Venturia canescens 32260 Arthropoda Arthropoda 63.5 2.83e-9   NR XP_043286869.1 32260 g7305 i0 51.9 1.12631578947368 52 25 54.7 0 220 65 200 251 XP_043286869.1 uncharacterized protein [Venturia canescens] diamond 321 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
32055030 32055030 PRJNA930380_P_NODE_5538_length_293_cov_3.290909_g5485_i0 PRJNA930380 5538 293 3.290909 9.64236337 Cotesia 32390 Arthropoda Arthropoda 44.7 0.0128   NR XP_044598892.1 32391 g5485 i0 44.9 1.00341296928328 49 27 50.2 0 15 161 175 223 XP_044598892.1 uncharacterized protein LOC123275054 [Cotesia glomerata] diamond 294 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
32364599 32364599 PRJNA930380_P_NODE_5599_length_293_cov_1.890909_g5546_i0 PRJNA930380 5599 293 1.890909 5.54036337 Parnassius mnemosyne 213953 Arthropoda Arthropoda 47 0.00222   NR CAK1596231.1 213953 g5546 i0 40 0.767918088737201 75 38 71.7 2 212 3 522 594 CAK1596231.1 unnamed protein product [Parnassius mnemosyne] diamond 225 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius mnemosyne
32466719 32466719 PRJNA930380_P_NODE_4599_length_305_cov_7.288793_g4546_i0 PRJNA930380 4599 305 7.288793 22.23081865 Metazoa 33208 Arthropoda Arthropoda 106 3.799999999999999e-24   NR XP_046452735.1 6669 g4546 i0 57 3.7672131147541 100 43 98.4 0 304 5 442 541 XP_046452735.1 uncharacterized protein LOC124200509 [Daphnia pulex] diamond 1149 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
32900591 32900591 PRJNA930380_P_NODE_8800_length_278_cov_2.107317_g8747_i0 PRJNA930380 8800 278 2.107317 5.85834126 Diprion similis 362088 Arthropoda Arthropoda 53.9 6.46e-6   NR XP_046748861.1 362088 g8747 i0 51.1 1.01438848920863 47 23 50.7 0 29 169 180 226 XP_046748861.1 uncharacterized protein LOC124412788 [Diprion similis] diamond 282 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Diprion Diprion similis

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