RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA526367" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA526367 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
3046752 3046752 PRJNA526367_P_NODE_22023_length_324_cov_2.269091_g21814_i0 PRJNA526367 22023 324 2.269091 7.35185484 Ceratitis capitata 7213 Arthropoda Arthropoda 104 1.93e-23   NR CAD7015493.1 7213 g21814 i0 52.7 1.01851851851852 110 8 99.1 2 3 323 222 290 CAD7015493.1 unnamed protein product [Ceratitis capitata] diamond 330 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
11974746 11974746 PRJNA526367_P_NODE_3970_length_346_cov_4.545455_g3762_i0 PRJNA526367 3970 346 4.545455 15.7272743 Insecta 50557 Arthropoda Arthropoda 61.2 2.29e-8   NR KAH8375738.1 30044 g3762 i0 90.3 1.07514450867052 31 3 26.9 0 6 98 112 142 KAH8375738.1 hypothetical protein KR093_008377, partial [Drosophila rubida] diamond 372 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila rubida
27140245 27140245 PRJNA526367_P_NODE_45422_length_174_cov_1.632000_g45212_i0 PRJNA526367 45422 174 1.632 2.83968 Diabrotica virgifera virgifera 50390 Arthropoda Arthropoda 70.1 3.39e-12   NR XP_050507928.1 50390 g45212 i0 60.4 0.913793103448276 53 21 91.4 0 168 10 264 316 XP_050507928.1 probable RNA-directed DNA polymerase from transposon BS [Diabrotica virgifera virgifera] diamond 159 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
27614628 27614628 PRJNA526367_P_NODE_48624_length_169_cov_3.908333_g48414_i0 PRJNA526367 48624 169 3.908333 6.60508277 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 100 3.9499999999999996e-23   NR KAH9409368.1 59818 g48414 i0 98.1 0.940828402366864 53 1 94.1 0 9 167 376 428 KAH9409368.1 hypothetical protein TYRP_010374 [Tyrophagus putrescentiae] diamond 159 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27993463 27993463 PRJNA526367_P_NODE_46005_length_173_cov_2.709677_g45795_i0 PRJNA526367 46005 173 2.709677 4.68774121 Oedothorax gibbosus 931172 Arthropoda Arthropoda 42.4 0.02   NR KAG8187541.1 931172 g45795 i0 100 1.85549132947977 19 0 32.9 0 168 112 260 278 KAG8187541.1 hypothetical protein JTE90_008428 [Oedothorax gibbosus] diamond 321 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
28056392 28056392 PRJNA526367_P_NODE_61565_length_156_cov_4.317757_g61355_i0 PRJNA526367 61565 156 4.317757 6.73570092 Rhagoletis zephyria 28612 Arthropoda Arthropoda 63.9 3.71e-10   NR XP_017487437.1 28612 g61355 i0 74.3 0.673076923076923 35 9 67.3 0 148 44 524 558 XP_017487437.1 PREDICTED: protein white-like [Rhagoletis zephyria] diamond 105 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
28151428 28151428 PRJNA526367_P_NODE_45405_length_174_cov_1.632000_g45195_i0 PRJNA526367 45405 174 1.632 2.83968 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 111 3.45e-27   NR KAH9401995.1 59818 g45195 i0 98.2 0.948275862068966 55 1 94.8 0 166 2 223 277 KAH9401995.1 Nucleoside diphosphate-linked moiety X motif 19, mitochondrial [Tyrophagus putrescentiae] diamond 165 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29256086 29256086 PRJNA526367_P_NODE_11709_length_324_cov_3.316364_g11500_i0 PRJNA526367 11709 324 3.316364 10.74501936 Caerostris extrusa 172846 Arthropoda Arthropoda 47.8 2.96e-4   NR GIY58481.1 172846 g11500 i0 31.9 0.842592592592593 91 18 84.3 1 283 11 49 95 GIY58481.1 uncharacterized protein CEXT_311891 [Caerostris extrusa] diamond 273 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
29351121 29351121 PRJNA526367_P_NODE_55389_length_163_cov_0.894737_g55179_i0 PRJNA526367 55389 163 0.894737 1.45842131 Frankliniella occidentalis 133901 Arthropoda Arthropoda 80.5 7.8e-17   NR XP_052130871.1 133901 g55179 i0 83.7 1.58282208588957 43 7 79.1 0 34 162 1 43 XP_052130871.1 E3 ubiquitin-protein ligase XIAP-like [Frankliniella occidentalis] diamond 258 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
30014293 30014293 PRJNA526367_P_NODE_40611_length_182_cov_2.300752_g40401_i0 PRJNA526367 40611 182 2.300752 4.18736864 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 105 9.6e-25   NR KAH9389936.1 59818 g40401 i0 100 0.93956043956044 57 0 94 0 3 173 694 750 KAH9389936.1 Calpain-1 catalytic subunit [Tyrophagus putrescentiae] diamond 171 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30172083 30172083 PRJNA526367_P_NODE_56652_length_162_cov_0.902655_g56442_i0 PRJNA526367 56652 162 0.902655 1.4623011 Orchesella dallaii 48710 Arthropoda Arthropoda 77.8 5.34e-15   NR CAL8109741.1 48710 g56442 i0 68 0.925925925925926 50 16 92.6 0 11 160 941 990 CAL8109741.1 unnamed protein product [Orchesella dallaii] diamond 150 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
30867215 30867215 PRJNA526367_P_NODE_61034_length_156_cov_9.728972_g60824_i0 PRJNA526367 61034 156 9.728972 15.17719632 Thrips palmi 161013 Arthropoda Arthropoda 67.4 2.23e-11   NR XP_034246904.1 161013 g60824 i0 64.4 0.865384615384615 45 16 86.5 0 145 11 460 504 XP_034246904.1 uncharacterized protein LOC117648507 [Thrips palmi] diamond 135 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
31151231 31151231 PRJNA526367_P_NODE_65455_length_151_cov_5.745098_g65245_i0 PRJNA526367 65455 151 5.745098 8.67509798 Tribolium castaneum 7070 Arthropoda Arthropoda 51.2 2.8e-6   NR KYB24744.1 7070 g65245 i0 70.3 1.50993377483444 37 11 73.5 0 27 137 1 37 KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] diamond 228 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
31182927 31182927 PRJNA526367_P_NODE_44715_length_175_cov_3.063492_g44505_i0 PRJNA526367 44715 175 3.063492 5.361111 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 116 8.249999999999999e-31   NR KAH9400639.1 59818 g44505 i0 100 0.874285714285714 51 0 87.4 0 10 162 172 222 KAH9400639.1 hypothetical protein TYRP_002209 [Tyrophagus putrescentiae] diamond 153 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31910719 31910719 PRJNA526367_P_NODE_62417_length_155_cov_3.358491_g62207_i0 PRJNA526367 62417 155 3.358491 5.20566105 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 107 2.54e-25   NR KAH9405660.1 59818 g62207 i0 100 0.948387096774194 49 0 94.8 0 3 149 703 751 KAH9405660.1 chitin synthase I [Tyrophagus putrescentiae] diamond 147 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32259088 32259088 PRJNA526367_P_NODE_10678_length_324_cov_3.483636_g10469_i0 PRJNA526367 10678 324 3.483636 11.28698064 Leptotrombidium deliense 299467 Arthropoda Arthropoda 60.5 5.83e-8   NR RWS24871.1 299467 g10469 i0 93.9 0.916666666666667 33 2 30.6 0 322 224 380 412 RWS24871.1 cohesin subunit SA-1-like protein [Leptotrombidium deliense] diamond 297 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
32290789 32290789 PRJNA526367_P_NODE_37419_length_187_cov_6.065217_g37209_i0 PRJNA526367 37419 187 6.065217 11.34195579 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00662   NR CAK9813121.1 597819 g37209 i0 48.6 2.80748663101604 35 18 56.1 0 51 155 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
32290800 32290800 PRJNA526367_P_NODE_64159_length_153_cov_2.538462_g63949_i0 PRJNA526367 64159 153 2.538462 3.88384686 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 105 1.16e-24   NR KAH9389936.1 59818 g63949 i0 98 0.980392156862745 50 1 98 0 3 152 643 692 KAH9389936.1 Calpain-1 catalytic subunit [Tyrophagus putrescentiae] diamond 150 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae

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