RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA356682 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
1672702 1672702 PRJNA356682_P_NODE_6922_length_535_cov_2.452381_g6235_i0 PRJNA356682 6922 535 2.452381 13.12023835 Daphnia pulex 6669 Arthropoda Arthropoda 278 6.77e-91   NR EFX60189.1 6669 g6235 i0 87.1 0.998130841121495 178 0 99.8 1 2 535 71 225 EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] diamond 534 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
1672739 1672739 PRJNA356682_P_NODE_9082_length_464_cov_1.526854_g8393_i0 PRJNA356682 9082 464 1.526854 7.08460256 Idotea baltica 82763 Arthropoda Arthropoda 252 1.68e-80   NR MCL4123734.1 82763 g8393 i0 80.5 0.995689655172414 154 30 99.6 0 1 462 29 182 MCL4123734.1 hypothetical protein [Idotea baltica] diamond 462 252 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
4224454 4224454 PRJNA356682_P_NODE_13124_length_389_cov_1.386076_g12434_i0 PRJNA356682 13124 389 1.386076 5.39183564 Idotea baltica 82763 Arthropoda Arthropoda 236 1.02e-71   NR MCL4154024.1 82763 g12434 i0 93.8 0.994858611825193 129 8 99.5 0 388 2 296 424 MCL4154024.1 hypothetical protein [Idotea baltica] diamond 387 236 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
6774860 6774860 PRJNA356682_P_NODE_14826_length_368_cov_1.305085_g14136_i0 PRJNA356682 14826 368 1.305085 4.8027128 Arthropoda 6656 Arthropoda Arthropoda 94 1.86e-19   NR XP_050734450.1 95602 g14136 i0 50 1.75271739130435 122 61 99.5 0 1 366 922 1043 XP_050734450.1 myosin heavy chain, muscle-like [Eriocheir sinensis] diamond 645 94.7 0.992608236536431 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
26663033 26663033 PRJNA356682_P_NODE_35741_length_251_cov_1.702247_g35050_i0 PRJNA356682 35741 251 1.702247 4.27263997 Daphnia pulex 6669 Arthropoda Arthropoda 97.1 5.4e-23   NR EFX60049.1 6669 g35050 i0 81.5 0.645418326693227 54 10 64.5 0 164 3 113 166 EFX60049.1 hypothetical protein DAPPUDRAFT_72936 [Daphnia pulex] diamond 162 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27060370 27060370 PRJNA356682_P_NODE_23882_length_299_cov_1.362832_g23191_i0 PRJNA356682 23882 299 1.362832 4.07486768 Metazoa 33208 Arthropoda Arthropoda 68.9 3.29e-12   NR KAH8009963.1 6941 g23191 i0 100 39.3612040133779 29 0 29.1 0 2 88 122 150 KAH8009963.1 hypothetical protein HPB51_023019 [Rhipicephalus microplus] diamond 11769 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
27201068 27201068 PRJNA356682_P_NODE_37642_length_249_cov_0.875000_g36951_i0 PRJNA356682 37642 249 0.875 2.17875 Tropilaelaps mercedesae 418985 Arthropoda Arthropoda 90.5 6.26e-19   NR OQR71856.1 418985 g36951 i0 52.4 2.96385542168675 82 39 98.8 0 2 247 200 281 OQR71856.1 armadillo segment polarity protein-like, partial [Tropilaelaps mercedesae] diamond 738 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Tropilaelaps Tropilaelaps mercedesae
27201076 27201076 PRJNA356682_P_NODE_46662_length_227_cov_3.051948_g45971_i0 PRJNA356682 46662 227 3.051948 6.92792196 Idotea baltica 82763 Arthropoda Arthropoda 131 1.22e-33   NR MCL4114215.1 82763 g45971 i0 84 0.991189427312775 75 12 99.1 0 226 2 385 459 MCL4114215.1 hypothetical protein [Idotea baltica] diamond 225 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27724161 27724161 PRJNA356682_P_NODE_26364_length_286_cov_54.361502_g25673_i0 PRJNA356682 26364 286 54.361502 155.47389572 Metazoa 33208 Arthropoda Arthropoda 51.2 1.19e-5   NR KAK3889482.1 88211 g25673 i0 57.1 4.42657342657343 56 23 58.7 1 32 199 38 92 KAK3889482.1 hypothetical protein Pcinc_006529 [Petrolisthes cinctipes] diamond 1266 51.6 0.992248062015504 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
27881622 27881622 PRJNA356682_P_NODE_41045_length_245_cov_0.895349_g40354_i0 PRJNA356682 41045 245 0.895349 2.19360505 Schistocerca 7008 Arthropoda Arthropoda 44.7 0.00836   NR XP_049835211.1 7010 g40354 i0 31.1 13.6530612244898 74 49 89.4 2 232 14 6069 6141 XP_049835211.1 muscle-specific protein 300 kDa isoform X1 [Schistocerca gregaria] diamond 3345 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28117007 28117007 PRJNA356682_P_NODE_43925_length_242_cov_0.911243_g43234_i0 PRJNA356682 43925 242 0.911243 2.20520806 Schistocerca gregaria 7010 Arthropoda Arthropoda 82 5.4e-16   NR XP_049850528.1 7010 g43234 i0 50 1.01652892561983 82 39 99.2 1 240 1 540 621 XP_049850528.1 uncharacterized protein LOC126322730 [Schistocerca gregaria] diamond 246 82 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28369630 28369630 PRJNA356682_P_NODE_42346_length_244_cov_0.883041_g41655_i0 PRJNA356682 42346 244 0.883041 2.15462004 Daphnia magna 35525 Arthropoda Arthropoda 63.9 1.09e-10   NR KZS01496.1 35525 g41655 i0 41.8 0.971311475409836 79 42 95.9 2 11 244 1 76 KZS01496.1 Uncharacterized protein APZ42_001828, partial [Daphnia magna] diamond 237 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
28432924 28432924 PRJNA356682_P_NODE_5946_length_578_cov_2.152475_g5267_i0 PRJNA356682 5946 578 2.152475 12.4413055 Cyprideis torosa 163714 Arthropoda Arthropoda 152 2.55e-44   NR CAD7237494.1 163714 g5267 i0 66.9 0.612456747404844 118 23 61.2 1 387 34 1 102 CAD7237494.1 unnamed protein product [Cyprideis torosa] diamond 354 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
29018619 29018619 PRJNA356682_P_NODE_40208_length_246_cov_0.890173_g39517_i0 PRJNA356682 40208 246 0.890173 2.18982558 Metazoa 33208 Arthropoda Arthropoda 70.5 6.79e-12   NR XP_027197836.1 6956 g39517 i0 49.3 13.8048780487805 67 31 81.7 1 43 243 277 340 XP_027197836.1 116 kDa U5 small nuclear ribonucleoprotein component-like [Dermatophagoides pteronyssinus] diamond 3396 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29127702 29127702 PRJNA356682_P_NODE_19809_length_324_cov_1.462151_g19118_i0 PRJNA356682 19809 324 1.462151 4.73736924 Trichogramma pretiosum 7493 Arthropoda Arthropoda 98.6 6.209999999999999e-23   NR XP_014235764.1 7493 g19118 i0 48.3 1.09259259259259 118 51 100 2 324 1 69 186 XP_014235764.1 60S ribosomal protein L13-like [Trichogramma pretiosum] diamond 354 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
29222387 29222387 PRJNA356682_P_NODE_42829_length_243_cov_0.905882_g42138_i0 PRJNA356682 42829 243 0.905882 2.20129326 Bradysia coprophila 38358 Arthropoda Arthropoda 47.8 6.21e-4   NR XP_037026128.1 38358 g42138 i0 48.9 3.76543209876543 45 23 55.6 0 2 136 511 555 XP_037026128.1 NADPH--cytochrome P450 reductase isoform X2 [Bradysia coprophila] diamond 915 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
29885460 29885460 PRJNA356682_P_NODE_36891_length_250_cov_0.870056_g36200_i0 PRJNA356682 36891 250 0.870056 2.17514 Schistocerca americana 7009 Arthropoda Arthropoda 57.4 2.85e-7   NR XP_047003276.1 7009 g36200 i0 51.1 0.54 45 22 54 0 208 74 304 348 XP_047003276.1 histone-lysine N-methyltransferase SUV39H1-like isoform X1 [Schistocerca americana] diamond 135 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
30186646 30186646 PRJNA356682_P_NODE_38672_length_248_cov_0.880000_g37981_i0 PRJNA356682 38672 248 0.88 2.1824 Sarcoptiformes 83137 Arthropoda Arthropoda 46.6 0.00178   NR KAH9414890.1 6956 g37981 i0 47.6 3.56854838709677 42 22 50.8 0 193 68 651 692 KAH9414890.1 hypothetical protein DERP_012480 [Dermatophagoides pteronyssinus] diamond 885 47 0.991489361702128 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
31243844 31243844 PRJNA356682_P_NODE_30975_length_267_cov_2.798969_g30284_i0 PRJNA356682 30975 267 2.798969 7.47324723 Trichonephila clavata 2740835 Arthropoda Arthropoda 43.9 0.00517   NR GFR22353.1 2740835 g30284 i0 38.8 0.752808988764045 67 41 75.3 0 222 22 16 82 GFR22353.1 uncharacterized protein TNCT_371781 [Trichonephila clavata] diamond 201 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavata
31813246 31813246 PRJNA356682_P_NODE_32757_length_261_cov_1.526596_g32066_i0 PRJNA356682 32757 261 1.526596 3.98441556 Lasius niger 67767 Arthropoda Arthropoda 43.9 0.016   NR KMQ86303.1 67767 g32066 i0 53.3 0.344827586206897 30 14 34.5 0 247 158 216 245 KMQ86303.1 copia protein [Lasius niger] diamond 90 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
32003100 32003100 PRJNA356682_P_NODE_34478_length_255_cov_2.054945_g33787_i0 PRJNA356682 34478 255 2.054945 5.24010975 Idotea baltica 82763 Arthropoda Arthropoda 152 1.36e-45   NR MCL4119130.1 82763 g33787 i0 81.2 1 85 16 100 0 1 255 1 85 MCL4119130.1 hypothetical protein [Idotea baltica] diamond 255 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32509609 32509609 PRJNA356682_P_NODE_38159_length_248_cov_2.125714_g37468_i0 PRJNA356682 38159 248 2.125714 5.27177072 Psylliodes chrysocephala 3402493 Arthropoda Arthropoda 43.5 0.0218   NR CAH1106855.1 2598218 g37468 i0 51.9 6.90725806451613 27 13 32.7 0 78 158 1148 1174 CAH1106855.1 unnamed protein product [Psylliodes chrysocephala] diamond 1713 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Psylliodes Psylliodes chrysocephala

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