RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA454154" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA454154 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27629598 27629598 PRJNA454154_S_NODE_264_length_205_cov_2.142857_g261_i0 PRJNA454154 264 205 2.142857 4.39285685 root 1 Root_unresolved Root_unresolved 45.1 0.00165   NR PCD39121.1 5518 g261 i0 57.1 2.18048780487805 35 15 51.2 0 192 88 95 129 PCD39121.1 hypothetical protein FGRA07_00392 [Fusarium graminearum] diamond 447 45.1 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium graminearum
27897280 27897280 PRJNA454154_S_NODE_325_length_193_cov_1.557692_g322_i0 PRJNA454154 325 193 1.557692 3.00634556 Saccharomycopsis crataegensis 43959 Fungi Fungi 67.8 1.44e-12   NR XP_064850582.1 43959 g322 i0 74.4 2.6580310880829 43 11 66.8 0 192 64 84 126 XP_064850582.1 profilin [Saccharomycopsis crataegensis] diamond 513 67.8 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Ascoideales Saccharomycopsidaceae Saccharomycopsis Saccharomycopsis crataegensis
29113512 29113512 PRJNA454154_S_NODE_688_length_150_cov_2.486726_g685_i0 PRJNA454154 688 150 2.486726 3.730089 Ascomycota 4890 Fungi Fungi 60.1 6.61e-9   NR XP_018734185.1 796027 g685 i0 57.8 7.32 45 19 90 0 150 16 249 293 XP_018734185.1 Ymc1p [Sugiyamaella lignohabitans] diamond 1098 60.5 0.993388429752066 Eukaryota Opisthokonta Fungi Ascomycota Dipodascomycetes Dipodascales Trichomonascaceae Sugiyamaella Sugiyamaella lignohabitans
30755919 30755919 PRJNA454154_S_NODE_634_length_154_cov_1.188034_g631_i0 PRJNA454154 634 154 1.188034 1.82957236 Opisthokonta 33154 Fungi Fungi 77.8 1.11e-16   NR KAG4304737.1 42067 g631 i0 68 7.83116883116883 50 16 97.4 0 150 1 43 92 KAG4304737.1 hypothetical protein PORY_001790 [Pneumocystis oryctolagi] diamond 1206 78.2 0.994884910485933 Eukaryota Opisthokonta Fungi Ascomycota Pneumocystomycetes Pneumocystales Pneumocystaceae Pneumocystis Pneumocystis oryctolagi
32020632 32020632 PRJNA454154_S_NODE_298_length_197_cov_3.056250_g295_i0 PRJNA454154 298 197 3.05625 6.0208125 Fungi 4751 Fungi Fungi 62 2.55e-10   NR KAF8422077.1 160517 g295 i0 71.1 16.4467005076142 45 13 68.5 0 196 62 79 123 KAF8422077.1 ribosomal L29 protein-domain-containing protein [Tirmania nivea] diamond 3240 62 1 Eukaryota Opisthokonta Fungi Ascomycota Pezizomycetes Pezizales Pezizaceae Tirmania Tirmania nivea

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