RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA999043" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA999043 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
979557 979557 PRJNA999043_P_NODE_16141_length_336_cov_1.273764_g16046_i0 PRJNA999043 16141 336 1.273764 4.27984704 Tropilaelaps mercedesae 418985 Arthropoda Arthropoda 176 6e-51   NR OQR74553.1 418985 g16046 i0 82.1 1.99107142857143 112 19 99.1 1 3 335 36 147 OQR74553.1 hypothetical protein BIW11_08987, partial [Tropilaelaps mercedesae] diamond 669 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Tropilaelaps Tropilaelaps mercedesae
9907760 9907760 PRJNA999043_P_NODE_16768_length_323_cov_0.924000_g16673_i0 PRJNA999043 16768 323 0.924 2.98452 Varroa destructor 109461 Arthropoda Arthropoda 212 7.97e-62   NR XP_022663764.1 109461 g16673 i0 92.5 1.98761609907121 107 8 99.4 0 322 2 584 690 XP_022663764.1 translation elongation factor 2-like [Varroa destructor] diamond 642 212 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor
27247774 27247774 PRJNA999043_P_NODE_23963_length_244_cov_0.871345_g23868_i0 PRJNA999043 23963 244 0.871345 2.1260818 Galendromus occidentalis 34638 Arthropoda Arthropoda 52.8 1.11e-5   NR XP_003737251.1 34638 g23868 i0 100 0.307377049180328 25 0 30.7 0 169 243 1 25 XP_003737251.1 serine/threonine-protein kinase PAK 3 [Galendromus occidentalis] diamond 75 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
27721969 27721969 PRJNA999043_P_NODE_17784_length_304_cov_1.000000_g17689_i0 PRJNA999043 17784 304 1 3.04 Galendromus occidentalis 34638 Arthropoda Arthropoda 155 3.05e-42   NR XP_003740670.1 34638 g17689 i0 75.2 0.996710526315789 101 25 99.7 0 304 2 117 217 XP_003740670.1 cholinesterase [Galendromus occidentalis] diamond 303 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
27942640 27942640 PRJNA999043_P_NODE_24885_length_241_cov_0.916667_g24790_i0 PRJNA999043 24885 241 0.916667 2.20916747 Galendromus occidentalis 34638 Arthropoda Arthropoda 43.9 0.0149   NR XP_028967959.1 34638 g24790 i0 59 0.485477178423237 39 16 48.5 0 8 124 1861 1899 XP_028967959.1 titin homolog [Galendromus occidentalis] diamond 117 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
31100624 31100624 PRJNA999043_P_NODE_13515_length_401_cov_2.320122_g13420_i0 PRJNA999043 13515 401 2.320122 9.30368922 Galendromus occidentalis 34638 Arthropoda Arthropoda 73.6 1.51e-13   NR XP_003739867.1 34638 g13420 i0 46.2 1.18204488778055 158 35 90.5 3 376 14 1 145 XP_003739867.1 cuticle protein 16.5 [Galendromus occidentalis] diamond 474 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
32055394 32055394 PRJNA999043_P_NODE_22498_length_248_cov_0.880000_g22403_i0 PRJNA999043 22498 248 0.88 2.1824 Varroa 62624 Arthropoda Arthropoda 170 1.26e-49   NR XP_022705918.1 62625 g22403 i0 95.1 2.9758064516129 82 4 99.2 0 247 2 170 251 XP_022705918.1 synaptic vesicle membrane protein VAT-1 homolog-like isoform X2 [Varroa jacobsoni] diamond 738 170 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa jacobsoni
32271227 32271227 PRJNA999043_P_NODE_21438_length_252_cov_1.290503_g21343_i0 PRJNA999043 21438 252 1.290503 3.25206756 Galendromus occidentalis 34638 Arthropoda Arthropoda 71.2 2.98e-12   NR XP_028967367.1 34638 g21343 i0 60.8 0.94047619047619 79 24 85.7 1 36 251 1 79 XP_028967367.1 uncharacterized protein KIAA0754-like [Galendromus occidentalis] diamond 237 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis

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