RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA784298 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2041218 2041218 PRJNA784298_P_NODE_18342_length_289_cov_1.425926_g18141_i0 PRJNA784298 18342 289 1.425926 4.12092614 Pendulispora brunnea 2905690 Bacteria Bacteria 381 2.9999999999999997e-101   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g18141 i0 90.592 133.076124567474 287 27 99 0 1 287 7408471 7408185 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 38459 381 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
5868896 5868896 PRJNA784298_P_NODE_25745_length_244_cov_1.660819_g25544_i0 PRJNA784298 25745 244 1.660819 4.05239836 Stigmatella aurantiaca 41 Bacteria Bacteria 261 3.36e-65   NTclustered gi|2244675|emb|X87291.1| 41 g25544 i0 90.05 222.987704918033 201 20 82 0 35 235 358 558 S.aurantiaca 23S rRNA gene blastn 54409 261 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
10969384 10969384 PRJNA784298_P_NODE_13809_length_336_cov_1.437262_g13608_i0 PRJNA784298 13809 336 1.437262 4.82920032 Cystobacter fuscus 43 Bacteria Bacteria 562 1.18e-155   NTclustered gi|2579665545|gb|CP043492.1| 43 g13608 i0 97.015 256.77380952381 335 9 99 1 1 335 452035 452368 Cystobacter fuscus strain Cbf 8 chromosome, complete genome blastn 86276 562 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
19892295 19892295 PRJNA784298_P_NODE_6656_length_491_cov_1.863636_g6456_i0 PRJNA784298 6656 491 1.863636 9.15045276 Pendulispora brunnea 2905690 Bacteria Bacteria 761 0   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g6456 i0 95.041 154.452138492872 484 24 99 0 8 491 7408838 7408355 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 75836 761 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
21167899 21167899 PRJNA784298_P_NODE_23497_length_252_cov_1.290503_g23296_i0 PRJNA784298 23497 252 1.290503 3.25206756 Cystobacter fuscus 43 Bacteria Bacteria 296 9.56e-76   NTclustered gi|2579656172|gb|CP043491.1| 43 g23296 i0 92.344 118.289682539683 209 15 83 1 45 252 396075 396283 Cystobacter fuscus strain Cbf 10 chromosome, complete genome blastn 29809 296 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus

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