RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA669701 · 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
10840281 10840281 PRJNA669701_P_NODE_75509_length_287_cov_2.037383_g75114_i0 PRJNA669701 75509 287 2.037383 5.84728921 Nais communis 188228 Annelida Annelida 129 1.82e-33   NR QUT13270.1 188228 g75114 i0 66.7 6.38675958188153 87 29 90.9 0 7 267 167 253 QUT13270.1 cytochrome b [Nais communis] diamond 1833 129 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Nais Nais communis
27303031 27303031 PRJNA669701_P_NODE_36923_length_388_cov_2.790476_g36528_i0 PRJNA669701 36923 388 2.790476 10.82704688 Helobdella robusta 6412 Annelida Annelida 73.2 7.71e-13   NR XP_009010058.1 6412 g36528 i0 62.3 2.96134020618557 53 20 41 0 21 179 88 140 XP_009010058.1 hypothetical protein HELRODRAFT_166577 [Helobdella robusta] diamond 1149 73.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
30378386 30378386 PRJNA669701_P_NODE_66592_length_302_cov_3.082969_g66197_i0 PRJNA669701 66592 302 3.082969 9.31056638 Metazoa 33208 Annelida Annelida 70.1 7.86e-12   NR CAH1783365.1 6347 g66197 i0 37 2.98013245033113 100 63 99.3 0 3 302 127 226 CAH1783365.1 unnamed protein product [Owenia fusiformis] diamond 900 70.5 0.994326241134752 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis

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