RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB36940 · 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
1330973 1330973 PRJEB36940_P_NODE_10182_length_275_cov_1.009901_g10053_i0 PRJEB36940 10182 275 1.009901 2.77722775 Nannocystis punicea 2995304 Bacteria Bacteria 263 1.07e-65   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g10053 i0 85.944 86.9309090909091 249 32 90 3 28 275 5377565 5377319 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 23906 263 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
7709103 7709103 PRJEB36940_P_NODE_15207_length_244_cov_0.906433_g15078_i0 PRJEB36940 15207 244 0.906433 2.21169652 Labilithrix luteola 1391654 Bacteria Bacteria 385 1.91e-102   NTclustered gi|913610804|gb|CP012333.1| 1391654 g15078 i0 95.082 211.147540983607 244 12 100 0 1 244 3943509 3943752 Labilithrix luteola strain DSM 27648, complete genome blastn 51520 385 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
22665836 22665836 PRJEB36940_P_NODE_16398_length_229_cov_2.596154_g16269_i0 PRJEB36940 16398 229 2.596154 5.94519266 Myxococcia 32015 Bacteria Bacteria 363 8.309999999999999e-96   NTclustered gi|913610804|gb|CP012333.1| 1391654 g16269 i0 95.197 267.829694323144 229 11 100 0 1 229 3944430 3944658 Labilithrix luteola strain DSM 27648, complete genome blastn 61333 363 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
25215098 25215098 PRJEB36940_P_NODE_14720_length_245_cov_0.906977_g14591_i0 PRJEB36940 14720 245 0.906977 2.22209365 root 1 Root_unresolved Root_unresolved 405 1.47e-108   NTclustered gi|507148211|ref|NR_103018.1| 56 g14591 i0 97.083 130.889795918367 240 7 98 0 6 245 1258 1497 Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence blastn 32068 405 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum

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