RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1002570" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1002570 · 6 ✖

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
27128761 27128761 PRJNA1002570_P_NODE_10822_length_358_cov_1.080702_g10627_i0 PRJNA1002570 10822 358 1.080702 3.86891316 Pontiellaceae bacterium 2813032 Bacteria Bacteria 179 1.49e-51   NR HPR83171.1 2813032 g10627 i0 70.6 0.99720670391061506 119 35 99.7 0 357 1 159 277 HPR83171.1 metallophosphoesterase [Pontiellaceae bacterium] diamond 357 179 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae   Pontiellaceae bacterium
27128805 27128805 PRJNA1002570_P_NODE_38922_length_247_cov_2.000000_g38727_i0 PRJNA1002570 38922 247 2 4.94 Pontiellaceae bacterium 2813032 Bacteria Bacteria 87 5.81e-18   NR MCU0858711.1 2813032 g38727 i0 53.7 1.9919028340081 82 38 99.6 0 2 247 267 348 MCU0858711.1 glycosyltransferase family 4 protein [Pontiellaceae bacterium] diamond 492 87 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae   Pontiellaceae bacterium
28550554 28550554 PRJNA1002570_P_NODE_44187_length_241_cov_0.916667_g43992_i0 PRJNA1002570 44187 241 0.916667 2.20916747 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 106 9.13e-25   NR MDP6525451.1 2212473 g43992 i0 59.5 2.05394190871369 84 29 98.3 1 240 4 334 417 MDP6525451.1 FAD-dependent thymidylate synthase [Kiritimatiellia bacterium] diamond 495 106 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29465569 29465569 PRJNA1002570_P_NODE_11510_length_349_cov_1.597826_g11315_i0 PRJNA1002570 11510 349 1.597826 5.57641274 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 142 1.73e-37   NR MDE0838229.1 2212473 g11315 i0 60.2 2.93123209169054 113 44 96.3 1 338 3 296 408 MDE0838229.1 FGGY family carbohydrate kinase [Kiritimatiellia bacterium] diamond 1023 142 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30792625 30792625 PRJNA1002570_P_NODE_10594_length_360_cov_2.679443_g10399_i0 PRJNA1002570 10594 360 2.679443 9.6459948 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 68.6 1.27e-10   NR MCO5068926.1 2212473 g10399 i0 49.3 1.15 69 35 57.5 0 3 209 706 774 MCO5068926.1 hypothetical protein [Kiritimatiellia bacterium] diamond 414 68.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31709546 31709546 PRJNA1002570_P_NODE_44677_length_238_cov_2.357576_g44482_i0 PRJNA1002570 44677 238 2.357576 5.61103088 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 104 5.26e-24   NR MDA3924539.1 2212473 g44482 i0 62.3 0.970588235294118 77 29 97.1 0 235 5 252 328 MDA3924539.1 hypothetical protein [Kiritimatiellia bacterium] diamond 231 104 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);;