RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB66218", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 5 ✖

tax_kingdom 1

  • Methanobacteriati · 5 ✖

bioproject 1

  • PRJEB66218 · 5 ✖

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
21808484 21808484 PRJEB66218_P_NODE_17178_length_975_cov_4.374179_g15254_i0 PRJEB66218 17178 975 4.374179 42.64824525 Acidiplasma aeolicum 507754 Archaea Archaea 489 1.2299999999999998e-171   NR WP_393917166.1 507754 g15254 i0 80.4 1.88923076923077 306 60 94.2 0 2 919 24 329 WP_393917166.1 NADH-quinone oxidoreductase subunit NuoH [Acidiplasma aeolicum] diamond 1842 489 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Ferroplasmaceae Acidiplasma Acidiplasma aeolicum
26907395 26907395 PRJEB66218_P_NODE_117202_length_279_cov_0.894495_g114773_i0 PRJEB66218 117202 279 0.894495 2.49564105 Thermoplasmata archaeon 1906666 Archaea Archaea 77 7.62e-15   NR HYB63318.1 1906666 g114773 i0 46.7 2.96774193548387 92 33 98.9 2 2 277 22 97 HYB63318.1 adenylate kinase [Thermoplasmata archaeon] diamond 828 77 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28928801 28928801 PRJEB66218_P_NODE_140588_length_250_cov_2.063492_g138159_i0 PRJEB66218 140588 250 2.063492 5.15873 Thermoplasmata archaeon 1906666 Archaea Archaea 73.2 6.06e-14   NR MEA3190336.1 1906666 g138159 i0 49.3 6.612 75 38 90 0 23 247 32 106 MEA3190336.1 deoxyhypusine monooxygenase [Thermoplasmata archaeon] diamond 1653 73.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29458180 29458180 PRJEB66218_P_NODE_196590_length_211_cov_1.733333_g194160_i0 PRJEB66218 196590 211 1.733333 3.65733263 root 1 Root_unresolved Root_unresolved 41.6 0.0283   NR MEF8873836.1 2806419 g194160 i0 35.3 1.56398104265403 51 33 72.5 0 9 161 20 70 MEF8873836.1 tetratricopeptide repeat protein [Thermoplasmatota archaeon] diamond 330 42 0.990476190476191 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
31361321 31361321 PRJEB66218_P_NODE_150976_length_241_cov_1.100000_g148547_i0 PRJEB66218 150976 241 1.1 2.651 Thermoplasmata archaeon 1906666 Archaea Archaea 50.4 6.91e-5   NR HID71581.1 1906666 g148547 i0 56.8 0.921161825726141 37 16 46.1 0 130 240 210 246 HID71581.1 hypothetical protein [Thermoplasmata archaeon] diamond 222 50.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;