RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA993416 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27095527 27095527 PRJNA993416_P_NODE_15202_length_244_cov_0.871345_g15097_i0 PRJNA993416 15202 244 0.871345 2.1260818 root 1 Root_unresolved Root_unresolved 128 3.46e-32   NR XP_023324937.1 1294199 g15097 i0 76.5 2.98770491803279 81 19 99.6 0 2 244 298 378 XP_023324937.1 vigilin [Eurytemora carolleeae] diamond 729 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
27753258 27753258 PRJNA993416_P_NODE_11104_length_264_cov_1.193717_g10999_i0 PRJNA993416 11104 264 1.193717 3.15141288 Ixodes hexagonus 34612 Arthropoda Arthropoda 63.5 2.17e-9   NR CAL6191666.1 34612 g10999 i0 62.5 1.14772727272727 48 18 54.5 0 107 250 402 449 CAL6191666.1 unnamed protein product, partial [Ixodes hexagonus] diamond 303 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes hexagonus
29678725 29678725 PRJNA993416_P_NODE_10250_length_272_cov_1.276382_g10145_i0 PRJNA993416 10250 272 1.276382 3.47175904 Thrips palmi 161013 Arthropoda Arthropoda 152 3.26e-45   NR XP_034255971.1 161013 g10145 i0 78.9 1.98529411764706 90 19 99.3 0 3 272 22 111 XP_034255971.1 60S ribosomal protein L14 isoform X2 [Thrips palmi] diamond 540 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
31227002 31227002 PRJNA993416_P_NODE_14655_length_245_cov_0.895349_g14550_i0 PRJNA993416 14655 245 0.895349 2.19360505 Chironomus riparius 315576 Arthropoda Arthropoda 89 2.08e-18   NR CAG9799483.1 315576 g14550 i0 55.7 0.96734693877551 79 30 96.7 2 239 3 331 404 CAG9799483.1 unnamed protein product [Chironomus riparius] diamond 237 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31385442 31385442 PRJNA993416_P_NODE_13696_length_248_cov_0.862857_g13591_i0 PRJNA993416 13696 248 0.862857 2.13988536 Chironomus riparius 315576 Arthropoda Arthropoda 107 7.02e-25   NR CAG9804166.1 315576 g13591 i0 59.3 0.979838709677419 81 33 98 0 3 245 101 181 CAG9804166.1 unnamed protein product [Chironomus riparius] diamond 243 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31764810 31764810 PRJNA993416_P_NODE_7097_length_310_cov_3.548523_g6992_i0 PRJNA993416 7097 310 3.548523 11.0004213 Halocaridina rubra 373956 Arthropoda Arthropoda 66.6 3.32e-10   NR KAK7081739.1 373956 g6992 i0 56 3.83225806451613 50 22 48.4 0 2 151 309 358 KAK7081739.1 hypothetical protein SK128_005861 [Halocaridina rubra] diamond 1188 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
31802161 31802161 PRJNA993416_P_NODE_7117_length_310_cov_2.810127_g7012_i0 PRJNA993416 7117 310 2.810127 8.7113937 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.2 0.005   NR XP_037869477.1 7091 g7012 i0 50 6.09677419354839 42 21 40.6 0 308 183 1337 1378 XP_037869477.1 uncharacterized protein LOC101741169 isoform X1 [Bombyx mori] diamond 1890 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori

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