RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA492280", 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 · 19 ✖

tax_kingdom 1

  • Bacillati · 19 ✖

bioproject 1

  • PRJNA492280 · 19 ✖

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
2374302 2374302 PRJNA492280_P_NODE_12662_length_164_cov_6.188976_g12555_i0 PRJNA492280 12662 164 6.188976 10.14992064 Metamycoplasmataceae 2895623 Bacteria Bacteria 230 5.89e-56   NTclustered gi|1563788636|emb|LR214955.1| 2115 g12555 i0 91.975 4.9390243902439 162 5 99 1 1 162 63325 63172 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 810 230 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
2374316 2374316 PRJNA492280_P_NODE_13742_length_164_cov_5.212598_g13635_i0 PRJNA492280 13742 164 5.212598 8.54866072 Metamycoplasmataceae 2895623 Bacteria Bacteria 243 7.57e-60   NTclustered gi|1563788636|emb|LR214955.1| 2115 g13635 i0 91.875 5.25609756097561 160 11 98 1 4 163 208651 208494 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 862 243 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
3002758 3002758 PRJNA492280_P_NODE_3063_length_275_cov_4.037815_g2956_i0 PRJNA492280 3063 275 4.037815 11.10399125 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 344 3.72e-90   NTclustered gi|307624329|gb|CP001995.1| 637387 g2956 i0 100 75.8836363636364 186 0 94 0 90 275 218991 219176 Mycoplasma fermentans JER, complete genome blastn 20868 344 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
4927249 4927249 PRJNA492280_P_NODE_8304_length_184_cov_3.183673_g8197_i0 PRJNA492280 8304 184 3.183673 5.85795832 Metamycoplasmataceae 2895623 Bacteria Bacteria 331 1.8000000000000002e-86   NTclustered gi|1563788636|emb|LR214955.1| 2115 g8197 i0 100 4.86413043478261 179 0 97 0 3 181 425938 425760 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 895 331 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
6202251 6202251 PRJNA492280_P_NODE_6005_length_210_cov_4.907514_g5898_i0 PRJNA492280 6005 210 4.907514 10.3057794 Mycoplasmopsis 2767358 Bacteria Bacteria 226 1.0299999999999999e-54   NTclustered gi|58761239|gb|AY838558.1| 2115 g5898 i0 100 73.6 122 0 93 0 1 122 728 607 Mycoplasma fermentans elongation factor mRNA, complete cds blastn 15456 226 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
8751893 8751893 PRJNA492280_P_NODE_28167_length_157_cov_4.908333_g28060_i0 PRJNA492280 28167 157 4.908333 7.70608281 Metamycoplasmataceae 2895623 Bacteria Bacteria 287 3.26e-73   NTclustered gi|1563790229|emb|LR214963.1| 2115 g28060 i0 100 75.3757961783439 155 0 99 0 1 155 192029 191875 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 11834 287 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
11930533 11930533 PRJNA492280_P_NODE_17110_length_164_cov_3.921260_g17003_i0 PRJNA492280 17110 164 3.92126 6.4308664 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 139 1.02e-28   NTclustered gi|307624329|gb|CP001995.1| 637387 g17003 i0 100 4.51219512195122 75 0 90 0 1 75 508778 508704 Mycoplasma fermentans JER, complete genome blastn 740 139 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
12577803 12577803 PRJNA492280_P_NODE_15430_length_164_cov_4.433071_g15323_i0 PRJNA492280 15430 164 4.433071 7.27023644 Metamycoplasmataceae 2895623 Bacteria Bacteria 139 1.02e-28   NTclustered gi|1563790229|emb|LR214963.1| 2115 g15323 i0 100 25.4329268292683 75 0 90 0 1 75 187571 187497 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 4171 139 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
13852630 13852630 PRJNA492280_P_NODE_33031_length_150_cov_4.548673_g32924_i0 PRJNA492280 33031 150 4.548673 6.8230095 Metamycoplasmataceae 2895623 Bacteria Bacteria 239 8.74e-59   NTclustered gi|1563790229|emb|LR214963.1| 2115 g32924 i0 95.455 10.02 154 0 98 1 4 150 87363 87210 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 1503 239 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
13852654 13852654 PRJNA492280_P_NODE_3711_length_255_cov_3.977064_g3604_i0 PRJNA492280 3711 255 3.977064 10.1415132 Metamycoplasmataceae 2895623 Bacteria Bacteria 272 1.6299999999999998e-68   NTclustered gi|1563790593|emb|LR214965.1| 2115 g3604 i0 92.135 5.58823529411765 178 13 98 1 75 251 54488 54665 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 11 blastn 1425 272 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
15126812 15126812 PRJNA492280_P_NODE_15852_length_164_cov_4.283465_g15745_i0 PRJNA492280 15852 164 4.283465 7.0248826 Metamycoplasmataceae 2895623 Bacteria Bacteria 231 1.6399999999999998e-56   NTclustered gi|1563788636|emb|LR214955.1| 2115 g15745 i0 91.195 5.85365853658537 159 11 97 1 1 159 16859 17014 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 960 231 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
16401435 16401435 PRJNA492280_P_NODE_17613_length_164_cov_3.811024_g17506_i0 PRJNA492280 17613 164 3.811024 6.25007936 Metamycoplasmataceae 2895623 Bacteria Bacteria 141 2.84e-29   NTclustered gi|1563790229|emb|LR214963.1| 2115 g17506 i0 100 42.5365853658537 76 0 91 0 1 76 192347 192272 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 6976 141 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
20225471 20225471 PRJNA492280_P_NODE_32776_length_150_cov_5.070796_g32669_i0 PRJNA492280 32776 150 5.070796 7.606194 Metamycoplasmataceae 2895623 Bacteria Bacteria 134 4.2400000000000006e-27   NTclustered gi|1563790229|emb|LR214963.1| 2115 g32669 i0 100 4.93333333333333 72 0 98 0 76 147 161634 161563 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 740 134 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
21500660 21500660 PRJNA492280_P_NODE_11117_length_165_cov_3.570312_g11010_i0 PRJNA492280 11117 165 3.570312 5.8910148 Metamycoplasmataceae 2895623 Bacteria Bacteria 237 3.5500000000000004e-58   NTclustered gi|1563790229|emb|LR214963.1| 2115 g11010 i0 91.925 23.8484848484848 161 10 98 1 2 162 112445 112288 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 3935 237 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
21501051 21501051 PRJNA492280_P_NODE_9817_length_171_cov_5.067164_g9710_i0 PRJNA492280 9817 171 5.067164 8.66485044 Metamycoplasmataceae 2895623 Bacteria Bacteria 156 1.06e-33   NTclustered gi|1563788636|emb|LR214955.1| 2115 g9710 i0 100 5.50877192982456 84 0 92 0 2 85 47067 46984 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 942 156 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
22775891 22775891 PRJNA492280_P_NODE_1798_length_335_cov_49.993289_g1691_i0 PRJNA492280 1798 335 49.993289 167.47751815 Metamycoplasmataceae 2895623 Bacteria Bacteria 558 1.53e-154   NTclustered gi|1563790229|emb|LR214963.1| 2115 g1691 i0 96.997 170.032835820896 333 9 99 1 1 332 194942 194610 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 56961 558 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
24678123 24678123 PRJNA492280_P_NODE_32660_length_150_cov_5.415929_g32553_i0 PRJNA492280 32660 150 5.415929 8.1238935 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 255 8.680000000000001e-64   NTclustered gi|2627174|dbj|D64083.1| 2115 g32553 i0 97.987 16.8866666666667 149 0 97 1 4 149 168 316 Mycoplasma fermentans mRNA for M161Ag, complete cds blastn 2533 255 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
25325139 25325139 PRJNA492280_P_NODE_2800_length_284_cov_5.060729_g2693_i0 PRJNA492280 2800 284 5.060729 14.37247036 Metamycoplasmataceae 2895623 Bacteria Bacteria 375 1.3699999999999999e-99   NTclustered gi|1563790229|emb|LR214963.1| 2115 g2693 i0 89 169.264084507042 300 17 100 3 1 284 101901 102200 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 48071 375 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
28276408 28276408 PRJNA492280_P_NODE_29646_length_151_cov_6.552632_g29539_i0 PRJNA492280 29646 151 6.552632 9.89447432 Candidatus Phytoplasma solani 69896 Bacteria Bacteria 46.2 1.28e-4   NR CCP88063.1 69896 g29539 i0 50 2.3841059602649 40 9 57.6 1 91 5 26 65 CCP88063.1 conserved hypothetical protein, partial CDS, partial [Candidatus Phytoplasma solani] diamond 360 46.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma solani

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