RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA914897 · 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
4723321 4723321 PRJNA914897_P_NODE_15824_length_443_cov_1.408108_g15402_i0 PRJNA914897 15824 443 1.408108 6.23791844 Spiroplasma culicicola 216935 Bacteria Bacteria 52.8 0.043   NTclustered gi|583840421|gb|CP006681.1| 1276246 g15402 i0 96.774 0.069977426636568807 31 1 7 0 38 68 947483 947513 Spiroplasma culicicola AES-1, complete genome blastn 31 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma culicicola
11098417 11098417 PRJNA914897_P_NODE_30789_length_284_cov_1.241706_g30365_i0 PRJNA914897 30789 284 1.241706 3.52644504 Mycoplasmopsis bovis 28903 Bacteria Bacteria 58.4 5.64e-4   NTclustered gi|1951464263|gb|CP058416.1| 28903 g30365 i0 97.059 1.26056338028169 34 1 12 0 170 203 274351 274384 Mycoplasmopsis bovis strain Mb200 chromosome blastn 358 58.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
11098570 11098570 PRJNA914897_P_NODE_8009_length_684_cov_1.371522_g7608_i0 PRJNA914897 8009 684 1.371522 9.38121048 Spiroplasma endosymbiont of Polydrusus formosus 3139326 Bacteria Bacteria 54.7 0.019   NTclustered gi|2802839271|emb|OZ181656.1| 3139326 g7608 i0 100 0.0423976608187134 29 0 4 0 73 101 1283150 1283178 Spiroplasma endosymbiont of Polydrusus formosus isolate 995c39d1-0117-465c-80e3-e7618475d57f genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Polydrusus formosus
14005003 14005003 PRJNA914897_P_NODE_3171_length_1109_cov_1.818533_g2914_i0 PRJNA914897 3171 1109 1.818533 20.16753097 Spiroplasma 2132 Bacteria Bacteria 58.4 0.002   NTclustered gi|2721114795|dbj|AP028955.1| 2141 g2914 i0 94.595 0.597835888187556 37 2 3 0 932 968 831057 831021 Spiroplasma ixodetis sAp269 DNA, complete genome blastn 663 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis

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