RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA897077" 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 · 5 ✖

bioproject 1

  • PRJNA897077 · 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
8526404 8526404 PRJNA897077_P_NODE_16087_length_251_cov_0.876404_g15960_i0 PRJNA897077 16087 251 0.876404 2.19977404 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 79.7 3.93e-15   NR MEB3305071.1 2847862 g15960 i0 97.4 0.466135458167331 39 1 46.6 0 133 249 1 39 MEB3305071.1 polyphosphate kinase 1 [Cyanobacteriota bacterium] diamond 117 79.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27150108 27150108 PRJNA897077_P_NODE_19802_length_242_cov_0.923077_g19675_i0 PRJNA897077 19802 242 0.923077 2.23384634 Tolypothrix carrinoi 1874533 Bacteria Bacteria 72.4 1.25e-12   NR MBW4570784.1 1874569 g19675 i0 45 0.991735537190083 80 44 99.2 0 1 240 18 97 MBW4570784.1 S8 family serine peptidase [Tolypothrix carrinoi HA7290-LM1] diamond 240 72.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Tolypothrix Tolypothrix carrinoi
29140191 29140191 PRJNA897077_P_NODE_16109_length_251_cov_0.876404_g15982_i0 PRJNA897077 16109 251 0.876404 2.19977404 Cyanobium gracile 59930 Bacteria Bacteria 79.7 3.99e-15   NR WP_015110162.1 59930 g15982 i0 50.6 0.99203187250996006 83 41 99.2 0 1 249 478 560 WP_015110162.1 hypothetical protein [Cyanobium gracile] diamond 249 79.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium gracile
29960914 29960914 PRJNA897077_P_NODE_19551_length_243_cov_0.917647_g19424_i0 PRJNA897077 19551 243 0.917647 2.22988221 Chroococcus sp. FPU1 1974212 Bacteria Bacteria 90.1 8.07e-19   NR WP_206815285.1 1974212 g19424 i0 92.3 0.641975308641975 52 4 64.2 0 243 88 673 724 WP_206815285.1 PAS domain-containing hybrid sensor histidine kinase/response regulator [Chroococcus sp. FPU101] diamond 156 90.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chroococcus Chroococcus sp. FPU101
32047268 32047268 PRJNA897077_P_NODE_16018_length_251_cov_0.876404_g15891_i0 PRJNA897077 16018 251 0.876404 2.19977404 Microcystis aeruginosa 1126 Bacteria Bacteria 56.2 7.27e-7   NR WP_185240507.1 1126 g15891 i0 51 1.82868525896414 51 25 61 0 23 175 543 593 WP_185240507.1 serine/threonine-protein kinase [Microcystis aeruginosa] diamond 459 56.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa

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