RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1215813 · 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
3596321 3596321 PRJNA1215813_P_NODE_10743_length_248_cov_0.891429_g10663_i0 PRJNA1215813 10743 248 0.891429 2.21074392 Polyangiaceae 49 Bacteria Bacteria 313 9.32e-81   NTclustered gi|1566478966|gb|CP012672.1| 56 g10663 i0 90.948 127.129032258065 232 21 95 0 1 232 3691775 3692006 Sorangium cellulosum strain So ce836 chromosome, complete genome blastn 31528 313 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
9259811 9259811 PRJNA1215813_P_NODE_9268_length_253_cov_1.300000_g9188_i0 PRJNA1215813 9268 253 1.3 3.289 Pendulispora albinea 2741071 Bacteria Bacteria 237 5.899999999999999e-58   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g9188 i0 84.362 372.695652173913 243 36 96 2 12 253 3588005 3587764 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 94292 237 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
11810463 11810463 PRJNA1215813_P_NODE_550_length_916_cov_1.480427_g499_i0 PRJNA1215813 550 916 1.480427 13.56071132 Labilithrix luteola 1391654 Bacteria Bacteria 1173 0   NTclustered gi|913610804|gb|CP012333.1| 1391654 g499 i0 89.73 141.625545851528 925 85 100 7 1 916 7090438 7089515 Labilithrix luteola strain DSM 27648, complete genome blastn 129729 1173 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
23283873 23283873 PRJNA1215813_P_NODE_10999_length_247_cov_0.896552_g10919_i0 PRJNA1215813 10999 247 0.896552 2.21448344 Archangium gephyra 48 Bacteria Bacteria 52.8 0.022   NTclustered gi|827418478|gb|CP011509.1| 48 g10919 i0 96.875 0.129554655870445 32 0 13 1 85 116 7215500 7215530 Archangium gephyra strain DSM 2261, complete genome blastn 32 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra

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