RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1010780" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1010780 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
14183855 14183855 PRJNA1010780_S_NODE_59832_length_155_cov_2.133333_g58543_i0 PRJNA1010780 59832 155 2.133333 3.30666615 Chlorobiota bacterium 2268192 Bacteria Bacteria 54.7 6.73e-7   NR KAA0247851.1 2268192 g58543 i0 54 0.967741935483871 50 23 96.8 0 152 3 305 354 KAA0247851.1 MAG: hybrid sensor histidine kinase/response regulator [Chlorobiota bacterium] diamond 150 54.7 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
27414165 27414165 PRJNA1010780_S_NODE_54123_length_166_cov_1.236641_g52834_i0 PRJNA1010780 54123 166 1.236641 2.05282406 Chlorobiota bacterium 2268192 Bacteria Bacteria 53.5 1.85e-6   NR MBL0333029.1 2268192 g52834 i0 65.1 0.77710843373494 43 15 77.7 0 36 164 5 47 MBL0333029.1 ABC transporter ATP-binding protein [Chlorobiota bacterium] diamond 129 53.5 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
27919012 27919012 PRJNA1010780_S_NODE_46985_length_183_cov_1.547297_g45696_i0 PRJNA1010780 46985 183 1.547297 2.83155351 Chlorobiota bacterium 2268192 Bacteria Bacteria 70.5 2.85e-12   NR NOX19613.1 2268192 g45696 i0 62.5 1.88524590163934 56 19 91.8 1 174 7 584 637 NOX19613.1 hypothetical protein [Chlorobiota bacterium] diamond 345 70.5 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
29150861 29150861 PRJNA1010780_S_NODE_5889_length_1105_cov_13.333645_g5308_i0 PRJNA1010780 5889 1105 13.333645 147.33677725 Pelodictyon phaeoclathratiforme 34090 Bacteria Bacteria 343 5.57e-113   NR WP_012507627.1 34090 g5308 i0 49 5.76380090497738 353 169 95.6 4 25 1080 3 345 WP_012507627.1 SDR family oxidoreductase [Pelodictyon phaeoclathratiforme] diamond 6369 343 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Pelodictyon Pelodictyon phaeoclathratiforme
30634732 30634732 PRJNA1010780_S_NODE_20233_length_397_cov_3.701657_g18944_i0 PRJNA1010780 20233 397 3.701657 14.69557829 Chlorobium sp. 1095 Bacteria Bacteria 64.3 3.59e-9   NR MEI7707330.1 1095 g18944 i0 32.3 1.94962216624685 127 77 89.9 4 29 385 127 252 MEI7707330.1 hypothetical protein [Chlorobium sp.] diamond 774 64.3 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Chlorobium Chlorobium sp.
32784280 32784280 PRJNA1010780_S_NODE_44760_length_189_cov_3.331169_g43471_i0 PRJNA1010780 44760 189 3.331169 6.29590941 Chlorobiota bacterium 2268192 Bacteria Bacteria 85.9 7.91e-18   NR NPA35040.1 2268192 g43471 i0 58.3 9.50793650793651 60 25 95.2 0 10 189 324 383 NPA35040.1 elongation factor Tu [Chlorobiota bacterium] diamond 1797 85.9 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium

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