RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA994052 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
20399449 20399449 PRJNA994052_P_NODE_32056_length_276_cov_64.068966_g30812_i0 PRJNA994052 32056 276 64.068966 176.83034616 Ceratitis capitata 7213 Arthropoda Arthropoda 101 7.019999999999999e-23   NR CAD7015491.1 7213 g30812 i0 65.9 0.989130434782609 91 26 95.7 2 266 3 323 411 CAD7015491.1 unnamed protein product [Ceratitis capitata] diamond 273 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
27215919 27215919 PRJNA994052_P_NODE_25282_length_294_cov_17.095023_g24045_i0 PRJNA994052 25282 294 17.095023 50.25936762 Operophtera brumata 104452 Arthropoda Arthropoda 84.3 1.7e-16   NR KOB76948.1 104452 g24045 i0 90.7 11.8469387755102 43 4 43.9 0 4 132 724 766 KOB76948.1 Translation elongation factor 2 [Operophtera brumata] diamond 3483 84.7 0.995277449822904 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Operophtera Operophtera brumata
27279453 27279453 PRJNA994052_P_NODE_17363_length_312_cov_5.673640_g16142_i0 PRJNA994052 17363 312 5.67364 17.7017568 Lucilia cuprina 7375 Arthropoda Arthropoda 57 2.7e-7   NR KNC34046.1 7375 g16142 i0 61 0.394230769230769 41 16 39.4 0 2 124 85 125 KNC34046.1 hypothetical protein FF38_07744, partial [Lucilia cuprina] diamond 123 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
27690302 27690302 PRJNA994052_P_NODE_37264_length_264_cov_39.753927_g36018_i0 PRJNA994052 37264 264 39.753927 104.95036728 Anoplophora glabripennis 217634 Arthropoda Arthropoda 56.2 1.3e-7   NR XP_018578213.1 217634 g36018 i0 80.6 0.693181818181818 31 6 35.2 0 256 164 103 133 XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis] diamond 183 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
27942611 27942611 PRJNA994052_P_NODE_33225_length_273_cov_67.540000_g31981_i0 PRJNA994052 33225 273 67.54 184.3842 Cotesia congregata 51543 Arthropoda Arthropoda 83.6 6.06e-18   NR CAD6244479.1 51543 g31981 i0 73.2 1.23076923076923 56 15 61.5 0 265 98 105 160 CAD6244479.1 GSCOCG00013363001-RA-CDS [Cotesia congregata] diamond 336 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia congregata
28068775 28068775 PRJNA994052_P_NODE_74645_length_207_cov_6.895522_g73389_i0 PRJNA994052 74645 207 6.895522 14.27373054 Lucilia cuprina 7375 Arthropoda Arthropoda 112 9.16e-30   NR KNC30284.1 7375 g73389 i0 72.1 0.985507246376812 68 19 98.6 0 2 205 42 109 KNC30284.1 hypothetical protein FF38_11047, partial [Lucilia cuprina] diamond 204 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
28416256 28416256 PRJNA994052_P_NODE_14866_length_313_cov_26.570833_g13645_i0 PRJNA994052 14866 313 26.570833 83.16670729 Ignelater luminosus 2038154 Arthropoda Arthropoda 52.8 7.45e-6   NR KAF2901893.1 2038154 g13645 i0 52.6 1.21725239616613 57 26 53.7 1 213 46 102 158 KAF2901893.1 hypothetical protein ILUMI_04294 [Ignelater luminosus] diamond 381 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Elateridae Ignelater Ignelater luminosus
28416266 28416266 PRJNA994052_P_NODE_66366_length_217_cov_28.298611_g65110_i0 PRJNA994052 66366 217 28.298611 61.40798587 Apolygus lucorum 248454 Arthropoda Arthropoda 45.8 0.00176   NR KAF6202109.1 248454 g65110 i0 68.8 0.442396313364055 32 9 44.2 1 97 2 41 71 KAF6202109.1 hypothetical protein GE061_004507 [Apolygus lucorum] diamond 96 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
28542642 28542642 PRJNA994052_P_NODE_54407_length_234_cov_30.944099_g53152_i0 PRJNA994052 54407 234 30.944099 72.40919166 Daphnia pulex 6669 Arthropoda Arthropoda 101 1.53e-23   NR EFX62214.1 6669 g53152 i0 58.9 0.935897435897436 73 30 93.6 0 11 229 60 132 EFX62214.1 hypothetical protein DAPPUDRAFT_270798 [Daphnia pulex] diamond 219 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
28548503 28548503 PRJNA994052_P_NODE_73027_length_208_cov_1065.333333_g71771_i0 PRJNA994052 73027 208 1065.333333 2215.89333264 Metazoa 33208 Arthropoda Arthropoda 80.5 2.08e-16   NR XP_015781697.1 32264 g71771 i0 75 15.2884615384615 56 14 80.8 0 40 207 6 61 XP_015781697.1 40S ribosomal protein S3 [Tetranychus urticae] diamond 3180 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
29931904 29931904 PRJNA994052_P_NODE_33851_length_272_cov_12.537688_g32607_i0 PRJNA994052 33851 272 12.537688 34.10251136 Pectinophora gossypiella 13191 Arthropoda Arthropoda 44.7 0.0113   NR XP_049874095.1 13191 g32607 i0 37.9 3.19852941176471 58 30 57.4 1 76 231 88 145 XP_049874095.1 regulating synaptic membrane exocytosis protein 1 isoform X1 [Pectinophora gossypiella] diamond 870 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Pectinophora Pectinophora gossypiella
30121128 30121128 PRJNA994052_P_NODE_78552_length_202_cov_41.131783_g77295_i0 PRJNA994052 78552 202 41.131783 83.08620166 Tribolium castaneum 7070 Arthropoda Arthropoda 55.1 1.88e-7   NR KYB24744.1 7070 g77295 i0 65.9 1.18811881188119 41 14 60.9 0 23 145 1 41 KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] diamond 240 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
30279655 30279655 PRJNA994052_P_NODE_70712_length_211_cov_97.123188_g69456_i0 PRJNA994052 70712 211 97.123188 204.92992668 Ochlerotatus camptorhynchus 644619 Arthropoda Arthropoda 63.5 1.16e-9   NR XP_065088351.1 644619 g69456 i0 45.8 1.7345971563981 59 24 79.6 2 11 178 95 148 XP_065088351.1 uncharacterized protein LOC135709856 [Ochlerotatus camptorhynchus] diamond 366 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus camptorhynchus
30469090 30469090 PRJNA994052_P_NODE_70553_length_212_cov_4.258993_g69297_i0 PRJNA994052 70553 212 4.258993 9.02906516 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 134 1.49e-34   NR KAH9403947.1 59818 g69297 i0 100 0.990566037735849 70 0 99.1 0 1 210 762 831 KAH9403947.1 hypothetical protein TYRP_014460 [Tyrophagus putrescentiae] diamond 210 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30500454 30500454 PRJNA994052_P_NODE_32193_length_276_cov_15.507389_g30949_i0 PRJNA994052 32193 276 15.507389 42.80039364 Cotesia congregata 51543 Arthropoda Arthropoda 84 4.45e-18   NR CAD6244479.1 51543 g30949 i0 75 1.21739130434783 56 14 60.9 0 9 176 105 160 CAD6244479.1 GSCOCG00013363001-RA-CDS [Cotesia congregata] diamond 336 84 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia congregata
30658411 30658411 PRJNA994052_P_NODE_7093_length_375_cov_2.884106_g6001_i0 PRJNA994052 7093 375 2.884106 10.8153975 Tribolium castaneum 7070 Arthropoda Arthropoda 58.5 4.3e-7   NR XP_968343.1 7070 g6001 i0 82.1 1.632 28 5 22.4 0 290 373 1 28 XP_968343.1 DNA/RNA-binding protein KIN17 [Tribolium castaneum] diamond 612 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
30721472 30721472 PRJNA994052_P_NODE_65734_length_218_cov_13.131034_g64478_i0 PRJNA994052 65734 218 13.131034 28.62565412 Amyelois transitella 680683 Arthropoda Arthropoda 58.2 8.56e-8   NR XP_013193203.2 680683 g64478 i0 42.9 0.963302752293578 70 37 96.3 1 5 214 46 112 XP_013193203.2 ribonuclease H2 subunit B [Amyelois transitella] diamond 210 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Amyelois Amyelois transitella
30911302 30911302 PRJNA994052_P_NODE_51874_length_238_cov_27.369697_g50619_i0 PRJNA994052 51874 238 27.369697 65.13987886 Tribolium castaneum 7070 Arthropoda Arthropoda 42.4 0.0218   NR KYB24744.1 7070 g50619 i0 50 0.504201680672269 40 20 50.4 0 238 119 1 40 KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] diamond 120 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
31416935 31416935 PRJNA994052_P_NODE_41516_length_255_cov_1367.620879_g40269_i0 PRJNA994052 41516 255 1367.620879 3487.43324145 Nesidiocoris tenuis 355587 Arthropoda Arthropoda 83.2 1.43e-16   NR BET02883.1 355587 g40269 i0 53.2 1.83529411764706 77 36 90.6 0 3 233 176 252 BET02883.1 epoxide hydrolase [Nesidiocoris tenuis] diamond 468 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Nesidiocoris Nesidiocoris tenuis
31575261 31575261 PRJNA994052_P_NODE_9036_length_349_cov_1171.601449_g7848_i0 PRJNA994052 9036 349 1171.601449 4088.88905701 Anopheles stephensi 30069 Arthropoda Arthropoda 117 9.32e-31   NR XP_035902640.1 30069 g7848 i0 77.9 0.66189111747851 77 17 66.2 0 348 118 2 78 XP_035902640.1 uncharacterized protein LOC118507745 [Anopheles stephensi] diamond 231 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles stephensi
31669916 31669916 PRJNA994052_P_NODE_17877_length_312_cov_3.046025_g16656_i0 PRJNA994052 17877 312 3.046025 9.503598 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 88.6 3.79e-19   NR KAH9398410.1 59818 g16656 i0 100 0.471153846153846 49 0 47.1 0 164 310 58 106 KAH9398410.1 hypothetical protein TYRP_019058 [Tyrophagus putrescentiae] diamond 147 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31669925 31669925 PRJNA994052_P_NODE_62157_length_223_cov_6.900000_g60901_i0 PRJNA994052 62157 223 6.9 15.387 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 109 1.68e-26   NR KAH9401057.1 59818 g60901 i0 100 0.739910313901345 55 0 74 0 58 222 311 365 KAH9401057.1 PDZ domain-containing protein gipc3 [Tyrophagus putrescentiae] diamond 165 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31764814 31764814 PRJNA994052_P_NODE_22077_length_304_cov_5.549784_g20849_i0 PRJNA994052 22077 304 5.549784 16.87134336 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 65.5 2.12e-11   NR KAG4079719.1 1564500 g20849 i0 81 0.414473684210526 42 8 41.4 0 281 156 1 42 KAG4079719.1 hypothetical protein HA402_004424 [Bradysia odoriphaga] diamond 126 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
32334657 32334657 PRJNA994052_P_NODE_24979_length_295_cov_8.400901_g23743_i0 PRJNA994052 24979 295 8.400901 24.78265795 Diachasmimorpha longicaudata 58733 Arthropoda Arthropoda 73.2 1.34e-12   NR XP_063992750.1 58733 g23743 i0 69.8 0.874576271186441 43 13 43.7 0 134 6 212 254 XP_063992750.1 ATP-dependent RNA helicase vasa [Diachasmimorpha longicaudata] diamond 258 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
32681553 32681553 PRJNA994052_P_NODE_25400_length_294_cov_3.787330_g24163_i0 PRJNA994052 25400 294 3.78733 11.1347502 Lucilia cuprina 7375 Arthropoda Arthropoda 92.4 2.26e-19   NR KNC29051.1 7375 g24163 i0 52.6 0.775510204081633 76 36 77.6 0 292 65 157 232 KNC29051.1 hypothetical protein FF38_03280 [Lucilia cuprina] diamond 228 92.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
32713283 32713283 PRJNA994052_P_NODE_70560_length_212_cov_4.057554_g69304_i0 PRJNA994052 70560 212 4.057554 8.60201448 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 124 4.869999999999999e-31   NR KAH9404569.1 59818 g69304 i0 98.3 0.834905660377358 59 1 83.5 0 210 34 289 347 KAH9404569.1 E3 ubiquitin-protein ligase ubr3, partial [Tyrophagus putrescentiae] diamond 177 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32807731 32807731 PRJNA994052_P_NODE_62940_length_221_cov_1270.236486_g61684_i0 PRJNA994052 62940 221 1270.236486 2807.22263406 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 46.6 0.0012   NR XP_066947097.1 79674 g61684 i0 43.2 1.00452488687783 74 31 85.5 3 197 9 252 325 XP_066947097.1 zinc finger BED domain-containing protein 4-like [Macrobrachium rosenbergii] diamond 222 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
32839168 32839168 PRJNA994052_P_NODE_65360_length_218_cov_64.200000_g64104_i0 PRJNA994052 65360 218 64.2 139.956 Limulus polyphemus 6850 Arthropoda Arthropoda 114 1.83e-28   NR XP_013782647.1 6850 g64104 i0 78.6 0.963302752293578 70 15 96.3 0 4 213 137 206 XP_013782647.1 fructose-1,6-bisphosphatase 1-like [Limulus polyphemus] diamond 210 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus

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