RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA811725" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA811725 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
8462977 8462977 PRJNA811725_P_NODE_27187_length_296_cov_2.869955_g26941_i0 PRJNA811725 27187 296 2.869955 8.4950668 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 78.6 7.4e-15   NR MBA3314648.1 2026779 g26941 i0 79.6 0.496621621621622 49 10 49.7 0 295 149 243 291 MBA3314648.1 peptide chain release factor N(5)-glutamine methyltransferase [Planctomycetaceae bacterium] diamond 147 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
13563447 13563447 PRJNA811725_P_NODE_1291_length_1104_cov_15.499515_g1165_i0 PRJNA811725 1291 1104 15.499515 171.1146456 Pirellulaceae bacterium 2699754 Bacteria Bacteria 362 9.069999999999997e-119   NR MBC7851959.1 2699754 g1165 i0 93.4 0.983695652173913 181 12 49.2 0 1102 560 283 463 MBC7851959.1 lactate utilization protein [Pirellulaceae bacterium] diamond 1086 362 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27180441 27180441 PRJNA811725_P_NODE_1162_length_1151_cov_4.653061_g1046_i0 PRJNA811725 1162 1151 4.653061 53.55673211 Gemmataceae bacterium 2052164 Bacteria Bacteria 342 9.05e-111   NR HYV36243.1 2052164 g1046 i0 65.2 0.659426585577758 253 88 65.9 0 392 1150 1 253 HYV36243.1 efflux RND transporter permease subunit [Gemmataceae bacterium] diamond 759 342 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30212084 30212084 PRJNA811725_P_NODE_3252_length_774_cov_7.746077_g3045_i0 PRJNA811725 3252 774 7.746077 59.95463598 Gemmataceae bacterium 2052164 Bacteria Bacteria 70.5 1.07e-9   NR MFL5339594.1 2052164 g3045 i0 30.2 2.01162790697674 255 137 98.8 8 765 1 384 597 MFL5339594.1 WD40 repeat domain-containing protein [Gemmataceae bacterium] diamond 1557 70.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30402273 30402273 PRJNA811725_P_NODE_8933_length_494_cov_4.707838_g8689_i0 PRJNA811725 8933 494 4.707838 23.25671972 Gemmataceae bacterium 2052164 Bacteria Bacteria 239 5.21e-70   NR HKI33594.1 2052164 g8689 i0 75.5 1.88259109311741 155 38 94.1 0 494 30 484 638 HKI33594.1 DUF3854 domain-containing protein [Gemmataceae bacterium] diamond 930 239 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31128163 31128163 PRJNA811725_P_NODE_18755_length_350_cov_1.357401_g18509_i0 PRJNA811725 18755 350 1.357401 4.7509035 Gemmataceae bacterium 2052164 Bacteria Bacteria 123 7.73e-30   NR MFL5342006.1 2052164 g18509 i0 52.8 9.70285714285714 108 50 91.7 1 2 322 63 170 MFL5342006.1 protein kinase domain-containing protein [Gemmataceae bacterium] diamond 3396 123 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31159720 31159720 PRJNA811725_P_NODE_24295_length_310_cov_2.886076_g24049_i0 PRJNA811725 24295 310 2.886076 8.9468356 Pirellulaceae bacterium 2699754 Bacteria Bacteria 71.6 3.27e-12   NR MCC6510033.1 2699754 g24049 i0 84.2 0.367741935483871 38 6 36.8 0 161 274 261 298 MCC6510033.1 dihydrodipicolinate synthase family protein [Pirellulaceae bacterium] diamond 114 71.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;