RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA290839", 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 · 13 ✖

tax_kingdom 1

  • Metazoa · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA290839 · 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
6750611 6750611 PRJNA290839_P_NODE_766_length_292_cov_1.036530_g745_i0 PRJNA290839 766 292 1.03653 3.0266676 Drosophila busckii 30019 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1829323352|ref|XM_017991740.2| 30019 g745 i0 96.97 0.339041095890411 33 0 11 1 165 197 321 352 PREDICTED: Drosophila busckii shootin-1 (LOC108603182), transcript variant X1, mRNA blastn 99 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
8712178 8712178 PRJNA290839_P_NODE_1067_length_252_cov_0.865922_g1046_i0 PRJNA290839 1067 252 0.865922 2.18212344 Aphidius gifuensis 684658 Arthropoda Arthropoda 104 6.47e-24   NR XP_044001066.1 684658 g1046 i0 50.6 2.96428571428571 83 40 98.8 1 251 3 470 551 XP_044001066.1 valine--tRNA ligase isoform X2 [Aphidius gifuensis] diamond 747 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
9987627 9987627 PRJNA290839_P_NODE_1188_length_250_cov_0.870056_g1167_i0 PRJNA290839 1188 250 0.870056 2.17514 Diptera 7147 Arthropoda Arthropoda 460 3.17e-125   NTclustered gi|422898859|gb|JQ613602.1| 335710 g1167 i0 100 99.6 249 0 99 0 2 250 1020 772 Bradysia difformis voucher 122 18S ribosomal RNA gene, partial sequence blastn 24900 460 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia impatiens
15675632 15675632 PRJNA290839_P_NODE_1653_length_242_cov_0.899408_g1632_i0 PRJNA290839 1653 242 0.899408 2.17656736 Phenacoccus solenopsis 483260 Arthropoda Arthropoda 161 3.47e-35   NTclustered gi|675275138|gb|KJ909511.1| 483260 g1632 i0 81.407 42.5247933884297 199 35 82 2 1 198 498 301 Phenacoccus solenopsis putative tubulin beta-1 chain mRNA, partial cds blastn 10291 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Phenacoccus Phenacoccus solenopsis
16950292 16950292 PRJNA290839_P_NODE_1554_length_243_cov_0.917647_g1533_i0 PRJNA290839 1554 243 0.917647 2.22988221 Vespula pensylvanica 30213 Arthropoda Arthropoda 191 4.45e-44   NTclustered gi|2098661466|ref|XM_043811691.1| 30213 g1533 i0 83.744 97.1481481481482 203 31 83 2 42 243 339 138 PREDICTED: Vespula pensylvanica ubiquitin-40S ribosomal protein S27a (LOC122628880), mRNA blastn 23607 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula pensylvanica
16950300 16950300 PRJNA290839_P_NODE_654_length_317_cov_1.036885_g633_i0 PRJNA290839 654 317 1.036885 3.28692545 Papilio polytes 76194 Arthropoda Arthropoda 431 3.26e-116   NTclustered gi|389615034|dbj|AK405121.1| 76194 g633 i0 99.574 0.741324921135647 235 1 74 0 1 235 235 1 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 235 431 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
22049325 22049325 PRJNA290839_P_NODE_1138_length_251_cov_0.865169_g1117_i0 PRJNA290839 1138 251 0.865169 2.17157419 Chrysoperla carnea 189513 Arthropoda Arthropoda 254 5.81e-63   NTclustered gi|2125146824|ref|XM_044885461.1| 189513 g1117 i0 87.615 84.7171314741036 218 27 87 0 19 236 568 785 PREDICTED: Chrysoperla carnea ATP synthase subunit beta, mitochondrial (LOC123302507), mRNA blastn 21264 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
24599004 24599004 PRJNA290839_P_NODE_1480_length_245_cov_0.901163_g1459_i0 PRJNA290839 1480 245 0.901163 2.20784935 Queda youngi 1458196 Arthropoda Arthropoda 128 3.57e-25   NTclustered gi|751960357|gb|KJ548853.1| 1458196 g1459 i0 92.308 30.0897959183673 91 6 37 1 11 101 502 413 Queda youngi voucher UNM KBMQuyo455 RNA polymerase II (RNA Pol II) gene, partial cds blastn 7372 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Queda Queda youngi
27295444 27295444 PRJNA290839_P_NODE_623_length_325_cov_0.916667_g602_i0 PRJNA290839 623 325 0.916667 2.97916775 Dermacentor silvarum 543639 Arthropoda Arthropoda 53.9 5.08e-6   NR XP_049524155.1 543639 g602 i0 56.1 3.15692307692308 57 25 52.6 0 224 54 105 161 XP_049524155.1 60S ribosomal protein L10-like [Dermacentor silvarum] diamond 1026 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
28228538 28228538 PRJNA290839_P_NODE_906_length_268_cov_1.589744_g885_i0 PRJNA290839 906 268 1.589744 4.26051392 Malacostraca 6681 Arthropoda Arthropoda 122 1.8e-32   NR CAL4234900.1 48144 g885 i0 60.7 5.00373134328358 89 35 99.6 0 2 268 6 94 CAL4234900.1 unnamed protein product [Meganyctiphanes norvegica] diamond 1341 123 0.991869918699187 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
29221739 29221739 PRJNA290839_P_NODE_1409_length_246_cov_0.895954_g1388_i0 PRJNA290839 1409 246 0.895954 2.20404684 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 88.2 3.06e-20   NR KAG5671785.1 319348 g1388 i0 56.8 2.04878048780488 81 35 98.8 0 243 1 12 92 KAG5671785.1 hypothetical protein PVAND_001961 [Polypedilum vanderplanki] diamond 504 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
30484982 30484982 PRJNA290839_P_NODE_633_length_321_cov_1.572581_g612_i0 PRJNA290839 633 321 1.572581 5.04798501 Argiope bruennichi 94029 Arthropoda Arthropoda 135 2.61e-38   NR XP_055944831.1 94029 g612 i0 63.2 1.98130841121495 106 39 99.1 0 319 2 1 106 XP_055944831.1 60S ribosomal protein L24-like [Argiope bruennichi] diamond 636 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
32603444 32603444 PRJNA290839_P_NODE_860_length_277_cov_1.509804_g839_i0 PRJNA290839 860 277 1.509804 4.18215708 Culicoides brevitarsis 469753 Arthropoda Arthropoda 88.6 4.4e-18   NR XP_063698977.1 469753 g839 i0 52.5 0.866425992779783 80 38 86.6 0 2 241 181 260 XP_063698977.1 phosphatidylinositol 3,4,5-trisphosphate 3-phosphatase cnrN [Culicoides brevitarsis] diamond 240 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis

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