RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA931595" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA931595 · 27 ✖
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
2184844 2184844 PRJNA931595_P_NODE_10382_length_269_cov_1.454082_g10273_i0 PRJNA931595 10382 269 1.454082 3.91148058 Timema poppense 170557 Arthropoda Arthropoda 399 7.639999999999999e-107   NTclustered gi|1948206426|emb|OD000428.1| 170557 g10273 i0 93.939 98.6765799256506 264 16 98 0 6 269 160573 160310 1_Tps_b3v08 blastn 26544 399 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
4737971 4737971 PRJNA931595_P_NODE_13264_length_248_cov_0.880000_g13155_i0 PRJNA931595 13264 248 0.88 2.1824 Cordilura ciliata 113142 Arthropoda Arthropoda 440 4.0999999999999997e-119   NTclustered gi|151347527|gb|EF531130.1| 113142 g13155 i0 98.79 100.004032258065 248 1 100 2 1 248 1355 1600 Cordilura ciliata 28S ribosomal RNA gene, partial sequence blastn 24801 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Scathophagidae Cordilura Cordilura ciliata
6012799 6012799 PRJNA931595_P_NODE_12525_length_250_cov_1.728814_g12416_i0 PRJNA931595 12525 250 1.728814 4.322035 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1964819819|emb|OC862830.1| 1979941 g12416 i0 96.97 0.132 33 0 13 1 41 72 62 30 Medioppia subpectinata blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
6358983 6358983 PRJNA931595_P_NODE_1025_length_629_cov_7.282374_g918_i0 PRJNA931595 1025 629 7.282374 45.80613246 Aedes 7158 Arthropoda Arthropoda 1157 0   NTclustered gi|66269556|gb|AY988440.1| 7159 g918 i0 99.841 100.267090620032 629 1 100 0 1 629 1151 523 Aedes aegypti small subunit ribosomal RNA gene, partial sequence blastn 63068 1157 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
8562777 8562777 PRJNA931595_P_NODE_7747_length_292_cov_4.050228_g7638_i0 PRJNA931595 7747 292 4.050228 11.82666576 Rhopalosiphum padi 40932 Arthropoda Arthropoda 523 4.769999999999998e-144   NTclustered gi|28629120|gb|AF487719.1| 40932 g7638 i0 98.973 34.7671232876712 292 3 100 0 1 292 252 543 Rhopalosiphum padi 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 10152 523 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
9837489 9837489 PRJNA931595_P_NODE_10748_length_265_cov_4.468750_g10639_i0 PRJNA931595 10748 265 4.46875 11.8421875 Aedes aegypti 7159 Arthropoda Arthropoda 490 4.3299999999999986e-134   NTclustered gi|89146769|gb|DQ397917.1| 7159 g10639 i0 100 99.8943396226415 265 0 100 0 1 265 520 256 Aedes aegypti isolate A20 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 26472 490 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
10183652 10183652 PRJNA931595_P_NODE_1828_length_506_cov_1.085450_g1721_i0 PRJNA931595 1828 506 1.08545 5.492377 Opisthokonta 33154 Arthropoda Arthropoda 99 6.27e-16   NTclustered gi|17979676|gb|AF291874.1| 6943 g1721 i0 82.5 23.6482213438735 120 14 23 6 344 461 7049 7163 Amblyomma americanum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 11966 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma americanum
13663164 13663164 PRJNA931595_P_NODE_11671_length_257_cov_0.836957_g11562_i0 PRJNA931595 11671 257 0.836957 2.15097949 Leptopilina boulardi 63433 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2322505542|ref|XM_051305263.1| 63433 g11562 i0 100 0.116731517509728 30 0 12 0 77 106 563 534 PREDICTED: Leptopilina boulardi uncharacterized LOC127281538 (LOC127281538), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Leptopilina Leptopilina boulardi
13663395 13663395 PRJNA931595_P_NODE_5891_length_328_cov_1.141176_g5782_i0 PRJNA931595 5891 328 1.141176 3.74305728 Metopolophium dirhodum 44670 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2621244807|ref|XM_061014939.1| 44670 g5782 i0 100 0.170731707317073 28 0 9 0 150 177 181 208 PREDICTED: Metopolophium dirhodum zinc transporter ZIP9-B (LOC132945249), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
16212587 16212587 PRJNA931595_P_NODE_15033_length_242_cov_3.822485_g14924_i0 PRJNA931595 15033 242 3.822485 9.2504137 Aedes aegypti 7159 Arthropoda Arthropoda 309 1.17e-79   NTclustered gi|2190344277|gb|OM542339.1| 7159 g14924 i0 99.412 11.2603305785124 170 1 89 0 47 216 2323 2492 Aedes aegypti isolate 28S_1_Ae_aegypti_CF_S24 large subunit ribosomal RNA gene, partial sequence blastn 2725 309 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
20036460 20036460 PRJNA931595_P_NODE_7296_length_300_cov_2.466960_g7187_i0 PRJNA931595 7296 300 2.46696 7.40088 Aedes aegypti 7159 Arthropoda Arthropoda 555 1.7399999999999995e-153   NTclustered gi|2591972313|gb|OR544945.1| 7159 g7187 i0 100 100.25 300 0 100 0 1 300 14703 15002 Aedes aegypti mitochondrion, complete genome blastn 30075 555 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
21311643 21311643 PRJNA931595_P_NODE_12577_length_250_cov_1.118644_g12468_i0 PRJNA931595 12577 250 1.118644 2.79661 Aedes aegypti 7159 Arthropoda Arthropoda 405 1.51e-108   NTclustered gi|2591972313|gb|OR544945.1| 7159 g12468 i0 100 87.668 219 0 88 0 1 219 15038 15256 Aedes aegypti mitochondrion, complete genome blastn 21917 405 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
21311714 21311714 PRJNA931595_P_NODE_15117_length_242_cov_1.449704_g15008_i0 PRJNA931595 15117 242 1.449704 3.50828368 Rhagoletis zephyria 28612 Arthropoda Arthropoda 191 4.43e-44   NTclustered gi|1048021599|ref|XM_017615826.1| 28612 g15008 i0 86.982 0.698347107438017 169 22 70 0 1 169 8597 8429 PREDICTED: Rhagoletis zephyria E3 ubiquitin-protein ligase HUWE1-like (LOC108362719), mRNA blastn 169 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
22586622 22586622 PRJNA931595_P_NODE_15478_length_241_cov_0.916667_g15369_i0 PRJNA931595 15478 241 0.916667 2.20916747 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1965353566|emb|OE839203.1| 629358 g15369 i0 100 0.116182572614108 28 0 12 0 9 36 128621 128594 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
23861864 23861864 PRJNA931595_P_NODE_11659_length_257_cov_1.255435_g11550_i0 PRJNA931595 11659 257 1.255435 3.22646795 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 252 2.15e-62   NTclustered gi|1535910468|ref|XM_027341248.1| 6956 g11550 i0 85.317 0.980544747081712 252 28 97 4 1 249 597 352 PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113791467 (LOC113791467), mRNA blastn 252 252 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
23862183 23862183 PRJNA931595_P_NODE_8199_length_288_cov_1.432558_g8090_i0 PRJNA931595 8199 288 1.432558 4.12576704 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 483 7.969999999999997e-132   NTclustered gi|1535916433|ref|XM_027344536.1| 6956 g8090 i0 96.875 1 288 9 100 0 1 288 136 423 PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113794414 (LOC113794414), mRNA blastn 288 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
27246173 27246173 PRJNA931595_P_NODE_9263_length_279_cov_1.475728_g9154_i0 PRJNA931595 9263 279 1.475728 4.11728112 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 120 3.72e-29   NR RWS00845.1 1965070 g9154 i0 70.7 0.989247311827957 92 27 98.9 0 277 2 583 674 RWS00845.1 pre-mRNA cleavage complex 2 protein Pcf11-like isoform X1 [Dinothrombium tinctorium] diamond 276 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
27530504 27530504 PRJNA931595_P_NODE_9023_length_281_cov_1.480769_g8914_i0 PRJNA931595 9023 281 1.480769 4.16096089 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 122 4.5000000000000004e-30   NR KAH9400523.1 59818 g8914 i0 85.1 0.790035587188612 74 9 76.9 1 1 216 1892 1965 KAH9400523.1 AAA ATPase midasin [Tyrophagus putrescentiae] diamond 222 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28288113 28288113 PRJNA931595_P_NODE_13826_length_246_cov_1.335260_g13717_i0 PRJNA931595 13826 246 1.33526 3.2847396 Rhagoletis zephyria 28612 Arthropoda Arthropoda 83.2 2.33e-16   NR XP_017489429.1 28612 g13717 i0 100 0.48780487804878 40 0 48.8 0 120 1 39 78 XP_017489429.1 PREDICTED: nuclear pore complex protein Nup155-like [Rhagoletis zephyria] diamond 120 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
28509344 28509344 PRJNA931595_P_NODE_5187_length_345_cov_1.088235_g5078_i0 PRJNA931595 5187 345 1.088235 3.75441075 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 87 9.38e-20   NR KAH9416493.1 6956 g5078 i0 84 0.434782608695652 50 8 43.5 0 100 249 31 80 KAH9416493.1 hypothetical protein DERP_014542 [Dermatophagoides pteronyssinus] diamond 150 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29614063 29614063 PRJNA931595_P_NODE_3510_length_400_cov_1.287462_g3402_i0 PRJNA931595 3510 400 1.287462 5.149848 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 229 1.81e-67   NR KAH9412944.1 6956 g3402 i0 94.6 0.9675 129 7 96.8 0 2 388 566 694 KAH9412944.1 hypothetical protein DERP_013254 [Dermatophagoides pteronyssinus] diamond 387 229 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29867045 29867045 PRJNA931595_P_NODE_10531_length_268_cov_1.153846_g10422_i0 PRJNA931595 10531 268 1.153846 3.09230728 Oppiella nova 334625 Arthropoda Arthropoda 73.2 8.69e-13   NR CAD7660316.1 334625 g10422 i0 50.7 2.42910447761194 73 16 81.7 1 257 39 11 63 CAD7660316.1 unnamed protein product, partial [Oppiella nova] diamond 651 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
30719962 30719962 PRJNA931595_P_NODE_13014_length_249_cov_0.875000_g12905_i0 PRJNA931595 13014 249 0.875 2.17875 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 131 5.349999999999999e-37   NR KAH9426076.1 6956 g12905 i0 97 0.807228915662651 67 2 80.7 0 35 235 1 67 KAH9426076.1 hypothetical protein DERP_007016 [Dermatophagoides pteronyssinus] diamond 201 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
32364609 32364609 PRJNA931595_P_NODE_7699_length_293_cov_2.813636_g7590_i0 PRJNA931595 7699 293 2.813636 8.24395348 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 203 1.19e-61   NR KAH9402498.1 59818 g7590 i0 94.9 1.00341296928328 98 4 99.3 1 3 293 44 141 KAH9402498.1 Yip1 member 6 [Tyrophagus putrescentiae] diamond 294 203 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32396192 32396192 PRJNA931595_P_NODE_6279_length_319_cov_1.646341_g6170_i0 PRJNA931595 6279 319 1.646341 5.25182779 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 129 7.22e-36   NR KAH9412943.1 6956 g6170 i0 88.6 0.658307210031348 70 8 65.8 0 228 19 86 155 KAH9412943.1 hypothetical protein DERP_013253 [Dermatophagoides pteronyssinus] diamond 210 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
32522956 32522956 PRJNA931595_P_NODE_7519_length_296_cov_3.242152_g7410_i0 PRJNA931595 7519 296 3.242152 9.59676992 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 46.6 0.00296   NR KAH9410077.1 59818 g7410 i0 54.8 0.425675675675676 42 19 42.6 0 168 293 49 90 KAH9410077.1 Mucolipin-2 [Tyrophagus putrescentiae] diamond 126 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32743407 32743407 PRJNA931595_P_NODE_11840_length_255_cov_1.395604_g11731_i0 PRJNA931595 11840 255 1.395604 3.5587902 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 86.3 2.01e-17   NR KAH9394917.1 59818 g11731 i0 75 0.988235294117647 84 15 91.8 2 20 253 29 112 KAH9394917.1 hypothetical protein TYRP_004980 [Tyrophagus putrescentiae] diamond 252 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae

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