RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA900028" 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

  • PRJNA900028 · 2 ✖

analysis 1

  • blastn · 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
13629088 13629088 PRJNA900028_P_NODE_2311_length_730_cov_6.985316_g1647_i0 PRJNA900028 2311 730 6.985316 50.9928068 Rhizophydium sp. 2012224 Fungi Fungi 446 2.87e-120   NTclustered gi|1866582435|gb|MT730610.1| 2012224 g1647 i0 81.787 80.4164383561644 582 61 79 26 1 574 3956 4500 Rhizophydium sp. isolate ARG035 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 58704 446 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Rhizophydiales Rhizophydiaceae Rhizophydium Rhizophydium sp.
18726171 18726171 PRJNA900028_P_NODE_14895_length_300_cov_3.944223_g14146_i0 PRJNA900028 14895 300 3.944223 11.832669 Spizellomyces punctatus 109760 Fungi Fungi 285 2.5299999999999996e-72   NTclustered gi|1027029543|ref|XR_001677161.1| 645134 g14146 i0 99.363 52.0433333333333 157 1 52 0 144 300 4037 3881 Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA blastn 15613 285 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Spizellomycetaceae Spizellomyces Spizellomyces punctatus

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