RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1182301 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
5421831 5421831 PRJNA1182301_P_NODE_43085_length_258_cov_1.648649_g42960_i0 PRJNA1182301 43085 258 1.648649 4.25351442 Arachnida 6854 Arthropoda Arthropoda 99 6.83e-22   NR XP_064459280.1 34597 g42960 i0 53.6 4.86046511627907 84 37 97.7 1 3 254 322 403 XP_064459280.1 putative phospholipase B-like 2 [Ornithodoros turicata] diamond 1254 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
11797705 11797705 PRJNA1182301_P_NODE_57410_length_245_cov_0.895349_g57285_i0 PRJNA1182301 57410 245 0.895349 2.19360505 Insecta 50557 Arthropoda Arthropoda 136 3.27e-35   NR XP_030753766.1 7048 g57285 i0 82.7 62.4857142857143 81 14 99.2 0 243 1 408 488 XP_030753766.1 heat shock protein 68-like [Sitophilus oryzae] diamond 15309 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
16896285 16896285 PRJNA1182301_P_NODE_58774_length_244_cov_0.900585_g58649_i0 PRJNA1182301 58774 244 0.900585 2.1974274 Limulus polyphemus 6850 Arthropoda Arthropoda 96.3 5.39e-21   NR XP_013788697.1 6850 g58649 i0 58.2 116.643442622951 79 11 97.1 1 6 242 345 401 XP_013788697.1 peregrin-like isoform X1 [Limulus polyphemus] diamond 28461 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
26629047 26629047 PRJNA1182301_P_NODE_4861_length_435_cov_1.193370_g4736_i0 PRJNA1182301 4861 435 1.19337 5.1911595 Daphnia pulicaria 35523 Arthropoda Arthropoda 61.6 7.67e-8   NR XP_046651552.1 35523 g4736 i0 32 3.90344827586207 128 83 86.9 3 50 427 374 499 XP_046651552.1 ankyrin-1-like [Daphnia pulicaria] diamond 1698 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulicaria
26964746 26964746 PRJNA1182301_P_NODE_53062_length_248_cov_0.880000_g52937_i0 PRJNA1182301 53062 248 0.88 2.1824 Hymenoptera 7399 Arthropoda Arthropoda 89.4 1.55e-18   NR XP_017878771.2 156304 g52937 i0 71.9 2.74596774193548 57 16 69 0 243 73 527 583 XP_017878771.2 long-chain fatty acid transport protein 4 [Ceratina calcarata] diamond 681 89.7 0.996655518394649 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Ceratina Ceratina calcarata
27514632 27514632 PRJNA1182301_P_NODE_38783_length_263_cov_2.421053_g38658_i0 PRJNA1182301 38783 263 2.421053 6.36736939 Tetranychus urticae 32264 Arthropoda Arthropoda 90.1 1.04e-18   NR XP_015789465.1 32264 g38658 i0 51.7 1.01520912547529 89 41 99.2 1 1 261 136 224 XP_015789465.1 solute carrier family 26 member 6 [Tetranychus urticae] diamond 267 90.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27849299 27849299 PRJNA1182301_P_NODE_44624_length_256_cov_1.683060_g44499_i0 PRJNA1182301 44624 256 1.68306 4.3086336 Psocodea 1930602 Arthropoda Arthropoda 87.8 6.31e-18   NR XP_002431396.1 121224 g44499 i0 57.6 2.34375 66 28 77.3 0 2 199 1716 1781 XP_002431396.1 Vitellogenin-1 precursor, putative [Pediculus humanus corporis] diamond 600 87.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
28303933 28303933 PRJNA1182301_P_NODE_31946_length_272_cov_2.336683_g31821_i0 PRJNA1182301 31946 272 2.336683 6.35577776 Episyrphus balteatus 286459 Arthropoda Arthropoda 53.9 5.69e-6   NR XP_055855794.1 286459 g31821 i0 44.4 0.595588235294118 54 30 59.6 0 164 3 184 237 XP_055855794.1 uncharacterized protein LOC129919021 [Episyrphus balteatus] diamond 162 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Episyrphus Episyrphus balteatus
28335501 28335501 PRJNA1182301_P_NODE_50286_length_250_cov_0.870056_g50161_i0 PRJNA1182301 50286 250 0.870056 2.17514 Topomyia yanbarensis 2498891 Arthropoda Arthropoda 65.1 5.57e-10   NR XP_058817692.1 2498891 g50161 i0 40.2 5.916 82 48 98.4 1 1 246 245 325 XP_058817692.1 uncharacterized protein LOC131681001 [Topomyia yanbarensis] diamond 1479 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Topomyia Topomyia yanbarensis
28366962 28366962 PRJNA1182301_P_NODE_24826_length_282_cov_1.574163_g24701_i0 PRJNA1182301 24826 282 1.574163 4.43913966 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 46.6 0.00248   NR XP_050540355.1 58002 g24701 i0 43.5 1.45744680851064 46 26 48.9 0 1 138 225 270 XP_050540355.1 uncharacterized protein LOC126904995 [Daktulosphaira vitifoliae] diamond 411 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
28891211 28891211 PRJNA1182301_P_NODE_47868_length_252_cov_1.022346_g47743_i0 PRJNA1182301 47868 252 1.022346 2.57631192 Metazoa 33208 Arthropoda Arthropoda 46.2 0.00205   NR EFX60121.1 6669 g47743 i0 41.5 2.0952380952381 65 36 77.4 2 249 55 149 211 EFX60121.1 hypothetical protein DAPPUDRAFT_125451 [Daphnia pulex] diamond 528 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
29314345 29314345 PRJNA1182301_P_NODE_60709_length_243_cov_0.905882_g60584_i0 PRJNA1182301 60709 243 0.905882 2.20129326 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 62.4 4.48e-9   NR KAG4077318.1 1564500 g60584 i0 73 0.91358024691358 74 20 91.4 0 224 3 821 894 KAG4077318.1 hypothetical protein HA402_009719 [Bradysia odoriphaga] diamond 222 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
29882876 29882876 PRJNA1182301_P_NODE_44591_length_256_cov_1.683060_g44466_i0 PRJNA1182301 44591 256 1.68306 4.3086336 Aphis craccivora 307492 Arthropoda Arthropoda 55.1 1.15e-7   NR KAF0763507.1 307492 g44466 i0 55.8 1.21875 52 23 60.9 0 171 16 23 74 KAF0763507.1 Uncharacterized protein FWK35_00008640, partial [Aphis craccivora] diamond 312 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
29882884 29882884 PRJNA1182301_P_NODE_60651_length_243_cov_0.905882_g60526_i0 PRJNA1182301 60651 243 0.905882 2.20129326 Clunio marinus 568069 Arthropoda Arthropoda 131 1.09e-33   NR CRK89813.1 568069 g60526 i0 75 0.987654320987654 80 20 98.8 0 3 242 165 244 CRK89813.1 CLUMA_CG003472, isoform A [Clunio marinus] diamond 240 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
29914448 29914448 PRJNA1182301_P_NODE_34011_length_270_cov_1.274112_g33886_i0 PRJNA1182301 34011 270 1.274112 3.4401024 Plodia interpunctella 58824 Arthropoda Arthropoda 45.1 0.00751   NR XP_053609976.1 58824 g33886 i0 42.6 1.01111111111111 54 28 56.7 1 215 63 106 159 XP_053609976.1 uncharacterized protein LOC128674969 [Plodia interpunctella] diamond 273 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Plodia Plodia interpunctella
29945950 29945950 PRJNA1182301_P_NODE_43011_length_258_cov_1.664865_g42886_i0 PRJNA1182301 43011 258 1.664865 4.2953517 Clunio marinus 568069 Arthropoda Arthropoda 111 2.58e-26   NR CRK95952.1 568069 g42886 i0 94 1.94186046511628 50 3 58.1 0 257 108 778 827 CRK95952.1 CLUMA_CG009396, isoform A [Clunio marinus] diamond 501 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
29977411 29977411 PRJNA1182301_P_NODE_32391_length_272_cov_1.427136_g32266_i0 PRJNA1182301 32391 272 1.427136 3.88180992 Medioppia subpectinata 1979941 Arthropoda Arthropoda 58.2 2e-7   NR CAD7630093.1 1979941 g32266 i0 62.8 1.89705882352941 43 15 47.4 1 112 240 135 176 CAD7630093.1 unnamed protein product, partial [Medioppia subpectinata] diamond 516 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
30862096 30862096 PRJNA1182301_P_NODE_49954_length_250_cov_1.649718_g49829_i0 PRJNA1182301 49954 250 1.649718 4.124295 Chelonus insularis 460826 Arthropoda Arthropoda 50.1 1.05e-4   NR XP_034944293.1 460826 g49829 i0 35.2 0.852 71 46 85.2 0 27 239 363 433 XP_034944293.1 putative ankyrin repeat protein RF_0381 [Chelonus insularis] diamond 213 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
31241162 31241162 PRJNA1182301_P_NODE_63175_length_241_cov_0.916667_g63050_i0 PRJNA1182301 63175 241 0.916667 2.20916747 Ischnura elegans 197161 Arthropoda Arthropoda 145 1.53e-39   NR XP_046402301.1 197161 g63050 i0 86.3 1.99170124481328 80 11 99.6 0 241 2 173 252 XP_046402301.1 CCA tRNA nucleotidyltransferase 1, mitochondrial [Ischnura elegans] diamond 480 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Coenagrionidae Ischnura Ischnura elegans
31355412 31355412 PRJNA1182301_P_NODE_30276_length_274_cov_5.318408_g30151_i0 PRJNA1182301 30276 274 5.318408 14.57243792 root 1 Root_unresolved Root_unresolved 43.5 0.0294   NR UYV65858.1 51811 g30151 i0 34.5 1.76277372262774 55 33 60.2 2 66 230 769 820 UYV65858.1 hypothetical protein LAZ67_3005722 [Cordylochernes scorpioides] diamond 483 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
31620794 31620794 PRJNA1182301_P_NODE_17336_length_295_cov_3.211712_g17211_i0 PRJNA1182301 17336 295 3.211712 9.4745504 Nymphon striatum 424472 Arthropoda Arthropoda 82 1.11e-15   NR KAG1648751.1 424472 g17211 i0 43.9 1.46440677966102 98 45 98.6 3 4 294 552 640 KAG1648751.1 Oligopeptide transport system permease protein AppB [Nymphon striatum] diamond 432 82 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
31905479 31905479 PRJNA1182301_P_NODE_48097_length_251_cov_2.353933_g47972_i0 PRJNA1182301 48097 251 2.353933 5.90837183 Orchesella dallaii 48710 Arthropoda Arthropoda 94.4 2.25e-20   NR CAL8125341.1 48710 g47972 i0 45.8 0.99203187250996006 83 45 99.2 0 249 1 265 347 CAL8125341.1 unnamed protein product [Orchesella dallaii] diamond 249 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
32032167 32032167 PRJNA1182301_P_NODE_50418_length_250_cov_0.870056_g50293_i0 PRJNA1182301 50418 250 0.870056 2.17514 Ischnura elegans 197161 Arthropoda Arthropoda 124 5.76e-31   NR XP_046391934.1 197161 g50293 i0 71.4 0.924 77 22 92.4 0 248 18 525 601 XP_046391934.1 prosaposin [Ischnura elegans] diamond 231 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Coenagrionidae Ischnura Ischnura elegans
32348750 32348750 PRJNA1182301_P_NODE_45079_length_255_cov_2.247253_g44954_i0 PRJNA1182301 45079 255 2.247253 5.73049515 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 53.1 7.13e-6   NR KFM63795.1 407821 g44954 i0 66.7 0.388235294117647 33 10 37.6 1 157 252 150 182 KFM63795.1 Transposable element Tcb1 transposase, partial [Stegodyphus mimosarum] diamond 99 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum

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