RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA356682 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
30422776 30422776 PRJNA356682_P_NODE_19773_length_324_cov_2.195219_g19082_i0 PRJNA356682 19773 324 2.195219 7.11250956 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 65.1 1.29e-9   NR MCS6785098.1 2972665 g19082 i0 42.6 0.87037037037037 94 50 86.1 2 316 38 121 211 MCS6785098.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 282 65.1 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
31402253 31402253 PRJNA356682_P_NODE_44996_length_241_cov_0.916667_g44305_i0 PRJNA356682 44996 241 0.916667 2.20916747 uncultured Nitrososphaera sp. 759874 Archaea Archaea 53.1 1.09e-6   NR WP_294807835.1 759874 g44305 i0 100 0.572614107883817 46 0 57.3 0 140 3 68 113 WP_294807835.1 hypothetical protein [uncultured Nitrososphaera sp.] diamond 138 53.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera uncultured Nitrososphaera sp.
31939665 31939665 PRJNA356682_P_NODE_19017_length_330_cov_0.972763_g18326_i0 PRJNA356682 19017 330 0.972763 3.2101179 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 44.3 0.0206   NR MCW3996493.1 2026714 g18326 i0 60 0.363636363636364 40 12 36.4 2 186 67 165 200 MCW3996493.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] diamond 120 44.3 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
32319846 32319846 PRJNA356682_P_NODE_43079_length_243_cov_0.905882_g42388_i0 PRJNA356682 43079 243 0.905882 2.20129326 Nitrososphaera sp. 1971748 Archaea Archaea 113 8.82e-30   NR HEX2014916.1 1971748 g42388 i0 64.6 0.975308641975309 79 28 97.5 0 2 238 62 140 HEX2014916.1 PepSY domain-containing protein [Nitrososphaera sp.] diamond 237 113 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.

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