RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA929940" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 6 ✖

bioproject 1

  • PRJNA929940 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
12388284 12388284 PRJNA929940_S_NODE_49730_length_161_cov_1.016129_g49495_i0 PRJNA929940 49730 161 1.016129 1.63596769 Neomicrococcus aestuarii 556325 Bacteria Bacteria 56.5 0.001   NTclustered gi|1109133054|gb|CP018135.1| 556325 g49495 i0 96.97 0.204968944099379 33 1 20 0 75 107 1146950 1146918 Neomicrococcus aestuarii strain B18 chromosome, complete genome blastn 33 56.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Neomicrococcus Neomicrococcus aestuarii
15282713 15282713 PRJNA929940_S_NODE_55692_length_154_cov_1.316239_g55457_i0 PRJNA929940 55692 154 1.316239 2.02700806 Micrococcus 1269 Bacteria Bacteria 279 5.33e-71   NTclustered gi|1891023613|gb|CP058971.1| 1270 g55457 i0 99.351 340.876623376623 154 1 100 0 1 154 346142 346295 Micrococcus luteus strain V017 chromosome, complete genome blastn 52495 279 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
16212069 16212069 PRJNA929940_S_NODE_30513_length_194_cov_2.783439_g30278_i0 PRJNA929940 30513 194 2.783439 5.39987166 uncultured Actinomycetes bacterium 152507 Bacteria Bacteria 348 1.91e-91   NTclustered gi|686688730|gb|KM031457.1| 152507 g30278 i0 98.969 98.2886597938144 194 2 100 0 1 194 397 590 Uncultured actinobacterium clone D9-49 16S ribosomal RNA gene, partial sequence blastn 19068 348 1 Bacteria   Bacillati Actinomycetota Actinomycetes       uncultured Actinomycetes bacterium
20035737 20035737 PRJNA929940_S_NODE_42916_length_170_cov_1.744361_g42681_i0 PRJNA929940 42916 170 1.744361 2.9654137 Clostridium neonatale 137838 Bacteria Bacteria 167 4.87e-37   NTclustered gi|2153692850|emb|OU997945.1| 137838 g42681 i0 84.524 98.8235294117647 168 26 99 0 1 168 3704104 3703937 Clostridium neonatale isolate 250_09 genome assembly, chromosome: CNEO blastn 16800 167 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium neonatale
20381129 20381129 PRJNA929940_S_NODE_18016_length_239_cov_1.504950_g17781_i0 PRJNA929940 18016 239 1.50495 3.5968305 Micrococcus 1269 Bacteria Bacteria 412 8.549999999999998e-111   NTclustered gi|1891023613|gb|CP058971.1| 1270 g17781 i0 97.908 191.02510460251 239 3 100 2 1 239 346165 345929 Micrococcus luteus strain V017 chromosome, complete genome blastn 45655 412 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
24206365 24206365 PRJNA929940_S_NODE_49119_length_161_cov_3.209677_g48884_i0 PRJNA929940 49119 161 3.209677 5.16757997 Micrococcus 1269 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1891023613|gb|CP058971.1| 1270 g48884 i0 100 295.478260869565 161 0 100 0 1 161 345721 345561 Micrococcus luteus strain V017 chromosome, complete genome blastn 47572 298 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus

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