RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA688157 · 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
29135117 29135117 PRJNA688157_S_NODE_39269_length_326_cov_1.644269_g39127_i0 PRJNA688157 39269 326 1.644269 5.36031694 Sarocladium implicatum 1610689 Fungi Fungi 209 1.87e-64   NR KAH8178064.1 1610689 g39127 i0 83.3 1.98773006134969 108 18 99.4 0 325 2 241 348 KAH8178064.1 alpha/beta hydrolase fold domain-containing protein [Sarocladium implicatum] diamond 648 209 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Sarocladiaceae Sarocladium Sarocladium implicatum
31536186 31536186 PRJNA688157_S_NODE_68936_length_272_cov_1.763819_g68794_i0 PRJNA688157 68936 272 1.763819 4.79758768 Cladosporium halotolerans 1052096 Fungi Fungi 95.5 1.46e-20   NR XP_069225492.1 1052096 g68794 i0 79.7 0.650735294117647 59 7 65.1 1 272 96 575 628 XP_069225492.1 uncharacterized protein WHR41_08899 [Cladosporium halotolerans] diamond 177 95.5 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium halotolerans
32863296 32863296 PRJNA688157_S_NODE_51840_length_300_cov_2.057269_g51698_i0 PRJNA688157 51840 300 2.057269 6.171807 Trematosphaeria pertusa 390896 Fungi Fungi 56.6 7.93e-7   NR XP_033675286.1 390896 g51698 i0 38.6 2.9 88 53 88 1 23 286 77 163 XP_033675286.1 uncharacterized protein BU26DRAFT_556950 [Trematosphaeria pertusa] diamond 870 56.6 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Trematosphaeriaceae Trematosphaeria Trematosphaeria pertusa

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