RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1073712 · 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
3566749 3566749 PRJNA1073712_P_NODE_11683_length_250_cov_0.870056_g11600_i0 PRJNA1073712 11683 250 0.870056 2.17514 Myxococcaceae 31 Bacteria Bacteria 462 8.83e-126   NTclustered gi|51507364|emb|AJ811622.1| 184914 g11600 i0 100 111.984 250 0 100 0 1 250 30 279 Corallococcus coralloides 16S rRNA gene, strain DSM 52498 blastn 27996 462 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus coralloides
14216330 14216330 PRJNA1073712_P_NODE_7972_length_282_cov_2.655502_g7889_i0 PRJNA1073712 7972 282 2.655502 7.48851564 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 510 3.57e-140   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g7889 i0 99.291 292.379432624113 282 2 100 0 1 282 2163254 2162973 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 82451 510 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis
16764565 16764565 PRJNA1073712_P_NODE_6874_length_297_cov_1.375000_g6791_i0 PRJNA1073712 6874 297 1.375 4.08375 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 527 3.759999999999999e-145   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g6791 i0 98.653 269.612794612795 297 4 100 0 1 297 2160323 2160619 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 80075 527 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis
18039235 18039235 PRJNA1073712_P_NODE_13695_length_246_cov_1.780347_g13612_i0 PRJNA1073712 13695 246 1.780347 4.37965362 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g13612 i0 100 258.686991869919 246 0 100 0 1 246 2161330 2161085 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 63637 455 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis

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