RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA908278 · 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
2165670 2165670 PRJNA908278_P_NODE_28882_length_248_cov_1.760000_g28779_i0 PRJNA908278 28882 248 1.76 4.3648 Pendulispora brunnea 2905690 Bacteria Bacteria 309 1.21e-79   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g28779 i0 89.157 93.4879032258064 249 25 100 2 1 248 7409247 7409000 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 23185 309 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
18741792 18741792 PRJNA908278_P_NODE_21015_length_282_cov_1.473684_g20912_i0 PRJNA908278 21015 282 1.473684 4.15578888 Myxococcales bacterium 2026763 Bacteria Bacteria 298 3.03e-76   NTclustered gi|2258824976|gb|CP060221.1| 2026763 g20912 i0 86.447 134.890070921986 273 35 96 2 1 272 1313406 1313135 MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome blastn 38039 298 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
18741824 18741824 PRJNA908278_P_NODE_24075_length_264_cov_1.460733_g23972_i0 PRJNA908278 24075 264 1.460733 3.85633512 Labilithrix luteola 1391654 Bacteria Bacteria 287 6.07e-73   NTclustered gi|913610804|gb|CP012333.1| 1391654 g23972 i0 87.5 22.094696969697 256 22 94 7 1 249 3943469 3943217 Labilithrix luteola strain DSM 27648, complete genome blastn 5833 287 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
23842541 23842541 PRJNA908278_P_NODE_2939_length_657_cov_1.674658_g2836_i0 PRJNA908278 2939 657 1.674658 11.00250306 Pendulispora rubella 2741070 Bacteria Bacteria 1038 0   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g2836 i0 95.282 167.377473363775 657 27 100 3 1 657 7289485 7288833 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 109967 1038 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella

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