RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA382558" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA382558 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27644032 27644032 PRJNA382558_S_NODE_10964_length_168_cov_5.618321_g10960_i0 PRJNA382558 10964 168 5.618321 9.43877928 Brachionus plicatilis 10195 Rotifera other_Eukaryota 108 6.38e-28   NR RNA32099.1 10195 g10960 i0 91.1 1 56 5 100 0 168 1 108 163 RNA32099.1 hypothetical protein BpHYR1_050505 [Brachionus plicatilis] diamond 168 108 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
28275178 28275178 PRJNA382558_S_NODE_7406_length_189_cov_5.125000_g7402_i0 PRJNA382558 7406 189 5.125 9.68625 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 42.4 0.0196   NR CAF0960475.1 1234261 g7402 i0 48.8 1.23809523809524 41 21 65.1 0 186 64 139 179 CAF0960475.1 unnamed protein product [Didymodactylos carnosus] diamond 234 42.4 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
28780320 28780320 PRJNA382558_S_NODE_12727_length_160_cov_18.861789_g12723_i0 PRJNA382558 12727 160 18.861789 30.1788624 Brachionus plicatilis 10195 Rotifera other_Eukaryota 88.6 7.17e-19   NR RNA42975.1 10195 g12723 i0 100 0.75 40 0 75 0 159 40 417 456 RNA42975.1 hypothetical protein BpHYR1_029794 [Brachionus plicatilis] diamond 120 88.6 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
30833438 30833438 PRJNA382558_S_NODE_13294_length_158_cov_8.396694_g13290_i0 PRJNA382558 13294 158 8.396694 13.26677652 Brachionus plicatilis 10195 Rotifera other_Eukaryota 97.8 3.16e-22   NR RNA42975.1 10195 g13290 i0 96.2 0.987341772151899 52 2 98.7 0 156 1 362 413 RNA42975.1 hypothetical protein BpHYR1_029794 [Brachionus plicatilis] diamond 156 97.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
31908454 31908454 PRJNA382558_S_NODE_13817_length_157_cov_0.975000_g13813_i0 PRJNA382558 13817 157 0.975 1.53075 Mustela nigripes 77151 Chordata Chordata 63.2 7.97e-11   NR XP_059242337.1 77151 g13813 i0 74.4 137.197452229299 39 10 74.5 0 127 11 95 133 XP_059242337.1 large ribosomal subunit protein eL42 [Mustela nigripes] diamond 21540 63.5 0.995275590551181 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Mustelidae Mustela Mustela nigripes
31956929 31956929 PRJNA382558_S_NODE_6777_length_194_cov_5.426752_g6773_i0 PRJNA382558 6777 194 5.426752 10.52789888 Opisthokonta 33154 Nematoda Nematoda 59.3 2.67e-8   NR KAK0419583.1 289476 g6773 i0 43.1 5.21134020618557 58 33 89.7 0 194 21 76 133 KAK0419583.1 hypothetical protein QR680_014219 [Steinernema hermaphroditum] diamond 1011 59.3 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Steinernematidae Steinernema Steinernema hermaphroditum

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