RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1104180", tax_kingdom = "Metazoa" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA1104180 · 20 ✖
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
1020131 1020131 PRJNA1104180_P_NODE_11641_length_301_cov_1.184211_g11499_i0 PRJNA1104180 11641 301 1.184211 3.56447511 Cicadellidae 30102 Arthropoda Arthropoda 472 1.81e-128   NTclustered gi|2587644272|gb|OK209746.1| 3078486 g11499 i0 95.017 83.9435215946844 301 13 99 2 2 301 6419 6120 Arenoledra tubularis voucher GZGUW006 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 25267 472 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Arenoledra Arenoledra tubularis
4848363 4848363 PRJNA1104180_P_NODE_3004_length_511_cov_1.477169_g2863_i0 PRJNA1104180 3004 511 1.477169 7.54833359 Opisthokonta 33154 Arthropoda Arthropoda 99 6.33e-16   NTclustered gi|17979676|gb|AF291874.1| 6943 g2863 i0 82.5 23.4168297455969 120 14 23 6 36 153 7163 7049 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
6590477 6590477 PRJNA1104180_P_NODE_23326_length_246_cov_0.890173_g23183_i0 PRJNA1104180 23326 246 0.890173 2.18982558 Notodromas monacha 399045 Arthropoda Arthropoda 416 6.839999999999999e-112   NTclustered gi|1938059323|emb|OA889206.1| 399045 g23183 i0 97.166 30.1463414634146 247 6 100 1 1 246 9764 10010 Notodromas monacha blastn 7416 416 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
6590566 6590566 PRJNA1104180_P_NODE_4186_length_446_cov_5.994638_g4044_i0 PRJNA1104180 4186 446 5.994638 26.73608548 Timema monikensis 170555 Arthropoda Arthropoda 58.4 0.001   NTclustered gi|1946411097|emb|OB793204.1| 170555 g4044 i0 97.059 0.201793721973094 34 1 8 0 99 132 168510 168543 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
9948392 9948392 PRJNA1104180_P_NODE_12048_length_296_cov_3.260090_g11906_i0 PRJNA1104180 12048 296 3.26009 9.6498664 Ceratopogonidae 41819 Arthropoda Arthropoda 427 3.9099999999999996e-115   NTclustered gi|630320333|gb|KF286391.1| 1495482 g11906 i0 92.881 99.1858108108108 295 20 99 1 2 296 316 23 Forcipomyia sp. FR-forcip2-D2.24-21 28S ribosomal RNA gene, partial sequence blastn 29359 427 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Forcipomyia Forcipomyia sp. FR-forcip2-D2.24-21
9948433 9948433 PRJNA1104180_P_NODE_15988_length_272_cov_1.190955_g15846_i0 PRJNA1104180 15988 272 1.190955 3.2393976 Culicoides 41820 Arthropoda Arthropoda 224 4.9999999999999996e-54   NTclustered gi|1830685083|gb|MT335979.1| 2510300 g15846 i0 90.588 71.4191176470588 170 15 62 1 104 272 118 287 Culicoides haematopotus isolate 26 small subunit ribosomal RNA gene, partial sequence blastn 19426 226 0.991150442477876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides haematopotus
12966111 12966111 PRJNA1104180_P_NODE_14231_length_282_cov_1.129187_g14089_i0 PRJNA1104180 14231 282 1.129187 3.18430734 Oppiella nova 334625 Arthropoda Arthropoda 516 7.67e-142   NTclustered gi|1964807194|emb|OC914826.1| 334625 g14089 i0 99.645 58.1063829787234 282 1 100 0 1 282 204332 204051 Oppiella nova blastn 16386 516 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
14241272 14241272 PRJNA1104180_P_NODE_28772_length_198_cov_21.568000_g28629_i0 PRJNA1104180 28772 198 21.568 42.70464 Cymothoe herminia 1210388 Arthropoda Arthropoda 361 2.51e-95   NTclustered gi|2307882115|gb|MW186585.1| 1210388 g28629 i0 99.495 105.40404040404 198 1 100 0 1 198 6470 6273 Cymothoe herminia voucher 17LW02125 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 20870 361 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Cymothoe Cymothoe herminia
16322896 16322896 PRJNA1104180_P_NODE_7833_length_347_cov_2.135036_g7691_i0 PRJNA1104180 7833 347 2.135036 7.40857492 Opisthokonta 33154 Arthropoda Arthropoda 641 1.5299999999999996e-179   NTclustered gi|1494774795|ref|XR_003394589.1| 121845 g7691 i0 100 96.207492795389 347 0 100 0 1 347 1277 1623 PREDICTED: Diaphorina citri small subunit ribosomal RNA (LOC113472153), rRNA blastn 33384 641 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
16789544 16789544 PRJNA1104180_P_NODE_24514_length_244_cov_0.900585_g24371_i0 PRJNA1104180 24514 244 0.900585 2.1974274 Penaeus vannamei 6689 Arthropoda Arthropoda 257 4.35e-64   NTclustered gi|2864089240|ref|XR_011399394.1| 6689 g24371 i0 98.621 14.9754098360656 145 2 59 0 1 145 171 315 PREDICTED: Penaeus vannamei uncharacterized lncRNA (LOC138865475), ncRNA blastn 3654 257 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
17597930 17597930 PRJNA1104180_P_NODE_15854_length_272_cov_7.527638_g15712_i0 PRJNA1104180 15854 272 7.527638 20.47517536 Opisthokonta 33154 Arthropoda Arthropoda 501 2.06e-137   NTclustered gi|1494774796|ref|XR_003394590.1| 121845 g15712 i0 100 12.7352941176471 271 0 99 0 2 272 3326 3056 PREDICTED: Diaphorina citri large subunit ribosomal RNA (LOC113472154), rRNA blastn 3464 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
18063982 18063982 PRJNA1104180_P_NODE_16175_length_271_cov_1.282828_g16033_i0 PRJNA1104180 16175 271 1.282828 3.47646388 Oppiella nova 334625 Arthropoda Arthropoda 420 5.91e-113   NTclustered gi|1962580169|emb|OC914870.1| 334625 g16033 i0 95.113 0.981549815498155 266 13 98 0 6 271 52131 51866 Oppiella nova blastn 266 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
18064175 18064175 PRJNA1104180_P_NODE_5335_length_403_cov_3.296970_g5193_i0 PRJNA1104180 5335 403 3.29697 13.2867891 Dasyhelea sp. 1 SRM-2010 891434 Arthropoda Arthropoda 326 2.0599999999999997e-84   NTclustered gi|346682017|gb|HQ440731.1| 891434 g5193 i0 87.197 82.5037220843672 289 34 72 3 114 402 18 303 Dasyhelea sp. 1 SRM-2010 voucher CERAT 28S large subunit ribosomal RNA gene, partial sequence blastn 33249 326 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Dasyhelea Dasyhelea sp. 1 SRM-2010
20146676 20146676 PRJNA1104180_P_NODE_23136_length_246_cov_0.890173_g22993_i0 PRJNA1104180 23136 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 449 6.74e-122   NTclustered gi|1964807365|emb|OC914831.1| 334625 g22993 i0 99.593 100.040650406504 246 1 100 0 1 246 110450 110695 Oppiella nova blastn 24610 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
21422291 21422291 PRJNA1104180_P_NODE_19897_length_252_cov_1.290503_g19754_i0 PRJNA1104180 19897 252 1.290503 3.25206756 Aphididae 27482 Arthropoda Arthropoda 460 3.2e-125   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g19754 i0 99.603 98.6904761904762 252 1 100 0 1 252 1985 2236 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 24870 460 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
23164773 23164773 PRJNA1104180_P_NODE_6099_length_383_cov_3.170968_g5957_i0 PRJNA1104180 6099 383 3.170968 12.14480744 Forcipomyia pluvialis 560757 Arthropoda Arthropoda 580 3.7699999999999985e-161   NTclustered gi|202070920|gb|FJ040559.1| 560757 g5957 i0 94.026 85.6527415143603 385 19 100 3 1 383 1784 2166 Forcipomyia pluvialis 28S ribosomal RNA gene, partial sequence blastn 32805 580 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Forcipomyia Forcipomyia pluvialis
27225553 27225553 PRJNA1104180_P_NODE_12903_length_290_cov_0.894009_g12761_i0 PRJNA1104180 12903 290 0.894009 2.5926261 Aedes albopictus 7160 Arthropoda Arthropoda 44.7 0.0138   NR XP_062698618.1 7160 g12761 i0 42.5 0.413793103448276 40 22 40.3 1 130 14 700 739 XP_062698618.1 uncharacterized protein LOC109412847 [Aedes albopictus] diamond 120 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
28132970 28132970 PRJNA1104180_P_NODE_13485_length_286_cov_1.460094_g13343_i0 PRJNA1104180 13485 286 1.460094 4.17586884 Aphididae 27482 Arthropoda Arthropoda 92.8 1.5700000000000001e-19   NR XP_029341341.1 7029 g13343 i0 60 2.72727272727273 75 30 78.7 0 272 48 84 158 XP_029341341.1 aminopeptidase N [Acyrthosiphon pisum] diamond 780 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
32407322 32407322 PRJNA1104180_P_NODE_20919_length_250_cov_0.870056_g20776_i0 PRJNA1104180 20919 250 0.870056 2.17514 Penaeus vannamei 6689 Arthropoda Arthropoda 76.3 1.67e-14   NR XP_069985543.1 6689 g20776 i0 66.7 1.944 54 18 64.8 0 170 9 86 139 XP_069985543.1 craniofacial development protein 2-like [Penaeus vannamei] diamond 486 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32691286 32691286 PRJNA1104180_P_NODE_18640_length_258_cov_1.248649_g18498_i0 PRJNA1104180 18640 258 1.248649 3.22151442 Mileewa gaoligongana 2545677 Arthropoda Arthropoda 44.7 0.00868   NR XII34339.1 2545677 g18498 i0 50 1.01162790697674 40 20 46.5 0 104 223 141 180 XII34339.1 NADH dehydrogenase subunit 2 [Mileewa gaoligongana] diamond 261 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Mileewa Mileewa gaoligongana

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