RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA591127", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA591127 · 13 ✖

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
1138662 1138662 PRJNA591127_P_NODE_13121_length_203_cov_1.867470_g12952_i0 PRJNA591127 13121 203 1.86747 3.7909641 Ureaplasma 2129 Bacteria Bacteria 337 4.3599999999999994e-88   NTclustered gi|306410979|gb|HM197715.1| 42093 g12952 i0 96.552 120.137931034483 203 7 100 0 1 203 3712 3914 Ureaplasma cati strain ATCC 49228 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 24388 337 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma cati
3115892 3115892 PRJNA591127_P_NODE_11203_length_220_cov_1.797814_g11034_i0 PRJNA591127 11203 220 1.797814 3.9551908 Mycoplasma feliminutum 36741 Bacteria Bacteria 147 8.689999999999999e-31   NTclustered gi|294768451|gb|GU905036.1| 36741 g11034 i0 87.597 143.418181818182 129 13 58 3 93 220 300 426 Mycoplasma feliminutum strain ATCC 25749 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence blastn 31552 147 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feliminutum
5668828 5668828 PRJNA591127_P_NODE_24885_length_169_cov_1.871212_g24716_i0 PRJNA591127 24885 169 1.871212 3.16234828 Ureaplasma zalophigenitalium 907723 Bacteria Bacteria 189 1.0299999999999998e-43   NTclustered gi|309385701|gb|HQ377518.1| 907723 g24716 i0 88.961 158.952662721893 154 15 91 2 4 156 4393 4545 Ureaplasma zalophigenitalium strain CSL7644-GEN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 26863 189 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma zalophigenitalium
8791708 8791708 PRJNA591127_P_NODE_5027_length_326_cov_1.608997_g4859_i0 PRJNA591127 5027 326 1.608997 5.24533022 Ureaplasma 2129 Bacteria Bacteria 276 1.67e-69   NTclustered gi|620596742|dbj|AP014584.1| 38504 g4859 i0 82.121 186.21472392638 330 52 100 6 1 326 29953 30279 Ureaplasma parvum serovar 3 DNA, complete genome, strain: SV3F4 blastn 60706 276 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
10769466 10769466 PRJNA591127_P_NODE_9169_length_243_cov_1.888350_g9001_i0 PRJNA591127 9169 243 1.88835 4.5886905 Ureaplasma diversum 42094 Bacteria Bacteria 372 1.48e-98   NTclustered gi|764071633|gb|CP009770.1| 42094 g9001 i0 94.262 138.271604938272 244 13 100 1 1 243 140318 140561 Ureaplasma diversum strain ATCC 49782 genome blastn 33600 372 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma diversum
12044172 12044172 PRJNA591127_P_NODE_21610_length_191_cov_2.025974_g21441_i0 PRJNA591127 21610 191 2.025974 3.86961034 Mycoplasma feliminutum 36741 Bacteria Bacteria 172 1.21e-38   NTclustered gi|294768451|gb|GU905036.1| 36741 g21441 i0 82.902 166.586387434555 193 29 100 4 1 191 2174 1984 Mycoplasma feliminutum strain ATCC 25749 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence blastn 31818 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feliminutum
12044212 12044212 PRJNA591127_P_NODE_26130_length_162_cov_4.392000_g25961_i0 PRJNA591127 26130 162 4.392 7.11504 Mycoplasma feliminutum 36741 Bacteria Bacteria 172 9.92e-39   NTclustered gi|294768451|gb|GU905036.1| 36741 g25961 i0 87.013 480.592592592593 154 18 94 2 10 162 1397 1245 Mycoplasma feliminutum strain ATCC 25749 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence blastn 77856 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feliminutum
13892803 13892803 PRJNA591127_P_NODE_23511_length_178_cov_1.170213_g23342_i0 PRJNA591127 23511 178 1.170213 2.08297914 Ureaplasma 2129 Bacteria Bacteria 324 2.89e-84   NTclustered gi|2806730808|gb|PQ350924.1| 293430 g23342 i0 100 98.3033707865169 175 0 98 0 1 175 409 583 Uncultured Ureaplasma sp. clone 234-22 16S ribosomal RNA gene, partial sequence blastn 17498 324 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma uncultured Ureaplasma sp.
14593815 14593815 PRJNA591127_P_NODE_13492_length_200_cov_2.374233_g13323_i0 PRJNA591127 13492 200 2.374233 4.748466 Ureaplasma gallorale 42096 Bacteria Bacteria 244 2.67e-60   NTclustered gi|302703647|gb|HM241735.1| 42096 g13323 i0 89 144.375 200 18 100 4 1 200 3075 2880 Ureaplasma gallorale 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 28875 244 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma gallorale
14593916 14593916 PRJNA591127_P_NODE_25012_length_168_cov_3.648855_g24843_i0 PRJNA591127 25012 168 3.648855 6.1300764 Mycoplasma feliminutum 36741 Bacteria Bacteria 233 4.7e-57   NTclustered gi|294768451|gb|GU905036.1| 36741 g24843 i0 91.765 246.291666666667 170 10 100 4 1 168 1707 1540 Mycoplasma feliminutum strain ATCC 25749 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence blastn 41377 233 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feliminutum
20967249 20967249 PRJNA591127_P_NODE_22337_length_186_cov_1.046980_g22168_i0 PRJNA591127 22337 186 1.04698 1.9473828 Metamycoplasma faucium 56142 Bacteria Bacteria 339 1.0899999999999998e-88   NTclustered gi|2708452869|gb|CP088155.1| 56142 g22168 i0 99.462 152.704301075269 186 1 100 0 1 186 605044 605229 Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome blastn 28403 339 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
24791343 24791343 PRJNA591127_P_NODE_4900_length_329_cov_295.914384_g4732_i0 PRJNA591127 4900 329 295.914384 973.55832336 Ureaplasma sp. 1965234 Bacteria Bacteria 592 1.4799999999999996e-164   NTclustered gi|2624684045|gb|OR879216.1| 1965234 g4732 i0 99.091 98.2492401215805 330 2 100 1 1 329 987 1316 Ureaplasma sp. strain 2674 16S ribosomal RNA gene, partial sequence blastn 32324 592 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma sp.
31325440 31325440 PRJNA591127_P_NODE_2915_length_417_cov_3.576316_g2748_i0 PRJNA591127 2915 417 3.576316 14.91323772 Bacteria 2 Bacteria Bacteria 53.1 5.29e-5   NR HHU55237.1 1898209 g2748 i0 37.3 1.9568345323741 75 47 54 0 404 180 413 487 HHU55237.1 sel1 repeat family protein [Acholeplasmataceae bacterium] diamond 816 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium

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