RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB41113 · 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
16292568 16292568 PRJEB41113_S_NODE_11373_length_156_cov_1.865546_g11364_i0 PRJEB41113 11373 156 1.865546 2.91025176 Lepidoptera 7088 Arthropoda Arthropoda 87.8 1.47e-18   NR CAG5041301.1 110799 g11364 i0 74.5 5.86538461538461 51 13 98.1 0 3 155 61 111 CAG5041301.1 unnamed protein product [Parnassius apollo] diamond 915 88.6 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo
16635923 16635923 PRJEB41113_S_NODE_1554_length_239_cov_3.712871_g1545_i0 PRJEB41113 1554 239 3.712871 8.87376169 Hemiodoecus leai 1254501 Arthropoda Arthropoda 72.8 2.15e-13   NR YP_009093732.1 1254501 g1545 i0 62.7 12.8786610878661 51 16 60.3 1 6 149 161 211 YP_009093732.1 cytochrome c oxidase subunit II [Hemiodoecus leai] diamond 3078 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Peloridiidae Hemiodoecus Hemiodoecus leai
26811969 26811969 PRJEB41113_S_NODE_12441_length_154_cov_1.000000_g12432_i0 PRJEB41113 12441 154 1 1.54 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 99 1.76e-22   NR KAH9404274.1 59818 g12432 i0 97.9 0.935064935064935 48 1 93.5 0 144 1 266 313 KAH9404274.1 hypothetical protein TYRP_000093 [Tyrophagus putrescentiae] diamond 144 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
26875529 26875529 PRJEB41113_S_NODE_11381_length_156_cov_1.781513_g11372_i0 PRJEB41113 11381 156 1.781513 2.77916028 Rhagoletis zephyria 28612 Arthropoda Arthropoda 51.2 1.12e-5   NR XP_017493965.1 28612 g11372 i0 75.8 0.634615384615385 33 8 63.5 0 3 101 327 359 XP_017493965.1 PREDICTED: sorbitol dehydrogenase-like [Rhagoletis zephyria] diamond 99 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
27096611 27096611 PRJEB41113_S_NODE_7382_length_172_cov_2.503704_g7373_i0 PRJEB41113 7382 172 2.503704 4.30637088 Larinioides sclopetarius 280406 Arthropoda Arthropoda 50.8 1.51e-6   NR CAL1301126.1 280406 g7373 i0 58.7 0.802325581395349 46 18 78.5 1 2 136 19 64 CAL1301126.1 unnamed protein product [Larinioides sclopetarius] diamond 138 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Larinioides Larinioides sclopetarius
27127870 27127870 PRJEB41113_S_NODE_10722_length_158_cov_1.570248_g10713_i0 PRJEB41113 10722 158 1.570248 2.48099184 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 65.5 1.11e-10   NR KAH9410127.1 59818 g10713 i0 84.6 0.740506329113924 39 5 74.1 1 119 3 106 143 KAH9410127.1 Disks large 5 [Tyrophagus putrescentiae] diamond 117 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27602344 27602344 PRJEB41113_S_NODE_8304_length_167_cov_1.607692_g8295_i0 PRJEB41113 8304 167 1.607692 2.68484564 Gryllus longicercus 2509291 Arthropoda Arthropoda 77.4 4.16e-15   NR KAK7788990.1 2509291 g8295 i0 65.5 0.988023952095808 55 14 98.8 1 1 165 30 79 KAK7788990.1 hypothetical protein R5R35_013596 [Gryllus longicercus] diamond 165 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus longicercus
28075653 28075653 PRJEB41113_S_NODE_8625_length_165_cov_3.421875_g8616_i0 PRJEB41113 8625 165 3.421875 5.64609375 Prorops nasuta 863751 Arthropoda Arthropoda 72.8 6.53e-14   NR XP_066602694.1 863751 g8616 i0 68 0.909090909090909 50 16 90.9 0 150 1 157 206 XP_066602694.1 uncharacterized protein [Prorops nasuta] diamond 150 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
28139186 28139186 PRJEB41113_S_NODE_10585_length_158_cov_3.438017_g10576_i0 PRJEB41113 10585 158 3.438017 5.43206686 Blomia tropicalis 40697 Arthropoda Arthropoda 58.2 4.21e-8   NR KAI2798569.1 40697 g10576 i0 96.4 0.531645569620253 28 1 53.2 0 5 88 503 530 KAI2798569.1 sorting nexin-2 [Blomia tropicalis] diamond 84 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Echimyopodidae Blomia Blomia tropicalis
28637657 28637657 PRJEB41113_S_NODE_11007_length_157_cov_2.358333_g10998_i0 PRJEB41113 11007 157 2.358333 3.70258281 Cydia 82599 Arthropoda Arthropoda 53.5 1.81e-6   NR XP_063387611.1 1458189 g10998 i0 70.6 1.29936305732484 34 10 65 0 1 102 749 782 XP_063387611.1 uncharacterized protein LOC134673544 [Cydia fagiglandana] diamond 204 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia fagiglandana
28738864 28738864 PRJEB41113_S_NODE_3707_length_198_cov_2.987578_g3698_i0 PRJEB41113 3707 198 2.987578 5.91540444 Oedothorax gibbosus 931172 Arthropoda Arthropoda 58.2 1.83e-8   NR KAG8196935.1 931172 g3698 i0 69.8 1.95454545454545 43 11 62.1 1 124 2 35 77 KAG8196935.1 hypothetical protein JTE90_027638 [Oedothorax gibbosus] diamond 387 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
28889940 28889940 PRJEB41113_S_NODE_2068_length_225_cov_2.175532_g2059_i0 PRJEB41113 2068 225 2.175532 4.894947 Arthropoda 6656 Arthropoda Arthropoda 123 1.59e-34   NR XP_017463239.1 28612 g2059 i0 76.1 2.68 67 16 89.3 0 3 203 49 115 XP_017463239.1 PREDICTED: cathepsin B-like, partial [Rhagoletis zephyria] diamond 603 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
29054717 29054717 PRJEB41113_S_NODE_468_length_309_cov_3.720588_g459_i0 PRJEB41113 468 309 3.720588 11.49661692 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 140 3.28e-39   NR QIA92558.1 59818 g459 i0 85.1 1.8252427184466 94 14 91.3 0 308 27 130 223 QIA92558.1 ATP synthase F0 subunit 6 [Tyrophagus putrescentiae] diamond 564 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29307089 29307089 PRJEB41113_S_NODE_1989_length_227_cov_2.036842_g1980_i0 PRJEB41113 1989 227 2.036842 4.62363134 Rhagoletis zephyria 28612 Arthropoda Arthropoda 91.3 1.14e-19   NR XP_017492968.1 28612 g1980 i0 78.1 0.845814977973568 64 11 84.6 1 20 211 279 339 XP_017492968.1 PREDICTED: UDP-N-acetylglucosamine/UDP-glucose/GDP-mannose transporter-like [Rhagoletis zephyria] diamond 192 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30002019 30002019 PRJEB41113_S_NODE_10931_length_157_cov_3.908333_g10922_i0 PRJEB41113 10931 157 3.908333 6.1360828100000004 Rhagoletis zephyria 28612 Arthropoda Arthropoda 50.8 1.57e-5   NR XP_017492037.1 28612 g10922 i0 100 0.382165605095541 20 0 38.2 0 156 97 299 318 XP_017492037.1 PREDICTED: 1,5-anhydro-D-fructose reductase-like [Rhagoletis zephyria] diamond 60 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30121442 30121442 PRJEB41113_S_NODE_8772_length_164_cov_8.637795_g8763_i0 PRJEB41113 8772 164 8.637795 14.1659838 Lepidoptera 7088 Arthropoda Arthropoda 55.1 5.11e-7   NR XP_063894713.1 29058 g8763 i0 74.2 1.11585365853659 31 8 56.7 0 100 8 269 299 XP_063894713.1 uncharacterized protein LOC135117964 [Helicoverpa armigera] diamond 183 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
30349960 30349960 PRJEB41113_S_NODE_5072_length_187_cov_2.026667_g5063_i0 PRJEB41113 5072 187 2.026667 3.78986729 Galendromus occidentalis 34638 Arthropoda Arthropoda 70.1 3.88e-12   NR XP_018496867.1 34638 g5063 i0 62.3 0.978609625668449 61 23 97.9 0 3 185 525 585 XP_018496867.1 uncharacterized protein LOC108864903 [Galendromus occidentalis] diamond 183 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
30570308 30570308 PRJEB41113_S_NODE_5733_length_182_cov_12.062069_g5724_i0 PRJEB41113 5733 182 12.062069 21.95296558 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 46.6 7.27e-4   NR KAH9407719.1 59818 g5724 i0 87.5 0.395604395604396 24 3 39.6 0 179 108 956 979 KAH9407719.1 RING finger and SPRY domain-containing protein 1 [Tyrophagus putrescentiae] diamond 72 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30760224 30760224 PRJEB41113_S_NODE_14634_length_151_cov_2.096491_g14625_i0 PRJEB41113 14634 151 2.096491 3.16570141 Polyplax serrata 468196 Arthropoda Arthropoda 81.6 3.01e-18   NR KAK6632216.1 468196 g14625 i0 86.8 1.49006622516556 38 5 75.5 0 38 151 26 63 KAK6632216.1 hypothetical protein RUM44_007247 [Polyplax serrata] diamond 225 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
31044860 31044860 PRJEB41113_S_NODE_11095_length_157_cov_1.258333_g11086_i0 PRJEB41113 11095 157 1.258333 1.97558281 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 45.8 9.58e-4   NR KAH9405394.1 59818 g11086 i0 72 0.477707006369427 25 7 47.8 0 4 78 596 620 KAH9405394.1 Sphingomyelin phosphodiesterase [Tyrophagus putrescentiae] diamond 75 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31328988 31328988 PRJEB41113_S_NODE_1896_length_229_cov_2.786458_g1887_i0 PRJEB41113 1896 229 2.786458 6.38098882 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 68.9 1.75e-11   NR QIA92565.1 59818 g1887 i0 55.2 1.75545851528384 67 30 87.8 0 3 203 486 552 QIA92565.1 NADH dehydrogenase subunit 5 [Tyrophagus putrescentiae] diamond 402 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31582178 31582178 PRJEB41113_S_NODE_11296_length_156_cov_3.193277_g11287_i0 PRJEB41113 11296 156 3.193277 4.98151212 Ignelater luminosus 2038154 Arthropoda Arthropoda 97.4 6.38e-22   NR KAF2898850.1 2038154 g11287 i0 86.3 4.90384615384615 51 7 98.1 0 156 4 558 608 KAF2898850.1 hypothetical protein ILUMI_07308 [Ignelater luminosus] diamond 765 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Elateridae Ignelater Ignelater luminosus
31613664 31613664 PRJEB41113_S_NODE_5836_length_182_cov_2.075862_g5827_i0 PRJEB41113 5836 182 2.075862 3.77806884 Clunio marinus 568069 Arthropoda Arthropoda 53.1 3.35e-6   NR CRK90543.1 568069 g5827 i0 79.3 0.956043956043956 29 6 47.8 0 181 95 302 330 CRK90543.1 CLUMA_CG004247, isoform A [Clunio marinus] diamond 174 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
32081452 32081452 PRJEB41113_S_NODE_7158_length_173_cov_4.220588_g7149_i0 PRJEB41113 7158 173 4.220588 7.30161724 Scarabaeidae 7055 Arthropoda Arthropoda 84.7 2.25e-17   NR KAI4460277.1 644536 g7149 i0 91.1 3.12138728323699 45 4 78 0 139 5 315 359 KAI4460277.1 f-box/tpr repeat protein pof3 [Holotrichia oblita] diamond 540 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
32846146 32846146 PRJEB41113_S_NODE_13040_length_153_cov_1.793103_g13031_i0 PRJEB41113 13040 153 1.793103 2.74344759 Sancassania mycophaga 3127633 Arthropoda Arthropoda 62.4 1.29e-9   NR YP_011102162.1 3127633 g13031 i0 58 0.980392156862745 50 21 98 0 4 153 422 471 YP_011102162.1 NADH dehydrogenase subunit 5 [Sancassania mycophaga] diamond 150 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Sancassania Sancassania mycophaga

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