RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 19 ✖

analysis 1

  • diamond · 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
21507320 21507320 PRJNA493827_P_NODE_210957_length_245_cov_2.145349_g208759_i0 PRJNA493827 210957 245 2.145349 5.25610505 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 92 1.55e-19   NR MDR0752969.1 2685873 g208759 i0 57.5 3.55102040816327 73 31 89.4 0 2 220 295 367 MDR0752969.1 F0F1 ATP synthase subunit alpha [Mycoplasmataceae bacterium] diamond 870 92 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
23424940 23424940 PRJNA493827_P_NODE_26019_length_744_cov_3.219076_g24072_i0 PRJNA493827 26019 744 3.219076 23.94992544 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 273 2.95e-86   NR HXN54563.1 2023991 g24072 i0 61.3 1 248 96 100 0 1 744 100 347 HXN54563.1 NADH-quinone oxidoreductase subunit M [Mycoplasmatales bacterium] diamond 744 273 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
24697359 24697359 PRJNA493827_P_NODE_186120_length_251_cov_0.865169_g183922_i0 PRJNA493827 186120 251 0.865169 2.17157419 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 114 2.0100000000000003e-27   NR MDV3176183.1 101513 g183922 i0 63.4 0.9800796812749 82 30 98 0 5 250 1579 1660 MDV3176183.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 246 114 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
24698052 24698052 PRJNA493827_P_NODE_221160_length_243_cov_1.394118_g218962_i0 PRJNA493827 221160 243 1.394118 3.38770674 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 95.1 1.38e-20   NR MDV3176183.1 101513 g218962 i0 51.9 1.93827160493827 79 38 97.5 0 239 3 1604 1682 MDV3176183.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 471 95.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
26760104 26760104 PRJNA493827_P_NODE_114981_length_319_cov_0.939024_g112783_i0 PRJNA493827 114981 319 0.939024 2.99548656 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 80.1 1.43e-15   NR HEY8364594.1 2862752 g112783 i0 57.3 0.705329153605016 75 32 70.5 0 91 315 15 89 HEY8364594.1 type II TA system antitoxin MqsA family protein [Haloplasmataceae bacterium] diamond 225 80.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
27361490 27361490 PRJNA493827_P_NODE_17003_length_965_cov_1.845291_g15338_i0 PRJNA493827 17003 965 1.845291 17.80705815 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 61.6 8.03e-7   NR HXN54601.1 2023991 g15338 i0 32.5 0.391709844559586 126 81 38.5 2 585 956 116 239 HXN54601.1 hypothetical protein [Mycoplasmatales bacterium] diamond 378 61.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
27771941 27771941 PRJNA493827_P_NODE_159484_length_271_cov_1.555556_g157286_i0 PRJNA493827 159484 271 1.555556 4.21555676 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 56.6 2.08e-7   NR HXN54403.1 2023991 g157286 i0 35.2 0.974169741697417 88 57 97.4 0 2 265 83 170 HXN54403.1 hypothetical protein [Mycoplasmatales bacterium] diamond 264 56.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28055794 28055794 PRJNA493827_P_NODE_176705_length_257_cov_1.130435_g174507_i0 PRJNA493827 176705 257 1.130435 2.90521795 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 103 1.81e-23   NR MDV3176183.1 101513 g174507 i0 55.6 0.945525291828794 81 36 94.6 0 243 1 1759 1839 MDV3176183.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 243 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28087446 28087446 PRJNA493827_P_NODE_88345_length_365_cov_2.373288_g86147_i0 PRJNA493827 88345 365 2.373288 8.6625012 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 55.8 6.03e-7   NR HXN54566.1 2023991 g86147 i0 29.5 0.780821917808219 95 62 78.1 2 288 4 11 100 HXN54566.1 hypothetical protein [Mycoplasmatales bacterium] diamond 285 55.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28150867 28150867 PRJNA493827_P_NODE_31465_length_666_cov_1.453626_g29360_i0 PRJNA493827 31465 666 1.453626 9.68114916 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 104 1.5299999999999999e-24   NR HXN54411.1 2023991 g29360 i0 43.2 0.531531531531532 118 67 53.2 0 356 3 1 118 HXN54411.1 uL14 family ribosomal protein [Mycoplasmatales bacterium] diamond 354 104 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28276848 28276848 PRJNA493827_P_NODE_59766_length_455_cov_1.628272_g57570_i0 PRJNA493827 59766 455 1.628272 7.4086376 Acholeplasma sp. 33015 Bacteria Bacteria 65.5 4.13e-9   NR RJX24460.1 33015 g57570 i0 48.3 1.2 58 30 38.2 0 186 359 435 492 RJX24460.1 MAG: alpha-glucosidase [Acholeplasma sp.] diamond 546 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
28434836 28434836 PRJNA493827_P_NODE_135386_length_293_cov_2.359091_g133188_i0 PRJNA493827 135386 293 2.359091 6.91213663 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 75.5 6.89e-14   NR MCK9234832.1 1898209 g133188 i0 44.8 0.982935153583618 96 53 98.3 0 292 5 170 265 MCK9234832.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 288 75.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28876748 28876748 PRJNA493827_P_NODE_129648_length_300_cov_1.634361_g127450_i0 PRJNA493827 129648 300 1.634361 4.903083 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 60.5 1.3e-9   NR HXN54401.1 2023991 g127450 i0 44.3 0.79 79 44 79 0 9 245 2 80 HXN54401.1 uS14 family ribosomal protein [Mycoplasmatales bacterium] diamond 237 60.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28940235 28940235 PRJNA493827_P_NODE_5888_length_1771_cov_2.931684_g5044_i0 PRJNA493827 5888 1771 2.931684 51.92012364 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 170 1.8299999999999998e-46   NR HXN54586.1 2023991 g5044 i0 73.4 0.184641445511011 109 29 18.5 0 819 1145 16 124 HXN54586.1 30S ribosomal protein S12 [Mycoplasmatales bacterium] diamond 327 170 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29161292 29161292 PRJNA493827_P_NODE_29889_length_686_cov_1.384992_g27832_i0 PRJNA493827 29889 686 1.384992 9.50104512 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 56.2 3.72e-5   NR HXN54413.1 2023991 g27832 i0 49.1 0.231778425655977 53 27 23.2 0 19 177 674 726 HXN54413.1 hypothetical protein [Mycoplasmatales bacterium] diamond 159 56.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29192719 29192719 PRJNA493827_P_NODE_181649_length_253_cov_1.077778_g179451_i0 PRJNA493827 181649 253 1.077778 2.72677834 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 96.7 4.7e-21   NR MDV3176183.1 101513 g179451 i0 51.2 0.99604743083004 84 41 99.6 0 253 2 1606 1689 MDV3176183.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 252 96.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30108371 30108371 PRJNA493827_P_NODE_221412_length_243_cov_1.252941_g219214_i0 PRJNA493827 221412 243 1.252941 3.04464663 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 42.4 0.0186   NR WNE40253.1 2685873 g219214 i0 47.4 0.469135802469136 38 20 46.9 0 125 238 20 57 WNE40253.1 MAG: Internalin J [Mycoplasmataceae bacterium] diamond 114 42.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
30582179 30582179 PRJNA493827_P_NODE_50853_length_499_cov_3.730047_g48663_i0 PRJNA493827 50853 499 3.730047 18.61293453 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 50.4 8.29e-4   NR HXN54584.1 2023991 g48663 i0 51.1 0.270541082164329 45 22 27.1 0 68 202 8 52 HXN54584.1 cytochrome b N-terminal domain-containing protein [Mycoplasmatales bacterium] diamond 135 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
30645384 30645384 PRJNA493827_P_NODE_80313_length_384_cov_2.016077_g78115_i0 PRJNA493827 80313 384 2.016077 7.74173568 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 66.2 1.05e-9   NR MBR4496047.1 2053494 g78115 i0 36.1 3.046875 108 60 82.8 3 383 66 546 646 MBR4496047.1 AAA family ATPase [Acholeplasmatales bacterium] diamond 1170 66.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales 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);;