RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA688157 · 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
666830 666830 PRJNA688157_S_NODE_30921_length_348_cov_2.745455_g30779_i0 PRJNA688157 30921 348 2.745455 9.5541834 Malassezia globosa 76773 Fungi Fungi 584 2.63e-162   NTclustered gi|164659138|ref|XM_001730642.1| 425265 g30779 i0 98.204 17.8908045977011 334 6 96 0 15 348 889 556 Malassezia globosa CBS 7966 uncharacterized protein (MGL_2148), partial mRNA blastn 6226 584 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
1942813 1942813 PRJNA688157_S_NODE_79742_length_257_cov_1.690217_g79600_i0 PRJNA688157 79742 257 1.690217 4.34385769 Malassezia globosa 76773 Fungi Fungi 475 1.1699999999999999e-129   NTclustered gi|1805972860|gb|CP046440.1| 76773 g79600 i0 100 46.2529182879377 257 0 100 0 1 257 30090 29834 Malassezia globosa strain CBS7966 mitochondrion, complete genome blastn 11887 475 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
10870873 10870873 PRJNA688157_S_NODE_76609_length_261_cov_2.207447_g76467_i0 PRJNA688157 76609 261 2.207447 5.76143667 Malassezia restricta 76775 Fungi Fungi 475 1.1899999999999999e-129   NTclustered gi|1546638659|ref|XM_027630971.1| 76775 g76467 i0 99.615 1.15708812260536 260 1 99 0 2 261 574 315 Malassezia restricta cell division control protein 42 (MRET_4344), partial mRNA blastn 302 475 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
13420789 13420789 PRJNA688157_S_NODE_45991_length_311_cov_5.029412_g45849_i0 PRJNA688157 45991 311 5.029412 15.64147132 Malassezia globosa 76773 Fungi Fungi 569 6.489999999999998e-158   NTclustered gi|1805972860|gb|CP046440.1| 76773 g45849 i0 100 46.6913183279743 308 0 99 0 4 311 2992 2685 Malassezia globosa strain CBS7966 mitochondrion, complete genome blastn 14521 569 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
24892960 24892960 PRJNA688157_S_NODE_61660_length_283_cov_2.295238_g61518_i0 PRJNA688157 61660 283 2.295238 6.49552354 Malassezia restricta 76775 Fungi Fungi 383 8.15e-102   NTclustered gi|1546636765|ref|XM_027630025.1| 76775 g61518 i0 94.048 0.890459363957597 252 15 89 0 1 252 1393 1644 Malassezia restricta myo-inositol-1-phosphate synthase (MRET_3398), partial mRNA blastn 252 383 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);;