RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB75230", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 4 ✖

tax_kingdom 1

tax_clade 1

  • Methanomada group · 4 ✖

bioproject 1

  • PRJEB75230 · 4 ✖

analysis 1

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
3962206 3962206 PRJEB75230_P_NODE_127244_length_250_cov_0.870056_g127062_i0 PRJEB75230 127244 250 0.870056 2.17514 Methanococcus maripaludis 39152 Archaea Archaea 52.8 0.023   NTclustered gi|132662671|gb|CP000609.1| 402880 g127062 i0 100 0.224 28 0 11 0 188 215 481881 481908 Methanococcus maripaludis C5, complete genome blastn 56 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanococcaceae Methanococcus Methanococcus maripaludis
5238402 5238402 PRJEB75230_P_NODE_112245_length_254_cov_1.977901_g112063_i0 PRJEB75230 112245 254 1.977901 5.02386854 Methanococcus voltae 2188 Archaea Archaea 54.7 0.006   NTclustered gi|2891705001|gb|CP178160.1| 523842 g112063 i0 100 0.114173228346457 29 0 11 0 129 157 475071 475099 Methanococcus voltae PS chromosome, complete genome blastn 29 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanococcaceae Methanococcus Methanococcus voltae
17988837 17988837 PRJEB75230_P_NODE_47275_length_316_cov_1.267490_g47093_i0 PRJEB75230 47275 316 1.26749 4.0052684 uncultured Methanobacteriaceae archaeon 176233 Archaea Archaea 52.8 0.03   NTclustered gi|2874253877|emb|OY969932.1| 176233 g47093 i0 100 0.0886075949367089 28 0 9 0 93 120 1240580 1240553 MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   uncultured Methanobacteriaceae archaeon
24363171 24363171 PRJEB75230_P_NODE_49860_length_312_cov_1.610879_g49678_i0 PRJEB75230 49860 312 1.610879 5.02594248 Methanobrevibacter arboriphilus 39441 Archaea Archaea 54.7 0.008   NTclustered gi|2047640843|dbj|AP019779.1| 39441 g49678 i0 94.286 0.112179487179487 35 2 11 0 3 37 1418270 1418304 Methanobrevibacter arboriphilus SA DNA, complete genome blastn 35 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter arboriphilus

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