RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA883229" and tax_clade = "ac1 cluster"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • ac1 cluster · 5 ✖

bioproject 1

  • PRJNA883229 · 5 ✖

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
25467797 25467797 PRJNA883229_P_NODE_6000_length_289_cov_1.245370_g5954_i0 PRJNA883229 6000 289 1.24537 3.5991193 Bacteria 2 Bacteria Bacteria 192 3.0300000000000003e-58   NR KRO50477.1 1655570 g5954 i0 100 10.9515570934256 96 0 99.7 0 289 2 177 272 KRO50477.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpX, partial [Actinobacteria bacterium BACL2 MAG-120820-bin50] diamond 3165 192 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120820-bin50
26936680 26936680 PRJNA883229_P_NODE_13582_length_246_cov_0.901734_g13536_i0 PRJNA883229 13582 246 0.901734 2.21826564 Bacteria 2 Bacteria Bacteria 175 4.5199999999999996e-52   NR KRO54138.1 1655570 g13536 i0 100 4 82 0 100 0 246 1 93 174 KRO54138.1 MAG: acyl-CoA dehydrogenase, partial [Actinobacteria bacterium BACL2 MAG-120820-bin50] diamond 984 175 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120820-bin50
27600608 27600608 PRJNA883229_P_NODE_3684_length_346_cov_0.758242_g3638_i0 PRJNA883229 3684 346 0.758242 2.62351732 Bacteria 2 Bacteria Bacteria 231 7.86e-68   NR KRO31092.1 1655568 g3638 i0 97.4 8.96531791907514 115 3 99.7 0 346 2 886 1000 KRO31092.1 MAG: methionine synthase [Actinobacteria bacterium BACL2 MAG-120802-bin41] diamond 3102 233 0.991416309012876 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120802-bin41
31422132 31422132 PRJNA883229_P_NODE_12456_length_248_cov_0.891429_g12410_i0 PRJNA883229 12456 248 0.891429 2.21074392 Clavibacter 1573 Bacteria Bacteria 141 9.28e-39   NR KRO32252.1 1655573 g12410 i0 97.1 4.17338709677419 69 2 83.5 0 40 246 1 69 KRO32252.1 MAG: dihydrolipoamide dehydrogenase, partial [Actinobacteria bacterium BACL2 MAG-121220-bin52] diamond 1035 141 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-121220-bin52
31572530 31572530 PRJNA883229_P_NODE_5336_length_301_cov_0.925439_g5290_i0 PRJNA883229 5336 301 0.925439 2.78557139 Actinobacteria bacterium BACL2 MAG-12 2900548 Bacteria Bacteria 162 8.11e-50   NR KRO26696.1 1655568 g5290 i0 97.8 0.897009966777409 90 2 89.7 0 299 30 1 90 KRO26696.1 MAG: XRE family transcriptional regulator [Actinobacteria bacterium BACL2 MAG-120802-bin41] diamond 270 162 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120802-bin41

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);;