RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630162 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
602337 602337 PRJNA630162_P_NODE_48681_length_253_cov_1.259804_g47158_i0 PRJNA630162 48681 253 1.259804 3.18730412 Chitinivibrionales bacterium 2663014 Bacteria Bacteria 147 2.23e-39   NR HEX7510617.1 2663014 g47158 i0 76.8 1.94466403162055 82 19 97.2 0 4 249 319 400 HEX7510617.1 phosphoenolpyruvate carboxykinase (GTP) [Chitinivibrionales bacterium] diamond 492 147 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia Chitinivibrionales     Chitinivibrionales bacterium
7529379 7529379 PRJNA630162_P_NODE_54726_length_238_cov_2.423280_g53203_i0 PRJNA630162 54726 238 2.42328 5.7674064 root 1 Root_unresolved Root_unresolved 139 8.21e-38   NR NLW33541.1 35828 g53203 i0 88.5 29.2310924369748 78 9 98.3 0 5 238 190 267 NLW33541.1 type I glyceraldehyde-3-phosphate dehydrogenase [Fibrobacter sp.] diamond 6957 140 0.992857142857143 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
31692495 31692495 PRJNA630162_P_NODE_107537_length_181_cov_1.545455_g106014_i0 PRJNA630162 107537 181 1.545455 2.79727355 Fibrobacteria bacterium 2725311 Bacteria Bacteria 65.1 1.89e-10   NR HLP41311.1 2725311 g106014 i0 47.5 1.95580110497238 59 31 97.8 0 179 3 140 198 HLP41311.1 patatin-like phospholipase family protein [Fibrobacteria bacterium] diamond 354 65.1 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria 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);;