RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1065838", tax_clade = "Opisthokonta" 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

  • Opisthokonta · 5 ✖

bioproject 1

  • PRJNA1065838 · 5 ✖

analysis 1

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
2730653 2730653 PRJNA1065838_S_NODE_34423_length_165_cov_0.879310_g34321_i0 PRJNA1065838 34423 165 0.87931 1.4508615 Malassezia restricta 76775 Fungi Fungi 289 9.66e-74   NTclustered gi|1546635006|ref|XM_027629162.1| 76775 g34321 i0 98.182 1 165 3 100 0 1 165 59 223 Malassezia restricta DASH complex subunit DAD4 (MRET_2535), partial mRNA blastn 165 289 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
4006536 4006536 PRJNA1065838_S_NODE_31844_length_169_cov_0.866667_g31742_i0 PRJNA1065838 31844 169 0.866667 1.46466723 Malassezia sympodialis 76777 Fungi Fungi 161 2.25e-35   NTclustered gi|1092931389|ref|XM_018885390.1| 1230383 g31742 i0 84.242 0.976331360946746 165 26 98 0 1 165 931 767 Malassezia sympodialis ATCC 42132 Putative transglycosidases (GH 16 family)-like protein (UTR2), partial mRNA blastn 165 161 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia sympodialis
9107700 9107700 PRJNA1065838_S_NODE_32448_length_168_cov_0.865546_g32346_i0 PRJNA1065838 32448 168 0.865546 1.45411728 Malassezia restricta 76775 Fungi Fungi 311 2.11e-80   NTclustered gi|1546636609|ref|XM_027629947.1| 76775 g32346 i0 100 50.6726190476191 168 0 100 0 1 168 501 334 Malassezia restricta serine/threonine-protein phosphatase 4 catalytic subunit (MRET_3320), partial mRNA blastn 8513 311 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
20581128 20581128 PRJNA1065838_S_NODE_26877_length_182_cov_1.172932_g26775_i0 PRJNA1065838 26877 182 1.172932 2.13473624 Mycosarcoma maydis 5270 Fungi Fungi 141 3.21e-29   NTclustered gi|758980934|ref|XM_011391890.1| 5270 g26775 i0 83.553 2.17032967032967 152 23 83 2 30 180 948 1098 Mycosarcoma maydis putative adenosylhomocysteinase (UMAG_03734), partial mRNA blastn 395 141 1 Eukaryota Opisthokonta Fungi Basidiomycota Ustilaginomycetes Ustilaginales Ustilaginaceae Mycosarcoma Mycosarcoma maydis
20581204 20581204 PRJNA1065838_S_NODE_34957_length_164_cov_0.904348_g34855_i0 PRJNA1065838 34957 164 0.904348 1.48313072 Malassezia restricta 76775 Fungi Fungi 292 7.41e-75   NTclustered gi|1546634810|ref|XM_027629064.1| 76775 g34855 i0 98.78 1 164 2 100 0 1 164 279 442 Malassezia restricta transcription initiation factor TFIID subunit 10 (MRET_2437), partial mRNA blastn 164 292 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);;