RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA980585", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 7 ✖

tax_kingdom 1

  • Methanobacteriati · 7 ✖

bioproject 1

  • PRJNA980585 · 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
9882605 9882605 PRJNA980585_P_NODE_18908_length_330_cov_1.583658_g18654_i0 PRJNA980585 18908 330 1.583658 5.2260714 Thermoplasmatota archaeon 2806419 Archaea Archaea 149 1.4099999999999999e-40   NR MDD5501850.1 2806419 g18654 i0 67.9 1.98181818181818 109 33 97.3 1 8 328 40 148 MDD5501850.1 phosphoglycerate kinase [Thermoplasmatota archaeon] diamond 654 149 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27089505 27089505 PRJNA980585_P_NODE_55762_length_243_cov_1.664706_g55508_i0 PRJNA980585 55762 243 1.664706 4.04523558 Marine Group III euryarchaeote CG-Epi1 1888995 Archaea Archaea 75.9 6.67e-14   NR OIR16537.1 1888995 g55508 i0 50 4.75308641975309 80 38 98.8 1 241 2 13 90 OIR16537.1 MAG: aspartate aminotransferase [Marine Group III euryarchaeote CG-Epi1] diamond 1155 75.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Thermoprofundales     Marine Group III euryarchaeote CG-Epi1
27948349 27948349 PRJNA980585_P_NODE_53825_length_244_cov_1.801170_g53571_i0 PRJNA980585 53825 244 1.80117 4.3948548 root 1 Root_unresolved Root_unresolved 44.3 0.01   NR MDP8011883.1 1906666 g53571 i0 32.3 1.64754098360656 62 42 76.2 0 243 58 36 97 MDP8011883.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Thermoplasmata archaeon] diamond 402 44.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28163289 28163289 PRJNA980585_P_NODE_10845_length_409_cov_1.827381_g10591_i0 PRJNA980585 10845 409 1.827381 7.47398829 Thermoplasmatota archaeon 2806419 Archaea Archaea 79.3 2.03e-15   NR HLE48058.1 2806419 g10591 i0 43.5 0.623471882640587 85 48 62.3 0 255 1 1 85 HLE48058.1 aquaporin [Thermoplasmatota archaeon] diamond 255 79.3 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29142261 29142261 PRJNA980585_P_NODE_50669_length_246_cov_0.890173_g50415_i0 PRJNA980585 50669 246 0.890173 2.18982558 Thermoplasmatota archaeon 2806419 Archaea Archaea 91.7 2.01e-20   NR MBU0496405.1 2806419 g50415 i0 53.9 0.926829268292683 76 35 92.7 0 246 19 159 234 MBU0496405.1 SOS response-associated peptidase [Thermoplasmatota archaeon] diamond 228 91.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29211446 29211446 PRJNA980585_P_NODE_45369_length_249_cov_0.875000_g45115_i0 PRJNA980585 45369 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 48.5 3.81e-4   NR MED5271849.1 2806419 g45115 i0 38.2 6.79518072289157 55 33 66.3 1 246 82 141 194 MED5271849.1 hypothetical protein [Thermoplasmatota archaeon] diamond 1692 48.5 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
31738833 31738833 PRJNA980585_P_NODE_56757_length_243_cov_0.905882_g56503_i0 PRJNA980585 56757 243 0.905882 2.20129326 root 1 Root_unresolved Root_unresolved 120 3.85e-30   NR HLF06029.1 1906666 g56503 i0 65.8 2.92592592592593 79 27 97.5 0 5 241 290 368 HLF06029.1 nicotinate phosphoribosyltransferase [Thermoplasmata archaeon] diamond 711 120 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);;