RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJEB9859" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB9859 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
145015 145015 PRJEB9859_S_NODE_541_length_179_cov_6.611111_g536_i0 PRJEB9859 541 179 6.611111 11.83388869 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 331 1.74e-86   NTclustered gi|2210637305|gb|MT106115.1| 185214 g536 i0 100 72.3240223463687 179 0 100 0 1 179 7678 7856 Liposcelis bostrychophila strain Berlin chromosome 1 mitochondrion, complete sequence blastn 12946 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
2695144 2695144 PRJEB9859_P_NODE_3983_length_255_cov_2.424779_g3948_i0 PRJEB9859 3983 255 2.424779 6.18318645 Stomoxys calcitrans 35570 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2573078818|ref|XM_013253840.2| 35570 g3948 i0 100 0.109803921568627 28 0 11 0 134 161 2712 2739 PREDICTED: Stomoxys calcitrans daxx-like protein (LOC106088360), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
2695199 2695199 PRJEB9859_S_NODE_563_length_175_cov_2.628571_g558_i0 PRJEB9859 563 175 2.628571 4.59999925 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 313 6.13e-81   NTclustered gi|1535914814|ref|XR_003474832.1| 6956 g558 i0 98.857 100.422857142857 175 2 100 0 1 175 320 146 PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA blastn 17574 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
6102155 6102155 PRJEB9859_P_NODE_2065_length_316_cov_759.282230_g2030_i0 PRJEB9859 2065 316 759.28223 2399.3318468 Staphylinidae 29026 Arthropoda Arthropoda 302 2.66e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g2030 i0 92.453 59.2151898734177 212 14 67 2 24 234 108 318 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
9072424 9072424 PRJEB9859_P_NODE_608_length_452_cov_371.297872_g578_i0 PRJEB9859 608 452 371.297872 1678.26638144 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 619 9.57e-173   NTclustered gi|194718416|gb|EU863798.1| 185214 g578 i0 100 25.7920353982301 335 0 74 0 22 356 11 345 Liposcelis bostrychophila isolate CZ 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 11658 619 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
9072429 9072429 PRJEB9859_P_NODE_6348_length_227_cov_2.111111_g6313_i0 PRJEB9859 6348 227 2.111111 4.79222197 Vanessa cardui 171605 Arthropoda Arthropoda 119 1.97e-22   NTclustered gi|2207062080|ref|XM_047117954.1| 171605 g6313 i0 87.619 13.7929515418502 105 9 45 4 124 226 1555 1453 PREDICTED: Vanessa cardui tubulin alpha chain (LOC124540420), mRNA blastn 3131 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Vanessa Vanessa cardui
11202272 11202272 PRJEB9859_P_NODE_1729_length_334_cov_710.619672_g1694_i0 PRJEB9859 1729 334 710.619672 2373.46970448 Staphylinidae 29026 Arthropoda Arthropoda 302 2.8300000000000002e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1694 i0 92.453 56.0239520958084 212 14 63 2 101 311 318 108 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
11202274 11202274 PRJEB9859_P_NODE_1809_length_329_cov_28.733333_g1774_i0 PRJEB9859 1809 329 28.733333 94.53266557 Entomobryomorpha 730330 Arthropoda Arthropoda 139 2.31e-28   NTclustered gi|472455922|gb|KC236276.1| 247613 g1774 i0 100 22.7963525835866 75 0 23 0 255 329 202 128 Entomobrya multifasciata 28S ribosomal RNA gene, partial sequence blastn 7500 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Entomobryidae Entomobrya Entomobrya multifasciata
11202311 11202311 PRJEB9859_P_NODE_7129_length_216_cov_63.780749_g7094_i0 PRJEB9859 7129 216 63.780749 137.76641784 Aphelocheirus 280208 Arthropoda Arthropoda 91.6 4.04e-14   NTclustered gi|741985854|gb|KJ461297.1| 575831 g7094 i0 91.045 32.087962962963 67 6 31 0 146 212 2209 2143 Aphelocheirus ellipsoideus 28S ribosomal RNA gene, partial sequence blastn 6931 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphelocheiridae Aphelocheirus Aphelocheirus ellipsoideus
11623560 11623560 PRJEB9859_P_NODE_750_length_425_cov_57.535354_g716_i0 PRJEB9859 750 425 57.535354 244.5252545 Derocheilocaris typica 84307 Arthropoda Arthropoda 154 1.09e-32   NTclustered gi|172072974|gb|EU370429.1| 84307 g716 i0 96.739 30.6470588235294 92 3 39 0 334 425 1221 1130 Derocheilocaris typicus strain C9 18S ribosomal RNA gene, partial sequence blastn 13025 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Mystacocarida Mystacocaridida Derocheilocarididae Derocheilocaris Derocheilocaris typica
12477904 12477904 PRJEB9859_P_NODE_1530_length_348_cov_682.304075_g1495_i0 PRJEB9859 1530 348 682.304075 2374.418181 Staphylinidae 29026 Arthropoda Arthropoda 302 2.96e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1495 i0 92.453 53.7701149425287 212 14 61 2 115 325 318 108 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
12898564 12898564 PRJEB9859_P_NODE_1511_length_349_cov_62.578125_g1476_i0 PRJEB9859 1511 349 62.578125 218.39765625 Derocheilocaris typica 84307 Arthropoda Arthropoda 154 8.78e-33   NTclustered gi|172072974|gb|EU370429.1| 84307 g1476 i0 96.739 30.1805157593123 92 3 26 0 142 233 1221 1130 Derocheilocaris typicus strain C9 18S ribosomal RNA gene, partial sequence blastn 10533 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Mystacocarida Mystacocaridida Derocheilocarididae Derocheilocaris Derocheilocaris typica
15447699 15447699 PRJEB9859_P_NODE_7773_length_207_cov_135.325843_g7738_i0 PRJEB9859 7773 207 135.325843 280.12449501 Speleonectes gironensis 172521 Arthropoda Arthropoda 97.1 8.25e-16   NTclustered gi|15986551|gb|AF370810.1| 172521 g7738 i0 95.082 14.6038647342995 61 3 29 0 133 193 224 164 Speleonectes gironensis 28S ribosomal RNA gene, partial sequence blastn 3023 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Remipedia Nectiopoda Speleonectidae Speleonectes Speleonectes gironensis
15447704 15447704 PRJEB9859_S_NODE_293_length_337_cov_27.884106_g288_i0 PRJEB9859 293 337 27.884106 93.96943722 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 614 3.229999999999999e-171   NTclustered gi|194718416|gb|EU863798.1| 185214 g288 i0 99.701 34.6112759643917 335 1 99 0 3 337 11 345 Liposcelis bostrychophila isolate CZ 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 11664 614 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
17996636 17996636 PRJEB9859_P_NODE_2835_length_287_cov_3.189922_g2800_i0 PRJEB9859 2835 287 3.189922 9.15507614 Labidocera rotunda 207950 Arthropoda Arthropoda 117 9.28e-22   NTclustered gi|961376781|gb|KT755301.1| 207950 g2800 i0 80.769 31.6898954703833 156 24 53 6 125 277 417 265 Labidocera rotunda clone LabbicDNA51(Lbi51) 60S ribosomal protein L22 mRNA, complete cds blastn 9095 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Pontellidae Labidocera Labidocera rotunda
18850678 18850678 PRJEB9859_P_NODE_1495_length_350_cov_674.105919_g1460_i0 PRJEB9859 1495 350 674.105919 2359.3707165 Staphylinidae 29026 Arthropoda Arthropoda 302 2.9700000000000006e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1460 i0 92.453 53.462857142857096 212 14 60 2 24 234 108 318 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
20546043 20546043 PRJEB9859_P_NODE_2057_length_317_cov_1.750000_g2022_i0 PRJEB9859 2057 317 1.75 5.5475 Zerynthia rumina 132710 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|2918381530|emb|OZ238054.1| 132710 g2022 i0 100 0.0883280757097792 28 0 9 0 241 268 6323989 6323962 Zerynthia rumina genome assembly, chromosome: 19 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
20546117 20546117 PRJEB9859_P_NODE_6917_length_217_cov_39.335106_g6882_i0 PRJEB9859 6917 217 39.335106 85.35718002 Delia radicum 30064 Arthropoda Arthropoda 139 1.43e-28   NTclustered gi|425869920|gb|KC177819.1| 30064 g6882 i0 100 34.1013824884793 75 0 35 0 143 217 2454 2380 Delia radicum 28S ribosomal RNA gene, partial sequence blastn 7400 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Anthomyiidae Delia Delia radicum
21821830 21821830 PRJEB9859_P_NODE_7558_length_211_cov_339.252747_g7523_i0 PRJEB9859 7558 211 339.252747 715.82329617 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 255 1.32e-63   NTclustered gi|537107101|gb|KF419262.1| 185214 g7523 i0 99.291 16.9099526066351 141 1 93 0 71 211 227 367 Liposcelis bostrychophila 12S ribosomal RNA gene, partial sequence; mitochondrial blastn 3568 255 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
25225153 25225153 PRJEB9859_P_NODE_6800_length_217_cov_158.031915_g6765_i0 PRJEB9859 6800 217 158.031915 342.92925555 Diptera 7147 Arthropoda Arthropoda 215 2.31e-51   NTclustered gi|2568282091|ref|XR_009344279.1| 7370 g6765 i0 99.16 56.6451612903226 119 1 55 0 99 217 3637 3519 PREDICTED: Musca domestica large subunit ribosomal RNA (LOC131807038), rRNA blastn 12292 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica

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