RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where bioproject = "PRJNA1004255" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1004255 · 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
153232 153232 PRJNA1004255_S_NODE_10421_length_198_cov_1.212903_g10213_i0 PRJNA1004255 10421 198 1.212903 2.40154794 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|1947890708|emb|OD104514.1| 170557 g10213 i0 94.118 0.171717171717172 34 2 17 0 86 119 745 778 1_Tps_b3v08 blastn 34 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
2276104 2276104 PRJNA1004255_S_NODE_3682_length_292_cov_2.819277_g3474_i0 PRJNA1004255 3682 292 2.819277 8.23228884 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|1026137028|emb|LT560377.1| 85552 g3474 i0 100 0.287671232876712 28 0 10 0 1 28 8 35 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
2703460 2703460 PRJNA1004255_S_NODE_15063_length_167_cov_3.693548_g14855_i0 PRJNA1004255 15063 167 3.693548 6.16822516 Metopolophium dirhodum 44670 Arthropoda Arthropoda 303 3.5e-78   NTclustered gi|2621214727|ref|XR_009663789.1| 44670 g14855 i0 99.401 92.5508982035928 167 1 100 0 1 167 3014 3180 PREDICTED: Metopolophium dirhodum large subunit ribosomal RNA (LOC132937693), rRNA blastn 15456 303 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
2703466 2703466 PRJNA1004255_S_NODE_17803_length_154_cov_5.081081_g17595_i0 PRJNA1004255 17803 154 5.081081 7.82486474 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 272 8.91e-69   NTclustered gi|239790075|dbj|AK341167.1| 7029 g17595 i0 98.693 7.21428571428571 153 2 99 0 1 153 787 939 Acyrthosiphon pisum ACYPI004705 mRNA, clone: 514G17, complete cds, full-insert cDNA sequence based on the ESTs (5'-EST:FF316223, 3'-EST:FF316541) blastn 1111 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
2703468 2703468 PRJNA1004255_S_NODE_18163_length_153_cov_1.709091_g17955_i0 PRJNA1004255 18163 153 1.709091 2.61490923 Aceria sp. ADM-2012 1260289 Arthropoda Arthropoda 220 3.25e-53   NTclustered gi|418208589|gb|JQ512779.1| 1260289 g17955 i0 92.81 58.3006535947712 153 9 99 2 1 152 344 193 Aceria sp. ADM-2012 haplotype 27 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 8920 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria sp. ADM-2012
2703503 2703503 PRJNA1004255_S_NODE_6243_length_242_cov_14.236181_g6035_i0 PRJNA1004255 6243 242 14.236181 34.45155802 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1184387702|emb|LT835105.1| 85552 g6035 i0 100 0.235537190082645 29 0 12 0 1 29 6 34 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
2703506 2703506 PRJNA1004255_S_NODE_7583_length_225_cov_6.016484_g7375_i0 PRJNA1004255 7583 225 6.016484 13.537089 Helicoverpa assulta 52344 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2636206747|emb|OY979773.1| 52344 g7375 i0 100 0.133333333333333 30 0 13 0 37 66 17357990 17358019 Helicoverpa assulta genome assembly, chromosome: Z blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
3979627 3979627 PRJNA1004255_S_NODE_10524_length_197_cov_1.175325_g10316_i0 PRJNA1004255 10524 197 1.175325 2.31539025 Homalodisca vitripennis 197043 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2196656407|ref|XM_046815557.1| 197043 g10316 i0 87.5 0.243654822335025 48 5 24 1 15 61 1531 1578 PREDICTED: Homalodisca vitripennis tyrosine-protein phosphatase non-receptor type 2-like (LOC124361499), transcript variant X1, mRNA blastn 48 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
3979647 3979647 PRJNA1004255_S_NODE_18704_length_151_cov_1.740741_g18496_i0 PRJNA1004255 18704 151 1.740741 2.62851891 Cydia pomonella 82600 Arthropoda Arthropoda 52.8 0.012   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g18496 i0 100 0.370860927152318 28 0 19 0 49 76 126 99 PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
4828991 4828991 PRJNA1004255_S_NODE_4004_length_284_cov_2.535270_g3796_i0 PRJNA1004255 4004 284 2.53527 7.2001668 root 1 Root_unresolved Root_unresolved 52.8 0.026   NTclustered gi|1184387702|emb|LT835105.1| 85552 g3796 i0 100 0.197183098591549 28 0 10 0 257 284 33 6 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
7378564 7378564 PRJNA1004255_S_NODE_9006_length_210_cov_3.598802_g8798_i0 PRJNA1004255 9006 210 3.598802 7.5574842 Dorypteryx 209978 Arthropoda Arthropoda 377 2.68e-100   NTclustered gi|54399814|gb|AY630454.1| 209979 g8798 i0 99.048 100.719047619048 210 2 100 0 1 210 604 813 Dorypteryx domestica voucher KY97 18S ribosomal RNA gene, partial sequence blastn 21151 377 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Psyllipsocidae Dorypteryx Dorypteryx domestica
9080692 9080692 PRJNA1004255_S_NODE_12868_length_180_cov_1.262774_g12660_i0 PRJNA1004255 12868 180 1.262774 2.2729932 Condylostylus longicornis 2530218 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2496089683|ref|XM_055526981.1| 2530218 g12660 i0 96.97 0.338888888888889 33 0 18 1 133 164 297 329 PREDICTED: Condylostylus longicornis GATA zinc finger domain-containing protein 15-like (LOC129613064), mRNA blastn 61 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
9928946 9928946 PRJNA1004255_S_NODE_11928_length_186_cov_1.972028_g11720_i0 PRJNA1004255 11928 186 1.972028 3.66797208 Aphididae 27482 Arthropoda Arthropoda 209 8.92e-50   NTclustered gi|1685532496|ref|XR_003840248.1| 7029 g11720 i0 87.097 27.1290322580645 186 23 100 1 1 186 1460 1644 PREDICTED: Acyrthosiphon pisum uncharacterized LOC107885124 (LOC107885124), ncRNA blastn 5046 211 0.990521327014218 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
11631833 11631833 PRJNA1004255_S_NODE_5590_length_253_cov_1.342857_g5382_i0 PRJNA1004255 5590 253 1.342857 3.39742821 Scylla paramamosain 85552 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1184387702|emb|LT835105.1| 85552 g5382 i0 100 0.229249011857708 30 0 12 0 1 30 6 35 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
11631866 11631866 PRJNA1004255_S_NODE_9770_length_203_cov_3.818750_g9562_i0 PRJNA1004255 9770 203 3.81875 7.7520625 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g9562 i0 96.875 0.315270935960591 32 1 16 0 55 86 24059124 24059155 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
14181982 14181982 PRJNA1004255_S_NODE_9112_length_209_cov_2.831325_g8904_i0 PRJNA1004255 9112 209 2.831325 5.91746925 Bryobia eharai 1490228 Arthropoda Arthropoda 294 2.76e-75   NTclustered gi|699114445|dbj|AB926227.1| 1490228 g8904 i0 92.344 6.07655502392345 209 13 100 3 1 209 95 300 Bryobia eharai gene for 18S ribosomal RNA, partial sequence, strain: Bryeha0612 blastn 1270 294 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Bryobia Bryobia eharai
15455889 15455889 PRJNA1004255_S_NODE_18913_length_150_cov_4.831776_g18705_i0 PRJNA1004255 18913 150 4.831776 7.247664 Armadillidium vulgare 13347 Arthropoda Arthropoda 278 1.85e-70   NTclustered gi|951215720|dbj|LC054202.1| 13347 g18705 i0 100 11.5533333333333 150 0 100 0 1 150 521 670 Armadillidium vulgare gene for 18S ribosomal RNA, partial sequence blastn 1733 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
15455932 15455932 PRJNA1004255_S_NODE_6873_length_234_cov_1.324607_g6665_i0 PRJNA1004255 6873 234 1.324607 3.09958038 Bombyx mori 7091 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g6665 i0 100 0.367521367521368 30 0 13 0 1 30 28 57 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 86 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
16303456 16303456 PRJNA1004255_S_NODE_10273_length_199_cov_2.410256_g10065_i0 PRJNA1004255 10273 199 2.410256 4.79640944 root 1 Root_unresolved Root_unresolved 52.8 0.017   NTclustered gi|1184387702|emb|LT835105.1| 85552 g10065 i0 100 0.281407035175879 28 0 14 0 172 199 33 6 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
16730140 16730140 PRJNA1004255_S_NODE_10134_length_200_cov_2.095541_g9926_i0 PRJNA1004255 10134 200 2.095541 4.191082 Bacillus rossius 75184 Arthropoda Arthropoda 171 4.599999999999999e-38   NTclustered gi|2686795422|ref|XM_063381357.1| 93214 g9926 i0 84.393 13.695 173 27 87 0 1 173 486 658 PREDICTED: Bacillus rossius redtenbacheri small ribosomal subunit protein uS11A (LOC134539369), transcript variant X2, mRNA blastn 2739 171 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
16730158 16730158 PRJNA1004255_S_NODE_16054_length_162_cov_3.411765_g15846_i0 PRJNA1004255 16054 162 3.411765 5.5270593 Artemia franciscana 6661 Arthropoda Arthropoda 278 2.04e-70   NTclustered gi|2743030278|ref|XM_065711281.1| 6661 g15846 i0 97.531 1 162 4 100 0 1 162 4330 4169 PREDICTED: Artemia franciscana protein pangolin, isoforms A/H/I/S-like (LOC136031638), mRNA blastn 162 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
16730173 16730173 PRJNA1004255_S_NODE_3054_length_310_cov_3.041199_g2846_i0 PRJNA1004255 3054 310 3.041199 9.4277169 Psocidae sp. NKU-003 1216954 Arthropoda Arthropoda 76.8 1.72e-9   NTclustered gi|399141782|gb|JQ309937.1| 1216954 g2846 i0 88.71 11.9838709677419 62 7 20 0 249 310 3836 3897 Psocidae sp. NKU-003 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 3715 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Psocidae   Psocidae sp. NKU-003
16730194 16730194 PRJNA1004255_S_NODE_6034_length_246_cov_1.600985_g5826_i0 PRJNA1004255 6034 246 1.600985 3.9384231 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 60.2 1.33e-4   NTclustered gi|2919538070|emb|OZ238348.1| 1002887 g5826 i0 97.222 0.390243902439024 36 0 15 1 19 54 23637999 23637965 Glaucopsyche melanops genome assembly, chromosome: 7 blastn 96 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
16730204 16730204 PRJNA1004255_S_NODE_7974_length_221_cov_3.679775_g7766_i0 PRJNA1004255 7974 221 3.679775 8.13230275 Venturia canescens 32260 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2089769906|ref|XM_043415605.1| 32260 g7766 i0 100 0.253393665158371 28 0 13 0 59 86 194 167 PREDICTED: Venturia canescens nuclear pore complex protein Nup98-96 (Nup98-96), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
19278790 19278790 PRJNA1004255_S_NODE_13596_length_175_cov_5.825758_g13388_i0 PRJNA1004255 13596 175 5.825758 10.1950765 Aphidius gifuensis 684658 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2106725932|ref|XM_044144987.1| 684658 g13388 i0 96.97 0.188571428571429 33 1 19 0 142 174 91 123 PREDICTED: Aphidius gifuensis facilitated trehalose transporter Tret1-like (LOC122847366), mRNA blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
22677794 22677794 PRJNA1004255_S_NODE_10038_length_201_cov_1.487342_g9830_i0 PRJNA1004255 10038 201 1.487342 2.98955742 root 1 Root_unresolved Root_unresolved 54.7 0.005   NTclustered gi|1184387702|emb|LT835105.1| 85552 g9830 i0 100 0.303482587064677 29 0 14 0 1 29 6 34 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 61 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
22677812 22677812 PRJNA1004255_S_NODE_16698_length_159_cov_2.793103_g16490_i0 PRJNA1004255 16698 159 2.793103 4.44103377 Aceria 109362 Arthropoda Arthropoda 294 1.98e-75   NTclustered gi|2240866639|gb|ON555754.1| 109366 g16490 i0 100 100.308176100629 159 0 100 0 1 159 322 164 Aceria tulipae isolate AS197 small subunit ribosomal RNA gene, partial sequence blastn 15949 294 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria tulipae
24379304 24379304 PRJNA1004255_S_NODE_6620_length_237_cov_5.525773_g6412_i0 PRJNA1004255 6620 237 5.525773 13.09608201 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1184387702|emb|LT835105.1| 85552 g6412 i0 100 0.240506329113924 29 0 12 0 209 237 34 6 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28487336 28487336 PRJNA1004255_S_NODE_8247_length_218_cov_2.954286_g8039_i0 PRJNA1004255 8247 218 2.954286 6.44034348 Nephila pilipes 299642 Arthropoda Arthropoda 43.9 0.00229   NR GFS81476.1 299642 g8039 i0 46.6 0.798165137614679 58 29 78.4 2 183 13 12 68 GFS81476.1 hypothetical protein NPIL_367381 [Nephila pilipes] diamond 174 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes

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