RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1186363", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 5 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 5 ✖

bioproject 1

  • PRJNA1186363 · 5 ✖

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
2870529 2870529 PRJNA1186363_P_NODE_26423_length_349_cov_1.268116_g25535_i0 PRJNA1186363 26423 349 1.268116 4.42572484 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 59.3 2.15e-9   NR MBL8086392.1 2711154 g25535 i0 90 0.257879656160458 30 3 25.8 0 201 112 1 30 MBL8086392.1 hypothetical protein [Candidatus Obscuribacter sp.] diamond 90 59.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
14348724 14348724 PRJNA1186363_P_NODE_20332_length_419_cov_1.864162_g19444_i0 PRJNA1186363 20332 419 1.864162 7.81083878 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 58.2 1.18e-8   NR MBL8086392.1 2711154 g19444 i0 90 0.214797136038186 30 3 21.5 0 214 125 1 30 MBL8086392.1 hypothetical protein [Candidatus Obscuribacter sp.] diamond 90 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
29125260 29125260 PRJNA1186363_P_NODE_34089_length_284_cov_0.848341_g33201_i0 PRJNA1186363 34089 284 0.848341 2.40928844 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 124 1.94e-33   NR MBL8086323.1 2711154 g33201 i0 76.3 1.02464788732394 97 20 99.3 1 283 2 71 167 MBL8086323.1 hypothetical protein [Candidatus Obscuribacter sp.] diamond 291 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
31463003 31463003 PRJNA1186363_P_NODE_37256_length_260_cov_1.251337_g36368_i0 PRJNA1186363 37256 260 1.251337 3.2534762 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 42.7 0.0356   NR MCD7740524.1 2137880 g36368 i0 34.9 0.726923076923077 63 39 70.4 1 39 221 39 101 MCD7740524.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] diamond 189 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
32380381 32380381 PRJNA1186363_P_NODE_9139_length_692_cov_0.956381_g8282_i0 PRJNA1186363 9139 692 0.956381 6.61815652 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 47 0.0375   NR RAI12352.1 2052166 g8282 i0 33.3 0.63728323699422 147 84 58.1 6 442 41 9 154 RAI12352.1 MAG: hypothetical protein DKM24_03210 [Candidatus Melainabacteria bacterium] diamond 441 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria 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);;