RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA688352" 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

  • PRJNA688352 · 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
1942848 1942848 PRJNA688352_P_NODE_12782_length_228_cov_2.767742_g12679_i0 PRJNA688352 12782 228 2.767742 6.31045176 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 422 1.34e-113   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12679 i0 100 123.635964912281 228 0 100 0 1 228 797506 797279 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 28189 422 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
5770525 5770525 PRJNA688352_P_NODE_6545_length_259_cov_3.086022_g6442_i0 PRJNA688352 6545 259 3.086022 7.99279698 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 473 4.25e-129   NTclustered gi|1563796921|emb|LR215008.1| 2107 g6442 i0 99.614 124.586872586873 259 1 100 0 1 259 800034 800292 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 32268 473 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
15969562 15969562 PRJNA688352_P_NODE_12813_length_226_cov_2.013072_g12710_i0 PRJNA688352 12813 226 2.013072 4.54954272 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 412 8.01e-111   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12710 i0 99.558 99.0619469026549 226 1 100 0 1 226 799805 800030 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 22388 412 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
17244809 17244809 PRJNA688352_P_NODE_12294_length_241_cov_0.916667_g12191_i0 PRJNA688352 12294 241 0.916667 2.20916747 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 435 1.84e-117   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12191 i0 99.17 100.174273858921 241 2 100 0 1 241 800501 800741 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 24142 435 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis

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