RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB73599 · 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
2685235 2685235 PRJEB73599_P_NODE_1983_length_525_cov_3.897177_g1733_i0 PRJEB73599 1983 525 3.897177 20.46017925 Labilithrix luteola 1391654 Bacteria Bacteria 593 6.819999999999998e-165   NTclustered gi|913610804|gb|CP012333.1| 1391654 g1733 i0 87.17 108.285714285714 530 58 99 9 1 523 7915270 7915796 Labilithrix luteola strain DSM 27648, complete genome blastn 56850 593 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
7787565 7787565 PRJEB73599_P_NODE_6467_length_235_cov_3.684466_g6180_i0 PRJEB73599 6467 235 3.684466 8.6584951 Labilithrix luteola 1391654 Bacteria Bacteria 279 8.87e-71   NTclustered gi|913610804|gb|CP012333.1| 1391654 g6180 i0 94.944 125.28085106383 178 9 76 0 58 235 3942649 3942472 Labilithrix luteola strain DSM 27648, complete genome blastn 29441 279 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
12888759 12888759 PRJEB73599_P_NODE_7291_length_210_cov_2.751381_g7004_i0 PRJEB73599 7291 210 2.751381 5.7779001 Labilithrix luteola 1391654 Bacteria Bacteria 267 6.05e-67   NTclustered gi|913610804|gb|CP012333.1| 1391654 g7004 i0 89.952 54.0428571428571 209 17 99 3 4 210 3941996 3942202 Labilithrix luteola strain DSM 27648, complete genome blastn 11349 267 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
20536104 20536104 PRJEB73599_P_NODE_6857_length_223_cov_30.293814_g6570_i0 PRJEB73599 6857 223 30.293814 67.55520522 Labilithrix luteola 1391654 Bacteria Bacteria 411 2.84e-110   NTclustered gi|913610804|gb|CP012333.1| 1391654 g6570 i0 100 185.340807174888 222 0 99 0 1 222 3944276 3944055 Labilithrix luteola strain DSM 27648, complete genome blastn 41331 411 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola

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