RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA550047 · 5 ✖

analysis 1

  • diamond · 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
26888404 26888404 PRJNA550047_P_NODE_231961_length_301_cov_5.399123_g229992_i0 PRJNA550047 231961 301 5.399123 16.25136023 Thermosphaera sp. 2831947 Archaea Archaea 59.3 1.03e-7   NR MEM4655254.1 2831947 g229992 i0 60 0.996677740863787 50 20 49.8 0 150 299 22 71 MEM4655254.1 flippase [Thermosphaera sp.] diamond 300 59.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Thermosphaera Thermosphaera sp.
28814664 28814664 PRJNA550047_P_NODE_300348_length_297_cov_8.080357_g298379_i0 PRJNA550047 300348 297 8.080357 23.99866029 Pyrobaculum aerophilum 13773 Archaea Archaea 186 3.74e-57   NR WP_116420834.1 13773 g298379 i0 98.9 0.888888888888889 88 1 88.9 0 265 2 60 147 WP_116420834.1 hypothetical protein [Pyrobaculum aerophilum] diamond 264 186 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum aerophilum
29099089 29099089 PRJNA550047_P_NODE_155328_length_345_cov_4.375000_g153368_i0 PRJNA550047 155328 345 4.375 15.09375 Thermoproteota archaeon 2056631 Archaea Archaea 56.6 1.5e-6   NR MCR8454875.1 2056631 g153368 i0 55.3 0.843478260869565 47 21 40.9 0 11 151 234 280 MCR8454875.1 methionine adenosyltransferase [Thermoproteota archaeon] diamond 291 56.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30661495 30661495 PRJNA550047_P_NODE_406693_length_262_cov_10.449735_g404721_i0 PRJNA550047 406693 262 10.449735 27.3783057 Thermoproteati 1783275 Archaea Archaea 97.8 7.03e-24   NR MDQ3974997.1 2056631 g404721 i0 82.1 2.42748091603053 56 10 64.1 0 93 260 1 56 MDQ3974997.1 glycine cleavage system protein GcvH [Thermoproteota archaeon] diamond 636 97.8 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30741585 30741585 PRJNA550047_P_NODE_467454_length_241_cov_12.130952_g465481_i0 PRJNA550047 467454 241 12.130952 29.23559432 Sulfolobus sp. 2288 Archaea Archaea 44.7 0.00642   NR MCI4456318.1 2288 g465481 i0 34.8 0.821576763485477 66 40 78.4 1 224 36 24 89 MCI4456318.1 DNA polymerase sliding clamp [Sulfolobus sp.] diamond 198 44.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp.

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