RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA492363" and tax_phylum = "Chytridiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chytridiomycota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA492363 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
32986790 32986790 PRJNA492363_S_NODE_97131_length_203_cov_0.901408_g96310_i0 PRJNA492363 97131 203 0.901408 1.82985824 Chytridium lagenaria 64509 Fungi Fungi 50.4 4.21e-5   NR KAI8849757.1 64509 g96310 i0 37.5 0.945812807881773 64 33 84.2 1 172 2 381 444 KAI8849757.1 hypothetical protein BC829DRAFT_416628 [Chytridium lagenaria] diamond 192 50.4 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Chytridiales Chytridiaceae Chytridium Chytridium lagenaria
33095045 33095045 PRJNA492363_S_NODE_83702_length_210_cov_3.436242_g82881_i0 PRJNA492363 83702 210 3.436242 7.2161082 root 1 Root_unresolved Root_unresolved 42.7 0.0257   NR KAJ3123091.1 109957 g82881 i0 63 2.9 27 10 38.6 0 19 99 1698 1724 KAJ3123091.1 cytochrome c oxidase subunit 1 [Physocladia obscura] diamond 609 43.1 0.990719257540603 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Chytridiales Chytriomycetaceae Physocladia Physocladia obscura

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