RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1227535 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2322373 2322373 PRJNA1227535_P_NODE_4302_length_351_cov_1.122302_g4179_i0 PRJNA1227535 4302 351 1.122302 3.93928002 Halobacteriales 2235 Archaea Archaea 627 4.329999999999999e-175   NTclustered gi|87129019|gb|DQ373058.1| 370968 g4179 i0 98.86 101.849002849003 351 4 100 0 1 351 1290 940 Halalkalicoccus sp. C15 16S ribosomal RNA gene, partial sequence blastn 35749 632 0.992088607594937 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus sp. C15
13088966 13088966 PRJNA1227535_P_NODE_21611_length_253_cov_2.455556_g21487_i0 PRJNA1227535 21611 253 2.455556 6.21255668 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 292 1.24e-74   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g21487 i0 87.903 0.980237154150198 248 30 98 0 2 249 1017478 1017231 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 248 292 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
13088987 13088987 PRJNA1227535_P_NODE_22551_length_252_cov_1.564246_g22427_i0 PRJNA1227535 22551 252 1.564246 3.94189992 Salinibaculum marinum 3131993 Archaea Archaea 159 1.31e-34   NTclustered gi|2700494403|gb|CP147838.1| 3131993 g22427 i0 85.161 1.11507936507937 155 23 62 0 98 252 2634100 2633946 Salinibaculum marinum strain SYNS191 chromosome, complete genome blastn 281 159 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Salinibaculum Salinibaculum marinum
16349509 16349509 PRJNA1227535_P_NODE_30113_length_243_cov_0.917647_g29989_i0 PRJNA1227535 30113 243 0.917647 2.22988221 Halobacteriales 2235 Archaea Archaea 278 3.3200000000000004e-70   NTclustered gi|222451341|gb|CP001365.1| 416348 g29989 i0 87.552 36.6255144032922 241 28 100 2 1 240 597893 598132 Halorubrum lacusprofundi ATCC 49239 chromosome 1, complete sequence blastn 8900 278 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum lacusprofundi
19461310 19461310 PRJNA1227535_P_NODE_23056_length_251_cov_2.882022_g22932_i0 PRJNA1227535 23056 251 2.882022 7.23387522 Nitrosopumilus oxyclinae 1959104 Archaea Archaea 54.7 0.006   NTclustered gi|1869222960|gb|CP026994.1| 1959104 g22932 i0 100 0.115537848605578 29 0 12 0 68 96 933970 933942 Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome blastn 29 54.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus oxyclinae

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