RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA716463 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
3258930 3258930 PRJNA716463_P_NODE_20263_length_310_cov_3.670886_g19846_i0 PRJNA716463 20263 310 3.670886 11.3797466 Metazoa 33208 Arthropoda Arthropoda 77 7.95e-14   NR XP_068901801.1 7067 g19846 i0 82 15.4645161290323 50 8 47.4 1 307 161 1111 1160 XP_068901801.1 LOW QUALITY PROTEIN: uncharacterized protein [Tenebrio molitor] diamond 4794 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
12186507 12186507 PRJNA716463_P_NODE_107070_length_245_cov_2.558140_g106652_i0 PRJNA716463 107070 245 2.55814 6.267443 Polyplax serrata 468196 Arthropoda Arthropoda 80.5 1.99e-15   NR KAK6629621.1 468196 g106652 i0 100 1.28571428571429 35 0 42.9 0 1 105 1653 1687 KAK6629621.1 hypothetical protein RUM43_003438 [Polyplax serrata] diamond 315 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
26872954 26872954 PRJNA716463_P_NODE_74301_length_273_cov_1.920000_g73884_i0 PRJNA716463 74301 273 1.92 5.2416 Arthropoda 6656 Arthropoda Arthropoda 103 2.25e-23   NR CAD7005632.1 7213 g73884 i0 54.4 14.4175824175824 90 41 98.9 0 270 1 400 489 CAD7005632.1 unnamed protein product [Ceratitis capitata] diamond 3936 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
26893977 26893977 PRJNA716463_P_NODE_105981_length_246_cov_2.416185_g105563_i0 PRJNA716463 105981 246 2.416185 5.9438151 Macrobrachium nipponense 159736 Arthropoda Arthropoda 63.5 8.56e-10   NR XP_064120205.1 159736 g105563 i0 48.3 0.707317073170732 58 30 70.7 0 246 73 145 202 XP_064120205.1 dual specificity protein phosphatase 14-like [Macrobrachium nipponense] diamond 174 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
27589256 27589256 PRJNA716463_P_NODE_64484_length_280_cov_2.917874_g64067_i0 PRJNA716463 64484 280 2.917874 8.1700472 Cimex lectularius 79782 Arthropoda Arthropoda 141 1.47e-36   NR XP_014244216.1 79782 g64067 i0 86 1.99285714285714 93 13 99.6 0 280 2 453 545 XP_014244216.1 FACT complex subunit spt16 isoform X2 [Cimex lectularius] diamond 558 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
27883723 27883723 PRJNA716463_P_NODE_114565_length_237_cov_3.597561_g114147_i0 PRJNA716463 114565 237 3.597561 8.52621957 Lepidoptera 7088 Arthropoda Arthropoda 123 1.28e-30   NR CAG9136876.1 51655 g114147 i0 66.2 1.91139240506329 77 26 97.5 0 5 235 845 921 CAG9136876.1 unnamed protein product [Plutella xylostella] diamond 453 124 0.991935483870968 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
27904608 27904608 PRJNA716463_P_NODE_28825_length_310_cov_2.641350_g28408_i0 PRJNA716463 28825 310 2.64135 8.188185 Halotydeus destructor 2874060 Arthropoda Arthropoda 73.6 1.26e-12   NR KAI1298750.1 2874060 g28408 i0 76.2 2.03225806451613 42 10 40.6 0 268 143 111 152 KAI1298750.1 Glutamate receptor ionotropic, kainate 2 [Halotydeus destructor] diamond 630 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
28294144 28294144 PRJNA716463_P_NODE_122906_length_218_cov_4.648276_g122488_i0 PRJNA716463 122906 218 4.648276 10.13324168 root 1 Root_unresolved Root_unresolved 94.4 1.51e-21   NR BCV68755.1 7227 g122488 i0 69.4 6.92201834862385 72 22 99.1 0 2 217 143 214 BCV68755.1 RFP fluorescence, partial [Drosophila melanogaster] diamond 1509 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
28567865 28567865 PRJNA716463_P_NODE_84587_length_265_cov_1.604167_g84170_i0 PRJNA716463 84587 265 1.604167 4.25104255 Polyplax serrata 468196 Arthropoda Arthropoda 124 7.449999999999999e-32   NR KAK6628228.1 468196 g84170 i0 68.6 0.973584905660377 86 25 97.4 1 263 6 272 355 KAK6628228.1 hypothetical protein RUM43_002040 [Polyplax serrata] diamond 258 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
28641748 28641748 PRJNA716463_P_NODE_767_length_1044_cov_9.240989_g458_i0 PRJNA716463 767 1044 9.240989 96.47592516 root 1 Root_unresolved Root_unresolved 272 6.729999999999999e-87   NR BCV68755.1 7227 g458 i0 64.4 1.9683908045977 225 80 64.7 0 189 863 32 256 BCV68755.1 RFP fluorescence, partial [Drosophila melanogaster] diamond 2055 273 0.996336996336996 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
29178464 29178464 PRJNA716463_P_NODE_11509_length_350_cov_5.848375_g11094_i0 PRJNA716463 11509 350 5.848375 20.4693125 root 1 Root_unresolved Root_unresolved 127 1.85e-33   NR BCV68755.1 7227 g11094 i0 61.4 4.88571428571429 114 44 97.7 0 7 348 142 255 BCV68755.1 RFP fluorescence, partial [Drosophila melanogaster] diamond 1710 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
29199555 29199555 PRJNA716463_P_NODE_102329_length_249_cov_2.568182_g101912_i0 PRJNA716463 102329 249 2.568182 6.39477318 Halotydeus destructor 2874060 Arthropoda Arthropoda 108 9.27e-27   NR KAI1301739.1 2874060 g101912 i0 82.9 0.843373493975904 70 11 83.1 1 248 42 1 70 KAI1301739.1 Aquaporin-10 [Halotydeus destructor] diamond 210 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
29272838 29272838 PRJNA716463_P_NODE_115949_length_235_cov_3.185185_g115531_i0 PRJNA716463 115949 235 3.185185 7.48518475 root 1 Root_unresolved Root_unresolved 134 3.03e-36   NR MCL4136227.1 82763 g115531 i0 70.1 4.92765957446808 77 23 98.3 0 232 2 212 288 MCL4136227.1 hypothetical protein [Idotea baltica] diamond 1158 135 0.992592592592593 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29514927 29514927 PRJNA716463_P_NODE_124730_length_207_cov_6.641791_g124312_i0 PRJNA716463 124730 207 6.6417909999999996 13.74850737 Cotesia typhae 2053667 Arthropoda Arthropoda 41.2 0.0255   NR KAG8042670.1 2053667 g124312 i0 45 0.579710144927536 40 18 52.2 1 117 10 9 48 KAG8042670.1 hypothetical protein G9C98_005304 [Cotesia typhae] diamond 120 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia typhae
29588486 29588486 PRJNA716463_P_NODE_114850_length_237_cov_2.542683_g114432_i0 PRJNA716463 114850 237 2.542683 6.02615871 Trombidiformes 83136 Arthropoda Arthropoda 50.1 8.96e-5   NR XP_015782034.1 32264 g114432 i0 53.2 1.55696202531646 47 22 59.5 0 21 161 402 448 XP_015782034.1 tetratricopeptide repeat protein 7B isoform X1 [Tetranychus urticae] diamond 369 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
29641085 29641085 PRJNA716463_P_NODE_76730_length_271_cov_2.126263_g76313_i0 PRJNA716463 76730 271 2.126263 5.76217273 Halotydeus destructor 2874060 Arthropoda Arthropoda 68.9 3.52e-12   NR KAI1305796.1 2874060 g76313 i0 65.8 0.420664206642066 38 13 42.1 0 117 230 83 120 KAI1305796.1 hypothetical protein HDE_01359 [Halotydeus destructor] diamond 114 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
29988858 29988858 PRJNA716463_P_NODE_19151_length_310_cov_3.962025_g18734_i0 PRJNA716463 19151 310 3.962025 12.2822775 Trichonephila clavipes 2585209 Arthropoda Arthropoda 45.1 0.0124   NR GFX87775.1 2585209 g18734 i0 38.3 0.783870967741935 81 44 76.5 3 269 33 265 341 GFX87775.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 243 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29988882 29988882 PRJNA716463_P_NODE_82951_length_266_cov_2.279793_g82534_i0 PRJNA716463 82951 266 2.279793 6.06424938 Halotydeus destructor 2874060 Arthropoda Arthropoda 123 1.95e-30   NR KAI1285852.1 2874060 g82534 i0 62.5 0.992481203007519 88 33 99.2 0 265 2 486 573 KAI1285852.1 Titin [Halotydeus destructor] diamond 264 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30146519 30146519 PRJNA716463_P_NODE_88932_length_261_cov_2.329787_g88515_i0 PRJNA716463 88932 261 2.329787 6.08074407 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 72.4 3.11e-14   NR KDR09738.1 136037 g88515 i0 49.3 4.96551724137931 71 35 80.5 1 259 50 33 103 KDR09738.1 hypothetical protein L798_00248 [Zootermopsis nevadensis] diamond 1296 72.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
30662808 30662808 PRJNA716463_P_NODE_36073_length_299_cov_3.358407_g35656_i0 PRJNA716463 36073 299 3.358407 10.04163693 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 82 1.17e-15   NR KAK4017590.1 35525 g35656 i0 44.4 10.7859531772575 99 49 98.3 2 296 3 575 668 KAK4017590.1 hypothetical protein OUZ56_033205 [Daphnia magna] diamond 3225 82 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
30810272 30810272 PRJNA716463_P_NODE_100474_length_251_cov_0.865169_g100057_i0 PRJNA716463 100474 251 0.865169 2.17157419 Galendromus occidentalis 34638 Arthropoda Arthropoda 118 5.709999999999999e-31   NR XP_003748229.1 34638 g100057 i0 77.6 0.800796812749004 67 15 80.1 0 49 249 3 69 XP_003748229.1 peroxiredoxin-6 [Galendromus occidentalis] diamond 201 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
30873474 30873474 PRJNA716463_P_NODE_115734_length_235_cov_4.506173_g115316_i0 PRJNA716463 115734 235 4.506173 10.58950655 Halotydeus destructor 2874060 Arthropoda Arthropoda 46.6 0.00143   NR KAI1287466.1 2874060 g115316 i0 39.4 0.842553191489362 66 38 81.7 1 233 42 162 227 KAI1287466.1 Histone-lysine N-methyltransferase SUV39H1 [Halotydeus destructor] diamond 198 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30905206 30905206 PRJNA716463_P_NODE_85914_length_264_cov_1.356021_g85497_i0 PRJNA716463 85914 264 1.356021 3.57989544 Portunus trituberculatus 210409 Arthropoda Arthropoda 52 2.75e-5   NR XP_045119708.1 210409 g85497 i0 48.9 1.57954545454545 47 24 53.4 0 150 10 572 618 XP_045119708.1 zinc finger protein 62 homolog isoform X3 [Portunus trituberculatus] diamond 417 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
31484800 31484800 PRJNA716463_P_NODE_56596_length_286_cov_1.948357_g56179_i0 PRJNA716463 56596 286 1.948357 5.57230102 Hymenoptera 7399 Arthropoda Arthropoda 62.4 7.53e-9   NR XP_008561209.1 69319 g56179 i0 52.1 1.51048951048951 48 23 50.3 0 146 3 84 131 XP_008561209.1 disintegrin and metalloproteinase domain-containing protein 10 [Microplitis demolitor] diamond 432 62.8 0.993630573248408 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
31959022 31959022 PRJNA716463_P_NODE_57617_length_285_cov_2.528302_g57200_i0 PRJNA716463 57617 285 2.528302 7.2056607 Arachnida 6854 Arthropoda Arthropoda 50.4 1.15e-4   NR GIX81218.1 172846 g57200 i0 49 0.905263157894737 49 25 51.6 0 283 137 319 367 GIX81218.1 multiple PDZ domain protein, partial [Caerostris extrusa] diamond 258 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
32053942 32053942 PRJNA716463_P_NODE_60778_length_283_cov_1.990476_g60361_i0 PRJNA716463 60778 283 1.990476 5.63304708 Ixodidae 6939 Arthropoda Arthropoda 89.4 7.790000000000001e-21   NR XP_050027486.1 34620 g60361 i0 60 2.73498233215548 65 26 68.9 0 198 4 27 91 XP_050027486.1 cystatin-A2-like [Dermacentor andersoni] diamond 774 90.1 0.992230854605993 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
32180699 32180699 PRJNA716463_P_NODE_123678_length_213_cov_9.885714_g123260_i0 PRJNA716463 123678 213 9.885714 21.05657082 root 1 Root_unresolved Root_unresolved 75.5 2.18e-14   NR BCV68755.1 7227 g123260 i0 61.4 2.92957746478873 70 27 98.6 0 212 3 136 205 BCV68755.1 RFP fluorescence, partial [Drosophila melanogaster] diamond 624 75.9 0.994729907773386 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
32307459 32307459 PRJNA716463_P_NODE_119799_length_228_cov_8.129032_g119381_i0 PRJNA716463 119799 228 8.129032 18.53419296 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.5 1.01e-6   NR KAJ6635689.1 35572 g119381 i0 45.9 7.69736842105263 61 20 63.2 2 12 155 1382 1442 KAJ6635689.1 Serine/threonine-protein kinase PAK mbt, partial [Pseudolycoriella hygida] diamond 1755 55.8 0.99462365591397806 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
32738922 32738922 PRJNA716463_P_NODE_59240_length_284_cov_2.132701_g58823_i0 PRJNA716463 59240 284 2.132701 6.05687084 Homarus americanus 6706 Arthropoda Arthropoda 102 9.15e-23   NR XP_042241566.1 6706 g58823 i0 51.1 1.98591549295775 94 46 99.3 0 3 284 685 778 XP_042241566.1 vitellogenin-like [Homarus americanus] diamond 564 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
32896036 32896036 PRJNA716463_P_NODE_26860_length_310_cov_2.827004_g26443_i0 PRJNA716463 26860 310 2.827004 8.7637124 Halotydeus destructor 2874060 Arthropoda Arthropoda 54.3 6.62e-6   NR KAI1289522.1 2874060 g26443 i0 58.5 0.832258064516129 41 16 38.7 1 308 189 127 167 KAI1289522.1 Uncharacterized protein HDE_08157 [Halotydeus destructor] diamond 258 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor

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