RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1233465 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
25553179 25553179 PRJNA1233465f_S_NODE_144057_length_204_cov_1.329032_g141777_i0 PRJNA1233465 144057 204 1.329032 2.71122528 Mycoplasmopsis felis 33923 Bacteria Bacteria 54.7 0.005   NTclustered gi|2303524955|gb|CP104193.1| 33923 g141777 i0 100 0.71078431372549 29 0 14 0 112 140 628978 629006 Mycoplasmopsis felis strain 16-040612-4 chromosome blastn 145 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis felis
25560264 25560264 PRJNA1233465f_S_NODE_68185_length_281_cov_1.293103_g65905_i0 PRJNA1233465 68185 281 1.293103 3.63361943 Spiroplasma citri 2133 Bacteria Bacteria 54.7 0.007   NTclustered gi|2477858054|gb|ON511091.1| 2133 g65905 i0 100 3.19217081850534 29 0 10 0 104 132 2750 2778 Spiroplasma citri strain D12 plasmid unnamed blastn 897 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma citri
25683626 25683626 PRJNA1233465e_S_NODE_153586_length_164_cov_1.069565_g152276_i0 PRJNA1233465 153586 164 1.069565 1.7540866 Mycoplasmopsis agassizii 33922 Bacteria Bacteria 54.7 0.004   NTclustered gi|2789550291|gb|CP166874.1| 33922 g152276 i0 100 0.176829268292683 29 0 18 0 128 156 342466 342438 Mycoplasmopsis agassizii strain 55P4 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis agassizii
25690216 25690216 PRJNA1233465f_S_NODE_167882_length_191_cov_1.753521_g165602_i0 PRJNA1233465 167882 191 1.753521 3.34922511 Mycoplasmopsis lipophila 2117 Bacteria Bacteria 56.5 0.001   NTclustered gi|2860286954|gb|CP174165.1| 2117 g165602 i0 100 0.157068062827225 30 0 16 0 17 46 796703 796732 Mycoplasmopsis lipophila strain MaBy chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis lipophila
25816794 25816794 PRJNA1233465d_S_NODE_73195_length_207_cov_1.936709_g72084_i0 PRJNA1233465 73195 207 1.936709 4.00898763 Metamycoplasma faucium 56142 Bacteria Bacteria 339 1.2399999999999998e-88   NTclustered gi|2921905358|gb|CP182786.1| 56142 g72084 i0 97.475 7.64734299516908 198 5 96 0 1 198 502953 502756 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 1583 339 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
25956333 25956333 PRJNA1233465e_S_NODE_165316_length_161_cov_0.910714_g164006_i0 PRJNA1233465 165316 161 0.910714 1.46624954 Spiroplasma endosymbiont of Anurida maritima 2967972 Bacteria Bacteria 117 4.68e-22   NTclustered gi|2812212550|gb|CP102059.1| 2967972 g164006 i0 88.542 21.7204968944099 96 11 60 0 43 138 150772 150677 Spiroplasma endosymbiont of Anurida maritima isolate Wells-next-the-Sea chromosome, complete genome blastn 3497 117 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Anurida maritima
26235664 26235664 PRJNA1233465f_S_NODE_186446_length_183_cov_1.380597_g184166_i0 PRJNA1233465 186446 183 1.380597 2.52649251 Spiroplasma kunkelii CR2-3x 273035 Bacteria Bacteria 58.4 3.35e-4   NTclustered gi|922842379|gb|CP010899.1| 273035 g184166 i0 94.737 2.16939890710383 38 0 20 2 145 181 425082 425046 Spiroplasma kunkelii CR2-3x, complete genome blastn 397 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma kunkelii
26236955 26236955 PRJNA1233465f_S_NODE_218430_length_171_cov_2.491803_g216150_i0 PRJNA1233465 218430 171 2.491803 4.26098313 Metamycoplasma faucium 56142 Bacteria Bacteria 294 2.16e-75   NTclustered gi|2921905358|gb|CP182786.1| 56142 g216150 i0 97.661 7.26900584795322 171 4 100 0 1 171 502783 502953 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 1243 294 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
26486477 26486477 PRJNA1233465a_S_NODE_241680_length_162_cov_1.805310_g240406_i0 PRJNA1233465 241680 162 1.80531 2.9246022 Spiroplasma endosymbiont of Acasis viretata 3066306 Bacteria Bacteria 137 3.6199999999999997e-28   NTclustered gi|2719904907|emb|OZ035019.1| 3066306 g240406 i0 90.385 196.271604938272 104 10 64 0 59 162 954024 953921 Spiroplasma endosymbiont of Acasis viretata isolate 54777 genome assembly, chromosome: 1 blastn 31796 137 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Acasis viretata
26489967 26489967 PRJNA1233465b_S_NODE_187248_length_215_cov_1.765060_g185563_i0 PRJNA1233465 187248 215 1.76506 3.794879 Mycoplasma feliminutum 36741 Bacteria Bacteria 237 4.88e-58   NTclustered gi|294768451|gb|GU905036.1| 36741 g185563 i0 86.697 472.679069767442 218 23 100 6 1 215 1238 1024 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 101626 237 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feliminutum
26491499 26491499 PRJNA1233465b_S_NODE_303104_length_174_cov_1.384000_g301419_i0 PRJNA1233465 303104 174 1.384 2.40816 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 178 2.31e-40   NTclustered gi|2187152066|emb|OV788644.1| 658143 g301419 i0 85.311 2.47701149425287 177 20 100 6 1 174 394858 394685 uncultured Tenericutes bacterium isolate min17_bin35 genome assembly, chromosome: 1 blastn 431 178 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
26575139 26575139 PRJNA1233465f_S_NODE_146040_length_203_cov_1.181818_g143760_i0 PRJNA1233465 146040 203 1.181818 2.39909054 Bacteria 2 Bacteria Bacteria 52.8 0.018   NTclustered gi|1450425804|emb|LS991954.1| 2123 g143760 i0 100 0.689655172413793 28 0 14 0 75 102 570210 570237 Mycoplasma putrefaciens strain NCTC10155 genome assembly, chromosome: 1 blastn 140 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma putrefaciens

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