RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA631119", tax_kingdom = "Bacillati" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 7 ✖

tax_kingdom 1

  • Bacillati · 7 ✖

bioproject 1

  • PRJNA631119 · 7 ✖

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
6981760 6981760 PRJNA631119_P_NODE_40266_length_233_cov_2.250000_g40148_i0 PRJNA631119 40266 233 2.25 5.2425 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 79.7 1.01e-16   NR HEY9815642.1 2364082 g40148 i0 56 1.08154506437768 84 29 99.1 3 1 231 37 119 HEY9815642.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 252 79.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28312721 28312721 PRJNA631119_P_NODE_36446_length_244_cov_0.900585_g36328_i0 PRJNA631119 36446 244 0.900585 2.1974274 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 59.3 3.79e-8   NR HEY9817614.1 2364082 g36328 i0 50 0.663934426229508 54 27 66.4 0 244 83 202 255 HEY9817614.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 162 59.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29272156 29272156 PRJNA631119_P_NODE_20589_length_294_cov_1.140271_g20471_i0 PRJNA631119 20589 294 1.140271 3.35239674 Bacillati 1783272 Bacteria Bacteria 151 1.6099999999999996e-41   NR MBX9666364.1 2364082 g20471 i0 68.8 4.88775510204082 96 30 98 0 2 289 235 330 MBX9666364.1 putrescine aminotransferase [Candidatus Obscuribacterales bacterium] diamond 1437 151 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29291384 29291384 PRJNA631119_P_NODE_9329_length_393_cov_3.009375_g9211_i0 PRJNA631119 9329 393 3.009375 11.82684375 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 192 2.38e-60   NR MBX9722668.1 2364082 g9211 i0 76.5 0.908396946564885 119 28 90.8 0 393 37 19 137 MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 357 192 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30902421 30902421 PRJNA631119_P_NODE_3454_length_592_cov_2.666667_g3342_i0 PRJNA631119 3454 592 2.666667 15.78666864 Vampirovibrionales bacterium 2692181 Bacteria Bacteria 58.9 2.31e-6   NR MEB3246050.1 2692181 g3342 i0 27.7 1.02364864864865 202 123 97.8 7 585 7 15 202 MEB3246050.1 signal recognition particle receptor subunit alpha [Vampirovibrionales bacterium] diamond 606 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria Vampirovibriophyceae Vampirovibrionales     Vampirovibrionales bacterium
30934056 30934056 PRJNA631119_P_NODE_37574_length_243_cov_0.905882_g37456_i0 PRJNA631119 37574 243 0.905882 2.20129326 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 44.7 0.00777   NR MBX9568713.1 2364082 g37456 i0 35.8 0.827160493827161 67 40 82.7 1 35 235 764 827 MBX9568713.1 cation:proton antiporter [Candidatus Obscuribacterales bacterium] diamond 201 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32610107 32610107 PRJNA631119_P_NODE_29400_length_256_cov_1.366120_g29282_i0 PRJNA631119 29400 256 1.36612 3.4972672 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 112 6.45e-29   NR MBX9771135.1 2364082 g29282 i0 73.7 0.890625 76 20 89.1 0 255 28 117 192 MBX9771135.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 228 112 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);;