RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA728642" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA728642 · 33 ✖

analysis 1

  • blastn · 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
1194911 1194911 PRJNA728642_P_NODE_16401_length_249_cov_1.829545_g16130_i0 PRJNA728642 16401 249 1.829545 4.55556705 Psychodidae 7197 Arthropoda Arthropoda 285 2.0399999999999997e-72   NTclustered gi|1128619224|gb|KX356025.1| 252620 g16130 i0 96.512 71.2088353413655 172 6 69 0 78 249 1432 1603 Nyssomyia flaviscutellata 28S ribosomal RNA gene, partial sequence blastn 17731 285 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Nyssomyia Nyssomyia flaviscutellata
1988797 1988797 PRJNA728642_P_NODE_14502_length_264_cov_1.146597_g14231_i0 PRJNA728642 14502 264 1.146597 3.02701608 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 483 7.219999999999998e-132   NTclustered gi|1912461452|gb|MN857506.1| 59818 g14231 i0 99.621 23.2159090909091 264 1 100 0 1 264 4273 4536 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 6129 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
1989047 1989047 PRJNA728642_P_NODE_9482_length_330_cov_3.105058_g9211_i0 PRJNA728642 9482 330 3.105058 10.2466914 Psychoda cinerea 7202 Arthropoda Arthropoda 462 1.21e-125   NTclustered gi|2190490|emb|X93386.1| 7202 g9211 i0 95.819 91.2666666666667 287 11 87 1 38 323 1 287 P.cinerea 28S rRNA gene, expansion segment D1 blastn 30118 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Psychoda Psychoda cinerea
2470227 2470227 PRJNA728642_P_NODE_14542_length_263_cov_1.621053_g14271_i0 PRJNA728642 14542 263 1.621053 4.26336939 Artemia 6660 Arthropoda Arthropoda 481 2.58e-131   NTclustered gi|511347781|ref|NC_021383.1| 351233 g14271 i0 99.62 26.8593155893536 263 1 100 0 1 263 8017 8279 Artemia tibetiana mitochondrion, complete genome blastn 7064 481 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
2470377 2470377 PRJNA728642_P_NODE_4082_length_513_cov_3.990909_g3811_i0 PRJNA728642 4082 513 3.990909 20.47336317 Tyrophagus 41443 Arthropoda Arthropoda 931 0   NTclustered gi|66390978|gb|DQ025510.1| 59818 g3811 i0 99.415 93.8830409356725 513 3 100 0 1 513 532 1044 Tyrophagus putrescentiae 18S ribosomal RNA gene, partial sequence blastn 48162 931 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
3264030 3264030 PRJNA728642_P_NODE_12323_length_287_cov_1.439252_g12052_i0 PRJNA728642 12323 287 1.439252 4.13065324 Stratiolaelaps sp. AD1286 2051769 Arthropoda Arthropoda 481 2.86e-131   NTclustered gi|1282187764|gb|KY921969.1| 2051769 g12052 i0 96.864 50.6620209059233 287 9 100 0 1 287 2302 2016 Stratiolaelaps sp. AD1286 voucher UMMZ BMOC 08-0807-006 AD1286 28S ribosomal RNA gene, partial sequence blastn 14540 481 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Stratiolaelaps Stratiolaelaps sp. AD1286
3264046 3264046 PRJNA728642_P_NODE_13303_length_276_cov_1.137931_g13032_i0 PRJNA728642 13303 276 1.137931 3.14068956 Armadillidium sp. JM-2004 307035 Arthropoda Arthropoda 510 3.48e-140   NTclustered gi|56968006|gb|AY859552.1| 307035 g13032 i0 100 56.8695652173913 276 0 100 0 1 276 172 447 Armadillidium sp. JM-2004 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 15696 510 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium sp. JM-2004
3264118 3264118 PRJNA728642_P_NODE_16783_length_248_cov_1.760000_g16512_i0 PRJNA728642 16783 248 1.76 4.3648 Psychomora mycophila 1588170 Arthropoda Arthropoda 333 7.149999999999999e-87   NTclustered gi|743621727|gb|KP288816.1| 1588170 g16512 i0 91.093 7.49193548387097 247 21 99 1 1 247 371 616 Psychomora mycophila 28S ribosomal RNA gene, partial sequence blastn 1858 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Psychomora Psychomora mycophila
5023250 5023250 PRJNA728642_P_NODE_1984_length_741_cov_1.907186_g1727_i0 PRJNA728642 1984 741 1.907186 14.13224826 Hemiptera 7524 Arthropoda Arthropoda 246 3.17e-60   NTclustered gi|306489308|gb|HM233853.1| 871510 g1727 i0 92.045 23.7354925775978 176 12 24 2 567 741 10 184 Prolivatis hainanensis isolate 195 28S ribosomal RNA gene, partial sequence blastn 17588 246 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Prolivatis Prolivatis hainanensis
5816471 5816471 PRJNA728642_P_NODE_16705_length_249_cov_0.875000_g16434_i0 PRJNA728642 16705 249 0.875 2.17875 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g16434 i0 94.595 0.594377510040161 37 0 14 2 151 185 8462 8498 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
5816610 5816610 PRJNA728642_P_NODE_5865_length_424_cov_5.860399_g5594_i0 PRJNA728642 5865 424 5.860399 24.84809176 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 784 0   NTclustered gi|1912461452|gb|MN857506.1| 59818 g5594 i0 100 90.0896226415094 424 0 100 0 1 424 7618 7195 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 38198 784 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
6298937 6298937 PRJNA728642_P_NODE_14025_length_269_cov_0.892857_g13754_i0 PRJNA728642 14025 269 0.892857 2.40178533 Aphididae 27482 Arthropoda Arthropoda 481 2.65e-131   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g13754 i0 98.885 95.3754646840149 269 3 100 0 1 269 3963 3695 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 25656 481 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
6299212 6299212 PRJNA728642_P_NODE_8585_length_347_cov_2.354015_g8314_i0 PRJNA728642 8585 347 2.354015 8.16843205 Insecta 50557 Arthropoda Arthropoda 220 8.51e-53   NTclustered gi|669819564|gb|KF525555.1| 798389 g8314 i0 79.938 77.3112391930836 324 46 92 16 3 322 760 452 Enderleinia bispina voucher 09-11-01-66 28S ribosomal RNA gene, partial sequence blastn 26827 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Machaerotidae Enderleinia Enderleinia bispina
7572736 7572736 PRJNA728642_P_NODE_13666_length_272_cov_1.547739_g13395_i0 PRJNA728642 13666 272 1.547739 4.20985008 Taylorilygus 567444 Arthropoda Arthropoda 503 5.729999999999998e-138   NTclustered gi|1394787871|gb|MH426835.1| 763236 g13395 i0 100 100.647058823529 272 0 100 0 1 272 449 178 Taylorilygus apicalis voucher UNSW_ENT 00027682 small subunit ribosomal RNA gene, partial sequence blastn 27376 503 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Taylorilygus Taylorilygus apicalis
7572771 7572771 PRJNA728642_P_NODE_15246_length_256_cov_1.497268_g14975_i0 PRJNA728642 15246 256 1.497268 3.83300608 Drosophila 7215 Arthropoda Arthropoda 473 4.189999999999999e-129   NTclustered gi|1829471572|ref|XR_004460481.1| 7226 g14975 i0 100 100 256 0 100 0 1 256 1976 2231 PREDICTED: Drosophila mauritiana large subunit ribosomal RNA (LOC117149730), rRNA blastn 25600 473 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
8366053 8366053 PRJNA728642_P_NODE_14967_length_259_cov_1.311828_g14696_i0 PRJNA728642 14967 259 1.311828 3.39763452 Aphis citricidus 223852 Arthropoda Arthropoda 457 4.279999999999999e-124   NTclustered gi|29028559|gb|AY216697.1| 223852 g14696 i0 98.456 43.8957528957529 259 4 100 0 1 259 856 1114 Toxoptera citricida 18S ribosomal RNA gene, complete sequence blastn 11369 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis citricidus
10917046 10917046 PRJNA728642_P_NODE_7009_length_386_cov_1.386581_g6738_i0 PRJNA728642 7009 386 1.386581 5.35220266 Zophobas morio 2755281 Arthropoda Arthropoda 403 8.83e-108   NTclustered gi|2705234672|ref|XR_010278514.1| 2755281 g6738 i0 85.825 150.497409326425 388 45 100 9 1 386 3621 4000 PREDICTED: Zophobas morio large subunit ribosomal RNA (LOC135120121), rRNA blastn 58092 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
12674472 12674472 PRJNA728642_P_NODE_14710_length_261_cov_2.356383_g14439_i0 PRJNA728642 14710 261 2.356383 6.15015963 Chironomus 7150 Arthropoda Arthropoda 422 1.57e-113   NTclustered gi|1834412|emb|X99212.1| 7153 g14439 i0 95.785 79.9080459770115 261 11 100 0 1 261 3431 3171 Chironomus tentans partial 18S rRNA gene, 5.8S rRNA gene, partial 28S rRNA gene, internal transcribed spacers 1 and 2 and intergenic spacer blastn 20856 422 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
13466570 13466570 PRJNA728642_P_NODE_17891_length_245_cov_1.406977_g17620_i0 PRJNA728642 17891 245 1.406977 3.44709365 Armadillidium sp. JM-2004 307035 Arthropoda Arthropoda 448 2.41e-121   NTclustered gi|56968006|gb|AY859552.1| 307035 g17620 i0 99.592 3.67755102040816 245 1 100 0 1 245 1039 795 Armadillidium sp. JM-2004 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 901 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium sp. JM-2004
13466723 13466723 PRJNA728642_P_NODE_7971_length_361_cov_2.076389_g7700_i0 PRJNA728642 7971 361 2.076389 7.49576429 Chironomus sp. 7152 Arthropoda Arthropoda 497 3.66e-136   NTclustered gi|2485418712|gb|OQ813480.1| 7152 g7700 i0 91.736 103.831024930748 363 23 100 6 1 361 1727 1370 Chironomus sp. isolate OVO4158 small subunit ribosomal RNA gene, partial sequence blastn 37483 497 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
16015312 16015312 PRJNA728642_P_NODE_16073_length_250_cov_1.632768_g15802_i0 PRJNA728642 16073 250 1.632768 4.08192 Culicoides brevitarsis 469753 Arthropoda Arthropoda 401 1.9499999999999994e-107   NTclustered gi|2701292674|ref|XR_010162285.1| 469753 g15802 i0 95.618 71.904 251 9 100 2 1 250 3374 3623 PREDICTED: Culicoides brevitarsis large subunit ribosomal RNA (LOC134836404), rRNA blastn 17976 401 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
16015493 16015493 PRJNA728642_P_NODE_6833_length_391_cov_2.867925_g6562_i0 PRJNA728642 6833 391 2.867925 11.21358675 Bemisia tabaci 7038 Arthropoda Arthropoda 701 0   NTclustered gi|694036|gb|U20401.1|BTU20401 7038 g6562 i0 98.977 54.4245524296675 391 4 100 0 1 391 20 410 Bemisia tabaci 18S small subunit ribosomal RNA, partial sequence blastn 21280 701 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
17290715 17290715 PRJNA728642_P_NODE_10794_length_308_cov_2.702128_g10523_i0 PRJNA728642 10794 308 2.702128 8.32255424 Eufallia seminivea 3388317 Arthropoda Arthropoda 564 2.99e-156   NTclustered gi|162072878|gb|EU164645.1| 3388317 g10523 i0 99.675 103.016233766234 308 1 100 0 1 308 2321 2014 Eufallia seminiveus isolate CO484 28S ribosomal RNA gene, partial sequence blastn 31729 564 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Latridiidae Eufallia Eufallia seminivea
17290988 17290988 PRJNA728642_P_NODE_5694_length_431_cov_1.290503_g5423_i0 PRJNA728642 5694 431 1.290503 5.56206793 Proctolaelaps sp. 1 NFS-2015 1609181 Arthropoda Arthropoda 675 0   NTclustered gi|758838498|gb|KM979683.1| 1609181 g5423 i0 94.896 100.162412993039 431 22 100 0 1 431 220 650 Proctolaelaps sp. 1 NFS-2015 voucher MZLQ15640 28S ribosomal RNA gene, partial sequence blastn 43170 675 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Ascidae Proctolaelaps Proctolaelaps sp. 1 NFS-2015
18564618 18564618 PRJNA728642_P_NODE_19075_length_242_cov_1.366864_g18804_i0 PRJNA728642 19075 242 1.366864 3.30781088 Armadillidium sp. JM-2004 307035 Arthropoda Arthropoda 132 2.7200000000000003e-26   NTclustered gi|56968007|gb|AY859553.1| 307035 g18804 i0 98.649 0.305785123966942 74 1 31 0 169 242 2447 2374 Armadillidium sp. JM-2004 28S ribosomal RNA gene, partial sequence blastn 74 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium sp. JM-2004
19839654 19839654 PRJNA728642_P_NODE_10636_length_311_cov_1.273109_g10365_i0 PRJNA728642 10636 311 1.273109 3.95936899 Cartodere constricta 1531405 Arthropoda Arthropoda 148 3.5999999999999996e-31   NTclustered gi|2620251915|gb|OR799814.1| 1531405 g10365 i0 89.744 42.7234726688103 117 11 38 1 195 311 720 605 Cartodere constricta isolate CcT1 large subunit ribosomal RNA gene, partial sequence blastn 13287 148 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Latridiidae Cartodere Cartodere constricta
20321673 20321673 PRJNA728642_P_NODE_9276_length_334_cov_1.586207_g9005_i0 PRJNA728642 9276 334 1.586207 5.29793138 Chironomus 7150 Arthropoda Arthropoda 579 1.1699999999999997e-160   NTclustered gi|2486656239|gb|OQ819027.1| 7152 g9005 i0 97.904 92.9790419161677 334 7 100 0 1 334 34 367 Chironomus sp. isolate OVO4158 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 31055 579 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
22390177 22390177 PRJNA728642_P_NODE_11758_length_294_cov_1.850679_g11487_i0 PRJNA728642 11758 294 1.850679 5.44099626 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 544 3.69e-150   NTclustered gi|1912461452|gb|MN857506.1| 59818 g11487 i0 100 85.9455782312925 294 0 100 0 1 294 4137 3844 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 25268 544 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
22390286 22390286 PRJNA728642_P_NODE_16658_length_249_cov_0.875000_g16387_i0 PRJNA728642 16658 249 0.875 2.17875 Bemisia tabaci 7038 Arthropoda Arthropoda 204 5.879999999999999e-48   NTclustered gi|1101384064|ref|XM_019053207.1| 7038 g16387 i0 95.312 7.09638554216868 128 6 51 0 24 151 828 955 PREDICTED: Bemisia tabaci doublesex- and mab-3-related transcription factor A2-like (LOC109038221), partial mRNA blastn 1767 204 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
22390321 22390321 PRJNA728642_P_NODE_18738_length_243_cov_0.905882_g18467_i0 PRJNA728642 18738 243 0.905882 2.20129326 Armadillidium vulgare 13347 Arthropoda Arthropoda 444 3.09e-120   NTclustered gi|1220106000|gb|MF187613.1| 13347 g18467 i0 99.588 66.4238683127572 243 1 100 0 1 243 5709 5951 Armadillidium vulgare strain WXf mitochondrion blastn 16141 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
24939245 24939245 PRJNA728642_P_NODE_16020_length_250_cov_2.745763_g15749_i0 PRJNA728642 16020 250 2.745763 6.8644075 Bemisia tabaci 7038 Arthropoda Arthropoda 420 5.389999999999998e-113   NTclustered gi|5955|emb|Z15052.1| 7038 g15749 i0 97.222 5.108 252 0 100 6 1 250 417 663 B.tabaci gene for 18S ribosomal RNA (partial) blastn 1277 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
24939340 24939340 PRJNA728642_P_NODE_2100_length_721_cov_6.216049_g1842_i0 PRJNA728642 2100 721 6.216049 44.81771329 Bemisia tabaci 7038 Arthropoda Arthropoda 996 0   NTclustered gi|1101364690|ref|XM_019057968.1| 7038 g1842 i0 99.633 28.6435506241331 545 2 76 0 177 721 1 545 PREDICTED: Bemisia tabaci uncharacterized LOC109041581 (LOC109041581), mRNA blastn 20652 996 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
25421393 25421393 PRJNA728642_P_NODE_10540_length_312_cov_1.594142_g10269_i0 PRJNA728642 10540 312 1.594142 4.97372304 Drosophila 7215 Arthropoda Arthropoda 577 3.89e-160   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g10269 i0 100 100 312 0 100 0 1 312 2888 3199 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 31200 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta

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