RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA849172", tax_phylum = "Thermoplasmatota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 7 ✖

tax_phylum 1

  • Thermoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849172 · 7 ✖

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
15260887 15260887 PRJNA849172_P_NODE_73892_length_265_cov_5.291667_g73532_i0 PRJNA849172 73892 265 5.291667 14.02291755 Candidatus Poseidonia alphae 1915863 Archaea Archaea 66.6 1.81e-10   NR MDA7463480.1 1915863 g73532 i0 59.3 1.87924528301887 54 22 61.1 0 3 164 264 317 MDA7463480.1 AAA family ATPase [Candidatus Poseidonia alphae] diamond 498 66.6 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae Candidatus Poseidonia Candidatus Poseidonia alphae
26865261 26865261 PRJNA849172_P_NODE_149301_length_197_cov_12.169355_g148941_i0 PRJNA849172 149301 197 12.169355 23.97362935 Candidatus Thalassarchaeaceae archaeon 2670411 Archaea Archaea 47 6.59e-4   NR MFL2951121.1 2670411 g148941 i0 43.1 1.52284263959391 51 27 76.1 2 8 157 569 618 MFL2951121.1 S8 family serine peptidase [Candidatus Thalassarchaeaceae archaeon] diamond 300 47 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Thalassarchaeaceae   Candidatus Thalassarchaeaceae archaeon
26896873 26896873 PRJNA849172_P_NODE_87581_length_253_cov_2.216667_g87221_i0 PRJNA849172 87581 253 2.216667 5.60816751 Thermoplasmata archaeon M8B2D 1933278 Archaea Archaea 62.4 4.87e-9   NR PNX50664.1 1933278 g87221 i0 42.2 0.758893280632411 64 37 75.9 0 45 236 521 584 PNX50664.1 MAG: hypothetical protein BV456_05935 [Thermoplasmata archaeon M8B2D] diamond 192 62.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon M8B2D
29360103 29360103 PRJNA849172_P_NODE_100049_length_246_cov_1.907514_g99689_i0 PRJNA849172 100049 246 1.907514 4.69248444 Thermoplasmatota archaeon 2806419 Archaea Archaea 47 0.00125   NR HVL86810.1 2806419 g99689 i0 47.4 1.45121951219512 57 29 69.5 1 16 186 374 429 HVL86810.1 helix-turn-helix domain-containing protein [Thermoplasmatota archaeon] diamond 357 47 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
30623370 30623370 PRJNA849172_P_NODE_31173_length_367_cov_5.061224_g30814_i0 PRJNA849172 31173 367 5.061224 18.57469208 Thermoplasmata archaeon 1906666 Archaea Archaea 66.6 1.19e-10   NR MCI4354872.1 1906666 g30814 i0 60.7 1.00544959128065 61 23 49 1 367 188 130 190 MCI4354872.1 oxidoreductase [Thermoplasmata archaeon] diamond 369 66.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
31137131 31137131 PRJNA849172_P_NODE_94155_length_249_cov_2.789773_g93795_i0 PRJNA849172 94155 249 2.789773 6.94653477 root 1 Root_unresolved Root_unresolved 53.5 6.3e-6   NR UCF08000.1 1906666 g93795 i0 53.8 3.20481927710843 52 21 59 1 188 42 431 482 UCF08000.1 MAG: thrombospondin type 3 repeat-containing protein, partial [Thermoplasmata archaeon] diamond 798 53.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
31382145 31382145 PRJNA849172_P_NODE_148716_length_198_cov_5.688000_g148356_i0 PRJNA849172 148716 198 5.688 11.26224 Thermoplasmatota archaeon 2806419 Archaea Archaea 82.8 1.21e-16   NR HUR61904.1 2806419 g148356 i0 80.4 2.09090909090909 46 9 69.7 0 138 1 9 54 HUR61904.1 ADP-forming succinate--CoA ligase subunit beta [Thermoplasmatota archaeon] diamond 414 82.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota 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);;