RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB75017 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
3961403 3961403 PRJEB75017_P_NODE_10484_length_284_cov_1.369668_g10355_i0 PRJEB75017 10484 284 1.369668 3.88985712 Anaeromyxobacter sp. K 447217 Bacteria Bacteria 58.4 5.64e-4   NTclustered gi|196170270|gb|CP001131.1| 447217 g10355 i0 94.595 0.130281690140845 37 2 13 0 73 109 1698272 1698308 Anaeromyxobacter sp. K, complete genome blastn 37 58.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. K
4823606 4823606 PRJEB75017_P_NODE_12384_length_265_cov_2.437500_g12255_i0 PRJEB75017 12384 265 2.4375 6.459375 Haliangium 162027 Bacteria Bacteria 351 2.13e-92   NTclustered gi|470485361|ref|NR_076697.1| 80816 g12255 i0 90.566 226.407547169811 265 25 100 0 1 265 3003 2739 Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence blastn 59998 351 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum
7787674 7787674 PRJEB75017_P_NODE_10427_length_285_cov_0.759434_g10298_i0 PRJEB75017 10427 285 0.759434 2.1643869 Myxococcus landrumensis 2813577 Bacteria Bacteria 172 1.94e-38   NTclustered gi|1998497960|gb|CP071091.1| 2813577 g10298 i0 78.058 19.059649122807 278 58 96 2 1 275 4000079 3999802 Myxococcus landrumus strain SCHIC003 chromosome blastn 5432 172 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus landrumensis
14163730 14163730 PRJEB75017_P_NODE_13992_length_253_cov_0.866667_g13863_i0 PRJEB75017 13992 253 0.866667 2.19266751 Polyangium aurulentum 2567896 Bacteria Bacteria 60.2 1.37e-4   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g13863 i0 97.222 0.142292490118577 36 0 14 1 22 57 9258624 9258658 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 36 60.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum
19260899 19260899 PRJEB75017_P_NODE_11896_length_270_cov_1.543147_g11767_i0 PRJEB75017 11896 270 1.543147 4.1664969 Myxococcus sp. NMCA1 2996785 Bacteria Bacteria 52.8 0.025   NTclustered gi|2410912425|gb|CP113950.1| 2996785 g11767 i0 100 0.103703703703704 28 0 10 0 41 68 2264627 2264654 Myxococcus sp. NMCA1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp. NMCA1
19260952 19260952 PRJEB75017_P_NODE_18316_length_242_cov_0.923077_g18187_i0 PRJEB75017 18316 242 0.923077 2.23384634 Pendulispora albinea 2741071 Bacteria Bacteria 132 2.7200000000000003e-26   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g18187 i0 90.099 1.2396694214876 101 10 42 0 142 242 2279985 2279885 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 300 132 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
20536246 20536246 PRJEB75017_P_NODE_14477_length_251_cov_3.443820_g14348_i0 PRJEB75017 14477 251 3.44382 8.6439882 Corallococcus exercitus 2316736 Bacteria Bacteria 211 3.55e-50   NTclustered gi|2809270164|gb|CP102577.1| 2316736 g14348 i0 82 98.5896414342629 250 43 99 2 3 251 161380 161132 Corallococcus exercitus strain SDU142 chromosome, complete genome blastn 24746 211 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus exercitus

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