RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1047749" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 5 ✖

bioproject 1

  • PRJNA1047749 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
5277813 5277813 PRJNA1047749_P_NODE_26085_length_299_cov_7.469027_g25818_i0 PRJNA1047749 26085 299 7.469027 22.33239073 Halosimplex rarum 3396619 Archaea Archaea 139 2.07e-28   NTclustered gi|2908454640|gb|CP180412.1| 3396619 g25818 i0 84.028 2.67892976588629 144 23 48 0 13 156 1820921 1820778 Halosimplex sp. TS25 chromosome, complete genome blastn 801 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex rarum
20576121 20576121 PRJNA1047749_P_NODE_27617_length_296_cov_2.901345_g27350_i0 PRJNA1047749 27617 296 2.901345 8.5879812 Haloglomus litoreum 3034026 Archaea Archaea 56.5 0.002   NTclustered gi|2463606059|gb|CP119988.1| 3034026 g27350 i0 100 0.101351351351351 30 0 10 0 245 274 1876041 1876012 Haloglomus litoreum strain DT116 chromosome, complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Haloglomus Haloglomus litoreum
23127619 23127619 PRJNA1047749_P_NODE_45719_length_232_cov_2.622642_g45452_i0 PRJNA1047749 45719 232 2.622642 6.08452944 Methanobacterium aridiramus 2584467 Archaea Archaea 424 3.82e-114   NTclustered gi|2523005876|gb|CP040735.1| 2584467 g45452 i0 99.569 133.836206896552 232 1 100 0 1 232 1375805 1375574 Methanobacterium aridiramus strain CWC-01 chromosome, complete genome blastn 31050 424 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium aridiramus
24400995 24400995 PRJNA1047749_P_NODE_23560_length_301_cov_4.986842_g23293_i0 PRJNA1047749 23560 301 4.986842 15.01039442 Pyrobaculum aerophilum 13773 Archaea Archaea 287 7.050000000000001e-73   NTclustered gi|18308975|gb|AE009441.1| 178306 g23293 i0 84.026 4.0797342192691 313 34 99 10 1 297 972783 973095 Pyrobaculum aerophilum str. IM2, complete genome blastn 1228 287 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum aerophilum
24401067 24401067 PRJNA1047749_P_NODE_27260_length_297_cov_3.531250_g26993_i0 PRJNA1047749 27260 297 3.53125 10.4878125 Halovalidus salilacus 3075124 Archaea Archaea 54.7 0.008   NTclustered gi|2581323319|gb|CP134700.1| 3075124 g26993 i0 100 0.191919191919192 29 0 10 0 240 268 3941006 3940978 Halovalidus salilacus strain CCL63 chromosome, complete genome blastn 57 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovalidus Halovalidus salilacus

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