RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA599208", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Altimarinota · 2 ✖

tax_clade 1

  • Bacteria candidate phyla · 2 ✖

bioproject 1

  • PRJNA599208 · 2 ✖

analysis 1

tax_kingdom 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
15169636 15169636 PRJNA599208_P_NODE_11752_length_191_cov_2.772727_g11556_i0 PRJNA599208 11752 191 2.772727 5.29590857 Bacteria 2 Bacteria Bacteria 95.3 2.69e-15   NTclustered gi|1769783243|gb|CP042461.1| 1862133 g11556 i0 82.569 2.60732984293194 109 17 57 2 1 108 1251617 1251724 Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome blastn 498 95.3 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Gracilibacteria bacterium 28_42_T64
22249436 22249436 PRJNA599208_P_NODE_8058_length_254_cov_2.133641_g7862_i0 PRJNA599208 8058 254 2.133641 5.41944814 Candidatus Gracilibacteria bacterium 28_42_T64 1862133 Bacteria Bacteria 183 7.84e-42   NTclustered gi|1769783243|gb|CP042461.1| 1862133 g7862 i0 81.9 61.4448818897638 221 36 86 4 1 219 1250914 1250696 Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome blastn 15607 183 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Gracilibacteria bacterium 28_42_T64

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