RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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

  • PRJNA1111448 · 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
10421742 10421742 PRJNA1111448_S_NODE_70129_length_310_cov_1.949367_g69306_i0 PRJNA1111448 70129 310 1.949367 6.0430377 Trichogramma brassicae 86971 Arthropoda Arthropoda 140 1.22e-37   NR CAB0035098.1 86971 g69306 i0 72.6 2.75806451612903 95 26 91.9 0 25 309 294 388 CAB0035098.1 unnamed protein product [Trichogramma brassicae] diamond 855 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma brassicae
12971937 12971937 PRJNA1111448_S_NODE_54271_length_339_cov_0.868421_g53448_i0 PRJNA1111448 54271 339 0.868421 2.94394719 Ceriodaphnia reticulata 302197 Arthropoda Arthropoda 211 5.63e-61   NR CAG4636794.1 302197 g53448 i0 99.1 1.9646017699115 112 1 99.1 0 2 337 545 656 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 666 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
18069258 18069258 PRJNA1111448_S_NODE_13655_length_529_cov_2.958333_g12849_i0 PRJNA1111448 13655 529 2.958333 15.64958157 Metazoa 33208 Arthropoda Arthropoda 196 2.0499999999999995e-54   NR KMQ89570.1 67767 g12849 i0 56.1 15.930056710775 157 69 89 0 527 57 345 501 KMQ89570.1 retrovirus-related gag-pol polyprotein [Lasius niger] diamond 8427 197 0.99492385786802 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
19343711 19343711 PRJNA1111448_S_NODE_24716_length_436_cov_1.347107_g23893_i0 PRJNA1111448 24716 436 1.347107 5.87338652 Hemiptera 7524 Arthropoda Arthropoda 211 1.1e-64   NR XP_039280434.1 108931 g23893 i0 68.7 1.95412844036697 147 43 99.1 1 2 433 153 299 XP_039280434.1 uncharacterized protein LOC120350562 [Nilaparvata lugens] diamond 852 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
19344299 19344299 PRJNA1111448_S_NODE_82256_length_293_cov_1.050000_g81433_i0 PRJNA1111448 82256 293 1.05 3.0765 root 1 Root_unresolved Root_unresolved 82.8 4.65e-16   NR XP_018329400.1 224129 g81433 i0 53.7 7.45392491467577 82 9 55.3 2 2 163 352 432 XP_018329400.1 adenosylhomocysteinase isoform X1 [Agrilus planipennis] diamond 2184 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
23170759 23170759 PRJNA1111448_S_NODE_899_length_1313_cov_4.103226_g669_i0 PRJNA1111448 899 1313 4.103226 53.87535738 Insecta 50557 Arthropoda Arthropoda 240 5.38e-66   NR KAH0810003.1 7067 g669 i0 47.4 1.97182025894897 287 139 64.4 6 881 36 9 288 KAH0810003.1 hypothetical protein GEV33_012787 [Tenebrio molitor] diamond 2589 240 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
24444028 24444028 PRJNA1111448_S_NODE_45620_length_358_cov_3.726316_g44797_i0 PRJNA1111448 45620 358 3.726316 13.34021128 Trichomalopsis sarcophagae 543379 Arthropoda Arthropoda 116 1.02e-28   NR OXU24743.1 543379 g44797 i0 50.9 2.6145251396648 106 52 88.8 0 6 323 152 257 OXU24743.1 hypothetical protein TSAR_013132 [Trichomalopsis sarcophagae] diamond 936 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Trichomalopsis Trichomalopsis sarcophagae
26624609 26624609 PRJNA1111448_S_NODE_118181_length_253_cov_1.283333_g117358_i0 PRJNA1111448 118181 253 1.283333 3.24683249 Periplaneta americana 6978 Arthropoda Arthropoda 60.5 1.1e-8   NR KAJ4431361.1 6978 g117358 i0 52.9 4.06719367588933 51 24 60.5 0 252 100 149 199 KAJ4431361.1 hypothetical protein ANN_19958 [Periplaneta americana] diamond 1029 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
26624610 26624610 PRJNA1111448_S_NODE_139201_length_241_cov_0.916667_g138378_i0 PRJNA1111448 139201 241 0.916667 2.20916747 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 67.8 4.85e-11   NR XP_050537947.1 58002 g138378 i0 66 1.2448132780083 50 17 62.2 0 170 21 50 99 XP_050537947.1 uncharacterized protein LOC126903645 isoform X2 [Daktulosphaira vitifoliae] diamond 300 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
26678967 26678967 PRJNA1111448_S_NODE_105701_length_265_cov_2.197917_g104878_i0 PRJNA1111448 105701 265 2.197917 5.82448005 Aphis 80764 Arthropoda Arthropoda 75.9 6.45e-14   NR KAE9539871.1 307491 g104878 i0 70 3.98490566037736 50 15 56.6 0 170 21 56 105 KAE9539871.1 hypothetical protein AGLY_005123 [Aphis glycines] diamond 1056 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines
26750958 26750958 PRJNA1111448_S_NODE_99261_length_272_cov_1.934673_g98438_i0 PRJNA1111448 99261 272 1.934673 5.26231056 Melanaphis sacchari 742174 Arthropoda Arthropoda 54.3 4.29e-6   NR XP_025195888.1 742174 g98438 i0 48.9 0.496323529411765 45 23 49.6 0 130 264 5 49 XP_025195888.1 protein ALP1-like [Melanaphis sacchari] diamond 135 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Melanaphis Melanaphis sacchari
26805831 26805831 PRJNA1111448_S_NODE_78921_length_297_cov_2.455357_g78098_i0 PRJNA1111448 78921 297 2.455357 7.29241029 Aphididae 27482 Arthropoda Arthropoda 147 6.17e-41   NR XP_025413308.1 143950 g78098 i0 69.1 10.8484848484848 97 30 98 0 2 292 162 258 XP_025413308.1 protein ALP1-like [Sipha flava] diamond 3222 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
27004450 27004450 PRJNA1111448_S_NODE_104042_length_267_cov_1.587629_g103219_i0 PRJNA1111448 104042 267 1.587629 4.23896943 Macrothrix elegans 527138 Arthropoda Arthropoda 50.1 7.17e-5   NR CAG4646612.1 527138 g103219 i0 42.1 1.26966292134831 57 31 61.8 1 256 92 139 195 CAG4646612.1 EOG090X0EPM [Macrothrix elegans] diamond 339 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Macrothrix Macrothrix elegans
27510328 27510328 PRJNA1111448_S_NODE_136323_length_242_cov_1.715976_g135500_i0 PRJNA1111448 136323 242 1.715976 4.15266192 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 86.3 6.94e-18   NR XP_050545824.1 58002 g135500 i0 60.3 1.56198347107438 63 25 78.1 0 242 54 270 332 XP_050545824.1 uncharacterized protein LOC126908041 isoform X2 [Daktulosphaira vitifoliae] diamond 378 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
27888974 27888974 PRJNA1111448_S_NODE_124505_length_249_cov_0.875000_g123682_i0 PRJNA1111448 124505 249 0.875 2.17875 Pediculus humanus corporis 121224 Arthropoda Arthropoda 56.2 7.12e-7   NR XP_002431374.1 121224 g123682 i0 54.2 1.74698795180723 48 22 57.8 0 243 100 472 519 XP_002431374.1 uncharacterized protein Phum_PHUM523610 [Pediculus humanus corporis] diamond 435 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
28046941 28046941 PRJNA1111448_S_NODE_118565_length_253_cov_0.872222_g117742_i0 PRJNA1111448 118565 253 0.872222 2.20672166 Callosobruchus maculatus 64391 Arthropoda Arthropoda 121 2.12e-30   NR VEN51095.1 64391 g117742 i0 63.3 5.59683794466403 79 29 93.7 0 251 15 283 361 VEN51095.1 unnamed protein product [Callosobruchus maculatus] diamond 1416 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Callosobruchus Callosobruchus maculatus
28046946 28046946 PRJNA1111448_S_NODE_75005_length_303_cov_1.004348_g74182_i0 PRJNA1111448 75005 303 1.004348 3.04317444 Galendromus occidentalis 34638 Arthropoda Arthropoda 46.6 0.00335   NR XP_018493987.1 34638 g74182 i0 45.5 0.435643564356436 44 24 43.6 0 18 149 285 328 XP_018493987.1 uncharacterized protein LOC108863840 [Galendromus occidentalis] diamond 132 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
28606466 28606466 PRJNA1111448_S_NODE_82667_length_292_cov_2.000000_g81844_i0 PRJNA1111448 82667 292 2 5.84 Metazoa 33208 Arthropoda Arthropoda 50.1 1.55e-4   NR KAJ4436765.1 6978 g81844 i0 74.1 0.534246575342466 27 7 27.7 0 292 212 240 266 KAJ4436765.1 hypothetical protein ANN_16897 [Periplaneta americana] diamond 156 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
28994471 28994471 PRJNA1111448_S_NODE_143108_length_227_cov_2.500000_g142285_i0 PRJNA1111448 143108 227 2.5 5.675 Anthophora plagiata 597819 Arthropoda Arthropoda 61.6 6.02e-9   NR CAK9796081.1 597819 g142285 i0 63.6 0.581497797356828 44 16 58.1 0 227 96 292 335 CAK9796081.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 132 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
29215418 29215418 PRJNA1111448_S_NODE_65889_length_317_cov_2.024590_g65066_i0 PRJNA1111448 65889 317 2.02459 6.4179503 Cryptotermes secundus 105785 Arthropoda Arthropoda 58.9 1.07e-7   NR XP_033608609.1 105785 g65066 i0 51 3.76656151419558 49 24 46.4 0 156 10 1 49 XP_033608609.1 uncharacterized protein LOC117282561 isoform X1 [Cryptotermes secundus] diamond 1194 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
29215420 29215420 PRJNA1111448_S_NODE_91189_length_282_cov_1.076555_g90366_i0 PRJNA1111448 91189 282 1.076555 3.0358851 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 51.2 6.11e-5   NR UYV69584.1 51811 g90366 i0 62.5 1.36170212765957 32 12 34 0 3 98 18 49 UYV69584.1 hypothetical protein LAZ67_6004025 [Cordylochernes scorpioides] diamond 384 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
29341588 29341588 PRJNA1111448_S_NODE_62969_length_322_cov_2.164659_g62146_i0 PRJNA1111448 62969 322 2.164659 6.97020198 Diaphorina citri 121845 Arthropoda Arthropoda 54.7 3.47e-7   NR KAI5700356.1 121845 g62146 i0 64.9 0.782608695652174 37 13 34.5 0 14 124 37 73 KAI5700356.1 hypothetical protein M8J77_004453 [Diaphorina citri] diamond 252 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
29783484 29783484 PRJNA1111448_S_NODE_45411_length_359_cov_1.573427_g44588_i0 PRJNA1111448 45411 359 1.573427 5.64860293 Phymastichus coffea 108790 Arthropoda Arthropoda 43.9 0.0303   NR XP_058790979.1 108790 g44588 i0 37 0.384401114206128 46 28 37.6 1 171 37 54 99 XP_058790979.1 COMM domain-containing protein 8-like [Phymastichus coffea] diamond 138 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea
29783485 29783485 PRJNA1111448_S_NODE_75931_length_301_cov_3.377193_g75108_i0 PRJNA1111448 75931 301 3.377193 10.16535093 Araneus ventricosus 182803 Arthropoda Arthropoda 49.3 3.5e-4   NR GBN01749.1 182803 g75108 i0 51.4 1.3953488372093 35 17 34.9 0 194 298 93 127 GBN01749.1 hypothetical protein AVEN_64609-1 [Araneus ventricosus] diamond 420 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
29973051 29973051 PRJNA1111448_S_NODE_51811_length_344_cov_1.273063_g50988_i0 PRJNA1111448 51811 344 1.273063 4.37933672 Cryptotermes secundus 105785 Arthropoda Arthropoda 66.6 2.81e-10   NR XP_023718171.1 105785 g50988 i0 52.7 1.49127906976744 55 26 48 0 258 94 1 55 XP_023718171.1 uncharacterized protein LOC111870272 [Cryptotermes secundus] diamond 513 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
30027568 30027568 PRJNA1111448_S_NODE_102711_length_269_cov_0.831633_g101888_i0 PRJNA1111448 102711 269 0.831633 2.23709277 Metazoa 33208 Arthropoda Arthropoda 103 1.9099999999999998e-23   NR XP_069960323.1 27406 g101888 i0 76.2 3.51301115241636 63 15 70.3 0 80 268 415 477 XP_069960323.1 RNA-directed DNA polymerase from mobile element jockey [Cherax quadricarinatus] diamond 945 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
30595998 30595998 PRJNA1111448_S_NODE_54753_length_338_cov_0.773585_g53930_i0 PRJNA1111448 54753 338 0.773585 2.6147173 Hemiptera 7524 Arthropoda Arthropoda 181 5.919999999999999e-55   NR XP_008179920.1 7029 g53930 i0 70.5 7.97041420118343 112 33 99.4 0 3 338 56 167 XP_008179920.1 protein ALP1-like [Acyrthosiphon pisum] diamond 2694 182 0.994505494505495 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
31204831 31204831 PRJNA1111448_S_NODE_5135_length_731_cov_2.062310_g4484_i0 PRJNA1111448 5135 731 2.06231 15.075486099999999 Nilaparvata lugens 108931 Arthropoda Arthropoda 139 1.02e-33   NR XP_039275893.1 108931 g4484 i0 56.9 0.504787961696306 123 52 50.1 1 365 730 1 123 XP_039275893.1 leucine-rich repeat serine/threonine-protein kinase 1-like [Nilaparvata lugens] diamond 369 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
32240614 32240614 PRJNA1111448_S_NODE_56158_length_335_cov_1.267176_g55335_i0 PRJNA1111448 56158 335 1.267176 4.2450396 Aphididae 27482 Arthropoda Arthropoda 76.3 1.51e-13   NR XP_025200092.1 742174 g55335 i0 53.3 1.07462686567164 60 28 53.7 0 335 156 52 111 XP_025200092.1 protein ALP1-like [Melanaphis sacchari] diamond 360 77 0.990909090909091 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Melanaphis Melanaphis sacchari
32249551 32249551 PRJNA1111448_S_NODE_128118_length_247_cov_0.885057_g127295_i0 PRJNA1111448 128118 247 0.885057 2.18609079 Scirpophaga incertulas 72366 Arthropoda Arthropoda 45.8 0.00269   NR KAL4717983.1 72366 g127295 i0 50 0.534412955465587 44 16 53.4 1 192 61 50 87 KAL4717983.1 hypothetical protein ACJJTC_013023 [Scirpophaga incertulas] diamond 132 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Scirpophaga Scirpophaga incertulas
32745839 32745839 PRJNA1111448_S_NODE_68660_length_313_cov_0.904167_g67837_i0 PRJNA1111448 68660 313 0.904167 2.83004271 Metazoa 33208 Arthropoda Arthropoda 62.8 7.71e-9   NR XP_017481746.1 28612 g67837 i0 71.1 1.86900958466454 38 11 36.4 0 313 200 404 441 XP_017481746.1 PREDICTED: uncharacterized protein LOC108370842 [Rhagoletis zephyria] diamond 585 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
32817455 32817455 PRJNA1111448_S_NODE_25900_length_429_cov_1.853933_g25077_i0 PRJNA1111448 25900 429 1.853933 7.95337257 Uroleucon formosanum 796250 Arthropoda Arthropoda 51.2 8.33e-5   NR KAL4131712.1 796250 g25077 i0 55.3 0.265734265734266 38 17 26.6 0 316 429 46 83 KAL4131712.1 hypothetical protein QTP88_008986 [Uroleucon formosanum] diamond 114 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum

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