RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1044115" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 4 ✖

bioproject 1

  • PRJNA1044115 · 4 ✖

analysis 1

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
26971841 26971841 PRJNA1044115_P_NODE_19062_length_334_cov_2.283525_g18878_i0 PRJNA1044115 19062 334 2.283525 7.6269735 Limnospira platensis 118562 Bacteria Bacteria 129 7.969999999999999e-37   NR MDV7390511.1 3080829 g18878 i0 96.9 0.583832335329341 65 2 58.4 0 239 45 1 65 MDV7390511.1 hypothetical protein [Arthrospira platensis SPKY1] diamond 195 129 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
27383000 27383000 PRJNA1044115_P_NODE_27823_length_278_cov_1.039024_g27639_i0 PRJNA1044115 27823 278 1.039024 2.88848672 Prochlorococcus sp. 1220 Bacteria Bacteria 42.7 0.0424   NR MFL0780659.1 1220 g27639 i0 44.7 0.410071942446043 38 21 41 0 28 141 151 188 MFL0780659.1 chromate transporter [Prochlorococcus sp.] diamond 114 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp.
30635359 30635359 PRJNA1044115_P_NODE_24193_length_295_cov_3.162162_g24009_i0 PRJNA1044115 24193 295 3.162162 9.3283779 Limnospira platensis 118562 Bacteria Bacteria 104 2.79e-26   NR MDV7397631.1 3080829 g24009 i0 91.1 0.569491525423729 56 5 56.9 0 170 3 6 61 MDV7397631.1 hypothetical protein [Arthrospira platensis SPKY1] diamond 168 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
31046562 31046562 PRJNA1044115_P_NODE_22535_length_306_cov_1.879828_g22351_i0 PRJNA1044115 22535 306 1.879828 5.75227368 Limnospira platensis 118562 Bacteria Bacteria 115 2.5399999999999996e-31   NR MDV7390511.1 3080829 g22351 i0 83.1 0.637254901960784 65 11 63.7 0 112 306 1 65 MDV7390511.1 hypothetical protein [Arthrospira platensis SPKY1] diamond 195 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis

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