RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_clade = "Methanomada group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Methanomada group · 4 ✖

bioproject 1

  • PRJNA814235 · 4 ✖

analysis 1

  • blastn · 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
8469907 8469907 PRJNA814235_P_NODE_191627_length_151_cov_2.877193_g190232_i0 PRJNA814235 191627 151 2.877193 4.34456143 Methanobacterium paludis 868131 Archaea Archaea 102 1.21e-17   NTclustered gi|333824386|gb|CP002772.1| 868131 g190232 i0 89.873 0.52317880794702 79 8 52 0 1 79 1107292 1107214 Methanobacterium paludis strain SWAN1, complete genome blastn 79 102 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium paludis
9744970 9744970 PRJNA814235_P_NODE_189908_length_151_cov_3.052632_g188513_i0 PRJNA814235 189908 151 3.052632 4.60947432 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 110 7.21e-20   NTclustered gi|985614202|gb|CP010834.1| 1609968 g188513 i0 94.366 0.470198675496689 71 4 47 0 81 151 1349112 1349042 Methanobrevibacter sp. YE315, complete genome blastn 71 110 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
11020198 11020198 PRJNA814235_P_NODE_163289_length_164_cov_1.220472_g161894_i0 PRJNA814235 163289 164 1.220472 2.00157408 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 270 3.4699999999999992e-68   NTclustered gi|985614202|gb|CP010834.1| 1609968 g161894 i0 96.341 34.1219512195122 164 6 100 0 1 164 496241 496078 Methanobrevibacter sp. YE315, complete genome blastn 5596 270 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
16117680 16117680 PRJNA814235_P_NODE_103713_length_203_cov_2.283133_g102318_i0 PRJNA814235 103713 203 2.283133 4.63475999 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 97.1 8.06e-16   NTclustered gi|985614202|gb|CP010834.1| 1609968 g102318 i0 95.082 0.300492610837438 61 3 30 0 8 68 485328 485268 Methanobrevibacter sp. YE315, complete genome blastn 61 97.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315

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