RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA577226 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
1836720 1836720 PRJNA577226_S_NODE_17962_length_301_cov_6.905303_g17023_i0 PRJNA577226 17962 301 6.905303 20.78496203 Thrips palmi 161013 Arthropoda Arthropoda 141 4.529999999999999e-37   NR XP_034234497.1 161013 g17023 i0 79.3 14.8803986710963 82 17 81.7 0 294 49 479 560 XP_034234497.1 lysine--tRNA ligase isoform X2 [Thrips palmi] diamond 4479 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
10767021 10767021 PRJNA577226_S_NODE_7469_length_494_cov_2.159737_g6538_i0 PRJNA577226 7469 494 2.159737 10.66910078 Sciaridae 7184 Arthropoda Arthropoda 234 3.32e-76   NR KAJ6637649.1 35572 g6538 i0 97.7 1.5668016194332 129 3 78.3 0 106 492 10 138 KAJ6637649.1 Myosin regulatory light chain 2, partial [Pseudolycoriella hygida] diamond 774 234 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
11340687 11340687 PRJNA577226_S_NODE_41369_length_193_cov_1.993590_g40430_i0 PRJNA577226 41369 193 1.99359 3.8476287 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 112 8.55e-30   NR XP_055296136.1 263140 g40430 i0 84.4 1.98963730569948 64 10 99.5 0 2 193 16 79 XP_055296136.1 myosin light chain alkali [Sitodiplosis mosellana] diamond 384 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
17140032 17140032 PRJNA577226_S_NODE_58354_length_164_cov_1.535433_g57415_i0 PRJNA577226 58354 164 1.535433 2.51811012 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 96.7 1.96e-22   NR KAJ6634753.1 35572 g57415 i0 82.7 2.85365853658537 52 8 95.1 1 156 1 47 97 KAJ6634753.1 hypothetical protein Bhyg_13332 [Pseudolycoriella hygida] diamond 468 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
19688094 19688094 PRJNA577226_S_NODE_30876_length_225_cov_1.452128_g29937_i0 PRJNA577226 30876 225 1.452128 3.267288 Mayetiola destructor 39758 Arthropoda Arthropoda 155 4.02e-45   NR AHB50498.1 39758 g29937 i0 94.7 2 75 4 100 0 1 225 56 130 AHB50498.1 succinate dehydrogenase B, partial [Mayetiola destructor] diamond 450 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Mayetiola Mayetiola destructor
23514893 23514893 PRJNA577226_S_NODE_61959_length_160_cov_1.219512_g61020_i0 PRJNA577226 61959 160 1.219512 1.9512192 Insecta 50557 Arthropoda Arthropoda 103 4.55e-24   NR CAK1586805.1 213953 g61020 i0 88.7 6.9375 53 6 99.4 0 159 1 368 420 CAK1586805.1 unnamed protein product [Parnassius mnemosyne] diamond 1110 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius mnemosyne
24788665 24788665 PRJNA577226_S_NODE_64620_length_157_cov_1.291667_g63681_i0 PRJNA577226 64620 157 1.291667 2.02791719 Hermetia illucens 343691 Arthropoda Arthropoda 80.1 1.2e-16   NR XP_037926877.1 343691 g63681 i0 94.6 13.4331210191083 37 2 70.7 0 156 46 195 231 XP_037926877.1 cytochrome b-c1 complex subunit Rieske, mitochondrial-like isoform X2 [Hermetia illucens] diamond 2109 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
26699589 26699589 PRJNA577226_S_NODE_57981_length_165_cov_0.914062_g57042_i0 PRJNA577226 57981 165 0.914062 1.5082023 Bradysia coprophila 38358 Arthropoda Arthropoda 103 3.1e-25   NR XP_037028769.1 38358 g57042 i0 90.7 0.981818181818182 54 5 98.2 0 3 164 170 223 XP_037028769.1 lipid storage droplets surface-binding protein 2 [Bradysia coprophila] diamond 162 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
27061498 27061498 PRJNA577226_S_NODE_57362_length_165_cov_2.125000_g56423_i0 PRJNA577226 57362 165 2.125 3.50625 Metazoa 33208 Arthropoda Arthropoda 110 1.24e-26   NR XP_046438519.1 6669 g56423 i0 98.1 237.6 54 1 98.2 0 164 3 213 266 XP_046438519.1 endoplasmic reticulum chaperone BiP [Daphnia pulex] diamond 39204 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27174227 27174227 PRJNA577226_S_NODE_51062_length_175_cov_1.130435_g50123_i0 PRJNA577226 51062 175 1.130435 1.97826125 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 92.8 3.25e-23   NR KAG4067434.1 1564500 g50123 i0 72.4 0.994285714285714 58 16 99.4 0 175 2 4 61 KAG4067434.1 hypothetical protein HA402_009671 [Bradysia odoriphaga] diamond 174 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
27205769 27205769 PRJNA577226_S_NODE_12422_length_368_cov_6.942598_g11483_i0 PRJNA577226 12422 368 6.942598 25.54876064 Cylas formicarius 197179 Arthropoda Arthropoda 47.8 0.00156   NR XP_060519304.1 197179 g11483 i0 35.6 3.75 73 46 59.5 1 1 219 99 170 XP_060519304.1 glutathione S-transferase-like [Cylas formicarius] diamond 1380 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Brentidae Cylas Cylas formicarius
27945993 27945993 PRJNA577226_S_NODE_63365_length_158_cov_1.611570_g62426_i0 PRJNA577226 63365 158 1.61157 2.5462806 Diptera 7147 Arthropoda Arthropoda 68.2 1.25e-11   NR XP_038118605.1 7176 g62426 i0 94.1 35.5063291139241 34 2 64.6 0 156 55 606 639 XP_038118605.1 arginine kinase isoform X1 [Culex quinquefasciatus] diamond 5610 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
28090253 28090253 PRJNA577226_S_NODE_64545_length_157_cov_1.300000_g63606_i0 PRJNA577226 64545 157 1.3 2.041 Contarinia nasturtii 265458 Arthropoda Arthropoda 48.1 1.08e-4   NR XP_031616934.1 265458 g63606 i0 82.1 0.535031847133758 28 5 53.5 0 153 70 183 210 XP_031616934.1 ferritin subunit-like [Contarinia nasturtii] diamond 84 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
28293171 28293171 PRJNA577226_S_NODE_30586_length_226_cov_1.439153_g29647_i0 PRJNA577226 30586 226 1.439153 3.25248578 Sciaridae 7184 Arthropoda Arthropoda 112 3.9899999999999997e-28   NR KAJ6634926.1 35572 g29647 i0 96.2 1.38053097345133 52 2 69 0 225 70 245 296 KAJ6634926.1 Succinate dehydrogenase [ubiquinone] iron-sulfur subunit, mitochondrial [Pseudolycoriella hygida] diamond 312 113 0.991150442477876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
28311432 28311432 PRJNA577226_S_NODE_44786_length_186_cov_1.442953_g43847_i0 PRJNA577226 44786 186 1.442953 2.68389258 Bradysia coprophila 38358 Arthropoda Arthropoda 109 7.150000000000001e-27   NR XP_037036049.1 38358 g43847 i0 82 3.93548387096774 61 11 98.4 0 2 184 69 129 XP_037036049.1 uncharacterized protein ZK1073.1 isoform X1 [Bradysia coprophila] diamond 732 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28469394 28469394 PRJNA577226_S_NODE_54246_length_170_cov_1.172932_g53307_i0 PRJNA577226 54246 170 1.172932 1.9939844 Bradysia coprophila 38358 Arthropoda Arthropoda 111 1.03e-26   NR XP_037024648.1 38358 g53307 i0 89.3 1.97647058823529 56 6 98.8 0 3 170 523 578 XP_037024648.1 probable aconitate hydratase, mitochondrial isoform X1 [Bradysia coprophila] diamond 336 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28546130 28546130 PRJNA577226_S_NODE_70107_length_152_cov_1.000000_g69168_i0 PRJNA577226 70107 152 1 1.52 Sciaridae 7184 Arthropoda Arthropoda 92.4 3.0600000000000003e-21   NR KAJ6648247.1 35572 g69168 i0 84 2.74342105263158 50 8 98.7 0 152 3 34 83 KAJ6648247.1 NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial, partial [Pseudolycoriella hygida] diamond 417 92.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
28735337 28735337 PRJNA577226_S_NODE_68907_length_153_cov_1.008621_g67968_i0 PRJNA577226 68907 153 1.008621 1.54319013 Sciaridae 7184 Arthropoda Arthropoda 100 3.549999999999999e-23   NR KAJ6647443.1 35572 g67968 i0 92 1.96078431372549 50 4 98 0 2 151 395 444 KAJ6647443.1 Mpv17-like protein 2 [Pseudolycoriella hygida] diamond 300 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
29051226 29051226 PRJNA577226_S_NODE_69428_length_152_cov_1.695652_g68489_i0 PRJNA577226 69428 152 1.695652 2.57739104 Lepidoptera 7088 Arthropoda Arthropoda 46.2 2.05e-4   NR NP_001296023.1 51655 g68489 i0 61.3 2.32894736842105 31 12 61.2 0 1 93 96 126 NP_001296023.1 ejaculatory bulb-specific protein 3-like precursor [Plutella xylostella] diamond 354 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
29713730 29713730 PRJNA577226_S_NODE_41670_length_193_cov_0.987179_g40731_i0 PRJNA577226 41670 193 0.987179 1.90525547 Sciaridae 7184 Arthropoda Arthropoda 99.4 3.09e-23   NR KAJ6641986.1 35572 g40731 i0 79.7 1.98963730569948 64 13 99.5 0 1 192 13 76 KAJ6641986.1 Cytochrome c1, heme protein, mitochondrial [Pseudolycoriella hygida] diamond 384 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
30409446 30409446 PRJNA577226_S_NODE_69613_length_152_cov_1.356522_g68674_i0 PRJNA577226 69613 152 1.356522 2.06191344 Arthropoda 6656 Arthropoda Arthropoda 77.4 3.82e-15   NR XP_055685068.1 7200 g68674 i0 72.9 10.6184210526316 48 12 94.7 1 1 144 280 326 XP_055685068.1 growth hormone-inducible transmembrane protein-like [Lutzomyia longipalpis] diamond 1614 77.8 0.994858611825193 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
30901184 30901184 PRJNA577226_S_NODE_60194_length_162_cov_1.248000_g59255_i0 PRJNA577226 60194 162 1.248 2.02176 Ochlerotatus camptorhynchus 644619 Arthropoda Arthropoda 53.1 2.58e-6   NR XP_065078460.1 644619 g59255 i0 59.5 0.777777777777778 42 12 68.5 1 112 2 127 168 XP_065078460.1 activating signal cointegrator 1 complex subunit 2 homolog [Ochlerotatus camptorhynchus] diamond 126 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus camptorhynchus
30932755 30932755 PRJNA577226_S_NODE_46774_length_182_cov_1.882759_g45835_i0 PRJNA577226 46774 182 1.882759 3.42662138 Bradysia coprophila 38358 Arthropoda Arthropoda 73.2 3.07e-13   NR XP_037051561.1 38358 g45835 i0 63.8 2.85164835164835 58 18 94 2 180 10 1257 1312 XP_037051561.1 vascular endothelial growth factor receptor 1 isoform X1 [Bradysia coprophila] diamond 519 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
31027650 31027650 PRJNA577226_S_NODE_40315_length_196_cov_1.484277_g39376_i0 PRJNA577226 40315 196 1.484277 2.90918292 Bradysia coprophila 38358 Arthropoda Arthropoda 85.5 1.63e-18   NR XP_037028250.1 38358 g39376 i0 62.3 0.933673469387755 61 23 93.4 0 193 11 143 203 XP_037028250.1 ferritin heavy chain [Bradysia coprophila] diamond 183 85.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
31059391 31059391 PRJNA577226_S_NODE_39055_length_199_cov_1.685185_g38116_i0 PRJNA577226 39055 199 1.685185 3.35351815 Contarinia nasturtii 265458 Arthropoda Arthropoda 97.1 5.34e-23   NR XP_031625297.1 265458 g38116 i0 69.8 1.89949748743719 63 19 95 0 11 199 31 93 XP_031625297.1 soma ferritin [Contarinia nasturtii] diamond 378 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
31311904 31311904 PRJNA577226_S_NODE_59935_length_162_cov_1.560000_g58996_i0 PRJNA577226 59935 162 1.56 2.5272 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 80.9 7.37e-17   NR XP_055317713.1 263140 g58996 i0 79.2 1.96296296296296 53 11 98.1 0 161 3 112 164 XP_055317713.1 LOW QUALITY PROTEIN: ornithine decarboxylase antizyme [Sitodiplosis mosellana] diamond 318 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
31470268 31470268 PRJNA577226_S_NODE_40136_length_196_cov_2.446541_g39197_i0 PRJNA577226 40136 196 2.446541 4.79522036 Glossina fuscipes 7396 Arthropoda Arthropoda 42.4 0.0263   NR XP_037897847.1 7396 g39197 i0 86.4 0.75 22 3 33.7 0 196 131 235 256 XP_037897847.1 myosin regulatory light chain 2-like [Glossina fuscipes] diamond 147 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
31754696 31754696 PRJNA577226_S_NODE_42917_length_190_cov_1.352941_g41978_i0 PRJNA577226 42917 190 1.352941 2.5705879 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 112 3.5400000000000005e-27   NR KAJ6648613.1 35572 g41978 i0 88.7 0.978947368421053 62 7 97.9 0 188 3 350 411 KAJ6648613.1 Succinate dehydrogenase [ubiquinone] flavoprotein subunit, mitochondrial [Pseudolycoriella hygida] diamond 186 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
32148004 32148004 PRJNA577226_S_NODE_23158_length_262_cov_1.213333_g22219_i0 PRJNA577226 23158 262 1.213333 3.17893246 Insecta 50557 Arthropoda Arthropoda 57.8 1.87e-7   NR KAG4066122.1 1564500 g22219 i0 46.8 2.08396946564885 62 29 69.8 2 185 3 1 59 KAG4066122.1 hypothetical protein HA402_010324 [Bradysia odoriphaga] diamond 546 58.2 0.993127147766323 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
32243196 32243196 PRJNA577226_S_NODE_31698_length_222_cov_1.264865_g30759_i0 PRJNA577226 31698 222 1.264865 2.8080003 Phlebotomus 13203 Arthropoda Arthropoda 57.8 1.31e-7   NR XP_055710069.1 29031 g30759 i0 41.2 2.28378378378378 85 38 98.6 3 2 220 114 198 XP_055710069.1 uncharacterized protein LOC129805870 [Phlebotomus papatasi] diamond 507 58.2 0.993127147766323 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
32464492 32464492 PRJNA577226_S_NODE_36339_length_206_cov_3.082840_g35400_i0 PRJNA577226 36339 206 3.08284 6.3506504 Daphnia 6668 Arthropoda Arthropoda 42 0.044   NR KAK4022638.1 35525 g35400 i0 37.1 2.70873786407767 62 35 90.3 1 198 13 542 599 KAK4022638.1 hypothetical protein OUZ56_008095 [Daphnia magna] diamond 558 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
32685107 32685107 PRJNA577226_S_NODE_43880_length_188_cov_1.284768_g42941_i0 PRJNA577226 43880 188 1.284768 2.41536384 Diptera 7147 Arthropoda Arthropoda 109 1.1599999999999999e-28   NR XP_037026813.1 38358 g42941 i0 82.3 1.97872340425532 62 11 98.9 0 187 2 28 89 XP_037026813.1 60S ribosomal protein L14 [Bradysia coprophila] diamond 372 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
32860690 32860690 PRJNA577226_S_NODE_53620_length_171_cov_1.164179_g52681_i0 PRJNA577226 53620 171 1.164179 1.99074609 Contarinia nasturtii 265458 Arthropoda Arthropoda 84.7 1.54e-18   NR XP_031616935.1 265458 g52681 i0 67.3 1.94736842105263 55 18 96.5 0 5 169 12 66 XP_031616935.1 ferritin subunit-like [Contarinia nasturtii] diamond 333 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii

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