RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA1193541" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1193541 · 33 ✖

analysis 1

  • blastn · 33 ✖
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
320633 320633 PRJNA1193541_P_NODE_13101_length_248_cov_0.880000_g12963_i0 PRJNA1193541 13101 248 0.88 2.1824 Bombyx mori 7091 Arthropoda Arthropoda 76.8 1.33e-9   NTclustered gi|2919985608|emb|OZ208581.1| 7091 g12963 i0 92.453 1.23387096774194 53 4 21 0 196 248 12081916 12081968 Bombyx mori genome assembly, chromosome: 3 blastn 306 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
320650 320650 PRJNA1193541_P_NODE_14061_length_245_cov_0.866279_g13923_i0 PRJNA1193541 14061 245 0.866279 2.12238355 Euproctis chrysorrhoea 987934 Arthropoda Arthropoda 130 9.93e-26   NTclustered gi|2918369808|emb|OZ237914.1| 987934 g13923 i0 81.646 1.30612244897959 158 28 64 1 66 223 20762483 20762639 Euproctis chrysorrhoea genome assembly, chromosome: 10 blastn 320 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Euproctis Euproctis chrysorrhoea
1595250 1595250 PRJNA1193541_P_NODE_14262_length_244_cov_0.900585_g14124_i0 PRJNA1193541 14262 244 0.900585 2.1974274 Euthrix potatoria 624169 Arthropoda Arthropoda 130 9.88e-26   NTclustered gi|2918370002|emb|OZ237889.1| 624169 g14124 i0 78.325 7.42213114754098 203 43 83 1 1 203 5852685 5852484 Euthrix potatoria genome assembly, chromosome: 17 blastn 1811 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
1595382 1595382 PRJNA1193541_P_NODE_6722_length_335_cov_1.076336_g6584_i0 PRJNA1193541 6722 335 1.076336 3.6057256 Coccinella septempunctata 41139 Arthropoda Arthropoda 143 1.82e-29   NTclustered gi|2125279524|ref|XM_044907735.1| 41139 g6584 i0 92.857 0.37910447761194 98 7 29 0 77 174 109 12 PREDICTED: Coccinella septempunctata uncharacterized LOC123320415 (LOC123320415), mRNA blastn 127 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
1595385 1595385 PRJNA1193541_P_NODE_6822_length_333_cov_1.003846_g6684_i0 PRJNA1193541 6822 333 1.003846 3.34280718 Callophrys avis 700180 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2918385401|emb|OZ238081.1| 700180 g6684 i0 100 0.0840840840840841 28 0 8 0 291 318 2016669 2016642 Callophrys avis genome assembly, chromosome: 14 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
2317756 2317756 PRJNA1193541_P_NODE_8462_length_300_cov_0.660793_g8324_i0 PRJNA1193541 8462 300 0.660793 1.982379 Lepidoptera 7088 Arthropoda Arthropoda 219 2.6e-52   NTclustered gi|2636206747|emb|OY979773.1| 52344 g8324 i0 86.124 34.1533333333333 209 21 67 7 97 297 7078913 7078705 Helicoverpa assulta genome assembly, chromosome: Z blastn 10246 219 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
2871390 2871390 PRJNA1193541_P_NODE_13903_length_245_cov_0.895349_g13765_i0 PRJNA1193541 13903 245 0.895349 2.19360505 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 71.3 6.11e-8   NTclustered gi|2918376580|emb|OZ238010.1| 307131 g13765 i0 85.507 0.281632653061224 69 8 28 2 29 96 16885153 16885086 Ceutorhynchus obstrictus genome assembly, chromosome: 1 blastn 69 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
6145233 6145233 PRJNA1193541_P_NODE_14465_length_243_cov_0.905882_g14327_i0 PRJNA1193541 14465 243 0.905882 2.20129326 Ramulus 523959 Arthropoda Arthropoda 159 1.2499999999999999e-34   NTclustered gi|1554432810|gb|MK291891.1| 2506092 g14327 i0 81.538 1.60493827160494 195 34 79 1 51 243 1956 2150 Ramulus sp. WS147 28S ribosomal RNA gene, partial sequence blastn 390 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Phasmatidae Ramulus Ramulus sp. WS147
6698483 6698483 PRJNA1193541_P_NODE_14886_length_242_cov_0.911243_g14748_i0 PRJNA1193541 14886 242 0.911243 2.20520806 Culex quinquefasciatus 7176 Arthropoda Arthropoda 425 1.11e-114   NTclustered gi|78190082|gb|AC168047.3| 7176 g14748 i0 98.347 31.8347107438017 242 4 100 0 1 242 68912 69153 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 7704 425 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
7973808 7973808 PRJNA1193541_P_NODE_10407_length_273_cov_1.540000_g10269_i0 PRJNA1193541 10407 273 1.54 4.2042 Psocoptera sp. PS02 1291676 Arthropoda Arthropoda 313 1.04e-80   NTclustered gi|449084630|gb|KC513101.1| 1291676 g10269 i0 95.855 72.8754578754579 193 8 71 0 1 193 1217 1025 Psocoptera sp. PS02 28S ribosomal RNA gene, partial sequence blastn 19895 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea     Psocoptera sp. PS02
7973900 7973900 PRJNA1193541_P_NODE_14987_length_241_cov_1.375000_g14849_i0 PRJNA1193541 14987 241 1.375 3.31375 Callosobruchus maculatus 64391 Arthropoda Arthropoda 440 3.959999999999999e-119   NTclustered gi|1258168164|gb|KY856743.1| 64391 g14849 i0 99.585 3.98755186721992 241 1 100 0 1 241 1079 839 Callosobruchus maculatus mitochondrion, complete genome blastn 961 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Callosobruchus Callosobruchus maculatus
7973998 7973998 PRJNA1193541_P_NODE_5447_length_364_cov_1.206186_g5309_i0 PRJNA1193541 5447 364 1.206186 4.39051704 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 97.1 1.57e-15   NTclustered gi|2918376583|emb|OZ238013.1| 307131 g5309 i0 85.567 39.6923076923077 97 9 34 5 170 263 14161838 14161932 Ceutorhynchus obstrictus genome assembly, chromosome: 4 blastn 14448 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
9248456 9248456 PRJNA1193541_P_NODE_10688_length_270_cov_1.263959_g10550_i0 PRJNA1193541 10688 270 1.263959 3.4126893 Ostrinia furnacalis 93504 Arthropoda Arthropoda 483 7.409999999999998e-132   NTclustered gi|1590285363|ref|XM_028310768.1| 93504 g10550 i0 98.889 1 270 3 100 0 1 270 378 647 PREDICTED: Ostrinia furnacalis extracellular serine protease-like (LOC114357247), mRNA blastn 270 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia furnacalis
9248487 9248487 PRJNA1193541_P_NODE_12308_length_250_cov_1.497175_g12170_i0 PRJNA1193541 12308 250 1.497175 3.7429375 Satyrium ilicis 876074 Arthropoda Arthropoda 316 7.269999999999998e-82   NTclustered gi|2918386084|emb|OZ238117.1| 876074 g12170 i0 89.6 178.38 250 24 100 1 1 250 3368613 3368366 Satyrium ilicis genome assembly, chromosome: 8 blastn 44595 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
10524278 10524278 PRJNA1193541_P_NODE_13409_length_247_cov_0.885057_g13271_i0 PRJNA1193541 13409 247 0.885057 2.18609079 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g13271 i0 100 0.121457489878543 30 0 12 0 109 138 14100599 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
11799107 11799107 PRJNA1193541_P_NODE_10510_length_272_cov_1.412060_g10372_i0 PRJNA1193541 10510 272 1.41206 3.8408032 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1964503389|emb|OE840646.1| 629358 g10372 i0 100 0.102941176470588 28 0 10 0 175 202 115144 115171 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
13074127 13074127 PRJNA1193541_P_NODE_10391_length_274_cov_0.935323_g10253_i0 PRJNA1193541 10391 274 0.935323 2.56278502 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 134 8.740000000000001e-27   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g10253 i0 86.4 11.014598540146 125 13 46 3 69 193 14693563 14693443 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 3018 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
13074151 13074151 PRJNA1193541_P_NODE_11531_length_258_cov_1.567568_g11393_i0 PRJNA1193541 11531 258 1.567568 4.04432544 Longitarsus dorsalis 346795 Arthropoda Arthropoda 137 6.300000000000001e-28   NTclustered gi|2918386054|emb|OZ238097.1| 346795 g11393 i0 76.923 0.957364341085271 247 53 95 4 7 251 29313704 29313460 Longitarsus dorsalis genome assembly, chromosome: 4 blastn 247 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
13074176 13074176 PRJNA1193541_P_NODE_12651_length_249_cov_0.875000_g12513_i0 PRJNA1193541 12651 249 0.875 2.17875 Longitarsus dorsalis 346795 Arthropoda Arthropoda 139 1.68e-28   NTclustered gi|2918386046|emb|OZ238108.1| 346795 g12513 i0 94.444 0.550200803212851 90 5 36 0 158 247 88491910 88491999 Longitarsus dorsalis genome assembly, chromosome: X blastn 137 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
13074203 13074203 PRJNA1193541_P_NODE_14571_length_243_cov_0.905882_g14433_i0 PRJNA1193541 14571 243 0.905882 2.20129326 Manduca sexta 7130 Arthropoda Arthropoda 444 3.09e-120   NTclustered gi|1931206981|ref|XM_037443718.1| 7130 g14433 i0 99.588 7.49794238683128 243 1 100 0 1 243 732 974 PREDICTED: Manduca sexta ferritin, lower subunit (LOC115455253), transcript variant X2, mRNA blastn 1822 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
13074206 13074206 PRJNA1193541_P_NODE_14831_length_242_cov_0.911243_g14693_i0 PRJNA1193541 14831 242 0.911243 2.20520806 Wasmannia auropunctata 64793 Arthropoda Arthropoda 58.4 4.69e-4   NTclustered gi|780618361|ref|XM_011704182.1| 64793 g14693 i0 97.059 0.56198347107438 34 1 14 0 95 128 1519 1552 PREDICTED: Wasmannia auropunctata uncharacterized protein C19orf47 (LOC105458679), transcript variant X3, mRNA blastn 136 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Wasmannia Wasmannia auropunctata
13074212 13074212 PRJNA1193541_P_NODE_15051_length_241_cov_0.916667_g14913_i0 PRJNA1193541 15051 241 0.916667 2.20916747 Callophrys avis 700180 Arthropoda Arthropoda 163 9.61e-36   NTclustered gi|2918384071|emb|OZ238072.1| 700180 g14913 i0 82.653 0.813278008298755 196 23 81 6 46 241 990337 990521 Callophrys avis genome assembly, chromosome: 5 blastn 196 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
14349616 14349616 PRJNA1193541_P_NODE_12052_length_251_cov_0.865169_g11914_i0 PRJNA1193541 12052 251 0.865169 2.17157419 Teleiodes vulgella 1594352 Arthropoda Arthropoda 82.4 2.9e-11   NTclustered gi|2918369816|emb|OZ237922.1| 1594352 g11914 i0 91.667 5.74103585657371 60 4 24 1 182 241 6150135 6150077 Teleiodes vulgella genome assembly, chromosome: 3 blastn 1441 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
15623427 15623427 PRJNA1193541_P_NODE_3053_length_455_cov_0.937173_g2915_i0 PRJNA1193541 3053 455 0.937173 4.26413715 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|2918376582|emb|OZ238012.1| 307131 g2915 i0 100 0.30989010989011 29 0 6 0 63 91 52669184 52669212 Ceutorhynchus obstrictus genome assembly, chromosome: 3 blastn 141 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
16897751 16897751 PRJNA1193541_P_NODE_15134_length_241_cov_0.916667_g14996_i0 PRJNA1193541 15134 241 0.916667 2.20916747 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2087207777|ref|XM_043367719.1| 1232801 g14996 i0 100 2.43983402489627 28 0 12 0 133 160 1234 1207 PREDICTED: Amphibalanus amphitrite MAP7 domain-containing protein 1-like (LOC122382427), transcript variant X12, mRNA blastn 588 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
16897835 16897835 PRJNA1193541_P_NODE_6034_length_350_cov_0.855596_g5896_i0 PRJNA1193541 6034 350 0.855596 2.994586 Longitarsus dorsalis 346795 Arthropoda Arthropoda 84.2 1.17e-11   NTclustered gi|2918386054|emb|OZ238097.1| 346795 g5896 i0 94.545 0.522857142857143 55 2 16 1 128 182 53681173 53681120 Longitarsus dorsalis genome assembly, chromosome: 4 blastn 183 84.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
18172359 18172359 PRJNA1193541_P_NODE_7455_length_320_cov_0.935223_g7317_i0 PRJNA1193541 7455 320 0.935223 2.9927136 Timema poppense 170557 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1946896637|emb|OD014535.1| 170557 g7317 i0 96.97 0.103125 33 1 10 0 215 247 7375 7407 1_Tps_b3v08 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
18172423 18172423 PRJNA1193541_P_NODE_9995_length_279_cov_0.815534_g9857_i0 PRJNA1193541 9995 279 0.815534 2.27533986 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g9857 i0 100 0.100358422939068 28 0 10 0 164 191 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
19446647 19446647 PRJNA1193541_P_NODE_15136_length_241_cov_0.916667_g14998_i0 PRJNA1193541 15136 241 0.916667 2.20916747 Euthrix potatoria 624169 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918369993|emb|OZ237880.1| 624169 g14998 i0 100 0.120331950207469 29 0 12 0 155 183 5382843 5382815 Euthrix potatoria genome assembly, chromosome: 8 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
21997313 21997313 PRJNA1193541_P_NODE_13678_length_246_cov_0.890173_g13540_i0 PRJNA1193541 13678 246 0.890173 2.18982558 Diabrotica virgifera 50389 Arthropoda Arthropoda 113 1e-20   NTclustered gi|2305240516|ref|XM_050648282.1| 50390 g13540 i0 86.408 4.58130081300813 103 14 42 0 143 245 5147 5249 PREDICTED: Diabrotica virgifera virgifera WD repeat-containing protein 7 (LOC114338584), transcript variant X4, mRNA blastn 1127 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
21997439 21997439 PRJNA1193541_P_NODE_6918_length_331_cov_0.810078_g6780_i0 PRJNA1193541 6918 331 0.810078 2.68135818 Longitarsus dorsalis 346795 Arthropoda Arthropoda 298 3.63e-76   NTclustered gi|2918386046|emb|OZ238108.1| 346795 g6780 i0 83.699 11.3081570996979 319 49 96 3 13 329 42217554 42217871 Longitarsus dorsalis genome assembly, chromosome: X blastn 3743 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
22719240 22719240 PRJNA1193541_P_NODE_718_length_820_cov_1.238286_g602_i0 PRJNA1193541 718 820 1.238286 10.1539452 Insecta 50557 Arthropoda Arthropoda 296 3.45e-75   NTclustered gi|1894976380|ref|XM_035938754.1| 7167 g602 i0 80.851 51.9512195121951 376 72 46 0 128 503 488 113 PREDICTED: Anopheles albimanus histone H2A (LOC118467848), mRNA blastn 42600 298 0.993288590604027 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
23272755 23272755 PRJNA1193541_P_NODE_12799_length_249_cov_0.875000_g12661_i0 PRJNA1193541 12799 249 0.875 2.17875 Manduca sexta 7130 Arthropoda Arthropoda 455 1.47e-123   NTclustered gi|1931219032|ref|XM_030174177.2| 7130 g12661 i0 99.598 2.2570281124498 249 1 100 0 1 249 129 377 PREDICTED: Manduca sexta ecdysteroid-regulated 16 kDa protein-like (LOC115447195), mRNA blastn 562 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta

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