RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA772154" 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

  • PRJNA772154 · 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
7126014 7126014 PRJNA772154_P_NODE_16846_length_259_cov_1.677419_g16661_i0 PRJNA772154 16846 259 1.677419 4.34451521 Sandaracinus amylolyticus 927083 Bacteria Bacteria 318 2.11e-82   NTclustered gi|2183633570|gb|CP070225.1| 927083 g16661 i0 88.803 68.5637065637066 259 29 100 0 1 259 9677836 9678094 Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence blastn 17758 318 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
16509708 16509708 PRJNA772154_P_NODE_10593_length_348_cov_1.701818_g10408_i0 PRJNA772154 10593 348 1.701818 5.92232664 Polyangiales 3031712 Bacteria Bacteria 479 1.2799999999999996e-130   NTclustered gi|1127353251|gb|CP016211.1| 888845 g10408 i0 91.643 211.600574712644 347 27 99 2 1 346 771062 771407 Minicystis rosea strain DSM 24000 chromosome, complete genome blastn 73637 483 0.991718426501035 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis rosea
21149916 21149916 PRJNA772154_P_NODE_18297_length_251_cov_2.814607_g18112_i0 PRJNA772154 18297 251 2.814607 7.06466357 Labilithrix luteola 1391654 Bacteria Bacteria 392 1.18e-104   NTclustered gi|913610804|gb|CP012333.1| 1391654 g18112 i0 94.821 196.96015936255 251 13 100 0 1 251 3942333 3942083 Labilithrix luteola strain DSM 27648, complete genome blastn 49437 392 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
22884547 22884547 PRJNA772154_P_NODE_22698_length_242_cov_0.923077_g22513_i0 PRJNA772154 22698 242 0.923077 2.23384634 Anaeromyxobacter 161492 Bacteria Bacteria 396 8.739999999999996e-106   NTclustered gi|470482295|ref|NR_076524.1| 404589 g22513 i0 96.281 161.49173553719 242 7 99 2 2 242 737 497 Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence blastn 39081 396 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. Fw109-5

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