RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA177642 · 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
4192605 4192605 PRJNA177642_P_NODE_17604_length_166_cov_1.051095_g16379_i0 PRJNA177642 17604 166 1.051095 1.7448177 Pendulispora albinea 2741071 Bacteria Bacteria 161 2.21e-35   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g16379 i0 85.093 0.969879518072289 161 20 96 4 5 163 8019866 8020024 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 161 161 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
5468705 5468705 PRJNA177642_P_NODE_10685_length_341_cov_1.551282_g9461_i0 PRJNA177642 10685 341 1.551282 5.28987162 Myxococcus sp. SDU36 2831967 Bacteria Bacteria 56.5 0.002   NTclustered gi|2513984958|gb|CP077414.1| 2831967 g9461 i0 100 0.0879765395894428 30 0 9 0 3 32 6741051 6741022 Myxococcus sp. SDU36 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp. SDU36
15082694 15082694 PRJNA177642_P_NODE_5512_length_605_cov_10.072917_g4435_i0 PRJNA177642 5512 605 10.072917 60.94114785 Myxococcia 32015 Bacteria Bacteria 610 7.879999999999996e-170   NTclustered gi|1566495190|gb|CP012670.1| 56 g4435 i0 85.082 117.170247933884 610 78 99 11 4 603 4848785 4848179 Sorangium cellulosum strain So ceGT47 chromosome, complete genome blastn 70888 614 0.993485342019544 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
22731917 22731917 PRJNA177642_P_NODE_4598_length_683_cov_17.058104_g3589_i0 PRJNA177642 4598 683 17.058104 116.50685032 Myxococcia 32015 Bacteria Bacteria 924 0   NTclustered gi|913610804|gb|CP012333.1| 1391654 g3589 i0 91.014 190.617862371889 690 54 99 5 1 682 3942887 3942198 Labilithrix luteola strain DSM 27648, complete genome blastn 130192 924 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola

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