RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1247234" 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

  • PRJNA1247234 · 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
351142 351142 PRJNA1247234_P_NODE_13041_length_307_cov_1.666667_g12885_i0 PRJNA1247234 13041 307 1.666667 5.11666769 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g12885 i0 100 0.0944625407166124 29 0 9 0 106 134 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
351299 351299 PRJNA1247234_P_NODE_22381_length_250_cov_0.881356_g22225_i0 PRJNA1247234 22381 250 0.881356 2.20339 Spodoptera frugiperda 7108 Arthropoda Arthropoda 457 4.1099999999999985e-124   NTclustered gi|2306775369|ref|XM_050694952.1| 7108 g22225 i0 99.6 51.844 250 1 100 0 1 250 11557 11806 PREDICTED: Spodoptera frugiperda titin (LOC118265809), transcript variant X15, mRNA blastn 12961 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
1625961 1625961 PRJNA1247234_P_NODE_12442_length_313_cov_2.020833_g12286_i0 PRJNA1247234 12442 313 2.020833 6.32520729 Spodoptera frugiperda 7108 Arthropoda Arthropoda 568 2.3499999999999998e-157   NTclustered gi|2306771470|ref|XM_035588506.2| 7108 g12286 i0 99.361 8.20766773162939 313 2 100 0 1 313 2277 2589 PREDICTED: Spodoptera frugiperda uncharacterized LOC118272155 (LOC118272155), mRNA blastn 2569 568 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
2327003 2327003 PRJNA1247234_P_NODE_12142_length_317_cov_1.012295_g11986_i0 PRJNA1247234 12142 317 1.012295 3.20897515 Opisthokonta 33154 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1847779723|ref|XM_034815018.1| 7241 g11986 i0 96.97 2.69400630914827 33 1 10 0 35 67 876 844 PREDICTED: Drosophila subobscura uncharacterized LOC117903173 (LOC117903173), mRNA blastn 854 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila subobscura
4178551 4178551 PRJNA1247234_P_NODE_15924_length_283_cov_1.114286_g15768_i0 PRJNA1247234 15924 283 1.114286 3.15342938 Aedes albopictus 7160 Arthropoda Arthropoda 451 2.1999999999999995e-122   NTclustered gi|2669883061|ref|XR_009995834.1| 7160 g15768 i0 96.043 5.54416961130742 278 9 100 1 6 283 9319 9594 PREDICTED: Aedes albopictus uncharacterized LOC134284553 (LOC134284553), ncRNA blastn 1569 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
6729200 6729200 PRJNA1247234_P_NODE_20246_length_253_cov_0.866667_g20090_i0 PRJNA1247234 20246 253 0.866667 2.19266751 Spodoptera frugiperda 7108 Arthropoda Arthropoda 418 1.9599999999999994e-112   NTclustered gi|2306725660|ref|XM_035573538.2| 7108 g20090 i0 96.443 19.8537549407115 253 9 100 0 1 253 701 449 PREDICTED: Spodoptera frugiperda cholinesterase 1 (LOC118262305), transcript variant X4, mRNA blastn 5023 418 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
6729308 6729308 PRJNA1247234_P_NODE_26046_length_244_cov_1.491228_g25890_i0 PRJNA1247234 26046 244 1.491228 3.63859632 Spodoptera frugiperda 7108 Arthropoda Arthropoda 418 1.8799999999999994e-112   NTclustered gi|2306768733|ref|XM_035594744.2| 7108 g25890 i0 97.541 8.03688524590164 244 6 100 0 1 244 304 61 PREDICTED: Spodoptera frugiperda basic juvenile hormone-suppressible protein 1 (LOC118276436), mRNA blastn 1961 418 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
6729324 6729324 PRJNA1247234_P_NODE_27186_length_243_cov_0.917647_g27030_i0 PRJNA1247234 27186 243 0.917647 2.22988221 Spodoptera frugiperda 7108 Arthropoda Arthropoda 424 4.03e-114   NTclustered gi|2306770749|ref|XM_035588304.2| 7108 g27030 i0 98.34 26.0740740740741 241 4 99 0 3 243 864 624 PREDICTED: Spodoptera frugiperda basic juvenile hormone-suppressible protein 2 (LOC118272014), mRNA blastn 6336 424 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
8004609 8004609 PRJNA1247234_P_NODE_14187_length_297_cov_1.174107_g14031_i0 PRJNA1247234 14187 297 1.174107 3.48709779 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g14031 i0 100 0.0942760942760943 28 0 9 0 98 125 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
8005000 8005000 PRJNA1247234_P_NODE_9527_length_348_cov_1.894545_g9371_i0 PRJNA1247234 9527 348 1.894545 6.5930166 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g9371 i0 100 0.0804597701149425 28 0 8 0 104 131 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
10555748 10555748 PRJNA1247234_P_NODE_7829_length_376_cov_1.188119_g7673_i0 PRJNA1247234 7829 376 1.188119 4.46732744 Spodoptera frugiperda 7108 Arthropoda Arthropoda 691 0   NTclustered gi|2306727437|ref|XM_035585800.2| 7108 g7673 i0 100 98.1515957446808 374 0 99 0 1 374 366 739 PREDICTED: Spodoptera frugiperda myosin regulatory light chain 2 (LOC118270279), mRNA blastn 36905 691 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
11830119 11830119 PRJNA1247234_P_NODE_24770_length_246_cov_0.901734_g24614_i0 PRJNA1247234 24770 246 0.901734 2.21826564 Spodoptera frugiperda 7108 Arthropoda Arthropoda 429 8.789999999999998e-116   NTclustered gi|2306768629|ref|XM_035594451.2| 7108 g24614 i0 98.361 7.88617886178862 244 4 99 0 1 244 805 562 PREDICTED: Spodoptera frugiperda delta-1-pyrroline-5-carboxylate synthase (LOC118276214), transcript variant X2, mRNA blastn 1940 429 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
12530365 12530365 PRJNA1247234_P_NODE_27970_length_242_cov_0.923077_g27814_i0 PRJNA1247234 27970 242 0.923077 2.23384634 root 1 Root_unresolved Root_unresolved 58.4 4.69e-4   NTclustered gi|2832707056|ref|XM_069129292.1| 103934 g27814 i0 97.059 3.74380165289256 34 1 14 0 174 207 1078 1111 PREDICTED: Bombus flavifrons similar to Deadpan (Sidpn), transcript variant X1, mRNA blastn 906 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus flavifrons
13105260 13105260 PRJNA1247234_P_NODE_18651_length_263_cov_1.221053_g18495_i0 PRJNA1247234 18651 263 1.221053 3.21136939 Spodoptera frugiperda 7108 Arthropoda Arthropoda 464 2.5999999999999993e-126   NTclustered gi|2306770749|ref|XM_035588304.2| 7108 g18495 i0 98.479 19.745247148289 263 4 100 0 1 263 1723 1985 PREDICTED: Spodoptera frugiperda basic juvenile hormone-suppressible protein 2 (LOC118272014), mRNA blastn 5193 464 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
14380416 14380416 PRJNA1247234_P_NODE_13172_length_306_cov_1.313305_g13016_i0 PRJNA1247234 13172 306 1.313305 4.0187133 Spodoptera frugiperda 7108 Arthropoda Arthropoda 566 8.239999999999998e-157   NTclustered gi|2306770749|ref|XM_035588304.2| 7108 g13016 i0 100 7.21241830065359 306 0 100 0 1 306 378 73 PREDICTED: Spodoptera frugiperda basic juvenile hormone-suppressible protein 2 (LOC118272014), mRNA blastn 2207 566 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
14380487 14380487 PRJNA1247234_P_NODE_16492_length_279_cov_1.024272_g16336_i0 PRJNA1247234 16492 279 1.024272 2.85771888 Spodoptera frugiperda 7108 Arthropoda Arthropoda 516 7.58e-142   NTclustered gi|1864254104|gb|MT544400.1| 7108 g16336 i0 100 15.9641577060932 279 0 100 0 1 279 910 1188 Spodoptera frugiperda clone Sf_485 arylphorin mRNA, complete cds blastn 4454 516 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
14380573 14380573 PRJNA1247234_P_NODE_20992_length_252_cov_0.871508_g20836_i0 PRJNA1247234 20992 252 0.871508 2.19620016 Limulus polyphemus 6850 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1238862767|ref|XM_022391955.1| 6850 g20836 i0 100 0.444444444444444 28 0 11 0 11 38 739 766 PREDICTED: Limulus polyphemus homeobox protein prospero-like (LOC106464241), transcript variant X2, mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
14380661 14380661 PRJNA1247234_P_NODE_25812_length_245_cov_0.906977_g25656_i0 PRJNA1247234 25812 245 0.906977 2.22209365 Anarta stigmosa 1869462 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2918376560|emb|OZ237980.1| 1869462 g25656 i0 97.059 0.138775510204082 34 0 14 1 212 245 13861544 13861576 Anarta stigmosa genome assembly, chromosome: 4 blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
15654346 15654346 PRJNA1247234_P_NODE_16673_length_277_cov_1.539216_g16517_i0 PRJNA1247234 16673 277 1.539216 4.26362832 Spodoptera frugiperda 7108 Arthropoda Arthropoda 512 9.73e-141   NTclustered gi|2306768733|ref|XM_035594744.2| 7108 g16517 i0 100 9.37545126353791 277 0 100 0 1 277 1367 1091 PREDICTED: Spodoptera frugiperda basic juvenile hormone-suppressible protein 1 (LOC118276436), mRNA blastn 2597 512 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
15654379 15654379 PRJNA1247234_P_NODE_18313_length_265_cov_1.567708_g18157_i0 PRJNA1247234 18313 265 1.567708 4.1544262 Spodoptera frugiperda 7108 Arthropoda Arthropoda 484 2.0199999999999998e-132   NTclustered gi|2306760478|ref|XM_050706700.1| 7108 g18157 i0 99.623 23.2943396226415 265 1 100 0 1 265 1137 1401 PREDICTED: Spodoptera frugiperda membrane alanyl aminopeptidase-like (LOC126912773), mRNA blastn 6173 484 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
16928453 16928453 PRJNA1247234_P_NODE_10274_length_338_cov_1.566038_g10118_i0 PRJNA1247234 10274 338 1.566038 5.29320844 Spodoptera frugiperda 7108 Arthropoda Arthropoda 575 1.5299999999999995e-159   NTclustered gi|2306771470|ref|XM_035588506.2| 7108 g10118 i0 97.337 15.2337278106509 338 9 100 0 1 338 2850 3187 PREDICTED: Spodoptera frugiperda uncharacterized LOC118272155 (LOC118272155), mRNA blastn 5149 575 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
16928536 16928536 PRJNA1247234_P_NODE_14614_length_293_cov_1.418182_g14458_i0 PRJNA1247234 14614 293 1.418182 4.15527326 Spodoptera frugiperda 7108 Arthropoda Arthropoda 542 1.32e-149   NTclustered gi|1864254104|gb|MT544400.1| 7108 g14458 i0 100 16.7883959044369 293 0 100 0 1 293 1789 1497 Spodoptera frugiperda clone Sf_485 arylphorin mRNA, complete cds blastn 4919 542 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
18203348 18203348 PRJNA1247234_P_NODE_7095_length_393_cov_0.946875_g6939_i0 PRJNA1247234 7095 393 0.946875 3.72121875 Diabrotica virgifera 50389 Arthropoda Arthropoda 52.8 0.038   NTclustered gi|2305281579|ref|XM_028276149.2| 50390 g6939 i0 100 0.142493638676845 28 0 7 0 275 302 8354 8381 PREDICTED: Diabrotica virgifera virgifera axin-1 (LOC114327508), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
19477574 19477574 PRJNA1247234_P_NODE_24476_length_247_cov_0.896552_g24320_i0 PRJNA1247234 24476 247 0.896552 2.21448344 Spodoptera frugiperda 7108 Arthropoda Arthropoda 457 4.05e-124   NTclustered gi|2306739794|ref|XM_050700254.1| 7108 g24320 i0 100 100 247 0 100 0 1 247 3875 4121 PREDICTED: Spodoptera frugiperda myosin heavy chain, muscle (LOC118269387), transcript variant X32, mRNA blastn 24700 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
20753020 20753020 PRJNA1247234_P_NODE_25757_length_245_cov_0.906977_g25601_i0 PRJNA1247234 25757 245 0.906977 2.22209365 Spodoptera frugiperda 7108 Arthropoda Arthropoda 448 2.41e-121   NTclustered gi|2306730672|ref|XM_035598118.2| 7108 g25601 i0 99.592 78.1183673469388 245 1 100 0 1 245 140 384 PREDICTED: Spodoptera frugiperda lipoyltransferase 1, mitochondrial (LOC118278772), transcript variant X1, mRNA blastn 19139 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
20753072 20753072 PRJNA1247234_P_NODE_27957_length_242_cov_0.923077_g27801_i0 PRJNA1247234 27957 242 0.923077 2.23384634 Spodoptera frugiperda 7108 Arthropoda Arthropoda 414 2.41e-111   NTclustered gi|2306724203|ref|XM_035573635.2| 7108 g27801 i0 97.521 8.21900826446281 242 6 100 0 1 242 963 722 PREDICTED: Spodoptera frugiperda bifunctional phosphoribosylaminoimidazole carboxylase/phosphoribosylaminoimidazole succinocarboxamide synthetase (LOC118262367), mRNA blastn 1989 414 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
20753095 20753095 PRJNA1247234_P_NODE_3477_length_526_cov_3.496689_g3326_i0 PRJNA1247234 3477 526 3.496689 18.39258414 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g3326 i0 100 0.296577946768061 30 0 6 0 207 236 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 156 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
23303729 23303729 PRJNA1247234_P_NODE_1759_length_707_cov_3.447950_g1628_i0 PRJNA1247234 1759 707 3.44795 24.3770065 Oppiella nova 334625 Arthropoda Arthropoda 54.7 0.02   NTclustered gi|1962580772|emb|OC914909.1| 334625 g1628 i0 100 0.041018387553041 29 0 4 0 81 109 7584 7612 Oppiella nova blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
23303931 23303931 PRJNA1247234_P_NODE_3559_length_521_cov_2.171875_g3408_i0 PRJNA1247234 3559 521 2.171875 11.31546875 Timema shepardi 629360 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1937893444|emb|OC006465.1| 629360 g3408 i0 94.595 0.0710172744721689 37 0 7 2 169 203 33213 33249 2_Tsi_b3v08 blastn 37 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema shepardi
23303957 23303957 PRJNA1247234_P_NODE_5219_length_444_cov_2.008086_g5065_i0 PRJNA1247234 5219 444 2.008086 8.91590184 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|2919545581|emb|OZ238355.1| 1002887 g5065 i0 100 0.0630630630630631 28 0 6 0 301 328 15905120 15905093 Glaucopsyche melanops genome assembly, chromosome: 14 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
23303968 23303968 PRJNA1247234_P_NODE_6019_length_419_cov_1.277457_g5865_i0 PRJNA1247234 6019 419 1.277457 5.35254483 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g5865 i0 100 0.0668257756563246 28 0 7 0 92 119 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
24577600 24577600 PRJNA1247234_P_NODE_12640_length_311_cov_1.924370_g12484_i0 PRJNA1247234 12640 311 1.92437 5.9847907 Graphium sarpedon 76205 Arthropoda Arthropoda 503 6.68e-138   NTclustered gi|16041012|dbj|AB059714.1| 76205 g12484 i0 100 506.742765273312 272 0 87 0 1 272 446 717 Graphium sarpedon gene for 28S rRNA, partial sequence blastn 157597 503 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Graphium Graphium sarpedon

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