RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJNA1013345" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1013345 · 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
158430 158430 PRJNA1013345_P_NODE_31601_length_157_cov_1.854545_g31471_i0 PRJNA1013345 31601 157 1.854545 2.91163565 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g31471 i0 100 0.178343949044586 28 0 18 0 127 154 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
1433206 1433206 PRJNA1013345_P_NODE_3142_length_329_cov_3.656028_g3014_i0 PRJNA1013345 3142 329 3.656028 12.02833212 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1685550242|ref|XM_008180416.3| 7029 g3014 i0 94.444 0.547112462006079 36 2 11 0 127 162 1159 1194 PREDICTED: Acyrthosiphon pisum uncharacterized LOC100572328 (LOC100572328), transcript variant X3, mRNA blastn 180 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
2277628 2277628 PRJNA1013345_P_NODE_17062_length_178_cov_1.396947_g16932_i0 PRJNA1013345 17062 178 1.396947 2.48656566 root 1 Root_unresolved Root_unresolved 318 1.34e-82   NTclustered gi|78190082|gb|AC168047.3| 7176 g16932 i0 98.876 32 178 2 100 0 1 178 95322 95499 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 5696 318 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
3984846 3984846 PRJNA1013345_P_NODE_25064_length_163_cov_1.758621_g24934_i0 PRJNA1013345 25064 163 1.758621 2.86655223 Trichogramma pretiosum 7493 Arthropoda Arthropoda 296 5.68e-76   NTclustered gi|1321331389|ref|XM_014378866.2| 7493 g24934 i0 99.387 9 163 1 100 0 1 163 4831 4993 PREDICTED: Trichogramma pretiosum protein retinal degeneration B (LOC106657374), transcript variant X3, mRNA blastn 1467 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
6536515 6536515 PRJNA1013345_P_NODE_24606_length_164_cov_0.871795_g24476_i0 PRJNA1013345 24606 164 0.871795 1.4297438 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 185 1.2899999999999997e-42   NTclustered gi|2492487781|ref|XM_055459044.1| 263140 g24476 i0 92.913 1.54878048780488 127 9 77 0 2 128 3355 3481 PREDICTED: Sitodiplosis mosellana myosin-I heavy chain (LOC129575429), transcript variant X1, mRNA blastn 254 185 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
9085860 9085860 PRJNA1013345_P_NODE_23768_length_165_cov_0.864407_g23638_i0 PRJNA1013345 23768 165 0.864407 1.42627155 Trichogramma pretiosum 7493 Arthropoda Arthropoda 265 1.6299999999999998e-66   NTclustered gi|1321345649|ref|XM_014376896.2| 7493 g23638 i0 98.026 0.921212121212121 152 3 92 0 2 153 1371 1220 PREDICTED: Trichogramma pretiosum A disintegrin and metalloproteinase with thrombospondin motifs 15-like (LOC106656182), mRNA blastn 152 265 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
9930511 9930511 PRJNA1013345_P_NODE_18328_length_175_cov_1.593750_g18198_i0 PRJNA1013345 18328 175 1.59375 2.7890625 Euwallacea 124011 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2753838490|ref|XM_066285739.1| 995702 g18198 i0 96.875 2.56 32 1 18 0 132 163 10924 10955 PREDICTED: Euwallacea fornicatus Ecdysone-induced protein 93F (Eip93F), transcript variant X3, mRNA blastn 448 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
10361555 10361555 PRJNA1013345_P_NODE_24409_length_164_cov_0.871795_g24279_i0 PRJNA1013345 24409 164 0.871795 1.4297438 Megaselia scalaris 36166 Arthropoda Arthropoda 298 1.59e-76   NTclustered gi|425869822|gb|KC177721.1| 36166 g24279 i0 99.39 102.036585365854 164 1 100 0 1 164 2232 2395 Megaselia scalaris 28S ribosomal RNA gene, partial sequence blastn 16734 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Phoridae Megaselia Megaselia scalaris
11637122 11637122 PRJNA1013345_P_NODE_4430_length_284_cov_3.641350_g4301_i0 PRJNA1013345 4430 284 3.64135 10.341434 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g4301 i0 100 0.0985915492957746 28 0 10 0 36 63 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
15461084 15461084 PRJNA1013345_P_NODE_31333_length_158_cov_0.873874_g31203_i0 PRJNA1013345 31333 158 0.873874 1.38072092 Oppiella nova 334625 Arthropoda Arthropoda 272 9.21e-69   NTclustered gi|1962580694|emb|OC914905.1| 334625 g31203 i0 98.077 1.9746835443038 156 3 99 0 3 158 15292 15447 Oppiella nova blastn 312 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
20559403 20559403 PRJNA1013345_P_NODE_18737_length_174_cov_1.606299_g18607_i0 PRJNA1013345 18737 174 1.606299 2.79496026 Ablabesmyia monilis 700369 Arthropoda Arthropoda 239 1.05e-58   NTclustered gi|2911520897|gb|OP006242.1| 700369 g18607 i0 91.379 83.7931034482759 174 15 100 0 1 174 12784 12611 Ablabesmyia monilis mitochondrion, complete genome blastn 14580 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Ablabesmyia Ablabesmyia monilis
20559535 20559535 PRJNA1013345_P_NODE_25917_length_162_cov_2.660870_g25787_i0 PRJNA1013345 25917 162 2.66087 4.3106094 Trichogramma pretiosum 7493 Arthropoda Arthropoda 102 1.32e-17   NTclustered gi|936714641|ref|XR_001339526.1| 7493 g25787 i0 100 0.722222222222222 55 0 34 0 91 145 55 1 PREDICTED: Trichogramma pretiosum uncharacterized LOC106658006 (LOC106658006), ncRNA blastn 117 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
21835335 21835335 PRJNA1013345_P_NODE_5998_length_250_cov_2.004926_g5868_i0 PRJNA1013345 5998 250 2.004926 5.012315 Bombyx mori 7091 Arthropoda Arthropoda 60.2 1.35e-4   NTclustered gi|2919985619|emb|OZ208592.1| 7091 g5868 i0 97.143 0.14 35 1 14 0 215 249 8289298 8289332 Bombyx mori genome assembly, chromosome: 14 blastn 35 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
23110670 23110670 PRJNA1013345_P_NODE_27219_length_161_cov_1.771930_g27089_i0 PRJNA1013345 27219 161 1.77193 2.8528073 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g27089 i0 100 0.173913043478261 28 0 17 0 108 135 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
24384256 24384256 PRJNA1013345_P_NODE_15120_length_182_cov_1.703704_g14990_i0 PRJNA1013345 15120 182 1.703704 3.10074128 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 108 3.26e-19   NTclustered gi|2492490382|ref|XR_008688842.1| 263140 g14990 i0 89.412 1.00549450549451 85 9 47 0 98 182 700 616 PREDICTED: Sitodiplosis mosellana uncharacterized LOC129575901 (LOC129575901), ncRNA blastn 183 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
24384501 24384501 PRJNA1013345_P_NODE_28860_length_160_cov_0.902655_g28730_i0 PRJNA1013345 28860 160 0.902655 1.444248 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|1963819186|emb|OC936887.1| 334625 g28730 i0 100 0.175 28 0 18 0 99 126 1910 1883 Oppiella nova blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
26813374 26813374 PRJNA1013345_P_NODE_19561_length_172_cov_2.112000_g19431_i0 PRJNA1013345 19561 172 2.112 3.63264 Penaeus vannamei 6689 Arthropoda Arthropoda 42.7 0.0145   NR ROT81340.1 6689 g19431 i0 42.3 0.906976744186046 52 25 82 2 162 22 164 215 ROT81340.1 hypothetical protein C7M84_025522 [Penaeus vannamei] diamond 156 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27224342 27224342 PRJNA1013345_P_NODE_25463_length_163_cov_0.879310_g25333_i0 PRJNA1013345 25463 163 0.87931 1.4332753 Myzus persicae 13164 Arthropoda Arthropoda 88.2 1.18e-18   NR XP_022181206.1 13164 g25333 i0 73.6 11.7055214723926 53 14 97.5 0 161 3 599 651 XP_022181206.1 uncharacterized protein LOC111041284 [Myzus persicae] diamond 1908 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
27761715 27761715 PRJNA1013345_P_NODE_15644_length_181_cov_1.522388_g15514_i0 PRJNA1013345 15644 181 1.522388 2.75552228 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 99 2.1e-25   NR CAI6360126.1 13131 g15514 i0 85.5 1.8232044198895 55 8 91.2 0 165 1 1 55 CAI6360126.1 unnamed protein product [Macrosiphum euphorbiae] diamond 330 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
28077080 28077080 PRJNA1013345_P_NODE_23645_length_165_cov_0.864407_g23515_i0 PRJNA1013345 23645 165 0.864407 1.42627155 Temnothorax curvispinosus 300111 Arthropoda Arthropoda 41.2 0.0249   NR XP_024870424.1 300111 g23515 i0 52.9 0.618181818181818 34 16 61.8 0 104 3 1 34 XP_024870424.1 uncharacterized protein LOC112453747, partial [Temnothorax curvispinosus] diamond 102 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Temnothorax Temnothorax curvispinosus
29079862 29079862 PRJNA1013345_P_NODE_26528_length_162_cov_0.886957_g26398_i0 PRJNA1013345 26528 162 0.886957 1.43687034 Insecta 50557 Arthropoda Arthropoda 56.2 1.73e-7   NR AAB33736.1 6973 g26398 i0 87.5 122.148148148148 32 3 57.4 1 95 3 25 56 AAB33736.1 GABA receptor Rdl 4 subunit, partial [Blattella germanica] diamond 19788 56.6 0.992932862190813 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
29332386 29332386 PRJNA1013345_P_NODE_20549_length_170_cov_1.658537_g20419_i0 PRJNA1013345 20549 170 1.658537 2.8195129 Insecta 50557 Arthropoda Arthropoda 61.2 2.04e-10   NR GLG99693.1 6999 g20419 i0 50.9 2.94705882352941 55 27 97.1 0 5 169 11 65 GLG99693.1 uncharacterized protein GBIM_06098 [Gryllus bimaculatus] diamond 501 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
29845320 29845320 PRJNA1013345_P_NODE_27211_length_161_cov_1.789474_g27081_i0 PRJNA1013345 27211 161 1.789474 2.88105314 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 102 1.16e-23   NR XP_055309135.1 263140 g27081 i0 92.5 0.987577639751553 53 4 98.8 0 2 160 71 123 XP_055309135.1 E3 UFM1-protein ligase 1 homolog [Sitodiplosis mosellana] diamond 159 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
30034965 30034965 PRJNA1013345_P_NODE_16471_length_179_cov_1.545455_g16341_i0 PRJNA1013345 16471 179 1.545455 2.76636445 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 67.4 3.14e-11   NR XP_055300236.1 263140 g16341 i0 96.7 0.50279329608938494 30 1 50.3 0 90 1 468 497 XP_055300236.1 uncharacterized protein LOC129567402 isoform X2 [Sitodiplosis mosellana] diamond 90 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
30097974 30097974 PRJNA1013345_P_NODE_28552_length_160_cov_0.902655_g28422_i0 PRJNA1013345 28552 160 0.902655 1.444248 Contarinia nasturtii 265458 Arthropoda Arthropoda 63.2 7.58e-10   NR XP_031637717.1 265458 g28422 i0 50 0.975 52 26 97.5 0 5 160 372 423 XP_031637717.1 uncharacterized protein LOC116350124, partial [Contarinia nasturtii] diamond 156 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
30563917 30563917 PRJNA1013345_P_NODE_32533_length_157_cov_0.863636_g32403_i0 PRJNA1013345 32533 157 0.863636 1.35590852 Anopheles 7164 Arthropoda Arthropoda 42.7 0.0114   NR XP_049284220.1 62324 g32403 i0 77.4 3.15286624203822 31 6 57.3 1 66 155 571 601 XP_049284220.1 serine-rich adhesin for platelets-like isoform X2 [Anopheles funestus] diamond 495 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles funestus
30753829 30753829 PRJNA1013345_P_NODE_24214_length_164_cov_1.358974_g24084_i0 PRJNA1013345 24214 164 1.358974 2.22871736 Aphididae 27482 Arthropoda Arthropoda 77.4 7.64e-15   NR XP_029347289.1 7029 g24084 i0 75.9 2.96341463414634 54 13 98.8 0 163 2 1279 1332 XP_029347289.1 uncharacterized protein LOC100167295 [Acyrthosiphon pisum] diamond 486 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
31362226 31362226 PRJNA1013345_P_NODE_27216_length_161_cov_1.780702_g27086_i0 PRJNA1013345 27216 161 1.780702 2.86693022 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 96.3 1.7e-21   NR XP_055305979.1 263140 g27086 i0 82.7 0.968944099378882 52 9 96.9 0 1 156 566 617 XP_055305979.1 zinc finger protein 271-like [Sitodiplosis mosellana] diamond 156 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
31646525 31646525 PRJNA1013345_P_NODE_27757_length_161_cov_0.894737_g27627_i0 PRJNA1013345 27757 161 0.894737 1.44052657 Phlebotomus argentipes 94469 Arthropoda Arthropoda 56.6 1.54e-7   NR XP_059622766.1 94469 g27627 i0 52.9 0.950310559006211 51 24 95 0 2 154 421 471 XP_059622766.1 nucleolar protein 9 [Phlebotomus argentipes] diamond 153 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus argentipes
31709999 31709999 PRJNA1013345_P_NODE_10217_length_204_cov_2.133758_g10087_i0 PRJNA1013345 10217 204 2.133758 4.35286632 Bacillus rossius redtenbacheri 93214 Arthropoda Arthropoda 47.4 5.18e-4   NR XP_063231910.1 93214 g10087 i0 43.5 0.911764705882353 62 31 91.2 3 16 201 3 60 XP_063231910.1 mucin-5AC-like isoform X6 [Bacillus rossius redtenbacheri] diamond 186 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
32279671 32279671 PRJNA1013345_P_NODE_27499_length_161_cov_0.894737_g27369_i0 PRJNA1013345 27499 161 0.894737 1.44052657 Rhipicephalus sanguineus 34632 Arthropoda Arthropoda 53.1 1.73e-6   NR XP_049274519.1 34632 g27369 i0 59.5 0.68944099378882 37 15 68.9 0 26 136 65 101 XP_049274519.1 zinc finger protein 436-like isoform X2 [Rhipicephalus sanguineus] diamond 111 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus
32406111 32406111 PRJNA1013345_P_NODE_33239_length_154_cov_2.355140_g33109_i0 PRJNA1013345 33239 154 2.35514 3.6269156 Trichogramma brassicae 86971 Arthropoda Arthropoda 86.3 5.12e-18   NR CAB0043339.1 86971 g33109 i0 90 0.974025974025974 50 5 97.4 0 2 151 659 708 CAB0043339.1 unnamed protein product [Trichogramma brassicae] diamond 150 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma brassicae
32627093 32627093 PRJNA1013345_P_NODE_13520_length_186_cov_1.273381_g13390_i0 PRJNA1013345 13520 186 1.273381 2.36848866 Ochlerotatus camptorhynchus 644619 Arthropoda Arthropoda 72.8 2.28e-13   NR XP_065079421.1 644619 g13390 i0 56.7 6.79032258064516 60 25 96.8 1 2 181 148 206 XP_065079421.1 uncharacterized protein LOC135702321 [Ochlerotatus camptorhynchus] diamond 1263 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus camptorhynchus

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