RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA756891", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 4 ✖

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA756891 · 4 ✖

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
27779618 27779618 PRJNA756891_P_NODE_2404_length_537_cov_1.816810_g2336_i0 PRJNA756891 2404 537 1.81681 9.7562697 Candidatus Sysuiplasma superficiale 2823368 Archaea Archaea 61.2 2.36e-7   NR MBX8644801.1 2823368 g2336 i0 31 0.558659217877095 100 68 55.3 1 240 536 247 346 MBX8644801.1 hypothetical protein [Candidatus Sysuiplasma superficiale] diamond 300 61.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Sysuiplasmatales Candidatus Sysuiplasmataceae Candidatus Sysuiplasma Candidatus Sysuiplasma superficiale
28474177 28474177 PRJNA756891_P_NODE_5486_length_362_cov_2.128028_g5417_i0 PRJNA756891 5486 362 2.128028 7.70346136 Thermoplasmata archaeon 1906666 Archaea Archaea 45.1 0.0166   NR HYB78508.1 1906666 g5417 i0 30.9 0.803867403314917 97 61 75.4 3 89 361 119 215 HYB78508.1 hypothetical protein [Thermoplasmata archaeon] diamond 291 45.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29147366 29147366 PRJNA756891_P_NODE_3429_length_452_cov_1.218997_g3361_i0 PRJNA756891 3429 452 1.218997 5.50986644 root 1 Root_unresolved Root_unresolved 140 6.58e-36   NR MDP6640595.1 2666346 g3361 i0 45.8 6.25884955752212 153 75 99.6 3 451 2 210 357 MDP6640595.1 CTP synthase (glutamine hydrolyzing) [Candidatus Poseidoniaceae archaeon] diamond 2829 141 0.99290780141844 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
31073888 31073888 PRJNA756891_P_NODE_1175_length_743_cov_2.343284_g1112_i0 PRJNA756891 1175 743 2.343284 17.41060012 root 1 Root_unresolved Root_unresolved 47.8 0.00635   NR OYT28433.1 2012525 g1112 i0 27.9 1.70390309555855 104 71 41.2 3 380 685 45 146 OYT28433.1 MAG: hypothetical protein B6U98_05060 [Thermoplasmatales archaeon ex4572_165] diamond 1266 47.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon ex4572_165

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