RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA169559 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
365001 365001 PRJNA169559_P_NODE_30821_length_261_cov_2.250000_g28745_i0 PRJNA169559 30821 261 2.25 5.8725 Chondromyces crocatus 52 Bacteria Bacteria 200 8.029999999999999e-47   NTclustered gi|908353314|gb|CP012159.1| 52 g28745 i0 89.809 85.6053639846743 157 14 60 2 17 172 697560 697405 Chondromyces crocatus strain Cm c5, complete genome blastn 22343 200 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces crocatus
4192066 4192066 PRJNA169559_P_NODE_25784_length_294_cov_1.350943_g23708_i0 PRJNA169559 25784 294 1.350943 3.97177242 Archangium gephyra 48 Bacteria Bacteria 52.8 0.027   NTclustered gi|827418478|gb|CP011509.1| 48 g23708 i0 100 0.0952380952380952 28 0 10 0 47 74 4865250 4865277 Archangium gephyra strain DSM 2261, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
13118846 13118846 PRJNA169559_P_NODE_38231_length_239_cov_2.076190_g36154_i0 PRJNA169559 38231 239 2.07619 4.9620941 Sandaracinus amylolyticus 927083 Bacteria Bacteria 182 2.63e-41   NTclustered gi|2183633570|gb|CP070225.1| 927083 g36154 i0 81.659 4.20502092050209 229 32 94 10 1 224 2481757 2481980 Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence blastn 1005 182 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus

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