RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA577226 · 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
22238459 22238459 PRJNA577226_S_NODE_21118_length_275_cov_2.920168_g20179_i0 PRJNA577226 21118 275 2.920168 8.030462 Opisthokonta 33154 Fungi Fungi 114 5.5399999999999995e-30   NR KAJ1337677.1 5520 g20179 i0 80.6 715.625454545455 67 13 73.1 0 275 75 109 175 KAJ1337677.1 histone H4 [Microdochium nivale] diamond 196797 115 0.991304347826087 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Xylariales Microdochiaceae Microdochium Microdochium nivale
29461202 29461202 PRJNA577226_S_NODE_56610_length_166_cov_2.418605_g55671_i0 PRJNA577226 56610 166 2.418605 4.0148843 Eukaryota 2759 Fungi Fungi 50.8 2.19e-6   NR RKU46573.1 177199 g55671 i0 60 2.3855421686747 35 14 63.3 0 160 56 57 91 RKU46573.1 hypothetical protein DL546_004475 [Coniochaeta pulveracea] diamond 396 51.2 0.9921875 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Coniochaetales Coniochaetaceae Coniochaeta Coniochaeta pulveracea
32243197 32243197 PRJNA577226_S_NODE_9398_length_432_cov_3.088608_g8463_i0 PRJNA577226 9398 432 3.088608 13.34278656 root 1 Root_unresolved Root_unresolved 277 4.62e-93   NR KAK0349949.1 329885 g8463 i0 100 1.98611111111111 143 0 99.3 0 430 2 28 170 KAK0349949.1 hypothetical protein LTR94_031001, partial [Friedmanniomyces endolithicus] diamond 858 277 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Friedmanniomyces Friedmanniomyces endolithicus
32482603 32482603 PRJNA577226_S_NODE_38099_length_201_cov_3.067073_g37160_i0 PRJNA577226 38099 201 3.067073 6.16481673 Teloschistes peruensis 2903223 Fungi Fungi 50.4 3.07e-5   NR KAI4087079.1 2903223 g37160 i0 58.8 1.49253731343284 34 14 50.7 0 201 100 112 145 KAI4087079.1 MAG: hypothetical protein L6R37_008358 [Teloschistes peruensis] diamond 300 50.4 1 Eukaryota Opisthokonta Fungi Ascomycota Lecanoromycetes Teloschistales Teloschistaceae Teloschistes Teloschistes peruensis

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