RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA904835" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA904835 · 20 ✖

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
8535653 8535653 PRJNA904835_P_NODE_24887_length_399_cov_1.702454_g24632_i0 PRJNA904835 24887 399 1.702454 6.79279146 Mycoplasmopsis maculosa 114885 Bacteria Bacteria 78.7 6.31e-10   NTclustered gi|1563804680|emb|LR215037.1| 114885 g24632 i0 74.731 0.466165413533835 186 41 46 6 203 384 310396 310579 Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1 blastn 186 78.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis maculosa
13636506 13636506 PRJNA904835_P_NODE_26591_length_384_cov_1.401929_g26335_i0 PRJNA904835 26591 384 1.401929 5.38340736 Mycoplasmopsis maculosa 114885 Bacteria Bacteria 67.6 1.31e-6   NTclustered gi|1563804680|emb|LR215037.1| 114885 g26335 i0 93.333 0.1171875 45 3 12 0 69 113 310496 310452 Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1 blastn 45 67.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis maculosa
17460464 17460464 PRJNA904835_P_NODE_10134_length_670_cov_1.425461_g9898_i0 PRJNA904835 10134 670 1.425461 9.5505887 Mycoplasmopsis maculosa 114885 Bacteria Bacteria 75 1.42e-8   NTclustered gi|1563804680|emb|LR215037.1| 114885 g9898 i0 78.761 0.16865671641791 113 22 17 2 296 407 310385 310496 Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1 blastn 113 75 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis maculosa
25109689 25109689 PRJNA904835_P_NODE_56020_length_245_cov_0.895349_g55764_i0 PRJNA904835 56020 245 0.895349 2.19360505 Metamycoplasma alkalescens 45363 Bacteria Bacteria 448 2.41e-121   NTclustered gi|1450418660|emb|LS991949.1| 45363 g55764 i0 99.592 1 245 1 100 0 1 245 458379 458135 Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1 blastn 245 448 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma alkalescens
27182117 27182117 PRJNA904835_P_NODE_27742_length_375_cov_1.500000_g27486_i0 PRJNA904835 27742 375 1.5 5.625 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 52.8 4.35e-5   NR MDD5602154.1 3018265 g27486 i0 35.9 0.736 92 59 73.6 0 61 336 218 309 MDD5602154.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 276 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
27340496 27340496 PRJNA904835_P_NODE_31283_length_350_cov_1.086643_g31027_i0 PRJNA904835 31283 350 1.086643 3.8032505 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 172 1.68e-50   NR MDV3181150.1 2754999 g31027 i0 75 0.994285714285714 116 29 99.4 0 1 348 137 252 MDV3181150.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 348 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
27719728 27719728 PRJNA904835_P_NODE_10764_length_647_cov_1.874564_g10523_i0 PRJNA904835 10764 647 1.874564 12.12842908 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 46.6 0.0371   NR MDV3181150.1 2754999 g10523 i0 53.8 0.180834621329212 39 18 18.1 0 262 378 207 245 MDV3181150.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 117 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28571737 28571737 PRJNA904835_P_NODE_49867_length_253_cov_2.061111_g49611_i0 PRJNA904835 49867 253 2.061111 5.21461083 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 41.6 0.0129   NR MDV3186347.1 2754999 g49611 i0 59 0.462450592885375 39 16 46.2 0 90 206 1 39 MDV3186347.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 117 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28603460 28603460 PRJNA904835_P_NODE_54027_length_247_cov_0.885057_g53771_i0 PRJNA904835 54027 247 0.885057 2.18609079 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 108 6.64e-29   NR MDV3202301.1 2754999 g53771 i0 100 0.947368421052632 78 0 94.7 0 3 236 16 93 MDV3202301.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 234 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28666605 28666605 PRJNA904835_P_NODE_17987_length_482_cov_1.286064_g17732_i0 PRJNA904835 17987 482 1.286064 6.19882848 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 80.9 5.96e-17   NR MDV3181175.1 2754999 g17732 i0 100 0.24896265560166 40 0 24.9 0 122 3 1 40 MDV3181175.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 120 80.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28855773 28855773 PRJNA904835_P_NODE_32508_length_342_cov_0.903346_g32252_i0 PRJNA904835 32508 342 0.903346 3.08944332 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 95.5 5.090000000000001e-22   NR MDV3181284.1 2754999 g32252 i0 67.6 0.596491228070175 68 22 59.6 0 223 20 55 122 MDV3181284.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 204 95.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
29392824 29392824 PRJNA904835_P_NODE_47149_length_266_cov_1.196891_g46893_i0 PRJNA904835 47149 266 1.196891 3.18373006 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 80.9 8.49e-16   NR MDV3181150.1 2754999 g46893 i0 58.2 0.755639097744361 67 28 75.6 0 63 263 190 256 MDV3181150.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 201 80.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
29455475 29455475 PRJNA904835_P_NODE_8390_length_745_cov_1.726190_g8163_i0 PRJNA904835 8390 745 1.72619 12.8601155 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 78.2 5.76e-15   NR MDV3190797.1 2754999 g8163 i0 75 0.209395973154362 52 13 20.9 0 516 361 1 52 MDV3190797.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 156 78.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
29771426 29771426 PRJNA904835_P_NODE_22291_length_424_cov_3.179487_g22036_i0 PRJNA904835 22291 424 3.179487 13.48102488 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 128 1.6e-34   NR MDV3181231.1 2754999 g22036 i0 53.6 1.06839622641509 151 53 99.1 3 422 3 10 154 MDV3181231.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 453 128 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30909082 30909082 PRJNA904835_P_NODE_25294_length_396_cov_0.928793_g25038_i0 PRJNA904835 25294 396 0.928793 3.67802028 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 43.5 0.00961   NR MDV3192317.1 2754999 g25038 i0 37.5 0.484848484848485 64 28 48.5 2 294 103 16 67 MDV3192317.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 192 43.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30909099 30909099 PRJNA904835_P_NODE_48054_length_262_cov_1.206349_g47798_i0 PRJNA904835 48054 262 1.206349 3.16063438 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 100 2.4699999999999994e-23   NR MDV3181150.1 2754999 g47798 i0 71.6 0.767175572519084 67 19 76.7 0 261 61 13 79 MDV3181150.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 201 100 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
31256530 31256530 PRJNA904835_P_NODE_36595_length_318_cov_0.906122_g36339_i0 PRJNA904835 36595 318 0.906122 2.88146796 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.4 8.09e-4   NR MDV3186347.1 2754999 g36339 i0 54.2 0.452830188679245 48 20 45.3 1 303 160 17 62 MDV3186347.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 144 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
31762584 31762584 PRJNA904835_P_NODE_2597_length_1313_cov_1.737097_g2479_i0 PRJNA904835 2597 1313 1.737097 22.80808361 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 47.4 0.00446   NR MDV3192318.1 2754999 g2479 i0 72.7 0.0753998476770754 33 8 7.5 1 529 431 34 65 MDV3192318.1 FAD-dependent oxidoreductase [Candidatus Phytoplasma australasiaticum] diamond 99 47.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32237573 32237573 PRJNA904835_P_NODE_38458_length_308_cov_0.821277_g38202_i0 PRJNA904835 38458 308 0.821277 2.52953316 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 55.1 3.25e-6   NR MDV3181150.1 2754999 g38202 i0 86.2 0.282467532467532 29 4 28.2 0 202 116 16 44 MDV3181150.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 87 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32868486 32868486 PRJNA904835_P_NODE_14480_length_547_cov_1.470464_g14228_i0 PRJNA904835 14480 547 1.470464 8.04343808 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 109 2.07e-27   NR MDV3181247.1 2754999 g14228 i0 84.4 0.351005484460695 64 10 35.1 0 354 545 22 85 MDV3181247.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 192 109 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum

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