RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA285816 · 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
2922746 2922746 PRJNA285816_S_NODE_283_length_1073_cov_95.308594_g244_i0 PRJNA285816 283 1073 95.308594 1022.66121362 Pendulispora rubella 2741070 Bacteria Bacteria 1343 0   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g244 i0 90.37 142.343895619758 1028 92 96 6 48 1073 7289998 7288976 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 152735 1343 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
4199258 4199258 PRJNA285816_S_NODE_564_length_819_cov_89.303896_g506_i0 PRJNA285816 564 819 89.303896 731.39890824 Labilithrix luteola 1391654 Bacteria Bacteria 1055 0   NTclustered gi|913610804|gb|CP012333.1| 1391654 g506 i0 89.88 153.283272283272 830 70 100 11 1 819 3941974 3942800 Labilithrix luteola strain DSM 27648, complete genome blastn 125539 1055 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
9987309 9987309 PRJNA285816_S_NODE_8048_length_251_cov_6.306931_g7946_i0 PRJNA285816 8048 251 6.306931 15.83039681 Myxococcus 32 Bacteria Bacteria 246 9.72e-61   NTclustered gi|2318731907|gb|CP104804.1| 34 g7946 i0 84.739 240.533864541833 249 34 98 3 5 251 380291 380537 Myxococcus xanthus strain DK1050 chromosome blastn 60374 246 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus xanthus
15674786 15674786 PRJNA285816_S_NODE_27633_length_164_cov_1.156522_g27531_i0 PRJNA285816 27633 164 1.156522 1.89669608 Myxococcales bacterium 2026763 Bacteria Bacteria 154 3.65e-33   NTclustered gi|2258824976|gb|CP060221.1| 2026763 g27531 i0 84.615 88.8353658536585 156 22 95 2 10 164 1313135 1313289 MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome blastn 14569 154 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
15674843 15674843 PRJNA285816_S_NODE_453_length_890_cov_86.925089_g401_i0 PRJNA285816 453 890 86.925089 773.6332921 Pendulispora rubella 2741070 Bacteria Bacteria 1050 0   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g401 i0 87.987 114.930337078652 899 94 100 12 1 890 9852389 9853282 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 102288 1050 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
16361638 16361638 PRJNA285816_S_NODE_513_length_850_cov_6.127341_g459_i0 PRJNA285816 513 850 6.127341 52.0823985 Stigmatella 40 Bacteria Bacteria 1090 0   NTclustered gi|507148216|ref|NR_103023.1| 41 g459 i0 89.953 241.184705882353 856 71 100 11 1 850 924 78 Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence blastn 205007 1090 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca

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