RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA864829" 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

  • PRJNA864829 · 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
30189560 30189560 PRJNA864829_S_NODE_7712_length_222_cov_2.924855_g7626_i0 PRJNA864829 7712 222 2.924855 6.4931781 Opisthokonta 33154 Fungi Fungi 132 6.529999999999999e-37   NR KAK0436538.1 47425 g7626 i0 84.9 22.6891891891892 73 11 98.6 0 220 2 87 159 KAK0436538.1 thioredoxin-like protein [Armillaria borealis] diamond 5037 133 0.992481203007519 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Physalacriaceae Armillaria Armillaria borealis
30686909 30686909 PRJNA864829_S_NODE_12313_length_182_cov_2.563910_g12227_i0 PRJNA864829 12313 182 2.56391 4.6663162 Malassezia arunalokei 1514897 Fungi Fungi 58.2 5.97e-8   NR WFD15251.1 1514897 g12227 i0 64.9 2.48901098901099 37 13 61 0 6 116 622 658 WFD15251.1 hypothetical protein MARU1_001267 [Malassezia arunalokei] diamond 453 58.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia arunalokei
30876601 30876601 PRJNA864829_S_NODE_8614_length_212_cov_2.858896_g8528_i0 PRJNA864829 8614 212 2.858896 6.06085952 Mycena floridula 1033242 Fungi Fungi 42.4 0.0329   NR KAJ7594971.1 1033242 g8528 i0 40.4 0.665094339622642 47 24 66.5 1 147 7 105 147 KAJ7594971.1 hypothetical protein C8J56DRAFT_928118 [Mycena floridula] diamond 141 42.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Mycenaceae Mycena Mycena floridula

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