RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1010662" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1010662 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2705209 2705209 PRJNA1010662_S_NODE_2323_length_215_cov_1.116279_g2278_i0 PRJNA1010662 2323 215 1.116279 2.39999985 Mycoplasma wenyonii 65123 Bacteria Bacteria 359 9.969999999999999e-95   NTclustered gi|395455868|gb|CP003703.1| 1197325 g2278 i0 96.744 1 215 7 100 0 1 215 281645 281859 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 215 359 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
3981405 3981405 PRJNA1010662_S_NODE_1564_length_247_cov_2.352941_g1519_i0 PRJNA1010662 1564 247 2.352941 5.81176427 Mycoplasma wenyonii 65123 Bacteria Bacteria 457 4.05e-124   NTclustered gi|395455868|gb|CP003703.1| 1197325 g1519 i0 100 1 247 0 100 0 1 247 35841 36087 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 247 457 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
5257891 5257891 PRJNA1010662_S_NODE_4185_length_169_cov_1.000000_g4140_i0 PRJNA1010662 4185 169 1 1.69 Mycoplasma ovis 171632 Bacteria Bacteria 117 4.93e-22   NTclustered gi|566058721|gb|CP006935.1| 1415773 g4140 i0 80.128 1.92307692307692 156 31 100 0 1 156 95600 95755 Mycoplasma ovis str. Michigan, complete genome blastn 325 117 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
7807543 7807543 PRJNA1010662_S_NODE_5327_length_152_cov_1.321101_g5282_i0 PRJNA1010662 5327 152 1.321101 2.00807352 Mycoplasma wenyonii 65123 Bacteria Bacteria 134 4.31e-27   NTclustered gi|395455868|gb|CP003703.1| 1197325 g5282 i0 83.333 0.947368421052632 144 24 95 0 1 144 440088 440231 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 144 134 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
11633474 11633474 PRJNA1010662_P_NODE_16690_length_162_cov_0.920354_g16631_i0 PRJNA1010662 16690 162 0.920354 1.49097348 Metamycoplasma subdolum 92407 Bacteria Bacteria 56.5 0.001   NTclustered gi|2619735232|gb|CP137846.1| 92407 g16631 i0 94.595 0.228395061728395 37 1 22 1 22 57 142621 142585 Metamycoplasma subdolum strain TB chromosome, complete genome blastn 37 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma subdolum
14183532 14183532 PRJNA1010662_P_NODE_15412_length_164_cov_0.904348_g15353_i0 PRJNA1010662 15412 164 0.904348 1.48313072 Mycoplasmopsis maculosa 114885 Bacteria Bacteria 58.4 2.94e-4   NTclustered gi|1563804680|emb|LR215037.1| 114885 g15353 i0 97.059 0.207317073170732 34 1 21 0 130 163 310459 310492 Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1 blastn 34 58.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis maculosa
15457579 15457579 PRJNA1010662_S_NODE_2953_length_195_cov_2.789474_g2908_i0 PRJNA1010662 2953 195 2.789474 5.4394743 Mycoplasma wenyonii 65123 Bacteria Bacteria 355 1.15e-93   NTclustered gi|395455868|gb|CP003703.1| 1197325 g2908 i0 99.487 1 195 1 100 0 1 195 462695 462889 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 195 355 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
18006742 18006742 PRJNA1010662_S_NODE_3035_length_193_cov_1.280000_g2990_i0 PRJNA1010662 3035 193 1.28 2.4704 Mycoplasma wenyonii 65123 Bacteria Bacteria 187 4.37e-43   NTclustered gi|395455868|gb|CP003703.1| 1197325 g2990 i0 84.293 0.989637305699482 191 30 99 0 3 193 163713 163903 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 191 187 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
18006754 18006754 PRJNA1010662_S_NODE_4415_length_165_cov_1.180328_g4370_i0 PRJNA1010662 4415 165 1.180328 1.9475412 Mycoplasma wenyonii 65123 Bacteria Bacteria 148 1.71e-31   NTclustered gi|395455868|gb|CP003703.1| 1197325 g4370 i0 96.629 0.539393939393939 89 3 54 0 2 90 408080 408168 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 89 148 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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