RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA752278" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA752278 · 3 ✖

analysis 1

  • diamond · 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
27505307 27505307 PRJNA752278_P_NODE_40343_length_286_cov_2.262911_g40140_i0 PRJNA752278 40343 286 2.262911 6.47192546 Metallosphaera 41980 Archaea Archaea 81.6 8.54e-17   NR WP_404809754.1 41980 g40140 i0 43.2 6.01048951048951 95 52 97.6 1 286 8 63 157 WP_404809754.1 MULTISPECIES: ADP-ribose-binding protein [Metallosphaera] diamond 1719 82.4 0.990291262135922 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Metallosphaera  
31759488 31759488 PRJNA752278_P_NODE_103737_length_241_cov_1.541667_g103534_i0 PRJNA752278 103737 241 1.541667 3.7154174700000002 Thermoproteota archaeon 2056631 Archaea Archaea 159 4.63e-44   NR MDQ5860364.1 2056631 g103534 i0 98.8 5.96265560165975 80 1 99.6 0 2 241 354 433 MDQ5860364.1 acetate--CoA ligase family protein [Thermoproteota archaeon] diamond 1437 159 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32234467 32234467 PRJNA752278_P_NODE_7878_length_496_cov_2.345154_g7675_i0 PRJNA752278 7878 496 2.345154 11.63196384 Thermoprotei archaeon 2250277 Archaea Archaea 55.1 1.38e-5   NR RLG82655.1 2250277 g7675 i0 28.1 1.6875 89 61 53.2 2 487 224 145 231 RLG82655.1 MAG: hypothetical protein DRO40_07150 [Thermoprotei archaeon] diamond 837 55.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei 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);;