RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA561138" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA561138 · 4 ✖
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
1820759 1820759 PRJNA561138_P_NODE_24742_length_251_cov_0.865169_g24547_i0 PRJNA561138 24742 251 0.865169 2.17157419 Natronomonas halophila 2747817 Archaea Archaea 414 2.52e-111   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g24547 i0 96.414 1 251 9 100 0 1 251 2309370 2309620 Natronomonas halophila strain C90 chromosome, complete genome blastn 251 414 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
17122843 17122843 PRJNA561138_P_NODE_28014_length_245_cov_0.895349_g27819_i0 PRJNA561138 28014 245 0.895349 2.19360505 Natronomonas halophila 2747817 Archaea Archaea 381 2.4799999999999995e-101   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g27819 i0 94.694 1.13061224489796 245 13 100 0 1 245 1623462 1623706 Natronomonas halophila strain C90 chromosome, complete genome blastn 277 381 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
18396833 18396833 PRJNA561138_P_NODE_11995_length_375_cov_1.019868_g11800_i0 PRJNA561138 11995 375 1.019868 3.824505 Halolamina sp. CBA1230 1853690 Archaea Archaea 577 4.7599999999999984e-160   NTclustered gi|1861365533|gb|CP054589.1| 1853690 g11800 i0 94.4 30.0186666666667 375 21 100 0 1 375 58554 58180 Halolamina sp. CBA1230 plasmid pCBA1230-02, complete sequence blastn 11257 577 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halolamina Halolamina sp. CBA1230
26920894 26920894 PRJNA561138_P_NODE_26502_length_248_cov_0.880000_g26307_i0 PRJNA561138 26502 248 0.88 2.1824 Halomarina halobia 3033386 Archaea Archaea 117 1.28e-29   NR WP_276305823.1 3033386 g26307 i0 70.7 3.96774193548387 82 24 99.2 0 248 3 59 140 WP_276305823.1 hydroxymethylglutaryl-CoA lyase [Halomarina halobia] diamond 984 117 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina halobia

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