RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA807836" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA807836 · 21 ✖
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
2082676 2082676 PRJNA807836_S_NODE_15122_length_362_cov_0.927336_g14846_i0 PRJNA807836 15122 362 0.927336 3.35695632 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 52.8 0.034   NTclustered gi|2304403542|ref|XM_050682190.1| 58002 g14846 i0 100 0.386740331491713 28 0 8 0 63 90 956 983 PREDICTED: Daktulosphaira vitifoliae RNA polymerase II subunit 5-mediating protein homolog (LOC126903736), transcript variant X6, mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
3358030 3358030 PRJNA807836_S_NODE_24343_length_271_cov_1.358586_g24067_i0 PRJNA807836 24343 271 1.358586 3.68176806 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919533883|emb|OZ238345.1| 1002887 g24067 i0 100 0.11070110701107 30 0 11 0 71 100 23309573 23309544 Glaucopsyche melanops genome assembly, chromosome: 4 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
4635895 4635895 PRJNA807836_S_NODE_8704_length_525_cov_1.274336_g8433_i0 PRJNA807836 8704 525 1.274336 6.690264 Phymastichus coffea 108790 Arthropoda Arthropoda 73.1 3.95e-8   NTclustered gi|2563746398|ref|XM_058952633.1| 108790 g8433 i0 95.556 1.42095238095238 45 2 9 0 1 45 2199 2243 PREDICTED: Phymastichus coffea ribosomal L1 domain-containing protein CG13096-like (LOC131674117), mRNA blastn 746 73.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea
7185563 7185563 PRJNA807836_S_NODE_4126_length_843_cov_1.980519_g3915_i0 PRJNA807836 4126 843 1.980519 16.69577517 Drosophila ananassae 7217 Arthropoda Arthropoda 91.6 1.8e-13   NTclustered gi|2119975529|ref|XM_001962190.4| 7217 g3915 i0 92.308 0.231316725978648 65 4 8 1 1 64 208 272 PREDICTED: Drosophila ananassae BUB3-interacting and GLEBS motif-containing protein ZNF207 (LOC6498170), mRNA blastn 195 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae
7185696 7185696 PRJNA807836_S_NODE_7886_length_562_cov_3.271984_g7620_i0 PRJNA807836 7886 562 3.271984 18.38855008 Stomoxys calcitrans 35570 Arthropoda Arthropoda 54.7 0.015   NTclustered gi|2573092842|ref|XM_013253665.2| 35570 g7620 i0 100 0.0516014234875445 29 0 5 0 152 180 1406 1434 PREDICTED: Stomoxys calcitrans spidroin-1 (LOC106088245), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
11011160 11011160 PRJNA807836_S_NODE_30849_length_241_cov_3.125000_g30573_i0 PRJNA807836 30849 241 3.125 7.53125 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2920024240|emb|OZ239122.1| 3086104 g30573 i0 96.875 0.132780082987552 32 0 13 1 130 161 20862555 20862585 Leiobunum subalpinum genome assembly, chromosome: 5 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
12286654 12286654 PRJNA807836_S_NODE_31250_length_240_cov_2.532934_g30974_i0 PRJNA807836 31250 240 2.532934 6.0790416 Platynothrus peltifer 128015 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2579718320|gb|CP133309.1| 128015 g30974 i0 100 0.116666666666667 28 0 12 0 122 149 5449389 5449416 Platynothrus peltifer isolate 155_3 chromosome 4 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
12702502 12702502 PRJNA807836_S_NODE_28430_length_248_cov_0.880000_g28154_i0 PRJNA807836 28430 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 459 1.13e-124   NTclustered gi|21428419|gb|AY118501.1| 7227 g28154 i0 100 90.5120967741936 248 0 100 0 1 248 818 571 Drosophila melanogaster LD09691 full insert cDNA blastn 22447 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
13560832 13560832 PRJNA807836_S_NODE_26211_length_258_cov_1.232432_g25935_i0 PRJNA807836 26211 258 1.232432 3.17967456 Drosophila pseudoobscura 7237 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1698636|gb|U63856.1|DPU63856 7237 g25935 i0 100 0.108527131782946 28 0 11 0 167 194 2837 2810 Drosophila pseudoobscura decapentaplegic protein (dpp) gene, complete cds, shortvein and haploinsufficient region blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila pseudoobscura
17385420 17385420 PRJNA807836_S_NODE_23574_length_277_cov_1.127451_g23298_i0 PRJNA807836 23574 277 1.127451 3.12303927 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g23298 i0 100 4.9927797833935 30 0 11 0 133 162 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
19933615 19933615 PRJNA807836_S_NODE_15936_length_349_cov_2.155797_g15660_i0 PRJNA807836 15936 349 2.155797 7.52373153 Drosophila navojoa 7232 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1723816879|ref|XM_030386309.1| 7232 g15660 i0 94.444 0.263610315186246 36 1 10 1 120 155 6444 6410 PREDICTED: Drosophila navojoa uncharacterized LOC108655696 (LOC108655696), mRNA blastn 92 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila navojoa
21209472 21209472 PRJNA807836_S_NODE_29117_length_246_cov_0.890173_g28841_i0 PRJNA807836 29117 246 0.890173 2.18982558 Chelonus insularis 460826 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1860484182|ref|XM_035083650.1| 460826 g28841 i0 96.774 0.252032520325203 31 1 13 0 105 135 726 696 PREDICTED: Chelonus insularis monocarboxylate transporter 10-like protein kar (kar), transcript variant X2, mRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
21209595 21209595 PRJNA807836_S_NODE_5517_length_709_cov_3.891509_g5269_i0 PRJNA807836 5517 709 3.891509 27.59079881 Timema cristinae 61476 Arthropoda Arthropoda 54.7 0.02   NTclustered gi|1947530273|emb|OC333851.1| 61476 g5269 i0 100 0.0409026798307475 29 0 4 0 348 376 3293 3265 3_Tce_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
21624951 21624951 PRJNA807836_S_NODE_14517_length_371_cov_1.889262_g14241_i0 PRJNA807836 14517 371 1.889262 7.00916202 Opisthokonta 33154 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|2837545071|ref|XM_069305474.1| 6728 g14241 i0 100 4.27493261455526 30 0 8 0 39 68 923 894 PREDICTED: Procambarus clarkii optomotor-blind protein (LOC123750108), transcript variant X3, mRNA blastn 1586 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
22900487 22900487 PRJNA807836_S_NODE_10478_length_462_cov_9.928021_g10202_i0 PRJNA807836 10478 462 9.928021 45.86745702 Insecta 50557 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|1060216358|ref|XM_018004263.1| 7263 g10202 i0 100 0.125541125541126 29 0 6 0 325 353 465 437 PREDICTED: Drosophila arizonae hyphally regulated cell wall protein 3 (LOC108611556), mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila arizonae
23759788 23759788 PRJNA807836_S_NODE_27599_length_250_cov_1.299435_g27323_i0 PRJNA807836 27599 250 1.299435 3.2485875 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918369771|emb|OZ237838.1| 1007376 g27323 i0 94.444 0.144 36 1 14 1 201 235 349698 349733 Pseudoterpna coronillaria genome assembly, chromosome: 13 blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
25033393 25033393 PRJNA807836_S_NODE_14920_length_365_cov_1.393836_g14644_i0 PRJNA807836 14920 365 1.393836 5.0875014 Ischnura elegans 197161 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2189724929|ref|XM_046537681.1| 197161 g14644 i0 100 0.0767123287671233 28 0 8 0 95 122 1458 1485 PREDICTED: Ischnura elegans uncharacterized PE-PGRS family protein PE_PGRS54-like (LOC124161366), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Coenagrionidae Ischnura Ischnura elegans
27875377 27875377 PRJNA807836_S_NODE_1745_length_1273_cov_4.110000_g1628_i0 PRJNA807836 1745 1273 4.11 52.3203 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 88.2 8.78e-15   NR XP_071033602.1 114398 g1628 i0 31.1 0.431264728986646 183 113 42.9 4 53 598 253 423 XP_071033602.1 DBIRD complex subunit ZNF326 isoform X2 [Parasteatoda tepidariorum] diamond 549 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
28601779 28601779 PRJNA807836_S_NODE_20787_length_299_cov_0.929204_g20511_i0 PRJNA807836 20787 299 0.929204 2.77831996 Araneus ventricosus 182803 Arthropoda Arthropoda 44.7 0.0156   NR GBN22170.1 182803 g20511 i0 31.1 0.74247491638796 74 48 71.2 1 247 35 1087 1160 GBN22170.1 putative RNA-directed DNA polymerase from transposon X-element, partial [Araneus ventricosus] diamond 222 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30180501 30180501 PRJNA807836_S_NODE_30372_length_243_cov_0.905882_g30096_i0 PRJNA807836 30372 243 0.905882 2.20129326 Gonioctena quinquepunctata 63699 Arthropoda Arthropoda 42.4 0.0441   NR KAG5875460.1 63699 g30096 i0 41.9 0.530864197530864 43 25 53.1 0 241 113 39 81 KAG5875460.1 hypothetical protein JTB14_028835 [Gonioctena quinquepunctata] diamond 129 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Gonioctena Gonioctena quinquepunctata
30726491 30726491 PRJNA807836_S_NODE_29914_length_244_cov_0.900585_g29638_i0 PRJNA807836 29914 244 0.900585 2.1974274 Lepidoptera 7088 Arthropoda Arthropoda 54.7 2.32e-6   NR KAI5651973.1 192464 g29638 i0 43.6 4.46311475409836 55 31 67.6 0 165 1 5 59 KAI5651973.1 beta-eliminating lyase domain-containing protein [Phthorimaea operculella] diamond 1089 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Phthorimaea Phthorimaea operculella

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