RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA713989" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA713989 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
703467 703467 PRJNA713989_S_NODE_401_length_709_cov_5.971212_g350_i0 PRJNA713989 401 709 5.971212 42.33589308 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 0.002   NTclustered gi|1048003915|ref|XM_017627148.1| 28612 g350 i0 100 0.0437235543018336 31 0 4 0 624 654 708 738 PREDICTED: Rhagoletis zephyria uncharacterized LOC108371558 (LOC108371558), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
4531700 4531700 PRJNA713989_S_NODE_10704_length_174_cov_1.360000_g10644_i0 PRJNA713989 10704 174 1.36 2.3664 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1963348689|emb|OE839515.1| 629358 g10644 i0 90.698 0.568965517241379 43 1 23 2 130 169 93570 93528 5_Tge_b3v08 blastn 99 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
4531811 4531811 PRJNA713989_S_NODE_2184_length_334_cov_2.512281_g2124_i0 PRJNA713989 2184 334 2.512281 8.39101854 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g2124 i0 100 4.14071856287425 30 0 9 0 71 100 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
5807078 5807078 PRJNA713989_S_NODE_1745_length_372_cov_3.346749_g1685_i0 PRJNA713989 1745 372 3.346749 12.44990628 Timema monikensis 170555 Arthropoda Arthropoda 58.4 7.6e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g1685 i0 97.059 0.241935483870968 34 1 9 0 309 342 168543 168510 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
6295261 6295261 PRJNA713989_S_NODE_11885_length_167_cov_0.864407_g11825_i0 PRJNA713989 11885 167 0.864407 1.44355969 Araneae 6893 Arthropoda Arthropoda 132 1.7500000000000002e-26   NTclustered gi|197210434|gb|EU979523.1| 29017 g11825 i0 90.816 31.8023952095808 98 9 59 0 1 98 793 696 Ornithoctonus huwena clone HWEco8 28S ribosomal RNA-like mRNA, partial sequence blastn 5311 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theraphosidae Cyriopagopus Cyriopagopus schmidti
7082074 7082074 PRJNA713989_S_NODE_13346_length_163_cov_0.894737_g13286_i0 PRJNA713989 13346 163 0.894737 1.45842131 Myzus persicae 13164 Arthropoda Arthropoda 180 5.97e-41   NTclustered gi|1229886450|ref|XM_022307787.1| 13164 g13286 i0 86.503 1 163 22 100 0 1 163 1144 1306 PREDICTED: Myzus persicae uncharacterized LOC111028982 (LOC111028982), partial mRNA blastn 163 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
8356699 8356699 PRJNA713989_S_NODE_11767_length_167_cov_1.296610_g11707_i0 PRJNA713989 11767 167 1.29661 2.1653387 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2919559730|emb|OZ238369.1| 204503 g11707 i0 96.774 0.18562874251497 31 1 19 0 65 95 13587230 13587260 Charissa obscurata genome assembly, chromosome: 3 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
13457230 13457230 PRJNA713989_S_NODE_5231_length_231_cov_1.120879_g5171_i0 PRJNA713989 5231 231 1.120879 2.58923049 Teleiodes vulgella 1594352 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2918369956|emb|OZ237936.1| 1594352 g5171 i0 100 0.121212121212121 28 0 12 0 141 168 10018177 10018150 Teleiodes vulgella genome assembly, chromosome: 17 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
19830481 19830481 PRJNA713989_S_NODE_5516_length_226_cov_0.926554_g5456_i0 PRJNA713989 5516 226 0.926554 2.09401204 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g5456 i0 100 0.123893805309735 28 0 12 0 143 170 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
19830535 19830535 PRJNA713989_S_NODE_756_length_533_cov_17.477273_g696_i0 PRJNA713989 756 533 17.477273 93.15386509 Oppiella nova 334625 Arthropoda Arthropoda 54.7 0.015   NTclustered gi|1962580772|emb|OC914909.1| 334625 g696 i0 100 0.0544090056285178 29 0 5 0 427 455 7612 7584 Oppiella nova blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
24930034 24930034 PRJNA713989_S_NODE_3900_length_260_cov_3.952607_g3840_i0 PRJNA713989 3900 260 3.952607 10.2767782 Agapeta hamana 1100904 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2918369793|emb|OZ237860.1| 1100904 g3840 i0 100 0.230769230769231 30 0 12 0 102 131 9630668 9630697 Agapeta hamana genome assembly, chromosome: 1 blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana

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