RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA177642 · 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
11844056 11844056 PRJNA177642_P_NODE_17430_length_167_cov_1.021739_g16205_i0 PRJNA177642 17430 167 1.021739 1.70630413 Hypholoma sublateritium FD-334 SS-4 945553 Fungi Fungi 91.7 4.94e-20   NR KJA21562.1 945553 g16205 i0 87.3 2.96407185628743 55 6 98.8 1 166 2 209 262 KJA21562.1 hypothetical protein HYPSUDRAFT_202904 [Hypholoma sublateritium FD-334 SS-4] diamond 495 91.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Strophariaceae Hypholoma Hypholoma sublateritium
30327221 30327221 PRJNA177642_P_NODE_19012_length_154_cov_3.232000_g17787_i0 PRJNA177642 19012 154 3.232 4.97728 Macrolepiota fuliginosa MF-IS2 1400762 Fungi Fungi 79.7 1.96e-17   NR KAF9450724.1 1400762 g17787 i0 75.6 1.81168831168831 45 11 87.7 0 3 137 57 101 KAF9450724.1 hypothetical protein P691DRAFT_700613 [Macrolepiota fuliginosa MF-IS2] diamond 279 79.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Agaricaceae Macrolepiota Macrolepiota fuliginosa
30660433 30660433 PRJNA177642_P_NODE_16333_length_173_cov_1.000000_g15108_i0 PRJNA177642 16333 173 1 1.73 Agaricomycetes 155619 Fungi Fungi 81.3 2.99e-16   NR GJE95822.1 48140 g15108 i0 70.7 2.01156069364162 58 16 98.8 1 1 171 304 361 GJE95822.1 3-deoxy-7-phosphoheptulonate synthase [Phanerochaete sordida] diamond 348 81.3 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Phanerochaetaceae Phanerochaete Phanerochaete sordida

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