RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA645397" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA645397 · 13 ✖
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
2434342 2434342 PRJNA645397_S_NODE_162_length_358_cov_2.074434_g160_i0 PRJNA645397 162 358 2.074434 7.42647372 Drosophila 7215 Arthropoda Arthropoda 58.4 7.29e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g160 i0 100 1.5055865921787699 31 0 9 0 41 71 77 107 PREDICTED: Drosophila nasuta potassium voltage-gated channel protein Shaker (LOC132796862), transcript variant X2, mRNA blastn 539 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
4447323 4447323 PRJNA645397_P_NODE_10124_length_165_cov_1.344828_g10051_i0 PRJNA645397 10124 165 1.344828 2.2189662 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918376580|emb|OZ238010.1| 307131 g10051 i0 96.875 1.9030303030303 32 1 19 0 47 78 7913943 7913974 Ceutorhynchus obstrictus genome assembly, chromosome: 1 blastn 314 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
6998190 6998190 PRJNA645397_P_NODE_3706_length_280_cov_0.943723_g3633_i0 PRJNA645397 3706 280 0.943723 2.6424244 Aphis glycines 307491 Arthropoda Arthropoda 501 2.13e-137   NTclustered gi|402170154|gb|JQ259057.1| 307491 g3633 i0 98.929 99.0714285714286 280 3 100 0 1 280 1707 1428 Aphis glycines 28S ribosomal RNA gene, partial sequence blastn 27740 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines
10087680 10087680 PRJNA645397_P_NODE_7968_length_183_cov_0.970149_g7895_i0 PRJNA645397 7968 183 0.970149 1.77537267 Insecta 50557 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1962695364|emb|OE197254.1| 61474 g7895 i0 100 2.26775956284153 29 0 16 0 88 116 211 183 2_Tcm_b3v08 blastn 415 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
11362583 11362583 PRJNA645397_S_NODE_949_length_191_cov_1.774648_g947_i0 PRJNA645397 949 191 1.774648 3.38957768 root 1 Root_unresolved Root_unresolved 52.8 0.016   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g947 i0 100 0.586387434554974 28 0 15 0 59 86 126 99 PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
15922458 15922458 PRJNA645397_P_NODE_8673_length_174_cov_1.432000_g8600_i0 PRJNA645397 8673 174 1.432 2.49168 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918386103|emb|OZ238124.1| 876074 g8600 i0 96.97 1.95977011494253 33 1 19 0 64 96 27495834 27495866 Satyrium ilicis genome assembly, chromosome: 15 blastn 341 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
26860132 26860132 PRJNA645397_P_NODE_6121_length_210_cov_1.254658_g6048_i0 PRJNA645397 6121 210 1.254658 2.6347818 Araneus ventricosus 182803 Arthropoda Arthropoda 45.1 0.0037200000000000002   NR GBN61280.1 182803 g6048 i0 55 4.77142857142857 40 18 57.1 0 3 122 1149 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1002 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
26872432 26872432 PRJNA645397_P_NODE_9461_length_168_cov_0.873950_g9388_i0 PRJNA645397 9461 168 0.87395 1.468236 Hemiptera 7524 Arthropoda Arthropoda 67.8 2.03e-11   NR XP_050426277.1 133065 g9388 i0 78.4 3.33928571428571 37 8 66.1 0 168 58 528 564 XP_050426277.1 spondin-1-like [Adelges cooleyi] diamond 561 68.2 0.994134897360704 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Adelgidae Adelges Adelges cooleyi
29480950 29480950 PRJNA645397_P_NODE_430_length_659_cov_4.247541_g388_i0 PRJNA645397 430 659 4.247541 27.99129519 Cinara cedri 506608 Arthropoda Arthropoda 207 2.05e-60   NR VVC46497.1 506608 g388 i0 84.9 1.08801213960546 119 18 54.2 0 512 156 349 467 VVC46497.1 Reverse transcriptase domain, partial [Cinara cedri] diamond 717 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
29860111 29860111 PRJNA645397_P_NODE_1771_length_393_cov_1.616279_g1702_i0 PRJNA645397 1771 393 1.616279 6.35197647 Diuraphis noxia 143948 Arthropoda Arthropoda 95.9 5.32e-20   NR XP_015363153.1 143948 g1702 i0 71.4 0.854961832061069 56 16 42.7 0 390 223 463 518 XP_015363153.1 PREDICTED: uncharacterized protein LOC107161309 isoform X2 [Diuraphis noxia] diamond 336 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
30681388 30681388 PRJNA645397_P_NODE_4593_length_247_cov_1.540404_g4520_i0 PRJNA645397 4593 247 1.540404 3.80479788 Diuraphis noxia 143948 Arthropoda Arthropoda 75.5 1.13e-13   NR XP_015363153.1 143948 g4520 i0 75 1.60323886639676 44 11 53.4 0 134 3 410 453 XP_015363153.1 PREDICTED: uncharacterized protein LOC107161309 isoform X2 [Diuraphis noxia] diamond 396 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
30902833 30902833 PRJNA645397_P_NODE_774_length_541_cov_3.447154_g721_i0 PRJNA645397 774 541 3.447154 18.64910314 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 78.6 3.05e-13   NR XP_050529254.1 58002 g721 i0 92.1 0.421441774491682 38 3 21.1 0 38 151 1387 1424 XP_050529254.1 CD109 antigen-like isoform X1 [Daktulosphaira vitifoliae] diamond 228 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
31914601 31914601 PRJNA645397_P_NODE_4317_length_256_cov_1.753623_g4244_i0 PRJNA645397 4317 256 1.753623 4.48927488 Onthophagus taurus 166361 Arthropoda Arthropoda 68.2 4.03e-11   NR XP_071050722.1 166361 g4244 i0 73.3 0.52734375 45 12 52.7 0 226 92 70 114 XP_071050722.1 uncharacterized protein [Onthophagus taurus] diamond 135 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Onthophagus Onthophagus taurus

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