RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA675042 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
3198402 3198402 PRJNA675042_P_NODE_83523_length_276_cov_1.896552_g83073_i0 PRJNA675042 83523 276 1.896552 5.23448352 Insecta 50557 Arthropoda Arthropoda 168 2.7199999999999992e-47   NR KAJ9586643.1 6984 g83073 i0 90.8 13.2391304347826 87 8 94.6 0 3 263 436 522 KAJ9586643.1 hypothetical protein L9F63_019745, partial [Diploptera punctata] diamond 3654 168 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
26765331 26765331 PRJNA675042_P_NODE_100301_length_257_cov_1.673913_g99851_i0 PRJNA675042 100301 257 1.673913 4.30195641 Polyplax serrata 468196 Arthropoda Arthropoda 166 7.54e-47   NR KAK6642907.1 468196 g99851 i0 81.2 6.94552529182879 85 16 99.2 0 255 1 108 192 KAK6642907.1 hypothetical protein RUM43_004409 [Polyplax serrata] diamond 1785 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27219917 27219917 PRJNA675042_P_NODE_30162_length_372_cov_1.274247_g29712_i0 PRJNA675042 30162 372 1.274247 4.74019884 Insecta 50557 Arthropoda Arthropoda 179 9.72e-56   NR XP_028138807.1 50390 g29712 i0 90.9 9.61290322580645 99 9 79.8 0 2 298 12 110 XP_028138807.1 60S ribosomal protein L34 [Diabrotica virgifera virgifera] diamond 3576 179 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
27366627 27366627 PRJNA675042_P_NODE_22943_length_399_cov_1.233129_g22493_i0 PRJNA675042 22943 399 1.233129 4.92018471 Daphnia pulex 6669 Arthropoda Arthropoda 102 7.45e-24   NR EFX60124.1 6669 g22493 i0 85.5 0.413533834586466 55 8 41.4 0 397 233 46 100 EFX60124.1 hypothetical protein DAPPUDRAFT_125424 [Daphnia pulex] diamond 165 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27599424 27599424 PRJNA675042_P_NODE_63564_length_302_cov_1.790393_g63114_i0 PRJNA675042 63564 302 1.790393 5.40698686 Psocodea 1930602 Arthropoda Arthropoda 149 2.47e-39   NR XP_002425601.1 121224 g63114 i0 78 1.96688741721854 100 6 99.3 1 302 3 4 87 XP_002425601.1 Bromodomain-containing protein, putative [Pediculus humanus corporis] diamond 594 150 0.993333333333333 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
27650675 27650675 PRJNA675042_P_NODE_75504_length_286_cov_1.234742_g75054_i0 PRJNA675042 75504 286 1.234742 3.53136212 Pollicipes pollicipes 41117 Arthropoda Arthropoda 43.1 0.0424   NR XP_037071859.1 41117 g75054 i0 42.6 0.493006993006993 47 27 49.3 0 152 12 150 196 XP_037071859.1 phenoloxidase-activating factor 3-like [Pollicipes pollicipes] diamond 141 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
28325314 28325314 PRJNA675042_P_NODE_105946_length_251_cov_1.073034_g105496_i0 PRJNA675042 105946 251 1.073034 2.69331534 Opisthokonta 33154 Arthropoda Arthropoda 42.7 0.0144   NR MCL4113734.1 82763 g105496 i0 57.7 1.55378486055777 26 11 31.1 0 251 174 23 48 MCL4113734.1 hypothetical protein [Idotea baltica] diamond 390 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28660984 28660984 PRJNA675042_P_NODE_39707_length_344_cov_2.774908_g39257_i0 PRJNA675042 39707 344 2.774908 9.54568352 Polyplax serrata 468196 Arthropoda Arthropoda 122 1.03e-29   NR KAK6641338.1 468196 g39257 i0 69.5 2.18895348837209 105 28 91.6 1 1 315 248 348 KAK6641338.1 hypothetical protein RUM44_013047 [Polyplax serrata] diamond 753 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
28818387 28818387 PRJNA675042_P_NODE_104328_length_253_cov_0.972222_g103878_i0 PRJNA675042 104328 253 0.972222 2.45972166 Blattella germanica 6973 Arthropoda Arthropoda 40.8 0.0472   NR PSN43669.1 6973 g103878 i0 45.8 0.569169960474308 48 25 55.7 1 189 49 40 87 PSN43669.1 hypothetical protein C0J52_12000 [Blattella germanica] diamond 144 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28976790 28976790 PRJNA675042_P_NODE_53948_length_317_cov_2.065574_g53498_i0 PRJNA675042 53948 317 2.065574 6.54786958 Culex quinquefasciatus 7176 Arthropoda Arthropoda 107 2.45e-24   NR XP_038117062.1 7176 g53498 i0 50.5 6 107 51 99.4 1 317 3 730 836 XP_038117062.1 LOW QUALITY PROTEIN: uncharacterized protein LOC6050036 [Culex quinquefasciatus] diamond 1902 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
30207905 30207905 PRJNA675042_P_NODE_104492_length_252_cov_3.011173_g104042_i0 PRJNA675042 104492 252 3.011173 7.58815596 Artemia franciscana 6661 Arthropoda Arthropoda 81.6 8.54e-16   NR XP_065582355.1 6661 g104042 i0 58.6 0.833333333333333 70 29 83.3 0 212 3 1103 1172 XP_065582355.1 uncharacterized protein LOC136041587 [Artemia franciscana] diamond 210 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30366665 30366665 PRJNA675042_P_NODE_76832_length_284_cov_2.597156_g76382_i0 PRJNA675042 76832 284 2.597156 7.37592304 Pediculus humanus corporis 121224 Arthropoda Arthropoda 152 2.6e-40   NR XP_002431932.1 121224 g76382 i0 85.9 0.971830985915493 92 11 97.2 1 277 2 898 987 XP_002431932.1 uncharacterized protein Phum_PHUM561100 [Pediculus humanus corporis] diamond 276 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
30883568 30883568 PRJNA675042_P_NODE_169474_length_242_cov_0.911243_g169024_i0 PRJNA675042 169474 242 0.911243 2.20520806 Blattodea 85823 Arthropoda Arthropoda 139 9.72e-37   NR XP_069684905.1 6978 g169024 i0 83.5 8.81404958677686 79 13 97.9 0 5 241 354 432 XP_069684905.1 scavenger receptor class B member 1 isoform X2 [Periplaneta americana] diamond 2133 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
31218932 31218932 PRJNA675042_P_NODE_177955_length_241_cov_0.916667_g177505_i0 PRJNA675042 177955 241 0.916667 2.20916747 Copidosoma floridanum 29053 Arthropoda Arthropoda 44.7 0.00782   NR XP_014204116.1 29053 g177505 i0 62.1 0.360995850622407 29 11 36.1 0 120 34 999 1027 XP_014204116.1 structural maintenance of chromosomes protein 5 [Copidosoma floridanum] diamond 87 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Encyrtidae Copidosoma Copidosoma floridanum
31250922 31250922 PRJNA675042_P_NODE_6335_length_579_cov_1.586957_g5898_i0 PRJNA675042 6335 579 1.586957 9.18848103 Polyplax serrata 468196 Arthropoda Arthropoda 288 4.19e-91   NR KAK6639286.1 468196 g5898 i0 68.8 0.979274611398964 189 59 97.9 0 577 11 381 569 KAK6639286.1 hypothetical protein RUM43_007558 [Polyplax serrata] diamond 567 288 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
31693754 31693754 PRJNA675042_P_NODE_71257_length_291_cov_2.064220_g70807_i0 PRJNA675042 71257 291 2.06422 6.0068802 Polyplax serrata 468196 Arthropoda Arthropoda 179 5.29e-50   NR KAK6621758.1 468196 g70807 i0 95.9 1 97 4 100 0 1 291 620 716 KAK6621758.1 hypothetical protein RUM44_001565 [Polyplax serrata] diamond 291 179 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
32073479 32073479 PRJNA675042_P_NODE_93318_length_265_cov_1.375000_g92868_i0 PRJNA675042 93318 265 1.375 3.64375 Polyplax serrata 468196 Arthropoda Arthropoda 124 1.42e-30   NR KAK6627655.1 468196 g92868 i0 76.2 1.90188679245283 84 19 95.1 1 1 252 354 436 KAK6627655.1 hypothetical protein RUM44_010134 [Polyplax serrata] diamond 504 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
32326939 32326939 PRJNA675042_P_NODE_55839_length_314_cov_1.539419_g55389_i0 PRJNA675042 55839 314 1.539419 4.83377566 Folsomia candida 158441 Arthropoda Arthropoda 83.6 4.1e-16   NR XP_021954557.1 158441 g55389 i0 37.3 4.14649681528662 102 59 93.6 2 296 3 8 108 XP_021954557.1 titin homolog [Folsomia candida] diamond 1302 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida

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