RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA977246 · 4 ✖

analysis 1

  • blastn · 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
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
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
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);;