RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
6923344 6923344 PRJNA561212_P_NODE_15926_length_283_cov_1.147619_g15715_i0 PRJNA561212 15926 283 1.147619 3.24776177 Haliangium ochraceum 80816 Bacteria Bacteria 78.7 4.31e-10   NTclustered gi|262076673|gb|CP001804.1| 502025 g15715 i0 84.615 1.07773851590106 78 12 28 0 19 96 686475 686552 Haliangium ochraceum DSM 14365, complete genome blastn 305 78.7 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum
20257217 20257217 PRJNA561212_P_NODE_26436_length_216_cov_4.580420_g26225_i0 PRJNA561212 26436 216 4.58042 9.8937072 Polyangiales 3031712 Bacteria Bacteria 294 2.87e-75   NTclustered gi|169977285|emb|AM946600.1| 52 g26225 i0 93.035 159.291666666667 201 14 93 0 3 203 1670 1870 Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 blastn 34407 294 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces crocatus
23497613 23497613 PRJNA561212_P_NODE_11899_length_321_cov_4.048387_g11688_i0 PRJNA561212 11899 321 4.048387 12.99532227 Minicystis rosea 888845 Bacteria Bacteria 518 2.47e-142   NTclustered gi|1127353251|gb|CP016211.1| 888845 g11688 i0 97.987 115.031152647975 298 6 93 0 15 312 770366 770069 Minicystis rosea strain DSM 24000 chromosome, complete genome blastn 36925 518 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis rosea
24771638 24771638 PRJNA561212_P_NODE_20520_length_252_cov_2.815642_g20309_i0 PRJNA561212 20520 252 2.815642 7.09541784 Pendulispora albinea 2741071 Bacteria Bacteria 331 2.62e-86   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g20309 i0 92.275 138 233 18 92 0 10 242 3589219 3588987 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 34776 331 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea

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