RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA278119 · 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
6161588 6161588 PRJNA278119_P_NODE_2445_length_782_cov_3.725784_g2228_i0 PRJNA278119 2445 782 3.725784 29.13563088 Haliangium 162027 Bacteria Bacteria 529 2.9699999999999992e-145   NTclustered gi|470485361|ref|NR_076697.1| 80816 g2228 i0 79.193 117.218670076726 793 141 100 22 1 782 10 789 Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence blastn 91665 529 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum
6748860 6748860 PRJNA278119_P_NODE_23006_length_206_cov_1.324841_g22757_i0 PRJNA278119 23006 206 1.324841 2.72917246 Minicystis rosea 888845 Bacteria Bacteria 195 2.83e-45   NTclustered gi|1127353251|gb|CP016211.1| 888845 g22757 i0 86.022 36.5533980582524 186 21 89 5 13 195 7473510 7473693 Minicystis rosea strain DSM 24000 chromosome, complete genome blastn 7530 195 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis rosea
11849694 11849694 PRJNA278119_P_NODE_16230_length_263_cov_1.457944_g15981_i0 PRJNA278119 16230 263 1.457944 3.83439272 Nannocystis sp. 1962667 Bacteria Bacteria 283 7.819999999999999e-72   NTclustered gi|1386873111|gb|MF774778.1| 1962667 g15981 i0 89.64 143.072243346008 222 23 84 0 42 263 440 661 Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence blastn 37628 283 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis sp.
22047722 22047722 PRJNA278119_P_NODE_25438_length_196_cov_1.061224_g25189_i0 PRJNA278119 25438 196 1.061224 2.07999904 Pendulispora brunnea 2905690 Bacteria Bacteria 87.9 4.65e-13   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g25189 i0 83.333 0.969387755102041 96 14 48 2 71 165 12710780 12710874 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 190 87.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
24597371 24597371 PRJNA278119_P_NODE_27680_length_188_cov_1.122302_g27431_i0 PRJNA278119 27680 188 1.122302 2.10992776 Corallococcus sp. EGB 1521117 Bacteria Bacteria 148 2e-31   NTclustered gi|2094564806|gb|CP079946.1| 1521117 g27431 i0 93.069 4.02659574468085 101 7 54 0 88 188 3510007 3509907 Corallococcus sp. EGB chromosome, complete genome blastn 757 148 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus sp. EGB
24597430 24597430 PRJNA278119_P_NODE_31460_length_177_cov_1.210938_g31211_i0 PRJNA278119 31460 177 1.210938 2.14336026 Vulgatibacter incomptus 1391653 Bacteria Bacteria 117 5.23e-22   NTclustered gi|913607065|gb|CP012332.1| 1391653 g31211 i0 81.507 34.6214689265537 146 23 81 4 1 144 2731936 2731793 Vulgatibacter incomptus strain DSM 27710, complete genome blastn 6128 117 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Vulgatibacteraceae Vulgatibacter Vulgatibacter incomptus

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