RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1008049 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
26812992 26812992 PRJNA1008049_S_NODE_2401_length_177_cov_3.851351_g2383_i0 PRJNA1008049 2401 177 3.851351 6.81689127 Malassezia globosa CBS 7966 425265 Fungi Fungi 62 2.39e-9   NR XP_001731550.1 425265 g2383 i0 100 0.406779661016949 24 0 40.7 0 3 74 488 511 XP_001731550.1 uncharacterized protein MGL_1733 [Malassezia globosa CBS 7966] diamond 72 62 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
27982131 27982131 PRJNA1008049_S_NODE_1025_length_208_cov_5.804469_g1007_i0 PRJNA1008049 1025 208 5.804469 12.07329552 Malassezia restricta CBS 7877 425264 Fungi Fungi 97.4 8.65e-24   NR AYO42766.1 425264 g1007 i0 76.3 1.70192307692308 59 14 85.1 0 206 30 100 158 AYO42766.1 hypothetical protein DNF11_1816 [Malassezia restricta CBS 7877] diamond 354 97.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
28392536 28392536 PRJNA1008049_S_NODE_1766_length_186_cov_2.484076_g1748_i0 PRJNA1008049 1766 186 2.484076 4.62038136 Malassezia caprae 1381934 Fungi Fungi 89.4 2.32e-21   NR WFD21081.1 1381934 g1748 i0 68.9 0.983870967741935 61 19 98.4 0 2 184 23 83 WFD21081.1 hypothetical protein MCAP1_003338 [Malassezia caprae] diamond 183 89.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia caprae
28645254 28645254 PRJNA1008049_S_NODE_1867_length_184_cov_4.374194_g1849_i0 PRJNA1008049 1867 184 4.374194 8.04851696 Malassezia globosa CBS 7966 425265 Fungi Fungi 91.3 6.98e-20   NR XP_001729783.1 425265 g1849 i0 68.3 0.978260869565217 60 19 97.8 0 181 2 214 273 XP_001729783.1 putative aspartyl protease [Malassezia globosa CBS 7966] diamond 180 91.3 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
28645255 28645255 PRJNA1008049_S_NODE_287_length_285_cov_5.027344_g269_i0 PRJNA1008049 287 285 5.027344 14.3279304 Malassezia restricta 76775 Fungi Fungi 46.2 8.26e-4   NR XP_027485494.1 76775 g269 i0 88.5 0.536842105263158 26 3 27.4 0 8 85 89 114 XP_027485494.1 large subunit ribosomal protein L34e [Malassezia restricta] diamond 153 46.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
29781771 29781771 PRJNA1008049_S_NODE_871_length_215_cov_20.865591_g853_i0 PRJNA1008049 871 215 20.865591 44.86102065 Malassezia arunalokei 1514897 Fungi Fungi 71.2 2.35e-12   NR WFD16437.1 1514897 g853 i0 100 0.488372093023256 35 0 48.8 0 51 155 2838 2872 WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] diamond 105 71.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia arunalokei
30634644 30634644 PRJNA1008049_S_NODE_3513_length_163_cov_7.932836_g3495_i0 PRJNA1008049 3513 163 7.932836 12.93052268 Malassezia globosa CBS 7966 425265 Fungi Fungi 101 6.88e-24   NR XP_001729783.1 425265 g3495 i0 83 0.975460122699387 53 9 97.5 0 3 161 306 358 XP_001729783.1 putative aspartyl protease [Malassezia globosa CBS 7966] diamond 159 101 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa

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