RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA886442 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
26651594 26651594 PRJNA886442_P_NODE_14981_length_242_cov_0.923077_g14817_i0 PRJNA886442 14981 242 0.923077 2.23384634 Metazoa 33208 Arthropoda Arthropoda 159 1.35e-45   NR PSN48223.1 6973 g14817 i0 100 87.2727272727273 80 0 99.2 0 3 242 286 365 PSN48223.1 26S protease regulatory subunit 8 [Blattella germanica] diamond 21120 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
31200351 31200351 PRJNA886442_P_NODE_9315_length_264_cov_1.670157_g9151_i0 PRJNA886442 9315 264 1.670157 4.40921448 Metazoa 33208 Arthropoda Arthropoda 129 1.0799999999999999e-32   NR OQR79895.1 418985 g9151 i0 90.5 16.5909090909091 63 6 71.6 0 75 263 253 315 OQR79895.1 beta-tubulin-like, partial [Tropilaelaps mercedesae] diamond 4380 130 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Tropilaelaps Tropilaelaps mercedesae
32490119 32490119 PRJNA886442_P_NODE_12979_length_247_cov_0.896552_g12815_i0 PRJNA886442 12979 247 0.896552 2.21448344 Orchesella cincta 48709 Arthropoda Arthropoda 45.1 0.00589   NR ODM93294.1 48709 g12815 i0 29.6 0.862348178137652 71 47 86.2 2 1 213 121 188 ODM93294.1 Trypsin-2 [Orchesella cincta] diamond 213 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta

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