RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA715461 · 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
3256496 3256496 PRJNA715461_S_NODE_1043_length_245_cov_7.726744_g969_i0 PRJNA715461 1043 245 7.726744 18.9305228 Helicoverpa assulta 52344 Arthropoda Arthropoda 401 1.9099999999999994e-107   NTclustered gi|2636206761|emb|OY979787.1| 52344 g969 i0 100 7.25714285714286 217 0 89 0 26 242 6606931 6606715 Helicoverpa assulta genome assembly, chromosome: 13 blastn 1778 401 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
3743927 3743927 PRJNA715461_S_NODE_603_length_341_cov_21557.014925_g529_i0 PRJNA715461 603 341 21557.014925 73509.42089425 Lepidoptera 7088 Arthropoda Arthropoda 414 3.57e-111   NTclustered gi|560190490|gb|KF611783.1| 7091 g529 i0 100 104.642228739003 224 0 66 0 4 227 925 1148 Bombyx mori isolate AVVMTKB1 18S ribosomal RNA gene, partial sequence blastn 35683 414 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
4533486 4533486 PRJNA715461_S_NODE_804_length_282_cov_22.497608_g730_i0 PRJNA715461 804 282 22.497608 63.44325456 Hydrometra stagnorum 446445 Arthropoda Arthropoda 217 8.72e-52   NTclustered gi|1131051030|gb|KX821841.1| 446445 g730 i0 85.388 22.7730496453901 219 20 74 7 12 219 1143 1360 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 6422 217 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
5020498 5020498 PRJNA715461_S_NODE_944_length_257_cov_12910.043478_g870_i0 PRJNA715461 944 257 12910.043478 33178.81173846 Artemia 6660 Arthropoda Arthropoda 315 2.7e-81   NTclustered gi|2295022767|gb|OP365120.1| 6661 g870 i0 99.422 67.3929961089494 173 1 67 0 82 254 987 815 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 17320 315 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7083785 7083785 PRJNA715461_S_NODE_1046_length_245_cov_2.802326_g972_i0 PRJNA715461 1046 245 2.802326 6.8656987 Helicoverpa assulta 52344 Arthropoda Arthropoda 318 1.9699999999999998e-82   NTclustered gi|2636206752|emb|OY979778.1| 52344 g972 i0 98.343 28.6734693877551 181 3 74 0 1 181 12543531 12543351 Helicoverpa assulta genome assembly, chromosome: 4 blastn 7025 318 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
9633681 9633681 PRJNA715461_S_NODE_928_length_259_cov_10034.526882_g854_i0 PRJNA715461 928 259 10034.526882 25989.42462438 Helicoverpa zea 7113 Arthropoda Arthropoda 320 5.86e-83   NTclustered gi|1864346560|gb|MT702911.1| 7113 g854 i0 100 37.6254826254826 173 0 67 0 1 173 10286 10458 Helicoverpa zea clone Hz_Scaffold_105 sequence blastn 9745 320 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa zea
10120782 10120782 PRJNA715461_S_NODE_908_length_263_cov_3.947368_g834_i0 PRJNA715461 908 263 3.947368 10.38157784 root 1 Root_unresolved Root_unresolved 366 7.55e-97   NTclustered gi|2295022767|gb|OP365120.1| 6661 g834 i0 99.02 77.5019011406844 204 2 78 0 2 205 1275 1478 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 20383 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10120783 10120783 PRJNA715461_S_NODE_948_length_256_cov_12843.956284_g874_i0 PRJNA715461 948 256 12843.956284 32880.52808704 Artemia 6660 Arthropoda Arthropoda 315 2.69e-81   NTclustered gi|2295022767|gb|OP365120.1| 6661 g874 i0 99.422 67.65625 173 1 68 0 4 176 815 987 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 17320 315 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10909209 10909209 PRJNA715461_S_NODE_1209_length_228_cov_40.529032_g1135_i0 PRJNA715461 1209 228 40.529032 92.40619296 Aedes aegypti 7159 Arthropoda Arthropoda 237 5.23e-58   NTclustered gi|42740775|gb|AY432810.1| 7159 g1135 i0 98.507 379.214912280702 134 2 59 0 4 137 361 494 Aedes aegypti ASAP ID: 38495 conserved unknown mRNA sequence blastn 86461 237 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
11395790 11395790 PRJNA715461_S_NODE_1829_length_201_cov_6.210938_g1755_i0 PRJNA715461 1829 201 6.210938 12.48398538 Lepidoptera 7088 Arthropoda Arthropoda 366 5.5e-97   NTclustered gi|2306717695|ref|XR_004783997.2| 7108 g1755 i0 100 213.004975124378 198 0 99 0 4 201 1552 1749 PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA blastn 42814 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
11395801 11395801 PRJNA715461_S_NODE_949_length_256_cov_11123.043716_g875_i0 PRJNA715461 949 256 11123.043716 28474.99191296 Artemia 6660 Arthropoda Arthropoda 311 3.4800000000000004e-80   NTclustered gi|2295022767|gb|OP365120.1| 6661 g875 i0 100 65.6953125 168 0 66 0 4 171 815 982 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 16818 311 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12184447 12184447 PRJNA715461_S_NODE_1070_length_243_cov_1.335294_g996_i0 PRJNA715461 1070 243 1.335294 3.24476442 Helicoverpa armigera 29058 Arthropoda Arthropoda 259 1.2e-64   NTclustered gi|2705312525|ref|XM_021334838.3| 29058 g996 i0 92.021 18.4979423868313 188 10 77 2 53 240 600 418 PREDICTED: Helicoverpa armigera uncharacterized LOC110376376 (LOC110376376), mRNA blastn 4495 259 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
12184459 12184459 PRJNA715461_S_NODE_450_length_407_cov_15037.853293_g376_i0 PRJNA715461 450 407 15037.853293 61204.06290251 Hydrometra stagnorum 446445 Arthropoda Arthropoda 357 7.39e-94   NTclustered gi|1131051030|gb|KX821841.1| 446445 g376 i0 89.153 21.2260442260442 295 20 70 7 113 396 1436 1143 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 8639 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
12671798 12671798 PRJNA715461_S_NODE_1170_length_231_cov_2.449367_g1096_i0 PRJNA715461 1170 231 2.449367 5.65803777 Artemia 6660 Arthropoda Arthropoda 318 1.84e-82   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1096 i0 98.876 37.974025974026 178 2 77 0 53 230 2430 2253 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 8772 318 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
14734112 14734112 PRJNA715461_S_NODE_492_length_387_cov_15720.984076_g418_i0 PRJNA715461 492 387 15720.984076 60840.20837412 Heliothis virescens 7102 Arthropoda Arthropoda 571 2.2899999999999993e-158   NTclustered gi|946714876|gb|KR871309.1| 7102 g418 i0 99.365 269.428940568475 315 2 81 0 70 384 402 88 Heliothis virescens transcribed RNA sequence blastn 104269 571 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Heliothis Heliothis virescens
14734117 14734117 PRJNA715461_S_NODE_792_length_285_cov_0.886792_g718_i0 PRJNA715461 792 285 0.886792 2.5273572 Helicoverpa assulta 52344 Arthropoda Arthropoda 505 1.6799999999999995e-138   NTclustered gi|2636206760|emb|OY979786.1| 52344 g718 i0 99.638 38.3508771929825 276 1 97 0 4 279 1275371 1275646 Helicoverpa assulta genome assembly, chromosome: 12 blastn 10930 505 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
16007724 16007724 PRJNA715461_S_NODE_493_length_387_cov_15025.050955_g419_i0 PRJNA715461 493 387 15025.050955 58146.94719585 Heliothis virescens 7102 Arthropoda Arthropoda 577 4.9299999999999986e-160   NTclustered gi|946714876|gb|KR871309.1| 7102 g419 i0 99.683 270.361757105943 315 1 81 0 4 318 88 402 Heliothis virescens transcribed RNA sequence blastn 104630 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Heliothis Heliothis virescens
18556960 18556960 PRJNA715461_S_NODE_1055_length_244_cov_4.532164_g981_i0 PRJNA715461 1055 244 4.532164 11.05848016 Helicoverpa assulta 52344 Arthropoda Arthropoda 363 8.949999999999999e-96   NTclustered gi|2636206752|emb|OY979778.1| 52344 g981 i0 99.497 9.38934426229508 199 1 84 0 43 241 12551335 12551137 Helicoverpa assulta genome assembly, chromosome: 4 blastn 2291 363 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
18556961 18556961 PRJNA715461_S_NODE_1135_length_235_cov_2.308642_g1061_i0 PRJNA715461 1135 235 2.308642 5.4253087 Helicoverpa assulta 52344 Arthropoda Arthropoda 344 3.0999999999999993e-90   NTclustered gi|2636206760|emb|OY979786.1| 52344 g1061 i0 99.471 19.8255319148936 189 1 80 0 1 189 5212268 5212456 Helicoverpa assulta genome assembly, chromosome: 12 blastn 4659 344 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
19043974 19043974 PRJNA715461_S_NODE_1155_length_232_cov_109.943396_g1081_i0 PRJNA715461 1155 232 109.943396 255.06867872 Artemia 6660 Arthropoda Arthropoda 320 5.15e-83   NTclustered gi|2295022767|gb|OP365120.1| 6661 g1081 i0 100 74.6551724137931 173 0 75 0 57 229 987 815 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 17320 320 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
19043982 19043982 PRJNA715461_S_NODE_575_length_357_cov_16577.274648_g501_i0 PRJNA715461 575 357 16577.274648 59180.87049336 Artemia 6660 Arthropoda Arthropoda 501 2.79e-137   NTclustered gi|2743054335|ref|XR_010620511.1| 6661 g501 i0 99.635 76.2717086834734 274 1 77 0 81 354 917 644 PREDICTED: Artemia franciscana small subunit ribosomal RNA (LOC136039680), rRNA blastn 27229 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22382694 22382694 PRJNA715461_S_NODE_1258_length_225_cov_546.243421_g1184_i0 PRJNA715461 1258 225 546.243421 1229.04769725 Aedes aegypti 7159 Arthropoda Arthropoda 416 6.159999999999998e-112   NTclustered gi|42740775|gb|AY432810.1| 7159 g1184 i0 100 642.151111111111 225 0 100 0 1 225 492 268 Aedes aegypti ASAP ID: 38495 conserved unknown mRNA sequence blastn 144484 416 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
22382705 22382705 PRJNA715461_S_NODE_838_length_276_cov_2.694581_g764_i0 PRJNA715461 838 276 2.694581 7.43704356 Helicoverpa armigera 29058 Arthropoda Arthropoda 470 5.91e-128   NTclustered gi|2705298473|ref|XR_002429736.3| 29058 g764 i0 100 23.7210144927536 254 0 92 0 3 256 295 42 PREDICTED: Helicoverpa armigera uncharacterized LOC110379414 (LOC110379414), ncRNA blastn 6547 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
23658189 23658189 PRJNA715461_S_NODE_319_length_487_cov_6.371981_g252_i0 PRJNA715461 319 487 6.371981 31.03154747 Artemia franciscana 6661 Arthropoda Arthropoda 800 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g252 i0 99.101 30.570841889117 445 4 91 0 40 484 3709 3265 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 14888 800 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
23658194 23658194 PRJNA715461_S_NODE_779_length_287_cov_1.570093_g705_i0 PRJNA715461 779 287 1.570093 4.50616691 Helicoverpa zea 7113 Arthropoda Arthropoda 457 4.81e-124   NTclustered gi|2211688911|ref|XM_047169116.1| 7113 g705 i0 95.775 2.9616724738676 284 10 98 1 6 287 504 787 PREDICTED: Helicoverpa zea circadian clock-controlled protein daywake-like (LOC124633782), mRNA blastn 850 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa zea
24143807 24143807 PRJNA715461_S_NODE_1079_length_241_cov_33520.160714_g1005_i0 PRJNA715461 1079 241 33520.160714 80783.58732074 Lepidoptera 7088 Arthropoda Arthropoda 231 2.6e-56   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g1005 i0 100 110.414937759336 125 0 52 0 114 238 8662584 8662460 Bombyx mori DNA, chromosome 22, sequence blastn 26610 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
24143828 24143828 PRJNA715461_S_NODE_819_length_279_cov_0.830097_g745_i0 PRJNA715461 819 279 0.830097 2.31597063 Helicoverpa 7112 Arthropoda Arthropoda 403 6.16e-108   NTclustered gi|2211690726|ref|XM_047172506.1| 7113 g745 i0 98.678 13.0645161290323 227 3 81 0 4 230 328 554 PREDICTED: Helicoverpa zea glycine-rich RNA-binding protein 8-like (LOC124636419), mRNA blastn 3645 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa zea
24931689 24931689 PRJNA715461_S_NODE_1100_length_240_cov_3.365269_g1026_i0 PRJNA715461 1100 240 3.365269 8.0766456 Helicoverpa armigera 29058 Arthropoda Arthropoda 425 1.1e-114   NTclustered gi|2705294570|ref|XM_021345321.3| 29058 g1026 i0 99.573 3.50833333333333 234 0 98 1 1 234 697 929 PREDICTED: Helicoverpa armigera endocuticle structural glycoprotein ABD-5 (LOC110384174), mRNA blastn 842 425 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
25418744 25418744 PRJNA715461_S_NODE_680_length_312_cov_8532.364017_g606_i0 PRJNA715461 680 312 8532.364017 26620.97573304 Lepidoptera 7088 Arthropoda Arthropoda 414 3.23e-111   NTclustered gi|560190490|gb|KF611783.1| 7091 g606 i0 100 114.36858974359 224 0 72 0 86 309 1148 925 Bombyx mori isolate AVVMTKB1 18S ribosomal RNA gene, partial sequence blastn 35683 414 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori

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