RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA1034995 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27477557 27477557 PRJNA1034995_S_NODE_36163_length_226_cov_7.322404_g36007_i0 PRJNA1034995 36163 226 7.322404 16.54863304 archaeon 1906665 Archaea Archaea 46.6 6.6e-4   NR NCP98113.1 1906665 g36007 i0 33.8 0.86283185840708 65 38 86.3 1 198 4 57 116 NCP98113.1 hypothetical protein [archaeon] diamond 195 46.6 1 Archaea               archaeon
27951235 27951235 PRJNA1034995_S_NODE_31765_length_256_cov_8.563380_g31609_i0 PRJNA1034995 31765 256 8.56338 21.9222528 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 169 8.36e-51   NR HET7242983.1 2169593 g31609 i0 98.7 2.77734375 79 1 92.6 0 19 255 115 193 HET7242983.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 711 169 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28266688 28266688 PRJNA1034995_S_NODE_41306_length_198_cov_10.961290_g41150_i0 PRJNA1034995 41306 198 10.96129 21.7033542 archaeon 1906665 Archaea Archaea 62 1.91e-9   NR NCQ52251.1 1906665 g41150 i0 50 0.939393939393939 62 30 93.9 1 3 188 144 204 NCQ52251.1 hypothetical protein [archaeon] diamond 186 62 1 Archaea               archaeon
28298398 28298398 PRJNA1034995_S_NODE_29926_length_270_cov_7.748899_g29770_i0 PRJNA1034995 29926 270 7.748899 20.9220273 archaeon 1906665 Archaea Archaea 106 1.74e-27   NR NCQ52295.1 1906665 g29770 i0 60.8 0.877777777777778 79 31 87.8 0 33 269 1 79 NCQ52295.1 hypothetical protein [archaeon] diamond 237 106 1 Archaea               archaeon
28740527 28740527 PRJNA1034995_S_NODE_38607_length_212_cov_7.307692_g38451_i0 PRJNA1034995 38607 212 7.307692 15.49230704 archaeon 1906665 Archaea Archaea 52.8 7.02e-6   NR MDP2438891.1 1906665 g38451 i0 52.9 0.721698113207547 51 24 72.2 0 187 35 323 373 MDP2438891.1 hypothetical protein [archaeon] diamond 153 52.8 1 Archaea               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);;