RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA897077" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA897077 · 4 ✖

analysis 1

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
2519806 2519806 PRJNA897077_P_NODE_19162_length_244_cov_0.894737_g19035_i0 PRJNA897077 19162 244 0.894737 2.18315828 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 147 2.67e-40   NR HTY80510.1 3045160 g19035 i0 91.4 0.995901639344262 81 7 99.6 0 1 243 337 417 HTY80510.1 CoA transferase [Candidatus Bathyarchaeia archaeon] diamond 243 147 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
30182020 30182020 PRJNA897077_P_NODE_16912_length_249_cov_0.886364_g16785_i0 PRJNA897077 16912 249 0.886364 2.20704636 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 115 1.3399999999999998e-31   NR HKG30437.1 2169593 g16785 i0 75.6 0.939759036144578 78 18 92.8 1 1 231 15 92 HKG30437.1 FUN14 domain-containing protein [Nitrososphaeraceae archaeon] diamond 234 115 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32332333 32332333 PRJNA897077_P_NODE_19279_length_243_cov_0.917647_g19152_i0 PRJNA897077 19279 243 0.917647 2.22988221 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 153 3.779999999999999e-43   NR HZV96983.1 2109671 g19152 i0 92.6 1 81 6 100 0 243 1 245 325 HZV96983.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] diamond 243 153 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
32522116 32522116 PRJNA897077_P_NODE_16279_length_251_cov_0.870787_g16152_i0 PRJNA897077 16279 251 0.870787 2.18567537 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 144 9.26e-41   NR MDW0278021.1 2169593 g16152 i0 90.4 3.95617529880478 83 8 99.2 0 1 249 69 151 MDW0278021.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 993 144 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;