RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA283169 · 29 ✖

analysis 1

  • blastn · 29 ✖
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
2922439 2922439 PRJNA283169_P_NODE_5383_length_184_cov_1.422222_g5320_i0 PRJNA283169 5383 184 1.422222 2.61688848 Zophobas morio 2755281 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2705164671|ref|XM_064049691.1| 2755281 g5320 i0 100 1.40760869565217 29 0 16 0 148 176 2996 2968 PREDICTED: Zophobas morio leucine-rich repeat, immunoglobulin-like domain and transmembrane domain-containing protein 2 (LOC135124538), transcript variant X3, mRNA blastn 259 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
2922445 2922445 PRJNA283169_P_NODE_6083_length_173_cov_1.959677_g6020_i0 PRJNA283169 6083 173 1.959677 3.39024121 Euthrix potatoria 624169 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918369998|emb|OZ237885.1| 624169 g6020 i0 96.97 0.352601156069364 33 1 19 0 34 66 1465689 1465657 Euthrix potatoria genome assembly, chromosome: 13 blastn 61 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
2922475 2922475 PRJNA283169_S_NODE_2163_length_193_cov_1.416667_g2149_i0 PRJNA283169 2163 193 1.416667 2.73416731 Glossina morsitans 7394 Arthropoda Arthropoda 357 3.1499999999999996e-94   NTclustered gi|425869935|gb|KC177834.1| 7394 g2149 i0 100 100.19689119171 193 0 100 0 1 193 2220 2412 Glossina morsitans 28S ribosomal RNA gene, partial sequence blastn 19338 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
4198881 4198881 PRJNA283169_P_NODE_2924_length_243_cov_0.938144_g2861_i0 PRJNA283169 2924 243 0.938144 2.27968992 Smittia aterrima 611654 Arthropoda Arthropoda 272 1.5399999999999998e-68   NTclustered gi|339716605|gb|JF894325.1| 611654 g2861 i0 100 86.8641975308642 147 0 60 0 97 243 70 216 Smittia aterrima 28S ribosomal RNA gene, partial sequence blastn 21108 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Smittia Smittia aterrima
4198933 4198933 PRJNA283169_P_NODE_7364_length_165_cov_0.879310_g7301_i0 PRJNA283169 7364 165 0.87931 1.4508615 Glossina morsitans 7394 Arthropoda Arthropoda 305 9.59e-79   NTclustered gi|425869935|gb|KC177834.1| 7394 g7301 i0 100 99.1515151515152 165 0 100 0 1 165 3831 3667 Glossina morsitans 28S ribosomal RNA gene, partial sequence blastn 16360 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
4198948 4198948 PRJNA283169_S_NODE_264_length_483_cov_4.435484_g250_i0 PRJNA283169 264 483 4.435484 21.42338772 Oppiella nova 334625 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|1962580772|emb|OC914909.1| 334625 g250 i0 100 0.0600414078674948 29 0 6 0 77 105 7584 7612 Oppiella nova blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
6749514 6749514 PRJNA283169_S_NODE_2106_length_195_cov_1.705479_g2092_i0 PRJNA283169 2106 195 1.705479 3.32568405 Glossina morsitans 7394 Arthropoda Arthropoda 361 2.46e-95   NTclustered gi|425869679|gb|KC177312.1| 7394 g2092 i0 100 100 195 0 100 0 1 195 1795 1601 Glossina morsitans 18S ribosomal RNA gene, partial sequence blastn 19500 361 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
7436922 7436922 PRJNA283169_S_NODE_2966_length_169_cov_0.858333_g2952_i0 PRJNA283169 2966 169 0.858333 1.45058277 Diptera 7147 Arthropoda Arthropoda 302 1.27e-77   NTclustered gi|2087623279|ref|XR_006246833.1| 7222 g2952 i0 98.817 100.289940828402 169 2 100 0 1 169 1219 1051 PREDICTED: Drosophila grimshawi small subunit ribosomal RNA (LOC122322765), rRNA blastn 16949 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
8025072 8025072 PRJNA283169_P_NODE_6607_length_168_cov_0.873950_g6544_i0 PRJNA283169 6607 168 0.87395 1.468236 Zerynthia rumina 132710 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918381721|emb|OZ238055.1| 132710 g6544 i0 100 0.357142857142857 30 0 18 0 4 33 4419128 4419099 Zerynthia rumina genome assembly, chromosome: 20 blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
8025100 8025100 PRJNA283169_S_NODE_2007_length_199_cov_1.020000_g1993_i0 PRJNA283169 2007 199 1.02 2.0298 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1963350700|emb|OE839616.1| 629358 g1993 i0 100 0.14572864321608 29 0 15 0 29 57 38081 38109 5_Tge_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
9299854 9299854 PRJNA283169_P_NODE_5108_length_189_cov_1.100000_g5045_i0 PRJNA283169 5108 189 1.1 2.079 Dermacentor andersoni 34620 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|2287807960|ref|XM_050170874.1| 34620 g5045 i0 100 0.148148148148148 28 0 15 0 132 159 669 642 PREDICTED: Dermacentor andersoni protein diaphanous homolog 1-like (LOC126522090), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
9299880 9299880 PRJNA283169_P_NODE_6948_length_166_cov_1.282051_g6885_i0 PRJNA283169 6948 166 1.282051 2.12820466 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g6885 i0 90.476 0.253012048192771 42 4 25 0 1 42 56559236 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 42 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
9299895 9299895 PRJNA283169_S_NODE_1468_length_225_cov_1.982955_g1454_i0 PRJNA283169 1468 225 1.982955 4.46164875 Papilio polytes 76194 Arthropoda Arthropoda 416 6.159999999999998e-112   NTclustered gi|389615034|dbj|AK405121.1| 76194 g1454 i0 100 57.7111111111111 225 0 100 0 1 225 366 142 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 12985 416 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
10575776 10575776 PRJNA283169_S_NODE_1789_length_208_cov_2.069182_g1775_i0 PRJNA283169 1789 208 2.069182 4.30389856 Ochlerotatus camptorhynchus 644619 Arthropoda Arthropoda 165 2.24e-36   NTclustered gi|2730504192|ref|XM_065228580.1| 644619 g1775 i0 85.806 129.144230769231 155 22 75 0 50 204 684 838 PREDICTED: Ochlerotatus camptorhynchus polyubiquitin-C-like (LOC135706898), transcript variant X2, mRNA blastn 26862 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus camptorhynchus
10575779 10575779 PRJNA283169_S_NODE_489_length_359_cov_1.516129_g475_i0 PRJNA283169 489 359 1.516129 5.44290311 Glossina morsitans 7394 Arthropoda Arthropoda 647 0   NTclustered gi|425869935|gb|KC177834.1| 7394 g475 i0 99.164 100.200557103064 359 3 100 0 1 359 2744 3102 Glossina morsitans 28S ribosomal RNA gene, partial sequence blastn 35972 647 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
13125643 13125643 PRJNA283169_P_NODE_7391_length_165_cov_0.870690_g7328_i0 PRJNA283169 7391 165 0.87069 1.4366385 Bombus affinis 309941 Arthropoda Arthropoda 60.2 8.25e-5   NTclustered gi|2308388317|ref|XM_050719693.1| 309941 g7328 i0 94.737 4.23636363636364 38 2 23 0 128 165 6543 6580 PREDICTED: Bombus affinis TGF-beta receptor type-1-like (LOC126915227), transcript variant X3, mRNA blastn 699 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus affinis
14400760 14400760 PRJNA283169_P_NODE_3372_length_226_cov_1.384181_g3309_i0 PRJNA283169 3372 226 1.384181 3.12824906 Glossina morsitans 7394 Arthropoda Arthropoda 412 8.01e-111   NTclustered gi|425869679|gb|KC177312.1| 7394 g3309 i0 99.558 100.424778761062 226 1 100 0 1 226 1700 1475 Glossina morsitans 18S ribosomal RNA gene, partial sequence blastn 22696 412 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
15674533 15674533 PRJNA283169_S_NODE_2493_length_182_cov_0.037594_g2479_i0 PRJNA283169 2493 182 0.037594 0.06842108 Artemia franciscana 6661 Arthropoda Arthropoda 337 3.82e-88   NTclustered gi|2743022902|ref|XM_065726824.1| 6661 g2479 i0 100 3 182 0 100 0 1 182 505 324 PREDICTED: Artemia franciscana myosin light chain 1-like (LOC136041996), transcript variant X2, mRNA blastn 546 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
16361495 16361495 PRJNA283169_S_NODE_1773_length_209_cov_1.068750_g1759_i0 PRJNA283169 1773 209 1.06875 2.2336875 Glossina 7393 Arthropoda Arthropoda 375 9.57e-100   NTclustered gi|377648489|gb|JF439566.1| 7394 g1759 i0 99.043 100.095693779904 209 2 100 0 1 209 2023 1815 Glossina morsitans voucher WVU2011-018-1 28S ribosomal RNA gene, partial sequence blastn 20920 375 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
16361498 16361498 PRJNA283169_S_NODE_2733_length_175_cov_0.126984_g2719_i0 PRJNA283169 2733 175 0.126984 0.222222 Artemia 6660 Arthropoda Arthropoda 324 2.83e-84   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g2719 i0 100 4.37714285714286 175 0 100 0 1 175 3518 3344 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 766 324 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
17636627 17636627 PRJNA283169_P_NODE_6474_length_169_cov_0.866667_g6411_i0 PRJNA283169 6474 169 0.866667 1.46466723 Arthropoda 6656 Arthropoda Arthropoda 63.9 6.52e-6   NTclustered gi|1946278083|emb|OD565209.1| 61472 g6411 i0 97.297 10.301775147929 37 1 22 0 110 146 165793 165757 4_Tbi_b3v08 blastn 1741 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
17636628 17636628 PRJNA283169_P_NODE_7034_length_166_cov_0.888889_g6971_i0 PRJNA283169 7034 166 0.888889 1.47555574 Opisthokonta 33154 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1963352278|emb|OE839704.1| 629358 g6971 i0 100 3.75301204819277 30 0 18 0 99 128 157639 157610 5_Tge_b3v08 blastn 623 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
18910439 18910439 PRJNA283169_S_NODE_895_length_277_cov_3.048246_g881_i0 PRJNA283169 895 277 3.048246 8.44364142 Glossina 7393 Arthropoda Arthropoda 507 4.53e-139   NTclustered gi|425869679|gb|KC177312.1| 7394 g881 i0 99.639 100.115523465704 277 1 100 0 1 277 965 689 Glossina morsitans 18S ribosomal RNA gene, partial sequence blastn 27732 507 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
19497686 19497686 PRJNA283169_P_NODE_2096_length_282_cov_1.639485_g2034_i0 PRJNA283169 2096 282 1.639485 4.6233477 Megafenestra aurita 2291010 Arthropoda Arthropoda 202 2.44e-47   NTclustered gi|2488190566|emb|OC990771.1| 2291010 g2034 i0 82.96 12.5957446808511 223 38 79 0 13 235 25 247 Megafenestra aurita EOG090X0E68 gene for EOG090X0E68 blastn 3552 202 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Megafenestra Megafenestra aurita
19497768 19497768 PRJNA283169_S_NODE_1216_length_245_cov_0.173469_g1202_i0 PRJNA283169 1216 245 0.173469 0.42499905 Bombyx mori 7091 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2909956438|dbj|AP039569.1| 7091 g1202 i0 100 0.114285714285714 28 0 11 0 90 117 2586691 2586664 Bombyx mori p50ma DNA, chromosome: 22 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
19497773 19497773 PRJNA283169_S_NODE_3556_length_157_cov_6.111111_g3542_i0 PRJNA283169 3556 157 6.111111 9.59444427 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2636206755|emb|OY979781.1| 52344 g3542 i0 100 0.178343949044586 28 0 18 0 58 85 8315215 8315242 Helicoverpa assulta genome assembly, chromosome: 7 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
22048306 22048306 PRJNA283169_S_NODE_1638_length_216_cov_0.149701_g1624_i0 PRJNA283169 1638 216 0.149701 0.32335416 Onthophagus taurus 166361 Arthropoda Arthropoda 60.2 1.14e-4   NTclustered gi|2902285080|ref|XM_071194628.1| 166361 g1624 i0 100 3.61111111111111 32 0 15 0 170 201 2660 2629 PREDICTED: Onthophagus taurus uncharacterized PE-PGRS family protein PE_PGRS54-like (LOC111428779), mRNA blastn 780 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Onthophagus Onthophagus taurus
24597878 24597878 PRJNA283169_P_NODE_3420_length_224_cov_1.457143_g3357_i0 PRJNA283169 3420 224 1.457143 3.26400032 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2636206755|emb|OY979781.1| 52344 g3357 i0 100 0.125 28 0 13 0 76 103 8315242 8315215 Helicoverpa assulta genome assembly, chromosome: 7 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
24597952 24597952 PRJNA283169_S_NODE_3140_length_166_cov_0.136752_g3126_i0 PRJNA283169 3140 166 0.136752 0.22700832 Artemia franciscana 6661 Arthropoda Arthropoda 300 4.5e-77   NTclustered gi|2743067299|ref|XM_065702716.1| 6661 g3126 i0 100 2.95180722891566 162 0 98 0 5 166 487 648 PREDICTED: Artemia franciscana large ribosomal subunit protein bL19m-like (LOC136026300), mRNA blastn 490 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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