RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1103784 · 29 ✖

analysis 1

  • diamond · 29 ✖
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
6590166 6590166 PRJNA1103784_P_NODE_1186_length_464_cov_2.882353_g1131_i0 PRJNA1103784 1186 464 2.882353 13.37411792 Metazoa 33208 Arthropoda Arthropoda 159 4.979999999999999e-47   NR KAK4887832.1 1421715 g1131 i0 58.8 5.67025862068965 148 60 95.7 1 446 3 1 147 KAK4887832.1 hypothetical protein RN001_004103 [Aquatica leii] diamond 2631 160 0.99375 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Aquatica Aquatica leii
7864800 7864800 PRJNA1103784_P_NODE_1227_length_456_cov_2.953003_g1172_i0 PRJNA1103784 1227 456 2.953003 13.46569368 Hylaeus volcanicus 313075 Arthropoda Arthropoda 87.4 9.26e-17   NR XP_053992947.1 313075 g1172 i0 47.2 0.585526315789474 89 45 57.2 1 21 281 531 619 XP_053992947.1 uncharacterized protein LOC128884012 [Hylaeus volcanicus] diamond 267 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Colletidae Hylaeus Hylaeus volcanicus
10415518 10415518 PRJNA1103784_P_NODE_3369_length_301_cov_0.960526_g3314_i0 PRJNA1103784 3369 301 0.960526 2.89118326 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 157 5.769999999999999e-43   NR KAF7495663.1 52283 g3314 i0 75 17.8803986710963 100 25 99.7 0 2 301 385 484 KAF7495663.1 T-complex protein 1 subunit epsilon [Sarcoptes scabiei] diamond 5382 157 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
11690804 11690804 PRJNA1103784_P_NODE_3130_length_310_cov_1.282700_g3075_i0 PRJNA1103784 3130 310 1.2827 3.97637 Phyllotreta striolata 444603 Arthropoda Arthropoda 132 3.3499999999999996e-35   NR CAH1161566.1 444603 g3075 i0 60.8 6.03870967741936 102 40 98.7 0 1 306 145 246 CAH1161566.1 unnamed protein product [Phyllotreta striolata] diamond 1872 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Phyllotreta Phyllotreta striolata
12965997 12965997 PRJNA1103784_P_NODE_471_length_685_cov_1.728758_g417_i0 PRJNA1103784 471 685 1.728758 11.8419923 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 345 3.369999999999999e-115   NR OTF77792.1 6958 g417 i0 72.6 22.0116788321168 219 57 95 2 683 33 189 406 OTF77792.1 elongation factor 2-like protein [Euroglyphus maynei] diamond 15078 348 0.991379310344828 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Euroglyphus Euroglyphus maynei
17597860 17597860 PRJNA1103784_P_NODE_2154_length_362_cov_2.519031_g2099_i0 PRJNA1103784 2154 362 2.519031 9.11889222 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 162 2.82e-46   NR XP_037278694.1 6941 g2099 i0 68.3 7.81491712707182 120 38 99.4 0 360 1 237 356 XP_037278694.1 glyceraldehyde-3-phosphate dehydrogenase-like isoform X1 [Rhipicephalus microplus] diamond 2829 163 0.993865030674847 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
18063872 18063872 PRJNA1103784_P_NODE_7055_length_244_cov_1.350877_g7000_i0 PRJNA1103784 7055 244 1.350877 3.29613988 Insecta 50557 Arthropoda Arthropoda 134 1.18e-34   NR XP_030753766.1 7048 g7000 i0 86.1 45.6885245901639 79 11 97.1 0 5 241 390 468 XP_030753766.1 heat shock protein 68-like [Sitophilus oryzae] diamond 11148 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
26837634 26837634 PRJNA1103784_P_NODE_7621_length_242_cov_0.911243_g7566_i0 PRJNA1103784 7621 242 0.911243 2.20520806 Arthropoda 6656 Arthropoda Arthropoda 48.9 6.64e-5   NR KAK8723605.1 27406 g7566 i0 45.2 1.58677685950413 42 23 52.1 0 242 117 45 86 KAK8723605.1 hypothetical protein OTU49_011460, partial [Cherax quadricarinatus] diamond 384 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
27257331 27257331 PRJNA1103784_P_NODE_3763_length_288_cov_1.293023_g3708_i0 PRJNA1103784 3763 288 1.293023 3.72390624 Ornithodoros turicata 34597 Arthropoda Arthropoda 56.6 8.48e-7   NR XP_064488612.1 34597 g3708 i0 44.2 0.802083333333333 77 41 78.1 1 260 36 587 663 XP_064488612.1 arfGAP with SH3 domain, ANK repeat and PH domain-containing protein-like isoform X1 [Ornithodoros turicata] diamond 231 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
28069679 28069679 PRJNA1103784_P_NODE_2625_length_333_cov_1.950000_g2570_i0 PRJNA1103784 2625 333 1.95 6.4935 Insecta 50557 Arthropoda Arthropoda 144 1.35e-38   NR XP_049287124.1 62324 g2570 i0 62.3 9.64864864864865 106 40 95.5 0 326 9 320 425 XP_049287124.1 elongation factor 1-gamma-like [Anopheles funestus] diamond 3213 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles funestus
28701315 28701315 PRJNA1103784_P_NODE_3647_length_290_cov_1.764977_g3592_i0 PRJNA1103784 3647 290 1.764977 5.1184333 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.1 1.26e-7   NR MCL4117871.1 82763 g3592 i0 46.4 1.99655172413793 69 37 71.4 0 1 207 2 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 579 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28867720 28867720 PRJNA1103784_P_NODE_7308_length_243_cov_0.905882_g7253_i0 PRJNA1103784 7308 243 0.905882 2.20129326 Uranotaenia lowii 190385 Arthropoda Arthropoda 84 6.31e-17   NR XP_055586220.1 190385 g7253 i0 51.5 8.75308641975309 68 32 84 1 4 207 283 349 XP_055586220.1 cathepsin B-like [Uranotaenia lowii] diamond 2127 84 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
28953999 28953999 PRJNA1103784_P_NODE_2848_length_321_cov_1.241935_g2793_i0 PRJNA1103784 2848 321 1.241935 3.98661135 root 1 Root_unresolved Root_unresolved 109 1.2e-27   NR EAT40142.1 7159 g2793 i0 57.5 20.214953271028 106 43 98.1 2 317 3 45 149 EAT40142.1 AAEL008103-PA [Aedes aegypti] diamond 6489 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
28962718 28962718 PRJNA1103784_P_NODE_7768_length_241_cov_0.916667_g7713_i0 PRJNA1103784 7768 241 0.916667 2.20916747 Leptosia nina 320188 Arthropoda Arthropoda 61.2 6.79e-9   NR CAK1553139.1 320188 g7713 i0 47.6 3.79668049792531 63 31 77.2 2 187 2 26 87 CAK1553139.1 unnamed protein product [Leptosia nina] diamond 915 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Leptosia Leptosia nina
29088837 29088837 PRJNA1103784_P_NODE_3348_length_301_cov_1.929825_g3293_i0 PRJNA1103784 3348 301 1.929825 5.80877325 Argiope bruennichi 94029 Arthropoda Arthropoda 109 4.24e-28   NR XP_055944831.1 94029 g3293 i0 61.9 1.96345514950166 97 37 96.7 0 300 10 18 114 XP_055944831.1 60S ribosomal protein L24-like [Argiope bruennichi] diamond 591 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29183672 29183672 PRJNA1103784_P_NODE_669_length_591_cov_2.272201_g615_i0 PRJNA1103784 669 591 2.272201 13.42870791 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 154 1.9299999999999994e-42   NR KAF0304196.1 1232801 g615 i0 52.7 2.3502538071066 167 69 84.3 3 591 94 132 289 KAF0304196.1 60S acidic ribosomal protein P0 [Amphibalanus amphitrite] diamond 1389 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
29846588 29846588 PRJNA1103784_P_NODE_6731_length_246_cov_0.890173_g6676_i0 PRJNA1103784 6731 246 0.890173 2.18982558 Tetranychus urticae 32264 Arthropoda Arthropoda 44.3 0.0104   NR XP_015791655.1 32264 g6676 i0 42.4 0.719512195121951 59 34 72 0 11 187 291 349 XP_015791655.1 26S proteasome non-ATPase regulatory subunit 7 [Tetranychus urticae] diamond 177 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30216841 30216841 PRJNA1103784_P_NODE_3152_length_309_cov_0.978814_g3097_i0 PRJNA1103784 3152 309 0.978814 3.02453526 Metazoa 33208 Arthropoda Arthropoda 46.6 0.00228   NR XP_013777983.1 6850 g3097 i0 31 1.8252427184466 87 45 84.5 3 45 305 119 190 XP_013777983.1 ER membrane protein complex subunit 8-like [Limulus polyphemus] diamond 564 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30280578 30280578 PRJNA1103784_P_NODE_5352_length_256_cov_1.262295_g5297_i0 PRJNA1103784 5352 256 1.262295 3.2314752 root 1 Root_unresolved Root_unresolved 87.4 5.19e-18   NR XP_017486670.1 28612 g5297 i0 46.4 4.91015625 84 45 98.4 0 3 254 128 211 XP_017486670.1 PREDICTED: carboxypeptidase B-like [Rhagoletis zephyria] diamond 1257 87.8 0.995444191343964 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
31038739 31038739 PRJNA1103784_P_NODE_1775_length_390_cov_4.488959_g1720_i0 PRJNA1103784 1775 390 4.488959 17.5069401 Metazoa 33208 Arthropoda Arthropoda 83.2 1.1e-16   NR KAH9413015.1 6956 g1720 i0 63.9 6.14615384615385 72 25 55.4 1 381 166 1 71 KAH9413015.1 60S ribosomal protein L38, partial [Dermatophagoides pteronyssinus] diamond 2397 84 0.990476190476191 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
31141567 31141567 PRJNA1103784_P_NODE_715_length_573_cov_1.508000_g661_i0 PRJNA1103784 715 573 1.508 8.64084 Galendromus occidentalis 34638 Arthropoda Arthropoda 127 7.860000000000001e-33   NR XP_003748072.1 34638 g661 i0 35.8 0.921465968586387 176 103 88 4 534 31 62 235 XP_003748072.1 ribonuclease Oy [Galendromus occidentalis] diamond 528 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
31204674 31204674 PRJNA1103784_P_NODE_6235_length_248_cov_0.880000_g6180_i0 PRJNA1103784 6235 248 0.88 2.1824 Condylostylus longicornis 2530218 Arthropoda Arthropoda 45.8 7.57e-4   NR XP_055388520.1 2530218 g6180 i0 37.5 0.67741935483871 56 34 67.7 1 168 1 47 101 XP_055388520.1 dynein light chain 1, cytoplasmic-like [Condylostylus longicornis] diamond 168 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
31236637 31236637 PRJNA1103784_P_NODE_2075_length_366_cov_1.805461_g2020_i0 PRJNA1103784 2075 366 1.805461 6.60798726 Culicoides brevitarsis 469753 Arthropoda Arthropoda 93.6 7.63e-21   NR XP_063703570.1 469753 g2020 i0 49.6 3.76229508196721 117 55 95.9 2 361 11 90 202 XP_063703570.1 large ribosomal subunit protein eL13 [Culicoides brevitarsis] diamond 1377 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
31490032 31490032 PRJNA1103784_P_NODE_4856_length_265_cov_2.421875_g4801_i0 PRJNA1103784 4856 265 2.421875 6.41796875 Cherax quadricarinatus 27406 Arthropoda Arthropoda 41.2 0.0499   NR KAK8735664.1 27406 g4801 i0 47.4 0.860377358490566 76 29 73.6 3 7 201 14 89 KAK8735664.1 hypothetical protein OTU49_005251 [Cherax quadricarinatus] diamond 228 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
31490034 31490034 PRJNA1103784_P_NODE_7896_length_240_cov_2.377246_g7841_i0 PRJNA1103784 7896 240 2.377246 5.7053904 Galendromus occidentalis 34638 Arthropoda Arthropoda 70.9 4.39e-12   NR XP_003738426.1 34638 g7841 i0 42.7 1.875 75 43 93.8 0 232 8 666 740 XP_003738426.1 protein transport protein Sec24C [Galendromus occidentalis] diamond 450 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
31576065 31576065 PRJNA1103784_P_NODE_4996_length_263_cov_1.342105_g4941_i0 PRJNA1103784 4996 263 1.342105 3.52973615 Metazoa 33208 Arthropoda Arthropoda 51.6 3.56e-5   NR XP_013772254.1 6850 g4941 i0 32.5 6.07984790874525 83 54 94.7 1 11 259 36 116 XP_013772254.1 RNA-binding protein 28-like, partial [Limulus polyphemus] diamond 1599 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
31892261 31892261 PRJNA1103784_P_NODE_5777_length_250_cov_1.796610_g5722_i0 PRJNA1103784 5777 250 1.79661 4.491525 Insecta 50557 Arthropoda Arthropoda 98.6 9.31e-22   NR EGI66903.1 103372 g5722 i0 51.8 5.064 85 38 98.4 1 250 5 671 755 EGI66903.1 Putative cysteine proteinase [Acromyrmex echinatior] diamond 1266 99.4 0.991951710261569 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Acromyrmex Acromyrmex echinatior
31900984 31900984 PRJNA1103784_P_NODE_3377_length_300_cov_2.035242_g3322_i0 PRJNA1103784 3377 300 2.035242 6.105726 Folsomia candida 158441 Arthropoda Arthropoda 55.8 1.7e-6   NR XP_035705737.1 158441 g3322 i0 31 0.87 87 57 84 1 38 289 181 267 XP_035705737.1 BTB/POZ domain-containing protein 2 isoform X3 [Folsomia candida] diamond 261 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
32682535 32682535 PRJNA1103784_P_NODE_6560_length_247_cov_0.885057_g6505_i0 PRJNA1103784 6560 247 0.885057 2.18609079 Insecta 50557 Arthropoda Arthropoda 73.6 4.23e-13   NR KAG8225587.1 123851 g6505 i0 52.5 3.02429149797571 59 28 71.7 0 70 246 22 80 KAG8225587.1 hypothetical protein J437_LFUL002106 [Ladona fulva] diamond 747 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva

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