RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 34 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA436017 · 34 ✖

analysis 1

  • diamond · 34 ✖
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
1705572 1705572 PRJNA436017_P_NODE_18622_length_190_cov_1.019608_g18324_i0 PRJNA436017 18622 190 1.019608 1.9372552 Drosophila immigrans 7250 Arthropoda Arthropoda 90.5 8.68e-20   NR KAH8307749.1 7250 g18324 i0 70.4 0.852631578947368 54 16 85.3 0 175 14 130 183 KAH8307749.1 hypothetical protein KR044_012241 [Drosophila immigrans] diamond 162 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila immigrans
2364497 2364497 PRJNA436017_P_NODE_23662_length_168_cov_1.137405_g23364_i0 PRJNA436017 23662 168 1.137405 1.9108404 Nitidulidae 116151 Arthropoda Arthropoda 80.9 4.8e-16   NR XP_049817035.1 116153 g23364 i0 68.5 1.92857142857143 54 17 96.4 0 163 2 332 385 XP_049817035.1 sodium/potassium-transporting ATPase subunit alpha-like [Aethina tumida] diamond 324 81.3 0.995079950799508 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
11292265 11292265 PRJNA436017_P_NODE_3049_length_536_cov_2.883768_g2773_i0 PRJNA436017 3049 536 2.883768 15.45699648 Opisthokonta 33154 Arthropoda Arthropoda 153 3.22e-44   NR ODM95864.1 48709 g2773 i0 56.6 6.3134328358209 143 60 79.5 2 507 82 7 148 ODM95864.1 40S ribosomal protein S16 [Orchesella cincta] diamond 3384 154 0.993506493506494 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
20832611 20832611 PRJNA436017_P_NODE_4097_length_457_cov_2.807143_g3806_i0 PRJNA436017 4097 457 2.807143 12.82864351 Metazoa 33208 Arthropoda Arthropoda 159 3.52e-45   NR XP_065559219.1 6661 g3806 i0 58.3 6.90590809628009 139 56 89.9 1 20 430 1 139 XP_065559219.1 large ribosomal subunit protein uL18-like [Artemia franciscana] diamond 3156 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
26871137 26871137 PRJNA436017_P_NODE_8941_length_292_cov_1.815686_g8643_i0 PRJNA436017 8941 292 1.815686 5.30180312 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 126 4.46e-35   NR KAH8020767.1 6941 g8643 i0 64.3 19.9006849315068 84 30 86.3 0 253 2 1 84 KAH8020767.1 hypothetical protein HPB51_003424 [Rhipicephalus microplus] diamond 5811 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
27297109 27297109 PRJNA436017_P_NODE_7903_length_315_cov_1.492806_g7606_i0 PRJNA436017 7903 315 1.492806 4.7023389 Diaphorina citri 121845 Arthropoda Arthropoda 57.8 3.31e-7   NR KAI5693023.1 121845 g7606 i0 36.9 0.8 84 51 80 2 55 306 83 164 KAI5693023.1 hypothetical protein M8J75_006194 [Diaphorina citri] diamond 252 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27629525 27629525 PRJNA436017_P_NODE_23284_length_169_cov_1.363636_g22986_i0 PRJNA436017 23284 169 1.363636 2.30454484 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 60.1 1.05e-8   NR XP_003739709.1 34638 g22986 i0 55.8 5.53846153846154 52 23 92.3 0 156 1 337 388 XP_003739709.1 ATP-binding cassette sub-family F member 1 [Galendromus occidentalis] diamond 936 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
28244239 28244239 PRJNA436017_P_NODE_25066_length_163_cov_1.222222_g24768_i0 PRJNA436017 25066 163 1.222222 1.99222186 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 49.3 5.97e-5   NR XP_050544960.1 58002 g24768 i0 46.2 3.01840490797546 52 27 95.7 1 158 3 397 447 XP_050544960.1 ankyrin repeat and IBR domain-containing protein 1-like isoform X2 [Daktulosphaira vitifoliae] diamond 492 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
28307618 28307618 PRJNA436017_P_NODE_28986_length_152_cov_0.982609_g28688_i0 PRJNA436017 28986 152 0.982609 1.49356568 Agrilus planipennis 224129 Arthropoda Arthropoda 68.6 3.71e-12   NR XP_018324267.1 224129 g28688 i0 52 0.986842105263158 50 24 98.7 0 152 3 130 179 XP_018324267.1 proteasome subunit alpha type-3 [Agrilus planipennis] diamond 150 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
28718117 28718117 PRJNA436017_P_NODE_9327_length_284_cov_12.720648_g9029_i0 PRJNA436017 9327 284 12.720648 36.12664032 Artemia franciscana 6661 Arthropoda Arthropoda 172 1.29e-53   NR KAK2709965.1 6661 g9029 i0 86 2.94718309859155 93 13 98.2 0 3 281 3 95 KAK2709965.1 hypothetical protein QYM36_013593 [Artemia franciscana] diamond 837 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28797383 28797383 PRJNA436017_P_NODE_26187_length_159_cov_1.598361_g25889_i0 PRJNA436017 26187 159 1.598361 2.54139399 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.8 1.67e-4   NR XP_037270228.1 6941 g25889 i0 50 4.37735849056604 50 22 94.3 2 3 152 44 90 XP_037270228.1 60S ribosomal protein L10a-like [Rhipicephalus microplus] diamond 696 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
28875866 28875866 PRJNA436017_P_NODE_18528_length_190_cov_1.888889_g18230_i0 PRJNA436017 18528 190 1.888889 3.5888891 Sarcoptes scabiei 52283 Arthropoda Arthropoda 43.9 0.0074   NR KPM07906.1 52283 g18230 i0 35.1 1.8 57 37 90 0 177 7 250 306 KPM07906.1 tetratricopeptide repeat protein 38-like protein [Sarcoptes scabiei] diamond 342 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
29002650 29002650 PRJNA436017_P_NODE_6388_length_354_cov_1.722397_g6092_i0 PRJNA436017 6388 354 1.722397 6.09728538 Notodromas monacha 399045 Arthropoda Arthropoda 46.2 0.0024   NR CAD7285788.1 399045 g6092 i0 33.3 0.661016949152542 78 44 64.4 2 288 61 65 136 CAD7285788.1 unnamed protein product, partial [Notodromas monacha] diamond 234 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
29018901 29018901 PRJNA436017_P_NODE_12408_length_240_cov_1.536946_g12110_i0 PRJNA436017 12408 240 1.536946 3.6886704 Arthropoda 6656 Arthropoda Arthropoda 89 1.83e-18   NR XP_063896406.1 29058 g12110 i0 60 15.725 60 24 75 0 238 59 492 551 XP_063896406.1 asparagine--tRNA ligase, cytoplasmic [Helicoverpa armigera] diamond 3774 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
29443995 29443995 PRJNA436017_P_NODE_6230_length_359_cov_1.816770_g5934_i0 PRJNA436017 6230 359 1.81677 6.5222043 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 72.4 1.95e-13   NR XP_023323401.1 1294199 g5934 i0 43.8 0.668523676880223 80 43 66.9 1 354 115 53 130 XP_023323401.1 60S ribosomal protein L31 [Eurytemora carolleeae] diamond 240 72.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
29538873 29538873 PRJNA436017_P_NODE_5750_length_375_cov_1.384615_g5454_i0 PRJNA436017 5750 375 1.384615 5.19230625 Dalotia coriaria 877792 Arthropoda Arthropoda 84.3 3.63e-17   NR XP_065157700.1 877792 g5454 i0 42.5 2.432 106 48 84.8 3 333 16 2 94 XP_065157700.1 glutathione S-transferase 1-like isoform X2 [Dalotia coriaria] diamond 912 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
29555182 29555182 PRJNA436017_P_NODE_4750_length_421_cov_1.197917_g4454_i0 PRJNA436017 4750 421 1.197917 5.04323057 Arthropoda 6656 Arthropoda Arthropoda 66.2 1.51e-9   NR XP_013792674.1 6850 g4454 i0 37.9 1.56769596199525 103 55 69.8 3 297 4 18 116 XP_013792674.1 sequestosome-1-like [Limulus polyphemus] diamond 660 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30218573 30218573 PRJNA436017_P_NODE_5692_length_377_cov_3.450000_g5396_i0 PRJNA436017 5692 377 3.45 13.0065 Arthropoda 6656 Arthropoda Arthropoda 73.2 3.39e-12   NR XP_065205024.1 170843 g5396 i0 38.2 3.75596816976127 110 64 87.5 3 43 372 222 327 XP_065205024.1 uncharacterized protein LOC135834946 [Planococcus citri] diamond 1416 73.6 0.994565217391304 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Planococcus Planococcus citri
30818990 30818990 PRJNA436017_P_NODE_25014_length_163_cov_1.238095_g24716_i0 PRJNA436017 25014 163 1.238095 2.01809485 Metazoa 33208 Arthropoda Arthropoda 85.9 7.63e-18   NR CAD7244881.1 69355 g24716 i0 71.7 4.87730061349693 53 15 97.5 0 161 3 29 81 CAD7244881.1 unnamed protein product, partial [Darwinula stevensoni] diamond 795 86.3 0.995365005793743 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
30928993 30928993 PRJNA436017_P_NODE_4894_length_413_cov_3.449468_g4598_i0 PRJNA436017 4894 413 3.449468 14.24630284 Choristoneura fumiferana 7141 Arthropoda Arthropoda 142 1.68e-38   NR KAI8439226.1 7141 g4598 i0 58.2 1.75060532687651 122 46 88.6 2 48 413 3 119 KAI8439226.1 hypothetical protein MSG28_013067 [Choristoneura fumiferana] diamond 723 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Choristoneura Choristoneura fumiferana
31008553 31008553 PRJNA436017_P_NODE_27254_length_156_cov_1.647059_g26956_i0 PRJNA436017 27254 156 1.647059 2.56941204 Opisthokonta 33154 Arthropoda Arthropoda 50.4 2.12e-5   NR XP_045524175.1 7116 g26956 i0 46.9 1.88461538461538 49 26 94.2 0 149 3 84 132 XP_045524175.1 protein disulfide-isomerase A3 [Pieris brassicae] diamond 294 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Pieris Pieris brassicae
31244848 31244848 PRJNA436017_P_NODE_23915_length_167_cov_1.169231_g23617_i0 PRJNA436017 23915 167 1.169231 1.95261577 Diploptera punctata 6984 Arthropoda Arthropoda 60.5 6.35e-9   NR KAJ9592845.1 6984 g23617 i0 49.1 5.7125748502994 53 27 95.2 0 9 167 251 303 KAJ9592845.1 hypothetical protein L9F63_015488 [Diploptera punctata] diamond 954 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
31388034 31388034 PRJNA436017_P_NODE_17996_length_193_cov_1.724359_g17698_i0 PRJNA436017 17996 193 1.724359 3.32801287 Ixodidae 6939 Arthropoda Arthropoda 86.7 2.03e-18   NR XP_040077675.1 6945 g17698 i0 51.6 3.82383419689119 64 31 99.5 0 192 1 65 128 XP_040077675.1 cytochrome c1, heme protein, mitochondrial [Ixodes scapularis] diamond 738 87.4 0.991990846681922 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
31482999 31482999 PRJNA436017_P_NODE_18976_length_188_cov_1.284768_g18678_i0 PRJNA436017 18976 188 1.284768 2.41536384 Hymenoptera 7399 Arthropoda Arthropoda 42.7 0.0164   NR APF47538.1 1911503 g18678 i0 65.5 1.42021276595745 29 10 46.3 0 14 100 127 155 APF47538.1 cytochrome c oxidase subunit III, partial [Fornicia albalata] diamond 267 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Fornicia Fornicia albalata
31593027 31593027 PRJNA436017_P_NODE_11916_length_246_cov_2.349282_g11618_i0 PRJNA436017 11916 246 2.349282 5.77923372 Diabrotica virgifera virgifera 50390 Arthropoda Arthropoda 79.3 4.91e-17   NR XP_028128765.1 50390 g11618 i0 68.8 2.20731707317073 48 15 58.5 0 245 102 59 106 XP_028128765.1 cytochrome c-like [Diabrotica virgifera virgifera] diamond 543 79.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
31750852 31750852 PRJNA436017_P_NODE_22617_length_172_cov_1.125926_g22319_i0 PRJNA436017 22617 172 1.125926 1.93659272 Procambarus clarkii 6728 Arthropoda Arthropoda 77 1.09e-14   NR XP_045584983.1 6728 g22319 i0 56.1 2.98255813953488 57 25 99.4 0 1 171 192 248 XP_045584983.1 protein disulfide-isomerase A6 homolog [Procambarus clarkii] diamond 513 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
32225673 32225673 PRJNA436017_P_NODE_10338_length_268_cov_1.350649_g10040_i0 PRJNA436017 10338 268 1.350649 3.61973932 Folsomia candida 158441 Arthropoda Arthropoda 70.1 1.19e-11   NR XP_021950666.1 158441 g10040 i0 44.9 8.66417910447761 69 38 77.2 0 56 262 13 81 XP_021950666.1 copine-2 [Folsomia candida] diamond 2322 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
32289201 32289201 PRJNA436017_P_NODE_18719_length_189_cov_1.664474_g18421_i0 PRJNA436017 18719 189 1.664474 3.14585586 Cylas formicarius 197179 Arthropoda Arthropoda 88.2 1.43e-18   NR XP_060533575.1 197179 g18421 i0 71.9 10.1587301587302 64 17 100 1 189 1 216 279 XP_060533575.1 phosphoglycerate kinase [Cylas formicarius] diamond 1920 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Brentidae Cylas Cylas formicarius
32320833 32320833 PRJNA436017_P_NODE_17159_length_198_cov_2.211180_g16861_i0 PRJNA436017 17159 198 2.21118 4.3781364 Homarus americanus 6706 Arthropoda Arthropoda 42.7 0.0207   NR KAG7169655.1 6706 g16861 i0 52.5 0.606060606060606 40 19 60.6 0 121 2 165 204 KAG7169655.1 hypothetical protein Hamer_G013271 [Homarus americanus] diamond 120 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
32383750 32383750 PRJNA436017_P_NODE_3339_length_512_cov_2.244211_g3060_i0 PRJNA436017 3339 512 2.244211 11.49036032 Anoplophora glabripennis 217634 Arthropoda Arthropoda 75.1 1.53e-13   NR XP_018573730.1 217634 g3060 i0 46.9 1.125 96 45 56.3 2 512 225 66 155 XP_018573730.1 60S ribosomal protein L21 [Anoplophora glabripennis] diamond 576 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
32527078 32527078 PRJNA436017_P_NODE_12639_length_237_cov_1.555000_g12341_i0 PRJNA436017 12639 237 1.555 3.68535 Tenebrionidae 7065 Arthropoda Arthropoda 101 6.6e-23   NR KAH0812858.1 7067 g12341 i0 60.8 2 79 31 100 0 237 1 732 810 KAH0812858.1 hypothetical protein GEV33_009931 [Tenebrio molitor] diamond 474 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
32715898 32715898 PRJNA436017_P_NODE_2840_length_556_cov_1.932563_g2572_i0 PRJNA436017 2840 556 1.932563 10.74505028 Calanoida 6833 Arthropoda Arthropoda 211 4.42e-66   NR ALS05287.1 213370 g2572 i0 57.6 5.96762589928058 184 76 99.3 1 553 2 29 210 ALS05287.1 60S ribosomal protein L10a [Pseudodiaptomus poplesia] diamond 3318 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Pseudodiaptomidae Pseudodiaptomus Pseudodiaptomus poplesia
32762458 32762458 PRJNA436017_P_NODE_21600_length_176_cov_1.122302_g21302_i0 PRJNA436017 21600 176 1.122302 1.97525152 Orchesella dallaii 48710 Arthropoda Arthropoda 63.5 1.53e-10   NR CAL8083058.1 48710 g21302 i0 78.8 2.82954545454545 33 7 56.3 0 4 102 150 182 CAL8083058.1 unnamed protein product [Orchesella dallaii] diamond 498 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
32825489 32825489 PRJNA436017_P_NODE_10640_length_263_cov_6.238938_g10342_i0 PRJNA436017 10640 263 6.238938 16.40840694 Rhipicephalus appendiculatus 34631 Arthropoda Arthropoda 42.7 0.0228   NR KAL1424694.1 34631 g10342 i0 43.1 0.741444866920152 65 25 67.3 2 5 181 75 133 KAL1424694.1 hypothetical protein MTO96_019841 [Rhipicephalus appendiculatus] diamond 195 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus

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