RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA608660 · 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
5688276 5688276 PRJNA608660_P_NODE_1785_length_937_cov_7.718468_g974_i1 PRJNA608660 1785 937 7.718468 72.32204516 Myxococcales bacterium 2026763 Bacteria Bacteria 612 3.47e-170   NTclustered gi|2258824976|gb|CP060221.1| 2026763 g974 i1 78.942 121.385272145144 945 165 99 20 1 926 1312523 1313452 MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome blastn 113738 612 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
6250649 6250649 PRJNA608660_P_NODE_41625_length_182_cov_1.563910_g41268_i0 PRJNA608660 41625 182 1.56391 2.8463162 Pendulispora 3375062 Bacteria Bacteria 178 2.45e-40   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g41268 i0 94.737 151.989010989011 114 6 63 0 57 170 7287256 7287143 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 27662 178 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
13338921 13338921 PRJNA608660_P_NODE_42311_length_179_cov_3.815385_g41954_i0 PRJNA608660 42311 179 3.815385 6.82953915 Myxococcales bacterium 2026763 Bacteria Bacteria 189 1.1099999999999999e-43   NTclustered gi|2258824976|gb|CP060221.1| 2026763 g41954 i0 88.05 161.184357541899 159 19 89 0 6 164 1311862 1312020 MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome blastn 28852 189 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
15175220 15175220 PRJNA608660_P_NODE_3672_length_732_cov_19.862372_g3413_i0 PRJNA608660 3672 732 19.862372 145.39256304 Stigmatella 40 Bacteria Bacteria 907 0   NTclustered gi|507148216|ref|NR_103023.1| 41 g3413 i0 94.836 250.821038251366 581 30 99 0 152 732 575 1155 Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence blastn 183601 907 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
15887759 15887759 PRJNA608660_P_NODE_4953_length_651_cov_5.626246_g4657_i0 PRJNA608660 4953 651 5.626246 36.62686146 Archangium violaceum 83451 Bacteria Bacteria 588 3.989999999999999e-163   NTclustered gi|2579675135|gb|CP043493.1| 83451 g4657 i0 83.308 266.282642089094 659 88 99 18 6 651 5179723 5180372 Archangium violaceum strain Cbvi 34 chromosome, complete genome blastn 173350 588 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
19711124 19711124 PRJNA608660_P_NODE_14856_length_380_cov_2.981873_g14503_i0 PRJNA608660 14856 380 2.981873 11.3311174 Myxococcales bacterium 2026763 Bacteria Bacteria 272 2.55e-68   NTclustered gi|2258824976|gb|CP060221.1| 2026763 g14503 i0 82.803 68.8710526315789 314 44 81 10 67 375 1312453 1312761 MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome blastn 26171 272 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium

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