RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB39643 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
6435491 6435491 PRJEB39643_P_NODE_119066_length_252_cov_2.581006_g118873_i0 PRJEB39643 119066 252 2.581006 6.50413512 Archangium violaceum 83451 Bacteria Bacteria 191 4.64e-44   NTclustered gi|1981856374|gb|CP069338.1| 83451 g118873 i0 81.405 1.89285714285714 242 38 94 6 15 251 12544361 12544122 Archangium violaceum strain SDU34 chromosome, complete genome blastn 477 191 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
7710064 7710064 PRJEB39643_P_NODE_154647_length_229_cov_3.461538_g154454_i0 PRJEB39643 154647 229 3.461538 7.92692202 Archangium violaceum 83451 Bacteria Bacteria 204 5.33e-48   NTclustered gi|1981856374|gb|CP069338.1| 83451 g154454 i0 84.018 59.3886462882096 219 27 94 7 7 221 10277349 10277563 Archangium violaceum strain SDU34 chromosome, complete genome blastn 13600 204 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
16633968 16633968 PRJEB39643_P_NODE_10154_length_615_cov_5.215867_g9972_i0 PRJEB39643 10154 615 5.215867 32.07758205 Nannocystis punicea 2995304 Bacteria Bacteria 351 5.37e-92   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g9972 i0 82.051 56.7739837398374 429 61 69 11 188 613 5377150 5377565 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 34916 351 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
16634922 16634922 PRJEB39643_P_NODE_47514_length_287_cov_2.878505_g47321_i0 PRJEB39643 47514 287 2.878505 8.26130935 Nannocystis punicea 2995304 Bacteria Bacteria 182 3.24e-41   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g47321 i0 78.929 96.8850174216028 280 49 96 10 1 275 9883934 9884208 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 27806 182 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
20459146 20459146 PRJEB39643_P_NODE_70777_length_275_cov_1.524752_g70584_i0 PRJEB39643 70777 275 1.524752 4.193068 Nannocystis punicea 2995304 Bacteria Bacteria 198 3.07e-46   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g70584 i0 82.278 5.95636363636364 237 35 85 7 10 242 6098338 6098105 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 1638 198 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
23941821 23941821 PRJEB39643_P_NODE_42939_length_290_cov_1.419355_g42746_i0 PRJEB39643 42939 290 1.419355 4.1161295 Myxococcia 32015 Bacteria Bacteria 289 1.88e-73   NTclustered gi|913610804|gb|CP012333.1| 1391654 g42746 i0 85.366 16.3344827586207 287 32 97 8 10 290 7915561 7915843 Labilithrix luteola strain DSM 27648, complete genome blastn 4737 289 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola

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