RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA415856", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Thermoproteota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA415856 · 5 ✖

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
13173068 13173068 PRJNA415856_P_NODE_311_length_1522_cov_3.315682_g241_i0 PRJNA415856 311 1522 3.315682 50.46468004 uncultured crenarchaeote 29281 Archaea Archaea 2206 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g241 i0 92.857 102.687253613666 1526 99 100 8 1 1522 6919 8438 Uncultured crenarchaeote 34 kb genomic fragment blastn 156290 2206 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
18270862 18270862 PRJNA415856_P_NODE_23895_length_185_cov_2.397059_g23634_i0 PRJNA415856 23895 185 2.397059 4.43455915 Sulfolobaceae archaeon 2967306 Archaea Archaea 103 6.3799999999999996e-24   NR MEM0173168.1 2967306 g23634 i0 75 0.972972972972973 60 15 97.3 0 2 181 332 391 MEM0173168.1 hypothetical protein [Sulfolobaceae archaeon] diamond 180 103 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
27739304 27739304 PRJNA415856_P_NODE_21564_length_190_cov_1.219858_g21303_i0 PRJNA415856 21564 190 1.219858 2.3177302 Sulfolobaceae archaeon 2967306 Archaea Archaea 67.4 2.75e-11   NR MEM0174246.1 2967306 g21303 i0 50.8 0.963157894736842 61 30 96.3 0 188 6 110 170 MEM0174246.1 helix-turn-helix domain-containing protein [Sulfolobaceae archaeon] diamond 183 67.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
29538580 29538580 PRJNA415856_P_NODE_24010_length_185_cov_1.500000_g23749_i0 PRJNA415856 24010 185 1.5 2.775 Sulfolobaceae archaeon 2967306 Archaea Archaea 49.3 5.44e-5   NR MEM0173399.1 2967306 g23749 i0 45 0.972972972972973 60 33 97.3 0 180 1 7 66 MEM0173399.1 hypothetical protein [Sulfolobaceae archaeon] diamond 180 49.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
30439936 30439936 PRJNA415856_P_NODE_8993_length_300_cov_1.884462_g8732_i0 PRJNA415856 8993 300 1.884462 5.653386 root 1 Root_unresolved Root_unresolved 85.1 1.87e-17   NR MEK6877666.1 2056631 g8732 i0 75 0.97 48 12 48 0 1 144 220 267 MEK6877666.1 site-specific DNA-methyltransferase [Thermoproteota archaeon] diamond 291 85.9 0.990686845168801 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;