RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1233317 · 32 ✖

analysis 1

  • blastn · 32 ✖
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
335601 335601 PRJNA1233317_S_NODE_11941_length_224_cov_9.884848_g11905_i0 PRJNA1233317 11941 224 9.884848 22.14205952 Macdunnoughia confusa 254380 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2917930536|emb|OZ234942.1| 254380 g11905 i0 100 0.125 28 0 13 0 48 75 12172516 12172489 Macdunnoughia confusa genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Macdunnoughia Macdunnoughia confusa
1610299 1610299 PRJNA1233317_S_NODE_5062_length_317_cov_31.996124_g5026_i0 PRJNA1233317 5062 317 31.996124 101.42771308 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g5026 i0 96.875 0.201892744479495 32 1 10 0 122 153 24059155 24059124 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
1610336 1610336 PRJNA1233317_S_NODE_8642_length_263_cov_1.196078_g8606_i0 PRJNA1233317 8642 263 1.196078 3.14568514 Lutzomyia longipalpis 7200 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2500586479|ref|XR_008750134.1| 7200 g8606 i0 100 0.32319391634981 29 0 11 0 235 263 689 717 PREDICTED: Lutzomyia longipalpis troponin C-like (LOC129786533), transcript variant X2, misc_RNA blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
2886564 2886564 PRJNA1233317_S_NODE_4463_length_329_cov_2.374074_g4427_i0 PRJNA1233317 4463 329 2.374074 7.81070346 Cyprideis torosa 163714 Arthropoda Arthropoda 58.4 6.65e-4   NTclustered gi|1936428501|emb|OB665705.1| 163714 g4427 i0 100 0.0942249240121581 31 0 9 0 106 136 6468 6498 Cyprideis torosa blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
4875214 4875214 PRJNA1233317_S_NODE_12644_length_218_cov_1.943396_g12608_i0 PRJNA1233317 12644 218 1.943396 4.23660328 Arthropoda 6656 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2500597445|ref|XM_055827390.1| 7200 g12608 i0 100 3.98165137614679 30 0 14 0 189 218 4182 4211 PREDICTED: Lutzomyia longipalpis WD repeat-containing protein 19 (LOC129790123), transcript variant X2, mRNA blastn 868 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
5438918 5438918 PRJNA1233317_S_NODE_6445_length_295_cov_1.864407_g6409_i0 PRJNA1233317 6445 295 1.864407 5.50000065 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2919609746|emb|OZ238413.1| 2546182 g6409 i0 100 0.569491525423729 28 0 9 0 268 295 26262208 26262181 Chelidura thaleri genome assembly, chromosome: 14 blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
5438929 5438929 PRJNA1233317_S_NODE_8065_length_271_cov_4.028302_g8029_i0 PRJNA1233317 8065 271 4.028302 10.91669842 Timema cristinae 61476 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1946891983|emb|OC317117.1| 61476 g8029 i0 96.875 0.118081180811808 32 1 12 0 26 57 192357 192326 3_Tce_b3v08 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
6149971 6149971 PRJNA1233317_S_NODE_11205_length_232_cov_3.895954_g11169_i0 PRJNA1233317 11205 232 3.895954 9.03861328 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.021   NTclustered gi|1937045714|emb|OA572163.1| 61478 g11169 i0 100 0.482758620689655 28 0 12 0 1 28 8611 8638 1_Tdi_b3v08 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
7989018 7989018 PRJNA1233317_S_NODE_10787_length_237_cov_2.398876_g10751_i0 PRJNA1233317 10787 237 2.398876 5.68533612 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|1964088095|emb|OC879385.1| 1979941 g10751 i0 100 0.118143459915612 28 0 12 0 174 201 1782 1755 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
7989107 7989107 PRJNA1233317_S_NODE_7747_length_276_cov_2.082949_g7711_i0 PRJNA1233317 7747 276 2.082949 5.74893924 Acartia pacifica 335913 Arthropoda Arthropoda 111 4.13e-20   NTclustered gi|961374647|gb|KT754234.1| 335913 g7711 i0 92.308 5.73550724637681 78 6 28 0 109 186 146 69 Acartia pacifica clone Apa_cDNA6-9 60S ribosomal protein L41 mRNA, complete cds blastn 1583 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Acartiidae Acartia Acartia pacifica
9263744 9263744 PRJNA1233317_S_NODE_8748_length_261_cov_4.965347_g8712_i0 PRJNA1233317 8748 261 4.965347 12.95955567 Notodromas monacha 399045 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1938072304|emb|OA929861.1| 399045 g8712 i0 100 0.111111111111111 29 0 11 0 126 154 321 349 Notodromas monacha blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
10539492 10539492 PRJNA1233317_S_NODE_1849_length_398_cov_1.884956_g1813_i0 PRJNA1233317 1849 398 1.884956 7.50212488 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.038   NTclustered gi|1044897043|gb|KT223635.1| 354439 g1813 i0 100 0.070351758793969807 28 0 7 0 368 395 58 31 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
10539539 10539539 PRJNA1233317_S_NODE_6189_length_298_cov_13.196653_g6153_i0 PRJNA1233317 6189 298 13.196653 39.32602594 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1964668523|emb|OC856572.1| 1979941 g6153 i0 100 0.305369127516779 29 0 10 0 110 138 5783 5755 Medioppia subpectinata blastn 91 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
11814314 11814314 PRJNA1233317_S_NODE_8450_length_266_cov_2.357488_g8414_i0 PRJNA1233317 8450 266 2.357488 6.27091808 Samia ricini 63990 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2883230448|dbj|AP038908.1| 63990 g8414 i0 100 0.109022556390977 29 0 11 0 235 263 4307632 4307660 Samia ricini White GU1 DNA, chromosome 13, complete sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
12525845 12525845 PRJNA1233317_S_NODE_2970_length_361_cov_15.410596_g2934_i0 PRJNA1233317 2970 361 15.410596 55.63225156 Drosophila 7215 Arthropoda Arthropoda 58.4 7.36e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g2934 i0 100 1.49307479224377 31 0 9 0 287 317 107 77 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
13089288 13089288 PRJNA1233317_S_NODE_17011_length_183_cov_5.411290_g16975_i0 PRJNA1233317 17011 183 5.41129 9.9026607 Bombyx mori 7091 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2895205013|dbj|AP039396.1| 7091 g16975 i0 100 0.808743169398907 30 0 16 0 151 180 9792720 9792749 Bombyx mori DNA, chromosome 8, sequence blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
13089293 13089293 PRJNA1233317_S_NODE_2191_length_385_cov_3.797546_g2155_i0 PRJNA1233317 2191 385 3.797546 14.6205521 Chelidurella thaleri 2546182 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|2919607919|emb|OZ238406.1| 2546182 g2155 i0 100 0.0753246753246753 29 0 8 0 229 257 1618333 1618361 Chelidura thaleri genome assembly, chromosome: 7 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
16912700 16912700 PRJNA1233317_S_NODE_14554_length_201_cov_3.436620_g14518_i0 PRJNA1233317 14554 201 3.43662 6.9076062 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|1962659390|emb|OC868180.1| 1979941 g14518 i0 100 0.139303482587065 28 0 14 0 116 143 250 277 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
16912719 16912719 PRJNA1233317_S_NODE_2194_length_385_cov_2.993865_g2158_i0 PRJNA1233317 2194 385 2.993865 11.52638025 Lucilia shenyangensis 1912787 Arthropoda Arthropoda 231 4.399999999999999e-56   NTclustered gi|2172620069|ref|NC_059913.1| 1912787 g2158 i0 79.387 91.4025974025974 359 51 91 17 1 351 5743 6086 Lucilia shenyangensis mitochondrion, complete genome blastn 35190 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia shenyangensis
16912720 16912720 PRJNA1233317_S_NODE_2254_length_382_cov_16.204334_g2218_i0 PRJNA1233317 2254 382 16.204334 61.90055588 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g2218 i0 90.909 0.115183246073298 44 1 11 2 129 169 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
16912746 16912746 PRJNA1233317_S_NODE_4934_length_320_cov_2.291188_g4898_i0 PRJNA1233317 4934 320 2.291188 7.3318016 Bacillus rossius 75184 Arthropoda Arthropoda 60.2 1.79e-4   NTclustered gi|2686796785|ref|XM_063382098.1| 93214 g4898 i0 100 0.1 32 0 10 0 202 233 8481 8512 PREDICTED: Bacillus rossius redtenbacheri G protein-coupled receptor kinase 1 (LOC134539813), mRNA blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
17624914 17624914 PRJNA1233317_S_NODE_8934_length_259_cov_3.660000_g8898_i0 PRJNA1233317 8934 259 3.66 9.4794 Bombus 28641 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2245565984|ref|XM_012317363.3| 30195 g8898 i0 94.286 2.32046332046332 35 1 13 1 175 208 4146 4112 PREDICTED: Bombus terrestris ras-related protein Rap-2a (LOC105666581), transcript variant X1, mRNA blastn 601 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
18187146 18187146 PRJNA1233317_S_NODE_13695_length_208_cov_4.315436_g13659_i0 PRJNA1233317 13695 208 4.315436 8.97610688 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|2918386058|emb|OZ238101.1| 346795 g13659 i0 96.774 0.149038461538462 31 1 15 0 14 44 17808223 17808193 Longitarsus dorsalis genome assembly, chromosome: 8 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
18187160 18187160 PRJNA1233317_S_NODE_15855_length_193_cov_0.910448_g15819_i0 PRJNA1233317 15855 193 0.910448 1.75716464 Scarabaeus laticollis 292456 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|70909612|emb|AM048993.1| 292456 g15819 i0 96.97 0.316062176165803 33 1 17 0 161 193 33 1 Scarabaeus laticollis partial mRNA for ribosomal protein L5e (rpL5e gene) blastn 61 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Scarabaeus Scarabaeus laticollis
18187162 18187162 PRJNA1233317_S_NODE_16515_length_187_cov_7.046875_g16479_i0 PRJNA1233317 16515 187 7.046875 13.17765625 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1964708817|emb|OC858617.1| 1979941 g16479 i0 100 0.149732620320856 28 0 15 0 70 97 5040 5067 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
18187168 18187168 PRJNA1233317_S_NODE_18435_length_168_cov_5.596330_g18399_i0 PRJNA1233317 18435 168 5.59633 9.4018344 Callophrys avis 700180 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2918385993|emb|OZ238089.1| 700180 g18399 i0 100 0.351190476190476 28 0 17 0 126 153 11333872 11333899 Callophrys avis genome assembly, chromosome: 22 blastn 59 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
19461602 19461602 PRJNA1233317_S_NODE_11476_length_229_cov_4.611765_g11440_i0 PRJNA1233317 11476 229 4.611765 10.56094185 Belonocnema kinseyi 2817044 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1830544010|ref|XM_033360048.1| 2817044 g11440 i0 100 1.00436681222707 30 0 13 0 123 152 3547 3576 PREDICTED: Belonocnema kinseyi serine/threonine-protein phosphatase 2A 56 kDa regulatory subunit epsilon isoform (LOC117172291), mRNA blastn 230 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Cynipidae Belonocnema Belonocnema kinseyi
19461700 19461700 PRJNA1233317_S_NODE_8876_length_260_cov_2.328358_g8840_i0 PRJNA1233317 8876 260 2.328358 6.0537308 Gryllus bimaculatus 6999 Arthropoda Arthropoda 58.4 5.09e-4   NTclustered gi|1192786022|dbj|LC202053.1| 6999 g8840 i0 100 0.715384615384615 31 0 12 0 1 31 8 38 Gryllus bimaculatus cry2 mRNA for cryptochrome 2 transcript variant f, complete cds blastn 186 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
20173440 20173440 PRJNA1233317_S_NODE_12756_length_217_cov_2.316456_g12720_i0 PRJNA1233317 12756 217 2.316456 5.02670952 Metazoa 33208 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2579718322|gb|CP133311.1| 128015 g12720 i0 96.97 0.981566820276498 33 1 15 0 185 217 9466777 9466745 Platynothrus peltifer isolate 155_3 chromosome 6 blastn 213 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
20737050 20737050 PRJNA1233317_S_NODE_12417_length_220_cov_2.273292_g12381_i0 PRJNA1233317 12417 220 2.273292 5.0012424 Scylla paramamosain 85552 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1184387702|emb|LT835105.1| 85552 g12381 i0 100 0.263636363636364 30 0 14 0 1 30 6 35 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
20737062 20737062 PRJNA1233317_S_NODE_15477_length_195_cov_2.691176_g15441_i0 PRJNA1233317 15477 195 2.691176 5.2477932 Platynothrus peltifer 128015 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2579718318|gb|CP133307.1| 128015 g15441 i0 100 1.44102564102564 29 0 15 0 167 195 9149531 9149503 Platynothrus peltifer isolate 155_3 chromosome 2 blastn 281 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
23287919 23287919 PRJNA1233317_S_NODE_4219_length_333_cov_5.675182_g4183_i0 PRJNA1233317 4219 333 5.675182 18.89835606 Halyomorpha halys 286706 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2782025577|ref|XM_014436817.2| 286706 g4183 i0 100 0.0840840840840841 28 0 8 0 157 184 718 691 PREDICTED: Halyomorpha halys tudor domain-containing protein 1-like (LOC106691143), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys

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