RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA562549", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 5 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA562549 · 5 ✖

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
9474351 9474351 PRJNA562549_P_NODE_29988_length_215_cov_3.928571_g29755_i0 PRJNA562549 29988 215 3.928571 8.44642765 Chlamydiales bacterium 2047757 Bacteria Bacteria 136 3.28e-39   NR MCP5470421.1 2047757 g29755 i0 90.1 0.990697674418605 71 7 99.1 0 3 215 7 77 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 213 136 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
27679680 27679680 PRJNA562549_P_NODE_10524_length_354_cov_1.720137_g10291_i0 PRJNA562549 10524 354 1.720137 6.08928498 Simkania sp. 34094 Bacteria Bacteria 85.9 1.2e-17   NR MCB1084310.1 34094 g10291 i0 89.6 0.406779661016949 48 5 40.7 0 235 92 81 128 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 144 85.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
27774317 27774317 PRJNA562549_P_NODE_9784_length_368_cov_2.045603_g9551_i0 PRJNA562549 9784 368 2.045603 7.52781904 Simkania sp. 34094 Bacteria Bacteria 88.2 2.93e-19   NR MCB1084323.1 34094 g9551 i0 62.1 0.53804347826087 66 25 53.8 0 203 6 30 95 MCB1084323.1 AMP-binding protein [Simkania sp.] diamond 198 88.2 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
27868701 27868701 PRJNA562549_P_NODE_36045_length_203_cov_0.915493_g35812_i0 PRJNA562549 36045 203 0.915493 1.85845079 Simkania sp. 34094 Bacteria Bacteria 84 9.69e-18   NR MCB1084310.1 34094 g35812 i0 76.5 0.753694581280788 51 12 75.4 0 46 198 1 51 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 153 84 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
28595177 28595177 PRJNA562549_P_NODE_19307_length_264_cov_2.192118_g19074_i0 PRJNA562549 19307 264 2.192118 5.78719152 Simkania sp. 34094 Bacteria Bacteria 178 2.2099999999999995e-55   NR MCB1084326.1 34094 g19074 i0 93.1 0.988636363636364 87 6 98.9 0 263 3 41 127 MCB1084326.1 serine/threonine-protein kinase [Simkania sp.] diamond 261 178 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.

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);;