RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA879067 · 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
4684825 4684825 PRJNA879067_P_NODE_92704_length_288_cov_2.418605_g89218_i0 PRJNA879067 92704 288 2.418605 6.9655824 Stigmatella aurantiaca 41 Bacteria Bacteria 52.8 0.027   NTclustered gi|309390350|gb|CP002271.1| 378806 g89218 i0 100 0.0972222222222222 28 0 10 0 82 109 7922904 7922877 Stigmatella aurantiaca DW4/3-1, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
15266670 15266670 PRJNA879067_P_NODE_108872_length_244_cov_0.900585_g105386_i0 PRJNA879067 108872 244 0.900585 2.1974274 Stigmatella 40 Bacteria Bacteria 326 1.17e-84   NTclustered gi|507148216|ref|NR_103023.1| 41 g105386 i0 90.947 213.356557377049 243 20 99 2 2 244 1443 1203 Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence blastn 52059 326 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
22532292 22532292 PRJNA879067_P_NODE_58858_length_457_cov_3.309896_g55373_i0 PRJNA879067 58858 457 3.309896 15.12622472 Sandaracinus amylolyticus 927083 Bacteria Bacteria 521 2.809999999999999e-143   NTclustered gi|2183633570|gb|CP070225.1| 927083 g55373 i0 89.07 198.588621444201 430 34 94 10 1 428 9676778 9676360 Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence blastn 90755 521 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
22532940 22532940 PRJNA879067_P_NODE_83638_length_324_cov_1.167331_g80152_i0 PRJNA879067 83638 324 1.167331 3.78215244 Myxococcus stipitatus 83455 Bacteria Bacteria 503 6.99e-138   NTclustered gi|2722781719|gb|CP102770.1| 83455 g80152 i0 97.619 377.027777777778 294 5 90 2 32 324 5052275 5052567 Myxococcus stipitatus strain YRE12 chromosome, complete genome blastn 122157 503 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus stipitatus

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