RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA1248424", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 10 ✖

tax_kingdom 1

  • Bacillati · 10 ✖

bioproject 1

  • PRJNA1248424 · 10 ✖

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
3602413 3602413 PRJNA1248424_P_NODE_53763_length_291_cov_12.509174_g47695_i0 PRJNA1248424 53763 291 12.509174 36.40169634 root 1 Root_unresolved Root_unresolved 516 7.95e-142   NTclustered gi|2591109271|gb|OR648474.1| 37628 g47695 i0 98.625 115.714776632302 291 4 100 0 1 291 534 824 Mollicutes bacterium strain A0039 16S ribosomal RNA gene, partial sequence blastn 33673 521 0.990403071017274 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
8704696 8704696 PRJNA1248424_P_NODE_58847_length_279_cov_0.902913_g52779_i0 PRJNA1248424 58847 279 0.902913 2.51912727 Mycoplasma 2093 Bacteria Bacteria 516 7.58e-142   NTclustered gi|365822471|gb|JN935874.1| 51364 g52779 i0 100 149.555555555556 279 0 100 0 1 279 1261 983 Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 41726 516 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
9281051 9281051 PRJNA1248424_P_NODE_50448_length_307_cov_1.192308_g44380_i0 PRJNA1248424 50448 307 1.192308 3.66038556 Spiroplasma endosymbiont of Dioctria linearis 3066290 Bacteria Bacteria 52.8 0.029   NTclustered gi|2719904871|emb|OZ034984.1| 3066290 g44380 i0 100 0.0912052117263844 28 0 9 0 1 28 1035637 1035664 Spiroplasma endosymbiont of Dioctria linearis isolate 54760 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Dioctria linearis
9979901 9979901 PRJNA1248424_P_NODE_41588_length_360_cov_2.170732_g35526_i0 PRJNA1248424 41588 360 2.170732 7.8146352 Mycoplasma 2093 Bacteria Bacteria 664 0   NTclustered gi|2294785939|gb|CP103424.1| 51364 g35526 i0 100 194.458333333333 359 0 99 0 2 360 270230 269872 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 70005 664 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
10556627 10556627 PRJNA1248424_P_NODE_35049_length_427_cov_3.437853_g28993_i0 PRJNA1248424 35049 427 3.437853 14.67963231 Malacoplasma muris 2119 Bacteria Bacteria 52.8 0.041   NTclustered gi|2890642799|gb|CP177248.1| 2119 g28993 i0 100 0.0655737704918033 28 0 7 0 53 80 121304 121331 Malacoplasma muris strain RIII-4 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
14381557 14381557 PRJNA1248424_P_NODE_30772_length_496_cov_2.971631_g24732_i0 PRJNA1248424 30772 496 2.971631 14.73928976 Spiroplasma endosymbiont of Polydrusus formosus 3139326 Bacteria Bacteria 60.2 2.89e-4   NTclustered gi|2802839271|emb|OZ181656.1| 3139326 g24732 i0 94.872 0.26008064516129 39 1 8 1 200 238 300961 300924 Spiroplasma endosymbiont of Polydrusus formosus isolate 995c39d1-0117-465c-80e3-e7618475d57f genome assembly, chromosome: 1 blastn 129 60.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Polydrusus formosus
20754446 20754446 PRJNA1248424_P_NODE_5737_length_2519_cov_59.369992_g4157_i0 PRJNA1248424 5737 2519 59.369992 1495.53009848 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 56.5 0.02   NTclustered gi|2511947619|gb|CP126225.1| 72990 g4157 i0 100 0.0119094878920206 30 0 1 0 225 254 435024 434995 MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma cynodontis
24579171 24579171 PRJNA1248424_P_NODE_51220_length_303_cov_1.004348_g45152_i0 PRJNA1248424 51220 303 1.004348 3.04317444 Mycoplasma yeatsii 51365 Bacteria Bacteria 449 8.570000000000001e-122   NTclustered gi|756767228|gb|CP007520.1| 743967 g45152 i0 93.399 91.986798679868 303 20 100 0 1 303 391713 391411 Mycoplasma yeatsii GM274B blastn 27872 449 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
27168205 27168205 PRJNA1248424_P_NODE_22942_length_728_cov_2.218321_g17145_i0 PRJNA1248424 22942 728 2.218321 16.14937688 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 47.4 0.0384   NR HXN54441.1 2023991 g17145 i0 33.7 0.366758241758242 89 57 36.3 2 143 406 517 604 HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium] diamond 267 47.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
31165647 31165647 PRJNA1248424_P_NODE_69015_length_251_cov_0.865169_g62946_i0 PRJNA1248424 69015 251 0.865169 2.17157419 FCB group 1783270 Bacteria Bacteria 142 1.04e-39   NR MDI4567808.1 2108 g62946 i0 90.1 1.93625498007968 81 8 96.8 0 247 5 145 225 MDI4567808.1 DNA sulfur modification protein DndD [Mycoplasma sp.] diamond 486 142 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.

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