RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312899 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
14408411 14408411 PRJNA312899_P_NODE_38932_length_287_cov_3.605042_g38490_i0 PRJNA312899 38932 287 3.605042 10.34647054 Haploplasma axanthum 29552 Bacteria Bacteria 276 1.45e-69   NTclustered gi|1563809587|emb|LR215048.1| 29552 g38490 i0 84.806 121.313588850174 283 34 99 8 1 277 56952 57231 Acholeplasma axanthum strain NCTC10138 genome assembly, chromosome: 1 blastn 34817 276 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma axanthum
14408953 14408953 PRJNA312899_P_NODE_69252_length_195_cov_2.082192_g68810_i0 PRJNA312899 69252 195 2.082192 4.0602744 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 231 2.02e-56   NTclustered gi|2621717558|emb|OY775910.1| 1898209 g68810 i0 88.542 38.6923076923077 192 20 98 2 1 192 768821 768632 MAG: Acholeplasmataceae bacterium isolate 79d77305-d387-4e48-9b67-53dfc1ec32a7 genome assembly, chromosome: 1 blastn 7545 231 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
25290870 25290870 PRJNA312899_P_NODE_53980_length_234_cov_4.410811_g53538_i0 PRJNA312899 53980 234 4.410811 10.32129774 Ureaplasma 2129 Bacteria Bacteria 431 2.3e-116   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g53538 i0 100 13.9401709401709 233 0 99 0 2 234 361194 361426 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 3262 431 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);;