RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA637219 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26618652 26618652 PRJNA637219_S_NODE_15221_length_163_cov_0.894737_g15176_i0 PRJNA637219 15221 163 0.894737 1.45842131 Hemiptera 7524 Arthropoda Arthropoda 54.7 7.75e-7   NR KAI5753261.1 121845 g15176 i0 55.3 6.2760736196319 38 17 69.9 0 123 10 726 763 KAI5753261.1 hypothetical protein M8J77_025240 [Diaphorina citri] diamond 1023 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
26713383 26713383 PRJNA637219_S_NODE_10781_length_167_cov_0.864407_g10736_i0 PRJNA637219 10781 167 0.864407 1.44355969 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.2 4.82e-8   NR OXA51685.1 158441 g10736 i0 51.1 6.17964071856287 45 22 80.8 0 28 162 366 410 OXA51685.1 RCC1 and BTB domain-containing protein 1 [Folsomia candida] diamond 1032 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
26796222 26796222 PRJNA637219_S_NODE_7721_length_187_cov_5.043478_g7676_i0 PRJNA637219 7721 187 5.043478 9.43130386 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00689   NR CAK9813121.1 597819 g7676 i0 48.6 2.80748663101604 35 18 56.1 0 43 147 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
27346512 27346512 PRJNA637219_S_NODE_12683_length_165_cov_0.879310_g12638_i0 PRJNA637219 12683 165 0.87931 1.4508615 Metazoa 33208 Arthropoda Arthropoda 43.5 0.00694   NR XP_055696472.1 7200 g12638 i0 37.8 4.47272727272727 45 28 81.8 0 16 150 11 55 XP_055696472.1 apolipoprotein D-like [Lutzomyia longipalpis] diamond 738 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
27618233 27618233 PRJNA637219_S_NODE_5244_length_216_cov_1.502994_g5199_i0 PRJNA637219 5244 216 1.502994 3.24646704 Tanypteryx pryeri 126203 Arthropoda Arthropoda 46.2 0.00121   NR AIJ00016.1 126203 g5199 i0 55 0.555555555555556 40 18 55.6 0 19 138 172 211 AIJ00016.1 cytochrome oxidase subunit I, partial [Tanypteryx pryeri] diamond 120 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Petaluridae Tanypteryx Tanypteryx pryeri
28091647 28091647 PRJNA637219_S_NODE_4825_length_223_cov_1.022989_g4780_i0 PRJNA637219 4825 223 1.022989 2.28126547 Blomia tropicalis 40697 Arthropoda Arthropoda 43.1 0.00802   NR KAI2808396.1 40697 g4780 i0 41.7 0.968609865470852 72 42 96.9 0 7 222 53 124 KAI2808396.1 hypothetical protein BLOT_006338 [Blomia tropicalis] diamond 216 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Echimyopodidae Blomia Blomia tropicalis
28325096 28325096 PRJNA637219_S_NODE_5126_length_218_cov_1.106509_g5081_i0 PRJNA637219 5126 218 1.106509 2.41218962 Metazoa 33208 Arthropoda Arthropoda 96.3 3.82e-21   NR XP_045512639.1 7116 g5081 i0 66.7 20.8073394495413 72 24 99.1 0 216 1 586 657 XP_045512639.1 glycine--tRNA ligase [Pieris brassicae] diamond 4536 97.1 0.991761071060762 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Pieris Pieris brassicae
28628674 28628674 PRJNA637219_S_NODE_3907_length_242_cov_1.305699_g3862_i0 PRJNA637219 3907 242 1.305699 3.15979158 Homarus americanus 6706 Arthropoda Arthropoda 55.5 1.37e-7   NR XP_042231662.1 6706 g3862 i0 54.2 17.3057851239669 59 27 73.1 0 178 2 34 92 XP_042231662.1 40S ribosomal protein S25-like [Homarus americanus] diamond 4188 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
28786150 28786150 PRJNA637219_S_NODE_4767_length_224_cov_0.937143_g4722_i0 PRJNA637219 4767 224 0.937143 2.09920032 Phlebotomus ariasi 59272 Arthropoda Arthropoda 65.9 1.13e-10   NR ADM88761.1 59272 g4722 i0 55.9 12.7232142857143 68 30 91.1 0 1 204 115 182 ADM88761.1 elongation factor-1 alpha, partial [Phlebotomus ariasi] diamond 2850 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus ariasi
29228588 29228588 PRJNA637219_S_NODE_12129_length_166_cov_0.871795_g12084_i0 PRJNA637219 12129 166 0.871795 1.4471797 Aphis craccivora 307492 Arthropoda Arthropoda 65.5 1.21e-11   NR KAF0755455.1 307492 g12084 i0 64.2 2.87349397590361 53 19 95.8 0 159 1 6 58 KAF0755455.1 putative secreted protein [Aphis craccivora] diamond 477 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
29430051 29430051 PRJNA637219_S_NODE_13409_length_164_cov_1.156522_g13364_i0 PRJNA637219 13409 164 1.156522 1.89669608 Arthropoda 6656 Arthropoda Arthropoda 55.1 2.01e-7   NR CAC19712.1 115809 g13364 i0 59.2 67.1707317073171 49 20 89.6 0 3 149 93 141 CAC19712.1 cytochrome C oxidase I, partial [Orchesella chiantica] diamond 11016 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella chiantica
29575463 29575463 PRJNA637219_S_NODE_12390_length_165_cov_1.258621_g12345_i0 PRJNA637219 12390 165 1.258621 2.07672465 Ephemera danica 1049336 Arthropoda Arthropoda 43.1 0.00931   NR KAF4532500.1 1049336 g12345 i0 40 0.909090909090909 50 30 90.9 0 14 163 210 259 KAF4532500.1 hypothetical protein B566_EDAN003076 [Ephemera danica] diamond 150 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Ephemeridae Ephemera Ephemera danica
29638456 29638456 PRJNA637219_S_NODE_15710_length_162_cov_0.902655_g15665_i0 PRJNA637219 15710 162 0.902655 1.4623011 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 54.3 9.54e-7   NR XP_021922401.1 136037 g15665 i0 58.1 0.796296296296296 43 18 79.6 0 131 3 1 43 XP_021922401.1 graves disease carrier protein-like isoform X2 [Zootermopsis nevadensis] diamond 129 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
29796542 29796542 PRJNA637219_S_NODE_15891_length_162_cov_0.902655_g15846_i0 PRJNA637219 15891 162 0.902655 1.4623011 Phlebotomus papatasi 29031 Arthropoda Arthropoda 95.9 2.3100000000000003e-21   NR XP_055713765.1 29031 g15846 i0 84.3 2.83333333333333 51 8 94.4 0 158 6 222 272 XP_055713765.1 very long-chain-fatty-acid--CoA ligase bubblegum [Phlebotomus papatasi] diamond 459 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
30030379 30030379 PRJNA637219_S_NODE_6791_length_197_cov_0.979730_g6746_i0 PRJNA637219 6791 197 0.97973 1.9300681 Chrysomelidae 27439 Arthropoda Arthropoda 70.1 4.6e-12   NR VEN47223.1 64391 g6746 i0 55 18.3959390862944 60 27 91.4 0 183 4 788 847 VEN47223.1 unnamed protein product [Callosobruchus maculatus] diamond 3624 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Callosobruchus Callosobruchus maculatus
31850934 31850934 PRJNA637219_S_NODE_3097_length_266_cov_1.244240_g3052_i0 PRJNA637219 3097 266 1.24424 3.3096784 Phlebotomus papatasi 29031 Arthropoda Arthropoda 60.5 1.32e-8   NR XP_055707395.1 29031 g3052 i0 54 1.80451127819549 87 40 98.1 0 2 262 111 197 XP_055707395.1 40S ribosomal protein S5 [Phlebotomus papatasi] diamond 480 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
31863344 31863344 PRJNA637219_S_NODE_13957_length_164_cov_0.886957_g13912_i0 PRJNA637219 13957 164 0.886957 1.45460948 Metazoa 33208 Arthropoda Arthropoda 74.7 5e-14   NR XP_056630568.1 1163346 g13912 i0 68 4.46341463414634 50 16 91.5 0 150 1 109 158 XP_056630568.1 protein ABHD13 [Diorhabda sublineata] diamond 732 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diorhabda Diorhabda sublineata

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