RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1005695 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_clade 0

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
28992749 28992749 PRJNA1005695_P_NODE_1268_length_1406_cov_2.809452_g904_i0 PRJNA1005695 1268 1406 2.809452 39.50089512 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 100 2.36e-18   NR HEX5069531.1 2910147 g904 i0 28.6 3.80440967283073 262 152 52.3 7 1386 652 369 612 HEX5069531.1 long-chain fatty acid--CoA ligase [Vicinamibacterales bacterium] diamond 5349 100 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
30350963 30350963 PRJNA1005695_P_NODE_37432_length_247_cov_1.344828_g36580_i0 PRJNA1005695 37432 247 1.344828 3.32172516 Blastocatellia bacterium 2052146 Bacteria Bacteria 45.4 0.00375   NR MBK6313972.1 2052146 g36580 i0 34.1 1.88259109311741 85 51 97.2 2 242 3 59 143 MBK6313972.1 ABC transporter ATP-binding protein [Blastocatellia bacterium] diamond 465 45.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
31638742 31638742 PRJNA1005695_P_NODE_35516_length_251_cov_0.876404_g34664_i0 PRJNA1005695 35516 251 0.876404 2.19977404 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.04e-4   NR WP_164981626.1 1560006 g34664 i0 35 6.47808764940239 80 52 95.6 0 12 251 290 369 WP_164981626.1 tetratricopeptide repeat protein [Silvibacterium dinghuense] diamond 1626 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Silvibacterium Silvibacterium dinghuense
31867615 31867615 PRJNA1005695_P_NODE_38977_length_244_cov_0.912281_g38125_i0 PRJNA1005695 38977 244 0.912281 2.22596564 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 42.7 0.0347   NR HEY8549577.1 2910147 g38125 i0 39 0.725409836065574 59 31 66.4 1 59 220 137 195 HEY8549577.1 hypothetical protein [Vicinamibacterales bacterium] diamond 177 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31962630 31962630 PRJNA1005695_P_NODE_31178_length_267_cov_2.097938_g30326_i0 PRJNA1005695 31178 267 2.097938 5.60149446 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.1 0.0383   NR MDH3522665.1 1978231 g30326 i0 41.3 0.842696629213483 75 38 82 3 37 255 285 355 MDH3522665.1 hypothetical protein [Acidobacteriota bacterium] diamond 225 43.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32776699 32776699 PRJNA1005695_P_NODE_10180_length_487_cov_1.845411_g9328_i0 PRJNA1005695 10180 487 1.845411 8.98715157 root 1 Root_unresolved Root_unresolved 74.3 2.41e-12   NR MCW5950305.1 2283092 g9328 i0 43 2.49486652977413 107 40 53 2 155 412 36 142 MCW5950305.1 cytochrome c oxidase subunit 3 [Pyrinomonadaceae bacterium] diamond 1215 74.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;