RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA811714" 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

  • PRJNA811714 · 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
29201775 29201775 PRJNA811714_P_NODE_15589_length_265_cov_4.656250_g15396_i0 PRJNA811714 15589 265 4.65625 12.3390625 Dermacentor andersoni 34620 Arthropoda Arthropoda 42.7 0.0461   NR XP_054934251.1 34620 g15396 i0 47.1 0.577358490566038 51 25 57.7 1 243 91 15 63 XP_054934251.1 polycystic kidney disease protein 1-like 3 isoform X2 [Dermacentor andersoni] diamond 153 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
29368368 29368368 PRJNA811714_P_NODE_19909_length_247_cov_3.517241_g19716_i0 PRJNA811714 19909 247 3.517241 8.68758527 Insecta 50557 Arthropoda Arthropoda 75.5 5.12e-14   NR XP_021919457.1 136037 g19716 i0 51.9 5.79352226720648 79 38 96 0 242 6 217 295 XP_021919457.1 N-acetylneuraminate lyase-like isoform X3 [Zootermopsis nevadensis] diamond 1431 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
29801447 29801447 PRJNA811714_P_NODE_18951_length_250_cov_7.322034_g18758_i0 PRJNA811714 18951 250 7.322034 18.305085 Harpegnathos saltator 610380 Arthropoda Arthropoda 48.5 2.97e-4   NR XP_011137057.1 610380 g18758 i0 73.3 0.36 30 8 36 0 34 123 1 30 XP_011137057.1 uncharacterized protein LOC105181771 [Harpegnathos saltator] diamond 90 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Harpegnathos Harpegnathos saltator

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