RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 3 ✖

bioproject 1

  • PRJNA356682 · 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
26870829 26870829 PRJNA356682_P_NODE_44721_length_241_cov_0.916667_g44030_i0 PRJNA356682 44721 241 0.916667 2.20916747 Chlorellaceae 35461 Plants Plants 43.1 0.0273   NR PRW56706.1 3076 g44030 i0 50 1.26970954356846 34 17 42.3 0 1 102 788 821 PRW56706.1 septin and tuftelin-interacting 1-like protein 1 [Chlorella sorokiniana] diamond 306 43.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
29190759 29190759 PRJNA356682_P_NODE_40409_length_246_cov_0.890173_g39718_i0 PRJNA356682 40409 246 0.890173 2.18982558 Chlorella ohadii 2649997 Plants Plants 130 1.97e-36   NR KAI7840626.1 2649997 g39718 i0 81.7 4 82 12 98.8 2 3 245 32 111 KAI7840626.1 hypothetical protein COHA_005648 [Chlorella ohadii] diamond 984 130 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella ohadii
31275492 31275492 PRJNA356682_P_NODE_37815_length_249_cov_0.875000_g37124_i0 PRJNA356682 37815 249 0.875 2.17875 Helicosporidium sp. ATCC 5 1907511 Plants Plants 72.8 3.49e-13   NR KDD76536.1 1291522 g37124 i0 44.9 4.30120481927711 78 40 91.6 2 240 13 5 81 KDD76536.1 hypothetical protein H632_c191p1 [Helicosporidium sp. ATCC 50920] diamond 1071 72.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Helicosporidium Helicosporidium sp. ATCC 50920

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