RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA478247 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1722526 1722526 PRJNA478247_P_NODE_3082_length_173_cov_1.729167_g2976_i0 PRJNA478247 3082 173 1.729167 2.99145891 Cutaneotrichosporon cavernicola 279322 Fungi Fungi 193 8.21e-45   NTclustered gi|2612508706|ref|XM_060602780.1| 279322 g2976 i0 88.344 74.4508670520231 163 15 93 3 1 161 471 311 Cutaneotrichosporon cavernicola uncharacterized protein (PET9), partial mRNA blastn 12880 193 1 Eukaryota Opisthokonta Fungi Basidiomycota Tremellomycetes Trichosporonales Trichosporonaceae Cutaneotrichosporon Cutaneotrichosporon cavernicola
3648287 3648287 PRJNA478247_P_NODE_3443_length_157_cov_2.718750_g3337_i0 PRJNA478247 3443 157 2.71875 4.2684375 Symmetrospora 1798808 Fungi Fungi 291 2.52e-74   NTclustered gi|1393511528|ref|NG_058410.1| 5434 g3337 i0 100 100.127388535032 157 0 100 0 1 157 644 800 Symmetrospora foliicola CBS 8075 28S rRNA gene, partial sequence; from TYPE material blastn 15720 291 1 Eukaryota Opisthokonta Fungi Basidiomycota Cystobasidiomycetes   Symmetrosporaceae Symmetrospora Symmetrospora foliicola
5551410 5551410 PRJNA478247_P_NODE_1345_length_332_cov_2.075908_g1239_i0 PRJNA478247 1345 332 2.075908 6.89201456 Sporisorium reilianum 72558 Fungi Fungi 370 7.6e-98   NTclustered gi|85720448|gb|DQ352827.1| 72558 g1239 i0 86.747 96.9156626506024 332 44 100 0 1 332 155 486 Sporisorium reilianum isolate 326 elongation factor 1-alpha (EF1alpha) gene, partial cds blastn 32176 370 1 Eukaryota Opisthokonta Fungi Basidiomycota Ustilaginomycetes Ustilaginales Ustilaginaceae Sporisorium Sporisorium reilianum
23400030 23400030 PRJNA478247_P_NODE_2859_length_186_cov_1.974522_g2753_i0 PRJNA478247 2859 186 1.974522 3.67261092 Rhizoctonia solani 456999 Fungi Fungi 167 5.4399999999999995e-37   NTclustered gi|2086745886|ref|XM_043323488.1| 456999 g2753 i0 83.158 8.46774193548387 190 24 100 5 1 186 348 163 Rhizoctonia solani ribosomal Proteins L2, C-terminal domain (RhiXN_03671), partial mRNA blastn 1575 167 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Ceratobasidiaceae Rhizoctonia Rhizoctonia solani

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