RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA559720" 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

  • PRJNA559720 · 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
5647355 5647355 PRJNA559720_P_NODE_14865_length_246_cov_1.578035_g14726_i0 PRJNA559720 14865 246 1.578035 3.8819661 Malassezia restricta 76775 Fungi Fungi 433 6.79e-117   NTclustered gi|1546638001|ref|XM_027630642.1| 76775 g14726 i0 98.374 1 246 4 100 0 1 246 449 204 Malassezia restricta fatty acid desaturase (MRET_4015), partial mRNA blastn 246 433 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
9472092 9472092 PRJNA559720_P_NODE_13568_length_251_cov_0.865169_g13429_i0 PRJNA559720 13568 251 0.865169 2.17157419 Malassezia restricta 76775 Fungi Fungi 464 2.47e-126   NTclustered gi|1546632870|ref|XM_027628095.1| 76775 g13429 i0 100 1.25099601593625 251 0 100 0 1 251 40 290 Malassezia restricta large subunit ribosomal protein L22e (MRET_1468), partial mRNA blastn 314 464 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
9472100 9472100 PRJNA559720_P_NODE_14248_length_249_cov_0.875000_g14109_i0 PRJNA559720 14248 249 0.875 2.17875 Malassezia globosa 76773 Fungi Fungi 444 3.18e-120   NTclustered gi|164657158|ref|XM_001729654.1| 425265 g14109 i0 98.795 1 249 3 100 0 1 249 928 680 Malassezia globosa CBS 7966 uncharacterized protein (MGL_3250), partial mRNA blastn 249 444 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
10747852 10747852 PRJNA559720_P_NODE_14809_length_247_cov_0.885057_g14670_i0 PRJNA559720 14809 247 0.885057 2.18609079 Malassezia restricta 76775 Fungi Fungi 457 4.05e-124   NTclustered gi|1546630921|ref|XM_027627121.1| 76775 g14670 i0 100 1 247 0 100 0 1 247 837 1083 Malassezia restricta ethanolaminephosphotransferase (MRET_0494), partial mRNA blastn 247 457 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
18981768 18981768 PRJNA559720_P_NODE_15935_length_242_cov_1.502959_g15796_i0 PRJNA559720 15935 242 1.502959 3.63716078 Tremellomycetes 155616 Fungi Fungi 241 4.33e-59   NTclustered gi|2669745353|ref|XM_062771525.1| 143232 g15796 i0 84.615 29.900826446281 247 32 99 5 2 242 334 88 Vanrija pseudolonga 40S ribosomal protein S10-B (rps1002), mRNA blastn 7236 243 0.991769547325103 Eukaryota Opisthokonta Fungi Basidiomycota Tremellomycetes Trichosporonales Trichosporonaceae Vanrija Vanrija pseudolonga

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