RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA924320 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
899291 899291 PRJNA924320_S_NODE_47021_length_167_cov_0.864407_g46879_i0 PRJNA924320 47021 167 0.864407 1.44355969 Halalkalicoccus jeotgali 413810 Archaea Archaea 134 4.86e-27   NTclustered gi|299123054|gb|CP002062.1| 795797 g46879 i0 90.909 0.994011976047904 99 9 59 0 1 99 1600914 1601012 Halalkalicoccus jeotgali B3, complete genome blastn 166 134 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
6356217 6356217 PRJNA924320_S_NODE_20505_length_229_cov_2.261111_g20363_i0 PRJNA924320 20505 229 2.261111 5.17794419 root 1 Root_unresolved Root_unresolved 52.8 0.02   NTclustered gi|1621075116|gb|CP031311.1| 699433 g20363 i0 100 0.244541484716157 28 0 12 0 202 229 2596409 2596436 Halobellus limi strain CGMCC 1.10331 chromosome, complete genome blastn 56 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobellus Halobellus limi
22576533 22576533 PRJNA924320_S_NODE_6938_length_364_cov_2.422222_g6796_i0 PRJNA924320 6938 364 2.422222 8.81688808 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 52.8 0.035   NTclustered gi|2695672541|gb|CP118754.2| 1452353 g6796 i0 100 0.0769230769230769 28 0 8 0 129 156 141713 141740 Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5

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