RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA473201 · 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
10647413 10647413 PRJNA473201_P_NODE_27989_length_372_cov_3.023411_g27247_i0 PRJNA473201 27989 372 3.023411 11.24708892 Pendulispora albinea 2741071 Bacteria Bacteria 429 1.4e-115   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g27247 i0 87.701 128.610215053763 374 38 99 6 3 372 3589475 3589106 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 47843 429 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
10648452 10648452 PRJNA473201_P_NODE_83869_length_242_cov_0.911243_g83127_i0 PRJNA473201 83869 242 0.911243 2.20520806 Labilithrix luteola 1391654 Bacteria Bacteria 263 9.250000000000001e-66   NTclustered gi|913610804|gb|CP012333.1| 1391654 g83127 i0 86.307 22.1322314049587 241 33 99 0 1 241 2701640 2701880 Labilithrix luteola strain DSM 27648, complete genome blastn 5356 263 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
17021228 17021228 PRJNA473201_P_NODE_44374_length_306_cov_1.321888_g43632_i0 PRJNA473201 44374 306 1.321888 4.04497728 Pendulispora albinea 2741071 Bacteria Bacteria 130 1.28e-25   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g43632 i0 78.947 26.578431372549 209 30 64 9 1 197 2909873 2910079 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 8133 130 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
19569154 19569154 PRJNA473201_P_NODE_1976_length_1374_cov_4.217525_g1662_i0 PRJNA473201 1976 1374 4.217525 57.9487935 Pendulispora rubella 2741070 Bacteria Bacteria 1816 0   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g1662 i0 90.587 148.190684133916 1381 115 100 13 1 1374 9852751 9854123 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 203614 1816 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
23396607 23396607 PRJNA473201_P_NODE_72019_length_248_cov_0.880000_g71277_i0 PRJNA473201 72019 248 0.88 2.1824 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 202 2.0999999999999998e-47   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g71277 i0 81.673 105.254032258065 251 39 100 7 1 248 2161773 2162019 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 26103 202 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis
25321447 25321447 PRJNA473201_P_NODE_68580_length_250_cov_0.870056_g67838_i0 PRJNA473201 68580 250 0.870056 2.17514 Myxococcus 32 Bacteria Bacteria 54.7 0.006   NTclustered gi|2869653495|gb|CP175551.1| 33 g67838 i0 100 0.348 29 0 12 0 200 228 6716181 6716153 Myxococcus fulvus strain KYC1117 chromosome, complete genome blastn 87 54.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus fulvus

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