RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA690124", tax_clade = "ac1 cluster" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 2 ✖

tax_kingdom 1

tax_clade 1

  • ac1 cluster · 2 ✖

bioproject 1

  • PRJNA690124 · 2 ✖

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
5006970 5006970 PRJNA690124_P_NODE_46724_length_250_cov_0.881356_g46358_i0 PRJNA690124 46724 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 174 9.21e-49   NR KRO32800.1 1655573 g46358 i0 98.8 9.96 83 1 99.6 0 249 1 623 705 KRO32800.1 MAG: glycine dehydrogenase, partial [Actinobacteria bacterium BACL2 MAG-121220-bin52] diamond 2490 174 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-121220-bin52
31187888 31187888 PRJNA690124_P_NODE_49415_length_248_cov_0.862857_g49049_i0 PRJNA690124 49415 248 0.862857 2.13988536 Actinobacteria bacterium BACL2 MAG-12 2900548 Bacteria Bacteria 160 2.12e-47   NR KRO45513.1 1655569 g49049 i0 95.1 2.9758064516129 82 4 99.2 0 246 1 98 179 KRO45513.1 MAG: hypothetical protein ABR61_06575 [Actinobacteria bacterium BACL2 MAG-120813-bin23] diamond 738 160 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120813-bin23

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