RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA867519" and tax_phylum = "Candidatus Omnitrophota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Omnitrophota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA867519 · 4 ✖

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
23800326 23800326 PRJNA867519_P_NODE_25319_length_251_cov_1.297753_g25165_i0 PRJNA867519 25319 251 1.297753 3.25736003 Bacteria 2 Bacteria Bacteria 128 1.6e-33   NR OGX28778.1 1801852 g25165 i0 72.3 70.8645418326693 83 23 99.2 0 250 2 132 214 OGX28778.1 MAG: 6-phosphofructokinase [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_01_FULL_49_10] diamond 17787 129 0.992248062015504 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_01_FULL_49_10
28547819 28547819 PRJNA867519_P_NODE_17007_length_289_cov_1.273148_g16853_i0 PRJNA867519 17007 289 1.273148 3.67939772 Bacteria 2 Bacteria Bacteria 58.2 4.93e-8   NR OGX28406.1 1801860 g16853 i0 60 6.07266435986159 50 20 51.9 0 2 151 106 155 OGX28406.1 MAG: 30S ribosomal protein S7 [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20] diamond 1755 58.5 0.994871794871795 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20
29928974 29928974 PRJNA867519_P_NODE_31991_length_243_cov_0.905882_g31837_i0 PRJNA867519 31991 243 0.905882 2.20129326 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 48.9 2.48e-4   NR MFA5039933.1 2035772 g31837 i0 37.7 0.851851851851852 69 40 81.5 2 239 42 680 748 MFA5039933.1 hypothetical protein [Candidatus Omnitrophota bacterium] diamond 207 48.9 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
30023745 30023745 PRJNA867519_P_NODE_33851_length_241_cov_0.916667_g33697_i0 PRJNA867519 33851 241 0.916667 2.20916747 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 45.1 0.00525   NR MBU4377171.1 2035772 g33697 i0 43.1 1.2448132780083 51 24 61 2 239 93 357 404 MBU4377171.1 lysophospholipase [Candidatus Omnitrophota bacterium] diamond 300 45.1 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota 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);;