RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA577580", tax_kingdom = "Thermoproteati" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 3 ✖

tax_kingdom 1

  • Thermoproteati · 3 ✖

bioproject 1

  • PRJNA577580 · 3 ✖

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
11341429 11341429 PRJNA577580_P_NODE_15589_length_245_cov_0.906977_g15511_i0 PRJNA577580 15589 245 0.906977 2.22209365 Candidatus Nitrosotenuis 1825023 Archaea Archaea 448 2.41e-121   NTclustered gi|808354332|gb|CP011097.2| 1603555 g15511 i0 99.592 99.5918367346939 245 1 100 0 1 245 740679 740435 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 24400 448 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
17141678 17141678 PRJNA577580_P_NODE_334_length_1334_cov_14.448850_g302_i0 PRJNA577580 334 1334 14.44885 192.747659 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 69.3 1.78e-8   NR MFL6422328.1 2169593 g302 i0 36.6 0.663418290854573 295 161 62.1 13 1165 338 303 590 MFL6422328.1 M12 family metallopeptidase [Nitrososphaeraceae archaeon] diamond 885 69.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27346201 27346201 PRJNA577580_P_NODE_10083_length_288_cov_3.074419_g10005_i0 PRJNA577580 10083 288 3.074419 8.85432672 root 1 Root_unresolved Root_unresolved 66.6 2.5e-10   NR MFL6422328.1 2169593 g10005 i0 38.9 2.71875 95 55 95.8 2 286 11 504 598 MFL6422328.1 M12 family metallopeptidase [Nitrososphaeraceae archaeon] diamond 783 66.6 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);;