RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA797475" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA797475 · 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
26895912 26895912 PRJNA797475_P_NODE_14301_length_287_cov_1.607477_g14202_i0 PRJNA797475 14301 287 1.607477 4.61345899 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 189 4.3e-58   NR MBK8224185.1 2711154 g14202 i0 98.9 0.993031358885017 95 1 99.3 0 286 2 60 154 MBK8224185.1 hypothetical protein [Candidatus Obscuribacter sp.] diamond 285 189 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
26990361 26990361 PRJNA797475_P_NODE_2242_length_650_cov_1.906412_g2145_i0 PRJNA797475 2242 650 1.906412 12.391678 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 49.7 0.00288   NR MBI3591571.1 2052166 g2145 i0 43.9 0.304615384615385 66 26 27.7 3 410 231 195 255 MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 198 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
27085580 27085580 PRJNA797475_P_NODE_5262_length_438_cov_1.265753_g5164_i0 PRJNA797475 5262 438 1.265753 5.54399814 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 170 2.49e-49   NR MBX9722485.1 2364082 g5164 i0 55.5 1 146 64 99.3 1 436 2 81 226 MBX9722485.1 pirin family protein [Candidatus Obscuribacterales bacterium] diamond 438 170 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27116895 27116895 PRJNA797475_P_NODE_26542_length_245_cov_0.895349_g26443_i0 PRJNA797475 26542 245 0.895349 2.19360505 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 155 4.64e-45   NR HIN65143.1 2364082 g26443 i0 98.8 0.991836734693878 81 1 99.2 0 2 244 129 209 HIN65143.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 243 155 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31476121 31476121 PRJNA797475_P_NODE_21596_length_251_cov_0.865169_g21497_i0 PRJNA797475 21596 251 0.865169 2.17157419 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 58.2 9.17e-8   NR MBX9950823.1 2364082 g21497 i0 87.5 0.764940239043825 32 4 38.2 0 9 104 212 243 MBX9950823.1 HAD family phosphatase [Candidatus Obscuribacterales bacterium] diamond 192 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31887132 31887132 PRJNA797475_P_NODE_29377_length_242_cov_0.911243_g29278_i0 PRJNA797475 29377 242 0.911243 2.20520806 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 92.8 8.76e-20   NR MBX9685384.1 2364082 g29278 i0 62 0.979338842975207 79 30 97.9 0 1 237 397 475 MBX9685384.1 AAA family ATPase [Candidatus Obscuribacterales bacterium] diamond 237 92.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales 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);;