RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA437204 · 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
2364691 2364691 PRJNA437204_P_NODE_101182_length_247_cov_0.885057_g100883_i0 PRJNA437204 101182 247 0.885057 2.18609079 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 163 1.06e-46   NR MBQ6104066.1 2212473 g100883 i0 98.8 0.983805668016194 81 1 98.4 0 245 3 137 217 MBQ6104066.1 aspartate aminotransferase family protein [Kiritimatiellia bacterium] diamond 243 163 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27233940 27233940 PRJNA437204_P_NODE_37723_length_331_cov_0.895349_g37424_i0 PRJNA437204 37723 331 0.895349 2.96360519 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 86.7 2.1e-17   NR MFT7520536.1 2212473 g37424 i0 47.1 0.924471299093656 102 40 92.4 3 321 16 37 124 MFT7520536.1 putative deacylase [Kiritimatiellia bacterium] diamond 306 86.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27897024 27897024 PRJNA437204_P_NODE_68345_length_267_cov_1.695876_g68046_i0 PRJNA437204 68345 267 1.695876 4.52798892 Kiritimatiellales bacterium 2202731 Bacteria Bacteria 79 9.2e-15   NR MCF7864708.1 2202731 g68046 i0 48.9 1.01123595505618 90 43 98.9 3 264 1 312 400 MCF7864708.1 hypothetical protein [Kiritimatiellales bacterium] diamond 270 79 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales     Kiritimatiellales bacterium
28623485 28623485 PRJNA437204_P_NODE_103947_length_246_cov_0.890173_g103648_i0 PRJNA437204 103947 246 0.890173 2.18982558 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 167 3.89e-46   NR MBO6120840.1 2212473 g103648 i0 98.8 1.96341463414634 81 1 98.8 0 2 244 461 541 MBO6120840.1 hypothetical protein [Kiritimatiellia bacterium] diamond 483 167 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);;