RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA929952" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA929952 · 21 ✖
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
909155 909155 PRJNA929952_P_NODE_11701_length_325_cov_2.851351_g10409_i0 PRJNA929952 11701 325 2.851351 9.26689075 Teleiodes vulgella 1594352 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2918369900|emb|OZ237924.1| 1594352 g10409 i0 100 0.0861538461538462 28 0 9 0 175 202 6857835 6857808 Teleiodes vulgella genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
909184 909184 PRJNA929952_P_NODE_21981_length_181_cov_2.164474_g20687_i0 PRJNA929952 21981 181 2.164474 3.91769794 Tigriopus californicus 6832 Arthropoda Arthropoda 119 1.49e-22   NTclustered gi|2571331483|ref|XM_059227977.1| 6832 g20687 i0 91.765 48.1546961325967 85 7 47 0 96 180 1653 1569 PREDICTED: Tigriopus californicus tubulin beta chain-like (LOC131881189), mRNA blastn 8716 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
2530480 2530480 PRJNA929952_P_NODE_6402_length_486_cov_6.890591_g5259_i0 PRJNA929952 6402 486 6.890591 33.48827226 Sarcoptiformes 83137 Arthropoda Arthropoda 93.5 2.79e-14   NTclustered gi|386696255|gb|JQ000428.1| 474159 g5259 i0 84.536 4.53497942386831 97 11 20 4 1 95 1671 1765 Cerophagus nearcticus voucher UMMZ BMOC 05-0506-011 AD667 28S ribosomal RNA gene, partial sequence blastn 2204 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Gaudiellidae Cerophagus Cerophagus nearcticus
3460075 3460075 PRJNA929952_P_NODE_8963_length_396_cov_2.517711_g7698_i0 PRJNA929952 8963 396 2.517711 9.97013556 Lysiphlebus testaceipes 77504 Arthropoda Arthropoda 97.1 1.73e-15   NTclustered gi|62083466|gb|AY961556.1| 77504 g7698 i0 92.647 13.5782828282828 68 3 17 1 33 100 371 306 Lysiphlebus testaceipes ribosomal protein S24 (RpS24) mRNA, complete cds blastn 5377 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Lysiphlebus Lysiphlebus testaceipes
6012403 6012403 PRJNA929952_P_NODE_17605_length_238_cov_2.588517_g16311_i0 PRJNA929952 17605 238 2.588517 6.16067046 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2918386058|emb|OZ238101.1| 346795 g16311 i0 96.774 0.130252100840336 31 1 13 0 2 32 17808223 17808193 Longitarsus dorsalis genome assembly, chromosome: 8 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
6012416 6012416 PRJNA929952_P_NODE_23745_length_160_cov_3.297710_g22451_i0 PRJNA929952 23745 160 3.29771 5.276336 Aphidius gifuensis 684658 Arthropoda Arthropoda 244 2.04e-60   NTclustered gi|1251773033|gb|KY809870.1| 684658 g22451 i0 94.937 87.5375 158 5 99 2 1 158 91 245 Aphidius gifuensis 18S ribosomal RNA, partial sequence blastn 14006 244 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
6012436 6012436 PRJNA929952_P_NODE_7625_length_439_cov_3.980488_g6399_i0 PRJNA929952 7625 439 3.980488 17.47434232 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 52.8 0.042   NTclustered gi|2918376582|emb|OZ238012.1| 307131 g6399 i0 100 0.0637813211845103 28 0 6 0 393 420 55504093 55504066 Ceutorhynchus obstrictus genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
9837168 9837168 PRJNA929952_P_NODE_4588_length_583_cov_1.940433_g3605_i0 PRJNA929952 4588 583 1.940433 11.31272439 Bradysia coprophila 38358 Arthropoda Arthropoda 403 1.3799999999999993e-107   NTclustered gi|1928104269|ref|XM_037168613.1| 38358 g3605 i0 81.139 21.2847341337907 509 90 87 6 78 583 2560 2055 PREDICTED: Bradysia coprophila eukaryotic translation elongation factor 2 (LOC119066260), mRNA blastn 12409 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
11112817 11112817 PRJNA929952_P_NODE_7489_length_444_cov_2.879518_g6270_i0 PRJNA929952 7489 444 2.879518 12.78505992 Atteva aurea 721898 Arthropoda Arthropoda 93.5 2.53e-14   NTclustered gi|2328347550|ref|NC_067569.1| 721898 g6270 i0 74.016 8.33558558558559 254 54 56 10 197 444 5171 5418 Atteva aurea voucher CNU6720 mitochondrion, complete genome blastn 3701 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Attevidae Atteva Atteva aurea
12388298 12388298 PRJNA929952_P_NODE_12510_length_308_cov_3.308244_g11217_i0 PRJNA929952 12510 308 3.308244 10.18939152 Speleorchestes sp. AD1084 2051767 Arthropoda Arthropoda 93.5 1.69e-14   NTclustered gi|1282187773|gb|KY921978.1| 2051767 g11217 i0 94.915 3.75974025974026 59 3 19 0 29 87 2510 2568 Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence blastn 1158 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1084
12734231 12734231 PRJNA929952_P_NODE_22190_length_178_cov_2.214765_g20896_i0 PRJNA929952 22190 178 2.214765 3.9422817 Drosophila 7215 Arthropoda Arthropoda 58.4 3.24e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g20896 i0 100 3.02808988764045 31 0 17 0 106 136 107 77 PREDICTED: Drosophila nasuta potassium voltage-gated channel protein Shaker (LOC132796862), transcript variant X2, mRNA blastn 539 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
14937102 14937102 PRJNA929952_P_NODE_152_length_2070_cov_4.441940_g97_i0 PRJNA929952 152 2070 4.44194 91.948158 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 363 1.18e-112   NR KAI2799691.1 40697 g97 i0 54.7 52.4565217391304 358 122 46.8 4 1327 359 283 635 KAI2799691.1 Heat shock cognate 71 kDa protein [Blomia tropicalis] diamond 108585 363 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Echimyopodidae Blomia Blomia tropicalis
17487431 17487431 PRJNA929952_P_NODE_2194_length_805_cov_5.122423_g1592_i0 PRJNA929952 2194 805 5.122423 41.23550515 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 54.7 0.022   NTclustered gi|2918369774|emb|OZ237841.1| 1007376 g1592 i0 90.476 0.0521739130434783 42 2 5 2 656 696 10600344 10600384 Pseudoterpna coronillaria genome assembly, chromosome: 16 blastn 42 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
18760752 18760752 PRJNA929952_P_NODE_11895_length_321_cov_1.979452_g10602_i0 PRJNA929952 11895 321 1.979452 6.35404092 Longitarsus dorsalis 346795 Arthropoda Arthropoda 309 1.62e-79   NTclustered gi|2918386052|emb|OZ238096.1| 346795 g10602 i0 84.227 322.722741433022 317 50 99 0 1 317 6520166 6520482 Longitarsus dorsalis genome assembly, chromosome: 3 blastn 103594 309 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
20035768 20035768 PRJNA929952_P_NODE_20596_length_200_cov_4.093567_g19302_i0 PRJNA929952 20596 200 4.093567 8.187134 Midgee thompsoni 1956472 Arthropoda Arthropoda 63.9 8.03e-6   NTclustered gi|1148357279|gb|KY016802.1| 1956472 g19302 i0 88.462 15.365 52 6 26 0 3 54 1238 1289 Midgee thompsoni isolate ARAGH000057 18S ribosomal RNA gene, partial sequence blastn 3073 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Amaurobiidae Midgee Midgee thompsoni
21311266 21311266 PRJNA929952_P_NODE_6057_length_502_cov_19.105708_g4945_i0 PRJNA929952 6057 502 19.105708 95.910654160000007 Midgee thompsoni 1956472 Arthropoda Arthropoda 63.9 2.27e-5   NTclustered gi|1148357279|gb|KY016802.1| 1956472 g4945 i0 88.462 6.12151394422311 52 6 10 0 3 54 1238 1289 Midgee thompsoni isolate ARAGH000057 18S ribosomal RNA gene, partial sequence blastn 3073 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Amaurobiidae Midgee Midgee thompsoni
25135284 25135284 PRJNA929952_P_NODE_1340_length_993_cov_6.316390_g955_i0 PRJNA929952 1340 993 6.31639 62.7217527 Nasonia vitripennis 7425 Arthropoda Arthropoda 58.4 0.002   NTclustered gi|1815722811|ref|XM_032598121.1| 7425 g955 i0 97.059 0.0342396777442095 34 1 3 0 57 90 141 108 PREDICTED: Nasonia vitripennis mucin-6-like (LOC116416952), mRNA blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
25135307 25135307 PRJNA929952_P_NODE_22720_length_172_cov_1.426573_g21426_i0 PRJNA929952 22720 172 1.426573 2.45370556 Bradysia coprophila 38358 Arthropoda Arthropoda 191 2.93e-44   NTclustered gi|1928074112|ref|XM_037184666.1| 38358 g21426 i0 86.628 146.383720930233 172 23 100 0 1 172 2213 2384 PREDICTED: Bradysia coprophila polyubiquitin-C (LOC119077460), transcript variant X6, mRNA blastn 25178 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
25481386 25481386 PRJNA929952_P_NODE_20920_length_195_cov_4.945783_g19626_i0 PRJNA929952 20920 195 4.945783 9.64427685 Timema 61471 Arthropoda Arthropoda 63.9 7.78e-6   NTclustered gi|1964873238|emb|OE203545.1| 61474 g19626 i0 95 0.41025641025641 40 2 21 0 43 82 1139 1100 2_Tcm_b3v08 blastn 80 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
31573708 31573708 PRJNA929952_P_NODE_23236_length_166_cov_2.072993_g21942_i0 PRJNA929952 23236 166 2.072993 3.44116838 Leptinotarsa decemlineata 7539 Arthropoda Arthropoda 48.1 1.64e-4   NR XP_023015979.1 7539 g21942 i0 57.9 3.32530120481928 38 15 66.9 1 111 1 292 329 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 552 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
32308545 32308545 PRJNA929952_P_NODE_5079_length_553_cov_3.791985_g4045_i0 PRJNA929952 5079 553 3.791985 20.96967705 Culicidae 7157 Arthropoda Arthropoda 138 1.0399999999999998e-37   NR XP_053685040.1 53552 g4045 i0 50.4 16.2151898734177 137 62 74.3 1 472 62 33 163 XP_053685040.1 ADP-ribose glycohydrolase OARD1-like [Sabethes cyaneus] diamond 8967 138 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Sabethes Sabethes cyaneus

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