RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1067370", 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

  • PRJNA1067370 · 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
27730956 27730956 PRJNA1067370_P_NODE_97264_length_246_cov_0.890173_g96715_i0 PRJNA1067370 97264 246 0.890173 2.18982558 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 42.7 0.0376   NR MBP5543794.1 2212473 g96715 i0 34.2 0.890243902439024 73 36 86.6 5 23 235 56 118 MBP5543794.1 hypothetical protein [Kiritimatiellia bacterium] diamond 219 42.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28520064 28520064 PRJNA1067370_P_NODE_42107_length_313_cov_1.283333_g41559_i0 PRJNA1067370 42107 313 1.283333 4.01683229 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 82.8 7.24e-16   NR HPK70123.1 2212473 g41559 i0 44.7 2.91373801916933 103 50 96.8 3 303 1 385 482 HPK70123.1 alpha-amylase family glycosyl hydrolase [Kiritimatiellia bacterium] diamond 912 82.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30193437 30193437 PRJNA1067370_P_NODE_110992_length_242_cov_0.911243_g110443_i0 PRJNA1067370 110992 242 0.911243 2.20520806 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 118 9.679999999999999e-30   NR MBQ7721948.1 2212473 g110443 i0 67.1 3.85537190082645 79 26 97.9 0 5 241 144 222 MBQ7721948.1 GTPase ObgE [Kiritimatiellia bacterium] diamond 933 118 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30943669 30943669 PRJNA1067370_P_NODE_19454_length_425_cov_1.318182_g18906_i0 PRJNA1067370 19454 425 1.318182 5.6022735 Pseudomonadati 3379134 Bacteria Bacteria 147 6.21e-39   NR MFT5499795.1 2212473 g18906 i0 55.3 5.67529411764706 141 60 99.5 1 424 2 341 478 MFT5499795.1 dihydrolipoamide dehydrogenase [Kiritimatiellia bacterium] diamond 2412 148 0.993243243243243 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);;