RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB6097" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJEB6097 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_kingdom 0

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
22669183 22669183 PRJEB6097_S_NODE_458_length_445_cov_28832.412195_g404_i0 PRJEB6097 458 445 28832.412195 128304.23426775 Ochromonas danica 2986 SAR_Eukaryotes SAR_Eukaryotes 119 8.63e-30   NR NP_066421.1 2986 g404 i0 77.8 0.485393258426966 72 16 48.5 0 3 218 190 261 NP_066421.1 ribosomal protein L2 [Ochromonas danica] diamond 216 119 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
26780547 26780547 PRJEB6097_S_NODE_6661_length_153_cov_2.372881_g6607_i0 PRJEB6097 6661 153 2.372881 3.63050793 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0251   NR KAJ1425508.1 483371 g6607 i0 76.7 0.588235294117647 30 7 58.8 0 151 62 188 217 KAJ1425508.1 ribosomal protein S6, partial [Ochromonadaceae sp. CCMP2298] diamond 90 41.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28391685 28391685 PRJEB6097_S_NODE_6806_length_150_cov_1.513043_g6752_i0 PRJEB6097 6806 150 1.513043 2.2695645 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82 2.85e-19   NR MES1911722.1 1215613 g6752 i0 75 0.96 48 12 96 0 146 3 1 48 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 144 82 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28896744 28896744 PRJEB6097_S_NODE_5588_length_197_cov_2.166667_g5534_i0 PRJEB6097 5588 197 2.166667 4.26833399 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.45e-12   NR KAJ1401815.1 483371 g5534 i0 84.6 1.18781725888325 39 6 59.4 0 1 117 102 140 KAJ1401815.1 ubiquitin-related domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 234 68.2 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31582353 31582353 PRJEB6097_S_NODE_5956_length_176_cov_1.602837_g5902_i0 PRJEB6097 5956 176 1.602837 2.82099312 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.95e-10   NR KAJ1422858.1 483371 g5902 i0 81.8 0.5625 33 6 56.3 0 176 78 50 82 KAJ1422858.1 ribosomal protein S27 [Ochromonadaceae sp. CCMP2298] diamond 99 60.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298

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