RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1054617 · 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
6114420 6114420 PRJNA1054617_S_NODE_8285_length_198_cov_0.987097_g8197_i0 PRJNA1054617 8285 198 0.987097 1.95445206 Malassezia 55193 Fungi Fungi 307 3.32e-79   NTclustered gi|1546635598|ref|XR_003525370.1| 76775 g8197 i0 99.408 84.4292929292929 169 1 85 0 30 198 34 202 Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA blastn 16717 307 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
11655068 11655068 PRJNA1054617_S_NODE_5150_length_240_cov_1.634518_g5062_i0 PRJNA1054617 5150 240 1.634518 3.9228432 Malassezia restricta 76775 Fungi Fungi 189 1.58e-43   NTclustered gi|1546630011|ref|XM_027626666.1| 76775 g5062 i0 100 0.808333333333333 102 0 43 0 1 102 1366 1467 Malassezia restricta oligosaccharyltransferase complex subunit alpha (ribophorin I) (MRET_0039), partial mRNA blastn 194 189 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
18028309 18028309 PRJNA1054617_S_NODE_13675_length_160_cov_4.264957_g13587_i0 PRJNA1054617 13675 160 4.264957 6.8239312 Malassezia restricta 76775 Fungi Fungi 296 5.55e-76   NTclustered gi|1546632316|ref|XM_027627818.1| 76775 g13587 i0 100 1 160 0 100 0 1 160 423 582 Malassezia restricta U3 small nucleolar RNA-associated protein 23 (MRET_1191), partial mRNA blastn 160 296 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
21853332 21853332 PRJNA1054617_S_NODE_11118_length_175_cov_3.303030_g11030_i0 PRJNA1054617 11118 175 3.30303 5.7803025 Rhizopogon vinicolor 80600 Fungi Fungi 54.7 0.004   NTclustered gi|1693287358|ref|NC_042699.1| 80600 g11030 i0 87.5 0.274285714285714 48 4 27 2 35 82 75201 75156 Rhizopogon vinicolor mitochondrion, complete genome blastn 48 54.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Boletales Rhizopogonaceae Rhizopogon Rhizopogon vinicolor
23128789 23128789 PRJNA1054617_S_NODE_11799_length_171_cov_1.078125_g11711_i0 PRJNA1054617 11799 171 1.078125 1.84359375 Malassezia restricta 76775 Fungi Fungi 311 2.14e-80   NTclustered gi|1546634690|ref|XM_027629004.1| 76775 g11711 i0 99.415 2 171 1 100 0 1 171 2619 2449 Malassezia restricta multifunctional beta-oxidation protein (MRET_2377), partial mRNA blastn 342 311 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);;