RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJDB9741 · 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
12764621 12764621 PRJDB9741_P_NODE_6651_length_243_cov_1.752577_g6334_i0 PRJDB9741 6651 243 1.752577 4.25876211 Metazoa 33208 Annelida Annelida 127 1.91e-35   NR CAH1794757.1 6347 g6334 i0 77.8 27.4567901234568 81 18 100 0 243 1 21 101 CAH1794757.1 unnamed protein product [Owenia fusiformis] diamond 6672 128 0.9921875 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
16587731 16587731 PRJDB9741_P_NODE_18614_length_180_cov_1.946565_g18297_i0 PRJDB9741 18614 180 1.946565 3.503817 Lamellibrachia satsuma 104711 Annelida Annelida 61.6 8.87e-10   NR KAI0229618.1 104711 g18297 i0 53.7 0.9 54 24 88.3 1 9 167 120 173 KAI0229618.1 Nucleoredoxin [Lamellibrachia satsuma] diamond 162 61.6 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
31480563 31480563 PRJDB9741_P_NODE_28376_length_167_cov_0.864407_g28059_i0 PRJDB9741 28376 167 0.864407 1.44355969 root 1 Root_unresolved Root_unresolved 45.4 5.15e-4   NR XP_009028542.1 6412 g28059 i0 39.7 1.9940119760479 58 31 98.8 2 167 3 13 69 XP_009028542.1 hypothetical protein HELRODRAFT_88948, partial [Helobdella robusta] diamond 333 45.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta

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