RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA1095825 · 4 ✖

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
15047277 15047277 PRJNA1095825_P_NODE_279232_length_244_cov_0.900585_g276169_i0 PRJNA1095825 279232 244 0.900585 2.1974274 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 81.6 7.43e-16   NR HMP75038.1 2212473 g276169 i0 72 0.614754098360656 50 14 61.5 0 242 93 660 709 HMP75038.1 hypothetical protein [Kiritimatiellia bacterium] diamond 150 81.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
26900902 26900902 PRJNA1095825_P_NODE_243021_length_250_cov_0.870056_g239958_i0 PRJNA1095825 243021 250 0.870056 2.17514 Pseudomonadati 3379134 Bacteria Bacteria 55.5 1.32e-6   NR MEE9369272.1 2837462 g239958 i0 85.7 2.34 28 4 33.6 0 85 2 98 125 MEE9369272.1 NAD(P)/FAD-dependent oxidoreductase [Pontiella sp.] diamond 585 55.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae Pontiella Pontiella sp.
28235932 28235932 PRJNA1095825_P_NODE_282526_length_243_cov_0.905882_g279463_i0 PRJNA1095825 282526 243 0.905882 2.20129326 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 89.7 6.72e-19   NR HEY8240355.1 2212473 g279463 i0 56.8 1 81 34 98.8 1 241 2 197 277 HEY8240355.1 amino acid permease [Kiritimatiellia bacterium] diamond 243 89.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28235933 28235933 PRJNA1095825_P_NODE_282826_length_243_cov_0.905882_g279763_i0 PRJNA1095825 282826 243 0.905882 2.20129326 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 161 8.51e-46   NR HMP76571.1 2212473 g279763 i0 86.4 1 81 11 100 0 243 1 235 315 HMP76571.1 terminase family protein [Kiritimatiellia bacterium] diamond 243 161 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);;