RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA977246 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
3501939 3501939 PRJNA977246_S_NODE_30563_length_223_cov_4.082474_g29571_i0 PRJNA977246 30563 223 4.082474 9.10391702 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 121 5.35e-23   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g29571 i0 89.474 0.426008968609865 95 10 43 0 7 101 58265 58171 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 95 121 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
11154966 11154966 PRJNA977246_S_NODE_36669_length_194_cov_3.000000_g35677_i0 PRJNA977246 36669 194 3 5.82 Salinigranum marinum 1515595 Archaea Archaea 52.8 0.017   NTclustered gi|2270305257|gb|CP100461.1| 1515595 g35677 i0 100 0.144329896907216 28 0 14 0 13 40 1075822 1075849 Salinigranum marinum strain ZS-10 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinigranum Salinigranum marinum
13704826 13704826 PRJNA977246_S_NODE_26771_length_248_cov_4.511416_g25779_i0 PRJNA977246 26771 248 4.511416 11.18831168 uncultured crenarchaeote 29281 Archaea Archaea 335 1.9899999999999996e-87   NTclustered gi|22797874|emb|AJ496176.1| 29281 g25779 i0 93.013 2.7258064516129 229 16 92 0 20 248 6098 6326 Uncultured crenarchaeote 34 kb genomic fragment blastn 676 335 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
16254074 16254074 PRJNA977246_S_NODE_26493_length_250_cov_4.895928_g25501_i0 PRJNA977246 26493 250 4.895928 12.23982 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 368 1.98e-97   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g25501 i0 93.2 1 250 17 100 0 1 250 58061 57812 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 250 368 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
20078005 20078005 PRJNA977246_S_NODE_35916_length_197_cov_4.375000_g34924_i0 PRJNA977246 35916 197 4.375 8.61875 uncultured archaeon 115547 Archaea Archaea 117 5.96e-22   NTclustered gi|1148941144|gb|KY476715.1| 115547 g34924 i0 80.392 2.81725888324873 153 30 78 0 22 174 33270 33422 Uncultured archaeon clone rifcsplowo2_01_scaffold_394_curated blastn 555 117 1 Archaea               uncultured archaeon
25176893 25176893 PRJNA977246_S_NODE_11240_length_451_cov_2191.196682_g10292_i0 PRJNA977246 11240 451 2191.196682 9882.29703582 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 379 1.7600000000000002e-100   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g10292 i0 95.397 12.3259423503326 239 9 53 2 42 278 259 21 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 5559 379 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus

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