RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA690592" and tax_phylum = "Candidatus Fermentibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Fermentibacterota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA690592 · 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
29324565 29324565 PRJNA690592_S_NODE_99949_length_328_cov_0.905882_g98935_i0 PRJNA690592 99949 328 0.905882 2.97129296 Candidatus Sabulitectum sp. 2822438 Bacteria Bacteria 43.9 0.0283   NR MCK5036067.1 2822438 g98935 i0 34 0.429878048780488 47 31 43 0 210 70 161 207 MCK5036067.1 XylR N-terminal domain-containing protein [Candidatus Sabulitectum sp.] diamond 141 43.9 1 Bacteria FCB group Pseudomonadati Candidatus Fermentibacterota       Candidatus Sabulitectum Candidatus Sabulitectum sp.
30998819 30998819 PRJNA690592_S_NODE_19434_length_676_cov_39.039801_g18485_i0 PRJNA690592 19434 676 39.039801 263.90905476 Candidatus Fermentibacterota bacterium 2044591 Bacteria Bacteria 115 2.11e-29   NR MBD3369599.1 2044591 g18485 i0 64.6 0.350591715976331 79 28 35.1 0 615 379 4 82 MBD3369599.1 RNA-binding protein [Candidatus Fermentibacterota bacterium] diamond 237 115 1 Bacteria FCB group Pseudomonadati Candidatus Fermentibacterota         Candidatus Fermentibacterota bacterium
32022180 32022180 PRJNA690592_S_NODE_4338_length_1264_cov_3.864819_g3886_i0 PRJNA690592 4338 1264 3.864819 48.85131216 Pseudomonadati 3379134 Bacteria Bacteria 168 1.6499999999999996e-41   NR HOP27743.1 2822438 g3886 i0 36.6 3.75949367088608 320 179 71.9 6 1264 356 530 842 HOP27743.1 response regulator [Candidatus Sabulitectum sp.] diamond 4752 168 1 Bacteria FCB group Pseudomonadati Candidatus Fermentibacterota       Candidatus Sabulitectum Candidatus Sabulitectum sp.
32327550 32327550 PRJNA690592_S_NODE_22039_length_637_cov_8.193262_g21062_i0 PRJNA690592 22039 637 8.193262 52.19107894 Candidatus Fermentibacterota bacterium 2044591 Bacteria Bacteria 113 1.53e-28   NR NLP06138.1 2044591 g21062 i0 63.9 3.16483516483516 83 30 39.1 0 72 320 15 97 NLP06138.1 RNA-binding protein [Candidatus Fermentibacterota bacterium] diamond 2016 113 1 Bacteria FCB group Pseudomonadati Candidatus Fermentibacterota         Candidatus Fermentibacterota bacterium
32453970 32453970 PRJNA690592_S_NODE_21679_length_642_cov_49.189807_g20703_i0 PRJNA690592 21679 642 49.189807 315.79856094 Candidatus Fermentibacterota bacterium 2044591 Bacteria Bacteria 115 1.48e-29   NR MBD3369599.1 2044591 g20703 i0 64.6 0.369158878504673 79 28 36.9 0 581 345 4 82 MBD3369599.1 RNA-binding protein [Candidatus Fermentibacterota bacterium] diamond 237 115 1 Bacteria FCB group Pseudomonadati Candidatus Fermentibacterota         Candidatus Fermentibacterota 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);;