RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA682774" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA682774 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
664629 664629 PRJNA682774_P_NODE_1781_length_335_cov_0.854962_g1752_i0 PRJNA682774 1781 335 0.854962 2.8641227 Cyprideis torosa 163714 Arthropoda Arthropoda 176 2.3e-51   NR CAD7232849.1 163714 g1752 i0 74.8 2.98208955223881 111 25 99.4 1 2 334 178 285 CAD7232849.1 unnamed protein product [Cyprideis torosa] diamond 999 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
1174700 1174700 PRJNA682774_P_NODE_3401_length_253_cov_1.155556_g3372_i0 PRJNA682774 3401 253 1.155556 2.92355668 Halotydeus destructor 2874060 Arthropoda Arthropoda 89.7 7.85e-19   NR KAI1285882.1 2874060 g3372 i0 82.7 0.616600790513834 52 8 61.7 1 158 3 28 78 KAI1285882.1 Eukaryotic initiation factor 4A-II [Halotydeus destructor] diamond 156 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
23617512 23617512 PRJNA682774_P_NODE_1239_length_389_cov_1.234177_g1210_i0 PRJNA682774 1239 389 1.234177 4.80094853 Insecta 50557 Arthropoda Arthropoda 165 1.1699999999999998e-47   NR NP_001036387.1 7227 g1210 i0 63.3 10.827763496144 128 45 98.7 1 385 2 127 252 NP_001036387.1 ribosomal protein L5, isoform A [Drosophila melanogaster] diamond 4212 166 0.993975903614458 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
26650425 26650425 PRJNA682774_P_NODE_4561_length_247_cov_0.896552_g4532_i0 PRJNA682774 4561 247 0.896552 2.21448344 Metazoa 33208 Arthropoda Arthropoda 77 3.39e-14   NR XP_050524610.1 58002 g4532 i0 50 13.5546558704453 76 38 92.3 0 235 8 531 606 XP_050524610.1 uncharacterized protein K02A2.6-like [Daktulosphaira vitifoliae] diamond 3348 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
27125012 27125012 PRJNA682774_P_NODE_5242_length_243_cov_0.917647_g5213_i0 PRJNA682774 5242 243 0.917647 2.22988221 Araneae 6893 Arthropoda Arthropoda 80.5 1.59e-15   NR XP_055945377.1 94029 g5213 i0 44.4 11.0617283950617 81 44 100 1 1 243 64 143 XP_055945377.1 DNA primase small subunit-like [Argiope bruennichi] diamond 2688 80.9 0.995055624227441 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
27144934 27144934 PRJNA682774_P_NODE_4322_length_248_cov_0.891429_g4293_i0 PRJNA682774 4322 248 0.891429 2.21074392 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 62 6.41e-9   NR RWS17722.1 1965070 g4293 i0 61.2 1.20967741935484 49 19 59.3 0 148 2 12 60 RWS17722.1 selenoprotein O-like isoform X2 [Dinothrombium tinctorium] diamond 300 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
27524496 27524496 PRJNA682774_P_NODE_2243_length_303_cov_1.030435_g2214_i0 PRJNA682774 2243 303 1.030435 3.12221805 Rhamnusium bicolor 1586634 Arthropoda Arthropoda 48.1 0.00101   NR KAJ8936993.1 1586634 g2214 i0 31.8 0.871287128712871 88 49 86.1 3 3 263 15687 15764 KAJ8936993.1 hypothetical protein NQ314_012075 [Rhamnusium bicolor] diamond 264 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Rhamnusium Rhamnusium bicolor
27694298 27694298 PRJNA682774_P_NODE_4564_length_247_cov_0.896552_g4535_i0 PRJNA682774 4564 247 0.896552 2.21448344 Metazoa 33208 Arthropoda Arthropoda 127 8.22e-33   NR XP_037924587.1 343691 g4535 i0 70 2.92712550607287 80 24 97.2 0 245 6 221 300 XP_037924587.1 protein farnesyltransferase subunit beta [Hermetia illucens] diamond 723 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
28345394 28345394 PRJNA682774_P_NODE_5306_length_243_cov_0.900000_g5277_i0 PRJNA682774 5306 243 0.9 2.187 Tropilaelaps mercedesae 418985 Arthropoda Arthropoda 70.5 6.46e-12   NR OQR68152.1 418985 g5277 i0 68.9 0.555555555555556 45 14 55.6 0 109 243 566 610 OQR68152.1 structure-specific recognition protein-like [Tropilaelaps mercedesae] diamond 135 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Tropilaelaps Tropilaelaps mercedesae
28388573 28388573 PRJNA682774_P_NODE_4926_length_245_cov_0.906977_g4897_i0 PRJNA682774 4926 245 0.906977 2.22209365 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 44.3 0.011   NR XP_055948623.1 94029 g4897 i0 36 3.09795918367347 50 32 61.2 0 208 59 566 615 XP_055948623.1 ras guanyl-releasing protein 3-like isoform X1 [Argiope bruennichi] diamond 759 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29051890 29051890 PRJNA682774_P_NODE_5008_length_244_cov_0.912281_g4979_i0 PRJNA682774 5008 244 0.912281 2.22596564 Arachnida 6854 Arthropoda Arthropoda 67.8 7.15e-12   NR XP_035207500.1 202533 g4979 i0 68.3 2.04098360655738 41 13 50.4 0 233 111 132 172 XP_035207500.1 cathepsin L-like [Stegodyphus dumicola] diamond 498 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
29114922 29114922 PRJNA682774_P_NODE_1868_length_328_cov_1.988235_g1839_i0 PRJNA682774 1868 328 1.988235 6.5214108 Metazoa 33208 Arthropoda Arthropoda 49.7 3.41e-4   NR XP_023015979.1 7539 g1839 i0 59 2.47865853658537 39 15 34.8 1 134 247 292 330 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 813 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
29146775 29146775 PRJNA682774_P_NODE_4329_length_248_cov_0.891429_g4300_i0 PRJNA682774 4329 248 0.891429 2.21074392 Opisthokonta 33154 Arthropoda Arthropoda 45.8 0.00297   NR KAG8318641.1 197043 g4300 i0 48.3 6.24193548387097 58 30 70.2 0 6 179 89 146 KAG8318641.1 hypothetical protein J6590_001765 [Homalodisca vitripennis] diamond 1548 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
29418802 29418802 PRJNA682774_P_NODE_2569_length_287_cov_1.341121_g2540_i0 PRJNA682774 2569 287 1.341121 3.84901727 Schistocerca gregaria 7010 Arthropoda Arthropoda 76.3 5.64e-14   NR XP_049849029.1 7010 g2540 i0 42.4 0.888501742160279 85 48 88.9 1 31 285 145 228 XP_049849029.1 uncharacterized protein LOC126317096 [Schistocerca gregaria] diamond 255 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29766111 29766111 PRJNA682774_P_NODE_3751_length_251_cov_0.876404_g3722_i0 PRJNA682774 3751 251 0.876404 2.19977404 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 44.3 0.00755   NR KAF2369228.1 1923959 g3722 i0 32.1 0.932270916334661 78 41 90.8 2 1 228 41 108 KAF2369228.1 hypothetical protein FHG87_000029 [Trinorchestia longiramus] diamond 234 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
30081966 30081966 PRJNA682774_P_NODE_1312_length_380_cov_1.439739_g1283_i0 PRJNA682774 1312 380 1.439739 5.4710082 Cyprideis torosa 163714 Arthropoda Arthropoda 48.9 0.00104   NR CAD7228575.1 163714 g1283 i0 33 0.860526315789474 109 53 86.1 5 336 10 262 350 CAD7228575.1 unnamed protein product [Cyprideis torosa] diamond 327 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
30240149 30240149 PRJNA682774_P_NODE_2912_length_272_cov_1.175879_g2883_i0 PRJNA682774 2912 272 1.175879 3.19839088 Bradysia coprophila 38358 Arthropoda Arthropoda 71.2 1.18e-12   NR XP_037044208.1 38358 g2883 i0 79.4 0.375 34 7 37.5 0 2 103 188 221 XP_037044208.1 hypoxanthine phosphoribosyltransferase-like [Bradysia coprophila] diamond 102 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
31093193 31093193 PRJNA682774_P_NODE_3795_length_251_cov_0.876404_g3766_i0 PRJNA682774 3795 251 0.876404 2.19977404 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 45.1 0.00613   NR XP_023330467.1 1294199 g3766 i0 56.1 1.47011952191235 41 17 49 1 244 122 414 453 XP_023330467.1 heterogeneous nuclear ribonucleoprotein K-like [Eurytemora carolleeae] diamond 369 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
31167702 31167702 PRJNA682774_P_NODE_5235_length_243_cov_0.917647_g5206_i0 PRJNA682774 5235 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 47.8 6.16e-4   NR XP_063986296.1 58733 g5206 i0 34.2 10.3086419753086 73 41 81.5 2 14 211 390 462 XP_063986296.1 DDB1- and CUL4-associated factor 11 isoform X1 [Diachasmimorpha longicaudata] diamond 2505 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
31294425 31294425 PRJNA682774_P_NODE_1415_length_367_cov_1.380952_g1386_i0 PRJNA682774 1415 367 1.380952 5.06809384 Opisthokonta 33154 Arthropoda Arthropoda 83.6 3.9e-17   NR ACJ61701.1 6661 g1386 i0 47.4 6.47411444141689 97 50 78.5 1 324 37 3 99 ACJ61701.1 ribosomal protein S7 [Artemia franciscana] diamond 2376 84 0.995238095238095 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31377858 31377858 PRJNA682774_P_NODE_5196_length_243_cov_0.917647_g5167_i0 PRJNA682774 5196 243 0.917647 2.22988221 Notodromas monacha 399045 Arthropoda Arthropoda 117 2.07e-28   NR CAD7281926.1 399045 g5167 i0 64.2 4 81 29 100 0 243 1 640 720 CAD7281926.1 unnamed protein product [Notodromas monacha] diamond 972 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
32010399 32010399 PRJNA682774_P_NODE_2998_length_268_cov_1.600000_g2969_i0 PRJNA682774 2998 268 1.6 4.288 Leptopilina heterotoma 63436 Arthropoda Arthropoda 44.3 0.0151   NR XP_043473686.1 63436 g2969 i0 36.8 2.59701492537313 76 47 85.1 1 4 231 1109 1183 XP_043473686.1 uncharacterized protein LOC122505882 [Leptopilina heterotoma] diamond 696 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Leptopilina Leptopilina heterotoma
32390071 32390071 PRJNA682774_P_NODE_1299_length_382_cov_1.262136_g1270_i0 PRJNA682774 1299 382 1.262136 4.82135952 Myzus persicae 13164 Arthropoda Arthropoda 46.2 0.00415   NR XP_022177475.1 13164 g1270 i0 28.4 0.746073298429319 95 67 74.6 1 377 93 48 141 XP_022177475.1 uncharacterized protein LOC111038618 [Myzus persicae] diamond 285 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
32401835 32401835 PRJNA682774_P_NODE_2399_length_294_cov_1.298643_g2370_i0 PRJNA682774 2399 294 1.298643 3.81801042 root 1 Root_unresolved Root_unresolved 94.4 4.74e-20   NR XP_023334287.1 1294199 g2370 i0 44.3 8.03061224489796 97 53 98 1 1 288 357 453 XP_023334287.1 delta(24)-sterol reductase isoform X2 [Eurytemora carolleeae] diamond 2361 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
32611339 32611339 PRJNA682774_P_NODE_2220_length_304_cov_1.350649_g2191_i0 PRJNA682774 2220 304 1.350649 4.10597296 Phthorimaea operculella 192464 Arthropoda Arthropoda 75.5 2.18e-14   NR KAI5638442.1 192464 g2191 i0 40 1.08552631578947 110 43 85.9 2 44 304 11 120 KAI5638442.1 EF-1 guanine nucleotide exchange domain-containing protein [Phthorimaea operculella] diamond 330 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Phthorimaea Phthorimaea operculella

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