RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA826497" 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

  • PRJNA826497 · 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
21222715 21222715 PRJNA826497_S_NODE_737_length_364_cov_3.462236_g697_i0 PRJNA826497 737 364 3.462236 12.60253904 Varroa destructor 109461 Arthropoda Arthropoda 84.7 1.71e-18   NR XP_022658338.1 109461 g697 i0 82.6 1.13736263736264 46 8 37.9 0 363 226 61 106 XP_022658338.1 cytochrome c [Varroa destructor] diamond 414 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor
26737490 26737490 PRJNA826497_S_NODE_19641_length_151_cov_6.983051_g19601_i0 PRJNA826497 19641 151 6.983051 10.54440701 Lasius niger 67767 Arthropoda Arthropoda 48.1 1.23e-4   NR KMQ86303.1 67767 g19601 i0 45 0.794701986754967 40 22 79.5 0 147 28 206 245 KMQ86303.1 copia protein [Lasius niger] diamond 120 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
27568556 27568556 PRJNA826497_S_NODE_2504_length_270_cov_8.582278_g2464_i0 PRJNA826497 2504 270 8.582278 23.1721506 Arthropoda 6656 Arthropoda Arthropoda 56.2 8.34e-7   NR XP_065579410.1 6661 g2464 i0 45.5 3.04444444444444 66 33 72.2 3 5 199 256 319 XP_065579410.1 WD repeat domain phosphoinositide-interacting protein 3-like isoform X1 [Artemia franciscana] diamond 822 56.6 0.992932862190813 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28105286 28105286 PRJNA826497_S_NODE_4245_length_237_cov_3.166667_g4205_i0 PRJNA826497 4245 237 3.166667 7.50500079 Metazoa 33208 Arthropoda Arthropoda 44.7 0.00684   NR XP_064483298.1 34597 g4205 i0 41.3 3.53164556962025 63 33 79.7 2 12 200 183 241 XP_064483298.1 uncharacterized protein LOC135396201 [Ornithodoros turicata] diamond 837 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
28254520 28254520 PRJNA826497_S_NODE_17006_length_159_cov_1.460317_g16966_i0 PRJNA826497 17006 159 1.460317 2.32190403 Schistocerca gregaria 7010 Arthropoda Arthropoda 70.5 3.33e-13   NR XP_049852132.1 7010 g16966 i0 60.8 0.962264150943396 51 20 96.2 0 158 6 105 155 XP_049852132.1 ras-related protein Rab-5A-like [Schistocerca gregaria] diamond 153 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28507297 28507297 PRJNA826497_S_NODE_5907_length_217_cov_5.760870_g5867_i0 PRJNA826497 5907 217 5.76087 12.5010879 Cotesia glomerata 32391 Arthropoda Arthropoda 50.1 3.12e-5   NR XP_044587611.1 32391 g5867 i0 53.5 1.1889400921659 43 18 56.7 1 14 136 129 171 XP_044587611.1 glycine cleavage system H protein [Cotesia glomerata] diamond 258 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
28507298 28507298 PRJNA826497_S_NODE_8227_length_198_cov_3.800000_g8187_i0 PRJNA826497 8227 198 3.8 7.524 Oppiella nova 334625 Arthropoda Arthropoda 110 2.67e-26   NR CAD7646424.1 334625 g8187 i0 82.8 0.96969696969697 64 11 97 0 5 196 455 518 CAD7646424.1 unnamed protein product [Oppiella nova] diamond 192 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
28949481 28949481 PRJNA826497_S_NODE_20308_length_150_cov_2.196581_g20268_i0 PRJNA826497 20308 150 2.196581 3.2948715 Triops cancriformis 194544 Arthropoda Arthropoda 80.9 3.29e-16   NR CAG4652015.1 194544 g20268 i0 77.6 7.84 49 11 98 0 149 3 341 389 CAG4652015.1 EOG090X0A33 [Triops cancriformis] diamond 1176 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Notostraca Triopsidae Triops Triops cancriformis
29264817 29264817 PRJNA826497_S_NODE_269_length_494_cov_11.720174_g231_i0 PRJNA826497 269 494 11.720174 57.89765956 Oppia nitens 1686743 Arthropoda Arthropoda 149 1.13e-40   NR XP_054162290.1 1686743 g231 i0 66 0.625506072874494 103 35 62.6 0 4 312 206 308 XP_054162290.1 uncharacterized protein LOC128960240 [Oppia nitens] diamond 309 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
30157669 30157669 PRJNA826497_S_NODE_10692_length_183_cov_4.686667_g10652_i0 PRJNA826497 10692 183 4.686667 8.57660061 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.1 5.96e-5   NR CAG7818425.1 39272 g10652 i0 40 1.67213114754098 55 33 90.2 0 19 183 66 120 CAG7818425.1 unnamed protein product, partial [Allacma fusca] diamond 306 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
30844449 30844449 PRJNA826497_S_NODE_19174_length_152_cov_13.630252_g19134_i0 PRJNA826497 19174 152 13.630252 20.71798304 Trichonephila clavipes 2585209 Arthropoda Arthropoda 43.5 0.00277   NR GFU75740.1 2585209 g19134 i0 63.3 0.592105263157895 30 11 59.2 0 92 3 110 139 GFU75740.1 hypothetical protein TNCV_1652001 [Trichonephila clavipes] diamond 90 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
31010917 31010917 PRJNA826497_S_NODE_1114_length_328_cov_4.033898_g1074_i0 PRJNA826497 1114 328 4.033898 13.23118544 Ixodes 6944 Arthropoda Arthropoda 55.8 8.52e-7   NR EEC10574.1 6945 g1074 i0 39.3 2.35060975609756 89 44 75 2 9 254 99 184 EEC10574.1 transmembrane protein C20orf108, putative [Ixodes scapularis] diamond 771 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
31105619 31105619 PRJNA826497_S_NODE_575_length_387_cov_11.228814_g535_i0 PRJNA826497 575 387 11.228814 43.45551018 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.8 0.0034   NR KAH0808894.1 7067 g535 i0 72.4 2.96899224806202 29 8 22.5 0 387 301 223 251 KAH0808894.1 hypothetical protein GEV33_013898 [Tenebrio molitor] diamond 1149 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
31255110 31255110 PRJNA826497_S_NODE_7695_length_202_cov_1.940828_g7655_i0 PRJNA826497 7695 202 1.940828 3.92047256 Oppiella nova 334625 Arthropoda Arthropoda 121 1.82e-30   NR CAD7646424.1 334625 g7655 i0 83.6 1.99009900990099 67 11 99.5 0 1 201 395 461 CAD7646424.1 unnamed protein product [Oppiella nova] diamond 402 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
32529445 32529445 PRJNA826497_S_NODE_4419_length_234_cov_11.990050_g4379_i0 PRJNA826497 4419 234 11.99005 28.056717 Caerostris 172845 Arthropoda Arthropoda 73.9 6.82e-14   NR GIY79073.1 172846 g4379 i0 63.8 2.05128205128205 80 27 100 2 234 1 45 124 GIY79073.1 hypothetical protein CEXT_388491 [Caerostris extrusa] diamond 480 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
32592482 32592482 PRJNA826497_S_NODE_7799_length_201_cov_3.440476_g7759_i0 PRJNA826497 7799 201 3.440476 6.91535676 Opisthokonta 33154 Arthropoda Arthropoda 52.8 6.29e-6   NR XP_023337860.1 1294199 g7759 i0 64.9 5.61194029850746 37 13 55.2 0 1 111 387 423 XP_023337860.1 actin-like protein 6B [Eurytemora carolleeae] diamond 1128 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
32804074 32804074 PRJNA826497_S_NODE_5560_length_221_cov_2.632979_g5520_i0 PRJNA826497 5560 221 2.632979 5.81888359 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 70.1 6.24e-12   NR CAI6363107.1 13131 g5520 i0 57.6 0.800904977375566 59 25 80.1 0 178 2 417 475 CAI6363107.1 unnamed protein product [Macrosiphum euphorbiae] diamond 177 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae

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