RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA789095", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJNA789095 · 5 ✖

analysis 1

tax_clade 0

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
16073559 16073559 PRJNA789095_P_NODE_54393_length_276_cov_0.990148_g53059_i0 PRJNA789095 54393 276 0.990148 2.73280848 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 158 1.94e-45   NR MCB0369725.1 2053517 g53059 i0 88.6 1.94565217391304 88 10 95.7 0 12 275 9 96 MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium] diamond 537 158 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
17348474 17348474 PRJNA789095_P_NODE_27234_length_419_cov_1.742775_g25902_i0 PRJNA789095 27234 419 1.742775 7.30222725 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 236 1.5700000000000003e-73   NR MCB0368368.1 2053517 g25902 i0 83.3 0.988066825775656 138 23 98.8 0 416 3 160 297 MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] diamond 414 236 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
19897088 19897088 PRJNA789095_P_NODE_28576_length_404_cov_0.924471_g27244_i0 PRJNA789095 28576 404 0.924471 3.73486284 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 192 3.8300000000000003e-59   NR MCB0369461.1 2053517 g27244 i0 73 0.905940594059406 122 33 90.6 0 370 5 43 164 MCB0369461.1 hypothetical protein [Bdellovibrionales bacterium] diamond 366 192 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
26832261 26832261 PRJNA789095_P_NODE_57561_length_269_cov_1.295918_g56227_i0 PRJNA789095 57561 269 1.295918 3.48601942 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 124 4.99e-34   NR MCB0370127.1 2053517 g56227 i0 78.6 0.936802973977695 84 17 92.6 1 251 3 7 90 MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] diamond 252 124 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
28001488 28001488 PRJNA789095_P_NODE_71965_length_245_cov_0.895349_g70631_i0 PRJNA789095 71965 245 0.895349 2.19360505 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 104 5.94e-26   NR MBX9767865.1 2053517 g70631 i0 59.5 0.906122448979592 74 30 90.6 0 245 24 128 201 MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] diamond 222 104 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales 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);;