RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA1167252" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1167252 · 28 ✖

analysis 1

  • blastn · 28 ✖
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
1589235 1589235 PRJNA1167252_P_NODE_24402_length_250_cov_0.881356_g24129_i0 PRJNA1167252 24402 250 0.881356 2.20339 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1964669652|emb|OC855650.1| 1979941 g24129 i0 100 0.112 28 0 11 0 3 30 11117 11090 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
2865175 2865175 PRJNA1167252_P_NODE_17543_length_291_cov_1.151376_g17270_i0 PRJNA1167252 17543 291 1.151376 3.35050416 Sipha flava 143950 Arthropoda Arthropoda 496 1.04e-135   NTclustered gi|1418884374|ref|XM_025549432.1| 143950 g17270 i0 98.571 3.84879725085911 280 4 96 0 1 280 1070 791 PREDICTED: Sipha flava uncharacterized LOC112679567 (LOC112679567), transcript variant X1, mRNA blastn 1120 496 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
2865202 2865202 PRJNA1167252_P_NODE_18503_length_283_cov_4.104762_g18230_i0 PRJNA1167252 18503 283 4.104762 11.61647646 Psocoptera sp. PS02 1291676 Arthropoda Arthropoda 313 1.09e-80   NTclustered gi|449084630|gb|KC513101.1| 1291676 g18230 i0 95.855 70.1378091872791 193 8 68 0 1 193 1217 1025 Psocoptera sp. PS02 28S ribosomal RNA gene, partial sequence blastn 19849 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea     Psocoptera sp. PS02
2865418 2865418 PRJNA1167252_P_NODE_25883_length_248_cov_0.891429_g25610_i0 PRJNA1167252 25883 248 0.891429 2.21074392 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2918386102|emb|OZ238122.1| 876074 g25610 i0 96.774 0.125 31 1 13 0 114 144 28208125 28208155 Satyrium ilicis genome assembly, chromosome: 13 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
2865517 2865517 PRJNA1167252_P_NODE_29503_length_242_cov_0.923077_g29230_i0 PRJNA1167252 29503 242 0.923077 2.23384634 Penaeus vannamei 6689 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2864124544|ref|XM_027356232.2| 6689 g29230 i0 100 0.12396694214876 30 0 12 0 198 227 2202 2173 PREDICTED: Penaeus vannamei uncharacterized protein (LOC113805257), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
4141433 4141433 PRJNA1167252_P_NODE_24384_length_250_cov_0.881356_g24111_i0 PRJNA1167252 24384 250 0.881356 2.20339 Drosophila albomicans 7291 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2328670945|ref|XM_034254818.2| 7291 g24111 i0 100 0.236 30 0 12 0 87 116 301 272 PREDICTED: Drosophila albomicans uncharacterized LOC117572168 (LOC117572168), mRNA blastn 59 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila albomicans
5417549 5417549 PRJNA1167252_P_NODE_21025_length_264_cov_1.633508_g20752_i0 PRJNA1167252 21025 264 1.633508 4.31246112 Diaziella yangi 942512 Arthropoda Arthropoda 488 1.5499999999999999e-133   NTclustered gi|325073578|gb|HQ456878.1| 942512 g20752 i0 100 98.9318181818182 264 0 100 0 1 264 563 300 Diaziella yangi isolate D.ya2 28S ribosomal RNA gene, partial sequence blastn 26118 488 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Diaziella Diaziella yangi
6692325 6692325 PRJNA1167252_P_NODE_19586_length_275_cov_2.207921_g19313_i0 PRJNA1167252 19586 275 2.207921 6.07178275 Timema monikensis 170555 Arthropoda Arthropoda 58.4 5.43e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g19313 i0 97.059 0.327272727272727 34 1 12 0 70 103 168510 168543 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
7967600 7967600 PRJNA1167252_P_NODE_15007_length_317_cov_1.598361_g14734_i0 PRJNA1167252 15007 317 1.598361 5.06680437 Psocidae sp. NKU-003 1216954 Arthropoda Arthropoda 276 1.62e-69   NTclustered gi|399141782|gb|JQ309937.1| 1216954 g14734 i0 90.821 99.4447949526814 207 18 65 1 111 317 4666 4871 Psocidae sp. NKU-003 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 31524 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Psocidae   Psocidae sp. NKU-003
9242277 9242277 PRJNA1167252_P_NODE_16568_length_300_cov_3.436123_g16295_i0 PRJNA1167252 16568 300 3.436123 10.308369 Oropus castaneus 1542260 Arthropoda Arthropoda 438 1.8299999999999998e-118   NTclustered gi|693465081|gb|KJ845131.1| 1542260 g16295 i0 94.7 96.7933333333333 283 14 94 1 16 297 283 1 Oropus castaneus voucher DDM1158 28S ribosomal RNA gene, partial sequence blastn 29038 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Oropus Oropus castaneus
9242466 9242466 PRJNA1167252_P_NODE_22908_length_253_cov_0.866667_g22635_i0 PRJNA1167252 22908 253 0.866667 2.19266751 Halyomorpha halys 286706 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2782026026|ref|XM_014418225.2| 286706 g22635 i0 100 0.110671936758893 28 0 11 0 52 79 911 884 PREDICTED: Halyomorpha halys immunoglobulin domain-containing protein oig-4 (LOC106679211), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
9242598 9242598 PRJNA1167252_P_NODE_28268_length_244_cov_0.912281_g27995_i0 PRJNA1167252 28268 244 0.912281 2.22596564 Bemisia tabaci 7038 Arthropoda Arthropoda 403 5.27e-108   NTclustered gi|1101364055|ref|XM_019052210.1| 7038 g27995 i0 98.678 0.930327868852459 227 3 93 0 18 244 1716 1490 PREDICTED: Bemisia tabaci uncharacterized LOC109037499 (LOC109037499), mRNA blastn 227 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
10518251 10518251 PRJNA1167252_P_NODE_25089_length_249_cov_0.886364_g24816_i0 PRJNA1167252 25089 249 0.886364 2.20704636 Metopolophium dirhodum 44670 Arthropoda Arthropoda 224 4.5099999999999996e-54   NTclustered gi|2621260089|ref|XR_009665293.1| 44670 g24816 i0 84.1 2.46586345381526 239 30 96 3 1 239 997 1227 PREDICTED: Metopolophium dirhodum uncharacterized LOC132951030 (LOC132951030), transcript variant X2, ncRNA blastn 614 224 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
11792943 11792943 PRJNA1167252_P_NODE_16090_length_306_cov_0.892704_g15817_i0 PRJNA1167252 16090 306 0.892704 2.73167424 Heortia vitessoides 1557813 Arthropoda Arthropoda 566 8.239999999999998e-157   NTclustered gi|1899341512|gb|MN788367.1| 1557813 g15817 i0 100 40.1078431372549 306 0 100 0 1 306 369 674 Heortia vitessoides autophagy-related protein 18 (atg18) mRNA, partial cds blastn 12273 566 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Heortia Heortia vitessoides
11793476 11793476 PRJNA1167252_P_NODE_7890_length_456_cov_1.352480_g7617_i0 PRJNA1167252 7890 456 1.35248 6.1673088 Stomoxys calcitrans 35570 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|2573092842|ref|XM_013253665.2| 35570 g7617 i0 100 0.125 29 0 6 0 351 379 1434 1406 PREDICTED: Stomoxys calcitrans spidroin-1 (LOC106088245), mRNA blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
12518563 12518563 PRJNA1167252_P_NODE_19690_length_275_cov_1.024752_g19417_i0 PRJNA1167252 19690 275 1.024752 2.818068 Pteromalidae 7423 Arthropoda Arthropoda 497 2.7e-136   NTclustered gi|1787460780|ref|XR_004228213.1| 7425 g19417 i0 99.273 100 275 2 100 0 1 275 2220 1946 PREDICTED: Nasonia vitripennis large subunit ribosomal RNA (LOC116418092), rRNA blastn 27500 497 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
12518630 12518630 PRJNA1167252_P_NODE_24710_length_250_cov_0.881356_g24437_i0 PRJNA1167252 24710 250 0.881356 2.20339 Curculionidae 7042 Arthropoda Arthropoda 436 5.349999999999999e-118   NTclustered gi|82936777|emb|AJ850004.1| 298155 g24437 i0 98.024 101.164 253 2 100 2 1 250 828 576 Gymnetron antirhini partial 18S rRNA gene blastn 25291 436 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Gymnetron Gymnetron antirhini
14343113 14343113 PRJNA1167252_P_NODE_10192_length_393_cov_0.946875_g9919_i0 PRJNA1167252 10192 393 0.946875 3.72121875 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.038   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g9919 i0 100 0.0712468193384224 28 0 7 0 174 201 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
16342655 16342655 PRJNA1167252_P_NODE_9333_length_413_cov_1.573529_g9060_i0 PRJNA1167252 9333 413 1.573529 6.49867477 Bemisia 7037 Arthropoda Arthropoda 761 0   NTclustered gi|1254338572|gb|KY951450.1| 7038 g9060 i0 100 92.7699757869249 412 0 99 0 2 413 9634 10045 Bemisia tabaci mitochondrion, complete genome blastn 38314 761 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
17617927 17617927 PRJNA1167252_P_NODE_9354_length_412_cov_2.952802_g9081_i0 PRJNA1167252 9354 412 2.952802 12.16554424 Insecta 50557 Arthropoda Arthropoda 141 8.21e-29   NTclustered gi|182240554|gb|EU414717.1| 516494 g9081 i0 83.439 2.35922330097087 157 21 38 4 1 155 3785 3938 Isoperla sp. Plec1 28S ribosomal RNA gene, partial sequence blastn 972 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Plecoptera Perlodidae Isoperla Isoperla sp. SS-2008
18166320 18166320 PRJNA1167252_P_NODE_29775_length_237_cov_2.304878_g29502_i0 PRJNA1167252 29775 237 2.304878 5.46256086 Penaeus vannamei 6689 Arthropoda Arthropoda 438 1.4e-118   NTclustered gi|41059656|gb|AY466348.1| 6689 g29502 i0 100 40.7088607594937 237 0 100 0 1 237 397 633 Litopenaeus vannamei microsatellite TUMXLV10.12 sequence blastn 9648 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
18891573 18891573 PRJNA1167252_P_NODE_30055_length_223_cov_4.746667_g29782_i0 PRJNA1167252 30055 223 4.746667 10.58506741 root 1 Root_unresolved Root_unresolved 412 7.88e-111   NTclustered gi|218526749|gb|EU921005.1| 6689 g29782 i0 100 30.6188340807175 223 0 100 0 1 223 373 595 Litopenaeus vannamei isolate KCpen_a 28S ribosomal RNA gene, partial sequence blastn 6828 412 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
20166136 20166136 PRJNA1167252_P_NODE_14516_length_322_cov_2.819277_g14243_i0 PRJNA1167252 14516 322 2.819277 9.07807194 Timema 61471 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|1936955213|emb|OA567898.1| 61478 g14243 i0 100 0.260869565217391 28 0 9 0 65 92 49402 49375 1_Tdi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
20166158 20166158 PRJNA1167252_P_NODE_15776_length_308_cov_3.314894_g15503_i0 PRJNA1167252 15776 308 3.314894 10.20987352 Coleoptera 7041 Arthropoda Arthropoda 241 5.720000000000001e-59   NTclustered gi|2782661618|gb|PQ129718.1| 245108 g15503 i0 81.23 100.282467532468 309 49 100 7 1 308 2537 2237 Limbodessus bigbellensis voucher R130 large subunit ribosomal RNA gene, partial sequence blastn 30887 241 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Limbodessus Limbodessus bigbellensis
20716174 20716174 PRJNA1167252_P_NODE_7117_length_485_cov_1.682039_g6844_i0 PRJNA1167252 7117 485 1.682039 8.15788915 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g6844 i0 100 3.2659793814433 30 0 6 0 212 241 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1584 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
21441929 21441929 PRJNA1167252_P_NODE_27577_length_245_cov_0.906977_g27304_i0 PRJNA1167252 27577 245 0.906977 2.22209365 Curculionidae 7042 Arthropoda Arthropoda 409 1.1399999999999998e-109   NTclustered gi|228014363|gb|FJ867677.1| 638888 g27304 i0 96.735 103.183673469388 245 8 100 0 1 245 250 6 Cylindrocopturus sp. DDM-2009 28S ribosomal RNA gene, partial sequence blastn 25280 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Cylindrocopturus Cylindrocopturus sp. DDM-2009
21991304 21991304 PRJNA1167252_P_NODE_27598_length_245_cov_0.906977_g27325_i0 PRJNA1167252 27598 245 0.906977 2.22209365 Oppiella nova 334625 Arthropoda Arthropoda 453 5.1900000000000006e-123   NTclustered gi|1962580169|emb|OC914870.1| 334625 g27325 i0 100 21.0326530612245 245 0 100 0 1 245 32706 32462 Oppiella nova blastn 5153 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
24540509 24540509 PRJNA1167252_P_NODE_25100_length_249_cov_0.886364_g24827_i0 PRJNA1167252 25100 249 0.886364 2.20704636 Bemisia tabaci 7038 Arthropoda Arthropoda 422 1.49e-113   NTclustered gi|1101400791|ref|XM_019055946.1| 7038 g24827 i0 99.145 1.87951807228916 234 2 94 0 2 235 617 384 PREDICTED: Bemisia tabaci cuticle protein 8-like (LOC109040131), mRNA blastn 468 422 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci

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