RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA550047 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
8165681 8165681 PRJNA550047_P_NODE_140167_length_345_cov_5.356618_g138207_i0 PRJNA550047 140167 345 5.356618 18.4803321 Mesomycoplasma moatsii 171287 Bacteria Bacteria 279 1.38e-70   NTclustered gi|2860287645|gb|CP174166.1| 171287 g138207 i0 100 2.76231884057971 151 0 88 0 195 345 179043 178893 Mesomycoplasma moatsii strain MK 405 chromosome, complete genome blastn 953 279 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma moatsii
8774462 8774462 PRJNA550047_P_NODE_432747_length_253_cov_0.866667_g430775_i0 PRJNA550047 432747 253 0.866667 2.19266751 Ureaplasma 2129 Bacteria Bacteria 462 8.95e-126   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g430775 i0 99.605 16 253 1 100 0 1 253 85263 85515 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 4048 462 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
18973155 18973155 PRJNA550047_P_NODE_471195_length_240_cov_7.916168_g469222_i0 PRJNA550047 471195 240 7.916168 18.9988032 Ureaplasma 2129 Bacteria Bacteria 444 3.05e-120   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g469222 i0 100 11 240 0 100 0 1 240 123825 123586 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 2640 444 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
22798656 22798656 PRJNA550047_P_NODE_412218_length_260_cov_9.262032_g410246_i0 PRJNA550047 412218 260 9.262032 24.0812832 Ureaplasma 2129 Bacteria Bacteria 481 2.55e-131   NTclustered gi|620596742|dbj|AP014584.1| 38504 g410246 i0 100 16 260 0 100 0 1 260 114057 113798 Ureaplasma parvum serovar 3 DNA, complete genome, strain: SV3F4 blastn 4160 481 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum

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