RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA588137" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA588137 · 32 ✖
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
564765 564765 PRJNA588137_S_NODE_281_length_839_cov_2.159269_g258_i0 PRJNA588137 281 839 2.159269 18.11626691 Idotea baltica 82763 Arthropoda Arthropoda 397 9.089999999999998e-132   NR MCL4154024.1 82763 g258 i0 85.4 0.854588796185936 239 35 85.5 0 63 779 364 602 MCL4154024.1 hypothetical protein [Idotea baltica] diamond 717 397 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
4392271 4392271 PRJNA588137_S_NODE_6464_length_251_cov_0.865169_g6431_i0 PRJNA588137 6464 251 0.865169 2.17157419 Calliphora vicina 7373 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2736829633|ref|XM_065505013.1| 7373 g6431 i0 100 0.111553784860558 28 0 11 0 204 231 914 941 PREDICTED: Calliphora vicina uncharacterized protein F13E9.13, mitochondrial (LOC135954781), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
4966660 4966660 PRJNA588137_S_NODE_9984_length_243_cov_0.905882_g9951_i0 PRJNA588137 9984 243 0.905882 2.20129326 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1963582870|emb|OE226063.1| 61474 g9951 i0 100 0.691358024691358 28 0 12 0 162 189 1018 991 2_Tcm_b3v08 blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
7516326 7516326 PRJNA588137_S_NODE_386_length_728_cov_7.741985_g359_i0 PRJNA588137 386 728 7.741985 56.3616508 Bemisia 7037 Arthropoda Arthropoda 1345 0   NTclustered gi|1254338572|gb|KY951450.1| 7038 g359 i0 100 86.2472527472527 728 0 100 0 1 728 10343 9616 Bemisia tabaci mitochondrion, complete genome blastn 62788 1345 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
8217904 8217904 PRJNA588137_S_NODE_10127_length_243_cov_0.905882_g10094_i0 PRJNA588137 10127 243 0.905882 2.20129326 Galleria mellonella 7137 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2418154743|ref|XM_026894655.3| 7137 g10094 i0 100 0.11522633744856 28 0 12 0 16 43 115 88 PREDICTED: Galleria mellonella eukaryotic translation initiation factor 2 subunit 1 (LOC113511073), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Galleria Galleria mellonella
8218003 8218003 PRJNA588137_S_NODE_9387_length_244_cov_1.660819_g9354_i0 PRJNA588137 9387 244 1.660819 4.05239836 Bemisia tabaci 7038 Arthropoda Arthropoda 449 6.68e-122   NTclustered gi|1254338572|gb|KY951450.1| 7038 g9354 i0 100 20.8647540983607 243 0 99 0 1 243 14768 14526 Bemisia tabaci mitochondrion, complete genome blastn 5091 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
9493141 9493141 PRJNA588137_S_NODE_10168_length_243_cov_0.905882_g10135_i0 PRJNA588137 10168 243 0.905882 2.20129326 Anarta stigmosa 1869462 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2918376538|emb|OZ237977.1| 1869462 g10135 i0 100 0.11522633744856 28 0 12 0 179 206 6955855 6955882 Anarta stigmosa genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
9493184 9493184 PRJNA588137_S_NODE_4328_length_287_cov_1.439252_g4295_i0 PRJNA588137 4328 287 1.439252 4.13065324 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g4295 i0 100 0.101045296167247 29 0 10 0 137 165 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
10769009 10769009 PRJNA588137_S_NODE_1629_length_394_cov_1.819315_g1596_i0 PRJNA588137 1629 394 1.819315 7.1681011 Bemisia tabaci 7038 Arthropoda Arthropoda 728 0   NTclustered gi|1440888351|gb|MH186145.1| 7038 g1596 i0 100 56.005076142132 394 0 100 0 1 394 10388 10781 Bemisia tabaci isolate 153_1 mitochondrion, complete genome blastn 22066 728 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
12043847 12043847 PRJNA588137_S_NODE_10130_length_243_cov_0.905882_g10097_i0 PRJNA588137 10130 243 0.905882 2.20129326 Platynothrus peltifer 128015 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2579718319|gb|CP133308.1| 128015 g10097 i0 100 0.119341563786008 29 0 12 0 168 196 22204033 22204005 Platynothrus peltifer isolate 155_3 chromosome 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
13318662 13318662 PRJNA588137_S_NODE_10071_length_243_cov_0.905882_g10038_i0 PRJNA588137 10071 243 0.905882 2.20129326 Bemisia tabaci 7038 Arthropoda Arthropoda 449 6.65e-122   NTclustered gi|1101361041|ref|XM_019057265.1| 7038 g10038 i0 100 1 243 0 100 0 1 243 14280 14038 PREDICTED: Bemisia tabaci midasin (LOC109041095), mRNA blastn 243 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
15867379 15867379 PRJNA588137_S_NODE_11133_length_241_cov_0.916667_g11100_i0 PRJNA588137 11133 241 0.916667 2.20916747 Bemisia tabaci 7038 Arthropoda Arthropoda 446 8.519999999999999e-121   NTclustered gi|1101373533|ref|XM_019052797.1| 7038 g11100 i0 100 1 241 0 100 0 1 241 1208 968 PREDICTED: Bemisia tabaci adenosine kinase 2 (LOC109037931), mRNA blastn 241 446 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
15867380 15867380 PRJNA588137_S_NODE_1313_length_427_cov_1.898305_g1280_i0 PRJNA588137 1313 427 1.898305 8.10576235 Bemisia tabaci 7038 Arthropoda Arthropoda 771 0   NTclustered gi|1254338572|gb|KY951450.1| 7038 g1280 i0 99.296 95.0936768149883 426 3 99 0 2 427 730 305 Bemisia tabaci mitochondrion, complete genome blastn 40605 771 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
15867457 15867457 PRJNA588137_S_NODE_8913_length_245_cov_1.674419_g8880_i0 PRJNA588137 8913 245 1.674419 4.10232655 Bemisia tabaci 7038 Arthropoda Arthropoda 453 5.1900000000000006e-123   NTclustered gi|1101360812|ref|XM_019057152.1| 7038 g8880 i0 100 2.76734693877551 245 0 100 0 1 245 373 129 PREDICTED: Bemisia tabaci 40S ribosomal protein S25 (LOC109040995), mRNA blastn 678 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
17142396 17142396 PRJNA588137_S_NODE_5914_length_257_cov_1.369565_g5881_i0 PRJNA588137 5914 257 1.369565 3.51978205 Bemisia tabaci 7038 Arthropoda Arthropoda 470 5.45e-128   NTclustered gi|1101338378|ref|XM_019061836.1| 7038 g5881 i0 99.611 4.23346303501946 257 1 100 0 1 257 1706 1450 PREDICTED: Bemisia tabaci elongation factor 1-alpha 2 (LOC109044237), transcript variant X1, mRNA blastn 1088 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
18416655 18416655 PRJNA588137_S_NODE_875_length_504_cov_6.125290_g842_i0 PRJNA588137 875 504 6.12529 30.8714616 Oppiella nova 334625 Arthropoda Arthropoda 54.7 0.014   NTclustered gi|1962580772|emb|OC914909.1| 334625 g842 i0 100 0.0575396825396825 29 0 6 0 59 87 7584 7612 Oppiella nova blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
19691153 19691153 PRJNA588137_S_NODE_4496_length_284_cov_0.995261_g4463_i0 PRJNA588137 4496 284 0.995261 2.82654124 Idotea baltica 82763 Arthropoda Arthropoda 116 7.91e-28   NR MCL4154024.1 82763 g4463 i0 82.2 0.77112676056338 73 13 77.1 0 65 283 276 348 MCL4154024.1 hypothetical protein [Idotea baltica] diamond 219 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
20966951 20966951 PRJNA588137_S_NODE_8797_length_246_cov_0.890173_g8764_i0 PRJNA588137 8797 246 0.890173 2.18982558 Bemisia tabaci 7038 Arthropoda Arthropoda 455 1.4500000000000002e-123   NTclustered gi|1101356174|ref|XM_019048700.1| 7038 g8764 i0 100 1 246 0 100 0 1 246 53 298 PREDICTED: Bemisia tabaci cytochrome c oxidase subunit NDUFA4 (LOC109035172), mRNA blastn 246 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
21540413 21540413 PRJNA588137_S_NODE_4617_length_281_cov_1.110577_g4584_i0 PRJNA588137 4617 281 1.110577 3.12072137 Insecta 50557 Arthropoda Arthropoda 237 6.66e-58   NTclustered gi|269784694|ref|NM_001167977.1| 7425 g4584 i0 82.482 94.1494661921708 274 44 97 2 9 280 1515 1244 Nasonia vitripennis ATP synthase subunit alpha blw, mitochondrial (blw), mRNA; nuclear gene for mitochondrial product blastn 26456 237 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
22241915 22241915 PRJNA588137_S_NODE_9558_length_244_cov_0.900585_g9525_i0 PRJNA588137 9558 244 0.900585 2.1974274 Bemisia tabaci 7038 Arthropoda Arthropoda 446 8.639999999999999e-121   NTclustered gi|1101353332|ref|XM_019047167.1| 7038 g9525 i0 99.59 4.85245901639344 244 1 100 0 1 244 625 382 PREDICTED: Bemisia tabaci 40S ribosomal protein S6 (LOC109034167), mRNA blastn 1184 446 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
22241918 22241918 PRJNA588137_S_NODE_98_length_1232_cov_6.042278_g85_i0 PRJNA588137 98 1232 6.042278 74.44086496 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 0.003   NTclustered gi|1048003915|ref|XM_017627148.1| 28612 g85 i0 100 0.0251623376623377 31 0 3 0 574 604 708 738 PREDICTED: Rhagoletis zephyria uncharacterized LOC108371558 (LOC108371558), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
24790902 24790902 PRJNA588137_S_NODE_2800_length_328_cov_1.360784_g2767_i0 PRJNA588137 2800 328 1.360784 4.46337152 Ceratosolen solmsi 142686 Arthropoda Arthropoda 202 2.9e-47   NTclustered gi|766940274|ref|XM_011504427.1| 326594 g2767 i0 77.946 23.1158536585366 331 67 100 6 1 328 96 423 PREDICTED: Ceratosolen solmsi marchali ubiquitin-60S ribosomal protein L40 (LOC105366106), mRNA blastn 7582 202 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Agaonidae Ceratosolen Ceratosolen solmsi
24790925 24790925 PRJNA588137_S_NODE_5300_length_268_cov_1.184615_g5267_i0 PRJNA588137 5300 268 1.184615 3.1747682 Bemisia tabaci 7038 Arthropoda Arthropoda 496 9.429999999999999e-136   NTclustered gi|1789143598|gb|MN738103.1| 7038 g5267 i0 100 8.69776119402985 268 0 100 0 1 268 2710 2443 Bemisia tabaci elongation factor 2 mRNA, complete cds blastn 2331 496 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
27142527 27142527 PRJNA588137_S_NODE_3062_length_319_cov_1.252033_g3029_i0 PRJNA588137 3062 319 1.252033 3.99398527 Daphnia pulex 6669 Arthropoda Arthropoda 74.3 5.42e-15   NR EFX60666.1 6669 g3029 i0 46.7 2.56739811912226 75 40 70.5 0 310 86 2 76 EFX60666.1 hypothetical protein DAPPUDRAFT_19575, partial [Daphnia pulex] diamond 819 74.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27377897 27377897 PRJNA588137_S_NODE_10963_length_241_cov_0.916667_g10930_i0 PRJNA588137 10963 241 0.916667 2.20916747 Arthropoda 6656 Arthropoda Arthropoda 117 7.66e-30   NR CAL4127524.1 48144 g10930 i0 68.8 38.4647302904564 80 25 99.6 0 1 240 206 285 CAL4127524.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 9270 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
27806416 27806416 PRJNA588137_S_NODE_4144_length_291_cov_1.197248_g4111_i0 PRJNA588137 4144 291 1.197248 3.48399168 Habropoda laboriosa 597456 Arthropoda Arthropoda 68.6 5.66e-11   NR KOC58568.1 597456 g4111 i0 41.1 0.979381443298969 95 51 93.8 2 18 290 802 895 KOC58568.1 putative deoxycytidylate deaminase [Habropoda laboriosa] diamond 285 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Habropoda Habropoda laboriosa
28847982 28847982 PRJNA588137_S_NODE_8728_length_246_cov_0.890173_g8695_i0 PRJNA588137 8728 246 0.890173 2.18982558 Allacma fusca 39272 Arthropoda Arthropoda 94.7 1.83e-20   NR CAG7728132.1 39272 g8695 i0 55.3 0.926829268292683 76 34 92.7 0 236 9 473 548 CAG7728132.1 unnamed protein product [Allacma fusca] diamond 228 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
29051246 29051246 PRJNA588137_S_NODE_8128_length_247_cov_0.885057_g8095_i0 PRJNA588137 8128 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 119 4.4e-29   NR KAF6207491.1 248454 g8095 i0 71.1 20.0161943319838 83 23 99.6 1 2 247 574 656 KAF6207491.1 hypothetical protein GE061_015937 [Apolygus lucorum] diamond 4944 120 0.991666666666667 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
29605592 29605592 PRJNA588137_S_NODE_8350_length_247_cov_0.885057_g8317_i0 PRJNA588137 8350 247 0.885057 2.18609079 Clunio marinus 568069 Arthropoda Arthropoda 68.2 4.43e-11   NR CRK96648.1 568069 g8317 i0 59.6 0.692307692307692 57 20 69.2 1 234 64 555 608 CRK96648.1 CLUMA_CG009862, isoform A [Clunio marinus] diamond 171 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
30472410 30472410 PRJNA588137_S_NODE_10773_length_242_cov_0.911243_g10740_i0 PRJNA588137 10773 242 0.911243 2.20520806 Metazoa 33208 Arthropoda Arthropoda 42.7 0.0376   NR XP_044743408.1 189513 g10740 i0 48.6 1.84710743801653 35 18 43.4 0 111 7 677 711 XP_044743408.1 attractin-like protein 1 [Chrysoperla carnea] diamond 447 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
31673318 31673318 PRJNA588137_S_NODE_2197_length_354_cov_1.288256_g2164_i0 PRJNA588137 2197 354 1.288256 4.56042624 Culicidae 7157 Arthropoda Arthropoda 104 1.2999999999999998e-24   NR XP_029715216.1 7160 g2164 i0 65.4 5.04237288135593 78 27 66.1 0 235 2 77 154 XP_029715216.1 large ribosomal subunit protein uL30 [Aedes albopictus] diamond 1785 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
32338062 32338062 PRJNA588137_S_NODE_4779_length_278_cov_1.126829_g4746_i0 PRJNA588137 4779 278 1.126829 3.13258462 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.8 5.06e-6   NR MCL4117871.1 82763 g4746 i0 45.5 1.98561151079137 66 36 71.2 0 274 77 5 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 552 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica

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