RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJNA993416" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA993416 · 30 ✖
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
2250984 2250984 PRJNA993416_P_NODE_11382_length_261_cov_1.329787_g11277_i0 PRJNA993416 11382 261 1.329787 3.47074407 Bactrocera dorsalis 27457 Arthropoda Arthropoda 455 1.55e-123   NTclustered gi|2273966520|ref|XM_011206105.4| 27457 g11277 i0 98.084 10.9386973180077 261 5 100 0 1 261 2177 1917 PREDICTED: Bactrocera dorsalis vesicle-fusing ATPase 1 (LOC105226961), transcript variant X1, mRNA blastn 2855 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
3526596 3526596 PRJNA993416_P_NODE_7783_length_295_cov_3.054054_g7678_i0 PRJNA993416 7783 295 3.054054 9.0094593 Thrips palmi 161013 Arthropoda Arthropoda 366 8.61e-97   NTclustered gi|1841799519|ref|XM_034391952.1| 161013 g7678 i0 89.583 2.07796610169492 288 30 98 0 8 295 3393 3106 PREDICTED: Thrips palmi DNA polymerase delta catalytic subunit (LOC117649312), transcript variant X1, mRNA blastn 613 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
5101149 5101149 PRJNA993416_P_NODE_13244_length_249_cov_0.875000_g13139_i0 PRJNA993416 13244 249 0.875 2.17875 Bactrocera 27456 Arthropoda Arthropoda 455 1.47e-123   NTclustered gi|2273967780|ref|XM_011200558.4| 27457 g13139 i0 99.598 25.1285140562249 249 1 100 0 1 249 210 458 PREDICTED: Bactrocera dorsalis probable 60S ribosomal protein L37-A (LOC105222978), mRNA blastn 6257 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
6079022 6079022 PRJNA993416_P_NODE_13465_length_248_cov_0.880000_g13360_i0 PRJNA993416 13465 248 0.88 2.1824 Venturia canescens 32260 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2089817871|ref|XM_043412868.1| 32260 g13360 i0 94.444 0.870967741935484 36 1 15 1 55 90 1092 1126 PREDICTED: Venturia canescens Oxysterol-binding protein-related protein 8 (Orp8), transcript variant X4, mRNA blastn 216 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
6079119 6079119 PRJNA993416_P_NODE_3125_length_484_cov_1.654501_g3020_i0 PRJNA993416 3125 484 1.654501 8.00778484 Episyrphus balteatus 286459 Arthropoda Arthropoda 60.2 2.82e-4   NTclustered gi|2501310459|ref|XM_055996361.1| 286459 g3020 i0 94.872 0.196280991735537 39 1 8 1 275 313 1954 1991 PREDICTED: Episyrphus balteatus maltase A2-like (LOC129916427), mRNA blastn 95 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Episyrphus Episyrphus balteatus
6377039 6377039 PRJNA993416_P_NODE_3065_length_488_cov_1.484337_g2960_i0 PRJNA993416 3065 488 1.484337 7.24356456 Bactrocera 27456 Arthropoda Arthropoda 902 0   NTclustered gi|1619304528|gb|MG688105.1| 27457 g2960 i0 100 100 488 0 100 0 1 488 1153 666 Bactrocera dorsalis clone PX_35 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 48800 902 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
7353801 7353801 PRJNA993416_P_NODE_9866_length_275_cov_3.247525_g9761_i0 PRJNA993416 9866 275 3.247525 8.93069375 Bactrocera dorsalis 27457 Arthropoda Arthropoda 503 5.809999999999998e-138   NTclustered gi|1851771247|gb|MT474619.1| 27457 g9761 i0 99.636 36.0290909090909 275 1 100 0 1 275 531 257 Bactrocera dorsalis odorant-binding protein (OBP83a) mRNA, complete cds blastn 9908 503 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
8628769 8628769 PRJNA993416_P_NODE_11087_length_264_cov_1.272251_g10982_i0 PRJNA993416 11087 264 1.272251 3.35874264 Bactrocera dorsalis 27457 Arthropoda Arthropoda 483 7.219999999999998e-132   NTclustered gi|2273921408|ref|XM_011207951.4| 27457 g10982 i0 99.621 7.99242424242424 264 1 100 0 1 264 693 430 PREDICTED: Bactrocera dorsalis membrane-associated progesterone receptor component 1 (LOC105228227), mRNA blastn 2110 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
8629051 8629051 PRJNA993416_P_NODE_9427_length_279_cov_1.495146_g9322_i0 PRJNA993416 9427 279 1.495146 4.17145734 Bactrocera dorsalis 27457 Arthropoda Arthropoda 516 7.58e-142   NTclustered gi|2273921428|ref|XM_011207966.4| 27457 g9322 i0 100 7.77777777777778 279 0 100 0 1 279 448 726 PREDICTED: Bactrocera dorsalis cathepsin B (LOC105228237), mRNA blastn 2170 516 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
9903952 9903952 PRJNA993416_P_NODE_11468_length_260_cov_1.577540_g11363_i0 PRJNA993416 11468 260 1.57754 4.101604 Bombus pyrosoma 396416 Arthropoda Arthropoda 340 4.52e-89   NTclustered gi|2097217982|ref|XM_043729041.1| 396416 g11363 i0 97.03 2.67692307692308 202 6 78 0 59 260 3579 3378 PREDICTED: Bombus pyrosoma regulator of telomere elongation helicase 1 homolog (LOC122568830), mRNA blastn 696 340 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus pyrosoma
11179079 11179079 PRJNA993416_P_NODE_10409_length_270_cov_1.522843_g10304_i0 PRJNA993416 10409 270 1.522843 4.1116761 Bombus terrestris 30195 Arthropoda Arthropoda 499 7.349999999999998e-137   NTclustered gi|2245587729|ref|XM_003396068.4| 30195 g10304 i0 100 29.9111111111111 270 0 100 0 1 270 2221 2490 PREDICTED: Bombus terrestris ribonucleoside-diphosphate reductase large subunit (LOC100648861), mRNA blastn 8076 499 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
11179112 11179112 PRJNA993416_P_NODE_12029_length_254_cov_1.629834_g11924_i0 PRJNA993416 12029 254 1.629834 4.13977836 Penaeus vannamei 6689 Arthropoda Arthropoda 464 2.4999999999999994e-126   NTclustered gi|2864135250|ref|XM_027367616.2| 6689 g11924 i0 99.606 100.48031496063 254 1 100 0 1 254 787 534 PREDICTED: Penaeus vannamei trypsin-1 (LOC113815556), transcript variant X1, mRNA blastn 25522 464 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
12455047 12455047 PRJNA993416_P_NODE_2590_length_533_cov_2.115217_g2486_i0 PRJNA993416 2590 533 2.115217 11.27410661 Desis jiaxiangi 2789892 Arthropoda Arthropoda 575 2.5099999999999995e-159   NTclustered gi|2192914883|ref|NC_060386.1| 2789892 g2486 i0 86.517 97.4821763602251 534 58 98 13 1 525 12549 12021 Desis jiaxiangi mitochondrion, complete sequence blastn 51958 575 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Desidae Desis Desis jiaxiangi
13729345 13729345 PRJNA993416_P_NODE_13531_length_248_cov_0.880000_g13426_i0 PRJNA993416 13531 248 0.88 2.1824 Bactrocera dorsalis 27457 Arthropoda Arthropoda 455 1.4600000000000002e-123   NTclustered gi|2273944077|ref|XM_011205599.4| 27457 g13426 i0 100 35.5524193548387 246 0 99 0 3 248 3840 3595 PREDICTED: Bactrocera dorsalis afadin (LOC105226625), transcript variant X6, mRNA blastn 8817 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
13729349 13729349 PRJNA993416_P_NODE_13671_length_248_cov_0.880000_g13566_i0 PRJNA993416 13671 248 0.88 2.1824 Bactrocera dorsalis 27457 Arthropoda Arthropoda 453 5.2600000000000005e-123   NTclustered gi|2273947629|ref|XM_011206191.4| 27457 g13566 i0 99.597 11.5241935483871 248 1 100 0 1 248 936 689 PREDICTED: Bactrocera dorsalis GTP-binding protein SAR1 (LOC105227035), mRNA blastn 2858 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
13729381 13729381 PRJNA993416_P_NODE_15471_length_243_cov_0.905882_g15366_i0 PRJNA993416 15471 243 0.905882 2.20129326 Papilio xuthus 66420 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|910333014|ref|XM_013314427.1| 66420 g15366 i0 100 0.716049382716049 29 0 12 0 190 218 1834 1806 PREDICTED: Papilio xuthus zinc finger RNA-binding protein (LOC106119439), transcript variant X5, mRNA blastn 174 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio xuthus
15004007 15004007 PRJNA993416_P_NODE_9232_length_281_cov_1.120192_g9127_i0 PRJNA993416 9232 281 1.120192 3.14773952 Bactrocera dorsalis 27457 Arthropoda Arthropoda 520 5.909999999999999e-143   NTclustered gi|2273978207|ref|XM_049460118.1| 27457 g9127 i0 100 16 281 0 100 0 1 281 8340 8620 PREDICTED: Bactrocera dorsalis calcium-dependent secretion activator (LOC105221871), transcript variant X4, mRNA blastn 4496 520 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
17553931 17553931 PRJNA993416_P_NODE_9854_length_276_cov_1.073892_g9749_i0 PRJNA993416 9854 276 1.073892 2.96394192 Bactrocera dorsalis 27457 Arthropoda Arthropoda 444 3.58e-120   NTclustered gi|2273976521|ref|XM_049459369.1| 27457 g9749 i0 96.014 14.6231884057971 276 6 100 2 1 276 1679 1409 PREDICTED: Bactrocera dorsalis uncharacterized oxidoreductase YjmC (LOC105227988), transcript variant X2, mRNA blastn 4036 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
18827745 18827745 PRJNA993416_P_NODE_6255_length_333_cov_1.553846_g6150_i0 PRJNA993416 6255 333 1.553846 5.17430718 Drosophila obscura 7282 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2038093233|ref|XM_022360369.2| 7282 g6150 i0 100 0.0840840840840841 28 0 8 0 190 217 1020 1047 PREDICTED: Drosophila obscura general transcription factor IIF subunit 1-like (LOC111070070), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila obscura
21377977 21377977 PRJNA993416_P_NODE_1437_length_705_cov_2.376582_g1340_i0 PRJNA993416 1437 705 2.376582 16.7549031 Bactrocera dorsalis 27457 Arthropoda Arthropoda 1303 0   NTclustered gi|702076269|gb|KM244662.1| 27457 g1340 i0 100 100 705 0 100 0 1 705 13347 14051 Bactrocera dorsalis isolate CL25 mitochondrion, partial genome blastn 70500 1303 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
21378180 21378180 PRJNA993416_P_NODE_8197_length_289_cov_1.847222_g8092_i0 PRJNA993416 8197 289 1.847222 5.33847158 Bactrocera dorsalis 27457 Arthropoda Arthropoda 523 4.7199999999999987e-144   NTclustered gi|2273928677|ref|XM_049448691.1| 27457 g8092 i0 99.308 32.8477508650519 289 2 100 0 1 289 4869 5157 PREDICTED: Bactrocera dorsalis protein lev-9 (LOC105223769), transcript variant X4, mRNA blastn 9493 523 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
22653099 22653099 PRJNA993416_P_NODE_8838_length_284_cov_1.459716_g8733_i0 PRJNA993416 8838 284 1.459716 4.14559344 Bactrocera neohumeralis 98809 Arthropoda Arthropoda 484 2.1799999999999998e-132   NTclustered gi|2293704707|ref|XM_050480281.1| 98809 g8733 i0 97.527 7.00352112676056 283 7 99 0 1 283 434 716 PREDICTED: Bactrocera neohumeralis uncharacterized LOC126763080 (LOC126763080), mRNA blastn 1989 484 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera neohumeralis
24224585 24224585 PRJNA993416_P_NODE_14739_length_245_cov_0.895349_g14634_i0 PRJNA993416 14739 245 0.895349 2.19360505 Bactrocera 27456 Arthropoda Arthropoda 453 5.1900000000000006e-123   NTclustered gi|2431473728|gb|MT121284.1| 27457 g14634 i0 100 100 245 0 100 0 1 245 3413 3169 Bactrocera dorsalis isolate China, Yunnan 14 mitochondrion, complete genome blastn 24500 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
27095527 27095527 PRJNA993416_P_NODE_15202_length_244_cov_0.871345_g15097_i0 PRJNA993416 15202 244 0.871345 2.1260818 root 1 Root_unresolved Root_unresolved 128 3.46e-32   NR XP_023324937.1 1294199 g15097 i0 76.5 2.98770491803279 81 19 99.6 0 2 244 298 378 XP_023324937.1 vigilin [Eurytemora carolleeae] diamond 729 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
27753258 27753258 PRJNA993416_P_NODE_11104_length_264_cov_1.193717_g10999_i0 PRJNA993416 11104 264 1.193717 3.15141288 Ixodes hexagonus 34612 Arthropoda Arthropoda 63.5 2.17e-9   NR CAL6191666.1 34612 g10999 i0 62.5 1.14772727272727 48 18 54.5 0 107 250 402 449 CAL6191666.1 unnamed protein product, partial [Ixodes hexagonus] diamond 303 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes hexagonus
29678725 29678725 PRJNA993416_P_NODE_10250_length_272_cov_1.276382_g10145_i0 PRJNA993416 10250 272 1.276382 3.47175904 Thrips palmi 161013 Arthropoda Arthropoda 152 3.26e-45   NR XP_034255971.1 161013 g10145 i0 78.9 1.98529411764706 90 19 99.3 0 3 272 22 111 XP_034255971.1 60S ribosomal protein L14 isoform X2 [Thrips palmi] diamond 540 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
31227002 31227002 PRJNA993416_P_NODE_14655_length_245_cov_0.895349_g14550_i0 PRJNA993416 14655 245 0.895349 2.19360505 Chironomus riparius 315576 Arthropoda Arthropoda 89 2.08e-18   NR CAG9799483.1 315576 g14550 i0 55.7 0.96734693877551 79 30 96.7 2 239 3 331 404 CAG9799483.1 unnamed protein product [Chironomus riparius] diamond 237 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31385442 31385442 PRJNA993416_P_NODE_13696_length_248_cov_0.862857_g13591_i0 PRJNA993416 13696 248 0.862857 2.13988536 Chironomus riparius 315576 Arthropoda Arthropoda 107 7.02e-25   NR CAG9804166.1 315576 g13591 i0 59.3 0.979838709677419 81 33 98 0 3 245 101 181 CAG9804166.1 unnamed protein product [Chironomus riparius] diamond 243 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31764810 31764810 PRJNA993416_P_NODE_7097_length_310_cov_3.548523_g6992_i0 PRJNA993416 7097 310 3.548523 11.0004213 Halocaridina rubra 373956 Arthropoda Arthropoda 66.6 3.32e-10   NR KAK7081739.1 373956 g6992 i0 56 3.83225806451613 50 22 48.4 0 2 151 309 358 KAK7081739.1 hypothetical protein SK128_005861 [Halocaridina rubra] diamond 1188 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
31802161 31802161 PRJNA993416_P_NODE_7117_length_310_cov_2.810127_g7012_i0 PRJNA993416 7117 310 2.810127 8.7113937 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.2 0.005   NR XP_037869477.1 7091 g7012 i0 50 6.09677419354839 42 21 40.6 0 308 183 1337 1378 XP_037869477.1 uncharacterized protein LOC101741169 isoform X1 [Bombyx mori] diamond 1890 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori

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