RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1145997 · 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
3583859 3583859 PRJNA1145997_P_NODE_27223_length_449_cov_4.893617_g24606_i0 PRJNA1145997 27223 449 4.893617 21.97234033 Myxococcus 32 Bacteria Bacteria 52.8 0.043   NTclustered gi|2869653495|gb|CP175551.1| 33 g24606 i0 92.308 0.173719376391982 39 0 8 2 286 321 754130 754092 Myxococcus fulvus strain KYC1117 chromosome, complete genome blastn 78 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus fulvus
9217691 9217691 PRJNA1145997_P_NODE_48568_length_243_cov_0.917647_g45949_i0 PRJNA1145997 48568 243 0.917647 2.22988221 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 239 1.57e-58   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g45949 i0 84.426 178.094650205761 244 36 100 2 1 243 9485973 9485731 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 43277 239 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis
18141263 18141263 PRJNA1145997_P_NODE_40955_length_260_cov_2.807487_g38336_i0 PRJNA1145997 40955 260 2.807487 7.2994662 Sandaracinus amylolyticus 927083 Bacteria Bacteria 241 4.71e-59   NTclustered gi|816953346|gb|CP011125.1| 927083 g38336 i0 89.894 2.67307692307692 188 17 72 2 47 233 5810363 5810549 Sandaracinus amylolyticus strain DSM 53668, complete genome blastn 695 241 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
21966563 21966563 PRJNA1145997_P_NODE_50758_length_225_cov_5.605263_g48139_i0 PRJNA1145997 50758 225 5.605263 12.61184175 Polyangium aurulentum 2567896 Bacteria Bacteria 161 3.1899999999999996e-35   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g48139 i0 93.519 56.1333333333333 108 7 48 0 96 203 10603721 10603828 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 12630 161 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum

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