RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA683902 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27682773 27682773 PRJNA683902_S_NODE_31584_length_173_cov_1.338235_g31140_i0 PRJNA683902 31584 173 1.338235 2.31514655 Microbotryum lychnidis-dioicae p1A1 Lamole 683840 Fungi Fungi 105 2.3400000000000003e-27   NR KDE09772.1 683840 g31140 i0 86 3.95375722543353 57 8 98.8 0 171 1 59 115 KDE09772.1 40S ribosomal protein S18 [Microbotryum lychnidis-dioicae p1A1 Lamole] diamond 684 105 1 Eukaryota Opisthokonta Fungi Basidiomycota Microbotryomycetes Microbotryales Microbotryaceae Microbotryum Microbotryum lychnidis-dioicae
28641427 28641427 PRJNA683902_S_NODE_21847_length_223_cov_1.645161_g21403_i0 PRJNA683902 21847 223 1.645161 3.66870903 Boletaceae 5368 Fungi Fungi 67 4.08e-12   NR KIJ70565.1 994086 g21403 i0 54.4 4.57399103139013 68 31 91.5 0 1 204 13 80 KIJ70565.1 hypothetical protein HYDPIDRAFT_105305 [Hydnomerulius pinastri MD-312] diamond 1020 67 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Boletales   Leucogyrophana Leucogyrophana pinastri
29260928 29260928 PRJNA683902_S_NODE_30189_length_178_cov_1.070922_g29745_i0 PRJNA683902 30189 178 1.070922 1.90624116 Mycena leptocephala 230808 Fungi Fungi 42 0.03   NR KAJ7901517.1 230808 g29745 i0 47.7 1.48314606741573 44 17 74.2 2 172 41 600 637 KAJ7901517.1 hypothetical protein B0H13DRAFT_1882938 [Mycena leptocephala] diamond 264 42 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Mycenaceae Mycena Mycena leptocephala

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