RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA613025 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
6970073 6970073 PRJNA613025_S_NODE_19086_length_228_cov_1.642458_g18932_i0 PRJNA613025 19086 228 1.642458 3.74480424 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 136 2.42e-37   NR MCB0369725.1 2053517 g18932 i0 89.3 1.97368421052632 75 8 98.7 0 3 227 22 96 MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium] diamond 450 136 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
17169349 17169349 PRJNA613025_S_NODE_11354_length_354_cov_2.954098_g11200_i0 PRJNA613025 11354 354 2.954098 10.45750692 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 195 3.58e-58   NR MCB0368368.1 2053517 g11200 i0 81.9 0.983050847457627 116 21 98.3 0 354 7 117 232 MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] diamond 348 195 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
19718279 19718279 PRJNA613025_S_NODE_21216_length_211_cov_0.938272_g21062_i0 PRJNA613025 21216 211 0.938272 1.97975392 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 107 2.06e-25   NR MCB0370360.1 2053517 g21062 i0 78.6 0.995260663507109 70 15 99.5 0 210 1 424 493 MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] diamond 210 107 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
28388097 28388097 PRJNA613025_S_NODE_18026_length_238_cov_4.037037_g17872_i0 PRJNA613025 18026 238 4.037037 9.60814806 Bacteria 2 Bacteria Bacteria 108 2.95e-29   NR MCB0370183.1 2053517 g17872 i0 89.1 2.36974789915966 55 6 69.3 0 54 218 1 55 MCB0370183.1 hypothetical protein [Bdellovibrionales bacterium] diamond 564 108 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
30238253 30238253 PRJNA613025_S_NODE_15872_length_266_cov_0.935484_g15718_i0 PRJNA613025 15872 266 0.935484 2.48838744 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 163 3.19e-49   NR MCB0369646.1 2053517 g15718 i0 90.9 0.992481203007519 88 8 99.2 0 1 264 47 134 MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] diamond 264 163 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
32861353 32861353 PRJNA613025_S_NODE_15400_length_273_cov_1.089286_g15246_i0 PRJNA613025 15400 273 1.089286 2.97375078 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 88.6 6.69e-20   NR MCB0371231.1 2053517 g15246 i0 67.3 0.604395604395604 55 18 60.4 0 108 272 1 55 MCB0371231.1 hypothetical protein [Bdellovibrionales bacterium] diamond 165 88.6 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);;