RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA924320 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
899023 899023 PRJNA924320_S_NODE_14221_length_266_cov_1.626728_g14079_i0 PRJNA924320 14221 266 1.626728 4.32709648 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 52.8 0.024   NTclustered gi|2108117163|gb|CP070734.1| 2026735 g14079 i0 100 0.105263157894737 28 0 11 0 110 137 2160336 2160309 MAG: Deltaproteobacteria bacterium isolate bin407 chromosome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
4727524 4727524 PRJNA924320_S_NODE_11544_length_291_cov_1.322314_g11402_i0 PRJNA924320 11544 291 1.322314 3.84793374 Sandaracinus amylolyticus 927083 Bacteria Bacteria 58.4 5.79e-4   NTclustered gi|816953346|gb|CP011125.1| 927083 g11402 i0 97.059 0.116838487972509 34 1 12 0 113 146 9377482 9377449 Sandaracinus amylolyticus strain DSM 53668, complete genome blastn 34 58.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
6002217 6002217 PRJNA924320_S_NODE_15965_length_254_cov_0.926829_g15823_i0 PRJNA924320 15965 254 0.926829 2.35414566 Anaeromyxobacter sp. Fw109-5 404589 Bacteria Bacteria 135 2.2300000000000003e-27   NTclustered gi|152026452|gb|CP000769.1| 404589 g15823 i0 80.447 39.8937007874016 179 33 70 2 74 251 1788231 1788408 Anaeromyxobacter sp. Fw109-5, complete genome blastn 10133 135 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. Fw109-5
11102883 11102883 PRJNA924320_S_NODE_49749_length_165_cov_0.879310_g49607_i0 PRJNA924320 49749 165 0.87931 1.4508615 Haliangium ochraceum 80816 Bacteria Bacteria 119 1.34e-22   NTclustered gi|262076673|gb|CP001804.1| 502025 g49607 i0 89.362 28.0242424242424 94 10 57 0 72 165 9394911 9394818 Haliangium ochraceum DSM 14365, complete genome blastn 4624 119 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum
16202069 16202069 PRJNA924320_S_NODE_21293_length_226_cov_1.502825_g21151_i0 PRJNA924320 21293 226 1.502825 3.3963845 Myxococcus stipitatus 83455 Bacteria Bacteria 52.8 0.02   NTclustered gi|2722781719|gb|CP102770.1| 83455 g21151 i0 100 0.123893805309735 28 0 12 0 116 143 935505 935532 Myxococcus stipitatus strain YRE12 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus stipitatus
22576140 22576140 PRJNA924320_S_NODE_1898_length_666_cov_2.661264_g1777_i0 PRJNA924320 1898 666 2.661264 17.72401824 Labilithrix luteola 1391654 Bacteria Bacteria 54.7 0.018   NTclustered gi|913610804|gb|CP012333.1| 1391654 g1777 i0 100 0.0435435435435435 29 0 4 0 131 159 9099141 9099169 Labilithrix luteola strain DSM 27648, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
25125476 25125476 PRJNA924320_S_NODE_5500_length_405_cov_2.691011_g5358_i0 PRJNA924320 5500 405 2.691011 10.89859455 Nannocystis punicea 2995304 Bacteria Bacteria 339 2.66e-88   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g5358 i0 83.467 82.8641975308642 375 50 92 9 18 391 5377202 5377565 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 33560 339 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea

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