RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA743294", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 7 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 7 ✖

bioproject 1

  • PRJNA743294 · 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
27084307 27084307 PRJNA743294_P_NODE_46642_length_253_cov_0.866667_g46186_i0 PRJNA743294 46642 253 0.866667 2.19266751 Salinibacter altiplanensis 1803181 Bacteria Bacteria 54.3 3.46e-6   NR WP_103027688.1 1803181 g46186 i0 48.2 0.66403162055336 56 27 66.4 1 18 185 123 176 WP_103027688.1 alkaline phosphatase D family protein [Salinibacter altiplanensis] diamond 168 54.3 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter altiplanensis
27369040 27369040 PRJNA743294_P_NODE_48243_length_251_cov_0.876404_g47787_i0 PRJNA743294 48243 251 0.876404 2.19977404 Rhodothermaceae bacterium 2026787 Bacteria Bacteria 42.7 0.041   NR MBX2822645.1 2026787 g47787 i0 35.5 0.908366533864542 76 38 90.8 2 23 250 481 545 MBX2822645.1 trypsin-like peptidase domain-containing protein [Rhodothermaceae bacterium] diamond 228 42.7 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae   Rhodothermaceae bacterium
28063229 28063229 PRJNA743294_P_NODE_19405_length_368_cov_1.586441_g18949_i0 PRJNA743294 19405 368 1.586441 5.83810288 Longibacter salinarum 1850348 Bacteria Bacteria 149 3.35e-41   NR WP_098075214.1 1850348 g18949 i0 56.6 2.02989130434783 122 52 99.5 1 1 366 208 328 WP_098075214.1 uroporphyrinogen decarboxylase [Longibacter salinarum] diamond 747 149 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salisaetaceae Longibacter Longibacter salinarum
31253268 31253268 PRJNA743294_P_NODE_19815_length_365_cov_0.873288_g19359_i0 PRJNA743294 19815 365 0.873288 3.1875012 Rhodothermaceae bacterium 2026787 Bacteria Bacteria 50.4 1.97e-4   NR MXY08224.1 2026787 g19359 i0 46.7 0.36986301369863 45 24 37 0 364 230 192 236 MXY08224.1 hypothetical protein [Rhodothermaceae bacterium] diamond 135 50.4 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae   Rhodothermaceae bacterium
31484977 31484977 PRJNA743294_P_NODE_41696_length_264_cov_1.628272_g41240_i0 PRJNA743294 41696 264 1.628272 4.29863808 Pseudomonadati 3379134 Bacteria Bacteria 123 1.83e-30   NR MEF8939505.1 1885341 g41240 i0 70.7 23.7840909090909 82 23 93.2 1 11 256 741 821 MEF8939505.1 bifunctional aspartate kinase/diaminopimelate decarboxylase [Salinivenus sp.] diamond 6279 124 0.991935483870968 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinivenus Salinivenus sp.
32370769 32370769 PRJNA743294_P_NODE_33619_length_289_cov_2.152778_g33163_i0 PRJNA743294 33619 289 2.152778 6.22152842 FCB group 1783270 Bacteria Bacteria 44.7 0.0136   NR MDX1546831.1 2306054 g33163 i0 32.5 2.56401384083045 83 50 84.1 2 37 279 557 635 MDX1546831.1 amino acid permease [Rhodothermales bacterium] diamond 741 44.7 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales bacterium
32518991 32518991 PRJNA743294_P_NODE_32219_length_294_cov_2.380090_g31763_i0 PRJNA743294 32219 294 2.38009 6.9974646 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 128 5.87e-32   NR MFN3596036.1 2838334 g31763 i0 58.8 3.95918367346939 97 40 99 0 292 2 314 410 MFN3596036.1 glucosamine-6-phosphate deaminase [Rubricoccaceae bacterium] diamond 1164 128 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae 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);;