RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA356682" 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

  • PRJNA356682 · 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
397690 397690 PRJNA356682_P_NODE_31781_length_264_cov_2.691099_g31090_i0 PRJNA356682 31781 264 2.691099 7.10450136 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 483 7.219999999999998e-132   NTclustered gi|985614202|gb|CP010834.1| 1609968 g31090 i0 99.621 149.625 264 1 100 0 1 264 496818 496555 Methanobrevibacter sp. YE315, complete genome blastn 39501 483 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
16975139 16975139 PRJNA356682_P_NODE_36814_length_250_cov_0.870056_g36123_i0 PRJNA356682 36814 250 0.870056 2.17514 Methanobrevibacter ruminantium 83816 Archaea Archaea 381 2.5399999999999996e-101   NTclustered gi|288541968|gb|CP001719.1| 634498 g36123 i0 94.378 25.888 249 13 99 1 2 250 2040570 2040817 Methanobrevibacter ruminantium M1, complete genome blastn 6472 381 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
18249523 18249523 PRJNA356682_P_NODE_43135_length_243_cov_0.905882_g42444_i0 PRJNA356682 43135 243 0.905882 2.20129326 Methanobrevibacter olleyae 294671 Archaea Archaea 327 3.25e-85   NTclustered gi|998157363|gb|CP014265.1| 294671 g42444 i0 91.25 7.32510288065844 240 21 99 0 1 240 302570 302809 Methanobrevibacter olleyae strain YLM1 chromosome, complete genome blastn 1780 327 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter olleyae
22074561 22074561 PRJNA356682_P_NODE_4758_length_650_cov_4.975737_g4085_i0 PRJNA356682 4758 650 4.975737 32.3422905 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 1134 0   NTclustered gi|985614202|gb|CP010834.1| 1609968 g4085 i0 98.157 162.173846153846 651 11 100 1 1 650 495560 496210 Methanobrevibacter sp. YE315, complete genome blastn 105413 1134 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);;