RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax_kingdom = "Fungi"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Fungi · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA314497 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
26599186 26599186 PRJNA314497_P_NODE_1281_length_492_cov_3.382289_g1142_i0 PRJNA314497 1281 492 3.382289 16.64086188 Elsinoe fawcettii 40997 Fungi Fungi 117 5.37e-27   NR KAF4547717.1 40997 g1142 i0 42 1.68292682926829 138 80 84.1 0 4 417 2349 2486 KAF4547717.1 AMP-binding enzyme 2 [Elsinoe fawcettii] diamond 828 117 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Myriangiales Elsinoaceae Elsinoe Elsinoe fawcettii
28274368 28274368 PRJNA314497_S_NODE_126_length_621_cov_6.712838_g111_i0 PRJNA314497 126 621 6.712838 41.68672398 Mycena metata 1033252 Fungi Fungi 381 1.86e-131   NR KAJ7746270.1 1033252 g111 i0 97.4 0.927536231884058 192 5 92.8 0 2 577 105 296 KAJ7746270.1 Arv1-like family-domain-containing protein [Mycena metata] diamond 576 381 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Mycenaceae Mycena Mycena metata
32192482 32192482 PRJNA314497_S_NODE_1958_length_157_cov_2.234375_g1935_i0 PRJNA314497 1958 157 2.234375 3.50796875 Phyllosticta citricarpa 55181 Fungi Fungi 45.8 9.57e-4   NR KAK7540103.1 55181 g1935 i0 70.4 1.5477707006369399 27 8 51.6 0 2 82 569 595 KAK7540103.1 hypothetical protein IWX46DRAFT_606636 [Phyllosticta citricarpa] diamond 243 45.8 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Botryosphaeriales Phyllostictaceae Phyllosticta Phyllosticta citricarpa
32666462 32666462 PRJNA314497_P_NODE_4820_length_162_cov_1.654135_g4668_i0 PRJNA314497 4820 162 1.654135 2.6796987 Scheffersomyces stipitis 4924 Fungi Fungi 58.2 3.85e-8   NR KAG2732346.1 4924 g4668 i0 60 2.5 45 18 83.3 0 161 27 258 302 KAG2732346.1 hypothetical protein G9P44_004763 [Scheffersomyces stipitis] diamond 405 58.2 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Serinales Debaryomycetaceae Scheffersomyces Scheffersomyces stipitis

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