RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1022139" and tax_phylum = "Nanobdellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nanobdellota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022139 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27003086 27003086 PRJNA1022139_P_NODE_13822_length_366_cov_1.030717_g13717_i0 PRJNA1022139 13822 366 1.030717 3.77242422 Nanoarchaeum equitans Kin4-M 228908 Archaea Archaea 58.2 9.16e-8   NR AAR39227.1 228908 g13717 i0 49.1 0.450819672131148 55 28 45.1 0 3 167 13 67 AAR39227.1 NEQ379 [Nanoarchaeum equitans Kin4-M] diamond 165 58.2 1 Archaea   Nanobdellati Nanobdellota Candidatus Nanoarchaeia Nanoarchaeales Nanoarchaeaceae Nanoarchaeum Nanoarchaeum equitans
31449284 31449284 PRJNA1022139_P_NODE_29276_length_269_cov_2.112245_g29171_i0 PRJNA1022139 29276 269 2.112245 5.68193905 Archaea 2157 Archaea Archaea 99 5e-23   NR MDP3724991.1 2026764 g29171 i0 58.1 2.85501858736059 86 34 95.9 1 262 5 19 102 MDP3724991.1 VIT1/CCC1 transporter family protein [Nanoarchaeota archaeon] diamond 768 99.8 0.991983967935872 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
32374630 32374630 PRJNA1022139_P_NODE_43079_length_241_cov_0.916667_g42974_i0 PRJNA1022139 43079 241 0.916667 2.20916747 Nanobdellota archaeon 2026764 Archaea Archaea 48.1 4.35e-4   NR MDP2926151.1 2026764 g42974 i0 47.4 1.89211618257261 76 33 94.6 1 229 2 22 90 MDP2926151.1 deoxyhypusine synthase [Nanoarchaeota archaeon] diamond 456 48.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon

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