RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJNA529241 · 7 ✖

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
26760856 26760856 PRJNA529241_P_NODE_356061_length_173_cov_2.808824_g353739_i0 PRJNA529241 356061 173 2.808824 4.85926552 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 47.4 3.11e-4   NR MFA7174832.1 2212473 g353739 i0 84 0.867052023121387 25 4 43.4 0 76 2 107 131 MFA7174832.1 class I SAM-dependent methyltransferase [Kiritimatiellia bacterium] diamond 150 47.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27235551 27235551 PRJNA529241_P_NODE_465523_length_152_cov_4.930435_g463201_i0 PRJNA529241 465523 152 4.930435 7.4942612 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 41.2 0.0381   NR MFA7334932.1 2212473 g463201 i0 78.3 0.453947368421053 23 5 45.4 0 80 148 169 191 MFA7334932.1 hypothetical protein [Kiritimatiellia bacterium] diamond 69 41.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29161842 29161842 PRJNA529241_P_NODE_101709_length_216_cov_5.044693_g99387_i0 PRJNA529241 101709 216 5.044693 10.89653688 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 65.5 2.2e-10   NR MFA7174831.1 2212473 g99387 i0 82.4 0.472222222222222 34 6 47.2 0 206 105 290 323 MFA7174831.1 hypothetical protein [Kiritimatiellia bacterium] diamond 102 65.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29382752 29382752 PRJNA529241_P_NODE_23509_length_438_cov_6.209476_g21233_i0 PRJNA529241 23509 438 6.209476 27.19750488 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 107 9.52e-25   NR MFA7174829.1 2212473 g21233 i0 69.7 0.89041095890411 66 20 45.2 0 109 306 44 109 MFA7174829.1 lysylphosphatidylglycerol synthase domain-containing protein [Kiritimatiellia bacterium] diamond 390 107 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29729860 29729860 PRJNA529241_P_NODE_82970_length_235_cov_6.212121_g80648_i0 PRJNA529241 82970 235 6.212121 14.59848435 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 54.7 1.97e-6   NR MFA7174831.1 2212473 g80648 i0 89.3 0.714893617021277 28 3 35.7 0 85 2 1 28 MFA7174831.1 hypothetical protein [Kiritimatiellia bacterium] diamond 168 54.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30235342 30235342 PRJNA529241_P_NODE_121312_length_201_cov_7.170732_g118990_i0 PRJNA529241 121312 201 7.170732 14.41317132 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 68.2 1.1e-11   NR MFA7174832.1 2212473 g118990 i0 77.8 0.537313432835821 36 8 53.7 0 2 109 210 245 MFA7174832.1 class I SAM-dependent methyltransferase [Kiritimatiellia bacterium] diamond 108 68.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31752549 31752549 PRJNA529241_P_NODE_506677_length_151_cov_4.587719_g504355_i0 PRJNA529241 506677 151 4.587719 6.92745569 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 43.9 0.00403   NR MBR3957082.1 2212473 g504355 i0 65.7 0.695364238410596 35 11 69.5 1 107 3 184 217 MBR3957082.1 DUF1080 domain-containing protein [Kiritimatiellia bacterium] diamond 105 43.9 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);;