RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1204310", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1204310 · 4 ✖

analysis 1

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
25271226 25271226 PRJNA1204310_P_NODE_59320_length_245_cov_0.906977_g59023_i0 PRJNA1204310 59320 245 0.906977 2.22209365 Thermoproteota archaeon 2056631 Archaea Archaea 95.9 5.9400000000000005e-21   NR MEE6246135.1 2056631 g59023 i0 64.2 0.991836734693878 81 26 99.2 1 244 2 201 278 MEE6246135.1 IMP dehydrogenase [Thermoproteota archaeon] diamond 243 95.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
26648128 26648128 PRJNA1204310_P_NODE_63141_length_227_cov_2.532468_g62844_i0 PRJNA1204310 63141 227 2.532468 5.74870236 root 1 Root_unresolved Root_unresolved 99.8 1.9e-22   NR WP_011752483.1 2269 g62844 i0 62.2 18.5550660792952 74 28 97.8 0 6 227 57 130 WP_011752483.1 proline--tRNA ligase [Thermofilum pendens] diamond 4212 100 0.998 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Thermofilum Thermofilum pendens
26882901 26882901 PRJNA1204310_P_NODE_14341_length_468_cov_1.946835_g14044_i0 PRJNA1204310 14341 468 1.946835 9.1111878 Pyrobaculum calidifontis 181486 Archaea Archaea 62 5.35e-9   NR WP_011850782.1 181486 g14044 i0 30.7 1.67948717948718 127 86 80.8 2 62 439 3 128 WP_011850782.1 universal stress protein [Pyrobaculum calidifontis] diamond 786 62 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum calidifontis
29238922 29238922 PRJNA1204310_P_NODE_28709_length_346_cov_1.428571_g28412_i0 PRJNA1204310 28709 346 1.428571 4.94285566 root 1 Root_unresolved Root_unresolved 103 2.3599999999999998e-23   NR WP_011278960.1 2285 g28412 i0 41.2 2.91329479768786 114 65 98.8 1 5 346 30 141 WP_011278960.1 amidase [Sulfolobus acidocaldarius] diamond 1008 104 0.990384615384615 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius

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