RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA982720" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA982720 · 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
28510705 28510705 PRJNA982720_S_NODE_8267_length_256_cov_3.426230_g8239_i0 PRJNA982720 8267 256 3.42623 8.7711488 Fusarium oxysporum 5507 Fungi Fungi 109 3.48e-26   NR KAJ4050974.1 5507 g8239 i0 86.4 0.69140625 59 8 69.1 0 3 179 89 147 KAJ4050974.1 hypothetical protein NW753_007579 [Fusarium oxysporum] diamond 177 109 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium oxysporum
30342813 30342813 PRJNA982720_S_NODE_6052_length_286_cov_4.342723_g6024_i0 PRJNA982720 6052 286 4.342723 12.42018778 Sarocladium strictum 5046 Fungi Fungi 156 2.8599999999999993e-43   NR KAK0391662.1 5046 g6024 i0 92.3 1.63636363636364 78 6 81.8 0 53 286 20 97 KAK0391662.1 hypothetical protein NLU13_1161 [Sarocladium strictum] diamond 468 156 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Sarocladiaceae Sarocladium Sarocladium strictum
31194965 31194965 PRJNA982720_S_NODE_9315_length_245_cov_2.558140_g9287_i0 PRJNA982720 9315 245 2.55814 6.267443 Sarocladium implicatum 1610689 Fungi Fungi 47 0.00115   NR KAH8170626.1 1610689 g9287 i0 33.9 0.722448979591837 59 39 72.2 0 63 239 1 59 KAH8170626.1 hypothetical protein LIA77_09407 [Sarocladium implicatum] diamond 177 47 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Sarocladiaceae Sarocladium Sarocladium implicatum

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