RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA473799", 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 · 5 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA473799 · 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
1720558 1720558 PRJNA473799_P_NODE_36982_length_250_cov_0.870056_g36708_i0 PRJNA473799 36982 250 0.870056 2.17514 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 157 5.21e-46   NR HMO49970.1 2212473 g36708 i0 95.2 0.996 83 4 99.6 0 250 2 44 126 HMO49970.1 nucleoside phosphorylase [Kiritimatiellia bacterium] diamond 249 157 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
20847025 20847025 PRJNA473799_P_NODE_15117_length_289_cov_1.347222_g14843_i0 PRJNA473799 15117 289 1.347222 3.89347158 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 191 1.49e-56   NR MBO7309280.1 2212473 g14843 i0 98.9 0.944636678200692 91 1 94.5 0 1 273 260 350 MBO7309280.1 MFS transporter [Kiritimatiellia bacterium] diamond 273 191 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28181374 28181374 PRJNA473799_P_NODE_29686_length_259_cov_1.973118_g29412_i0 PRJNA473799 29686 259 1.973118 5.11037562 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 151 4.97e-44   NR MBR2919733.1 2212473 g29412 i0 98.8 0.996138996138996 86 1 99.6 0 1 258 74 159 MBR2919733.1 MotA/TolQ/ExbB proton channel family protein [Kiritimatiellia bacterium] diamond 258 151 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29223744 29223744 PRJNA473799_P_NODE_22849_length_272_cov_2.361809_g22575_i0 PRJNA473799 22849 272 2.361809 6.42412048 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 79 8.56e-15   NR HMP89311.1 2212473 g22575 i0 40.9 0.970588235294118 88 52 97.1 0 3 266 224 311 HMP89311.1 hypothetical protein [Kiritimatiellia bacterium] diamond 264 79 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32447642 32447642 PRJNA473799_P_NODE_38939_length_249_cov_0.875000_g38665_i0 PRJNA473799 38939 249 0.875 2.17875 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 104 6.04e-26   NR MBP7638381.1 2212473 g38665 i0 82.5 1.37349397590361 57 10 68.7 0 77 247 2 58 MBP7638381.1 hypothetical protein [Kiritimatiellia bacterium] diamond 342 104 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);;