RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA494251 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
1106784 1106784 PRJNA494251_P_NODE_37581_length_251_cov_0.865169_g37267_i0 PRJNA494251 37581 251 0.865169 2.17157419 root 1 Root_unresolved Root_unresolved 73.2 9.55e-14   NR HKZ62992.1 1906666 g37267 i0 64.3 2.71314741035857 56 20 66.9 0 2 169 19 74 HKZ62992.1 DUF5655 domain-containing protein [Thermoplasmata archaeon] diamond 681 73.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28024578 28024578 PRJNA494251_P_NODE_41085_length_248_cov_0.880000_g40771_i0 PRJNA494251 41085 248 0.88 2.1824 Thermoplasmata archaeon 1906666 Archaea Archaea 78.6 1.46e-15   NR MEM4779004.1 1906666 g40771 i0 47.4 5.6491935483871 78 41 94.4 0 15 248 55 132 MEM4779004.1 ATP-binding cassette domain-containing protein [Thermoplasmata archaeon] diamond 1401 78.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28797630 28797630 PRJNA494251_P_NODE_36127_length_253_cov_1.122222_g35813_i0 PRJNA494251 36127 253 1.122222 2.83922166 Archaea 2157 Archaea Archaea 82.4 7.57e-18   NR RZP10485.1 2163009 g35813 i0 47.5 2.83399209486166 80 40 94.9 1 252 13 56 133 RZP10485.1 MAG: PaaI family thioesterase, partial [Candidatus Poseidoniales archaeon] diamond 717 82.4 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
30108447 30108447 PRJNA494251_P_NODE_16032_length_348_cov_1.116364_g15719_i0 PRJNA494251 16032 348 1.116364 3.88494672 Candidatus Sysuiplasma superficiale 2823368 Archaea Archaea 54.7 8.23e-6   NR MBX8643924.1 2823368 g15719 i0 36.7 0.844827586206897 98 56 83.6 3 304 14 490 582 MBX8643924.1 AAA family ATPase [Candidatus Sysuiplasma superficiale] diamond 294 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Sysuiplasmatales Candidatus Sysuiplasmataceae Candidatus Sysuiplasma Candidatus Sysuiplasma superficiale
30645432 30645432 PRJNA494251_P_NODE_31473_length_267_cov_1.231959_g31159_i0 PRJNA494251 31473 267 1.231959 3.28933053 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 80.1 7.83e-16   NR HII50895.1 2666346 g31159 i0 53.7 3.01123595505618 67 31 75.3 0 216 16 3 69 HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] diamond 804 80.1 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
31229777 31229777 PRJNA494251_P_NODE_5415_length_549_cov_3.508403_g5120_i0 PRJNA494251 5415 549 3.508403 19.26113247 Archaea 2157 Archaea Archaea 49.3 3.64e-4   NR HID25561.1 1906666 g5120 i0 49 1.51366120218579 51 26 27.9 0 37 189 4 54 HID25561.1 50S ribosomal protein P1 [Thermoplasmata archaeon] diamond 831 49.3 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);;