RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1199893" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1199893 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2320010 2320010 PRJNA1199893_P_NODE_8782_length_322_cov_2.064257_g8707_i0 PRJNA1199893 8782 322 2.064257 6.64690754 Opisthokonta 33154 Fungi Fungi 278 4.58e-70   NTclustered gi|1859980207|gb|MT645548.1| 76775 g8707 i0 100 76.6645962732919 150 0 66 0 173 322 333 482 Malassezia restricta strain RM11 large subunit ribosomal RNA gene, partial sequence blastn 24686 278 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
4153754 4153754 PRJNA1199893_P_NODE_2264_length_638_cov_3.198230_g2191_i0 PRJNA1199893 2264 638 3.19823 20.4047074 Rhodotorula graminis 29898 Fungi Fungi 399 1.97e-106   NTclustered gi|1069925624|ref|XM_018418617.1| 578459 g2191 i0 80.073 80.9561128526646 547 101 85 8 66 608 543 1 Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_64935), partial mRNA blastn 51650 399 1 Eukaryota Opisthokonta Fungi Basidiomycota Microbotryomycetes Sporidiobolales Sporidiobolaceae Rhodotorula Rhodotorula graminis
5429787 5429787 PRJNA1199893_P_NODE_10705_length_291_cov_1.527523_g10630_i0 PRJNA1199893 10705 291 1.527523 4.44509193 Kalmanozyma brasiliensis 1392244 Fungi Fungi 211 4.2e-50   NTclustered gi|1023177687|ref|XM_016436031.1| 1365824 g10630 i0 81.746 79.3814432989691 252 46 87 0 1 252 142 393 Kalmanozyma brasiliensis GHG001 Small GTPase superfamily, ARF/SAR type (PSEUBRA_000406), partial mRNA blastn 23100 211 1 Eukaryota Opisthokonta Fungi Basidiomycota Ustilaginomycetes Ustilaginales Ustilaginaceae Kalmanozyma Kalmanozyma brasiliensis
6704642 6704642 PRJNA1199893_P_NODE_5026_length_428_cov_1.971831_g4953_i0 PRJNA1199893 5026 428 1.971831 8.43943668 Malassezia restricta 76775 Fungi Fungi 780 0   NTclustered gi|1546635598|ref|XR_003525370.1| 76775 g4953 i0 99.533 106.71261682243 428 2 100 0 1 428 1923 1496 Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA blastn 45673 780 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
15629739 15629739 PRJNA1199893_P_NODE_7093_length_361_cov_1.083333_g7019_i0 PRJNA1199893 7093 361 1.083333 3.91083213 Malassezia restricta 76775 Fungi Fungi 651 0   NTclustered gi|1546635598|ref|XR_003525370.1| 76775 g7019 i0 99.169 89.7839335180055 361 3 100 0 1 361 3342 2982 Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA blastn 32412 651 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta

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