RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA235310 · 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
1056691 1056691 PRJNA235310_P_NODE_6101_length_163_cov_0.912281_g6075_i0 PRJNA235310 6101 163 0.912281 1.48701803 Opisthokonta 33154 Arthropoda Arthropoda 60.2 8.12e-5   NTclustered gi|2202991289|ref|XM_046952111.1| 7375 g6075 i0 90.909 1.15337423312883 44 4 27 0 37 80 5498 5541 PREDICTED: Lucilia cuprina serine-rich adhesin for platelets (LOC111689648), transcript variant X3, mRNA blastn 188 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
1642155 1642155 PRJNA235310_P_NODE_3402_length_205_cov_1.660256_g3376_i0 PRJNA235310 3402 205 1.660256 3.4035248 Drosophila ananassae 7217 Arthropoda Arthropoda 235 1.6599999999999997e-57   NTclustered gi|2119956788|ref|XM_001964495.4| 7217 g3376 i0 87.44 97.6341463414634 207 22 100 3 1 205 858 1062 PREDICTED: Drosophila ananassae V-type proton ATPase subunit B (LOC6505649), mRNA blastn 20015 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae
1642180 1642180 PRJNA235310_P_NODE_5162_length_168_cov_0.873950_g5136_i0 PRJNA235310 5162 168 0.87395 1.468236 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g5136 i0 100 0.178571428571429 30 0 18 0 29 58 14100628 14100599 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
2917993 2917993 PRJNA235310_P_NODE_4603_length_174_cov_1.016000_g4577_i0 PRJNA235310 4603 174 1.016 1.76784 Aphidius gifuensis 684658 Arthropoda Arthropoda 183 4.969999999999999e-42   NTclustered gi|2106733657|ref|XM_044149144.1| 684658 g4577 i0 86.747 78.6781609195402 166 20 95 2 2 166 1400 1236 PREDICTED: Aphidius gifuensis ATP synthase subunit alpha, mitochondrial (LOC122850116), mRNA blastn 13690 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
3607129 3607129 PRJNA235310_P_NODE_6003_length_164_cov_0.904348_g5977_i0 PRJNA235310 6003 164 0.904348 1.48313072 Cydia 82599 Arthropoda Arthropoda 95.3 2.24e-15   NTclustered gi|157814291|gb|EU020950.1| 82600 g5977 i0 93.651 34.0182926829268 63 4 38 0 101 163 824 762 Cydia pomonella clone Cpo58f3 putative clathrin heavy chain mRNA, partial cds blastn 5579 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
4194495 4194495 PRJNA235310_P_NODE_6264_length_162_cov_1.380531_g6238_i0 PRJNA235310 6264 162 1.380531 2.23646022 Anopheles moucheti 186751 Arthropoda Arthropoda 119 1.31e-22   NTclustered gi|2429159714|ref|XM_053035032.1| 186751 g6238 i0 88.66 25.2283950617284 97 11 60 0 16 112 496 592 PREDICTED: Anopheles moucheti tubulin beta-3 chain (LOC128299162), transcript variant X2, mRNA blastn 4087 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles moucheti
5470700 5470700 PRJNA235310_P_NODE_2265_length_258_cov_0.990431_g2239_i0 PRJNA235310 2265 258 0.990431 2.55531198 Diabrotica virgifera 50389 Arthropoda Arthropoda 145 3.7699999999999995e-30   NTclustered gi|2305239034|ref|XM_050648012.1| 50390 g2239 i0 80.628 12.8914728682171 191 34 74 3 52 241 541 353 PREDICTED: Diabrotica virgifera virgifera 60S ribosomal protein L23 (LOC126882935), mRNA blastn 3326 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
5470747 5470747 PRJNA235310_P_NODE_4765_length_170_cov_1.256198_g4739_i0 PRJNA235310 4765 170 1.256198 2.1355366 Henosepilachna vigintioctomaculata 420088 Arthropoda Arthropoda 219 1.3199999999999996e-52   NTclustered gi|2678049038|gb|PP238408.1| 420088 g4739 i0 89.941 95.1 169 17 99 0 1 169 955 1123 Henosepilachna vigintioctomaculata Hsp70cB4i mRNA, complete cds blastn 16167 219 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctomaculata
6745040 6745040 PRJNA235310_P_NODE_4146_length_185_cov_0.955882_g4120_i0 PRJNA235310 4146 185 0.955882 1.7683817 Aethina tumida 116153 Arthropoda Arthropoda 111 2.57e-20   NTclustered gi|2284699683|ref|XM_020015998.2| 116153 g4120 i0 84.821 19.8810810810811 112 16 60 1 14 124 1030 1141 PREDICTED: Aethina tumida puromycin-sensitive aminopeptidase (LOC109599941), transcript variant X1, mRNA blastn 3678 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
6745053 6745053 PRJNA235310_P_NODE_4806_length_169_cov_1.300000_g4780_i0 PRJNA235310 4806 169 1.3 2.197 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 117 4.93e-22   NTclustered gi|2237292786|ref|XM_048141955.1| 1035111 g4780 i0 79.641 7.62130177514793 167 30 98 4 5 169 1428 1264 PREDICTED: Leguminivora glycinivorella probable methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial (LOC125235407), mRNA blastn 1288 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
6745069 6745069 PRJNA235310_P_NODE_6146_length_163_cov_0.912281_g6120_i0 PRJNA235310 6146 163 0.912281 1.48701803 Tenebrio molitor 7067 Arthropoda Arthropoda 97.1 6.19e-16   NTclustered gi|2814367998|ref|XM_069039549.1| 7067 g6120 i0 78.621 0.889570552147239 145 31 89 0 19 163 381 237 PREDICTED: Tenebrio molitor RAS oncogene family member Rab2 (Rab2), mRNA blastn 145 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
9295415 9295415 PRJNA235310_P_NODE_2188_length_264_cov_1.600000_g2162_i0 PRJNA235310 2188 264 1.6 4.224 Aphidius gifuensis 684658 Arthropoda Arthropoda 161 3.84e-35   NTclustered gi|2106745948|ref|XM_044155791.1| 684658 g2162 i0 81.538 3.34848484848485 195 36 74 0 52 246 562 368 PREDICTED: Aphidius gifuensis 40S ribosomal protein S14a-like (LOC122854808), mRNA blastn 884 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
9295452 9295452 PRJNA235310_P_NODE_4368_length_179_cov_1.061538_g4342_i0 PRJNA235310 4368 179 1.061538 1.90015302 Bombus pyrosoma 396416 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2097243538|ref|XM_043742097.1| 396416 g4342 i0 96.875 0.17877094972067 32 1 18 0 4 35 537 568 PREDICTED: Bombus pyrosoma peptidyl-prolyl cis-trans isomerase B-like (LOC122574462), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus pyrosoma
9295468 9295468 PRJNA235310_P_NODE_5708_length_165_cov_0.896552_g5682_i0 PRJNA235310 5708 165 0.896552 1.4793108 Drosophila novamexicana 47314 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1732868891|ref|XM_030707165.1| 47314 g5682 i0 100 0.175757575757576 29 0 18 0 54 82 3576 3548 PREDICTED: Drosophila novamexicana mucin-5AC (LOC115764247), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila novamexicana
10571369 10571369 PRJNA235310_P_NODE_1009_length_397_cov_3.313218_g983_i0 PRJNA235310 1009 397 3.313218 13.15347546 Chelidurella thaleri 2546182 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g983 i0 100 0.0755667506297229 30 0 8 0 263 292 26066733 26066762 Chelidura thaleri genome assembly, chromosome: 3 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
10571390 10571390 PRJNA235310_P_NODE_1889_length_288_cov_2.075314_g1863_i0 PRJNA235310 1889 288 2.075314 5.97690432 Hydrometra stagnorum 446445 Arthropoda Arthropoda 348 3.0300000000000004e-91   NTclustered gi|1131051030|gb|KX821841.1| 446445 g1863 i0 98.969 1.29861111111111 194 2 67 0 58 251 1433 1240 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 374 348 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
11845949 11845949 PRJNA235310_P_NODE_4350_length_179_cov_1.384615_g4324_i0 PRJNA235310 4350 179 1.384615 2.47846085 Timema cristinae 61476 Arthropoda Arthropoda 58.4 3.26e-4   NTclustered gi|1947186551|emb|OC452010.1| 61476 g4324 i0 89.362 0.424581005586592 47 3 26 2 118 164 238 194 3_Tce_b3v08 blastn 76 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
12535224 12535224 PRJNA235310_P_NODE_1270_length_358_cov_1.508091_g1244_i0 PRJNA235310 1270 358 1.508091 5.39896578 Opisthokonta 33154 Arthropoda Arthropoda 339 2.32e-88   NTclustered gi|1510347979|ref|XM_002020282.2| 7234 g1244 i0 83.944 97.4162011173184 355 55 99 2 1 354 1028 1381 PREDICTED: Drosophila persimilis V-type proton ATPase subunit B (LOC6594950), mRNA blastn 34875 340 0.997058823529412 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila persimilis
12535225 12535225 PRJNA235310_P_NODE_1330_length_350_cov_1.049834_g1304_i0 PRJNA235310 1330 350 1.049834 3.674419 Insecta 50557 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|1418070092|ref|XM_011266903.3| 104421 g1304 i0 100 0.32 28 0 8 0 81 108 1098 1071 PREDICTED: Camponotus floridanus calmodulin (LOC105256720), transcript variant X3, mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Camponotus Camponotus floridanus
13121216 13121216 PRJNA235310_P_NODE_671_length_474_cov_1.908235_g645_i0 PRJNA235310 671 474 1.908235 9.0450339 Megachile rotundata 143995 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|805762148|ref|XM_012298808.1| 143995 g645 i0 94.286 0.147679324894515 35 2 7 0 377 411 411 445 PREDICTED: Megachile rotundata cathepsin L (LOC100883762), transcript variant X2, mRNA blastn 70 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megachilidae Megachile Megachile rotundata
13810058 13810058 PRJNA235310_P_NODE_4691_length_171_cov_1.475410_g4665_i0 PRJNA235310 4691 171 1.47541 2.5229511 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|780676060|ref|XM_011698144.1| 64793 g4665 i0 100 2.78362573099415 28 0 16 0 64 91 639 666 PREDICTED: Wasmannia auropunctata uncharacterized LOC105455089 (LOC105455089), mRNA blastn 476 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Wasmannia Wasmannia auropunctata
14396421 14396421 PRJNA235310_P_NODE_4012_length_188_cov_1.726619_g3986_i0 PRJNA235310 4012 188 1.726619 3.24604372 Anopheles bellator 139047 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|2547166095|ref|XM_058207431.1| 139047 g3986 i0 100 0.148936170212766 28 0 15 0 65 92 1388 1415 PREDICTED: Anopheles bellator all trans-polyprenyl-diphosphate synthase PDSS1 (LOC131213396), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles bellator
15670117 15670117 PRJNA235310_P_NODE_1053_length_390_cov_1.589443_g1027_i0 PRJNA235310 1053 390 1.589443 6.1988277 Cyprideis torosa 163714 Arthropoda Arthropoda 130 1.67e-25   NTclustered gi|1936417594|emb|OB660025.1| 163714 g1027 i0 94.186 22.8461538461538 86 4 22 1 118 202 84544 84629 Cyprideis torosa blastn 8910 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
15670131 15670131 PRJNA235310_P_NODE_1593_length_318_cov_1.933086_g1567_i0 PRJNA235310 1593 318 1.933086 6.14721348 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919531121|emb|OZ238343.1| 1002887 g1567 i0 100 0.0911949685534591 29 0 9 0 237 265 15806096 15806124 Glaucopsyche melanops genome assembly, chromosome: 2 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
15670188 15670188 PRJNA235310_P_NODE_5333_length_167_cov_0.881356_g5307_i0 PRJNA235310 5333 167 0.881356 1.47186452 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2920024485|emb|OZ239128.1| 3086104 g5307 i0 100 0.167664670658683 28 0 17 0 42 69 33702581 33702608 Leiobunum subalpinum genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
16944636 16944636 PRJNA235310_P_NODE_2474_length_245_cov_1.678571_g2448_i0 PRJNA235310 2474 245 1.678571 4.11249895 Pollicipes pollicipes 41117 Arthropoda Arthropoda 137 5.93e-28   NTclustered gi|1929142475|ref|XM_037226053.1| 41117 g2448 i0 81.176 4.61224489795918 170 32 69 0 59 228 1104 935 PREDICTED: Pollicipes pollicipes rRNA 2'-O-methyltransferase fibrillarin-like (LOC119102609), mRNA blastn 1130 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
18219045 18219045 PRJNA235310_P_NODE_3855_length_192_cov_1.734266_g3829_i0 PRJNA235310 3855 192 1.734266 3.32979072 Ixodes scapularis 6945 Arthropoda Arthropoda 128 2.67e-25   NTclustered gi|2064669464|ref|XM_029986925.4| 6945 g3829 i0 82.639 13.453125 144 25 75 0 49 192 1634 1491 PREDICTED: Ixodes scapularis phosphoenolpyruvate carboxykinase, cytosolic [GTP] (LOC8024859), mRNA blastn 2583 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
20768931 20768931 PRJNA235310_P_NODE_697_length_467_cov_1.703349_g671_i0 PRJNA235310 697 467 1.703349 7.95463983 Drosophila ananassae 7217 Arthropoda Arthropoda 331 5.21e-86   NTclustered gi|2119969912|ref|XM_001961129.4| 7217 g671 i0 79.914 57.6959314775161 463 83 98 9 3 460 1713 2170 PREDICTED: Drosophila ananassae transitional endoplasmic reticulum ATPase TER94 (LOC6494000), transcript variant X3, mRNA blastn 26944 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae

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