RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA879067", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 3 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA879067 · 3 ✖

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
855557 855557 PRJNA879067_P_NODE_57301_length_468_cov_4.268354_g53816_i0 PRJNA879067 57301 468 4.268354 19.97589672 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 636 9.87e-178   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g53816 i0 92.727 162.108974358974 440 32 94 0 1 440 4042301 4041862 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 75867 636 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
4684989 4684989 PRJNA879067_P_NODE_99424_length_264_cov_3.020942_g95938_i0 PRJNA879067 99424 264 3.020942 7.97528688 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 333 7.689999999999999e-87   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g95938 i0 91.736 220.621212121212 242 16 91 4 3 242 2341653 2341892 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 58244 333 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
5958593 5958593 PRJNA879067_P_NODE_51625_length_511_cov_6.374429_g48141_i0 PRJNA879067 51625 511 6.374429 32.57333219 Lentisphaeria bacterium 2053569 Bacteria Bacteria 442 2.539999999999999e-119   NTclustered gi|2189495548|gb|CP091727.1| 2053569 g48141 i0 83.573 234.553816046967 487 64 94 14 3 480 950432 950911 MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome blastn 119857 442 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria 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);;