RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA939415", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA939415 · 6 ✖

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
26715094 26715094 PRJNA939415_P_NODE_98081_length_237_cov_4.518293_g97659_i0 PRJNA939415 98081 237 4.518293 10.70835441 PVC group 1783257 Bacteria Bacteria 122 1.89e-31   NR MFA7158456.1 2212473 g97659 i0 75.3 9.83544303797468 77 19 97.5 0 233 3 154 230 MFA7158456.1 substrate-binding domain-containing protein [Kiritimatiellia bacterium] diamond 2331 122 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
26867048 26867048 PRJNA939415_P_NODE_16641_length_381_cov_3.448052_g16221_i0 PRJNA939415 16641 381 3.448052 13.13707812 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.1 0.0238   NR MDX9867848.1 2212473 g16221 i0 43.4 0.716535433070866 53 30 41.7 0 10 168 218 270 MDX9867848.1 protein phosphatase 2C domain-containing protein [Kiritimatiellia bacterium] diamond 273 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27783386 27783386 PRJNA939415_P_NODE_25104_length_310_cov_6.548523_g24682_i0 PRJNA939415 25104 310 6.548523 20.3004213 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 49.7 3.09e-4   NR MBQ8125756.1 2212473 g24682 i0 65.1 0.416129032258065 43 15 41.6 0 307 179 891 933 MBQ8125756.1 transporter substrate-binding domain-containing protein [Kiritimatiellia bacterium] diamond 129 49.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28414841 28414841 PRJNA939415_P_NODE_30006_length_310_cov_3.210970_g29584_i0 PRJNA939415 30006 310 3.21097 9.954007 Pontiella desulfatans 2750659 Bacteria Bacteria 73.2 1.6e-12   NR WP_168442171.1 2750659 g29584 i0 74 0.483870967741935 50 13 48.4 0 2 151 205 254 WP_168442171.1 ThiF family adenylyltransferase [Pontiella desulfatans] diamond 150 73.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae Pontiella Pontiella desulfatans
30189940 30189940 PRJNA939415_P_NODE_9952_length_499_cov_3.286385_g9534_i0 PRJNA939415 9952 499 3.286385 16.39906115 PVC group 1783257 Bacteria Bacteria 65.9 4.88e-9   NR MCF7816486.1 2202731 g9534 i0 57.6 1.2685370741483 59 20 32.5 1 323 484 27 85 MCF7816486.1 DUF5110 domain-containing protein [Kiritimatiellales bacterium] diamond 633 65.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales     Kiritimatiellales bacterium
31921668 31921668 PRJNA939415_P_NODE_92297_length_243_cov_5.658824_g91875_i0 PRJNA939415 92297 243 5.658824 13.75094232 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 73.9 9.64e-15   NR NKB25360.1 2212473 g91875 i0 62 0.617283950617284 50 19 61.7 0 152 3 1 50 NKB25360.1 hypothetical protein [Kiritimatiellia bacterium] diamond 150 73.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia 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);;