RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 2 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA1020854 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
1003526 1003526 PRJNA1020854_S_NODE_7741_length_532_cov_393.558648_g5102_i0 PRJNA1020854 7741 532 393.558648 2093.73200736 Methanobrevibacter 2172 Archaea Archaea 776 0   NTclustered gi|470484903|ref|NR_076674.1| 83816 g5102 i0 95.842 152.934210526316 481 19 90 1 48 527 1045 1525 Methanobrevibacter ruminantium strain M1 23S ribosomal RNA gene, complete sequence blastn 81361 780 0.994871794871795 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
21838039 21838039 PRJNA1020854_S_NODE_42998_length_151_cov_2.500000_g40234_i0 PRJNA1020854 42998 151 2.5 3.775 Methanothrix soehngenii 2223 Archaea Archaea 279 5.19e-71   NTclustered gi|328927127|gb|CP002565.1| 990316 g40234 i0 100 1.47019867549669 151 0 100 0 1 151 553240 553390 Methanosaeta concilii GP-6, complete genome blastn 222 279 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii

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