RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA188516 · 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
27579410 27579410 PRJNA188516_P_NODE_5264_length_165_cov_0.896552_g5214_i0 PRJNA188516 5264 165 0.896552 1.4793108 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 99 9.53e-24   NR HEY9753936.1 3088181 g5214 i0 100 0.981818181818182 54 0 98.2 0 164 3 3 56 HEY9753936.1 response regulator transcription factor [Oculatellaceae cyanobacterium] diamond 162 99 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
28621533 28621533 PRJNA188516_P_NODE_5687_length_163_cov_0.912281_g5637_i0 PRJNA188516 5687 163 0.912281 1.48701803 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 96.7 1.13e-21   NR HEY9756923.1 3088181 g5637 i0 100 0.865030674846626 47 0 86.5 0 142 2 1 47 HEY9756923.1 SPFH domain-containing protein [Oculatellaceae cyanobacterium] diamond 141 96.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
29158348 29158348 PRJNA188516_P_NODE_4129_length_169_cov_0.866667_g4079_i0 PRJNA188516 4129 169 0.866667 1.46466723 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 115 4.61e-28   NR HEY9760369.1 3088181 g4079 i0 96.4 0.994082840236686 56 2 99.4 0 168 1 124 179 HEY9760369.1 ATP-binding protein [Oculatellaceae cyanobacterium] diamond 168 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
29316023 29316023 PRJNA188516_P_NODE_4029_length_169_cov_0.866667_g3979_i0 PRJNA188516 4029 169 0.866667 1.46466723 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 68.2 1.54e-12   NR HEY9755221.1 3088181 g3979 i0 100 0.585798816568047 33 0 58.6 0 100 2 1 33 HEY9755221.1 group III truncated hemoglobin [Oculatellaceae cyanobacterium] diamond 99 68.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30579229 30579229 PRJNA188516_P_NODE_5773_length_163_cov_0.912281_g5723_i0 PRJNA188516 5773 163 0.912281 1.48701803 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 113 2.36e-28   NR HEY9755099.1 3088181 g5723 i0 100 0.993865030674847 54 0 99.4 0 1 162 239 292 HEY9755099.1 NAD(P)-dependent alcohol dehydrogenase [Oculatellaceae cyanobacterium] diamond 162 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32051614 32051614 PRJNA188516_P_NODE_5378_length_164_cov_0.904348_g5328_i0 PRJNA188516 5378 164 0.904348 1.48313072 Cyanophyceae 3028117 Bacteria Bacteria 72.8 3.21e-13   NR WP_242578028.1 1974212 g5328 i0 66 2.94512195121951 53 18 97 0 6 164 392 444 WP_242578028.1 hypothetical protein [Chroococcus sp. FPU101] diamond 483 72.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chroococcus Chroococcus sp. FPU101

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